Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | INT UNSIGNED | 10 | √ | null |
|
|
ID |
|||
| entity_table | VARCHAR | 64 | null |
|
|
Links to an entity_table like civicrm_financial_type |
||||
| entity_id | INT UNSIGNED | 10 | null |
|
|
Links to an id in the entity_table, such as vid in civicrm_financial_type |
||||
| account_relationship | INT UNSIGNED | 10 | null |
|
|
FK to a new civicrm_option_value (account_relationship) |
||||
| financial_account_id | INT UNSIGNED | 10 | null |
|
|
FK to the financial_account_id |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| FK_civicrm_entity_financial_account_financial_account_id | Performance | Asc | financial_account_id |
| index_entity_id_entity_table_account_relationship | Must be unique | Asc/Asc/Asc | entity_id + entity_table + account_relationship |
Relationships
Close relationships within degrees of separation
