종설

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