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.