Skip to main content

Table Details

PropertyValue
Table Namestellar.raw.tokens
Table StatusProduction-Ready
Unique Keycontract_id
Clustering Key(s)to_date("ledger_close_time")
Search Optimizationcontract_id, asset_id

Table Columns

Column NameData TypeDescription
contract_idVARCHAR(16777216)Soroban contract address of this token.
asset_idVARCHAR(16777216)Composite code:issuer identifier of the asset for non-native assets.
asset_codeVARCHAR(16777216)Asset code for a classic asset.
asset_issuerVARCHAR(16777216)Issuer G-address for a classic asset.
decimalsNUMBER(38,0)Number of decimal places for this token.
token_typeVARCHAR(16777216)Whether the token is a classic asset or a Soroban contract token.
asset_toml_infoVARIANTMetadata from the asset’s SEP-1 stellar.toml file.
asset_toml_urlVARCHAR(16777216)URL of the SEP-1 stellar.toml file for this asset’s issuer.
executableVARCHAR(16777216)Executable of the Soroban contract instance ledger entry.
durabilityVARCHAR(16777216)Storage durability of the Soroban ledger entry: persistent or temporary.
ledger_close_timeTIMESTAMP_NTZ(9)Time when the ledger containing this change closed and was finalized.
ledger_sequenceNUMBER(38,0)Sequence number of the ledger containing this change.
ledger_hashVARCHAR(16777216)Hash of the ledger containing this change.
transaction_hashVARCHAR(16777216)Hash of the transaction that produced this change.
transaction_indexNUMBER(38,0)Position of the transaction within its ledger.
ledger_entry_change_indexNUMBER(38,0)Sequential index of this change within the transaction’s ledger entry changes.
ledger_entry_typeVARCHAR(16777216)Numeric type of the affected LedgerEntry.
ledger_entry_type_strVARCHAR(16777216)Human-readable name of the LedgerEntry type.
ledger_entry_change_typeVARCHAR(16777216)Type of change applied to this ledger entry (created, updated, removed, state).
ledger_entry_change_reason_strVARCHAR(16777216)Human-readable description of the reason for this ledger entry change.
ledger_entry_change_reasonVARCHAR(16777216)Reason code for this ledger entry change.
post_ledger_entryVARIANTState of the ledger entry after this change was applied.
_extra_fieldsVARIANTCatch-all of additional source fields not mapped to a dedicated column.
_created_atTIMESTAMP_NTZ(9)Timestamp of when the entry was created in the database.
_updated_atTIMESTAMP_NTZ(9)Timestamp of when the entry was last updated in the database.