종설
테이블 (4)
grid_info
- grid_id — INT
- geom — GEOMETRY(Polygon, 4326)
- elevation — FLOAT
- slope — FLOAT
- impervious_rate — FLOAT
- static_risk_score — FLOAT
realtime_risk
- log_id — SERIAL
- grid_id — INT — 외래 키 → grid_info.grid_id — NOT NULL
- rainfall — FLOAT
- sewage_level — FLOAT
- final_risk_score — FLOAT
- created_at — TIMESTAMP
route_history
- route_id — SERIAL
- user_id — VARCHAR(255) — 외래 키 → user.user_id — NOT NULL
- start_geom — GEOMETRY(Point, 4326)
- end_geom — GEOMETRY(Point, 4326)
- is_rerouted — BOOLEAN
- created_at — TIMESTAMP
user
- user_id — VARCHAR(255)
- fcm_token — VARCHAR(255)
- current_lat — FLOAT
- current_lng — FLOAT
- updated_at — TIMESTAMP