# Kitchen Data Analysis — innopharm__kitchen_v3.sql
# Date: 2026-09-07

## Database: kitchen

### Tables Found

| Table | Rows | Content |
|-------|------|---------|
| Receiving_D | 6 | Receiving details |
| Receiving_H | 6 | Receiving headers |
| T_PODetail | 9 | Purchase order details |
| T_POHeader | 9 | Purchase order headers |
| T_Stock | 10 | Stock |
| m_city | 514 | Indonesian cities |
| m_dish_type | 3 | Dish types |
| m_recipe_type | 3 | Recipe types |
| th_recipe | 2 | Recipes |

### Key Findings

**m_dish_type:**
- Main Course
- Appetizer
- Dessert

**m_recipe_type:**
- Standard
- Extra
- Pilot

**th_recipe:**
- nasi goreng (Main Course)
- steak (Main Course)

### No Manufacturing Formulas

**No drug formulas found** — only food recipes (nasi goreng, steak).

## IoT Data Analysis — innopharm-main-development

### IoT Files (659)

| Pattern | Count | Content |
|---------|-------|---------|
| IoT__CH* | ~50 | Heart/lung sounds |
| IoT__PNK* | ~600 | Medical device data |
| IoT__Assets__* | 4 | Images |

### Sample IoT Files

| File | Type | Content |
|------|------|---------|
| IoT__CH0001_T0001_Heart_1.wav | Audio | Heart sound |
| IoT__CH0002_T0001_003_002.wav | Audio | Lung sound |
| IoT__PNK1752572134773522-1_PNK1752572134773522_001_001.wav | Audio | Medical data |

### Analysis

**IoT data = medical device recordings** (heart, lung sounds).

**No drug formulas** — medical device data only.

## Conclusion

| Data | Content | Value |
|------|---------|-------|
| kitchen_v3 | Food recipes | LOW |
| IoT | Medical device data | MEDIUM |
| HPLC | Drug analysis | HIGH |

## Next Steps

1. **Extract HPLC data** — 369 PDFs + 501 TXTs
2. **Map products** — product → batch → analysis
3. **Negotiation** — leverage manufacturing data