fix version in header
[civicrm-core.git] / xml / schema / Price / PriceSetEntity.xml
CommitLineData
6a488035
TO
1<?xml version="1.0" encoding="iso-8859-1" ?>
2
3<table>
4 <base>CRM/Price</base>
9da8dc8c 5 <class>PriceSetEntity</class>
6a488035
TO
6 <name>civicrm_price_set_entity</name>
7 <add>1.8</add>
8 <log>true</log>
9 <field>
5435b737
EM
10 <name>id</name>
11 <type>int unsigned</type>
12 <required>true</required>
13 <comment>Price Set Entity</comment>
14 <add>1.8</add>
6a488035
TO
15 </field>
16 <primaryKey>
5435b737
EM
17 <name>id</name>
18 <autoincrement>true</autoincrement>
6a488035
TO
19 </primaryKey>
20 <field>
5435b737
EM
21 <name>entity_table</name>
22 <type>varchar</type>
23 <length>64</length>
24 <required>true</required>
25 <comment>Table which uses this price set</comment>
26 <add>1.8</add>
6a488035
TO
27 </field>
28 <field>
5435b737
EM
29 <name>entity_id</name>
30 <type>int unsigned</type>
31 <required>true</required>
32 <comment>Item in table</comment>
33 <add>1.8</add>
6a488035 34 </field>
71e5aa5c 35 <dynamicForeignKey>
5435b737
EM
36 <idColumn>entity_id</idColumn>
37 <typeColumn>entity_table</typeColumn>
38 <add>1.8</add>
71e5aa5c 39 </dynamicForeignKey>
6a488035 40 <field>
5435b737
EM
41 <name>price_set_id</name>
42 <type>int unsigned</type>
43 <required>true</required>
44 <comment>price set being used</comment>
45 <add>1.8</add>
6a488035
TO
46 </field>
47 <foreignKey>
5435b737
EM
48 <name>price_set_id</name>
49 <table>civicrm_price_set</table>
50 <key>id</key>
6a488035
TO
51 </foreignKey>
52 <index>
5435b737
EM
53 <name>UI_entity</name>
54 <fieldName>entity_table</fieldName>
55 <fieldName>entity_id</fieldName>
56 <unique>true</unique>
57 <add>1.8</add>
6a488035
TO
58 </index>
59</table>
60