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