ERD

Tables (8)

Admin (admin)

  • ID (id) — int — Primary key — NOT NULL
  • Name/Username (username) — str
  • Email (email) — email
  • Password Hash (password) — str
  • Creation Time (created_at) — dz
  • Role (role) — str
  • Active (is_active) — bool
  • Login Time (last_login_at) — dz
  • Update Time (updated_at) — dz

Alarm Messages (alarm)

  • Alarm ID (id) — int — Primary key — NOT NULL
  • Detection ID (detection_id) — int — Foreign key → Detections.Detection ID — NOT NULL
  • Event ID (event id) — int — Foreign key → Detections.Event ID — NOT NULL
  • CCTV ID (cctv_id) — int — Foreign key → Detections.CCTV ID — NOT NULL
  • Messasge (Alarm_message) — str
  • Alarm Decision (alarm_trigger) — int
  • Time (alarm_time) — tz

Camera (camera)

  • CCTV ID (cctv_id) — int — Primary key — NOT NULL
  • CCTV Name (camera_name) — str
  • Channel (channel) — int
  • Stream Url (stream_url) — str
  • Address (ip_address) — int
  • Location (zone) — str
  • Resolution (resolution) — int
  • FPS (fps) — int
  • Enabled (is_enabled) — str
  • Alive (last_hearbeat) — str
  • Created (created_at) — dz
  • Updated (updated_at) — tz

Detections (detections)

  • Detection ID (detection_id) — int — Primary key — NOT NULL
  • Event ID (event id) — int — Foreign key → Events.Event ID — NOT NULL
  • CCTV ID (cctv_id) — type — Foreign key → Events.CCTV ID — NOT NULL
  • Confidence Score (score) — int
  • Bounding Boxes (boudning_box) — int

Events (events)

  • Event ID (event id) — int — Primary key — NOT NULL
  • CCTV ID (cctv_id) — int — Foreign key → Camera.CCTV ID — NOT NULL
  • Time (timestamp) — dz
  • Client (client id) — int
  • Event Name (event_name) — str
  • Frame Information (frame_id) — int

Media (media)

  • media id (cctv id) — int — Primary key — NOT NULL
  • Event ID (event id) — int — Foreign key → Events.Event ID — NOT NULL
  • CCTV ID (camera_name) — int — Foreign key → Events.CCTV ID — NOT NULL
  • Media Link (media_url) — str
  • Media Time (media timestamp) — dz
  • Media Duration (duration_ms) — int
  • Media Type (media_type) — str

Object Registation (objects)

  • Object ID (object_id) — int — Primary key — NOT NULL
  • Object Name (name) — str
  • Creation Time (created_at) — datetime

Objects Images (target images)

  • Image ID (image_id) — int — Primary key — NOT NULL
  • Object ID (target_id) — int — Foreign key → Object Registation.Object ID — NOT NULL
  • Images Path (url) — str