b105
Tables (18)
auction_bids
- id — CHAR(36)
- auction_id — CHAR(36) — NOT NULL
- bidder_id — CHAR(36) — NOT NULL
- amount — DECIMAL(38,18) — NOT NULL
- escrow_id — VARCHAR(128)
- tx_hash — VARCHAR(128)
- created_at — DATETIME(6) — NOT NULL
auction_settlements
- id — CHAR(36)
- auction_id — CHAR(36) — NOT NULL
- winner_id — CHAR(36) — NOT NULL
- price — DECIMAL(38,18) — NOT NULL
- royalty_rate — DECIMAL(10,9) — NOT NULL
- platform_fee_rate — DECIMAL(10,9) — NOT NULL
- seller_amount — DECIMAL(38,18) — NOT NULL
- payment_token — VARCHAR(32) — NOT NULL
- tx_hash — VARCHAR(128)
- settled_at — DATETIME(6) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
auctions
- id — CHAR(36)
- nft_id — CHAR(36) — NOT NULL
- seller_id — CHAR(36) — NOT NULL
- start_price — DECIMAL(38,18) — NOT NULL
- reserve_price — DECIMAL(38,18)
- buyout_price — DECIMAL(38,18)
- min_increment_type — ENUM('fixed','tier','rate') — NOT NULL
- min_increment_value — DECIMAL(38,18) — NOT NULL
- starts_at — DATETIME(6) — NOT NULL
- ends_at — DATETIME(6) — NOT NULL
- extend_window_sec — INT — NOT NULL
- status — ENUM('draft','listed','bidding','ended_sold','ended_unsold','settled') — NOT NULL
- canceled_at — DATETIME(6)
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
cards
- id — CHAR(36)
- user_id — CHAR(36) — NOT NULL
- title — VARCHAR(200) — NOT NULL
- description — TEXT
- author_name — VARCHAR(120) — NOT NULL
- hash — VARCHAR(128)
- owner_address — VARCHAR(128)
- token_id — DECIMAL(78,0)
- cid — TEXT
- created_at — DATETIME(6) — NOT NULL
groups
- id — CHAR(36)
- user_id — CHAR(36) — NOT NULL
- name — VARCHAR(120) — NOT NULL
- group_image_url — TEXT
- description — TEXT
- created_at — DATETIME(6) — NOT NULL
idols
- id — CHAR(36)
- group_id — CHAR(36) — NOT NULL
- name — VARCHAR(120) — NOT NULL
- idol_image_url — TEXT
- description — TEXT
- created_at — DATETIME(6) — NOT NULL
nfts
- id — CHAR(36)
- card_id — CHAR(36) — NOT NULL
- token_id — DECIMAL(78,0) — NOT NULL
- standard — ENUM('ERC721','ERC1155') — NOT NULL
- owner_user_id — CHAR(36)
- quantity — DECIMAL(38,0)
- minted_at — DATETIME(6) — NOT NULL
offer_settlements
- id — CHAR(36)
- offer_id — CHAR(36) — NOT NULL
- price — DECIMAL(38,18) — NOT NULL
- royalty_rate — DECIMAL(10,9) — NOT NULL
- platform_fee_rate — DECIMAL(10,9) — NOT NULL
- seller_amount — DECIMAL(38,18) — NOT NULL
- payment_token — VARCHAR(32) — NOT NULL
- tx_hash — VARCHAR(128)
- settled_at — DATETIME(6) — NOT NULL
- created_at — DATETIME(6) — NOT NULL
offers
- id — CHAR(36)
- nft_id — CHAR(36) — NOT NULL
- seller_id — CHAR(36) — NOT NULL
- buyer_id — CHAR(36) — NOT NULL
- price — DECIMAL(38,18) — NOT NULL
- payment_token — VARCHAR(32) — NOT NULL
- expires_at — DATETIME(6) — NOT NULL
- quantity — DECIMAL(38,0) — NOT NULL
- status — ENUM('created','active','accepted','rejected','expired','canceled') — NOT NULL
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
- accepted_at — DATETIME(6)
- rejected_at — DATETIME(6)
- canceled_at — DATETIME(6)
- expired_at — DATETIME(6)
ownership
- user_id — CHAR(36) — Primary key — NOT NULL
- card_id — CHAR(36) — Primary key — NOT NULL
- quantity — DECIMAL(38,0) — NOT NULL
pack_composition
- id — CHAR(36)
- pack_id — CHAR(36) — NOT NULL
- card_id — CHAR(36) — NOT NULL
- quantity — INT — NOT NULL
- probability — DECIMAL(10,9) — NOT NULL
pack_orders
- id — CHAR(36)
- pack_id — CHAR(36) — NOT NULL
- buyer_id — CHAR(36) — NOT NULL
- unit_price — DECIMAL(38,18) — NOT NULL
- quantity — INT — NOT NULL
- total_price — DECIMAL(38,18) — NOT NULL
- payment_token — VARCHAR(32) — NOT NULL
- status — ENUM('created','paid','failed','refunded','canceled') — NOT NULL
- payment_tx_hash — VARCHAR(128)
- created_at — DATETIME(6) — NOT NULL
- paid_at — DATETIME(6)
- canceled_at — DATETIME(6)
- refunded_at — DATETIME(6)
pack_reveal_items
- id — CHAR(36)
- pack_reveal_id — CHAR(36) — NOT NULL
- nft_id — CHAR(36)
- rarity — VARCHAR(32)
- assigned_at — DATETIME(6) — NOT NULL
- tx_hash — VARCHAR(128)
pack_reveals
- id — CHAR(36)
- pack_order_id — CHAR(36) — NOT NULL
- buyer_id — CHAR(36) — NOT NULL
- slots — INT — NOT NULL
- vrf_request_id — VARCHAR(128)
- vrf_result — JSON
- reveal_tx_hash — VARCHAR(128)
- opened_at — DATETIME(6) — NOT NULL
packs
- id — CHAR(36)
- card_id — CHAR(36)
- user_id — CHAR(36) — NOT NULL
- price — DECIMAL(38,18) — NOT NULL
- slots — INT — NOT NULL
- starts_at — DATETIME(6) — NOT NULL
- ends_at — DATETIME(6) — NOT NULL
- reveal_at — DATETIME(6)
- per_wallet_limit — INT
- created_at — DATETIME(6) — NOT NULL
sales
- id — CHAR(36)
- ref_type — ENUM('auction','offer','pack') — NOT NULL
- ref_id — CHAR(36) — NOT NULL
- nft_id — CHAR(36)
- buyer_id — CHAR(36) — NOT NULL
- seller_id — CHAR(36)
- buyer_address — VARCHAR(128)
- seller_address — VARCHAR(128)
- chain_id — INT
- network — VARCHAR(32)
- payment_token — VARCHAR(32)
- tx_hash — VARCHAR(128)
- status — ENUM('completed','failed','canceled') — NOT NULL
- completed_at — DATETIME(6)
- created_at — DATETIME(6) — NOT NULL
users
- id — CHAR(36)
- name — VARCHAR(100) — NOT NULL
- email — VARCHAR(255) — NOT NULL
- role — ENUM('USER','PROVIDER','ADMIN') — NOT NULL
- profile_image_url — TEXT
- provider — VARCHAR(32)
- created_at — DATETIME(6) — NOT NULL
- updated_at — DATETIME(6) — NOT NULL
wallet
- id — CHAR(36)
- user_id — CHAR(36) — NOT NULL
- balance — DECIMAL(38,18) — NOT NULL