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