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

<?xml version="1.0" encoding="iso-8859-1" ?>
<table>
  <base>CRM/Activity</base>
  <class>Activity</class>
  <name>civicrm_activity</name>
  <description>Past or future actions concerning one or more contacts.</description>
  <comment>Other Activity details stored here include contact, location, details.</comment>
  <add>1.1</add>
  <log>true</log>
  <icon>fa-tasks</icon>
  <labelField>subject</labelField>
  <paths>
    <add>civicrm/activity?reset=1&amp;action=add&amp;context=standalone</add>
    <view>civicrm/activity?reset=1&amp;action=view&amp;id=[id]</view>
    <update>civicrm/activity/add?reset=1&amp;action=update&amp;id=[id]</update>
    <delete>civicrm/activity?reset=1&amp;action=delete&amp;id=[id]</delete>
  </paths>
  <field>
    <name>id</name>
    <uniqueName>activity_id</uniqueName>
    <title>Activity ID</title>
    <import>true</import>
    <type>int unsigned</type>
    <required>true</required>
    <comment>Unique  Other Activity ID</comment>
    <html>
      <type>Number</type>
    </html>
    <add>1.1</add>
  </field>
  <primaryKey>
    <name>id</name>
    <autoincrement>true</autoincrement>
  </primaryKey>
  <field>
    <name>source_record_id</name>
    <type>int unsigned</type>
    <title>Source Record</title>
    <comment>Artificial FK to original transaction (e.g. contribution) IF it is not an Activity. Table can be figured out through activity_type_id, and further through component registry.</comment>
    <readonly>true</readonly>
    <add>2.0</add>
  </field>
  <index>
    <name>UI_source_record_id</name>
    <fieldName>source_record_id</fieldName>
    <add>3.2</add>
  </index>
  <field>
    <name>activity_type_id</name>
    <title>Activity Type ID</title>
    <import>true</import>
    <type>int unsigned</type>
    <required>true</required>
    <export>true</export>
    <default>1</default>
    <headerPattern>/(activity.)?type(.id$)/i</headerPattern>
    <comment>FK to civicrm_option_value.id, that has to be valid, registered activity type.</comment>
    <add>1.1</add>
    <pseudoconstant>
      <optionGroupName>activity_type</optionGroupName>
    </pseudoconstant>
    <html>
      <type>Select</type>
      <label>Activity Type</label>
    </html>
  </field>
  <index>
    <name>UI_activity_type_id</name>
    <fieldName>activity_type_id</fieldName>
    <add>1.6</add>
  </index>
  <field>
    <name>subject</name>
    <uniqueName>activity_subject</uniqueName>
    <type>varchar</type>
    <title>Subject</title>
    <length>255</length>
    <comment>The subject/purpose/short description of the activity.</comment>
    <import>true</import>
    <headerPattern>/(activity.)?subject/i</headerPattern>
    <html>
      <type>Text</type>
    </html>
    <add>1.1</add>
    <change>2.0</change>
  </field>
  <field>
    <name>activity_date_time</name>
    <import>true</import>
    <required>false</required>
    <export>true</export>
    <default>CURRENT_TIMESTAMP</default>
    <title>Activity Date</title>
    <type>datetime</type>
    <headerPattern>/(activity.)?date(.time$)?/i</headerPattern>
    <comment>Date and time this activity is scheduled to occur. Formerly named scheduled_date_time.</comment>
    <html>
      <type>Select Date</type>
      <formatType>activityDateTime</formatType>
    </html>
    <add>2.0</add>
  </field>
  <index>
    <name>index_activity_date_time</name>
    <fieldName>activity_date_time</fieldName>
    <add>4.7</add>
  </index>
  <field>
    <name>duration</name>
    <uniqueName>activity_duration</uniqueName>
    <title>Duration</title>
    <import>true</import>
    <type>int unsigned</type>
    <headerPattern>/(activity.)?duration(s)?$/i</headerPattern>
    <comment>Planned or actual duration of activity expressed in minutes. Conglomerate of former duration_hours and duration_minutes.</comment>
    <add>2.0</add>
    <html>
      <type>Number</type>
    </html>
  </field>
  <field>
    <name>location</name>
    <uniqueName>activity_location</uniqueName>
    <title>Location</title>
    <import>true</import>
    <type>varchar</type>
    <length>255</length>
    <headerPattern>/(activity.)?location$/i</headerPattern>
    <comment>Location of the activity (optional, open text).</comment>
    <html>
      <type>Text</type>
    </html>
    <add>1.1</add>
  </field>
  <field>
    <name>phone_id</name>
    <type>int unsigned</type>
    <title>Phone ID (called)</title>
    <comment>Phone ID of the number called (optional - used if an existing phone number is selected).</comment>
    <add>2.0</add>
    <html>
      <type>EntityRef</type>
      <label>Phone (called)</label>
    </html>
  </field>
  <foreignKey>
    <name>phone_id</name>
    <table>civicrm_phone</table>
    <key>id</key>
    <add>2.0</add>
    <onDelete>SET NULL</onDelete>
  </foreignKey>
  <field>
    <name>phone_number</name>
    <title>Phone (called) Number</title>
    <type>varchar</type>
    <length>64</length>
    <comment>Phone number in case the number does not exist in the civicrm_phone table.</comment>
    <html>
      <type>Text</type>
    </html>
    <add>2.0</add>
  </field>
  <field>
    <name>details</name>
    <uniqueName>activity_details</uniqueName>
    <title>Details</title>
    <import>true</import>
    <type>longtext</type>
    <headerPattern>/(activity.)?detail(s)?$/i</headerPattern>
    <comment>Details about the activity (agenda, notes, etc).</comment>
    <html>
      <type>RichTextEditor</type>
      <rows>8</rows>
      <cols>60</cols>
    </html>
    <add>1.1</add>
  </field>
  <field>
    <name>status_id</name>
    <uniqueName>activity_status_id</uniqueName>
    <title>Activity Status</title>
    <import>true</import>
    <export>true</export>
    <headerPattern>/(activity.)?status(.label$)?/i</headerPattern>
    <type>int unsigned</type>
    <comment>ID of the status this activity is currently in. Foreign key to civicrm_option_value.</comment>
    <add>2.0</add>
    <pseudoconstant>
      <optionGroupName>activity_status</optionGroupName>
    </pseudoconstant>
    <html>
      <type>Select</type>
    </html>
  </field>
  <index>
    <name>index_status_id</name>
    <fieldName>status_id</fieldName>
    <add>4.7</add>
  </index>
  <field>
    <name>priority_id</name>
    <type>int unsigned</type>
    <title>Priority</title>
    <export>true</export>
    <import>true</import>
    <comment>ID of the priority given to this activity. Foreign key to civicrm_option_value.</comment>
    <add>2.0</add>
    <pseudoconstant>
      <optionGroupName>priority</optionGroupName>
    </pseudoconstant>
    <html>
      <type>Select</type>
    </html>
  </field>
  <field>
    <name>parent_id</name>
    <title>Parent Activity ID</title>
    <type>int unsigned</type>
    <comment>Parent meeting ID (if this is a follow-up item). This is not currently implemented</comment>
    <readonly>true</readonly>
    <html>
      <label>Parent Activity</label>
    </html>
    <add>1.1</add>
  </field>
  <foreignKey>
    <name>parent_id</name>
    <table>civicrm_activity</table>
    <key>id</key>
    <add>1.1</add>
    <onDelete>CASCADE</onDelete>
  </foreignKey>
  <field>
    <name>is_test</name>
    <title>Test</title>
    <uniqueName>activity_is_test</uniqueName>
    <type>boolean</type>
    <default>0</default>
    <import>true</import>
    <headerPattern>/(is.)?test(.activity)?/i</headerPattern>
    <add>2.0</add>
    <html>
      <type>CheckBox</type>
    </html>
  </field>
  <field>
    <name>medium_id</name>
    <uniqueName>activity_medium_id</uniqueName>
    <title>Activity Medium</title>
    <type>int unsigned</type>
    <default>NULL</default>
    <comment>Activity Medium, Implicit FK to civicrm_option_value where option_group = encounter_medium.</comment>
    <pseudoconstant>
      <optionGroupName>encounter_medium</optionGroupName>
    </pseudoconstant>
    <html>
      <type>Select</type>
    </html>
    <add>2.2</add>
  </field>
  <index>
    <name>index_medium_id</name>
    <fieldName>medium_id</fieldName>
    <add>2.2</add>
    <drop>5.28</drop>
  </index>
  <field>
    <name>is_auto</name>
    <title>Auto</title>
    <type>boolean</type>
    <default>0</default>
    <add>2.2</add>
  </field>
  <field>
    <name>relationship_id</name>
    <title>Relationship ID</title>
    <type>int unsigned</type>
    <default>NULL</default>
    <comment>FK to Relationship ID</comment>
    <html>
      <label>Relationship</label>
    </html>
    <add>2.2</add>
  </field>
  <foreignKey>
    <name>relationship_id</name>
    <table>civicrm_relationship</table>
    <key>id</key>
    <onDelete>SET NULL</onDelete>
  </foreignKey>
  <field>
    <name>is_current_revision</name>
    <title>Is this activity a current revision in versioning chain?</title>
    <type>boolean</type>
    <default>1</default>
    <import>true</import>
    <headerPattern>/(is.)?(current.)?(revision|version(ing)?)/i</headerPattern>
    <add>2.2</add>
  </field>
  <index>
    <name>index_is_current_revision</name>
    <fieldName>is_current_revision</fieldName>
    <add>2.2</add>
  </index>
  <field>
    <name>original_id</name>
    <type>int unsigned</type>
    <title>Original Activity ID</title>
    <comment>Activity ID of the first activity record in versioning chain.</comment>
    <readonly>true</readonly>
    <html>
      <label>Original Activity</label>
    </html>
    <add>2.2</add>
  </field>
  <foreignKey>
    <name>original_id</name>
    <table>civicrm_activity</table>
    <key>id</key>
    <add>2.2</add>
    <onDelete>CASCADE</onDelete>
  </foreignKey>
  <field>
    <name>result</name>
    <uniqueName>activity_result</uniqueName>
    <type>varchar</type>
    <title>Result</title>
    <length>255</length>
    <comment>Currently being used to store result id for survey activity, FK to option value.</comment>
    <add>3.3</add>
  </field>
  <field>
    <name>is_deleted</name>
    <uniqueName>activity_is_deleted</uniqueName>
    <title>Activity is in the Trash</title>
    <type>boolean</type>
    <default>0</default>
    <import>true</import>
    <headerPattern>/(activity.)?(trash|deleted)/i</headerPattern>
    <add>2.2</add>
    <html>
      <type>CheckBox</type>
    </html>
  </field>
  <index>
    <name>index_is_deleted</name>
    <fieldName>is_deleted</fieldName>
    <add>2.2</add>
  </index>
  <field>
    <name>campaign_id</name>
    <component>CiviCampaign</component>
    <uniqueName>activity_campaign_id</uniqueName>
    <type>int unsigned</type>
    <title>Campaign ID</title>
    <import>true</import>
    <comment>The campaign for which this activity has been triggered.</comment>
    <add>3.4</add>
    <html>
      <type>EntityRef</type>
      <label>Campaign</label>
    </html>
    <pseudoconstant>
      <table>civicrm_campaign</table>
      <keyColumn>id</keyColumn>
      <labelColumn>title</labelColumn>
      <prefetch>FALSE</prefetch>
    </pseudoconstant>
  </field>
  <foreignKey>
    <name>campaign_id</name>
    <table>civicrm_campaign</table>
    <key>id</key>
    <onDelete>SET NULL</onDelete>
  </foreignKey>
  <field>
    <name>engagement_level</name>
    <uniqueName>activity_engagement_level</uniqueName>
    <type>int unsigned</type>
    <title>Engagement Index</title>
    <import>true</import>
    <comment>Assign a specific level of engagement to this activity. Used for tracking constituents in ladder of engagement.</comment>
    <pseudoconstant>
      <optionGroupName>engagement_index</optionGroupName>
    </pseudoconstant>
    <html>
      <type>Select</type>
    </html>
    <add>3.4</add>
  </field>
  <field>
    <name>weight</name>
    <title>Order</title>
    <type>int</type>
    <add>4.1</add>
  </field>
  <field>
    <name>is_star</name>
    <title>Is Starred</title>
    <type>boolean</type>
    <default>0</default>
    <import>true</import>
    <comment>Activity marked as favorite.</comment>
    <headerPattern>/(activity.)?(star|favorite)/i</headerPattern>
    <add>4.7</add>
    <html>
      <type>Checkbox</type>
    </html>
  </field>
  <field>
    <name>created_date</name>
    <uniqueName>activity_created_date</uniqueName>
    <type>timestamp</type>
    <comment>When was the activity was created.</comment>
    <required>false</required>
    <export>true</export>
    <default>CURRENT_TIMESTAMP</default>
    <html>
      <label>Created Date</label>
    </html>
    <add>4.7</add>
  </field>
  <field>
    <name>modified_date</name>
    <uniqueName>activity_modified_date</uniqueName>
    <type>timestamp</type>
    <comment>When was the activity (or closely related entity) was created or modified or deleted.</comment>
    <required>false</required>
    <export>true</export>
    <default>CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP</default>
    <html>
      <label>Modified Date</label>
    </html>
    <readonly>true</readonly>
    <add>4.7</add>
  </field>
