환쿠폰
테이블 (5)
coupon
- id — BIGINT — 기본 키 — NOT NULL
- name — VARCHAR(255) — NOT NULL
- discount_type — VARCHAR(10) — NOT NULL
- discount_value — INT — NOT NULL
- total_quantity — INT
- issued_quantity — INT — NOT NULL
- min_order_amount — INT
- issue_type — VARCHAR(20) — NOT NULL
- issue_start_time — TIME
- issue_end_time — TIME
- expired_at — DATETIME(6) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
coupon_issue
- id — BIGINT — 기본 키 — NOT NULL
- coupon_id — BIGINT — 외래 키 → coupon.id — NOT NULL
- user_id — BIGINT — 외래 키 → member.id — NOT NULL
- status — VARCHAR(10) — NOT NULL
- issued_at — DATETIME(6) — NOT NULL
- used_at — DATETIME(6)
coupon_issue_batch
- id — BIGINT — 기본 키 — NOT NULL
- coupon_id — BIGINT — 외래 키 → coupon.id — NOT NULL
- target_count — INT — NOT NULL
- status — VARCHAR(20) — NOT NULL
- requested_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
- completed_at — DATETIME(6)
coupon_issue_request
- id — BIGINT — 기본 키 — NOT NULL
- coupon_id — BIGINT — 외래 키 → coupon.id — NOT NULL
- user_id — BIGINT — 외래 키 → member.id — NOT NULL
- status — VARCHAR(20) — NOT NULL
- requested_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
- completed_at — DATETIME(6)
- failure_reason — VARCHAR(255)
member
- id — BIGINT — 기본 키 — NOT NULL
- email — VARCHAR(255) — NOT NULL
- password — VARCHAR(255) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- birthdate — DATE — NOT NULL
- phone — VARCHAR(20) — NOT NULL
- role — VARCHAR(10) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL