연계

테이블 (3)

IRM_CRST_INFO_SYS

  • CRST_INFO_SYS_NO — CHAR(20) — 기본 키 — NOT NULL
  • INST_MNG_NO — CHAR(10) — NOT NULL
  • CRST_INFO_SYS_NM — VARCHAR(500) — NOT NULL
  • CRST_INFO_SYS_TYPE — VARCHAR(100)
  • RLTD_DCE — VARCHAR(4000)
  • CRGMN_INST_NM — VARCHAR(200)
  • OPER_INST — VARCHAR(200) — NOT NULL
  • OPER_PIC — VARCHAR(500)
  • OPER_DEPT — VARCHAR(500) — NOT NULL
  • CRST_INFO_SYS_GOAL — VARCHAR(4000)
  • CRST_INFO_SYS_MAIN_FCN — VARCHAR(4000)
  • SRVC_TRGT — VARCHAR(100)
  • SUB_SYS — VARCHAR(500)
  • BLD_YM — DATE
  • CRST_INFO_SYS_OPER_SE — VARCAHR(100)
  • TRNSF_TRGT_INST — VARCHAR(200)
  • Field — DATE
  • DSCD_RSN — VARCHAR(100)
  • DSCD_YR — CHAR(4)
  • IMPRV_SYS_NM — VARCHAR(500)
  • ETC_IMPRV_SYS_NM — VARCHAR(500)
  • INFO_RLS_LV — CHAR(4)
  • INFO_SYS_IDNTF_CD — VARCHAR(20)
  • DEL_YN — CHAR(1) — NOT NULL
  • FRST_REG_DT — DATE — NOT NULL
  • LAST_MDFCN_DT — VARCHAR(255) — NOT NULL

IRM_CRST_INFO_SYS_SW_MAP

  • SW_MAP_NO — CHAR(20) — 기본 키 — NOT NULL
  • CRST_INFO_SYS_NO — CHAR(20) — 외래 키 → IRM_CRST_INFO_SYS.CRST_INFO_SYS_NO — NOT NULL
  • SW_NM — VARCHAR(500) — NOT NULL
  • SW_SE — VARCHAR(100) — NOT NULL
  • SW_TYPE — VARCHAR(100)
  • SW_TYPE_ETC_CN — VARCHAR(1000)
  • SW_DTL_TYPE — VARCHAR(100)
  • SW_VEN_NM — VARCHAR(100) — NOT NULL
  • SW_VEN_NM_ETC_CN — VARCHAR(1000)
  • SW_PRDCT_NM — VARCHAR(500)
  • SW_VER — VARCHAR(100)
  • INTRO_YM — DATE
  • OPER_PIC — VARCHAR(100)
  • OPER_DEPT — VARCHAR(500)
  • DEL_YN — CHAR(1) — NOT NULL
  • FRST_REG_DT — DATETIME — NOT NULL
  • LAST_MDFCN_DT — DATETIME — NOT NULL

IRM_LINK_INFO_SYS

  • LINK_INFO_SYS_NO — CHAR(20) — 기본 키 — NOT NULL
  • CRST_INFO_SYS_NO — CHAR(20) — 외래 키 → IRM_CRST_INFO_SYS.CRST_INFO_SYS_NO — NOT NULL
  • INST_MNG_NO — CHAR(10) — NOT NULL
  • LINK_SE — CHAR(20)
  • LINK_TRGT_SYS_HAVE_INST — VARCHAR(200)
  • LINK_INFO_SYS_NM — VARCHAR(500)
  • LINK_INFO_CN — VARCHAR(1000)
  • DEL_YN — CHAR(1) — NOT NULL
  • FRST_REG_DT — DATE — NOT NULL
  • LAST_MDFCN_DT — DATE — NOT NULL