법규위반 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