fm
Tables (4)
address
- address_id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL
- recipient — VARCHAR(50) — NOT NULL
- phone — VARCHAR(20) — NOT NULL
- zipcode — VARCHAR(10) — NOT NULL
- road_address — VARCHAR(255) — NOT NULL
- detail_address — VARCHAR(255)
- is_default — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
cart
- cart_id — BIGINT — Primary key — NOT NULL
- member_id — BIGINT — Foreign key → member.member_id — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
member
- member_id — BIGINT — Primary key — NOT NULL
- provider_user_id — VARCHAR(100) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- nickname — VARCHAR(50) — NOT NULL
- name — VARCHAR(50)
- phone — VARCHAR(20)
- member_grade_id — BIGINT — Foreign key → member_grade.member_grade_id — NOT NULL
- is_marketing_agreed — BOOLEAN — NOT NULL
- status — VARCHAR(30) — NOT NULL
- termsAgreedAt — DATETIME
- deleted_at — DATETIME
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
member_grade
- member_grade_id — BIGINT — Primary key — NOT NULL
- name — VARCHAR(50) — NOT NULL
- discount_rate — DECIMAL(5,2) — NOT NULL
- promotion_rule — VARCHAR(255)
- is_default — BOOLEAN — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL