Gift-Club

Tables (4)

member

  • member_id — INT — Primary key — NOT NULL
  • member_email — VARCHAR(45) — NOT NULL
  • member_name — VARCHAR(45) — NOT NULL
  • member_password — VARCHAR(45) — NOT NULL
  • member_birth — VARCHAR(45) — NOT NULL
  • member_type_id — INT — Foreign key → member_type.member_type_id — NOT NULL

member_type

  • member_type_id — INT — Primary key — NOT NULL
  • member_type_name — VARCHAR(45) — NOT NULL

store

  • store_id — INT — Primary key — NOT NULL
  • store_name — VARCHAR(255) — NOT NULL
  • store_phone — VARHCHAR(255) — NOT NULL
  • store_introduce — VARCHAR(255) — NOT NULL
  • store_category_id — INT — Foreign key → store_category.store_category_id — NOT NULL
  • member_id — INT — Foreign key → member.member_id — NOT NULL

store_category

  • store_category_id — INT — Primary key — NOT NULL
  • store_category_name — VARCHAR(45) — NOT NULL