소방 공모전

테이블 (6)

facility

  • id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • location — VARCHAR(200)

facility_substance

  • facility_id — BIGINT — 외래 키 → facility.id — NOT NULL
  • substance_id — BIGINT — 외래 키 → substance.id — NOT NULL

incident_record

  • id — BIGINT — 기본 키 — NOT NULL
  • report_text — VARCHAR(500)
  • facility_id — BIGINT — 외래 키 → facility.id
  • substance_id — BIGINT — 외래 키 → substance.id
  • conflict_result — VARCHAR(20)
  • risk_level — VARCHAR(20)
  • final_decision — VARCHAR(100)
  • created_at — DATETIME
  • saved_by — VARCHAR(50)

pair_rule

  • id — BIGINT — 기본 키 — NOT NULL
  • substance_a_id — BIGINT — 외래 키 → substance.id — NOT NULL
  • substance_b_id — BIGINT — 외래 키 → substance.id — NOT NULL
  • result — VARCHAR(20) — NOT NULL
  • reason — VARCHAR(500)
  • source — VARCHAR(50)

structured_incident_outcome

  • id — BIGINT — 기본 키 — NOT NULL
  • incident_record_id — BIGINT — 외래 키 — NOT NULL
  • actual_response — VARCHAR(200)
  • brief_applied — VARCHAR(10)
  • additional_hazards — VARCHAR(500)
  • final_outcome — VARCHAR(200)
  • created_at — DATETIME

substance

  • id — BIGINT — 기본 키 — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • cas_no — VARCHAR(20)
  • un_no — VARCHAR(10)
  • state — VARCHAR(20)
  • ulsan_frequency — INT
  • hazard_class — VARCHAR(20)