Merge pull request #3066 from relldoesphp/CRM-14466
[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>
f80ce889 47 <pseudoconstant>
93bfa565 48 <callback>CRM_Core_SelectValues::getCampaignGroupTypes</callback>
f80ce889 49 </pseudoconstant>
614d72ec 50 <html>
51 <type>Select</type>
52 </html>
6a488035
TO
53 </field>
54
3c7d2158 55 <field>
6a488035
TO
56 <name>entity_table</name>
57 <type>varchar</type>
3c7d2158 58 <length>64</length>
6a488035
TO
59 <default>NULL</default>
60 <comment>Name of table where item being referenced is stored.</comment>
61 <add>3.3</add>
62 </field>
63
64 <field>
65 <name>entity_id</name>
66 <type>int unsigned</type>
67 <default>NULL</default>
68 <comment>Entity id of referenced table.</comment>
69 <add>3.3</add>
70 </field>
71e5aa5c
ARW
71
72 <dynamicForeignKey>
73 <idColumn>entity_id</idColumn>
74 <typeColumn>entity_table</typeColumn>
75 <add>3.3</add>
76 </dynamicForeignKey>
6a488035 77</table>