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