1 <?xml version=
"1.0" encoding=
"iso-8859-1" ?>
5 <class>LineItem
</class>
6 <name>civicrm_line_item
</name>
11 <type>int unsigned
</type>
12 <required>true
</required>
13 <comment>Line Item
</comment>
18 <autoincrement>true
</autoincrement>
21 <name>entity_table
</name>
24 <required>true
</required>
25 <comment>table which has the transaction
</comment>
29 <name>entity_id
</name>
30 <type>int unsigned
</type>
31 <required>true
</required>
32 <comment>entry in table
</comment>
36 <idColumn>entity_id
</idColumn>
37 <typeColumn>entity_table
</typeColumn>
41 <name>price_field_id
</name>
42 <type>int unsigned
</type>
43 <comment>FK to civicrm_price_field
</comment>
44 <!-- changed to not required in 4.3 in order to change ON DELETE CASCADE FK constraint to SET NULL -->
48 <name>price_field_id
</name>
49 <table>civicrm_price_field
</table>
51 <onDelete>SET NULL
</onDelete>
54 <name>option_group_id
</name>
55 <type>int unsigned
</type>
56 <required>true
</required>
57 <comment>FK to option group
</comment>
65 <default>NULL
</default>
66 <!-- changed to not required in 4.2.3 -->
67 <comment>descriptive label for item - from price_field_value.label
</comment>
75 <type>int unsigned
</type>
76 <required>true
</required>
77 <comment>How many items ordered
</comment>
84 <name>unit_price
</name>
86 <required>true
</required>
87 <comment>price of each item
</comment>
94 <name>line_total
</name>
96 <required>true
</required>
97 <comment>qty * unit_price
</comment>
101 <name>participant_count
</name>
102 <type>int unsigned
</type>
103 <default>NULL
</default>
104 <comment>Participant count for fiel
112 <name>index_entity
</name>
113 <fieldName>entity_table
</fieldName>
114 <fieldName>entity_id
</fieldName>
118 <name>UI_line_item_value
</name>
119 <fieldName>entity_table
</fieldName>
120 <fieldName>entity_id
</fieldName>
121 <fieldName>price_field_value_id
</fieldName>
122 <fieldName>price_field_id
</fieldName>
123 <unique>true
</unique>
127 <name>price_field_value_id
</name>
128 <type>int unsigned
</type>
129 <default>NULL
</default>
130 <comment>FK to civicrm_price_field_value
</comment>
134 <name>price_field_value_id
</name>
135 <table>civicrm_price_field_value
</table>
137 <onDelete>SET NULL
</onDelete>
140 <name>financial_type_id
</name>
141 <title>Financial Type
</title>
142 <type>int unsigned
</type>
143 <default>NULL
</default>
144 <comment>FK to Financial Type.
</comment>
151 <name>financial_type_id
</name>
152 <table>civicrm_financial_type
</table>
154 <onDelete>SET NULL
</onDelete>
158 <name>deductible_amount
</name>
159 <title>Deductible Amount
</title>
161 <default>0.0</default>
162 <headerPattern>/unit?.?amoun/i
</headerPattern>
163 <dataPattern>/^\d+(\.\d{
2})?$/
</dataPattern>
164 <required>true
</required>
165 <comment>Tax-deductible portion of the amount
</comment>