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>
72 <type>int unsigned
</type>
73 <required>true
</required>
74 <comment>How many items ordered
</comment>
78 <name>unit_price
</name>
80 <required>true
</required>
81 <comment>price of each item
</comment>
85 <name>line_total
</name>
87 <required>true
</required>
88 <comment>qty * unit_price
</comment>
92 <name>participant_count
</name>
93 <type>int unsigned
</type>
94 <default>NULL
</default>
95 <comment>Participant count for field
</comment>
99 <name>index_entity
</name>
100 <fieldName>entity_table
</fieldName>
101 <fieldName>entity_id
</fieldName>
105 <name>UI_line_item_value
</name>
106 <fieldName>entity_table
</fieldName>
107 <fieldName>entity_id
</fieldName>
108 <fieldName>price_field_value_id
</fieldName>
109 <fieldName>price_field_id
</fieldName>
110 <unique>true
</unique>
114 <name>price_field_value_id
</name>
115 <type>int unsigned
</type>
116 <default>NULL
</default>
117 <comment>FK to civicrm_price_field_value
</comment>
121 <name>price_field_value_id
</name>
122 <table>civicrm_price_field_value
</table>
124 <onDelete>SET NULL
</onDelete>
127 <name>financial_type_id
</name>
128 <title>Financial Type
</title>
129 <type>int unsigned
</type>
130 <default>NULL
</default>
131 <comment>FK to Financial Type.
</comment>
135 <name>financial_type_id
</name>
136 <table>civicrm_financial_type
</table>
138 <onDelete>SET NULL
</onDelete>
142 <name>deductible_amount
</name>
143 <title>Deductible Amount
</title>
145 <default>0.0</default>
146 <headerPattern>/unit?.?amoun/i
</headerPattern>
147 <dataPattern>/^\d+(\.\d{
2})?$/
</dataPattern>
148 <required>true
</required>
149 <comment>Tax-deductible portion of the amount
</comment>