마스터코드 Eid
테이블 (5)
MaruHeader (TB_MR_HEADER)
- maruId (maru_id) — 기본 키 — NOT NULL
- maruEid (maru_Eid) — 기본 키 — NOT NULL
- currentVersion (current_ver)
- maruNameEn (maru_name_en)
- maruNameKo (maru_name_ko)
- maruTp (maru_tp)
- progressStatus (progress_status)
- systemCode (system_code)
- subSystemCode (sub_system_code)
- description
MaruVersion (TB_MR_VER)
- maruVersionEid (maru_ver_eid) — 기본 키 — NOT NULL
- maruVer (maru_ver)
- description
- maruId (maru_id) — 외래 키 → MaruHeader.maruId — NOT NULL
- Key — 외래 키 → MaruHeader.maruEid — NOT NULL
MasterCodeBase (TB_MR_MC_BASE)
- code — 기본 키 — NOT NULL
- maruVersionEid (maru_ver_eid) — 외래 키 → MaruVersion.maruVersionEid — NOT NULL
- Key — 외래 키 → MaruVersion.Key — NOT NULL
- decode
- sequence (seq)
MasterCodeGroup (TB_MR_MC_GRP)
- masterCodeGroupEid (group_eid) — 기본 키 — NOT NULL
- maruVersionEid (maru_ver_eid) — 외래 키 → MaruVersion.maruVersionEid — NOT NULL
- Key — 외래 키 → MaruVersion.Key — NOT NULL
- groupId (group_id)
- groupName (group_name)
- expression — NOT NULL
MasterCodeGroupMember (TB_MR_MC_GRP_MBR)
- masterCodeGroupEid (group_eid) — 외래 키 → MasterCodeGroup.masterCodeGroupEid — NOT NULL
- code — 외래 키 → MasterCodeBase.code — NOT NULL
- maruVersionEid (maru_ver_eid) — 외래 키 → MasterCodeBase.maruVersionEid — NOT NULL
- Key — 외래 키 → MasterCodeGroup.Key — NOT NULL
- codeAlias (code_alias)
- sequence (seq)