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