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