hackathon

Tables (6)

building

  • building_id — BIGINT — Primary key — NOT NULL
  • address_road — VARCHAR(255)
  • address_jibun — VARCHAR(255)
  • lat — DECIMAL(10,7) — NOT NULL
  • lng — DECIMAL(10,7) — NOT NULL
  • elevation — DECIMAL(6,2)
  • is_semi_basement — BOOLEAN — NOT NULL
  • sido — VARCHAR(20)
  • sigungu — VARCHAR(20)
  • created_at — TIMESTAMP — NOT NULL

drainage_facility

  • facility_id — BIGINT — Primary key — NOT NULL
  • facility_name — VARCHAR(100)
  • facility_type — VARCHAR(30)
  • lat — DECIMAL(10,7) — NOT NULL
  • lng — DECIMAL(10,7) — NOT NULL
  • capacity — DECIMAL(10,2)
  • sigungu — VARCHAR(20)

flood_history

  • history_id — BIGINT — Primary key — NOT NULL
  • lat — DECIMAL(10,7) — NOT NULL
  • lng — DECIMAL(10,7) — NOT NULL
  • occurred_at — DATE
  • rainfall_mm — DECIMAL(6,2)
  • depth_cm — DECIMAL(6,2)
  • sigungu — VARCHAR(20)

risk_factor

  • factor_id — BIGINT — Primary key — NOT NULL
  • score_id — BIGINT — Foreign key → risk_score.score_id — NOT NULL
  • factor_type — VARCHAR(20)
  • contribution — DECIMAL(5,2)
  • description — TEXT

risk_score

  • score_id — BIGINT — Primary key — NOT NULL
  • building_id — BIGINT — Foreign key → building.building_id — NOT NULL
  • total_score — SMALLINT — NOT NULL
  • risk_level — VARCHAR(10)
  • rainfall_scenario — DECIMAL(6,2)
  • summary — TEXT
  • created_at — TIMESTAMP — NOT NULL

shelter

  • shelter_id — BIGINT — Primary key — NOT NULL
  • shelter_name — VARCHAR(100)
  • lat — DECIMAL(10,7) — NOT NULL
  • lng — DECIMAL(10,7) — NOT NULL
  • capacity — INT
  • address — VARCHAR(255)
  • sigungu — VARCHAR(20)