</table>
Commit	Line	Data
6a488035 TO	1	<?xml version="1.0" encoding="iso-8859-1" ?>
	2	<table>
	3	<base>CRM/Activity</base>
	4	<class>Activity</class>
	5	<name>civicrm_activity</name>
2562d09a	6	<description>Past or future actions concerning one or more contacts.</description>
165a7fc0	7	<comment>Other Activity details stored here include contact, location, details.</comment>
6a488035 TO	8	<add>1.1</add>
6a488035 TO	9	<log>true</log>
449c4e6b	10	<icon>fa-tasks</icon>
8ab43c93	11	<labelField>subject</labelField>
a7bd99ff	12	<paths>
5c385299	13	<add>civicrm/activity?reset=1&action=add&context=standalone</add>
a7bd99ff	14	<view>civicrm/activity?reset=1&action=view&id=[id]</view>
5c385299	15	<update>civicrm/activity/add?reset=1&action=update&id=[id]</update>
a7bd99ff CW	16	<delete>civicrm/activity?reset=1&action=delete&id=[id]</delete>
a7bd99ff CW	17	</paths>
6a488035	18	<field>
29e8791c EM	19	<name>id</name>
	20	<uniqueName>activity_id</uniqueName>
	21	<title>Activity ID</title>
	22	<import>true</import>
	23	<type>int unsigned</type>
	24	<required>true</required>
	25	<comment>Unique Other Activity ID</comment>
