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