[civicrm-core.git] / xml / schema / Campaign / Campaign.xml

<?xml version="1.0" encoding="iso-8859-1" ?>
<table>
  <base>CRM/Campaign</base>
  <class>Campaign</class>
  <name>civicrm_campaign</name>
  <comment>Campaign Details.</comment>
  <add>3.3</add>

  <field>
      <name>id</name>
      <title>Campaign ID</title>
      <type>int unsigned</type>
      <required>true</required>
      <comment>Unique Campaign ID.</comment>
      <import>true</import>
      <add>3.3</add>
  </field>
  <primaryKey>
       <name>id</name>
       <autoincrement>true</autoincrement>
  </primaryKey>

  <field>
      <name>name</name>
      <title>Campaign Name</title>
      <type>varchar</type>
      <length>255</length>
      <required>true</required>
      <comment>Name of the Campaign.</comment>
      <import>true</import>
      <html>
        <type>Text</type>
      </html>
      <add>3.3</add>
  </field>

  <field>
       <name>title</name>
       <title>Campaign Title</title>
       <type>varchar</type>
       <length>255</length>
       <comment>Title of the Campaign.</comment>
       <import>true</import>
       <html>
        <type>Text</type>
      </html>
       <add>3.3</add>
  </field>

  <field>
      <name>description</name>
      <title>Campaign Description</title>
      <type>text</type>
      <html>
        <type>TextArea</type>
        <rows>8</rows>
      </html>
      <cols>60</cols>
      <comment>Full description of Campaign.</comment>
      <add>3.3</add>
  </field>

  <field>
      <name>start_date</name>
      <title>Campaign Start Date</title>
      <type>datetime</type>
      <headerPattern>/^start|(s(tart\s)?date)$/i</headerPattern>
      <comment>Date and time that Campaign starts.</comment>
      <import>true</import>
      <html>
        <type>Select Date</type>
      </html>
      <add>3.3</add>
  </field>

  <field>
      <name>end_date</name>
      <title>Campaign End Date</title>
      <type>datetime</type>
      <headerPattern>/^end|(e(nd\s)?date)$/i</headerPattern>
      <comment>Date and time that Campaign ends.</comment>
      <import>true</import>
      <html>
        <type>Select Date</type>
      </html>
      <add>3.3</add>
  </field>

  <field>
      <name>campaign_type_id</name>
      <title>Campaign Type ID</title>
      <type>int unsigned</type>
      <default>NULL</default>
      <comment>Campaign Type ID.Implicit FK to civicrm_option_value where option_group = campaign_type</comment>
      <import>true</import>
      <pseudoconstant>
        <optionGroupName>campaign_type</optionGroupName>
      </pseudoconstant>
      <add>3.3</add>
  </field>
  <index>
      <name>UI_campaign_type_id</name>
      <fieldName>campaign_type_id</fieldName>
      <add>3.3</add>
  </index>

   <field>
      <name>status_id</name>
      <title>Campaign Status ID</title>
      <type>int unsigned</type>
      <default>NULL</default>
      <comment>Campaign status ID.Implicit FK to civicrm_option_value where option_group = campaign_status</comment>
      <import>true</import>
      <pseudoconstant>
        <optionGroupName>campaign_status</optionGroupName>
      </pseudoconstant>
      <add>3.3</add>
  </field>
  <index>
      <name>UI_campaign_status_id</name>
      <fieldName>status_id</fieldName>
      <add>3.3</add>
  </index>

  <field>
       <name>external_identifier</name>
       <type>varchar</type>
       <length>32</length>
       <headerPattern>/external\s?id/i</headerPattern>
       <dataPattern>/^\d{11,}$/</dataPattern>
       <comment>Unique trusted external ID (generally from a legacy app/datasource). Particularly useful for deduping operations.</comment>
       <import>true</import>
       <add>3.3</add>
  </field>
  <index>
       <name>UI_external_identifier</name>
       <unique>true</unique>
       <fieldName>external_identifier</fieldName>
       <add>3.3</add>
  </index>

  <field>
       <name>parent_id</name>
       <type>int unsigned</type>
       <default>NULL</default>
       <comment>Optional parent id for this Campaign.</comment>
       <import>true</import>
       <add>3.3</add>
  </field>
  <foreignKey>
       <name>parent_id</name>
       <table>civicrm_campaign</table>
       <key>id</key>
       <add>3.3</add>
       <onDelete>SET NULL</onDelete>
  </foreignKey>

  <field>
      <name>is_active</name>
      <type>boolean</type>
      <default>1</default>
      <comment>Is this Campaign enabled or disabled/cancelled?</comment>
      <add>3.3</add>
  </field>

  <field>
      <name>created_id</name>
      <type>int unsigned</type>
      <comment>FK to civicrm_contact, who created this Campaign.</comment>
      <add>3.3</add>
  </field>
  <foreignKey>
      <name>created_id</name>
      <table>civicrm_contact</table>
      <key>id</key>
      <add>3.3</add>
      <onDelete>SET NULL</onDelete>
  </foreignKey>

  <field>
      <name>created_date</name>
      <type>datetime</type>
      <title>Campaign Created Date</title>
      <comment>Date and time that Campaign was created.</comment>
      <add>3.3</add>
  </field>

  <field>
      <name>last_modified_id</name>
      <type>int unsigned</type>
      <comment>FK to civicrm_contact, who recently edited this Campaign.</comment>
      <add>3.3</add>
  </field>
  <foreignKey>
      <name>last_modified_id</name>
      <table>civicrm_contact</table>
      <key>id</key>
      <add>3.3</add>
      <onDelete>SET NULL</onDelete>
  </foreignKey>

  <field>
      <name>last_modified_date</name>
      <type>datetime</type>
      <comment>Date and time that Campaign was edited last time.</comment>
      <add>3.3</add>
  </field>
  <field>
      <name>goal_general</name>
      <type>text</type>
      <title>Campaign Goals</title>
      <comment>General goals for Campaign.</comment>
      <add>3.4</add>
  </field>
  <field>
      <name>goal_revenue</name>
      <type>decimal</type>
      <comment>The target revenue for this campaign.</comment>
      <add>3.4</add>
  </field>
