스마트 안전관리 프로젝트

테이블 (27)

공통코드 관리 (COM_CODE_MNG)

  • Key (CODE_ID) — VARCHAR2(50) — 기본 키
  • Field (CODE_NM) — VARCHAR2(200)
  • Field (UP_CODE_ID) — VARCHAR2(5)
  • Field (DISCRIPTION) — VARCHAR2(1000)
  • Field (USE_YN) — VARCHAR2(1)
  • Field (REG_DATE) — VARCHAR2(14)
  • Field (REG_ID) — VARCHAR2(50)
  • Field (AMD_DATE) — VARCHAR2(14)
  • Field (AMD_ID) — VARCHAR2(50)

구역 (COM_AREA)

  • Key (AREA_ID) — VARCHAR2(50) — 기본 키 — NOT NULL
  • Key2 (AREA_MASTER_ID) — VARCHAR2(50) — 기본 키
  • Field (AREA_NM) — VARCHAR2(200)
  • Field (DISPLAYSEQ) — INT
  • Field (USE_YN) — CHAR(1)
  • Field (REG_DATE) — VARCHAR2(14)
  • Field (REG_ID) — VARCHAR2(50)
  • Field (AMD_DATE) — VARCHAR2(14)
  • Field (AMD_ID) — VARCHAR2(50)

구역별 메뉴 (COM_MENU_AREA)

  • Key (MENU_ID) — VARCHAR2(20) — 기본 키 — NOT NULL
  • Field (AREA_ID) — VARCHAR2(50)
  • Field (REG_DATE) — VARCHAR2(14)
  • Field (REG_ID) — VARCHAR2(50)

권한 (COM_AUTHORITY)

  • Key (AUTH_ID) — VARCHAR2(10) — 기본 키 — NOT NULL
  • Field (AUTH_NM) — VARCHAR2(50)
  • Field (AUTH_DESC) — VARCHAR2(300)
  • Field (USE_YN) — VARCHAR2(1)
  • Field (REG_DATE) — VARCHAR2(14)
  • Field (REG_ID) — VARCHAR2(50)
  • Field (AMD_DATE) — VARCHAR2(14)
  • Field (AMD_ID) — VARCHAR2(50)

권한별 메뉴 (COM_AUTHORITY_MENU)

  • Key (AUTH_ID) — VARCHAR2(10) — 기본 키 — NOT NULL
  • Field (MENU_ID) — VARCHAR2(20)
  • Field (AUTH_ROLE) — VARCHAR2(30)
  • Field (REG_DATE) — VARCHAR2(14)
  • Field (REG_ID) — VARCHAR2(50)
  • Field (AMD_DATE) — VARCHAR214)
  • Field (AMD_ID) — VARCHAR2(50)

날씨 (COM_WEATHER)

  • Key (ID) — INT — 기본 키
  • Field (TEMP) — DECIMAL
  • Field (HUMIDITY) — DECIMAL
  • Field (LAST_YN) — CHAR(1)
  • Field (PRESSURE) — DECIMAL
  • Field (REG_DATE) — VARCHAR2(14)
  • Field (MEASURE_TIME) — DATETIME
  • Field (MEASURE_TIMESTAMP) — VARCHAR2(20)
  • Field (SKY) — VARCHAR2(20)
  • Field (ICON) — VARCHAR2(10)

다국어 (COM_LANGUAGE)

  • Key (LANG) — VARCHAR2(50) — 기본 키 — NOT NULL
  • Field (LANGUAGE_NM) — VARCHAR2(300)
  • Field (REG_DATE) — VARCHAR2(14)
  • Field (REG_ID) — VARCHAR(50)
  • Field (USE_YN) — VARCHAR2(1)

단위 (COM_UNIT)

  • Key (UNIT_ID) — VARCHAR2(50) — 기본 키 — NOT NULL
  • Field (UNIT_NM) — VARCHAR2(300)
  • Field (UNIT_DESC) — VARCHAR2(500)
  • Field (UNIT_TYPE) — VARCHAR220)
  • Field (USE_YN) — CHAR(1)
  • Field (REG_DATE) — VARCHAR2(14)
  • Field (REG_ID) — VARCHAR(50)
  • Field (AMD_DATE) — VARCHAR(14)
  • Field (AMD_ID) — VARCHAR(50)

