initial_report
Tables (11)
accident_media
- id — BIGSERIAL — Primary key — NOT NULL
- accident_report_id — BIGINT — Foreign key → accident_reports.id — NOT NULL
- file_path — VARCHAR(500) — NOT NULL
- media_type — VARCHAR(10) — NOT NULL
- mime_type — VARCHAR(50)
- category — VARCHAR(30) — NOT NULL
- investigation_stage — VARCHAR(10)
- sort_order — SMALLINT
- uploaded_at — TIMESTAMPTZ — NOT NULL
accident_report_agencies
- agency_code — VARCHAR(30) — Primary key — NOT NULL
- accident_report_id — BIGINT — Foreign key → accident_reports.id — NOT NULL
accident_report_causes
- cause_code — VARCHAR(20) — Primary key — NOT NULL
- accident_report_id — BIGINT — Foreign key → accident_reports.id — NOT NULL
accident_report_equipments
- accident_report_id — BIGINT — Foreign key → accident_reports.id — NOT NULL
- equipment_id — BIGINT — Foreign key → equipments.id — NOT NULL
accident_report_investigators
- accident_report_id — BIGINT — Foreign key → accident_reports.id — NOT NULL
- investigator_id — BIGINT — Foreign key → investigators.id — NOT NULL
- site_visit_date — DATE
- investigation_method — VARCHAR(20) — NOT NULL
accident_report_patterns
- pattern_code — VARCHAR(20) — Primary key — NOT NULL
- accident_report_id — BIGINT — Foreign key → accident_reports.id — NOT NULL
accident_reports
- id — BIGSERIAL — Primary key — NOT NULL
- accident_datetime — TIMESTAMP — NOT NULL
- weather — VARCHAR(20)
- project_name — VARCHAR(200) — NOT NULL
- site_address — VARCHAR(300)
- construction_start — DATE
- construction_end — DATE
- client_name — VARCHAR(100)
- contractor_name — VARCHAR(100)
- manager_name — VARCHAR(50)
- manager_phone — VARCHAR(30)
- accident_name — VARCHAR(200) — NOT NULL
- accident_severity — VARCHAR(10) — NOT NULL
- cause_summary — TEXT
- human_damage_yn — BOOLEAN — NOT NULL
- human_damage_scale — VARCHAR(100)
- property_damage_yn — BOOLEAN — NOT NULL
- property_damage_scale — VARCHAR(100)
- human_cause_factor — TEXT
- material_cause_factor — TEXT
- environmental_cause_factor — TEXT
- follow_up_status — VARCHAR(20) — NOT NULL
- follow_up_reason — TEXT
- safety_mgmt_plan_required — BOOLEAN
- work_procedure_plan_established — BOOLEAN
- cctv_installed_yn — BOOLEAN — NOT NULL
- video_exists_yn — BOOLEAN — NOT NULL
- narrative — TEXT
- site_findings — TEXT
- equipment_condition — TEXT
- corrective_actions_text — TEXT
- cited_law_text — TEXT
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
equipments
- id — BIGSERIAL — Primary key — NOT NULL
- equipment_name — VARCHAR(50) — NOT NULL
- registration_no — VARCHAR(30)
- vin — VARCHAR(50)
- model_type — VARCHAR(50)
- spec — VARCHAR(50)
- manufacturer — VARCHAR(50)
- country_of_manufacture — VARCHAR(30)
- last_inspection_date — DATE
- inspection_agency — VARCHAR(50)
- first_registration_date — DATE
- first_registration_type — VARCHAR(10)
- structure_modified_yn — BOOLEAN — NOT NULL
investigators
- id — BIGSERIAL — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
opinion_hearings
- id — BIGSERIAL — Primary key — NOT NULL
- accident_report_id — BIGINT — Foreign key → accident_reports.id — NOT NULL
- listener — VARCHAR(50) — NOT NULL
- content — TEXT — NOT NULL
- sort_order — SMALLINT
pilots
- id — BIGSERIAL — Primary key — NOT NULL
- accident_report_id — BIGINT — Foreign key → accident_reports.id — NOT NULL
- age_group — VARCHAR(10)
- experience_years — SMALLINT
- safety_education_completed — BOOLEAN — NOT NULL
- insured_yn — BOOLEAN — NOT NULL
- pilot_type — VARCHAR(10) — NOT NULL