Poseman
Tables (9)
access_logs
- log_id — UUID
- user_id — UUID
- accessed_at — TIMESTAMP
- action — TEXT
alerts
- alert_id — UUID
- event_id — UUID
- alert_type — VARCHAR(50)
- sent_time — TIMESTAMP
cameras
- camera_id — VARCHAR(50)
- store_id — VARCHAR(50) — NOT NULL
- location — TEXT
- status — BOOLEAN
- created_at — TIMESTAMP
event_logs
- event_id — UUID
- timestamp — TIMESTAMP — NOT NULL
- camera_id — VARCHAR(50)
- behavior — VARCHAR(100)
- confidence — FLOAT
- severity — INTEGER
reports
- report_id — UUID
- user_id — UUID
- created_at — TIMESTAMP
- type — VARCHAR(20)
- data_json — TEXT
settings
- setting_id — UUID
- camera_id — VARCHAR(50)
- sensitivity — FLOAT
- alert_enabled — BOOLEAN
speaker_triggers
- trigger_id — UUID
- event_id — UUID
- trigger_time — TIMESTAMP
users
- Key — Primary key — NOT NULL
- user_id — UUID
- username — VARCHAR(50) — NOT NULL
- password_hash — VARCHAR(255) — NOT NULL
- role — VARCHAR(20)
- OPERATOR)) — NOT — NOT NULL
- created_at — TIMESTAMP
video_clips
- clip_id — UUID
- event_id — UUID
- file_path — TEXT — NOT NULL
- start_time — TIMESTAMP
- end_time — TIMESTAMP