0481e12c A	26	<html>
	27	<type>Number</type>
	28	</html>
29e8791c	29	<add>1.1</add>
6a488035 TO	30	</field>
6a488035 TO	31	<primaryKey>
29e8791c EM	32	<name>id</name>
29e8791c EM	33	<autoincrement>true</autoincrement>
6a488035	34	</primaryKey>
6a488035	35	<field>
29e8791c EM	36	<name>source_record_id</name>
	37	<type>int unsigned</type>
	38	<title>Source Record</title>
	39	<comment>Artificial FK to original transaction (e.g. contribution) IF it is not an Activity. Table can be figured out through activity_type_id, and further through component registry.</comment>
58b0bf5a	40	<readonly>true</readonly>
29e8791c	41	<add>2.0</add>
6a488035 TO	42	</field>
6a488035 TO	43	<index>
29e8791c EM	44	<name>UI_source_record_id</name>
	45	<fieldName>source_record_id</fieldName>
	46	<add>3.2</add>
6a488035 TO	47	</index>
6a488035 TO	48	<field>
29e8791c	49	<name>activity_type_id</name>
a1d226d6	50	<title>Activity Type ID</title>
29e8791c EM	51	<import>true</import>
	52	<type>int unsigned</type>
	53	<required>true</required>
9ab34172	54	<export>true</export>
29e8791c EM	55	<default>1</default>
	56	<headerPattern>/(activity.)?type(.id$)/i</headerPattern>
	57	<comment>FK to civicrm_option_value.id, that has to be valid, registered activity type.</comment>
	58	<add>1.1</add>
	59	<pseudoconstant>
	60	<optionGroupName>activity_type</optionGroupName>
	61	</pseudoconstant>
	62	<html>
	63	<type>Select</type>
