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