종합설계2

테이블 (3)

analysis_results

  • id (Key) — BIGINT — 기본 키 — NOT NULL
  • event_type (Field) — VARCHAR(50)
  • score (Field2) — VARCHAR(50)
  • detected_at (Field3) — DATETIME
  • imgae_url (Field4) — VARCHAR(255)
  • description (Field5) — VARCHAR(500)
  • created_at (Field6) — DATETIME
  • updated_at (Field7) — DATETIME
  • camera_id (Key3) — BIGINT — 외래 키 → cameras.camera_id — NOT NULL

cameras

  • camera_id (Key) — BIGINT — 기본 키 — NOT NULL
  • name (Field3) — VARCHAR(100)
  • location (Field4) — VARCHAR(100)
  • stream_key (Field5) — VARCHAR(100)
  • description (Field6) — VARCHAR(255)
  • status (Field7) — VARCHAR(20)
  • active (Field8) — BOOLEAN
  • created_at (Field9) — DATETIME
  • updated_at (Field10) — DATETIME

stream_sessions

  • id (Key) — BIGINT — 기본 키 — NOT NULL
  • status (Field) — VARCHAR(20)
  • hls_url (Field2) — VARCHAR(255)
  • started_at (Field3) — DATETIME
  • stopped_at (Field4) — DATETIME
  • created_at (Field5) — DATETIME
  • updated_at (Field6) — DATETIME
  • camera_id (Key3) — BIGINT — 외래 키 → cameras.camera_id — NOT NULL