자율주행_수정
테이블 (7)
call_traffic_15min
- TOD_DT (collect_time) — DATETIME — NOT NULL
- cross_name (cross_id) — INT — NOT NULL
- frome_name (from_id) — INT — NOT NULL
- direction (direction_id) — INT — NOT NULL
- car_type (type) — INT — NOT NULL
- lane — INT — NOT NULL
- traffic_flow — INT
- traffic_speed — INT
- max_flow — INT
- time — DATETIME
direction_id
- cross_id — INT — NOT NULL
- dir_id — INT — NOT NULL
- turn_id — INT — NOT NULL
- in_direction — TINYINT — NOT NULL
- turn_direction — TINYINT — NOT NULL
- origin_id — INT — NOT NULL
- destination_id — INT — NOT NULL
id_map
- cross_name — VARCHAR — NOT NULL
- from_name — VARCHAR — NOT NULL
- direction — VARCHAR — NOT NULL
- lane — TINYINT
- inflowDirection — VARCHAR
- turnDirection — VARCHAR
- nodeid — TINYINT
trans_direction
- cross_id — INT — NOT NULL
- collection_time — DATETIME — NOT NULL
- inflow_direction — TINYINT — NOT NULL
- turn_direction — TINYINT — NOT NULL
- lane — TINYINT — NOT NULL
- flow — SMALLINT — NOT NULL
trans_direction_hide
- cross_id — INT — NOT NULL
- collection_time — DATETIME — NOT NULL
- inflow_direction — TINYINT — NOT NULL
- turn_direction — TINYINT — NOT NULL
- lane — TINYINT — NOT NULL
- flow — SMALLINT — NOT NULL
trans_traffic
- Date — DATETIME — NOT NULL
- Hour — DATETIME — NOT NULL
- Min — DATETIME — NOT NULL
- NodeID — INT — NOT NULL
- InFlowDirction (InFlowDirection) — VARCHAR(4)
- TurnDirection — VARCHAR(4)
- car_type — VARCHAR(4)
- lane_number (lane) — INT
- traffic_flow — INT
- que_length — INT
trans_traffic_hide (ftrans_traffic_hide)
- Date — DATETIME — NOT NULL
- Hour — DATETIME — NOT NULL
- Min — DATETIME — NOT NULL
- NodeID — INT — NOT NULL
- InFlowDirction (InFlowDirection) — VARCHAR(4)
- TurnDirection — VARCHAR(4)
- car_type — VARCHAR(4)
- lane_number (lane) — INT
- traffic_flow — INT
- que_length — INT