> ## Documentation Index
> Fetch the complete documentation index at: https://docs.aps-store.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Database

Tables created automatically on start, or by `sql/aps_cityhall.sql` (names configurable in `Config.DB`).

| Table | Contents | Auto-created |
| - | - | - |
| `aps_licenses` | Licenses held per player | Yes |
| `aps_license_cooldowns` | Last failed attempt per license | Yes |
| `aps_documents` | Ordered documents with expiry | Yes (+ upgrade) |
| `aps_vehicle_insurance` | Insurance policies per plate | Yes |
| `aps_bills` | Bills, tickets and receipts | Yes |
| `aps_game_scores` | Best score per player and game | Yes (+ upgrade) |
| `aps_businesses` | Business Register entries | Yes (+ upgrade) |
| `aps_gov_log` | Government Portal activity log and security incidents | Yes |
| `aps_mugshots` | Photo per character (documents) | Yes |
| `aps_citizens` | SSN per character (frameworks without one) | Yes |
| `aps_business_permits` | Permit applications and grants | Yes |
| `aps_business_vehicles` | Vehicles registered to businesses | Yes |
| `aps_business_employees` | Business employees | Yes |
| `aps_business_inspections` | Inspection records | Yes |
| `aps_taxes` | Personal taxes | Yes |
| `aps_business_taxes` | Business taxes per account and month | Yes |
| `aps_treasury`, `aps_treasury_log` | City treasury and ledger | Yes |
| `aps_scheduler` | Last period each scheduled job ran | Yes |
| `aps_license_suspensions` | License suspensions | Yes |
| `aps_penalty_points` | Penalty points | Yes |
| `aps_paychecks`, `aps_paycheck_log` | Salaries waiting at City Hall | Yes |
| `aps_resumes`, `aps_resume_settings` | Job applications, hiring open / closed | Yes |
| `owned_vehicles.vin`, `vin_hidden` | VIN columns (Config.VIN) | Yes (added) |

Players are identified by the ESX `identifier` (character-aware on multicharacter servers) or the QBCore / Qbox `citizenid`.


This documentation is built and hosted on [Mintlify](https://mintlify.com), a developer documentation platform.