</table>
Commit	Line	Data
6a488035 TO	1	<?xml version="1.0" encoding="iso-8859-1" ?>
	2	<table>
	3	<base>CRM/Campaign</base>
	4	<class>Campaign</class>
	5	<name>civicrm_campaign</name>
	6	<comment>Campaign Details.</comment>
	7	<add>3.3</add>
	8
	9	<field>
	10	<name>id</name>
f813f78e	11	<title>Campaign ID</title>
6a488035 TO	12	<type>int unsigned</type>
	13	<required>true</required>
	14	<comment>Unique Campaign ID.</comment>
	15	<import>true</import>
	16	<add>3.3</add>
	17	</field>
	18	<primaryKey>
	19	<name>id</name>
	20	<autoincrement>true</autoincrement>
	21	</primaryKey>
	22
	23	<field>
	24	<name>name</name>
f813f78e	25	<title>Campaign Name</title>
6a488035 TO	26	<type>varchar</type>
	27	<length>255</length>
	28	<required>true</required>
	29	<comment>Name of the Campaign.</comment>
	30	<import>true</import>
7deea513	31	<html>
	32	<type>Text</type>
	33	</html>
6a488035 TO	34	<add>3.3</add>
	35	</field>
	36
	37	<field>
	38	<name>title</name>
	39	<title>Campaign Title</title>
	40	<type>varchar</type>
	41	<length>255</length>
	42	<comment>Title of the Campaign.</comment>
	43	<import>true</import>
7deea513	44	<html>
	45	<type>Text</type>
	46	</html>
6a488035 TO	47	<add>3.3</add>
	48	</field>
	49
f813f78e	50	<field>
	51	<name>description</name>
	52	<title>Campaign Description</title>
	53	<type>text</type>
7deea513	54	<html>
	55	<type>TextArea</type>
	56	<rows>8</rows>
	57	</html>
6a488035 TO	58	<cols>60</cols>
6a488035 TO	59	<comment>Full description of Campaign.</comment>
f813f78e	60	<add>3.3</add>
f813f78e	61	</field>
6a488035 TO	62
	63	<field>
	64	<name>start_date</name>
	65	<title>Campaign Start Date</title>
	66	<type>datetime</type>
	67	<headerPattern>/^start\|(s(tart\s)?date)$/i</headerPattern>
	68	<comment>Date and time that Campaign starts.</comment>
	69	<import>true</import>
7deea513	70	<html>
	71	<type>Select Date</type>
	72	</html>
6a488035 TO	73	<add>3.3</add>
	74	</field>
	75
	76	<field>
	77	<name>end_date</name>
	78	<title>Campaign End Date</title>
	79	<type>datetime</type>
	80	<headerPattern>/^end\|(e(nd\s)?date)$/i</headerPattern>
	81	<comment>Date and time that Campaign ends.</comment>
	82	<import>true</import>
7deea513	83	<html>
	84	<type>Select Date</type>
	85	</html>
6a488035 TO	86	<add>3.3</add>
	87	</field>
	88
f813f78e	89	<field>
	90	<name>campaign_type_id</name>
	91	<title>Campaign Type ID</title>
	92	<type>int unsigned</type>
	93	<default>NULL</default>
