v1
Tables (44)
ADDRESS
- id — UUID — Primary key — NOT NULL
- user_id — UUID — Foreign key → USER.id
- recipient_name — VARCHAR(100)
- phone — VARCHAR(30)
- postal_code — VARCHAR(20)
- address1 — VARCHAR(255)
- address2 — VARCHAR(255)
- delivery_memo — VARCHAR(255)
- is_default — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- deleted_at — TIMESTAMP
AGENT_CLIENT
- id — UUID — Primary key — NOT NULL
- client_id — VARCHAR(100)
- client_secret_hash — VARCHAR(255)
- name — VARCHAR(200)
- redirect_uri — TEXT
- status — VARCHAR(30)
- created_at — TIMESTAMP
AGENT_CONNECTION
- id — UUID — Primary key — NOT NULL
- user_id — UUID — Foreign key → USER.id
- agent_client_id — UUID — Foreign key → AGENT_CLIENT.id
- scopes — JSONB
- connected_at — TIMESTAMP
- revoked_at — TIMESTAMP
AGENT_TOKEN
- id — UUID — Primary key — NOT NULL
- connection_id — UUID — Foreign key → AGENT_CONNECTION.id
- token_type — VARCHAR(30)
- token_hash — VARCHAR(255)
- expires_at — TIMESTAMP
- revoked_at — TIMESTAMP
AUDIT_LOG
- id — UUID — Primary key — NOT NULL
- user_id — UUID — Foreign key → USER.id
- actor_type — VARCHAR(30)
- actor_id — VARCHAR(100)
- entity_type — VARCHAR(50)
- entity_id — UUID
- action — VARCHAR(50)
- before_state — JSONB
- after_state — JSONB
- created_at — TIMESTAMP
BIOMETRIC_CREDENTIAL
- id — UUID — Primary key — NOT NULL
- user_id — UUID — Foreign key → USER.id
- device_id — VARCHAR(255)
- credential_type — VARCHAR(50)
- public_key — TEXT
- registered_at — TIMESTAMP
- revoked_at — TIMESTAMP
CART
- id — UUID — Primary key — NOT NULL
- user_id — UUID — Foreign key → USER.id
- status — VARCHAR(30)
- version — BIGINT
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
CART_ITEM
- id — UUID — Primary key — NOT NULL
- cart_id — UUID — Foreign key → CART.id
- product_id — UUID — Foreign key → PRODUCT.id
- quantity — INT
- added_price — DECIMAL(14,2)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
CART_ITEM_OPTION
- id — UUID — Primary key — NOT NULL
- cart_item_id — UUID — Foreign key → CART_ITEM.id
- option_value_id — UUID — Foreign key → PRODUCT_OPTION_VALUE.id
EXTERNAL_PRODUCT_MAPPING
- id — UUID — Primary key — NOT NULL
- product_id — UUID — Foreign key → PRODUCT.id
- provider — VARCHAR(50)
- external_product_id — VARCHAR(100)
- external_url — TEXT
- last_synced_at — TIMESTAMP
IDEMPOTENCY_RECORD
- id — UUID — Primary key — NOT NULL
- user_id — UUID — Foreign key → USER.id
- idempotency_key — UUID
- operation — VARCHAR(50)
- request_hash — VARCHAR(255)
- response_status — INT
- response_body — JSONB
- resource_type — VARCHAR(50)
- resource_id — UUID
- created_at — TIMESTAMP
- expires_at — TIMESTAMP
ORDERS
- id — UUID — Primary key — NOT NULL
- user_id — UUID — Foreign key → USER.id
- order_snapshot_id — UUID — Foreign key → ORDER_SNAPSHOT.id
- payment_group_id — UUID — Foreign key → PAYMENT_GROUP.id
- order_number — VARCHAR(50)
- status — VARCHAR(30)
- total_product_amount — DECIMAL(14,2)
- shipping_amount — DECIMAL(14,2)
- total_amount — DECIMAL(14,2)
- currency — CHAR(3)
- recipient_name — VARCHAR(100)
- recipient_phone — VARCHAR(30)
- postal_code — VARCHAR(20)
- address1 — VARCHAR(255)
- address2 — VARCHAR(255)
- delivery_memo — VARCHAR(255)
- payment_brand — VARCHAR(50)
- payment_last4 — CHAR(4)
- ordered_at — TIMESTAMP
- updated_at — TIMESTAMP
ORDER_ITEM
- id — UUID — Primary key — NOT NULL
- seller_order_id — UUID — Foreign key → SELLER_ORDER.id
- product_id — UUID — Foreign key → PRODUCT.id
- product_name — VARCHAR(255)
- external_product_id — VARCHAR(100)
- quantity — INT
- unit_price — DECIMAL(14,2)
- total_price — DECIMAL(14,2)
- created_at — TIMESTAMP
ORDER_ITEM_OPTION
- id — UUID — Primary key — NOT NULL
- order_item_id — UUID — Foreign key → ORDER_ITEM.id
- option_name — VARCHAR(100)
- option_value — VARCHAR(100)
- additional_price — DECIMAL(14,2)
ORDER_SNAPSHOT
- id — UUID — Primary key — NOT NULL
- validation_id — UUID — Foreign key → ORDER_VALIDATION.id
- user_id — UUID — Foreign key → USER.id
- cart_id — UUID — Foreign key → CART.id
- cart_version — BIGINT
- total_product_amount — DECIMAL(14,2)
- shipping_amount — DECIMAL(14,2)
- total_amount — DECIMAL(14,2)
- currency — CHAR(3)
- recipient_name — VARCHAR(100)
- recipient_phone — VARCHAR(30)
- postal_code — VARCHAR(20)
- address1 — VARCHAR(255)
- address2 — VARCHAR(255)
- delivery_memo — VARCHAR(255)
- payment_brand — VARCHAR(50)
- payment_last4 — CHAR(4)
- created_at — TIMESTAMP
ORDER_SNAPSHOT_ITEM
- id — UUID — Primary key — NOT NULL
- order_snapshot_id — UUID — Foreign key → ORDER_SNAPSHOT.id
- product_id — UUID — Foreign key → PRODUCT.id
- seller_id — UUID — Foreign key → SELLER.id
- product_name — VARCHAR(255)
- quantity — INT
- unit_price — DECIMAL(14,2)
- total_price — DECIMAL(14,2)
- external_product_id — VARCHAR(100)
ORDER_SNAPSHOT_ITEM_OPTION
- id — UUID — Primary key — NOT NULL
- snapshot_item_id — UUID — Foreign key → ORDER_SNAPSHOT_ITEM.id
- option_name — VARCHAR(100)
- option_value — VARCHAR(100)
- additional_price — DECIMAL(14,2)
ORDER_SNAPSHOT_SELLER
- id — UUID — Primary key — NOT NULL
- order_snapshot_id — UUID — Foreign key → ORDER_SNAPSHOT.id
- seller_id — UUID — Foreign key → SELLER.id
- product_amount — DECIMAL(14,2)
- shipping_amount — DECIMAL(14,2)
- total_amount — DECIMAL(14,2)
ORDER_VALIDATION
- id — UUID — Primary key — NOT NULL
- user_id — UUID — Foreign key → USER.id
- cart_id — UUID — Foreign key → CART.id
- cart_version — BIGINT
- address_id — UUID — Foreign key → ADDRESS.id
- payment_method_id — UUID — Foreign key → PAYMENT_METHOD.id
- status — VARCHAR(30)
- failure_reason — VARCHAR(255)
- created_at — TIMESTAMP
- validated_at — TIMESTAMP
PAYMENT
- id — UUID — Primary key — NOT NULL
- payment_group_id — UUID — Foreign key → PAYMENT_GROUP.id
- seller_id — UUID — Foreign key → SELLER.id
- amount — DECIMAL(14,2)
- status — VARCHAR(30)
- pg_provider — VARCHAR(50)
- pg_transaction_id — VARCHAR(100)
- failure_code — VARCHAR(50)
- failure_message — VARCHAR(255)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- completed_at — TIMESTAMP
PAYMENT_APPROVAL
- id — UUID — Primary key — NOT NULL
- user_id — UUID — Foreign key → USER.id
- order_snapshot_id — UUID — Foreign key → ORDER_SNAPSHOT.id
- status — VARCHAR(30)
- expires_at — TIMESTAMP
- approved_at — TIMESTAMP
- rejected_at — TIMESTAMP
- rejection_reason — VARCHAR(255)
- authentication_type — VARCHAR(50)
- created_at — TIMESTAMP
PAYMENT_GROUP
- id — UUID — Primary key — NOT NULL
- approval_id — UUID — Foreign key → PAYMENT_APPROVAL.id
- order_snapshot_id — UUID — Foreign key → ORDER_SNAPSHOT.id
- status — VARCHAR(30)
- total_amount — DECIMAL(14,2)
- created_at — TIMESTAMP
- completed_at — TIMESTAMP
PAYMENT_METHOD
- id — UUID — Primary key — NOT NULL
- user_id — UUID — Foreign key → USER.id
- pg_provider — VARCHAR(50)
- payment_token — VARCHAR(255)
- brand — VARCHAR(50)
- last4 — CHAR(4)
- is_default — BOOLEAN
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- deleted_at — TIMESTAMP
PAYMENT_PIN
- user_id — UUID — Foreign key → USER.id — NOT NULL
- pin_hash — VARCHAR(255)
- failed_attempts — INT
- blocked_until — TIMESTAMP
- updated_at — TIMESTAMP
PAYMENT_REFUND
- id — UUID — Primary key — NOT NULL
- payment_id — UUID — Foreign key — NOT NULL
- return_request_id — UUID — Foreign key → RETURN_REQUEST.id — NOT NULL
- amount — BIGINT — NOT NULL
- status — VARCHAR(20) — NOT NULL
- pg_refund_transaction_id — VARCHAR(100)
- requested_at — TIMESTAMPTZ — NOT NULL
- completed_at — TIMESTAMPTZ
PRODUCT
- id — UUID — Primary key — NOT NULL
- seller_id — UUID — Foreign key → SELLER.id
- name — VARCHAR(255)
- description — TEXT
- current_price — DECIMAL(14,2)
- currency — CHAR(3)
- stock_quantity — INT
- status — VARCHAR(30)
- synced_at — TIMESTAMP
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
PRODUCT_IMAGE
- id — UUID — Primary key — NOT NULL
- product_id — UUID — Foreign key → PRODUCT.id
- image_url — TEXT
- display_order — INT
- is_primary — BOOLEAN
PRODUCT_OPTION
- id — UUID — Primary key — NOT NULL
- product_id — UUID — Foreign key → PRODUCT.id
- name — VARCHAR(100)
- display_order — INT
PRODUCT_OPTION_VALUE
- id — UUID — Primary key — NOT NULL
- product_option_id — UUID — Foreign key → PRODUCT_OPTION.id
- value — VARCHAR(100)
- additional_price — DECIMAL(14,2)
- external_option_value_id — VARCHAR(100)
- status — VARCHAR(30)
REFRESH_TOKEN
- id — UUID — Primary key — NOT NULL
- user_id — UUID — Foreign key → USER.id
- token_hash — VARCHAR(255)
- expires_at — TIMESTAMP
- revoked_at — TIMESTAMP
- created_at — TIMESTAMP
RETURN_REQUEST
- id — UUID — Primary key — NOT NULL
- seller_order_id — UUID — Foreign key — NOT NULL
- user_id — UUID — Foreign key — NOT NULL
- type — VARCHAR(20) — NOT NULL
- reason_code — VARCHAR(50) — NOT NULL
- reason_detail — VARCHAR(500)
- status — VARCHAR(20) — NOT NULL
- requested_at — TIMESTAMPTZ — NOT NULL
- processed_at — TIMESTAMPTZ
RETURN_REQUEST_ITEM
- id — UUID — Primary key — NOT NULL
- return_request_id — UUID — Foreign key → RETURN_REQUEST.id — NOT NULL
- order_item_id — UUID — Foreign key — NOT NULL
- quantity — INT — NOT NULL
SELLER
- id — UUID — Primary key — NOT NULL
- name — VARCHAR(200)
- external_source — VARCHAR(50)
- external_seller_id — VARCHAR(100)
- created_at — TIMESTAMP
SELLER_ORDER
- id — UUID — Primary key — NOT NULL
- order_id — UUID — Foreign key → ORDERS.id
- seller_id — UUID — Foreign key → SELLER.id
- payment_id — UUID — Foreign key → PAYMENT.id
- seller_order_number — VARCHAR(50)
- status — VARCHAR(30)
- product_amount — DECIMAL(14,2)
- shipping_amount — DECIMAL(14,2)
- total_amount — DECIMAL(14,2)
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
USER
- id — UUID — Primary key — NOT NULL
- email — VARCHAR(255)
- name — VARCHAR(100)
- provider — VARCHAR(50)
- provider_user_id — VARCHAR(255)
- status — VARCHAR(30)
- auth_fail_count — INT
- blocked_until — TIMESTAMP
- created_at — TIMESTAMP
- updated_at — TIMESTAMP
- deleted_at — TIMESTAMP
agent_client
- id — BIGSERIAL — Primary key — NOT NULL
- client_id — VARCHAR(128) — NOT NULL
- client_secret_hash — VARCHAR(255)
- token_endpoint_auth_method — VARCHAR(32) — NOT NULL
- name — VARCHAR(100) — NOT NULL
- logo_uri — VARCHAR(2048)
- status — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
agent_client_redirect_uri
- id — BIGSERIAL — Primary key — NOT NULL
- agent_client_id — BIGINT — Foreign key → agent_client.id — NOT NULL
- redirect_uri — VARCHAR(2048) — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
agent_connection
- id — BIGSERIAL — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- agent_client_id — BIGINT — Foreign key → agent_client.id — NOT NULL
- scopes — TEXT — NOT NULL
- connected_at — TIMESTAMPTZ — NOT NULL
- revoked_at — TIMESTAMPTZ
checkout_snapshot
- id — BIGSERIAL — Primary key — NOT NULL
- purchase_request_id — BIGINT — Foreign key → purchase_request.id — NOT NULL
- merchant_id — BIGINT — Foreign key → merchant.id — NOT NULL
- merchant_checkout_id — VARCHAR(255) — NOT NULL
- merchant_checkout_status — VARCHAR(32) — NOT NULL
- raw_payload — JSONB — NOT NULL
- checkout_hash — VARCHAR(64) — NOT NULL
- total_amount — NUMERIC(19,4) — NOT NULL
- last_synced_at — TIMESTAMPTZ — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
merchant
- id — BIGSERIAL — Primary key — NOT NULL
- public_id — UUID — NOT NULL
- name — VARCHAR(100) — NOT NULL
- domain — VARCHAR(255) — NOT NULL
- profile — JSONB — NOT NULL
- status — VARCHAR(20) — NOT NULL
- last_profile_synced_at — TIMESTAMPTZ
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
pay_authorization_reference
- id — BIGSERIAL — Primary key — NOT NULL
- checkout_snapshot_id — BIGINT — Foreign key → checkout_snapshot.id — NOT NULL
- pay_authorization_id — UUID — NOT NULL
- checkout_mandate_id — UUID
- approval_status — VARCHAR(20) — NOT NULL
- expires_at — TIMESTAMPTZ — NOT NULL
- approved_at — TIMESTAMPTZ
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
purchase_request
- id — BIGSERIAL — Primary key — NOT NULL
- public_id — UUID — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- agent_connection_id — BIGINT — Foreign key → agent_connection.id — NOT NULL
- status — VARCHAR(32) — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL
user_identity
- id — BIGSERIAL — Primary key — NOT NULL
- user_id — BIGINT — Foreign key → users.id — NOT NULL
- provider — VARCHAR(20) — NOT NULL
- provider_user_id — VARCHAR(255) — NOT NULL
- secret_hash — VARCHAR(255)
- created_at — TIMESTAMPTZ — NOT NULL
users
- id — BIGSERIAL — Primary key — NOT NULL
- public_id — UUID — NOT NULL
- name — VARCHAR(100) — NOT NULL
- status — VARCHAR(20) — NOT NULL
- created_at — TIMESTAMPTZ — NOT NULL
- updated_at — TIMESTAMPTZ — NOT NULL