SSFAY
Tables (6)
ACTORS
- actor_id — Primary key — NOT NULL
- name — varchar — NOT NULL
- type — varchar — NOT NULL
- created_at — datetime — NOT NULL
ORDERS
- order_id — Primary key — NOT NULL
- buyer_actor_id — varchar — NOT NULL
- quantity — int — NOT NULL
- subtotal_onchain — bigint — NOT NULL
- created_at — datetime — NOT NULL
PAYMENTS
- payment_id — Primary key — NOT NULL
- order_id — Foreign key → ORDERS.order_id — NOT NULL
- actor_id — varchar — NOT NULL
- status — varchar — NOT NULL
- pay_method — varchar — NOT NULL
- amount_display — varchar — NOT NULL
- amount_onchain — bigint — NOT NULL
- currency — varchar — NOT NULL
- timeline_json — varchar
- tx_hash_payment — varchar
- idempotency_key — varchar
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
RECEIPTS
- receipt_id — Primary key — NOT NULL
- payment_id — Foreign key → PAYMENTS.payment_id — NOT NULL
- token_id — varchar
- owner_type — varchar — NOT NULL
- owner_address — varchar — NOT NULL
- token_uri — varchar — NOT NULL
- mint_tx_hash — varchar — NOT NULL
- mint_block_number — bigint — NOT NULL
- mint_log_index — int — NOT NULL
- status — varchar — NOT NULL
- metadata_hash_sha256 — varchar — NOT NULL
- created_at — datetime — NOT NULL
- updated_at — datetime — NOT NULL
RECEIPT_EVENTS
- recipt_event_id — Primary key — NOT NULL
- token_id — varchar — NOT NULL
- event — varchar — NOT NULL
- tx_hash — varchar
- block_number — bigint
- log_index — int
- created_at — datetime — NOT NULL
TRANSACTIONS
- tx_id — Primary key — NOT NULL
- order_id — Foreign key → ORDERS.order_id — NOT NULL
- payment_id — Foreign key → PAYMENTS.payment_id — NOT NULL
- seller_actor_id — varchar — NOT NULL
- buyer_actor_id — varchar — NOT NULL
- direction — varchar — NOT NULL
- method — varchar — NOT NULL
- status — varchar — NOT NULL
- amount_display — varchar — NOT NULL
- amount_onchain — bigint — NOT NULL
- currency — varchar — NOT NULL
- onchain_tx_hash — varchar
- onchain_block_number — bigint
- onchain_log_index — int
- contract_address — varchar
- token_id_receipt — varchar
- created_at — datetime — NOT NULL