una swap

Tables (8)

currency_info

  • id — INT — Auto increment primary key
  • currency_id — VARCHAR(255) — NOT NULL — Currency patch data id
  • contract_address — VARCHAR(42) — Currency contract address, null when native currency
  • chain_key — VARCHAR(54) — NOT NULL — Currency chain key
  • name — VARCHAR(256) — NOT NULL — Currency name
  • symbol — VARCHAR(256) — NOT NULL — Currency symbol
  • decimals — INT — NOT NULL — Currency decimals

fcm_token

  • id — INT — Auto increment primary key
  • wallet_address — VARCHAR(42) — NOT NULL — User wallet address
  • device_id — VARCHAR(36) — NOT NULL — User Device id
  • fcm_token — VARCHAR(255) — NOT NULL — User fcm token

indexed_history

  • id — BIGINT — Primary key — NOT NULL — Unique ID, auto-incremented
  • block_timestamp — DATETIME — Primary key — NOT NULL — Timestamp when the block was created
  • tx_hash — VARCHAR(66) — NOT NULL — Unique hash of the event or transaction
  • index — VARCHAR(168) — NOT NULL — Index or identifier for sub-events within the main transaction
  • chain_key — VARCHAR(54) — NOT NULL — Identifier or key of the chain where the event occurred
  • block_number — INTEGER — NOT NULL — Number of the block containing the event
  • label — VARCHAR(24) — NOT NULL — Type of event or action (e.g., ERC-20, ERC-721, ERC-1155, INTERNAL)
  • from_address — VARCHAR(42) — NOT NULL — Originating address of the event or action
  • to_address — VARCHAR(42) — Recipient or target address of the event or action
  • contract_address — VARCHAR(42) — Address of the contract involved, if any
  • amount — VARCHAR(40) — NOT NULL — Amount of cryptocurrency or tokens involved
  • token_id — VARCHAR(40) — Identifier for specific tokens (relevant for NFTs or ERC-1155 multi-tokens)
  • partitioned — by

indexed_nft_balance

  • id — BIGINT — Primary key — NOT NULL — Unique ID, auto-incremented
  • wallet_address — VARCHAR(42) — NOT NULL — Address of the wallet holding the NFT
  • chain_key — VARCHAR(54) — NOT NULL — Identifier of the chain where the NFT resides
  • contract_address — VARCHAR(42) — NOT NULL — Address of the NFT contract
  • contract_type — VARCHAR(24) — NOT NULL — Type of the NFT contract (e.g., ERC-721, ERC-1155)
  • token_id — VARCHAR(40) — NOT NULL — Unique identifier for the specific NFT within the contract
  • balance — VARCHAR(40) — NOT NULL — Current balance or ownership quantity of the NFT (especially relevant for ERC-1155 which can have multiple of the same…
  • updated_block_number — INTEGER — NOT NULL — Block number when the balance or ownership was last updated
  • created_block_number — INTEGER — NOT NULL — Block number when the balance or ownership record was first created

indexed_token_balance

  • id — BIGINT — Primary key — NOT NULL — Unique ID, auto-incremented
  • wallet_address — VARCHAR(42) — NOT NULL — Address of the wallet
  • chain_key — VARCHAR(54) — NOT NULL — Identifier of the chain
  • contract_address — VARCHAR(42) — NOT NULL — Address of the token contract
  • balance — VARCHAR(40) — NOT NULL — Balance of the token in the wallet
  • updated_block_number — INTEGER — NOT NULL — Block number when the balance was last updated
  • created_block_number — INTEGER — NOT NULL — Block number when the balance record was created

indexed_transaction

  • id — BIGINT — Primary key — NOT NULL — Unique ID, auto-incremented
  • block_timestamp — DATETIME — Primary key — NOT NULL — Timestamp when the block was created
  • tx_hash — VARCHAR(66) — NOT NULL — Unique hash of the transaction
  • chain_key — VARCHAR(54) — NOT NULL — Identifier or key of the chain where the transaction occurred
  • block_number — INTEGER — NOT NULL — Blocknumber of the transaction
  • from_address — VARCHAR(42) — NOT NULL — Address initiating the transaction
  • to_address — VARCHAR(42) — Recipient address of the transaction
  • data — TEXT — NOT NULL — Additional data or payload related to the transaction
  • status — INTEGER — NOT NULL — Status of the transaction (e.g., success, failure)
  • value — VARCHAR(40) — NOT NULL — Amount of cryptocurrency transferred
  • gas_used — VARCHAR(40) — NOT NULL — Amount of gas consumed for the transaction
  • gas_limit — VARCHAR(40) — NOT NULL — Maximum amount of gas allocated for the transaction
  • gas_price — VARCHAR(40) — NOT NULL — Price paid per unit of gas

swap

  • seq_id — INT — Auto increment primary key
  • id — VARCHAR(32) — NOT NULL — Unique identifier for the swap
  • wallet_address — VARCHAR(42) — NOT NULL — User wallet address
  • status — VARCHAR(20) — NOT NULL — Current status of the swap
  • created_at — datetime — NOT NULL — Timestamp when the swap was created
  • updated_at — datetime — NOT NULL — Timestamp when the swap was last updated
  • slippage — DECIMAL(6, 5) — NOT NULL — Accepted slippage for the swap
  • gas_price_option — VARCHAR(20) — NOT NULL — Gas price option of the swap
  • requested_amount — NUMERIC(65, 0) — NOT NULL — Amount of currency requested for the swap
  • estimated_receive_amount — NUMERIC(65, 0) — NOT NULL — Estimated receive amount after the swap' ) COMMENT 'Table for storing swap information'; CREATE INDEX swap_wallet_addre…

swap_step

  • seq_id — INT — Auto increment primary key
  • id — VARCHAR(32) — NOT NULL — Unique identifier for the swap step
  • swap_id — VARCHAR(32) — NOT NULL — Associated swap unique identifier
  • wallet_address — VARCHAR(42) — NOT NULL — User wallet address
  • status — VARCHAR(20) — NOT NULL — Current status of the swap step
  • type — VARCHAR(20) — NOT NULL — Type of the swap step
  • created_at — datetime — NOT NULL — Timestamp when the swap step was created
  • updated_at — datetime — NOT NULL — Timestamp when the swap step was last updated
  • from_currency_id — VARCHAR(80) — NOT NULL — Source currency identifier
  • to_currency_id — VARCHAR(80) — NOT NULL — Target currency identifier
  • fee — NUMERIC(65, 0) — Fee associated with the step
  • requested_amount — NUMERIC(65, 0) — Amount of currency requested for the swap
  • received_amount — NUMERIC(65, 0) — Amount of currency received after the swap
  • sequence_number — TINYINT — NOT NULL — Sequence number of the swap step
  • tx_hash — VARCHAR(66) — Executed tx hash for the swap step