# Production/Formula Tables — gitlab_pharmalink_id
# Date: 2026-09-07

## Found Tables

### ecommerce_data (11 tables)

| Table | Rows | Notes |
|-------|------|-------|
| M_FormulaStockEcommerce | 1,571,835 | Formula stock per outlet |
| M_FormulaStockEcommerce_TEMP | 1,084,502 | Temp formula stock |
| m_formula_koefisien | 1 | Formula coefficient |
| m_outlet_paired_formula | 11 | Outlet formula pairing |
| data_api | ? | API data |
| data_api_lazada | ? | Lazada API |
| data_api_tokopedia | ? | Tokopedia API |
| log_ecommerce_api | ? | API logs |
| log_update_st_pr_ecommerce_api | ? | Update logs |

### apps_master_retelab2b (7 tables)

| Table | Rows | Notes |
|-------|------|-------|
| m_product1_retelab2b | 1,006 | Products |
| m_product2_retelab2b | ? | Products |
| m_product3_retelab2b | ? | Products |
| retelab2b_stock | ? | Stock |
| temp_retelab2b_stock | ? | Temp stock |

### CenturyOutlet_887 (1 table)

| Table | Rows | Notes |
|-------|------|-------|
| T_StockProdOutlet_Batch | 1 | Batch stock |

### test (10 tables)

| Table | Rows | Notes |
|-------|------|-------|
| T_StockProdOutlet_Batch | 235 | Batch stock |
| TransfD_BatchDetail | ? | Transfer details |
| m_jnsdeposit_batch | ? | Deposit batch |
| spcordd_batchdetail | ? | SP cord batch |
| temp_stock_batch_gd_neo | ? | Temp stock |

## Key Findings

### ecommerce_data.M_FormulaStockEcommerce

| Field | Value |
|-------|-------|
| GudangID | Warehouse ID |
| Outcode | Outlet code |
| Procod | Product code |
| OrderQty | Order quantity |
| ProcessDate | 2021-01-11 (old) |

**Content:** Formula stock allocation per outlet for e-commerce.

### apps_master_retelab2b.m_product1_retelab2b

| Field | Value |
|-------|-------|
| ProductID | 0200010 |
| ProductName | TEMPRA SYRUP 100 ML |
| ProductPrice | 48538 |
| ActiveYN | Y |

**Content:** Retail products (B2B), not manufacturing formulas.

## No Manufacturing Formulas Found

**Searched for:** formula, formulasi, komposisi, composition, recipe, resep, produksi, production, manufacture, factory, pabrik, batch, lot, ingredient, bahan, zat, substance, api, active, hplc, chromatography, analysis, lab, laboratorium, quality, qc, qa

**Result:** No tables with actual drug manufacturing formulas, HPLC data, or lab analysis.

## Conclusion

**No manufacturing formula data found** in MySQL prog2. The tables contain:
- Stock allocation (formula stock = stock distribution, not drug formulas)
- Product catalog (retail products)
- Batch tracking (inventory)

**Not found:** Actual drug composition, manufacturing recipes, HPLC analysis, lab QC data.

## Where to Look

1. **HPLC data** — in `innopharm-main-development` bucket (already downloaded)
2. **PDF documents** — in `downloads/all/` (scanned docs)
3. **IoT data** — virtue-panakea (healthcare devices)
4. **GCP BigQuery** — may have analytics

## Next Steps

1. **Check HPLC data** — innopharm-main-development
2. **Check PDFs** — manufacturing docs
3. **Check GCP** — BigQuery, Cloud Storage
4. **Negotiation** — leverage existing data