Table d47civi_0z3xa.civicrm_line_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  √  Line Item
entity_table varchar 64 table which has the transaction
entity_id int unsigned 10 entry in table
contribution_id int unsigned 10  √  null
civicrm_contribution.id FK_civicrm_line_item_contribution_id N
FK to civicrm_contribution
price_field_id int unsigned 10  √  null
civicrm_price_field.id FK_civicrm_line_item_price_field_id N
FK to civicrm_price_field
label varchar 255  √  null descriptive label for item - from price_field_value.label
qty decimal 20,2 How many items ordered
unit_price decimal 20,2 price of each item
line_total decimal 20,2 qty * unit_price
participant_count int unsigned 10  √  null Participant count for field
price_field_value_id int unsigned 10  √  null
civicrm_price_field_value.id FK_civicrm_line_item_price_field_value_id N
FK to civicrm_price_field_value
financial_type_id int unsigned 10  √  null
civicrm_financial_type.id FK_civicrm_line_item_financial_type_id N
FK to Financial Type.
deductible_amount decimal 20,2 0.00 Tax-deductible portion of the amount
tax_amount decimal 20,2  √  null tax of each item

Table contained 93 rows at mer. avr. 13 16:52 EDT 2016

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
contribution_id Performance Asc FK_civicrm_line_item_contribution_id
financial_type_id Performance Asc FK_civicrm_line_item_financial_type_id
price_field_id Performance Asc FK_civicrm_line_item_price_field_id
price_field_value_id Performance Asc FK_civicrm_line_item_price_field_value_id
entity_table + entity_id Performance Asc/Asc index_entity
entity_table + entity_id + contribution_id + price_field_value_id + price_field_id Must be unique Asc/Asc/Asc/Asc/Asc UI_line_item_value

Close relationships  within of separation: