자율주행_수정

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