마스터코드
테이블 (6)
MaruHeader (TB_MR_HEADER)
- maruId (maru_id) — VARCHAR2(30) — 기본 키 — NOT NULL
- currentVersion (current_ver) — number
- maruName (maru_name) — VARCHAR2(50)
- maruType (maru_tp) — VARCHAR2(5)
- progressStatus (progress_status) — VARCHAR2(5)
- systemCode (system_code) — VARCHAR2(20)
- subSystemCode (sub_system_code) — VARCHAR2(20)
- description — VARCHAR2(1000)
MaruMasterCodeBase (TB_MR_MC_BASE)
- code — VARCHAR2(20) — 기본 키 — NOT NULL
- maruVersion (maru_version) — number — 외래 키 → MaruVersion.maruVersion — NOT NULL
- maruId (maru_id) — VARCHAR2(30) — 외래 키 → MaruVersion.maruId — NOT NULL
- decode — VARCHAR2(100)
- seq — number
MaruMasterCodeGroup (TB_MR_MC_GRP)
- groupId (group_id) — VARCHAR2(30) — 기본 키 — NOT NULL
- maruVersion (maru_version) — number — 외래 키 → MaruVersion.maruVersion — NOT NULL
- maruId (maru_id) — VARCHAR2(30) — 외래 키 → MaruVersion.maruId — NOT NULL
- groupName (group_name) — VARCHAR2(100)
- expression — VARCHAR2(100) — NOT NULL
- codeType (Field) — VARCHAR2(20)
MaruMasterCodeGroupMember (TB_MR_MC_GRP_MBR)
- code — VARCHAR2(20) — 외래 키 → MaruMasterCodeBase.code — NOT NULL
- maruId (maru_id) — VARCHAR2(30) — 외래 키 → MaruMasterCodeBase.maruId — NOT NULL
- groupId (group_id) — VARCHAR2(30) — 외래 키 → MaruMasterCodeGroup.groupId — NOT NULL
- maruVersion (maru_version) — number — 외래 키 → MaruMasterCodeGroup.maruVersion — NOT NULL
- alterDecode (alter_decode) — VARCHAR2(100)
- seq — number
MaruVersion (TB_MR_VER)
- maruVersion (maru_version) — number — 기본 키 — NOT NULL
- maruId (maru_id) — VARCHAR2(30) — 외래 키 → MaruHeader.maruId — NOT NULL
- description — VARCHAR2(1000)
MaruVersionHistory (TB_MR_VER_HISTORY)
- historyId (history_id) — VARCHAR2(30) — 기본 키 — NOT NULL
- maruVersion (maru_version) — number — 외래 키 → MaruVersion.maruVersion — NOT NULL
- maruId (maru_id) — VARCHAR2(30) — 외래 키 → MaruVersion.maruId — NOT NULL
- activeStartDate (act_str_dh) — DATE
- activeEndDate (act_end_dh) — DATE