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