account_balance_materialized_view


Columns

Column Type Size Nulls Auto Default Children Parents Comments
account_id INTEGER 2000000000 null
account.id C
asset_id INTEGER 2000000000 null
asset.id C
balance TEXT 2000000000 null

Indexes

Constraint Name Type Sort Column(s)
account_balance_materialized_view_s_pk Primary key Asc/Asc account_id + asset_id
idx_account_balance_mv_account Performance Asc account_id
idx_account_balance_mv_currency Performance Asc asset_id
sqlite_autoindex_account_balance_materialized_view_1 Must be unique Asc/Asc account_id + asset_id

Relationships

Close relationships within degrees of separation