ss

Tables (10)

call_traffic_15

  • id (id2) — INT — Foreign key → intersection_name.id — NOT NULL
  • traffic_flow — SMALLINT — NOT NULL
  • que — SMALLINT — NOT NULL
  • direction — TINYINT — NOT NULL
  • lane — TINYINT — NOT NULL
  • call_time — DATETIME — NOT NULL
  • cross_id — INT — NOT NULL

call_traffic_30

  • id (id2) — INT — Foreign key → intersection_name.id — NOT NULL
  • cross_id — INT — NOT NULL
  • t_id — INT — NOT NULL
  • call_time — DATETIME — NOT NULL
  • id (id22) — INT — Foreign key → call_traffic_15.id — NOT NULL

call_traffic_60

  • id (id2) — INT — Foreign key → intersection_name.id — NOT NULL
  • cross_id — INT — NOT NULL
  • t_id — INT — NOT NULL
  • call_time — DATETIME — NOT NULL
  • id (id22) — INT — Foreign key → call_traffic_15.id — NOT NULL

call_traffic_cycle3

  • id (id2) — INT — Foreign key → intersection_name.id — NOT NULL
  • cross_id — INT — NOT NULL
  • traffic_flow — SMALLINT — NOT NULL
  • que — SMALLINt — NOT NULL
  • direction — TINYINT — NOT NULL
  • lane — TINYINT — NOT NULL
  • collect_time — DATETIME — NOT NULL

direction_id

  • id (id2) — INT — Foreign key → intersection_name.id — NOT NULL
  • cross_id — INT — NOT NULL
  • dir_id — INT — NOT NULL
  • turn_id — INT — NOT NULL
  • turn_eid — INT — NOT NULL
  • in_direction — TINYINT — NOT NULL
  • turn_direction — TINYINT — NOT NULL
  • origin_id — INT — NOT NULL
  • origin_eid — INT — NOT NULL
  • destination_id — INT — NOT NULL
  • destination_eid — INT — NOT NULL

intersection_name

  • id — INT — Primary key — NOT NULL
  • name — VARCHAR(64) — NOT NULL

traffic_direction

  • id — INT — Primary key — NOT NULL
  • turn_id — INT — NOT NULL
  • turn_eid — INT — NOT NULL
  • turn_value — INT — NOT NULL

traffic_total_flow

  • id — INT — Primary key — NOT NULL
  • oid — INT — NOT NULL
  • eid — INT — NOT NULL
  • flow — SMALLINT — NOT NULL

trans_direction

  • id (id2) — INT — Foreign key → intersection_name.id — NOT NULL
  • 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

  • id (id2) — INT — Foreign key → intersection_name.id — NOT NULL
  • cross_id — INT — NOT NULL
  • collection_time — DATETIME — NOT NULL
  • inflow_direction — TINYINT — NOT NULL
  • flow — SMALLINT — NOT NULL