Merge pull request #19525 from eileenmcnaughton/member_soft
[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>
d31fb4e3 8 <component>CiviCampaign</component>
6a488035
TO
9 <field>
10 <name>id</name>
f3ea5182 11 <title>Campaign Group ID</title>
6a488035
TO
12 <type>int unsigned</type>
13 <required>true</required>
14 <comment>Campaign Group id.</comment>
0481e12c
A
15 <html>
16 <type>Number</type>
17 </html>
6a488035
TO
18 <add>3.3</add>
19 </field>
20 <primaryKey>
21 <name>id</name>
22 <autoincrement>true</autoincrement>
23 </primaryKey>
3c7d2158 24
6a488035
TO
25 <field>
26 <name>campaign_id</name>
57e94608 27 <title>Campaign ID</title>
6a488035
TO
28 <type>int unsigned</type>
29 <required>true</required>
30 <comment>Foreign key to the activity Campaign.</comment>
57e94608
A
31 <html>
32 <label>Campaign</label>
33 </html>
6a488035
TO
34 <add>3.3</add>
35 </field>
36 <foreignKey>
37 <name>campaign_id</name>
38 <table>civicrm_campaign</table>
39 <key>id</key>
40 <add>3.3</add>
41 <onDelete>CASCADE</onDelete>
42 </foreignKey>
43
44 <field>
45 <name>group_type</name>
f3ea5182 46 <title>Campaign Group Type</title>
be622aca 47 <type>varchar</type>
48 <length>8</length>
6a488035
TO
49 <default>NULL</default>
50 <comment>Type of Group.</comment>
f80ce889 51 <pseudoconstant>
93bfa565 52 <callback>CRM_Core_SelectValues::getCampaignGroupTypes</callback>
f80ce889 53 </pseudoconstant>
614d72ec 54 <html>
55 <type>Select</type>
56 </html>
6a488035
TO
57 </field>
58
3c7d2158 59 <field>
6a488035 60 <name>entity_table</name>
f3ea5182 61 <title>Entity Table</title>
6a488035 62 <type>varchar</type>
3c7d2158 63 <length>64</length>
6a488035
TO
64 <default>NULL</default>
65 <comment>Name of table where item being referenced is stored.</comment>
66 <add>3.3</add>
67 </field>
68
69 <field>
70 <name>entity_id</name>
f3ea5182 71 <title>Entity ID</title>
6a488035
TO
72 <type>int unsigned</type>
73 <default>NULL</default>
74 <comment>Entity id of referenced table.</comment>
75 <add>3.3</add>
76 </field>
71e5aa5c
ARW
77
78 <dynamicForeignKey>
79 <idColumn>entity_id</idColumn>
80 <typeColumn>entity_table</typeColumn>
81 <add>3.3</add>
82 </dynamicForeignKey>
6a488035 83</table>