a1d226d6	64	<label>Activity Type</label>
29e8791c	65	</html>
6a488035 TO	66	</field>
6a488035 TO	67	<index>
29e8791c EM	68	<name>UI_activity_type_id</name>
	69	<fieldName>activity_type_id</fieldName>
	70	<add>1.6</add>
6a488035	71	</index>
6a488035	72	<field>
29e8791c EM	73	<name>subject</name>
	74	<uniqueName>activity_subject</uniqueName>
	75	<type>varchar</type>
	76	<title>Subject</title>
	77	<length>255</length>
	78	<comment>The subject/purpose/short description of the activity.</comment>
	79	<import>true</import>
	80	<headerPattern>/(activity.)?subject/i</headerPattern>
	81	<html>
	82	<type>Text</type>
	83	</html>
	84	<add>1.1</add>
a8162657	85	<change>2.0</change>
6a488035	86	</field>
6a488035	87	<field>
29e8791c EM	88	<name>activity_date_time</name>
29e8791c EM	89	<import>true</import>
487813ab MW	90	<required>false</required>
	91	<export>true</export>
	92	<default>CURRENT_TIMESTAMP</default>
29e8791c EM	93	<title>Activity Date</title>
	94	<type>datetime</type>
	95	<headerPattern>/(activity.)?date(.time$)?/i</headerPattern>
	96	<comment>Date and time this activity is scheduled to occur. Formerly named scheduled_date_time.</comment>
	97	<html>
	98	<type>Select Date</type>
