account


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INTEGER 2000000000 √ √ null
account_attribute.account_id C
account_balance_materialized_view.account_id C
account_mapping.account_id C
account_merge.surviving_account_id C
exchange_order.account_id C
import_directory.account_id N
pending_materialized_view_changes.account_id C
person_account_ownership.account_id C
running_balance_materialized_view.account_id C
settings.last_qif_account_id R
trade.from_account_id C
trade.to_account_id C
transfer.source_account_id C
transfer.target_account_id C
revision_id INTEGER 2000000000 1
name TEXT 2000000000 null
opening_date INTEGER 2000000000 null
category_id INTEGER 2000000000 -1
category.id R

Indexes

Constraint Name Type Sort Column(s)
account_s_pk Primary key Asc id
sqlite_autoindex_account_1 Must be unique Asc name

Relationships

Close relationships within degrees of separation