맥스멤버스
테이블 (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)