24317d89	99	<formatType>activityDateTime</formatType>
29e8791c EM	100	</html>
29e8791c EM	101	<add>2.0</add>
3f3a3ba0	102	</field>
ab49600a SL	103	<index>
	104	<name>index_activity_date_time</name>
	105	<fieldName>activity_date_time</fieldName>
	106	<add>4.7</add>
	107	</index>
6a488035	108	<field>
29e8791c EM	109	<name>duration</name>
	110	<uniqueName>activity_duration</uniqueName>
	111	<title>Duration</title>
	112	<import>true</import>
	113	<type>int unsigned</type>
	114	<headerPattern>/(activity.)?duration(s)?$/i</headerPattern>
	115	<comment>Planned or actual duration of activity expressed in minutes. Conglomerate of former duration_hours and duration_minutes.</comment>
	116	<add>2.0</add>
	117	<html>
3542118f	118	<type>Number</type>
29e8791c	119	</html>
6a488035	120	</field>
6a488035	121	<field>
29e8791c EM	122	<name>location</name>
	123	<uniqueName>activity_location</uniqueName>
	124	<title>Location</title>
	125	<import>true</import>
	126	<type>varchar</type>
	127	<length>255</length>
	128	<headerPattern>/(activity.)?location$/i</headerPattern>
	129	<comment>Location of the activity (optional, open text).</comment>
	130	<html>
	131	<type>Text</type>
	132	</html>
	133	<add>1.1</add>
6a488035	134	</field>
6a488035	135	<field>
29e8791c EM	136	<name>phone_id</name>
29e8791c EM	137	<type>int unsigned</type>
57e94608	138	<title>Phone ID (called)</title>
29e8791c EM	139	<comment>Phone ID of the number called (optional - used if an existing phone number is selected).</comment>
	140	<add>2.0</add>
	141	<html>