메뉴 (COM_MENU)

  • Key (MENU_ID) — VARCHAR2(20) — 기본 키 — NOT NULL
  • Field (MENU_NM) — VARCHAR2(50)
  • Field (MENU_DESC) — VARCHAR2(200)
  • Field (PARENT_MENU_ID) — VARCHAR2(20)
  • Field (MENU_URL) — VARCHAR2(50)
  • Field (USE_YN) — VARCHAR2(1)
  • Field (REG_DATE) — VARCHAR2(14)
  • Field (REG_ID) — VARCHAR2(50)
  • Field (AMD_DATE) — VARCHAR2(14)
  • Field (AMD_ID) — VARCHAR2(50)
  • Field (DISPLAY_ORDER) — INT
  • Field (MENU_LEVEL) — VARCHAR2(30)
  • Field (LINK_YN) — CHAR(1)

배치 (LOG_BATCH)

  • Key (BATCH_ID) — VARCHAR2(50) — 기본 키 — NOT NULL
  • Field (BATCH_NM) — VARCHAR2(200)
  • Field (LAST_ID) — VARCHAR2(300)
  • Field (PROC_COUNT) — INT
  • Field (PROC_TIME) — DATETIME
  • Field (DETAIL) — VARCHAR2(1000)
  • Field (PROC_TYPE) — VARCHAR2(10)
  • Field (RUN_YN) — CHAR(10)
  • Field (MEMO) — VARCHAR2(1000)
  • Field (BATCH_GROUP) — VARCHAR2(20)

부서 (COM_DEPARTMENT)

  • Key (DEPT_ID) — VARCHAR2(20) — 기본 키 — NOT NULL
  • Field (DEPT_NM) — VARCHAR2(50)
  • Field (USE_YN) — VARCHAR2(1)
  • Field (REG_DATE) — VARCHAR2(14)
  • Field (REG_ID) — VARCHAR2(50)
  • Field (AMD_DATE) — VARCHAR2(14)
  • Field (AMD_ID) — VARCHAR2(50)

사용자 (COM_USER)

  • Key (USER_ID) — VARCHAR2(50) — 기본 키 — NOT NULL
  • Field (USER_PWD) — VARCHAR2(10)
  • Field (USER_NM) — VARCHAR2(50)
  • Field (CHANGE_PWD_DATE) — DATETIME
  • Field (EMAIL) — VARCHAR(30)
  • Field (CELLPHONE) — VARCHAR2(20)
  • Field (USE_YN) — VARCHAR2(1)
  • Field (AREA_ID) — VARCHAR2(50)
  • Field (DEPT_ID) — VARCHAR2(20)
  • Field (LOGIN_IP) — VARCHAR2(30)
  • Field (LOGIN_DATE) — DATETIME
  • Field (LOGIN_FAIL_CNT) — INT
  • Field (REG_DATE) — VARCHAR2(14)
  • Field (REG_ID) — VARCHAR2(50)
  • Field (AMD_DATE) — VARCHAR2(14)
  • Field (AMD_ID) — VARCHAR2(50)
  • Field (MAIN_MENU_ID) — VARCHAR2(30)

사용자 권한 (COM_USER_AUTH)

  • Key (USER_ID) — VARCHAR2(50) — 기본 키 — NOT NULL
  • Field (AUTH_ID) — VARCHAR2(50)
  • Field (REG_DATE) — VARCHAR2(14)
  • Field (REG_ID) — VARCHAR2(50)
  • Field (AMD_DATE) — VARCHAR2(14)
  • Field (AMD_ID) — VARCHAR2(50)

사이트 (COM_SITE)

  • Key (SITE_ID) — VARCHAR2(50) — 기본 키 — NOT NULL
  • Key2 (SITE_MASTER_ID) — VARCHAR2(50) — 기본 키
  • Field (SITE_NM) — VARCHAR2(50)
  • Field (SITE_DESC) — VARCHAR2(200)
  • Field (USE_YN) — VARCHAR2(1)
  • Field (REG_DATE) — VARCHAR2(14)
  • Field (REG_ID) — VARCHAR2(50)
  • Field (AMD_DATE) — VARCHAR2(14)
  • Field (AMD_ID) — VARCHAR2(50)

