법규위반 db
테이블 (4)
analysis_run
- id — INT — 기본 키 — NOT NULL
- camera_id — BIGINT — 외래 키
- video_name — VARCHAR(128) — NOT NULL
- source_type — VARCHAR(32) — NOT NULL
- source_url (source_uri) — TEXT
- analysis_interval_sec — DOUBLE — NOT NULL
- model_path — VARCHAR(512)
- started_at — TIMESTAMPTZ
- ended_at — TIMESTAMPTZ
camera
- id — INT — 기본 키 — NOT NULL
- name — VARCHAR(256)
- link_id — INT
interval_metric
- id — INT — 기본 키 — NOT NULL
- analysis_run_id — BIGINT — 외래 키 — NOT NULL
- interval_index — INT — NOT NULL
- start_video_sec — DOUBLE — NOT NULL
- end_video_sec — DOUBLE — NOT NULL
- traffic_volume — INT
- speeding_count — INT — NOT NULL
- unsafe_distance_count — INT — NOT NULL
- unsafe_distance_lane_change_count — INT — NOT NULL
- changing_multiple_lanes_count — INT — NOT NULL
violation_event
- id — BIGSERIAL
- analysis_run_id — BIGINT — 외래 키 — NOT NULL
- interval_metric_id — BIGINT — 외래 키
- violation_type — VARCHAR(64) — NOT NULL
- video_sec — DOUBLE
- detail_json — JSONB