Extsy

Tables (10)

Coin

  • id — String — Primary key — NOT NULL
  • network_id — String — Foreign key → Network.id — NOT NULL
  • coinGeckoId — String
  • name — String
  • symbol — String
  • name_short — String
  • symbol_short — String
  • logo_url — String
  • contract_address — String
  • is_token — Boolean
  • is_mainnet — Boolean
  • is_deleted — Boolean
  • is_active — Boolean
  • price — Float
  • decimal — Integer
  • Field

CoinExchange

  • id — String — Primary key — NOT NULL
  • coin_id — String — Foreign key → Coin.id — NOT NULL
  • network_id — String — Foreign key → Coin.network_id — NOT NULL
  • exchange_id — String — Foreign key → Exchange.id — NOT NULL
  • ticker_name — String
  • precision_deposit — number
  • precision_withdraw — number
  • minimum_deposit — number
  • minimum_withdraw — number
  • Field

Currency

  • id — String — Primary key — NOT NULL
  • name — String
  • symbol — String
  • coin_gecko_id — String
  • logo_url — String
  • is_deleted — String
  • is_active — String

Exchange

  • id — String — Primary key — NOT NULL
  • name — String
  • api_url — String
  • api_key — String
  • is_active — String
  • is_deleted — String
  • Field

Network

  • id — String — Primary key — NOT NULL
  • name — String
  • symbol — String
  • logo_url — String
  • rpc_url — String
  • network_type — String
  • wallet_type — String
  • chain_id — Int
  • chain_id_hex — String
  • is_mainnet — Boolean
  • is_deleted — Boolean
  • is_active — Boolean
  • Field

Price

  • id — String — Primary key — NOT NULL
  • coin_id — String — Foreign key → Coin.id — NOT NULL
  • currency_id — String — Foreign key → Currency.id — NOT NULL
  • price — Float
  • previous_price — Float
  • price_change — Float
  • market_cap — Float
  • volume — Float
  • Field

SwapPair

  • id — String — Primary key — NOT NULL
  • from_coin_id — String — Foreign key → Coin.id — NOT NULL
  • from_network_id — String — Foreign key → Coin.network_id — NOT NULL
  • to_coin_id — String
  • to_network_id — String
  • pair_ticker — String
  • minimum_amount — number
  • side — enum(BUY,SELL)
  • Field

SwapTransactions

  • id — String — Primary key — NOT NULL
  • swap_pair_id — String — Foreign key → SwapPair.id — NOT NULL
  • from_coin_id — String — Foreign key → SwapPair.from_coin_id — NOT NULL
  • from_network_id — String — Foreign key → SwapPair.from_network_id — NOT NULL
  • to_coin_id — String
  • to_network_id — String
  • from_amount — Float
  • to_amount — Float
  • output_rate — Float
  • fee — Float
  • fee_percentage — Float
  • exchange_id — String
  • Field

User

  • id — User — Primary key — NOT NULL
  • email — User
  • password — User
  • username — User
  • is_guest — User
  • Field

Wallet

  • id — String — Primary key — NOT NULL
  • user_id — User — Foreign key → User.id — NOT NULL
  • network_id — String — Foreign key → Network.id — NOT NULL
  • wallet_type — String
  • address — String
  • private_key — String
  • public_key — String
  • mnemonic — String
  • signature_id — String
  • is_temp — Boolean
  • is_deleted — Boolean
  • Field