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)