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