Table d44civi_9xzwf.civicrm_financial_item 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  √ 
created_date timestamp 19 CURRENT_TIMESTAMP Date and time the item was created
transaction_date datetime 19 Date and time of the source transaction
contact_id int unsigned 10
civicrm_contact.id FK_civicrm_financial_item_contact_id C
FK to Contact ID of contact the item is from
description varchar 255  √  null Human readable description of this item, to ease display without lookup of source item.
amount decimal 20,2 0.00 Total amount of this item
currency varchar 3  √  null Currency for the amount
financial_account_id int unsigned 10  √  null
civicrm_financial_account.id FK_civicrm_financial_item_financial_account_id R
FK to civicrm_financial_account
status_id int unsigned 10  √  null Payment status: test, paid, part_paid, unpaid (if empty assume unpaid)
entity_table varchar 64  √  null The table providing the source of this item such as civicrm_line_item
entity_id int unsigned 10  √  null The specific source item that is responsible for the creation of this financial_item

Table contained 93 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_item_contact_id
financial_account_id Performance Asc FK_civicrm_financial_item_financial_account_id
created_date Performance Asc IX_created_date
entity_table + entity_id Performance Asc/Asc IX_entity
transaction_date Performance Asc IX_transaction_date
id Must be unique Asc UI_id

Close relationships  within of separation: