asdsd
Tables (18)
auction_bids
- id — uuid — Primary key — NOT NULL
- auction_id — uuid — NOT NULL
- bidder_id — uuid — NOT NULL
- amount — numeric(38,18) — NOT NULL
- escrow_id — text
- tx_hash — text
- created_at — timestamp — NOT NULL
auction_settlements
- id — uuid — Primary key — NOT NULL
- auction_id — uuid — NOT NULL
- winner_id — uuid — NOT NULL
- price — numeric(38,18) — NOT NULL
- royalty_rate — numeric(18,9) — NOT NULL
- platform_fee_rate — numeric(18,9) — NOT NULL
- seller_amount — numeric(38,18) — NOT NULL
- payment_token — text — NOT NULL
- tx_hash — text
- settled_at — timestamp — NOT NULL
- created_at — timestamp — NOT NULL
auctions
- id — uuid — Primary key — NOT NULL
- nft_id — uuid — NOT NULL
- seller_id — uuid — NOT NULL
- start_price — numeric(38,18) — NOT NULL
- reserve_price — numeric(38,18)
- buyout_price — numeric(38,18)
- min_increment_type — text — NOT NULL
- min_increment_value — numeric(38,18) — NOT NULL
- starts_at — timestamp — NOT NULL
- ends_at — timestamp — NOT NULL
- extend_window_sec — integer — NOT NULL
- status — text — NOT NULL
- canceled_at — timestamp
- created_at — timestamp — NOT NULL
- updated_at — timestamp
cards
- id — uuid — Primary key — NOT NULL
- user_id — uuid — NOT NULL
- title — text — NOT NULL
- description — text
- author_name — text
- hash — text
- owner_address — text
- token_id — text
- cid — text
- created_at — timestamp — NOT NULL
groups
- id — uuid — Primary key — NOT NULL
- user_id — uuid — NOT NULL
- name — text — NOT NULL
- group_image_url — text
- description — text
- created_at — timestamp — NOT NULL
idols
- id — uuid — Primary key — NOT NULL
- group_id — uuid — NOT NULL
- name — text — NOT NULL
- idol_image_url — text
- description — text
- created_at — timestamp — NOT NULL
nfts
- id — uuid — Primary key — NOT NULL
- card_id — uuid — NOT NULL
- token_id — text — NOT NULL
- standard — text — NOT NULL
- owner_user_id — uuid
- quantity — integer
- minted_at — timestamp — NOT NULL
offer_settlements
- id — uuid — Primary key — NOT NULL
- offer_id — uuid — NOT NULL
- price — numeric(38,18) — NOT NULL
- royalty_rate — numeric(18,9) — NOT NULL
- platform_fee_rate — numeric(18,9) — NOT NULL
- seller_amount — numeric(38,18) — NOT NULL
- payment_token — text — NOT NULL
- tx_hash — text
- settled_at — timestamp — NOT NULL
- created_at — timestamp — NOT NULL
offers
- id — uuid — Primary key — NOT NULL
- nft_id — uuid — NOT NULL
- seller_id — uuid — NOT NULL
- buyer_id — uuid — NOT NULL
- price — numeric(38,18) — NOT NULL
- payment_token — text — NOT NULL
- expires_at — timestamp — NOT NULL
- quantity — integer — NOT NULL
- status — text — NOT NULL
- created_at — timestamp — NOT NULL
- updated_at — timestamp
- accepted_at — timestamp
- rejected_at — timestamp
- canceled_at — timestamp
- expired_at — timestamp
ownership
- user_id — uuid — Primary key — NOT NULL
- card_id — uuid — Primary key — NOT NULL
- quantity — integer — NOT NULL
pack_composition
- id — uuid — Primary key — NOT NULL
- pack_id — uuid — NOT NULL
- card_id — uuid — NOT NULL
- quantity — integer — NOT NULL
- probability — numeric(18,9)
pack_orders
- id — uuid — Primary key — NOT NULL
- pack_id — uuid — NOT NULL
- buyer_id — uuid — NOT NULL
- unit_price — numeric(38,18) — NOT NULL
- quantity — integer — NOT NULL
- total_price — numeric(38,18) — NOT NULL
- payment_token — text — NOT NULL
- status — text — NOT NULL
- payment_tx_hash — text
- created_at — timestamp — NOT NULL
- paid_at — timestamp
- canceled_at — timestamp
- refunded_at — timestamp
pack_reveal_items
- id — uuid — Primary key — NOT NULL
- pack_reveal_id — uuid — NOT NULL
- nft_id — uuid
- rarity — text
- assigned_at — timestamp — NOT NULL
- tx_hash — text
- alt_card_id — uuid
- alt_token_id — text
pack_reveals
- id — uuid — Primary key — NOT NULL
- pack_order_id — uuid — NOT NULL
- buyer_id — uuid — NOT NULL
- slots — integer — NOT NULL
- vrf_request_id — text
- vrf_result — text
- reveal_tx_hash — text
- opened_at — timestamp — NOT NULL
packs
- id — uuid — Primary key — NOT NULL
- card_id — uuid
- user_id — uuid — NOT NULL
- price — numeric(38,18) — NOT NULL
- slots — integer — NOT NULL
- starts_at — timestamp — NOT NULL
- ends_at — timestamp — NOT NULL
- reveal_at — timestamp
- per_wallet_limit — integer
- created_at — timestamp — NOT NULL
sales
- id — uuid — Primary key — NOT NULL
- ref_type — text — NOT NULL
- ref_id — uuid — NOT NULL
- nft_id — uuid
- buyer_id — uuid — NOT NULL
- seller_id — uuid
- buyer_address — text
- seller_address — text
- chain_id — integer
- network — text
- payment_token — text
- tx_hash — text
- status — text — NOT NULL
- completed_at — timestamp
- created_at — timestamp — NOT NULL
users
- id — uuid — Primary key — NOT NULL
- name — text — NOT NULL
- email — text — NOT NULL
- role — text — NOT NULL
- profile_image_url — text
- provider — text
- created_at — timestamp — NOT NULL
- updated_at — timestamp
wallet
- id — uuid — Primary key — NOT NULL
- user_id — uuid — NOT NULL
- balance — numeric(38,18) — NOT NULL