coupon

Tables (4)

coupon_issues

  • id — BIGINT — Primary key — NOT NULL
  • issue_code — UUID — NOT NULL
  • is_used — BOOLEAN — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • coupon_id — BIGINT — Foreign key → coupons.id — NOT NULL

coupons

  • id — BIGINT — Primary key — NOT NULL
  • total_quantity — INT — NOT NULL
  • issued_quantity — INT — NOT NULL

refresh_token

  • id — BIGINT — Primary key — NOT NULL
  • user_id — BIGINT — Foreign key → users.id — NOT NULL
  • token — VARCHAR — NOT NULL

users

  • id — BIGINT — Primary key — NOT NULL
  • email — VARCHAR — NOT NULL
  • password — VARCHAR — NOT NULL