재난안전

테이블 (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