sag

Tables (4)

idempotency_tokens

  • id — BIGINT
  • purpose — VARCHAR(50) — NOT NULL
  • token — VARCHAR(120) — NOT NULL
  • request_hash — VARCHAR(128)
  • order_id — BIGINT
  • response_snapshot — CLOB
  • created_at — TIMESTAMP — NOT NULL

order_items

  • id — BIGINT
  • order_id — BIGINT — NOT NULL
  • name — VARCHAR(200) — NOT NULL
  • qty — INT — NOT NULL
  • price — BIGINT — NOT NULL
  • partner_item_code — VARCHAR(120)

orders

  • id — BIGINT
  • merchant_order_id — VARCHAR(100) — NOT NULL
  • partner_code — VARCHAR(50) — NOT NULL
  • partner_order_id — VARCHAR(120)
  • status — VARCHAR(20) — NOT NULL
  • amount — BIGINT — NOT NULL
  • currency — VARCHAR(10) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL
  • updated_at — TIMESTAMP — NOT NULL
  • version — INT — NOT NULL

partner_call_logs

  • id — BIGINT
  • partner_code — VARCHAR(50) — NOT NULL
  • api — VARCHAR(20) — NOT NULL
  • request_body — CLOB — NOT NULL
  • response_body — CLOB
  • http_status — INT
  • success — BOOLEAN — NOT NULL
  • elapsed_ms — INT — NOT NULL
  • order_id — BIGINT
  • created_at — TIMESTAMP — NOT NULL