맥스멤버스

테이블 (6)

mb_membership_h

  • mbr_no — varchar(15) — NOT NULL
  • use_yn — varchar(1) — NOT NULL
  • reg_ts — timestamp
  • regpsn_id — varchar(50)
  • mod_ts — timestamp
  • modpsn_id — varchar(50)
  • membership_no — varchar(15) — 외래 키 → mb_membership_m.membership_no — NOT NULL
  • membership_type_no — varchar(15) — 외래 키 → mb_membership_m.membership_type_no — NOT NULL — 멤버십유형번호

mb_membership_join_restrict_h

  • use_yn — varchar(1) — NOT NULL
  • reg_ts — timestamp
  • regpsn_id — varchar(50)
  • mod_ts — timestamp
  • modpsn_id — varchar(50)
  • membership_type_no — varchar(15) — 외래 키 → mb_membership_join_restrict_m.membership_type_no — NOT NULL
  • mbr_no — varchar(15) — 외래 키 → mb_membership_join_restrict_m.mbr_no — NOT NULL

mb_membership_join_restrict_m

  • membership_type_no — varchar(15) — 기본 키 — NOT NULL
  • mbr_no — varchar(15) — 기본 키 — NOT NULL
  • use_yn — varchar(1) — NOT NULL
  • reg_ts — timestamp
  • regpsn_id — varchar(50)
  • mod_ts — timestamp
  • modpsn_id — varchar(50)

mb_membership_m

  • membership_no — varchar(15) — 기본 키 — NOT NULL
  • membership_type_no — varchar(15) — 외래 키 → mb_membership_type_m.membership_type_no — NOT NULL — 멤버십유형번호
  • mbr_no — varchar(15) — NOT NULL
  • use_yn — varchar(1) — NOT NULL
  • reg_ts — timestamp
  • regpsn_id — varchar(50)
  • mod_ts — timestamp
  • modpsn_id — varchar(50)

mb_membership_type_benefit_m

  • membership_type_benefit_sn — varchar(15) — 기본 키 — NOT NULL
  • membership_type_no — varchar(15) — 외래 키 → mb_membership_type_m.membership_type_no — NOT NULL — 멤버십유형번호
  • use_yn — varchar(1) — NOT NULL
  • reg_ts — timestamp
  • regpsn_id — varchar(50)
  • mod_ts — timestamp
  • modpsn_id — varchar(50)

mb_membership_type_m

  • membership_type_no — varchar(15) — 기본 키 — NOT NULL — 멤버십유형번호
  • use_yn — varchar(1) — NOT NULL
  • reg_ts — timestamp
  • regpsn_id — varchar(50)
  • mod_ts — timestamp
  • modpsn_id — varchar(50)