Database Design (FULL)
This page is the main source for database design. Diagrams are split per domain to prevent broken/too dense rendering.
- Fast visual viewer: /docs/database-viewer
- Full column catalog: /docs/database-full-catalog
1) Context Map Between Domains
2) Domain Details: Procurement
3) Domain Details: Payment PO
4) Domain Details: SPK
Domain Summary
| Domains | Main table | Notes |
|---|---|---|
| Projects | projects, pivot_project_spvs, pivot_project_logistic_admins | project owner + personnel relations |
| Procurement | spbs, items, pre_orders, po_items, suppliers | flow requests → PO |
| Payment PO | payments, payment_terms, payment_splits, payment_split_price_change_requests, taxes | approval, split, nominal change |
| SPK | spks, spk_payments, spk_payment_accountings, spk_payment_receipts | SPK contract lifecycle |
Validity & Limitations
- The summary above is based on reading the migration file in the source repo.
- To confirm final production (including existing data), you still need to check the live DB schema.
- Some old relationship details still verification required if not forced by FK in the initial migration.