마스터코드

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