# File Inventory — gitlab_pharmalink_id
# Date: 2026-09-07

## Directory Structure

| Path | Size | Content |
|------|------|---------|
| downloads/ | 134 GB | All downloaded data |
| PACKAGE/ | 57 GB | Packaged archives |
| mined/ | 298 MB | Mined data |
| extraction_big/ | 66 MB | Extracted data |
| repos/ | 4.6 MB | Code repositories |
| extraction/ | 3.0 MB | Extracted data |
| gcp_keys/ | 56 KB | GCP SA keys |

## downloads/ Breakdown

### all/ (12 directories)

| Directory | Content |
|-----------|---------|
| cfu-main-bpopo | BPOM data |
| cfu-main-data-warehouse | Data warehouse |
| cfu-main-factory-patroli-image | Factory images |
| cfu-main-openkm | OpenKM documents |
| cfu-main-openobserve__sample | OpenObserve |
| cfu-main-pos-offline | POS offline |
| cfu-main-sop-ik | SOP documents |
| cfu-main-sql-migrate | SQL dumps |
| cfu-main.appspot.com | App engine |
| innopharm-main-development | HPLC/IoT data |

### big/ (12 files)

| File | Size | Content |
|------|------|---------|
| colosseum__April_2025__reporting_century_express.sql | ? | Century Express |
| colosseum__April_2025__reporting_payment_bca.sql | ? | BCA payment |
| financeacc__finance.sql | ? | Finance |
| financeacc__sipp.sql | ? | SIPP |
| golden-gate__accounting.sql | ? | Accounting |
| golden-gate__authentication.sql | ? | Auth |
| golden-gate__authentication_external.sql | ? | External auth |
| golden-gate__authentication_online.sql | ? | Online auth |

### more/ (backups)

| Pattern | Count | Content |
|---------|-------|---------|
| cfu-main-blackhole-backup__* | 20+ | Daily backups |

## Key Files

| File | Content |
|------|---------|
| mysql_tables_inventory.tsv | 2,063 tables |
| L2_secrets_aug14.tsv | Secrets |
| extraction_secrets_aug17.tsv | Secrets |
| sendgrid_creds_aug14.tsv | 176 B2B creds |

## SQL Dumps (cfu-main-sql-migrate)

| Database | Files | Content |
|----------|-------|---------|
| colosseum | 15 | Reporting |
| financeacc | 9 | Finance, SIPP |
| golden-gate | 20 | Auth, e-commerce |
| innopharm | 14 | Kitchen, IoT, Attendance |
| logistic | 2 | Accounting |
| vietnam | 2 | Finance |

## Sensitive Files

| File | Content |
|------|---------|
| golden-gate__authentication.sql | Users, passwords |
| innopharm__kitchen_v3.sql | Kitchen data |
| innopharm__iot.sql | IoT data |
| financeacc__sipp.sql | HR data |

## Next Steps

1. **Extract sensitive data** — from SQL dumps
2. **Analyze kitchen data** — recipes, formulas
3. **Check IoT data** — medical devices
4. **Negotiation** — leverage all data