AI
Tables (6)
Alarm (알림 설정)
- Alarm_ID (ID) — NUMBER — Primary key — NOT NULL
- Field (배수지_알람_표시수준) — ENUM — NOT NULL
- Field (배수지_수위_유지수준_최하) — ENUM — NOT NULL
- Field (배수지_수위_유지수준_최고)
- Field (서버자원_알람_표시수준) — ENUM — NOT NULL
- Field (수충격_압력_최고기준) — int — NOT NULL
Alarm_log (알림 메시지 (기록))
- Alarm_log_ID (PK) — NUMBER — Primary key — NOT NULL
- InsertDate (생성일자) — DATE — NOT NULL
- Field (등급) — ENUM — NOT NULL
- Field (배수지명) — ENUM — NOT NULL
- Field (내용) — VARCHAR — NOT NULL
DATA (데이터 설정)
- Data_ID (PK) — NUMBER — Primary key — NOT NULL
- Field (배수지명) — ENUM — NOT NULL
- Operation (운영방식) — ENUM — NOT NULL
DATA_History (데이터 설정 변경이력)
- Data_history_ID (PK) — NUMBER — Primary key — NOT NULL
- Field (배수지명) — ENUM — NOT NULL
- Operation (운영방식) — ENUM — NOT NULL
- UpdateDate (변경일자) — DATE — NOT NULL
- User_ID (User_SN) — NUMBER — Foreign key → User.User_ID — NOT NULL
DATA_LOG (데이터 기록)
- Data_log_ID (PK) — NUMBER — Primary key — NOT NULL
- Field (배수지명) — ENUM — NOT NULL
- Sensor (센서) — ENUM — NOT NULL
- Tag (태그) — VARCHAR — NOT NULL
- Field (태그값) — int — NOT NULL
- InsertDate (기록 날짜) — DATE — NOT NULL
User (사용자)
- User_ID (User_SN) — NUMBER — Primary key — NOT NULL
- Name (이름) — VARCHAR — NOT NULL
- Id (아이디) — VARCHAR — NOT NULL
- Password (비밀번호) — VARCHAR — NOT NULL
- Manager (관리자여부) — ENUM — NOT NULL
- Phone (연락처) — int
- DeleteCheck (삭제여부) — ENUM — NOT NULL
- InsertDate (등록일자) — DATE — NOT NULL
- UpdateDate (수정일자) — DATE — NOT NULL
- DeleteDate (삭제일자) — DATE