마스터코드 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)