재난안전
테이블 (10)
disaster_event
- event_id — VARCHAR(30)
- event_name — VARCHAR(200) — NOT NULL
- disaster_type — VARCHAR(100)
- occurred_start — TIMESTAMP
- occurred_end — TIMESTAMP
- damage_amount — NUMERIC(18, 0)
- casualties — INTEGER
- geom — GEOMETRY(Geometry, 5179)
- summary — TEXT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
event_source_evidence
- evidence_id — VARCHAR(30)
- event_id — VARCHAR(30) — 외래 키 → disaster_event.event_id — NOT NULL
- source_id — VARCHAR(30) — 외래 키 → source_catalog.source_id
- evidence_type — VARCHAR(50)
- evidence_text — TEXT
- reported_damage — NUMERIC(18, 0)
- source_date — DATE
risk_area
- risk_area_id — VARCHAR(30)
- area_name — VARCHAR(200) — NOT NULL
- legal_area_type — VARCHAR(100)
- admin_code — VARCHAR(20)
- address — VARCHAR(300)
- managing_agency_code — VARCHAR(50)
- legal_basis — VARCHAR(200)
- designation_date — DATE
- grade — VARCHAR(20)
- geom_type — VARCHAR(20)
- geom — GEOMETRY(Geometry, 5179)
- standard_crs — VARCHAR(20)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
risk_area_event_map
- risk_area_id — VARCHAR(30) — 외래 키 → risk_area.risk_area_id — NOT NULL
- event_id — VARCHAR(30) — 외래 키 → disaster_event.event_id — NOT NULL
- relation_type — VARCHAR(20)
- match_method — VARCHAR(50)
- match_score — NUMERIC(5, 2)
risk_area_history
- history_id — VARCHAR(30)
- risk_area_id — VARCHAR(30) — 외래 키 → risk_area.risk_area_id — NOT NULL
- change_type — VARCHAR(20) — NOT NULL
- change_reason — TEXT
- before_value — TEXT
- after_value — TEXT
- changed_at — DATE
- source_id — VARCHAR(30) — 외래 키 → source_catalog.source_id
risk_area_source_map
- risk_area_id — VARCHAR(30) — 외래 키 → risk_area.risk_area_id — NOT NULL
- source_id — VARCHAR(30) — 외래 키 → source_catalog.source_id — NOT NULL
- source_area_name — VARCHAR(200)
- source_record_id — VARCHAR(100)
- source_page — INTEGER
- source_url — TEXT
- evidence_text — TEXT
risk_area_type_map
- risk_area_id — VARCHAR(30) — 외래 키 → risk_area.risk_area_id — NOT NULL
- risk_type_code — VARCHAR(30) — 외래 키 → risk_type_code.risk_type_code — NOT NULL
- primary_yn — CHAR(1)
- confidence_level — VARCHAR(20)
- source_id — VARCHAR(30) — 외래 키 → source_catalog.source_id
risk_type_code
- risk_type_code — VARCHAR(30)
- risk_type_name — VARCHAR(100) — NOT NULL
- risk_large_class — VARCHAR(100)
- risk_middle_class — VARCHAR(100)
- description — TEXT
- use_yn — CHAR(1)
source_catalog
- source_id — VARCHAR(30)
- source_name — VARCHAR(200) — NOT NULL
- provider_agency — VARCHAR(100)
- source_type — VARCHAR(50)
- data_format — VARCHAR(100)
- update_cycle — VARCHAR(50)
- original_crs — VARCHAR(20)
- collection_method — VARCHAR(100)
- collected_at — TIMESTAMP
- file_name — VARCHAR(300)
- source_url — TEXT
- created_at — TIMESTAMP
weather_observation_link
- obs_id — VARCHAR(30)
- risk_area_id — VARCHAR(30) — 외래 키 → risk_area.risk_area_id — NOT NULL
- observed_at — TIMESTAMP — NOT NULL
- rainfall_1h — NUMERIC(10, 2)
- water_level — NUMERIC(10, 2)
- wind_speed — NUMERIC(10, 2)
- snow_depth — NUMERIC(10, 2)
- source_id — VARCHAR(30) — 외래 키 → source_catalog.source_id