연계
테이블 (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