Columns
| Column | Type | Size | Nulls | Auto | Default | Children | Parents | Comments | ||
|---|---|---|---|---|---|---|---|---|---|---|
| id | INT UNSIGNED | 10 | √ | null |
|
|
Line Item |
|||
| entity_table | VARCHAR | 64 | null |
|
|
table which has the transaction |
||||
| entity_id | INT UNSIGNED | 10 | null |
|
|
entry in table |
||||
| contribution_id | INT UNSIGNED | 10 | √ | null |
|
|
FK to civicrm_contribution |
|||
| price_field_id | INT UNSIGNED | 10 | √ | null |
|
|
FK to civicrm_price_field |
|||
| label | VARCHAR | 255 | √ | null |
|
|
descriptive label for item - from price_field_value.label |
|||
| qty | DECIMAL | 20,2 | √ | null |
|
|
||||
| unit_price | DECIMAL | 20,2 | null |
|
|
price of each item |
||||
| line_total | DECIMAL | 20,2 | null |
|
|
qty * unit_price |
||||
| participant_count | INT UNSIGNED | 10 | √ | null |
|
|
Participant count for field |
|||
| price_field_value_id | INT UNSIGNED | 10 | √ | null |
|
|
FK to civicrm_price_field_value |
|||
| financial_type_id | INT UNSIGNED | 10 | √ | null |
|
|
FK to Financial Type. |
|||
| non_deductible_amount | DECIMAL | 20,2 | 0.00 |
|
|
Portion of total amount which is NOT tax deductible. |
||||
| tax_amount | DECIMAL | 20,2 | √ | null |
|
|
tax of each item |
Indexes
| Constraint Name | Type | Sort | Column(s) |
|---|---|---|---|
| PRIMARY | Primary key | Asc | id |
| FK_civicrm_line_item_contribution_id | Performance | Asc | contribution_id |
| FK_civicrm_line_item_financial_type_id | Performance | Asc | financial_type_id |
| FK_civicrm_line_item_price_field_id | Performance | Asc | price_field_id |
| FK_civicrm_line_item_price_field_value_id | Performance | Asc | price_field_value_id |
| index_entity | Performance | Asc/Asc | entity_table + entity_id |
| UI_line_item_value | Must be unique | Asc/Asc/Asc/Asc/Asc | entity_table + entity_id + contribution_id + price_field_value_id + price_field_id |
Relationships
Close relationships within degrees of separation
