water_project

Tables (14)

camera_capture (카메라캡쳐)

  • id — intrger — Primary key — NOT NULL
  • camera — integer — Foreign key → camera_setting.id — NOT NULL
  • capture_image — char

camera_log (카메라 로그)

  • id — integer — Primary key — NOT NULL
  • camera — integer — Foreign key → camera_setting.id — NOT NULL
  • log_date — datetime
  • camera_state — char

camera_setting (카메라정보)

  • id — integer — Primary key — NOT NULL
  • camera_name — char
  • camera_id — char
  • camera_pw — char
  • camera_ip — char
  • camera_prot (camera_port) — char
  • camera_url — char

color (색상)

  • id — integer — Primary key — NOT NULL
  • camera — integer — Foreign key → camera_setting.id — NOT NULL
  • color — char
  • inteval — float

color_dataset (데이터셋(색상))

  • id — integer — Primary key — NOT NULL
  • color — char
  • image — blob

color_event_log (색상 이벤트 로그)

  • id — integer — Primary key — NOT NULL
  • id (id2) — integer — Foreign key → color.id — NOT NULL
  • log_date — datetime
  • value — char

color_roi (색상 분할좌표)

  • id — integer — Primary key — NOT NULL
  • color_id — integer — Foreign key → color.id — NOT NULL
  • x — integer
  • y — integer
  • w — integer
  • h — integer

color_train (훈련 색상값)

  • id — integer — Primary key
  • color_dataset — integer — Foreign key → color_dataset.id — NOT NULL
  • color_r — integer
  • color_g — integer
  • color_b — integer

line (선)

  • id — integer — Primary key — NOT NULL
  • camera — integer — Foreign key → camera_setting.id — NOT NULL
  • inteval — float

line_event_log (선 이벤트 로그)

  • id — integer — Primary key — NOT NULL
  • line_id — integer — Foreign key → line.id — NOT NULL
  • camera — integer — Foreign key → line.camera — NOT NULL
  • log_date — datetime
  • value — integer

line_roi (선 분할좌표)

  • id — integer — Foreign key → line.id — NOT NULL
  • camera — integer — Foreign key → line.camera — NOT NULL
  • x — integer
  • y — integer
  • w — integer
  • h — integer

text (문자)

  • id — integer — Primary key — NOT NULL
  • camera — integer — Foreign key → camera_setting.id — NOT NULL
  • inteval — float

text_event_log (문자 이벤트 로그)

  • id — integer — Primary key — NOT NULL
  • id (id2) — integer — Foreign key → text.id — NOT NULL
  • camera — integer — Foreign key → text.camera — NOT NULL
  • log_date — datetime
  • value — char

text_roi (문자 분할좌표)

  • id — integer — Foreign key → text.id — NOT NULL
  • camera — integer — Foreign key → text.camera — NOT NULL
  • x — integer
  • y — integer
  • w — integer
  • h — integer