v_apparatus: Many-to-One (N:1)
Many work orders link to one apparatus
Referenced through apparatus_id
v_equipment: Many-to-One (N:1)
Many work orders link to one equipment item
Referenced through equipment_id
v_personnel: Many-to-One (N:1)
Many work orders created by one personnel
Referenced through created_by
Column | Type | Description |
id | integer | Primary key |
summary | varchar(255) | Work summary |
description | text | Full description |
client_code | varchar(28) | Organization ID |
apparatus_id | integer | Apparatus reference |
apparatus_name | varchar(40) | Apparatus name |
equipment_id | integer | Equipment reference |
equipment_name | varchar(100) | Equipment name |
fire_station_id | integer | Station reference |
station_num | varchar(64) | Station number |
board_id | integer | Board reference |
board_name | varchar(255) | Board name |
created_at | timestamp | Creation time |
work_order_status | varchar(255) | Status |
work_order_type | varchar(255) | Order type |
created_by | integer | Creator reference |
created_by_name | varchar(255) | Creator name |
is_archived | boolean | Archive status |
parts_cost | numeric | Parts cost |
labor_hours | numeric | Labor hours |
labor_cost | numeric | Labor cost |