coach_id (PK)
coach_no
coach_type
shell_id (FK)
status
wheelset_id (PK)
wheel_no
balance_status
last_test_date
coach_id (FK)
shell_id (PK)
shell_no
paint_flag
received_date
current_shop
bogie_id (PK)
bogie_no
bogie_type
assigned_coach_id (FK)
qci_id (PK)
test_type
result
tested_by
test_date
machine_id (PK)
machine_name
shop
last_maint_date
log_id (PK)
machine_id (FK)
maint_date
action
downtime
performed_by
user_id (PK)
username
password_hash
role_id (FK)
email
role_id (PK)
role_name
permissions
by ab
