cctv_fin_ENG
Tables (3)
CAMERA (Untitled)
- camera_id (UUID) — Primary key — NOT NULL
- location (TEXT)
OBJECT (Untitled3)
- object_id (UUID) — Primary key — NOT NULL
- camera_id (UUID22) — Foreign key → VIDEO.camera_id — NOT NULL
- label (TEXT)
- confidence (FLOAT)
- frame_num (INT)
- bbox (JSONB)
- vector_id (Field)
VIDEO (Untitled2)
- video_id (UUID) — Primary key — NOT NULL
- camera_id (UUID2) — Foreign key → CAMERA.camera_id — NOT NULL
- file_path (TEXT)
- create_at (TIMESTAMP)
- duration (INT)