CRM-14181, remove special handing for enums
[civicrm-core.git] / xml / schema / Campaign / CampaignGroup.xml
CommitLineData
6a488035
TO
1<?xml version="1.0" encoding="iso-8859-1" ?>
2<table>
3 <base>CRM/Campaign</base>
4 <class>CampaignGroup</class>
5 <name>civicrm_campaign_group</name>
6 <comment>Campaign Group Details.</comment>
7 <add>3.3</add>
3c7d2158 8
6a488035
TO
9 <field>
10 <name>id</name>
11 <type>int unsigned</type>
12 <required>true</required>
13 <comment>Campaign Group id.</comment>
14 <add>3.3</add>
15 </field>
16 <primaryKey>
17 <name>id</name>
18 <autoincrement>true</autoincrement>
19 </primaryKey>
3c7d2158 20
6a488035
TO
21 <field>
22 <name>campaign_id</name>
23 <type>int unsigned</type>
24 <required>true</required>
25 <comment>Foreign key to the activity Campaign.</comment>
3e3eacd0
CW
26 <pseudoconstant>
27 <table>civicrm_campaign</table>
28 <keyColumn>id</keyColumn>
29 <labelColumn>title</labelColumn>
3e3eacd0 30 </pseudoconstant>
6a488035
TO
31 <add>3.3</add>
32 </field>
33 <foreignKey>
34 <name>campaign_id</name>
35 <table>civicrm_campaign</table>
36 <key>id</key>
37 <add>3.3</add>
38 <onDelete>CASCADE</onDelete>
39 </foreignKey>
40
41 <field>
42 <name>group_type</name>
be622aca 43 <type>varchar</type>
44 <length>8</length>
6a488035
TO
45 <default>NULL</default>
46 <comment>Type of Group.</comment>
614d72ec 47 <html>
48 <type>Select</type>
49 </html>
6a488035
TO
50 </field>
51
3c7d2158 52 <field>
6a488035
TO
53 <name>entity_table</name>
54 <type>varchar</type>
3c7d2158 55 <length>64</length>
6a488035
TO
56 <default>NULL</default>
57 <comment>Name of table where item being referenced is stored.</comment>
58 <add>3.3</add>
59 </field>
60
61 <field>
62 <name>entity_id</name>
63 <type>int unsigned</type>
64 <default>NULL</default>
65 <comment>Entity id of referenced table.</comment>
66 <add>3.3</add>
67 </field>
71e5aa5c
ARW
68
69 <dynamicForeignKey>
70 <idColumn>entity_id</idColumn>
71 <typeColumn>entity_table</typeColumn>
72 <add>3.3</add>
73 </dynamicForeignKey>
6a488035 74</table>