ssapg
Tables (9)
audit_logs
- id — BIGSERIAL
- actor_type — TEXT — NOT NULL
- actor_id — TEXT
- action — TEXT — NOT NULL
- resource — TEXT — NOT NULL
- metadata — JSONB
- created_at — TIMESTAMPTZ — NOT NULL
card_issuer_cache
- card_issuer_code — TEXT
- card_issuer_name — TEXT — NOT NULL
- fetched_at — TIMESTAMPTZ — NOT NULL
category_cache
- category_id — TEXT
- category_name — TEXT — NOT NULL
- category_description — TEXT
- fetched_at — TIMESTAMPTZ — NOT NULL
checkout_sessions
- session_id — UUID
- merchant_id — TEXT — NOT NULL
- order_id — TEXT — NOT NULL
- amount — BIGINT — NOT NULL
- currency — TEXT — NOT NULL
- status — checkout_status — NOT NULL
- success_url — TEXT — NOT NULL
- cancel_url — TEXT — NOT NULL
- user_context — JSONB
- idempotency_key — TEXT — NOT NULL
- ssafy_transaction_unique_no — TEXT
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
- completed_at — TIMESTAMPTZ
idempotency_keys
- merchant_id — TEXT — Primary key — NOT NULL
- endpoint — TEXT — Primary key — NOT NULL
- session_id — UUID
- payment_id — UUID
- response_hash — TEXT
- created_at — TIMESTAMPTZ — NOT NULL
merchant_cache
- merchant_id — TEXT
- category_id — TEXT — NOT NULL
- category_name — TEXT — NOT NULL
- merchant_name — TEXT — NOT NULL
- fetched_at — TIMESTAMPTZ — NOT NULL
payments
- payment_id — UUID
- session_id — UUID — NOT NULL
- merchant_id — TEXT — NOT NULL
- order_id — TEXT — NOT NULL
- amount — BIGINT — NOT NULL
- currency — TEXT — NOT NULL
- status — payment_status — NOT NULL
- ssafy_transaction_unique_no — TEXT
- ssafy_card_no_masked — TEXT
- failure_code — TEXT
- failure_message — TEXT
- metadata — JSONB
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
webhook_delivery_log
- id — BIGSERIAL
- event_id — UUID — NOT NULL
- attempt_no — INT — NOT NULL
- http_status — INT
- latency_ms — INT
- error_message — TEXT
- created_at — TIMESTAMPTZ — NOT NULL
webhook_outbox
- id — BIGSERIAL
- event_id — UUID — NOT NULL
- event_type — TEXT — NOT NULL
- destination_url — TEXT — NOT NULL
- headers — JSONB — NOT NULL
- payload — JSONB — NOT NULL
- status — outbox_status — NOT NULL
- retry_count — INT — NOT NULL
- next_attempt_at — TIMESTAMPTZ — NOT NULL
- error_message — TEXT
- created_at — TIMESTAMPTZ — NOT NULL
- processed_at — TIMESTAMPTZ