멋사
테이블 (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