패캠
테이블 (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)