Skip to main content

Table Details

PropertyValue
Table Namebitcoin-cash.raw.outputs
Table StatusProduction-Ready
Unique Keyutxo_id
Clustering Key(s)to_date("block_timestamp")
Search Optimizationutxo_id, transaction_hash

Table Columns

Column NameData TypeDescription
valueNUMBER(38,0)The amount of DOGE in satoshis (smallest unit) for this output.
script_asmVARCHAR(16777216)The script in assembly format that defines the conditions for spending this output.
script_hexVARCHAR(16777216)The script in hexadecimal format that defines the conditions for spending this output.
required_signaturesNUMBER(38,0)Number of signatures required to spend this output.
typeVARCHAR(16777216)The type of script used in this output.
addressesARRAYArray of addresses that can spend this output.
address0VARCHAR(16777216)The first address in the addresses array that can spend this output.
indexNUMBER(38,0)The position of this output within its transaction.
utxo_idVARCHAR(16777216)Unique identifier for this output, composed of transaction_hash and index.
transaction_hashVARCHAR(66)Unique hash of the transaction that contains this output.
block_hashVARCHAR(66)Hash of the block containing this output’s transaction.
block_numberNUMBER(38,0)Number of the block containing this output’s transaction.
block_timestampTIMESTAMP_NTZ(9)Timestamp when the block containing this output was mined.
_created_atTIMESTAMP_NTZ(9)Timestamp when this record was created in the database.
_updated_atTIMESTAMP_NTZ(9)Timestamp when this record was last updated in the database.