예방점검1_인터페이스_물리
테이블 (11)
EAI_EQUIPMENTBM_RCV
- UNISYSTEM_ID — VARCHAR2(4) — 기본 키 — NOT NULL
- MESSAGE_ID — VARCHAR2(32) — 기본 키 — NOT NULL
- DATE_TIME — VARCHAR2(18) — 기본 키 — NOT NULL
- EQ_SN — VARCHAR2(50)
- ITEM_CD — VARCHAR2(50)
- SET_QY — VARCHAR2(50)
- STT — CHAR(1)
- RECV_TIME — CHAR(17) — NOT NULL
- DEAL_STAT — CHAR(1) — NOT NULL
- DEAL_DESC — VARCHAR2(1000)
EAI_EQUIPMENTMS_RCV
- UNISYSTEM_ID — VARCHAR2(4) — 기본 키 — NOT NULL
- MESSAGE_ID — VARCHAR2(32) — 기본 키 — NOT NULL
- DATE_TIME — VARCHAR2(18) — 기본 키 — NOT NULL
- EQ_SN — VARCHAR2(50)
- EQ_NO — VARCHAR2(18)
- EQ_NM — VARCHAR2(256)
- USE_YN — VARCHAR2(50)
- FNLC_SN — VARCHAR2(50)
- UPER_EQ_SN — VARCHAR2(50)
- FILD_MGMT_NO — VARCHAR2(60)
- EQ_CATE_CD — VARCHAR2(50)
- EQ_SE_CD — VARCHAR2(50)
- OBJT_TY_CD — VARCHAR2(50)
- CLSS_SN — VARCHAR2(50)
- MGMT_DEPT — VARCHAR2(50)
- WKPL_SN — VARCHAR2(50)
- ASSET_NO — VARCHAR2(18)
- FRST_OPER_DT — VARCHAR2(8)
- COCEN_CD — VARCHAR2(50)
- MAKER — VARCHAR2(500)
- MAKE_DT — VARCHAR2(8)
- STT — CHAR(1)
- RECV_TIME — CHAR(17) — NOT NULL
- DEAL_STAT — CHAR(1) — NOT NULL
- DEAL_DESC — VARCHAR2(1000)
EAI_EQUIPMENTSP_RCV
- UNISYSTEM_ID — VARCHAR2(4) — NOT NULL
- MESSAGE_ID — VARCHAR2(32) — NOT NULL
- DATE_TIME — VARCHAR2(18) — NOT NULL
- EQ_SN — VARCHAR2(50)
- EQ_MANP_SN — VARCHAR2(50)
- ORDR — VARCHAR2(50)
- CLSS_MANP_CD — VARCHAR2(50)
- MANP_VAL — VARCHAR2(256)
- STT — CHAR(1)
- RECV_TIME — CHAR(17) — NOT NULL
- DEAL_STAT — CHAR(1) — NOT NULL
- DEAL_DESC — VARCHAR2(1000)
EAI_FLOCATIONBM_RCV
- UNISYSTEM_ID — VARCHAR2(4) — 기본 키 — NOT NULL
- MESSAGE_ID — VARCHAR2(32) — 기본 키 — NOT NULL
- DATE_TIME — VARCHAR2(18) — 기본 키 — NOT NULL
- FNLC_SN — VARCHAR2(50)
- ITEM_CD — VARCHAR2(50)
- SET_QY — VARCHAR2(50)
- STT — CHAR(1)
- RECV_TIME — CHAR(17) — NOT NULL
- DEAL_STAT — CHAR(1) — NOT NULL
- DEAL_DESC — VARCHAR2(1000)
EAI_FLOCATIONMS_RCV
- UNISYSTEM_ID — VARCHAR2(4) — 기본 키 — NOT NULL
- MESSAGE_ID — VARCHAR2(32) — 기본 키 — NOT NULL
- DATE_TIME — VARCHAR2(18) — 기본 키 — NOT NULL
- FNLC_SN — VARCHAR2(50)
- FNLC_NO — VARCHAR2(18)
- FNLC_NM — VARCHAR2(256)
- UPER_FNLC_SN — VARCHAR2(50)
- USE_YN — VARCHAR2(50)
- FNLC_LC_CD — VARCHAR2(50)
- MGMT_DEPT — VARCHAR2(50)
- WKPL_SN — VARCHAR2(50)
- ASSET_NO — VARCHAR2(18)
- COCEN_CD — VARCHAR2(50)
- FRST_OPER_DT — VARCHAR2(8)
- ROOM_NO — VARCHAR2(128)
- FCLT_GRP_CD — VARCHAR2(50)
- STT — CHAR(1)
- RECV_TIME — CHAR(17) — NOT NULL
- DEAL_STAT — CHAR(1) — NOT NULL
- DEAL_DESC — VARCHAR2(1000)
EAI_PINSPECTIONIT_RCV
- UNISYSTEM_ID — VARCHAR2(4) — 기본 키 — NOT NULL
- MESSAGE_ID — VARCHAR2(32) — 기본 키 — NOT NULL
- DATE_TIME — VARCHAR2(18) — 기본 키 — NOT NULL
- CHCK_NO — VARCHAR2(18)
- CHCK_FACT_SN — VARCHAR2(50)
- UPT_HIST_CNT — VARCHAR2(50)
- CHCK_ORDR — VARCHAR2(20)
- CHCK_DTLS — VARCHAR2(256)
- CHCK_WAY — VARCHAR2(256)
- CHCK_MAX_VAL — VARCHAR2(50)
- CHCK_MIN_VAL — VARCHAR2(50)
- CHCK_STDR_VAL — VARCHAR2(50)
- OPER_YN — CHAR(1)
- NUM_INPUT_YN — CHAR(1)
- UNIT_CD — VARCHAR2(50)
- MSRE_UNT — VARCHAR2(256)
- STT — CHAR(1)
- RECV_TIME — CHAR(17) — NOT NULL
- DEAL_STAT — CHAR(1) — NOT NULL
- DEAL_DESC — VARCHAR2(1000)
EAI_PINSPECTIONMS_RCV
- UNISYSTEM_ID — VARCHAR2(4) — 기본 키 — NOT NULL
- MESSAGE_ID — VARCHAR2(32) — 기본 키 — NOT NULL
- DATE_TIME — VARCHAR2(18) — 기본 키 — NOT NULL
- CHCK_NO — VARCHAR2(18)
- UPT_HIST_CNT — VARCHAR2(50)
- NEW_YN — CHAR(1)
- CHCK_NM — VARCHAR2(256)
- MSTR_STT — VARCHAR2(50)
- FNLC_SN — VARCHAR2(50)
- EQ_SN — VARCHAR2(50)
- PRID_CR_RULE — VARCHAR2(50)
- PRID — VARCHAR2(50)
- PRID_TY — VARCHAR2(50)
- PRID_AUTO_RULE — VARCHAR2(50)
- PRID_OPER_STDE — VARCHAR2(8)
- PRID_WK — VARCHAR2(18)
- PRID_DAY — VARCHAR2(18)
- WKPL_SN — VARCHAR2(50)
- MGMT_DEPT — VARCHAR2(18)
- CHCK_KND — VARCHAR2(50)
- STT — CHAR(1)
- RECV_TIME — CHAR(17) — NOT NULL
- DEAL_STAT — CHAR(1) — NOT NULL
- DEAL_DESC — VARCHAR2(1000)
EAI_PINSPECTIONOD_RCV
- UNISYSTEM_ID — VARCHAR2(4) — 기본 키 — NOT NULL
- MESSAGE_ID — VARCHAR2(32) — 기본 키 — NOT NULL
- DATE_TIME — VARCHAR2(18) — 기본 키 — NOT NULL
- CKDR_NO — VARCHAR2(18)
- CHCK_NO — VARCHAR2(18)
- UPT_HIST_CNT — VARCHAR2(50)
- YEAR — VARCHAR2(4)
- MT — VARCHAR2(2)
- WK — VARCHAR2(18)
- CR_DT — VARCHAR2(8) — NOT NULL
- PLAN_DT — VARCHAR2(8)
- CHCK_DT — VARCHAR2(8)
- CHCK_TIME — VARCHAR2(4)
- CMPTER_ID — VARCHAR2(50)
- COMP_DT — VARCHAR2(8)
- COMP_TIME — VARCHAR2(4)
- COMP_YN — CHAR(1)
- SBCT_CD — VARCHAR2(50)
- STT — CHAR(1)
- RECV_TIME — CHAR(17) — NOT NULL
- DEAL_STAT — CHAR(1) — NOT NULL
- DEAL_DESC — VARCHAR2(1000)
EAI_PINSPECTIONRS_RCV
- UNISYSTEM_ID — VARCHAR2(4) — 기본 키 — NOT NULL
- MESSAGE_ID — VARCHAR2(32) — 기본 키 — NOT NULL
- DATE_TIME — VARCHAR2(18) — 기본 키 — NOT NULL
- CKDR_NO — VARCHAR2(18)
- CHCK_NO — VARCHAR2(18)
- UPT_HIST_CNT — VARCHAR2(50)
- OBJT_SN — VARCHAR2(50)
- CHCK_INFO — VARCHAR2(5000)
- CHCK_REG_ID — VARCHAR2(50)
- CHCK_REG_NM — VARCHAR2(128)
- CHCK_DT — VARCHAR2(8)
- CHCK_TIME — VARCHAR2(4)
- STT — CHAR(1)
- RECV_TIME — CHAR(17) — NOT NULL
- DEAL_STAT — CHAR(1) — NOT NULL
- DEAL_DESC — VARCHAR2(1000)
EAI_PINSPECTIONRS_SND
- UNISYSTEM_ID — VARCHAR2(4) — 기본 키 — NOT NULL
- MESSAGE_ID — VARCHAR2(32) — 기본 키 — NOT NULL
- DATE_TIME — VARCHAR2(18) — 기본 키 — NOT NULL
- CKDR_NO — VARCHAR2(18)
- CHCK_NO — VARCHAR2(18)
- UPT_HIST_CNT — VARCHAR2(50)
- OBJT_SN — VARCHAR2(50)
- CHCK_INFO — VARCHAR2(5000)
- CHCK_REG_ID — VARCHAR2(50)
- CHCK_REG_NM — VARCHAR2(128)
- MHRL_INFO — VARCHAR2(50)
- MSS_USER_ID — VARCHAR2(50)
- CHCK_DT — VARCHAR2(8)
- CHCK_TIME — VARCHAR2(4)
- STT — CHAR(1)
- SEND_TIME — CHAR(17) — NOT NULL
- DEAL_STAT — CHAR(1) — NOT NULL
- DEAL_DESC — VARCHAR2(1000)
EAI_PINSPECTIONTA_RCV
- UNISYSTEM_ID — VARCHAR2(4) — 기본 키 — NOT NULL
- MESSAGE_ID — VARCHAR2(32) — 기본 키 — NOT NULL
- DATE_TIME — VARCHAR2(18) — 기본 키 — NOT NULL
- CHCK_NO — VARCHAR2(18)
- UPT_HIST_CNT — VARCHAR2(50)
- OBJT_SN — VARCHAR2(50)
- FNLC_SN — VARCHAR2(50)
- EQ_SN — VARCHAR2(50)
- STT — CHAR(1)
- RECV_TIME — CHAR(17) — NOT NULL
- DEAL_STAT — CHAR(1) — NOT NULL
- DEAL_DESC — VARCHAR2(1000)