3c7d2158	94	<comment>Campaign Type ID.Implicit FK to civicrm_option_value where option_group = campaign_type</comment>
6a488035	95	<import>true</import>
3f3a3ba0 CW	96	<pseudoconstant>
	97	<optionGroupName>campaign_type</optionGroupName>
	98	</pseudoconstant>
3c7d2158	99	<add>3.3</add>
3c7d2158	100	</field>
6a488035 TO	101	<index>
	102	<name>UI_campaign_type_id</name>
	103	<fieldName>campaign_type_id</fieldName>
	104	<add>3.3</add>
	105	</index>
	106
f813f78e	107	<field>
f813f78e	108	<name>status_id</name>
6a488035 TO	109	<title>Campaign Status ID</title>
	110	<type>int unsigned</type>
	111	<default>NULL</default>
	112	<comment>Campaign status ID.Implicit FK to civicrm_option_value where option_group = campaign_status</comment>
	113	<import>true</import>
3f3a3ba0 CW	114	<pseudoconstant>
	115	<optionGroupName>campaign_status</optionGroupName>
	116	</pseudoconstant>
3c7d2158	117	<add>3.3</add>
6a488035 TO	118	</field>
	119	<index>
	120	<name>UI_campaign_status_id</name>
	121	<fieldName>status_id</fieldName>
	122	<add>3.3</add>
	123	</index>
	124
	125	<field>
	126	<name>external_identifier</name>
	127	<type>varchar</type>
	128	<length>32</length>
	129	<headerPattern>/external\s?id/i</headerPattern>
	130	<dataPattern>/^\d{11,}$/</dataPattern>
	131	<comment>Unique trusted external ID (generally from a legacy app/datasource). Particularly useful for deduping operations.</comment>
	132	<import>true</import>
	133	<add>3.3</add>
	134	</field>
	135	<index>
	136	<name>UI_external_identifier</name>
	137	<unique>true</unique>
	138	<fieldName>external_identifier</fieldName>
	139	<add>3.3</add>
	140	</index>
	141
	142	<field>
	143	<name>parent_id</name>
	144	<type>int unsigned</type>
	145	<default>NULL</default>
	146	<comment>Optional parent id for this Campaign.</comment>
	147	<import>true</import>
	148	<add>3.3</add>
	149	</field>
	150	<foreignKey>
	151	<name>parent_id</name>
	152	<table>civicrm_campaign</table>
	153	<key>id</key>
	154	<add>3.3</add>
	155	<onDelete>SET NULL</onDelete>
	156	</foreignKey>
	157
f813f78e	158	<field>
f813f78e	159	<name>is_active</name>
6a488035	160	<type>boolean</type>
f813f78e	161	<default>1</default>
	162	<comment>Is this Campaign enabled or disabled/cancelled?</comment>
	163	<add>3.3</add>
	164	</field>
6a488035 TO	165
	166	<field>
	167	<name>created_id</name>
	168	<type>int unsigned</type>
	169	<comment>FK to civicrm_contact, who created this Campaign.</comment>
	170	<add>3.3</add>
	171	</field>
	172	<foreignKey>
	173	<name>created_id</name>
	174	<table>civicrm_contact</table>
	175	<key>id</key>
	176	<add>3.3</add>
	177	<onDelete>SET NULL</onDelete>
	178	</foreignKey>
	179
	180	<field>
	181	<name>created_date</name>
	182	<type>datetime</type>
	183	<title>Campaign Created Date</title>
	184	<comment>Date and time that Campaign was created.</comment>
	185	<add>3.3</add>
	186	</field>
	187
	188	<field>
	189	<name>last_modified_id</name>
	190	<type>int unsigned</type>
	191	<comment>FK to civicrm_contact, who recently edited this Campaign.</comment>
	192	<add>3.3</add>
	193	</field>
	194	<foreignKey>
	195	<name>last_modified_id</name>
	196	<table>civicrm_contact</table>
	197	<key>id</key>
	198	<add>3.3</add>
	199	<onDelete>SET NULL</onDelete>
	200	</foreignKey>
	201
	202	<field>
	203	<name>last_modified_date</name>
	204	<type>datetime</type>
	205	<comment>Date and time that Campaign was edited last time.</comment>
	206	<add>3.3</add>
	207	</field>
f813f78e	208	<field>
	209	<name>goal_general</name>
	210	<type>text</type>
	211	<title>Campaign Goals</title>
6a488035	212	<comment>General goals for Campaign.</comment>
f813f78e	213	<add>3.4</add>
f813f78e	214	</field>
6a488035	215	<field>
f813f78e	216	<name>goal_revenue</name>
	217	<type>decimal</type>
	218	<comment>The target revenue for this campaign.</comment>
	219	<add>3.4</add>
6a488035 TO	220	</field>
6a488035 TO	221	</table>