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