# Analysis: pharmanet.sql

**File size:** 806,382 bytes
**Total tables:** 55
**Tables with secret columns:** 2
**Total INSERT statements:** 43

## All Tables (with row counts)

| # | Table | INSERT count | Secret columns |
|---|-------|--------------|----------------|
| 1 | `attendance_HA` | 1 | - |
| 2 | `bridging_location_user` | 0 | - |
| 3 | `bridging_user_outlet` | 1 | - |
| 4 | `bridging_voucher_customer` | 1 | - |
| 5 | `briging_product_category_special` | 0 | - |
| 6 | `customer_location` | 1 | - |
| 7 | `detail_cart_owner` | 0 | - |
| 8 | `detail_po_owner` | 1 | - |
| 9 | `detail_pre_order_joint_order` | 0 | - |
| 10 | `detail_received_pl_owner` | 1 | - |
| 11 | `detail_transaction_customer` | 1 | - |
| 12 | `detail_transaction_owner` | 1 | - |
| 13 | `disease_mapping` | 1 | - |
| 14 | `header_cart_owner` | 0 | - |
| 15 | `header_po_owner` | 1 | - |
| 16 | `header_pre_order_joint_owner` | 0 | - |
| 17 | `header_received_pl_owner` | 1 | - |
| 18 | `header_transaction_customer` | 1 | - |
| 19 | `header_transaction_owner` | 1 | - |
| 20 | `joint_order_discount` | 0 | - |
| 21 | `m_app` | 1 | - |
| 22 | `m_category_special` | 0 | - |
| 23 | `m_customer` | 1 | CustomerPassword |
| 24 | `m_delivery_service` | 1 | - |
| 25 | `m_delivery_status` | 1 | - |
| 26 | `m_feedback` | 1 | - |
| 27 | `m_generic` | 1 | - |
| 28 | `m_joint_order` | 0 | - |
| 29 | `m_location` | 2 | - |
| 30 | `m_outlet` | 1 | - |
| 31 | `m_outlet_type` | 1 | - |
| 32 | `m_payment_type` | 1 | - |
| 33 | `m_principal` | 1 | - |
| 34 | `m_prod_packing` | 1 | - |
| 35 | `m_product` | 1 | - |
| 36 | `m_rejected_reason` | 1 | - |
| 37 | `m_role` | 1 | - |
| 38 | `m_slider` | 0 | - |
| 39 | `m_status_order` | 1 | - |
| 40 | `m_supplier` | 1 | - |
| 41 | `m_target_category` | 1 | - |
| 42 | `m_track_status` | 1 | - |
| 43 | `m_user` | 1 | UserPassword |
| 44 | `m_voucher` | 1 | - |
| 45 | `order_track_customer` | 1 | - |
| 46 | `order_track_owner` | 1 | - |
| 47 | `outlet_delivery` | 1 | - |
| 48 | `outlet_operational` | 1 | - |
| 49 | `outlet_overstock` | 0 | - |
| 50 | `outlet_product_promo` | 0 | - |
| 51 | `outlet_product_recommendation` | 0 | - |
| 52 | `outlet_stock` | 2 | - |
| 53 | `product_point` | 1 | - |
| 54 | `product_suggestion_owner` | 0 | - |
| 55 | `target_HA` | 1 | - |

## Secret Column Details

### `m_customer`
- Secret columns: CustomerPassword
- INSERT statements: 1
- Sample INSERT data (first 1 rows):

```
INSERT INTO `m_customer` VALUES
```

### `m_user`
- Secret columns: UserPassword
- INSERT statements: 1
- Sample INSERT data (first 1 rows):

```
INSERT INTO `m_user` VALUES
```