member_erd
Tables (5)
login
- login_code — varchar(50) — Primary key — NOT NULL
- log_date — DATE
- logout_date — DATE
- member_id — varchar(50) — Foreign key → member.member_id — NOT NULL
mem_level
- mem_level_code — VARCHAR(50) — Primary key — NOT NULL
- membership_rating — VARCHAR(50)
- System_registration_time — DATE
- member_id — varchar(50) — Foreign key → member.member_id — NOT NULL
member
- member_id — varchar(50) — Primary key — NOT NULL
- mem_level_code — varchar(50)
- mem_position — varchar(50)
- member_pw — varchar(50)
- member_email — varchar(50)
- member_name — varchar(50)
- member_birth — DATE
- member_gender — varchar(50)
- member_phone — varchar(50)
- member_addr — varchar(50)
- member_regdate — DATE
- final_mileage — INT
- accumulated_payment_amount — INT
- memberState — varchar(50)
withdrawl_member
- withdrawl_code — varchar(50) — Primary key — NOT NULL
- withdrawl_member_category_choice_code — varchar(50)
- member_id — varchar(50) — Foreign key → member.member_id — NOT NULL
- withdrawl_member_category_code — varchar(50) — Foreign key → withdrawl_member_category.withdrawl_member_category_code — NOT NULL
withdrawl_member_category
- withdrawl_member_category_code — varchar(50) — Primary key — NOT NULL
- withdraw_member_category_context_num — varchar(50)
- withdrawl_member_category_context — varchar(50)
- System_registration_time — DATETIME
- member_id — varchar(50) — Foreign key → member.member_id — NOT NULL