Table d44civi_9xzwf.civicrm_financial_account Generated by
SchemaSpy
Legend: SourceForge.net
Primary key columns
Columns with indexes
Implied relationships
Excluded column relationships
< n > number of related tables
 
Column Type Size Nulls Auto Default Children Parents Comments
id int unsigned 10  √ 
civicrm_entity_financial_account.financial_account_id FK_civicrm_entity_financial_account_financial_account_id R
civicrm_financial_account.parent_id FK_civicrm_financial_account_parent_id R
civicrm_financial_item.financial_account_id FK_civicrm_financial_item_financial_account_id R
civicrm_financial_trxn.from_financial_account_id FK_civicrm_financial_trxn_from_financial_account_id R
civicrm_financial_trxn.to_financial_account_id FK_civicrm_financial_trxn_to_financial_account_id R
ID
name varchar 255 Financial Account Name.
contact_id int unsigned 10  √  null
civicrm_contact.id FK_civicrm_financial_account_contact_id N
FK to Contact ID that is responsible for the funds in this account
financial_account_type_id int unsigned 10 3 pseudo FK into civicrm_option_value.
accounting_code varchar 64  √  null Optional value for mapping monies owed and received to accounting system codes.
account_type_code varchar 64  √  null Optional value for mapping account types to accounting system account categories (QuickBooks Account Type Codes for example).
description varchar 255  √  null Financial Type Description.
parent_id int unsigned 10  √  null
civicrm_financial_account.id FK_civicrm_financial_account_parent_id R
Parent ID in account hierarchy
is_header_account tinyint 3  √  0 Is this a header account which does not allow transactions to be posted against it directly, but only to its sub-accounts?
is_deductible tinyint 3  √  1 Is this account tax-deductible?
is_tax tinyint 3  √  0 Is this account for taxes?
tax_rate decimal 10,8  √  null The percentage of the total_amount that is due for this tax.
is_reserved tinyint 3  √  null Is this a predefined system object?
is_active tinyint 3  √  null Is this property active?
is_default tinyint 3  √  null Is this account the default one (or default tax one) for its financial_account_type?

Table contained 12 rows at Wed Nov 11 17:14 EST 2015

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
contact_id Performance Asc FK_civicrm_financial_account_contact_id
parent_id Performance Asc FK_civicrm_financial_account_parent_id
name Must be unique Asc UI_name

Close relationships  within of separation: