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