4
DU
Demo userProduction planner
Data browser
Every table in the database, how they connect, and a CSV export of each.
Tables
14
in the relational model
Rows
785
across all tables
Relationships
22
foreign keys linking tables
| Table | What it holds | Rows | Fields | Links to | Last change | |
|---|---|---|---|---|---|---|
| Bom Lines | Bill of materials: which item is made from how many of which other items | 80 | 7 | ProductProduct | 09 Oct 2026 11:50 | |
| Customer Orders | Customer orders with order and ship dates | 44 | 8 | – | 09 Oct 2026 14:00 | |
| Customer Order Lines | Products and quantities on each customer order | 84 | 7 | CustomerOrderProductWorkOrder | 09 Oct 2026 11:50 | |
| Defects | Recorded defects and scrap with the part, the build and the cost | 45 | 12 | ProductProductWorkOrderUnitProductionTechnician | 07 Oct 2026 16:35 | |
| Events | Append-only audit trail of everything that happens to a work order | 165 | 7 | WorkOrderUnit | 09 Oct 2026 11:30 | |
| Machines | Machinery and its availability | 10 | 8 | – | 09 Oct 2026 11:50 | |
| Products | Finished products, sub-assemblies and components (one catalogue table) | 59 | 15 | – | 09 Oct 2026 11:50 | |
| Production Technicians | People who build and test products | 3 | 4 | – | 09 Oct 2026 11:50 | |
| Routing Steps | Manufacturing operations per product, with the machine each needs | 42 | 8 | ProductMachine | 09 Oct 2026 11:50 | |
| Test Reports | Completed test procedures for built units | 6 | 15 | ProductUnitProductionTechnician | 08 Oct 2026 10:35 | |
| Test Steps | Individual steps and results within each test report | 84 | 9 | TestReport | – | |
| Units | Individual serialised units built under work orders | 107 | 8 | WorkOrder | 09 Oct 2026 11:50 | |
| Work Orders | Production jobs, from entry to completion | 51 | 13 | ProductWorkstationProductionTechnician | 09 Oct 2026 20:00 | |
| Workstations | Work areas on the shop floor | 5 | 4 | – | 09 Oct 2026 11:50 |