916b6181	142	<type>EntityRef</type>
a1d226d6	143	<label>Phone (called)</label>
29e8791c	144	</html>
6a488035 TO	145	</field>
6a488035 TO	146	<foreignKey>
29e8791c EM	147	<name>phone_id</name>
	148	<table>civicrm_phone</table>
	149	<key>id</key>
	150	<add>2.0</add>
	151	<onDelete>SET NULL</onDelete>
6a488035	152	</foreignKey>
6a488035	153	<field>
29e8791c EM	154	<name>phone_number</name>
	155	<title>Phone (called) Number</title>
	156	<type>varchar</type>
	157	<length>64</length>
	158	<comment>Phone number in case the number does not exist in the civicrm_phone table.</comment>
	159	<html>
	160	<type>Text</type>
	161	</html>
	162	<add>2.0</add>
6a488035	163	</field>
6a488035	164	<field>
29e8791c EM	165	<name>details</name>
	166	<uniqueName>activity_details</uniqueName>
	167	<title>Details</title>
	168	<import>true</import>
07f093c3	169	<type>longtext</type>
29e8791c EM	170	<headerPattern>/(activity.)?detail(s)?$/i</headerPattern>
	171	<comment>Details about the activity (agenda, notes, etc).</comment>
	172	<html>
	173	<type>RichTextEditor</type>
	174	<rows>8</rows>
	175	<cols>60</cols>
	176	</html>
	177	<add>1.1</add>
6a488035	178	</field>
6a488035	179	<field>
29e8791c EM	180	<name>status_id</name>
	181	<uniqueName>activity_status_id</uniqueName>
	182	<title>Activity Status</title>
	183	<import>true</import>
a0655ae9	184	<export>true</export>
29e8791c EM	185	<headerPattern>/(activity.)?status(.label$)?/i</headerPattern>
	186	<type>int unsigned</type>
	187	<comment>ID of the status this activity is currently in. Foreign key to civicrm_option_value.</comment>
	188	<add>2.0</add>
	189	<pseudoconstant>
	190	<optionGroupName>activity_status</optionGroupName>
	191	</pseudoconstant>
	192	<html>
	193	<type>Select</type>
	194	</html>
	195	</field>
5b3543ce JM	196	<index>
	197	<name>index_status_id</name>
	198	<fieldName>status_id</fieldName>
	199	<add>4.7</add>
	200	</index>
29e8791c EM	201	<field>
	202	<name>priority_id</name>
	203	<type>int unsigned</type>
	204	<title>Priority</title>
6c0c4ac7	205	<export>true</export>
6c0c4ac7	206	<import>true</import>
29e8791c EM	207	<comment>ID of the priority given to this activity. Foreign key to civicrm_option_value.</comment>
	208	<add>2.0</add>
	209	<pseudoconstant>
	210	<optionGroupName>priority</optionGroupName>
	211	</pseudoconstant>
	212	<html>
	213	<type>Select</type>
	214	</html>
	215	</field>
	216	<field>
	217	<name>parent_id</name>
57e94608	218	<title>Parent Activity ID</title>
29e8791c EM	219	<type>int unsigned</type>
29e8791c EM	220	<comment>Parent meeting ID (if this is a follow-up item). This is not currently implemented</comment>
58b0bf5a	221	<readonly>true</readonly>
57e94608 A	222	<html>
	223	<label>Parent Activity</label>
	224	</html>
29e8791c	225	<add>1.1</add>
6a488035 TO	226	</field>
6a488035 TO	227	<foreignKey>
29e8791c EM	228	<name>parent_id</name>
	229	<table>civicrm_activity</table>
	230	<key>id</key>
	231	<add>1.1</add>
	232	<onDelete>CASCADE</onDelete>
6a488035	233	</foreignKey>
6a488035	234	<field>
29e8791c EM	235	<name>is_test</name>
	236	<title>Test</title>
	237	<uniqueName>activity_is_test</uniqueName>
	238	<type>boolean</type>
	239	<default>0</default>
	240	<import>true</import>
	241	<headerPattern>/(is.)?test(.activity)?/i</headerPattern>
	242	<add>2.0</add>
	243	<html>
