AutoSafer ERD
Tables (6)
control_actions
- id — INT — Primary key — NOT NULL
- simulation_id — INT — Foreign key → simulation_runs.id — NOT NULL
- edge_id — VARCHAR(100) — NOT NULL
- action_type — VARCHAR(50) — NOT NULL
- requires_approval — BOOLEAN
- status — VARCHAR(20)
- approved_by — VARCHAR(100)
- approved_at — DATETIME
- executed_at — DATETIME
- created_at — DATETIME
edge_density_snapshots
- id — BIGINT — Primary key — NOT NULL
- simulation_id — INT — Foreign key → simulation_runs.id — NOT NULL
- edge_id — VARCHAR(100) — NOT NULL
- time_step — INT
- density — FLOAT
- risk_level — VARCHAR(20)
- INDEX — idx_sim_edge
pedestrian_tracks
- id — BIGINT — Primary key — NOT NULL
- video_id — INT — Foreign key → videos.id — NOT NULL
- frame — INT — NOT NULL
- timestamp_sec — FLOAT
- total_bboxes_count — INT
- active_pedestrians_count — INT
- track_id — INT — NOT NULL
- state — VARCHAR(20)
- x1 — FLOAT
- y1 — FLOAT
- x2 — FLOAT
- y2 — FLOAT
- cx — FLOAT
- cy — FLOAT
- speed_px_s — FLOAT
- heading_deg — FLOAT
- density_val — FLOAT
- INDEX — idx_video_frame
- INDEX — idx_track
simulation_runs
- id — INT — Primary key — NOT NULL
- started_at — DATETIME — NOT NULL
- horizon_min — INT
- status — VARCHAR(20)
- created_at — DATETIME
videos
- id — INT — Primary key — NOT NULL
- video_name — VARCHAR(255) — NOT NULL
- dataset_name — VARCHAR(100)
- site — VARCHAR(100)
- cam_id — VARCHAR(50)
- date — DATE
- time — TIME
- weekday — VARCHAR(10)
- weather — VARCHAR(50)
- inout — VARCHAR(10)
window_risk
- id — INT — Primary key — NOT NULL
- video_id — INT — Foreign key → videos.id — NOT NULL
- start_frame — INT — NOT NULL
- end_frame — INT — NOT NULL
- avg_risk — FLOAT
- max_risk — FLOAT
- pred_density — FLOAT
- created_at — DATETIME
- INDEX — idx_video_window