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