asdf

Tables (5)

its_traffic_data

  • tm — TIMESTAMP
  • link_id — VARCHAR(10)
  • road_authority — INTEGER
  • speed — NUMERIC(5,1)
  • travel_time — INTEGER

kma_weather_data

  • nx — INTEGER
  • ny — INTEGER
  • tm — TIMESTAMP
  • pty — NUMERIC(5,1)
  • rn1 — NUMERIC(5,1)
  • updated_at — TIMESTAMP — NOT NULL

link_grid_mapping

  • link_id — VARCHAR(10)
  • nx — INTEGER
  • ny — INTEGER

location_master

  • location_id — VARCHAR(50)
  • type — location_type — NOT NULL
  • name — VARCHAR(100) — NOT NULL
  • point_info — geometry(POINT, 4326)
  • line_info — geometry(LINESTRING, 4326)
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL

traffic_predictions

  • link_id — VARCHAR(10)
  • tm — TIMESTAMP
  • prediction_5min — NUMERIC(5,1) — NOT NULL
  • prediction_10min — NUMERIC(5,1) — NOT NULL
  • prediction_15min — NUMERIC(5,1) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL