payments
Tables (9)
coupon
- id — BIGINT — Primary key — NOT NULL
- code — VARCHAR(64) — NOT NULL
- discount_type — ENUM('FIXED','PERCENT') — NOT NULL
- discount_value — BIGINT — NOT NULL
- min_order_amount_krw — BIGINT — NOT NULL
- status — ENUM('ACTIVE','EXPIRED','INACTIVE') — NOT NULL
- valid_from — DATETIME(3)
- valid_to — DATETIME(3)
- created_at — DATETIME(3) — NOT NULL
coupon_reservation
- id — BIGINT — Primary key — NOT NULL
- coupon_id — BIGINT — Foreign key → coupon.id — NOT NULL
- order_id — BIGINT — Foreign key → order.id — NOT NULL
- status — ENUM('RESERVED','USED','RELEASED') — NOT NULL
- reserved_at — DATETIME(3) — NOT NULL
- used_at — DATETIME(3)
- released_at — DATETIME(3)
order
- id — BIGINT — Primary key — NOT NULL
- external_id — VARCHAR(64) — NOT NULL
- user_id — BIGINT — Foreign key → user.id
- total_amount_krw — BIGINT — NOT NULL
- currency — CHAR(3) — NOT NULL
- status — ENUM('PENDING','PAID','CANCELED','FAILED') — NOT NULL
- coupon_id — BIGINT — Foreign key → coupon.id
- created_at — DATETIME(3) — NOT NULL
- updated_at — DATETIME(3) — NOT NULL
order_line
- id — BIGINT — Primary key — NOT NULL
- order_id — BIGINT — Foreign key → order.id — NOT NULL
- product_id — BIGINT — Foreign key → product.id — NOT NULL
- unit_price_krw — BIGINT — NOT NULL
- quantity — INT — NOT NULL
- line_amount_krw — BIGINT — NOT NULL
payment
- id — BIGINT — Primary key — NOT NULL
- order_id — BIGINT — Foreign key → order.id — NOT NULL
- provider — ENUM('TOSS') — NOT NULL
- provider_payment_key — VARCHAR(128) — NOT NULL
- method — VARCHAR(32) — NOT NULL
- amount_krw — BIGINT — NOT NULL
- status — ENUM('INIT','PAID','PARTIAL_REFUND','REFUNDED','CANCELED','FAILED') — NOT NULL
- approved_at — DATETIME(3)
- raw_payload — JSON
- created_at — DATETIME(3) — NOT NULL
- updated_at — DATETIME(3) — NOT NULL
payment_webhook_event
- id — BIGINT — Primary key — NOT NULL
- event_id — VARCHAR(128) — NOT NULL
- payment_key — VARCHAR(128)
- event_type — VARCHAR(64) — NOT NULL
- signature_valid — TINYINT(1) — NOT NULL
- received_at — DATETIME(3) — NOT NULL
- processed_at — DATETIME(3)
- payload — JSON
product
- id — BIGINT — Primary key — NOT NULL
- sku — VARCHAR(64) — NOT NULL
- name — VARCHAR(255) — NOT NULL
- list_price_krw — BIGINT — NOT NULL
- tax_rate_pct — DECIMAL(5,2) — NOT NULL
- active — TINYINT(1) — NOT NULL
- created_at — DATETIME(3) — NOT NULL
- updated_at — DATETIME(3) — NOT NULL
refund
- id — BIGINT — Primary key — NOT NULL
- payment_id — BIGINT — Foreign key → payment.id — NOT NULL
- amount_krw — BIGINT — NOT NULL
- reason — VARCHAR(255)
- status — ENUM('REQUESTED','DONE','FAILED') — NOT NULL
- requested_at — DATETIME(3) — NOT NULL
- approved_at — DATETIME(3)
- raw_payload — JSON
user
- id — BIGINT — Primary key — NOT NULL
- email — VARCHAR(255) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- created_at — DATETIME(3) — NOT NULL