3542118f	244	<type>CheckBox</type>
29e8791c EM	245	</html>
	246	</field>
	247	<field>
	248	<name>medium_id</name>
	249	<uniqueName>activity_medium_id</uniqueName>
	250	<title>Activity Medium</title>
	251	<type>int unsigned</type>
	252	<default>NULL</default>
	253	<comment>Activity Medium, Implicit FK to civicrm_option_value where option_group = encounter_medium.</comment>
	254	<pseudoconstant>
	255	<optionGroupName>encounter_medium</optionGroupName>
	256	</pseudoconstant>
	257	<html>
	258	<type>Select</type>
	259	</html>
	260	<add>2.2</add>
6a488035 TO	261	</field>
6a488035 TO	262	<index>
29e8791c EM	263	<name>index_medium_id</name>
	264	<fieldName>medium_id</fieldName>
	265	<add>2.2</add>
9bfe43ee	266	<drop>5.28</drop>
6a488035 TO	267	</index>
6a488035 TO	268	<field>
29e8791c EM	269	<name>is_auto</name>
	270	<title>Auto</title>
	271	<type>boolean</type>
	272	<default>0</default>
	273	<add>2.2</add>
3f3a3ba0 CW	274	</field>
3f3a3ba0 CW	275	<field>
29e8791c	276	<name>relationship_id</name>
57e94608	277	<title>Relationship ID</title>
29e8791c EM	278	<type>int unsigned</type>
	279	<default>NULL</default>
	280	<comment>FK to Relationship ID</comment>
57e94608 A	281	<html>
	282	<label>Relationship</label>
	283	</html>
29e8791c	284	<add>2.2</add>
6a488035	285	</field>
3f3a3ba0	286	<foreignKey>
29e8791c EM	287	<name>relationship_id</name>
	288	<table>civicrm_relationship</table>
	289	<key>id</key>
	290	<onDelete>SET NULL</onDelete>
3f3a3ba0	291	</foreignKey>
6a488035	292	<field>
29e8791c EM	293	<name>is_current_revision</name>
	294	<title>Is this activity a current revision in versioning chain?</title>
	295	<type>boolean</type>
	296	<default>1</default>
	297	<import>true</import>
	298	<headerPattern>/(is.)?(current.)?(revision\|version(ing)?)/i</headerPattern>
	299	<add>2.2</add>
6a488035 TO	300	</field>
6a488035 TO	301	<index>
29e8791c EM	302	<name>index_is_current_revision</name>
	303	<fieldName>is_current_revision</fieldName>
	304	<add>2.2</add>
3f3a3ba0	305	</index>
6a488035	306	<field>
29e8791c EM	307	<name>original_id</name>
29e8791c EM	308	<type>int unsigned</type>
57e94608	309	<title>Original Activity ID</title>
29e8791c	310	<comment>Activity ID of the first activity record in versioning chain.</comment>
58b0bf5a	311	<readonly>true</readonly>
57e94608 A	312	<html>
	313	<label>Original Activity</label>
	314	</html>
29e8791c	315	<add>2.2</add>
6a488035 TO	316	</field>
6a488035 TO	317	<foreignKey>
29e8791c EM	318	<name>original_id</name>
	319	<table>civicrm_activity</table>
	320	<key>id</key>
	321	<add>2.2</add>
	322	<onDelete>CASCADE</onDelete>
6a488035	323	</foreignKey>
6a488035	324	<field>
29e8791c EM	325	<name>result</name>
	326	<uniqueName>activity_result</uniqueName>
	327	<type>varchar</type>
	328	<title>Result</title>
	329	<length>255</length>
	330	<comment>Currently being used to store result id for survey activity, FK to option value.</comment>
29e8791c EM	331	<add>3.3</add>
	332	</field>
	333	<field>
	334	<name>is_deleted</name>
	335	<uniqueName>activity_is_deleted</uniqueName>
	336	<title>Activity is in the Trash</title>
	337	<type>boolean</type>
	338	<default>0</default>
	339	<import>true</import>
	340	<headerPattern>/(activity.)?(trash\|deleted)/i</headerPattern>
	341	<add>2.2</add>
	342	<html>
