Table d44civi_9xzwf.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
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 int unsigned 10 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

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

Indexes:
Column(s) Type Sort Constraint Name
id Primary key Asc PRIMARY
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 + price_field_value_id + price_field_id Must be unique Asc/Asc/Asc/Asc UI_line_item_value

Close relationships  within of separation: