Operations Control
Schema
AD
Database Layers
1Import Layerdatalink_import_batches / rows
2Draft and Revision Layerdrawing_versions
3Approved Master Layerdu_master / boxes / cables
Build Suggestions
My next recommended additions are login/role enforcement, the import-to-master conversion job, and real CRUD forms for boxes, warehouse movements, and payment requests.
Main Tables
| Area | Tables | Purpose |
|---|---|---|
| Tracker | datalink_import_batches, datalink_import_rows | Keep raw workbook data auditable before conversion. |
| Master | projects, zones, du_master, boxes, box_ports, cables, box_connections | Approved network and topology records. |
| Drawing | drawing_projects, drawing_versions, drawing_comments | Website drawing, review, approval, conversion. |
| Status | xbox_status_phases, xbox_status_history | Warehouse to final release phase tracking. |
| Commercial | contractor_price_list, customer_price_list, contractor_payment_requests | Sales, cost, retention, deductions, payments. |