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