# **SECTION 9 — Database Schema**

This will include:

- All tables
- Indexes
- Foreign keys
- Seed data
- API token table
- Devices, customers, services
- Towers, jobs, tickets
- Event stream + audit log

**SECTION 9: Database Schema**, the backbone of your entire ISP automation suite.
This is the full SQL schema for all tables used across provisioning, dashboards, APIs, cron jobs, and vendor modules.

Everything is normalized, indexed, and production‑ready.

---

# **📁 SECTION 9 — Database Schema**

Below is the complete SQL schema, organized by functional area:

- Core system tables
- Users + API tokens
- Customers + services
- Devices
- Towers
- Jobs (field tech)
- Tickets
- Event stream
- Audit log

You can run this as a single SQL import.