oculon

Tables (7)

bbox_log

  • cam_id — int — Primary key — NOT NULL
  • ts — timestamptz — Primary key — NOT NULL
  • frames — jsonb — NOT NULL

cams

  • id — serial — Primary key — NOT NULL
  • nvr_id — int — Foreign key → nvr_devices.id — NOT NULL
  • code — varchar(32) — NOT NULL
  • name — varchar(64) — NOT NULL
  • nvr_channel — int — NOT NULL
  • width — int — NOT NULL
  • height — int — NOT NULL
  • fps — int — NOT NULL
  • stream_path — varchar(64) — NOT NULL
  • confidence_threshold — numeric(3,2) — NOT NULL
  • config_version — int — NOT NULL
  • enabled — boolean — NOT NULL
  • deleted_at — timestamptz
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

clip_files

  • event_id — bigint — Foreign key → events.id — NOT NULL
  • state — varchar(16) — NOT NULL
  • file_path — varchar(512)
  • retry_count — int — NOT NULL
  • error — varchar(64)
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

events

  • id — bigserial — Primary key — NOT NULL
  • cam_id — int — Foreign key → cams.id — NOT NULL
  • event_type — varchar(32) — Foreign key → state_types.code — NOT NULL
  • severity — varchar(8) — NOT NULL
  • confidence — numeric(3,2) — NOT NULL
  • occurred_at — timestamptz — NOT NULL
  • status — varchar(16) — NOT NULL
  • read_at — timestamptz
  • resolved_at — timestamptz
  • resolve_note — text
  • resolver_name — varchar(64)
  • created_at — timestamptz — NOT NULL

nvr_devices

  • id — serial — Primary key — NOT NULL
  • host — varchar(255) — NOT NULL
  • rtsp_port — int — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL

state_types

  • code — varchar(32) — Primary key — NOT NULL
  • label — varchar(64) — NOT NULL
  • severity — varchar(8) — NOT NULL
  • is_event — boolean — NOT NULL
  • sort_order — int — NOT NULL

zones

  • id — serial — Primary key — NOT NULL
  • cam_id — int — Foreign key → cams.id — NOT NULL
  • name — varchar(20) — NOT NULL
  • type — varchar(32) — NOT NULL
  • enabled — boolean — NOT NULL
  • points — jsonb — NOT NULL
  • created_at — timestamptz — NOT NULL
  • updated_at — timestamptz — NOT NULL