123123

Tables (11)

EAI_EQUIPMENTBM_RCV

  • UNISYSTEM_ID — VARCHAR2(4) — Primary key — NOT NULL
  • MESSAGE_ID — VARCHAR2(32) — Primary key — NOT NULL
  • DATE_TIME — VARCHAR2(18) — Primary key — NOT NULL
  • EQ_SN — VARCHAR2(50)
  • ITEM_CD — VARCHAR2(50)
  • SET_QY — VARCHAR2(50)
  • STT — CHAR(1)
  • MSG_TY — VARCHAR2(1)
  • RECV_TIME — CHAR(17) — NOT NULL
  • DEAL_STAT — CHAR(1) — NOT NULL
  • DEAL_DESC — VARCHAR2(1000)

EAI_EQUIPMENTMS_RCV

  • UNISYSTEM_ID — VARCHAR2(4) — Primary key — NOT NULL
  • MESSAGE_ID — VARCHAR2(32) — Primary key — NOT NULL
  • DATE_TIME — VARCHAR2(18) — Primary key — 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)
  • MSG_TY — VARCHAR2(1)
  • RECV_TIME — CHAR(17) — NOT NULL
  • DEAL_STAT — CHAR(1) — NOT NULL
  • DEAL_DESC — VARCHAR2(1000)

EAI_EQUIPMENTSP_RCV

  • UNISYSTEM_ID — VARCHAR2(4) — Primary key — NOT NULL
  • MESSAGE_ID — VARCHAR2(32) — Primary key — NOT NULL
  • DATE_TIME — VARCHAR2(18) — Primary key — 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)
  • MSG_TY — VARCHAR2(1)
  • RECV_TIME — CHAR(17) — NOT NULL
  • DEAL_STAT — CHAR(1) — NOT NULL
  • DEAL_DESC — VARCHAR2(1000)

EAI_FLOCATIONBM_RCV

  • UNISYSTEM_ID — VARCHAR2(4) — Primary key — NOT NULL
  • MESSAGE_ID — VARCHAR2(32) — Primary key — NOT NULL
  • DATE_TIME — VARCHAR2(18) — Primary key — NOT NULL
  • FNLC_SN — VARCHAR2(50)
  • ITEM_CD — VARCHAR2(50)
  • SET_QY — VARCHAR2(50)
  • STT — CHAR(1)
  • MSG_TY — VARCHAR2(1)
  • RECV_TIME — CHAR(17) — NOT NULL
  • DEAL_STAT — CHAR(1) — NOT NULL
  • DEAL_DESC — VARCHAR2(1000)

EAI_FLOCATIONMS_RCV

  • UNISYSTEM_ID — VARCHAR2(4) — Primary key — NOT NULL
  • MESSAGE_ID — VARCHAR2(32) — Primary key — NOT NULL
  • DATE_TIME — VARCHAR2(18) — Primary key — 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)
  • MSG_TY — VARCHAR2(1)
  • RECV_TIME — CHAR(17) — NOT NULL
  • DEAL_STAT — CHAR(1) — NOT NULL
  • DEAL_DESC — VARCHAR2(1000)

EAI_PINSPECTIONIT_RCV

  • UNISYSTEM_ID — VARCHAR2(4) — Primary key — NOT NULL
  • MESSAGE_ID — VARCHAR2(32) — Primary key — NOT NULL
  • DATE_TIME — VARCHAR2(18) — Primary key — 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)
  • MSG_TY — VARCHAR2(1)
  • RECV_TIME — CHAR(17) — NOT NULL
  • DEAL_STAT — CHAR(1) — NOT NULL
  • DEAL_DESC — VARCHAR2(1000)

EAI_PINSPECTIONMS_RCV

  • UNISYSTEM_ID — VARCHAR2(4) — Primary key — NOT NULL
  • MESSAGE_ID — VARCHAR2(32) — Primary key — NOT NULL
  • DATE_TIME — VARCHAR2(18) — Primary key — 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)
  • MSG_TY — VARCHAR2(1)
  • RECV_TIME — CHAR(17) — NOT NULL
  • DEAL_STAT — CHAR(1) — NOT NULL
  • DEAL_DESC — VARCHAR2(1000)

EAI_PINSPECTIONOD_RCV

  • UNISYSTEM_ID — VARCHAR2(4) — Primary key — NOT NULL
  • MESSAGE_ID — VARCHAR2(32) — Primary key — NOT NULL
  • DATE_TIME — VARCHAR2(18) — Primary key — 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)
  • MSG_TY — VARCHAR2(1)
  • RECV_TIME — CHAR(17) — NOT NULL
  • DEAL_STAT — CHAR(1) — NOT NULL
  • DEAL_DESC — VARCHAR2(1000)

EAI_PINSPECTIONRS_RCV

  • UNISYSTEM_ID — VARCHAR2(4) — Primary key — NOT NULL
  • MESSAGE_ID — VARCHAR2(32) — Primary key — NOT NULL
  • DATE_TIME — VARCHAR2(18) — Primary key — 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)
  • MSG_TY — VARCHAR2(1)
  • RECV_TIME — CHAR(17) — NOT NULL
  • DEAL_STAT — CHAR(1) — NOT NULL
  • DEAL_DESC — VARCHAR2(1000)

EAI_PINSPECTIONRS_SND

  • UNISYSTEM_ID — VARCHAR2(4) — Primary key — NOT NULL
  • MESSAGE_ID — VARCHAR2(32) — Primary key — NOT NULL
  • DATE_TIME — VARCHAR2(18) — Primary key — 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)
  • MSG_TY — VARCHAR2(1)
  • 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) — Primary key — NOT NULL
  • MESSAGE_ID — VARCHAR2(32) — Primary key — NOT NULL
  • DATE_TIME — VARCHAR2(18) — Primary key — 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)
  • MSG_TY — VARCHAR2(1)
  • RECV_TIME — CHAR(17) — NOT NULL
  • DEAL_STAT — CHAR(1) — NOT NULL
  • DEAL_DESC — VARCHAR2(1000)