1 <?xml version=
"1.0" encoding=
"iso-8859-1" ?>
4 <base>CRM/Contribute
</base>
5 <class>ContributionProduct
</class>
6 <name>civicrm_contribution_product
</name>
11 <title>Contribution Product ID
</title>
12 <type>int unsigned
</type>
13 <required>true
</required>
18 <autoincrement>true
</autoincrement>
21 <name>product_id
</name>
22 <title>Product ID
</title>
23 <type>int unsigned
</type>
24 <required>true
</required>
28 <name>contribution_id
</name>
29 <title>Contribution ID
</title>
30 <type>int unsigned
</type>
31 <required>true
</required>
35 <name>contribution_id
</name>
36 <table>civicrm_contribution
</table>
39 <onDelete>CASCADE
</onDelete>
42 <name>product_option
</name>
43 <title>Product Option
</title>
47 <comment>Option value selected if applicable - e.g. color, size etc.
</comment>
52 <title>Quantity
</title>
59 <name>total_cost
</name>
61 <required>true
</required>
63 <headerPattern>/^total|(.?^am(ou)?nt)/i
</headerPattern>
64 <dataPattern>/^\d+(\.\d{
2})?$/
</dataPattern>
65 <comment>quantity X civicrm_product.cost.
</comment>
70 <name>fulfilled_date
</name>
72 <title>Fulfilled Date
</title>
74 <comment>Optional. Can be used to record the date this product was fulfilled or shipped.
</comment>
78 <name>start_date
</name>
79 <uniqueName>contribution_start_date
</uniqueName>
80 <title>Start date for premium
</title>
83 <comment>Actual start date for a time-delimited premium (subscription, service or membership)
</comment>
88 <uniqueName>contribution_end_date
</uniqueName>
90 <title>End date for premium
</title>
92 <comment>Actual end date for a time-delimited premium (subscription, service or membership)
</comment>
97 <title>Premium comment
</title>
102 <name>financial_type_id
</name>
103 <title>Financial Type
</title>
104 <type>int unsigned
</type>
105 <default>NULL
</default>
107 <table>civicrm_financial_type
</table>
108 <keyColumn>id
</keyColumn>
109 <labelColumn>name
</labelColumn>
111 <comment>FK to Financial Type(for membership price sets only).
</comment>
115 <name>financial_type_id
</name>
116 <table>civicrm_financial_type
</table>
118 <onDelete>SET NULL
</onDelete>