3542118f	343	<type>CheckBox</type>
29e8791c	344	</html>
6a488035 TO	345	</field>
6a488035 TO	346	<index>
29e8791c EM	347	<name>index_is_deleted</name>
	348	<fieldName>is_deleted</fieldName>
	349	<add>2.2</add>
6a488035	350	</index>
3f3a3ba0	351	<field>
29e8791c	352	<name>campaign_id</name>
88c31c05	353	<component>CiviCampaign</component>
29e8791c EM	354	<uniqueName>activity_campaign_id</uniqueName>
29e8791c EM	355	<type>int unsigned</type>
57e94608	356	<title>Campaign ID</title>
29e8791c EM	357	<import>true</import>
29e8791c EM	358	<comment>The campaign for which this activity has been triggered.</comment>
29e8791c EM	359	<add>3.4</add>
29e8791c EM	360	<html>
8813f972	361	<type>EntityRef</type>
57e94608	362	<label>Campaign</label>
29e8791c	363	</html>
25ad69f2 CW	364	<pseudoconstant>
	365	<table>civicrm_campaign</table>
	366	<keyColumn>id</keyColumn>
	367	<labelColumn>title</labelColumn>
	368	<prefetch>FALSE</prefetch>
	369	</pseudoconstant>
6a488035	370	</field>
3f3a3ba0	371	<foreignKey>
29e8791c EM	372	<name>campaign_id</name>
	373	<table>civicrm_campaign</table>
	374	<key>id</key>
	375	<onDelete>SET NULL</onDelete>
6a488035	376	</foreignKey>
3f3a3ba0	377	<field>
29e8791c EM	378	<name>engagement_level</name>
	379	<uniqueName>activity_engagement_level</uniqueName>
	380	<type>int unsigned</type>
	381	<title>Engagement Index</title>
	382	<import>true</import>
	383	<comment>Assign a specific level of engagement to this activity. Used for tracking constituents in ladder of engagement.</comment>
	384	<pseudoconstant>
	385	<optionGroupName>engagement_index</optionGroupName>
	386	</pseudoconstant>
	387	<html>
	388	<type>Select</type>
	389	</html>
	390	<add>3.4</add>
	391	</field>
	392	<field>
	393	<name>weight</name>
7ecddde4	394	<title>Order</title>
29e8791c EM	395	<type>int</type>
29e8791c EM	396	<add>4.1</add>
6a488035	397	</field>
cd063b10 CW	398	<field>
	399	<name>is_star</name>
	400	<title>Is Starred</title>
	401	<type>boolean</type>
	402	<default>0</default>
	403	<import>true</import>
	404	<comment>Activity marked as favorite.</comment>
	405	<headerPattern>/(activity.)?(star\|favorite)/i</headerPattern>
	406	<add>4.7</add>
3542118f CW	407	<html>
	408	<type>Checkbox</type>
	409	</html>
cd063b10	410	</field>
3ed77291 TO	411	<field>
	412	<name>created_date</name>
	413	<uniqueName>activity_created_date</uniqueName>
	414	<type>timestamp</type>
	415	<comment>When was the activity was created.</comment>
	416	<required>false</required>
	417	<export>true</export>
487813ab	418	<default>CURRENT_TIMESTAMP</default>
1662d426 A	419	<html>
	420	<label>Created Date</label>
	421	</html>
3ed77291 TO	422	<add>4.7</add>
	423	</field>
	424	<field>
	425	<name>modified_date</name>
	426	<uniqueName>activity_modified_date</uniqueName>
	427	<type>timestamp</type>
	428	<comment>When was the activity (or closely related entity) was created or modified or deleted.</comment>
	429	<required>false</required>
	430	<export>true</export>
	431	<default>CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP</default>
1662d426 A	432	<html>
	433	<label>Modified Date</label>
	434	</html>
a0e733f3	435	<readonly>true</readonly>
3ed77291 TO	436	<add>4.7</add>
3ed77291 TO	437	</field>
6a488035	438	</table>