common
Tables (8)
bike_master
- id — int — Primary key — NOT NULL
- name — varchar(255)
- lat — decimal(10,7)
- lon — decimal(10,7)
- geom — point — NOT NULL
- SPATIAL — KEY
route_master
- route_id — bigint — Primary key — NOT NULL
- route_no — varchar(20) — NOT NULL
route_stop_seq
- route_id — bigint — Primary key — NOT NULL
- seq — int — Primary key — NOT NULL
- stop_id — bigint — NOT NULL
- dist_m — int
station_master
- id — int — Primary key — NOT NULL
- Line — varchar(30) — NOT NULL
- station_name — varchar(60) — NOT NULL
- seq — int
- lon — double — NOT NULL
- lat — double — NOT NULL
- stnCd — varchar(30)
- stnNo — varchar(30)
- stop_id — varchar(40)
- geom — point — NOT NULL
- SPATIAL — KEY
stop_master
- stop_id — bigint — Primary key — NOT NULL
- ars_id — varchar(10) — NOT NULL
- node_id — bigint — NOT NULL
- stop_name — varchar(200) — NOT NULL
- lat — double — NOT NULL
- lon — double — NOT NULL
- geom — point — NOT NULL
- SPATIAL — KEY
subway_edge
- id — bigint — Primary key — NOT NULL
- line — varchar(30) — NOT NULL
- from_station_id — int — NOT NULL
- to_station_id — int — NOT NULL
- train_type — enum('LOCAL','EXPRESS') — NOT NULL
- travel_sec — int — NOT NULL
- from_station_name — varchar(60)
- to_station_name — varchar(60)
- sample_cnt — int
subway_edge_direction
- line — varchar(30) — Primary key — NOT NULL
- from_station_id — int — Primary key — NOT NULL
- to_station_id — int — Primary key — NOT NULL
- train_type — enum('LOCAL','EXPRESS') — Primary key — NOT NULL
- direction_code — varchar(10) — NOT NULL
- direction_name — varchar(10) — NOT NULL
- sample_cnt — int — NOT NULL
subway_edge_time
- id — bigint — Primary key — NOT NULL
- line — varchar(50) — NOT NULL
- wknd_se — varchar(10) — NOT NULL
- updn — varchar(10) — NOT NULL
- branch_key — varchar(50)
- from_stop_id — varchar(64) — NOT NULL
- to_stop_id — varchar(64) — NOT NULL
- avg_run_sec — int — NOT NULL
- sample_cnt — int — NOT NULL