종합프로젝트
테이블 (5)
app_user
- user_id — BIGINT — 기본 키 — NOT NULL
- login_id — VARCHAR(100) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- email — VARCHAR(255)
- role — VARCHAR(30) — NOT NULL
- status — VARCHAR(30) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
coupon
- coupon_id — BIGINT — 기본 키 — NOT NULL
- event_id — BIGINT — 외래 키 → coupon_event.event_id — NOT NULL
- name — VARCHAR(150) — NOT NULL
- discount_type — VARCHAR(30) — NOT NULL
- discount_value — INT — NOT NULL
- min_order_amount — INT
- max_discount_amount — INT
- total_quantity — INT — NOT NULL
- remaining_quantity — INT — NOT NULL
- per_user_limit — INT — NOT NULL
- issue_start_at — DATETIME — NOT NULL
- issue_end_at — DATETIME — NOT NULL
- valid_days — INT
- status — VARCHAR(30) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
coupon_event
- event_id — BIGINT — 기본 키 — NOT NULL
- created_by — BIGINT — 외래 키 → app_user.user_id — NOT NULL
- name — VARCHAR(150) — NOT NULL
- description — VARCHAR(1000)
- open_at — DATETIME
- start_at — DATETIME — NOT NULL
- end_at — DATETIME — NOT NULL
- status — VARCHAR(30) — NOT NULL
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
coupon_issue
- coupon_issue_id — BIGINT — 기본 키 — NOT NULL
- coupon_id — BIGINT — 외래 키 → coupon.coupon_id — NOT NULL
- user_id — BIGINT — 외래 키 → app_user.user_id — NOT NULL
- request_id — VARCHAR(100) — NOT NULL
- sequence_no — BIGINT — NOT NULL
- status — VARCHAR(30) — NOT NULL
- issued_at — DATETIME — NOT NULL
- used_at — DATETIME
- canceled_at — DATETIME
- expired_at — DATETIME
- created_at — DATETIME — NOT NULL
- updated_at — DATETIME — NOT NULL
reconciliation_report
- report_id — BIGINT — 기본 키 — NOT NULL
- coupon_id — BIGINT — 외래 키 → coupon.coupon_id — NOT NULL
- as_of_at — DATETIME — NOT NULL
- total_quantity — INT — NOT NULL
- db_issued_count — INT — NOT NULL
- db_remaining — INT — NOT NULL
- redis_remaining — INT — NOT NULL
- difference_quantity — INT — NOT NULL
- result — VARCHAR(30) — NOT NULL
- started_at — DATETIME — NOT NULL
- finished_at — DATETIME
- created_at — DATETIME — NOT NULL