멋사

테이블 (3)

Coupon

  • coupon_id — BIGINT — 기본 키 — NOT NULL
  • type — ENUM('PERCENTAGE', 'FIXED_AMOUNT')
  • discount — INTEGER
  • issue_date — DATETIME
  • expiration_date — DATETIME

CouponHolders

  • member_coupon_id — BIGINT — 기본 키 — NOT NULL
  • coupon_id — BIGINT — 외래 키 → Coupon.coupon_id — NOT NULL
  • member_id — BIGINT — 외래 키 → Member.member_id — NOT NULL

Member

  • member_id — BIGINT — 기본 키 — NOT NULL
  • email — VARCHAR(30)
  • password — VARCHAR(20)
  • role — ENUM('ADMIN', 'USER')
  • name — VARCHAR(5)
  • age — SMALLINT
  • is_account_expired — BOOLEAN
  • is_account_locked — BOOLEAN