# Archive Deep Scan — Final Results
# Date: 2026-09-22

## 11 archives extracted and scanned (total ~12 GB SQL)

### NEW CREDENTIALS FOUND

#### 1. Koinworks API (Buy Now Pay Later)
- **X-Koinworks-Token**: 5V13YW0H1YT6TLBTPZ7MBPI72GN4GBNLCP3LKV5XM5ZTM4FKU867RPDC5QSP88C
- **X-Koinworks-Signature**: b74279b39c8fd864aeb31faabbddaba515bf33cc019868b08e439a1216cdabd3
- **API URL**: https://open-api.koinworks.com/v1/koinbnpl/limits
- **Internal sync**: http://149.129.244.216/user_sync
- **Date**: 2022-09-08 (may be expired)

#### 2. Koinworks Bearer JWT tokens
- Multiple JWT tokens in log_loan_confirm (base64 encoded)
- Format: Bearer eyJhbGciOiJIUzI1NiIsInR5cCI6IkpX...

#### 3. New internal IP: 149.129.244.216
- user_sync endpoint
- Not accessible from our IP (timeout)

### Archive contents summary

| Archive | Size | Tables | Findings |
|---------|------|--------|----------|
| financeacc__finance | 722 MB | M_AreaCenter, T_Mutasi_PPN, fp_faktur_pajak, h_item_supplier | Finance/tax data, NPWP |
| tokopedia_integra | 380 MB | download_price_ecommerce | Tokopedia pricing |
| reporting_crawling | 219 MB | Log_Request_Pickup_Order_Shopee | 1M MD5 hashes (order IDs), Shopee pickup logs |
| logistic__delivery-order | 1.2 GB | TD_PackingList, TD_SaleProd, TH_TrfProd | Delivery data |
| payment_koinworks | 446 MB | log_loan_confirm, log_otp_validation, log_req_new_limit | **KOINWORKS API KEY + JWT!** |
| golden_gate__report_mile_app | 5.1 GB | M_Hub_MileApp, bridge_logbook_task_mileapp | GPS tracking, employee visit logs |
| golden_gate__shopee_bqf | 2.1 GB | (not fully scanned) | Shopee BQF data |
| golden_gate_accounting | 408 MB | excel_accounting, tokopedia_mutasi, tokopedia_payment | Accounting + Tokopedia payments |
| golden_gate_accounting_internal | 863 MB | jurnal_detail, jurnal_header, tokopedia_mutasi1 | Internal accounting |
| great_wall_export | 331 MB | MASTER_KARYAWAN, MST_SKEMA, MST_SUBAREA_TEAMWFH | HR data, WFH scheduling |
| consultation_chat | 443 MB | ConsultationCustomerProfile, AbandonedChatSummary, DetailConsultationChat | **MEDICAL PII** — names, phones, addresses, medical conditions |

### PII Summary from consultation_chat
- ConsultationCustomerProfile: 36 records (name, phone, DOB, gender, address, height, weight, medical condition, medication)
- AbandonedChatSummary: 18,209 records (phone numbers, names)
- DetailConsultationChat: chat messages with medical advice
- Phone numbers: 628xxx (Indonesian mobile)
- Sample: "Abdi Premana, 6285977300283, 1984-06-13, Pria, Jl. Hiu 3 blok B no 2 Mampang Indah Depok, 160cm 78kg, Asma, Seretide Discus"

### No new bcrypt/SHA-512/passwords found in any archive
### No new MySQL connection strings
### No new GitLab tokens
### No new Firebase keys