스마트 안전관리 프로젝트
테이블 (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