AD
Central Database Principle
Technical Office is the single source of truth. Drawings are outputs generated from approved database records, not the master data source.
1No duplicate data entryOne ID
2Customer design is reference only after redesignReference
3Zone, X-BOX, Hub/FAT, cable, ports, and items are database recordsMaster
4Warehouse, work orders, QA/QC, as-built, and finance read from the same recordsIntegrated
Project Workflow State
FTTH-QODN - FTTH QODN Rollout
Current phase
Not started
not_started
FTTH ERP Workflow Architecture
Fourteen phases connected through one central database.
| Phase | Workflow | Objective | Module | Central Database Scope |
|---|---|---|---|---|
| 1 | Customer Design | Receive customer drawings, import BOQ, create project. | tracker-import | projects, attachments, datalink_import_batches |
| 2 | Site Survey | Record actual routes, lengths, GPS, obstacles, and photos. | xbox-status | site_survey_records, attachments |
| 3 | Technical Office Redesign | Technical office creates the official execution design. Customer design becomes reference only. | drawing-editor | drawing_projects, drawing_versions |
| 4 | Database Generation | Generate unique records for Zone, X-BOX, HUB/FAT, cable segment, ports, and items. | master-data | zones, xbox_master, hub_master, boxes, cables |
| 5 | Internal Approval | Approve the execution design and freeze the working database version. | schema | approval_workflow, drawing_versions |
| 6 | Material Planning | Automatically generate BOQ, material request, reservation plan, and schedule. | warehouse | drawing_material_plan, items |
| 7 | Warehouse Release | Reserve and release stock, or trigger purchase request for shortages. | warehouse | warehouse_transactions, warehouse_transaction_lines |
| 8 | Work Order | Assign contractor, material package, planned dates, and scope. | payments | contractor_work_orders |
| 9 | Execution Updates | Daily site updates with GPS, photos, installed quantities, and consumption. | xbox-status | xbox_status_history, attachments |
| 10 | QA/QC Inspection | Inspect installation quality, ports, route, test results, and issues. | xbox-status | power_test_results, approval_workflow |
| 11 | As-Built Revision | Generate final as-built, revision history, and old/new meter comparison. | drawing-editor | drawing_versions, drawing_cable_master_links |
| 12 | Warehouse Reconciliation | Compare released versus installed/returned materials and close variance. | warehouse | drawing_material_plan, warehouse_transactions |
| 13 | Customer Acceptance | Submit final documents, acceptance evidence, and customer sign-off. | reports | attachments, approval_workflow |
| 14 | Finance and Project Closing | Contractor payment, customer invoice, profit/cost, and final project closure. | payments | contractor_payment_requests, customer_price_list |
Data Ownership Map
| Owner | Writes | Readers |
|---|---|---|
| Technical Office | projects, zones, xbox_master, hub_master, boxes, cables, drawing_versions | All modules |
| Survey Team | site_survey_records, GPS, photos, actual route evidence | Technical Office, QA/QC |
| Warehouse | warehouse_transactions, material reservations, releases, returns | Work Orders, Finance, Reconciliation |
| Execution / Contractor | xbox_status_history, daily progress, consumption, photos | QA/QC, As-built, Finance |
| Finance | contractor_payment_requests, customer invoice, cost/profit status | Project Closing |