Coupon
Tables (3)
Coupon (Untitled2)
- id (PK) — Primary key — NOT NULL
- name (쿠폰 이름)
- total_stock (쿠폰 재고)
- available_stock (남은 재고)
- start_at (시작시각)
- end_at (종료시각)
Coupon_ISSUE (Untitled3)
- id (PK) — Primary key — NOT NULL
- member_id (PK2) — Foreign key → Member.id — NOT NULL
- coupon_id (PK3) — Foreign key → Coupon.id — NOT NULL
- datetime (issued_at)
Member (Untitled)
- id (PK) — Primary key — NOT NULL
- nickname (닉네임)