패캠

테이블 (5)

merchants

  • merchant_id — varchar(255) — 기본 키 — NOT NULL
  • name — varchar(255)

payment_requests

  • payment_request_id — varchar(255) — 기본 키 — NOT NULL
  • version — integer — NOT NULL
  • amount_value — bigint
  • created_at — timestamp(6)
  • failed_at — timestamp(6)
  • success_at — timestamp(6)
  • updated_at — timestamp(6)
  • status — varchar(255)
  • merchant_id (merchant_id2) — varchar(255) — 외래 키 → merchants.merchant_id — NOT NULL

payments

  • payment_id — varchar(255) — 기본 키 — NOT NULL
  • payment_request_id (payment_request_id2) — varchar(255) — 외래 키 → payment_requests.payment_request_id — NOT NULL
  • version — integer — NOT NULL
  • amount_value — bigint
  • cancelled_at — timestamp(6)
  • created_at — timestamp(6)
  • expired_at — timestamp(6)
  • failed_at — timestamp(6)
  • success_at — timestamp(6)
  • updated_at — timestamp(6)
  • merchant_id — varchar(255)
  • status — varchar(255)
  • user_id — varchar(255) — 외래 키 → users.user_id — NOT NULL

user_balances

  • user_balance_id — varchar(255) — 기본 키 — NOT NULL
  • user_id (user_id2) — varchar(255) — 외래 키 → users.user_id — NOT NULL
  • version — integer — NOT NULL
  • balance — bigint

users

  • user_id — varchar(255) — 기본 키 — NOT NULL
  • name — varchar(255)