775
Tables (5)
DETECTION
- detection_id — BIGINT
- sensor_id — INT
- device_id — VARCHAR(255)
- timestamp — DATETIME
- signal_strength — FLOAT
MATCHED_TRAVEL
- match_id — BIGINT
- origin_sensor_id — INT
- destination_sensor_id — INT
- device_id — VARCHAR(255)
- start_time — DATETIME
- end_time — DATETIME
- travel_time_seconds — INT
SEGMENT
- segment_id — INT
- origin_sensor_id — INT
- destination_sensor_id — INT
- road_name — VARCHAR(255)
- distance_miles — DECIMAL(6,3)
SENSOR
- sensor_id — INT
- sensor_location — VARCHAR(255)
- road_name — VARCHAR(255)
- latitude — DECIMAL(10,6)
- longitude — DECIMAL(10,6)
- direction — VARCHAR(50)
SUMMARY_INTERVAL
- summary_id — BIGINT
- segment_id — INT
- time_interval_start — DATETIME
- time_interval_end — DATETIME
- avg_travel_time — FLOAT
- avg_speed — FLOAT
- sample_size — INT
- std_dev_travel_time — FLOAT