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