# MySQL prog2 — Table Categorization
# Date: 2026-09-07

## Database Categorization by Table Names

| Database | User/Auth | Product | Order | Stock | Log | Config | Master | Other |
|----------|-----------|---------|-------|-------|-----|--------|--------|-------|
| apps_master | 26 | 43 | 12 | 5 | 3 | 1 | 91 | 68 |
| apps_master_history | 14 | 17 | 8 | 4 | 73 | 0 | 0 | 0 |
| apps_transaction | 9 | 2 | 32 | 1 | 2 | 0 | 0 | 20 |
| pharmanet | 9 | 6 | 9 | 2 | 1 | 0 | 17 | 11 |
| century | 10 | 2 | 6 | 0 | 0 | 0 | 15 | 6 |
| ecommerce | 5 | 18 | 0 | 0 | 3 | 0 | 7 | 47 |
| purchasing | 5 | 18 | 0 | 0 | 3 | 0 | 6 | 41 |

## Sensitive Tables Found

### USER (155 tables)

| Database | Table | Notes |
|----------|-------|-------|
| CenturyMaster | M_AppUser | App users |
| CenturyMaster | M_AppUser_Role | User roles |
| absensi | karyawan | Employees |
| apps_master | customer | Customers |
| apps_master | bridging_member_pelapak | Members |
| pharmanet | m_user | ERP users |

### PASSWORD (9 tables)

| Database | Table | Notes |
|----------|-------|-------|
| apps_master | forgot_password_customer | Password reset |
| apps_master | forgot_password_ha | Password reset HA |
| apps_master | forgot_password_owner | Password reset owner |
| master | password_resets | Password resets |
| sayasehat | forget_password_tb | Password reset |

### CREDENTIAL (11 tables)

| Database | Table | Notes |
|----------|-------|-------|
| hemera | voluspa_login | Login |
| master | voluspa_login | Login |
| pi_vitropic | wpai_aiowps_failed_logins | Failed logins |
| pi_vitropic | wpai_aiowps_login_activity | Login activity |
| u8182940_wpni213 | wpai_aiowps_failed_logins | Failed logins |
| u8182940_wpni213 | wpai_aiowps_login_activity | Login activity |

### TOKEN (8 tables)

| Database | Table | Notes |
|----------|-------|-------|
| CenturyMaster | M_Token | Tokens |
| ecommerce_data | token_shopee_v2 | Shopee tokens |
| sayasehat | akucantik_sessions | Sessions |
| sayasehat | session_login_block_tb | Login blocks |
| sayasehat | session_login_failed_tb | Failed logins |

### EMAIL (12 tables)

| Database | Table | Notes |
|----------|-------|-------|
| apps_master_history | log_edit_outlet_phone_email | Email changes |
| master | email_instant_config | Email config |
| sayasehat | mailbox_tb | Mailbox |
| sayasehat3 | mailbox_tb | Mailbox |

### PHONE (4 tables)

| Database | Table | Notes |
|----------|-------|-------|
| apps_master | mobile | Mobile numbers |
| apps_master | pharmanet_telpoutlet | Outlet phones |
| test | no_telp | Phone numbers |

## Key Findings

| Category | Count | Risk |
|----------|-------|------|
| USER | 155 | HIGH |
| PASSWORD | 9 | CRITICAL |
| CREDENTIAL | 11 | CRITICAL |
| TOKEN | 8 | HIGH |
| EMAIL | 12 | MEDIUM |
| PHONE | 4 | MEDIUM |

## Next Steps

1. **Extract sensitive tables** — password, credential, token
2. **Check for plaintext** — password fields
3. **Map user data** — user → email → phone
4. **Negotiation** — leverage sensitive data