ACI
Tables (5)
Algorithm (Untitled2)
- id — auto increment — Primary key — NOT NULL
- camera_id — auto increment — Foreign key → CAMERA.id — NOT NULL
- name — varchar
- roi — array
CAMERA (Untitled)
- id — auto increment — Primary key — NOT NULL
- name — varchar(40)
- video_src — varchar
- position_no
CAMERA (Untitled3)
- id — pk — Primary key — NOT NULL
- name — varchar
- video_src — varchar
- monitor_no — int
- grid_type — int
- position_no — int
- roi_and_model_list — jsonb
MONITOR (Untitled4)
- monitor_no (id) — auto increment — Primary key — NOT NULL
- grid_type
MONITOR_CAMERA (Untitled5)
- Key — Primary key — NOT NULL
- camer_id (id) — auto increment — Foreign key → CAMERA.id — NOT NULL
- monitor_no (id2) — auto increment — Foreign key → MONITOR.monitor_no — NOT NULL
- position_no