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