상태 (COM_STATE_CODE)

  • Key (STATE_ID) — VARCHAR2(50) — 기본 키 — NOT NULL
  • Field (STATE_NM) — VARCHAR2(300)
  • Field (STATE_TYPE) — VARCHAR2(50)
  • Field (USE_YN) — VARCHAR2(1)
  • Field (REG_DATE) — VARCHAR2(14)
  • Field (REG_ID) — VARCHAR(50)
  • Field (AMD_DATE) — VARCHAR(14)
  • Field (AMD_ID) — VARCHAR(50)
  • Field (EQP_ID) — VARCHAR2(50)
  • Field (RUN_YN) — CHAR(1)

설비(장비) (COM_EQUIPMENT)

  • Key (EQP_ID) — VARCHAR2(50) — 기본 키 — NOT NULL
  • Field (EQP_NM) — VARCHAR2(300)
  • Field (PARENT_EQP_ID) — VARCHAR2(50)
  • Field (EQP_DESC) — VARCHAR2(1000)
  • Field (EQP_LEVEL) — VARCHAR2(20)
  • Field (EQP_TYPE) — VARCHAR2(20)
  • Field (EQP_GROUP) — VARCHAR2(20)
  • Field (LINE_ID) — VARCHAR2(50)
  • Field (USE_YN) — CHAR(1)
  • Field (REG_DATE) — VARCHAR2(14)
  • Field (REG_ID) — VARCHAR2(50)
  • Field (AMD_DATE) — VARCHAR2(14)
  • Field (AMD_ID) — VARCHAR2(50)
  • Field (DISPLAY_ORDER) — INT
  • Field (MAPPED_EQP_ID) — VARCHAR2(50)

설비별 상태 (COM_EQP_STATE)

  • Key (EQP_ID) — VARCHAR2(50) — 기본 키 — NOT NULL
  • Field (EVENT_TIME) — DATETIME
  • Field (STATE_ID) — VARCHAR2(50)
  • Field (STATE_TYPE) — VARCHAR2(50)
  • Field (RUN_YN) — CHAR(1)
  • Field (AMD_DATE) — VARCHAR2(14)

설비별 상태 이력 (COM_EQP_STATE_HIS)

  • Key (EVENT_TIME) — DATETIME — 기본 키 — NOT NULL
  • Field (END_TIME) — DATETIME
  • Field (REG_DATE) — VARCHAR2(14)
  • Field (REG_ID) — VARCHAR2(50)
  • Field (AMD_DATE) — VARCHAR2(14)
  • Field (AMD_ID) — VARCHAR2(50)
  • Field (EQP_ID) — VARCHAR2(50)
  • Field (START_TIME) — DATETIME
  • Field (STATE_ID) — VARCHAR2(50)
  • Field (LAST_YN) — CHAR(1)
  • Field (RUN_YN) — CHAR(1)
  • Field (STATE_TYPE) — VARCHAR2(50)

설비별 알람 (COM_EQP_ALARM)

  • Key (EQP_ID) — VARCHAR2(50) — 기본 키 — NOT NULL
  • Field (ALARM_ID) — VARCHAR2(50)
  • Field (EVENT_TIME) — DATETIME
  • Field (SHOW_YN) — CHAR(1)

설비별 알람 이력 (COM_EQP_ALARM_HIS)

  • Key (EVENT_TIME) — DATETIME — 기본 키 — NOT NULL
  • Field (ALARM_ID) — VARCHAR2(50)
  • Field (EQP_ID) — VARCHAR2(50)
  • Field (REG_DATE) — VARCHAR2(14)
  • Field (REG_ID) — VARCHAR(50)
  • Field (END_TIME) — DATETIME

설비별 접점 (COM_EQP_TAG)

  • Key (EQP_ID) — VARCHAR2(50) — 기본 키 — NOT NULL
  • Key2 (TAG_ID) — VARCHAR2(50) — 기본 키 — NOT NULL
  • Field (REG_DATE) — VARCHAR2(14)
  • Field (REG_ID) — VARCHAR2(50)
  • Field (COLLECT_TYPE) — VARCHAR2(30)
  • Field (COLLECT_YN) — CHAR(1)

