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