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