Table d44civi_9xzwf.civicrm_financial_type 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_contribution.financial_type_id FK_civicrm_contribution_financial_type_id R
civicrm_contribution_page.financial_type_id FK_civicrm_contribution_page_financial_type_id R
civicrm_contribution_product.financial_type_id FK_civicrm_contribution_product_financial_type_id N
civicrm_contribution_recur.financial_type_id FK_civicrm_contribution_recur_financial_type_id N
civicrm_grant.financial_type_id FK_civicrm_grant_financial_type_id N
civicrm_line_item.financial_type_id FK_civicrm_line_item_financial_type_id N
civicrm_membership_type.financial_type_id FK_civicrm_membership_type_financial_type_id R
civicrm_pledge.financial_type_id FK_civicrm_pledge_financial_type_id R
civicrm_premiums_product.financial_type_id FK_civicrm_premiums_product_financial_type_id N
civicrm_price_field_value.financial_type_id FK_civicrm_price_field_value_financial_type_id N
civicrm_price_set.financial_type_id FK_civicrm_price_set_financial_type_id N
civicrm_product.financial_type_id FK_civicrm_product_financial_type_id N
ID of original financial_type so you can search this table by the financial_type.id and then select the relevant version based on the timestamp
name varchar 64 Financial Type Name.
description varchar 255  √  null Financial Type Description.
is_deductible tinyint 3  √  1 Is this financial type tax-deductible? If true, contributions of this type may be fully OR partially deductible - non-deductible amount is stored in the Contribution record.
is_reserved tinyint 3  √  null Is this a predefined system object?
is_active tinyint 3  √  null Is this property active?

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

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
id Must be unique Asc UI_id

Close relationships  within of separation: