종합설계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