예방점검2_인터페이스_물리
테이블 (4)
EAI_CLASSDATA_RCV
- UNISYSTEM_ID — VARCHAR2(4) — 기본 키 — NOT NULL
- MESSAGE_ID — VARCHAR2(32) — 기본 키 — NOT NULL
- DATE_TIME — VARCHAR2(18) — 기본 키 — NOT NULL
- CLSS_MANP_SN — VARCHAR2(50)
- CLSS_SN — VARCHAR2(50)
- ORDR — VARCHAR2(50)
- CLSS_MANP_CD — VARCHAR2(50)
- STT — CHAR(1)
- RECV_TIME — CHAR(17) — NOT NULL
- DEAL_STAT — CHAR(1) — NOT NULL
- DEAL_DESC — VARCHAR2(1000)
EAI_CLASS_RCV
- UNISYSTEM_ID — VARCHAR2(4) — 기본 키 — NOT NULL
- MESSAGE_ID — VARCHAR2(32) — 기본 키 — NOT NULL
- DATE_TIME — VARCHAR2(18) — 기본 키 — NOT NULL
- CLSS_SN — VARCHAR2(50)
- CLSS_CD — VARCHAR2(50)
- CLSS_NM — VARCHAR2(256)
- USE_YN — VARCHAR2(50)
- STT — CHAR(1)
- RECV_TIME — CHAR(17) — NOT NULL
- DEAL_STAT — CHAR(1) — NOT NULL
- DEAL_DESC — VARCHAR2(1000)
EAI_MATERIALSTCK_RCV
- UNISYSTEM_ID — VARCHAR2(4) — 기본 키 — NOT NULL
- MESSAGE_ID — VARCHAR2(32) — 기본 키 — NOT NULL
- DATE_TIME — VARCHAR2(18) — 기본 키 — NOT NULL
- ITEM_CD — VARCHAR2(50)
- EVAL_TYPE — VARCHAR2(18)
- ITEM_LC_CD — VARCHAR2(50)
- ITEM_QY — VARCHAR2(50)
- RECV_TIME — CHAR(17) — NOT NULL
- DEAL_STAT — CHAR(1) — NOT NULL
- DEAL_DESC — VARCHAR2(1000)
EAI_MATERIALS_RCV
- UNISYSTEM_ID — VARCHAR2(4) — 기본 키 — NOT NULL
- MESSAGE_ID — VARCHAR2(32) — 기본 키 — NOT NULL
- DATE_TIME — VARCHAR2(18) — 기본 키 — NOT NULL
- ITEM_CD — VARCHAR2(50)
- ITEM_NM — VARCHAR2(500)
- LCLAS_NM — VARCHAR2(500)
- MLSFC_NM — VARCHAR2(500)
- SCLAS_NM — VARCHAR2(500)
- DTLCLFC_NM — VARCHAR2(500)
- BAS_UNIT — VARCHAR2(50)
- USE_YN — CHAR(1)
- RECV_TIME — CHAR(17) — NOT NULL
- DEAL_STAT — CHAR(1) — NOT NULL
- DEAL_DESC — VARCHAR2(1000)