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