🗄️ Schema & Data Dictionary
Welcome to the Database Schema section. This area contains all the technical details regarding table structures, column definitions, and database logic in PostgreSQL.
📂 In this section:
-
Client, Agreement & Order Schema
Core tables covering clients, agreements, brands, and orders. -
Proforma Drafts Schema
The JSON-based state machine table (tbl_proforma_drafts) for invoice generation. -
Data Dictionary
Centralized definitions for shared database objects.