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)