SSATTO

Tables (6)

anonymous_sessions

  • id — BIGSERIAL
  • session_uuid — UUID — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • first_seen_at — TIMESTAMP — NOT NULL
  • last_seen_at — TIMESTAMP — NOT NULL
  • created_at — TIMESTAMP — NOT NULL

dashboard_snapshots

  • id — BIGSERIAL
  • block_height — BIGINT — NOT NULL
  • best_block_hash — VARCHAR(128)
  • peer_count — INTEGER — NOT NULL
  • mempool_tx_count — INTEGER — NOT NULL
  • jackpot_pool_balance — NUMERIC(20,8) — NOT NULL
  • next_jackpot_amount — NUMERIC(20,8) — NOT NULL
  • pending_commit_count — INTEGER — NOT NULL
  • claimable_commit_count — INTEGER — NOT NULL
  • captured_at — TIMESTAMP — NOT NULL

lottery_claims

  • id — BIGSERIAL
  • commit_id — BIGINT — Foreign key → lottery_commits.id — NOT NULL
  • wallet_id — BIGINT — Foreign key → wallets.id — NOT NULL
  • claim_txid — VARCHAR(128)
  • claim_status — VARCHAR(20) — NOT NULL
  • claimed_at_block_height — BIGINT
  • claimed_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL

lottery_commits

  • id — BIGSERIAL
  • session_id — BIGINT — Foreign key → anonymous_sessions.id
  • wallet_id — BIGINT — Foreign key → wallets.id — NOT NULL
  • commit_txid — VARCHAR(128) — NOT NULL
  • commit_hash — VARCHAR(128) — NOT NULL
  • chosen_numbers — CHAR(6) — NOT NULL
  • stake_pot — NUMERIC(20,8) — NOT NULL
  • commit_block_height — BIGINT
  • result_check_start_height — BIGINT
  • result_check_end_height — BIGINT
  • claim_open_height — BIGINT
  • claim_close_height — BIGINT
  • matched_count — INTEGER
  • prize_rank — VARCHAR(20)
  • payout_jack — NUMERIC(20,8) — NOT NULL
  • payout_pot — NUMERIC(20,8) — NOT NULL
  • status — VARCHAR(20) — NOT NULL
  • committed_at — TIMESTAMP
  • created_at — TIMESTAMP — NOT NULL

session_wallets

  • id — BIGSERIAL
  • session_id — BIGINT — Foreign key → anonymous_sessions.id — NOT NULL
  • wallet_id — BIGINT — Foreign key → wallets.id — NOT NULL
  • is_primary — BOOLEAN — NOT NULL
  • linked_at — TIMESTAMP — NOT NULL

wallets

  • id — BIGSERIAL
  • wallet_address — VARCHAR(128) — NOT NULL
  • label — VARCHAR(100)
  • source_type — VARCHAR(20) — NOT NULL
  • created_at — TIMESTAMP — NOT NULL