asdf
Tables (18)
COM_ALARM_CODE
- ALARM_CD — varchar(20) — NOT NULL
- ALARM_NM — varchar(300)
- ALARM_DESC — varchar(600)
- ALARM_LEVEL — varchar(2)
- USE_YN — char
- REMARKS — varchar(1000)
- CREATED_DT — datetime
- CREATED_USER_ID — varchar(30)
- UPDATED_DT — datetime
- UPDATED_USER_ID — varchar(30)
- ALARM_TIME — numeric(15)
- TEXT — varchar(2000)
COM_AREA
- AREA_CD — varchar(20) — NOT NULL
- AREA_NM — varchar(300)
- AREA_DESC — varchar(600)
- SIGN_AREA_CD — varchar(20)
- SITE_CD — varchar(20)
- USE_YN — varchar(2)
- REMARKS — varchar(1000)
- CREATED_DT — datetime
- CREATED_USER_ID — varchar(30)
- UPDATED_DT — datetime
- UPDATED_USER_ID — varchar(30)
- PLANT_CD — varchar(20)
- DISPLAY_ORDER — numeric
COM_AREA_PRODUCT
- AREA_CD — varchar(20) — Primary key — NOT NULL
- PROD_CD — varchar(50) — Primary key — NOT NULL
- USE_YN — char
- CREATED_DT — datetime
- CREATED_USER_ID — varchar(30)
COM_ARTICLE
- ARTICLE_ID — numeric(10) — NOT NULL
- BOARD_ID — numeric(10)
- TITLE — varchar(100)
- CONTENT — varchar(2000)
- DEL_YN — char
- VIEW_CNT — numeric(10)
- CREATED_DT — datetime
- CREATED_USER_ID — varchar(30)
- UPDATED_DT — datetime
- UPDATED_USER_ID — varchar(30)
- ATTR1 — varchar(100)
- ATTR2 — varchar(100)
- ATTR3 — varchar(100)
- ATTR4 — varchar(100)
- ATTR5 — varchar(100)
COM_ARTICLE_FILE
- ARTICLE_ID — numeric(10) — Primary key — NOT NULL
- ATTACH_FILE_ID — numeric(10) — Primary key — NOT NULL
COM_ATTACH_FILE
- ATTACH_FILE_ID — numeric(10) — NOT NULL
- ATTACH_FILE_NM — varchar(255)
- SERVER_FILE_NM — varchar(255)
- REFERENCD_FILE_ID — numeric(10)
- FILE_PATH — varchar(255)
- FILE_SIZE — numeric(15, 3)
- FILE_EXT — varchar(30)
- USE_YN — char
- CREATED_DT — datetime
- CREATED_USER_ID — varchar(30)
- UPDATED_DT — datetime
- UPDATED_USER_ID — varchar(30)
COM_AUTHORITY
- AUTH_CD — varchar(20) — NOT NULL
- AUTH_NM — varchar(300)
- AUTH_DESC — varchar(500)
- USE_YN — char
- CREATED_DT — datetime
- CREATED_USER_ID — varchar(30)
- UPDATED_DT — datetime
- UPDATED_USER_ID — varchar(30)
COM_AUTHORITY_MENU
- AUTH_CD — varchar(20) — Primary key — NOT NULL
- MENU_CD — varchar(50) — Primary key — NOT NULL
- AUTH_ROLE — varchar(10)
- CREATED_DT — datetime
- CREATED_USER_ID — varchar(30)
- UPDATED_DT — datetime
- UPDATED_USER_ID — varchar(30)
COM_BARCODE_CHECK
- ID — numeric(15) — NOT NULL
- MEASURE_TIME — datetime
- LINE_CD — char(18)
- SYS_BARCODE — varchar(100)
- READ_BARCODE — varchar(100)
- ORDER_NO — varchar(15)
- JUDG — varchar
- PROD_CD — varchar(50)
COM_BOARD
- BOARD_ID — numeric(10) — NOT NULL
- BOARD_NM — varchar(300)
- CREATED_DT — datetime
- CREATED_USER_ID — varchar(30)
- UPDATED_DT — datetime
- UPDATED_USER_ID — varchar(30)
COM_COMMONCODE
- CODE_CD — varchar(30) — Primary key — NOT NULL
- CODE_VALUE — varchar(100) — Primary key — NOT NULL
- CODE_NM — varchar(300)
- CODE_DESC — varchar(500)
- PARENT_CODE_CD — varchar(30)
- DISPLAY_ORDER — numeric(5)
- USE_YN — char
- ATTR1 — varchar(300)
- ATTR2 — varchar(300)
- ATTR3 — varchar(300)
- CREATED_DT — datetime
- CREATED_USER_ID — varchar(30)
- UPDATED_DT — datetime
- UPDATED_USER_ID — varchar(30)
- ATTR4 — varchar(50)
- ATTR5 — varchar(50)
- REMARKS — varchar(1000)
COM_CONTROL_LIMIT_CALC_OPT
- SEQ_ID — numeric(11)
- PROD_CD — varchar(50)
- TAG_CD — varchar(15)
- CALC_TIME — varchar(10)
- USE_YN — varchar(2)
- CREATED_DT — datetime
- CREATED_USER_ID — varchar(30)
- UPDATED_DT — datetime
- UPDATED_USER_ID — varchar(30)
COM_CONTROL_LIMIT_SUM
- STD_DATE — varchar(8) — Primary key — NOT NULL
- PROD_CD — varchar(50) — Primary key — NOT NULL
- START_TIME — datetime — Primary key — NOT NULL
- TAG_CD — varchar(50) — Primary key — NOT NULL
- VALUE_SUM — numeric(15, 3)
- VALUE_MAX — numeric(15, 3)
- VALUE_AVG — numeric(15, 3)
- VALUE_MIN — numeric(15, 3)
- VALUE_STDDEV — numeric(15, 3)
- VALUE_COUNT — numeric(7)
- CREATED_DT — datetime
- UCL — numeric(15, 3)
- CL — numeric(15, 3)
- LCL — numeric(15, 3)
- UPDATED_DT — datetime
- END_TIME — datetime
- RS_SUM — numeric(15, 3)
- RS_MAX — numeric(15, 3)
- RS_AVG — numeric(15, 3)
- RS_MIN — numeric(15, 3)
- RS_STDDEV — numeric(15, 3)
- RS_UCL — numeric(15, 3)
- RS_CL — numeric(15, 3)
- RS_LCL — numeric(15, 3)
- GOOD_CNT — char(18)
- BAD_CNT — char(18)
- GOOD_RATE — char(18)
- P_VALUE — char(18)
COM_CTQ_CODE
- CTQ_CD — varchar(20) — NOT NULL
- CTQ_NM — varchar(300)
- CTQ_DESC — varchar(600)
- PARENT_CTQ_CD — varchar(20)
- CREATED_DT — datetime
- CREATED_USER_ID — varchar(30)
- UPDATED_DT — datetime
- UPDATED_USER_ID — varchar(30)
- CTQ_TYPE — varchar(20)
- AREA_CD — varchar(20)
- USE_YN — char
- DISPLAY_ORDER — numeric
COM_CTQ_TAG
- CTQ_CD — varchar(50) — Primary key — NOT NULL
- TAG_CD — varchar(50) — Primary key — NOT NULL
- CREATED_DT — datetime
- CREATED_USER_ID — varchar(50)
- UPDATED_DT — datetime
- UPDATED_USER_ID — varchar(50)
COM_DEPARTMENT
- DEPT_CD — varchar(20) — NOT NULL
- DEPT_NM — varchar(300)
- USE_YN — char
- CREATED_DT — datetime
- CREATED_USER_ID — varchar(30)
- UPDATED_DT — datetime
- UPDATED_USER_ID — varchar(30)
PTS_ETC_DATA
- DOC_ID — numeric — Primary key — NOT NULL
- ETC_CD — varchar(15) — Primary key — NOT NULL
- S_VAL — varchar(2000)
- CREATED_DT — datetime
- CREATED_USER_ID — varchar(30)
- UPDATED_DT — datetime
- UPDATED_USER_ID — varchar(30)
PTS_LOT
- LOT_ID — numeric — NOT NULL
- REG_DATE — datetime
- LINE_CD — varchar(50)
- MIX_CODE — varchar(50)
- INPUT_WEIGHT — numeric
- PROD_WEIGHT — numeric
- GOODS_COUNT — numeric
- BAD_COUNT — numeric
- GOODS_CD — varchar(50)
- YIELD — numeric(5, 2)
- GOODS_RATE — numeric(5, 2)
- USE_YN — char
- TEMP — numeric(5, 2)
- HUMIDITY — numeric(5, 2)
- PRESSURE — numeric(6, 2)
- MIX_START_TIME — datetime
- MIX_END_TIME — datetime
- LINE_INPUT_TIME — datetime
- CREATED_DT — datetime
- UPDATED_DT — datetime