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