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