소방 공모전
테이블 (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)