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>
60 <name>total_cost
</name>
62 <required>true
</required>
64 <headerPattern>/^total|(.?^am(ou)?nt)/i
</headerPattern>
65 <dataPattern>/^\d+(\.\d{
2})?$/
</dataPattern>
66 <comment>quantity X civicrm_product.cost.
</comment>
71 <name>fulfilled_date
</name>
73 <title>Fulfilled Date
</title>
75 <comment>Optional. Can be used to record the date this product was fulfilled or shipped.
</comment>
79 <name>start_date
</name>
80 <uniqueName>contribution_start_date
</uniqueName>
81 <title>Start date for premium
</title>
84 <comment>Actual start date for a time-delimited premium (subscription, service or membership)
</comment>
89 <uniqueName>contribution_end_date
</uniqueName>
91 <title>End date for premium
</title>
93 <comment>Actual end date for a time-delimited premium (subscription, service or membership)
</comment>
98 <title>Premium comment
</title>
103 <name>financial_type_id
</name>
104 <title>Financial Type
</title>
105 <type>int unsigned
</type>
106 <default>NULL
</default>
108 <table>civicrm_financial_type
</table>
109 <keyColumn>id
</keyColumn>
110 <labelColumn>name
</labelColumn>
112 <comment>FK to Financial Type(for membership price sets only).
</comment>
116 <name>financial_type_id
</name>
117 <table>civicrm_financial_type
</table>
119 <onDelete>SET NULL
</onDelete>