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