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