stable_data_items

0 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id BLOB 2000000000 null
bundle_data_items.id Defined in XML R
stable_data_item_tags.data_item_id Defined in XML R
parent_id BLOB 2000000000 null
bundles.id Defined in XML R
root_transaction_id BLOB 2000000000 null
bundles.id Defined in XML R
height INTEGER 2000000000 null
block_transaction_index INTEGER 2000000000 null
stable_data_item_tags.block_transaction_index Defined in XML R
signature BLOB 2000000000 √ null
anchor BLOB 2000000000 null
owner_address BLOB 2000000000 null
wallets.address Defined in XML R
target BLOB 2000000000 √ null
data_offset INTEGER 2000000000 null
data_size INTEGER 2000000000 null
content_type TEXT 2000000000 √ null
tag_count INTEGER 2000000000 null
indexed_at INTEGER 2000000000 null
signature_type INTEGER 2000000000 √ null
offset INTEGER 2000000000 √ null
size INTEGER 2000000000 √ null
owner_offset INTEGER 2000000000 √ null
owner_size INTEGER 2000000000 √ null
signature_offset INTEGER 2000000000 √ null
signature_size INTEGER 2000000000 √ null
content_encoding TEXT 2000000000 √ null
root_parent_offset INTEGER 2000000000 √ null

Indexes

Constraint Name Type Sort Column(s)
stable_data_items_s_pk Primary key Asc id
sqlite_autoindex_stable_data_items_1 Must be unique Asc id
stable_data_items_height_block_transaction_index_id_idx Performance Asc/Asc/Asc height + block_transaction_index + id
stable_data_items_indexed_at_idx Performance Asc indexed_at
stable_data_items_owner_address_height_block_transaction_index_id_idx Performance Asc/Asc/Asc/Asc owner_address + height + block_transaction_index + id
stable_data_items_parent_id_height_block_transaction_index_id_idx Performance Asc/Asc/Asc/Asc parent_id + height + block_transaction_index + id
stable_data_items_target_height_block_transaction_index_id_idx Performance Asc/Asc/Asc/Asc target + height + block_transaction_index + id

Relationships

Close relationships within degrees of separation