알람 (COM_ALARM)

  • Key (ALARM_ID) — VARCHAR2(50) — 기본 키 — NOT NULL
  • Field (ALARM_NM) — VARCHAR2(200)
  • Field (ALARM_DESC) — VARCHAR2(1000)
  • Field (ALARM_LEVEL) — VARCHAR2(20)
  • Field (USE_YN) — VARCHAR2(1)
  • Field (ALARM_TIME) — DECIMAL
  • Field (REG_DATE) — VARCHAR2(14)
  • Field (REG_ID) — VARCHAR2(50)
  • Field (AMD_DATE) — VARCHAR2(14)
  • Field (AMD_ID) — VARCHAR2(50)

워크센터 (COM_WORKCENTER)

  • Key (WORKCENTER_ID) — VARCHAR2(50) — 기본 키 — NOT NULL
  • Field (WORKCENTER_NM) — VARCHAR2(200)
  • Field (WORKCENTER_DESC) — VARCHAR2(2000)
  • Field (USE_YN) — VARCHAR2(1)
  • Field (REG_DATE) — VARCHAR2(14)
  • Field (REG_ID) — VARCHAR2(50)
  • Field (AMD_DATE) — VARCHAR2(14)
  • Field (AMD_ID) — VARCHAR2(50)

접점 (COM_TAG)

  • Key (TAG_ID) — VARCHAR2(50) — 기본 키 — NOT NULL
  • Field (TAG_NM) — VARCHAR2(100)
  • Field (TAG_TYPE) — VARCHAR2(20)
  • Field (UNIT) — VARCHAR2(20)
  • Field (USE_YN) — VARCHAR2(1)
  • Field (REG_DATE) — VARCHAR2(14)
  • Field (REG_ID) — VARCHAR2(50)
  • Field (AMD_DATE) — VARCHAR2(14)
  • Field (AMD_ID) — VARCHAR2(50)
  • Field (CHART_TYPE) — VARCHAR2(30)
  • Field (FILL_YN) — CHAR(1)
  • Field (AREA_ID) — VARCHAR2(50)
  • Field (ATTR1) — VARCHAR2(1000)
  • Field (ATTR2) — VARCHAR2(1000)
  • Field (ATTR3) — VARCHAR2(1000)
  • Field (ATTR4) — VARCHAR2(1000)
  • Field (ATTR5) — VARCHAR2(1000)
  • Field (AUTO_LIMIT_YN) — CHAR(1)
  • Field (TAG_DESC) — VARCHAR2(1000)

접점 ROW 값 (COM_TAG_VALUE)

  • Key (ID) — INT — 기본 키 — NOT NULL
  • Field (EVENT_TIME) — DATETIME
  • Field (TAG_VALUE) — DECIMAL(18,6)
  • Field (PREV_VAL) — DECIMAL(18,6)
  • Field (UCL) — DECIMAL(18,6)
  • Field (LCL) — DECIMAL(18,6)
  • Field (TAG_ID) — VARCHAR2(50)
  • Field (EQP_RUN_YN) — CHAR(1)

접점 집계 값 (COM_TAG_VALUE_SUM)

  • Key (MEASURE_TYPE) — VARCHAR2(30) — 기본 키 — NOT NULL
  • Key2 (EVENT_TIME) — DATETIME — 기본 키 — NOT NULL
  • Key3 (TAG_ID) — VARCHAR2(50) — 기본 키 — NOT NULL
  • Field (SUM) — DECIMAL(18,6)
  • Field (AVG) — DECIMAL(18,6)
  • Field (MIN) — DECIMAL(18,6)
  • Field (MAX) — DECIMAL(18,6)
  • Field (STDDEV) — DECIMAL(18,6)

접점 현재 값 (COM_TAG_VALUE_CURRENT)

  • Key (TAG_ID) — VARCHAR2(50) — 기본 키 — NOT NULL
  • Field (TAG_GB) — VARCHAR2(30)
  • Field (EVENT_TIME) — DATETIME
  • Field (TAG_VALUE) — DECIMAL(18,6)
  • Field (REF_ID) — INT
  • Field (AMD_DATE) — VARCHAR2(14)
  • Field