From 29e8791c0afef0d4af1d62ea2f507960eec2fb3d Mon Sep 17 00:00:00 2001 From: Eileen McNaughton Date: Fri, 22 Aug 2014 21:52:39 +1200 Subject: [PATCH] more whitespace --- xml/schema/Activity/Activity.xml | 708 ++++++++++----------- xml/schema/Activity/ActivityAssignment.xml | 34 +- xml/schema/Campaign/Campaign.xml | 370 +++++------ 3 files changed, 556 insertions(+), 556 deletions(-) diff --git a/xml/schema/Activity/Activity.xml b/xml/schema/Activity/Activity.xml index 063b36313a..73fce03f90 100644 --- a/xml/schema/Activity/Activity.xml +++ b/xml/schema/Activity/Activity.xml @@ -7,454 +7,454 @@ 1.1 true - id - activity_id - Activity ID - true - int unsigned - true - Unique Other Activity ID - 1.1 - + id + activity_id + Activity ID + true + int unsigned + true + Unique Other Activity ID + 1.1 + - id - true + id + true - source_contact_id - int unsigned - Source Contact - true - /(activity.)?source(.contact(.id)?)?/i - Contact ID of the person scheduling or logging this Activity. Usually the authenticated user. - 1.1 - 4.4 + source_contact_id + int unsigned + Source Contact + true + /(activity.)?source(.contact(.id)?)?/i + Contact ID of the person scheduling or logging this Activity. Usually the authenticated user. + 1.1 + 4.4 - source_contact_id - civicrm_contact
- id - 1.1 - 4.4 - SET NULL + source_contact_id + civicrm_contact
+ id + 1.1 + 4.4 + SET NULL - UI_source_contact_id - source_contact_id - 2.0 - 3.2 + UI_source_contact_id + source_contact_id + 2.0 + 3.2 - source_record_id - int unsigned - Source Record - 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. - 2.0 + source_record_id + int unsigned + Source Record + 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. + 2.0 - UI_source_record_id - source_record_id - 3.2 + UI_source_record_id + source_record_id + 3.2 - activity_type_id - Activity Type - true - int unsigned - true - false - 1 - /(activity.)?type(.id$)/i - FK to civicrm_option_value.id, that has to be valid, registered activity type. - 1.1 - - activity_type - - - Select - + activity_type_id + Activity Type + true + int unsigned + true + false + 1 + /(activity.)?type(.id$)/i + FK to civicrm_option_value.id, that has to be valid, registered activity type. + 1.1 + + activity_type + + + Select + - UI_activity_type_id - activity_type_id - 1.6 + UI_activity_type_id + activity_type_id + 1.6 - target_entity_table - varchar - 64 - true - Name of table where item being referenced is stored. - 1.1 - 2.0 + target_entity_table + varchar + 64 + true + Name of table where item being referenced is stored. + 1.1 + 2.0 - target_entity_id - int unsigned - true - Foreign key to the referenced item. - 1.1 - 2.0 + target_entity_id + int unsigned + true + Foreign key to the referenced item. + 1.1 + 2.0 - subject - activity_subject - varchar - Subject - 255 - The subject/purpose/short description of the activity. - true - /(activity.)?subject/i - - Text - - 1.1 - 2.0 + subject + activity_subject + varchar + Subject + 255 + The subject/purpose/short description of the activity. + true + /(activity.)?subject/i + + Text + + 1.1 + 2.0 - scheduled_date - datetime - Date and time meeting is scheduled to occur. - 1.1 - 2.0 + scheduled_date + datetime + Date and time meeting is scheduled to occur. + 1.1 + 2.0 - activity_date_time - true - Activity Date - datetime - /(activity.)?date(.time$)?/i - Date and time this activity is scheduled to occur. Formerly named scheduled_date_time. - - Select Date - - 2.0 + activity_date_time + true + Activity Date + datetime + /(activity.)?date(.time$)?/i + Date and time this activity is scheduled to occur. Formerly named scheduled_date_time. + + Select Date + + 2.0 - due_date_time - datetime - Date and time this activity is due. - 2.0 - 3.0 + due_date_time + datetime + Date and time this activity is due. + 2.0 + 3.0 - duration_hours - int unsigned - Planned or actual duration of meeting - hours. - 1.1 - 2.0 + duration_hours + int unsigned + Planned or actual duration of meeting - hours. + 1.1 + 2.0 - duration_minutes - int unsigned - Planned or actual duration of meeting - minutes. - 1.1 - 2.0 + duration_minutes + int unsigned + Planned or actual duration of meeting - minutes. + 1.1 + 2.0 - duration - activity_duration - Duration - true - int unsigned - /(activity.)?duration(s)?$/i - Planned or actual duration of activity expressed in minutes. Conglomerate of former duration_hours and duration_minutes. - 2.0 - - Text - + duration + activity_duration + Duration + true + int unsigned + /(activity.)?duration(s)?$/i + Planned or actual duration of activity expressed in minutes. Conglomerate of former duration_hours and duration_minutes. + 2.0 + + Text + - location - activity_location - Location - true - varchar - 255 - /(activity.)?location$/i - Location of the activity (optional, open text). - - Text - - 1.1 + location + activity_location + Location + true + varchar + 255 + /(activity.)?location$/i + Location of the activity (optional, open text). + + Text + + 1.1 - phone_id - int unsigned - Phone (called) ID - Phone ID of the number called (optional - used if an existing phone number is selected). - 2.0 - - Autocomplete-Select - + phone_id + int unsigned + Phone (called) ID + Phone ID of the number called (optional - used if an existing phone number is selected). + 2.0 + + Autocomplete-Select + - phone_id - civicrm_phone
- id - 2.0 - SET NULL + phone_id + civicrm_phone
+ id + 2.0 + SET NULL - phone_number - Phone (called) Number - varchar - 64 - Phone number in case the number does not exist in the civicrm_phone table. - - Text - - 2.0 + phone_number + Phone (called) Number + varchar + 64 + Phone number in case the number does not exist in the civicrm_phone table. + + Text + + 2.0 - details - activity_details - Details - true - text - /(activity.)?detail(s)?$/i - Details about the activity (agenda, notes, etc). - - RichTextEditor - 8 - 60 - - 1.1 + details + activity_details + Details + true + text + /(activity.)?detail(s)?$/i + Details about the activity (agenda, notes, etc). + + RichTextEditor + 8 + 60 + + 1.1 - status - enum - Status - Scheduled, Completed - What is the status of this meeting? Completed meeting status results in activity history entry. - 1.1 - 2.0 + status + enum + Status + Scheduled, Completed + What is the status of this meeting? Completed meeting status results in activity history entry. + 1.1 + 2.0 - status_id - activity_status_id - Activity Status - true - false - /(activity.)?status(.label$)?/i - int unsigned - ID of the status this activity is currently in. Foreign key to civicrm_option_value. - 2.0 - - activity_status - - - Select - - - - priority_id - int unsigned - Priority - ID of the priority given to this activity. Foreign key to civicrm_option_value. - 2.0 - - priority - - - Select - - - - parent_id - Parent Activity Id - int unsigned - Parent meeting ID (if this is a follow-up item). This is not currently implemented - 1.1 + status_id + activity_status_id + Activity Status + true + false + /(activity.)?status(.label$)?/i + int unsigned + ID of the status this activity is currently in. Foreign key to civicrm_option_value. + 2.0 + + activity_status + + + Select + + + + priority_id + int unsigned + Priority + ID of the priority given to this activity. Foreign key to civicrm_option_value. + 2.0 + + priority + + + Select + + + + parent_id + Parent Activity Id + int unsigned + Parent meeting ID (if this is a follow-up item). This is not currently implemented + 1.1 - parent_id - civicrm_activity
- id - 1.1 - CASCADE + parent_id + civicrm_activity
+ id + 1.1 + CASCADE - is_test - Test - activity_is_test - boolean - 0 - true - /(is.)?test(.activity)?/i - 2.0 - - Select - - - - medium_id - activity_medium_id - Activity Medium - int unsigned - NULL - Activity Medium, Implicit FK to civicrm_option_value where option_group = encounter_medium. - - encounter_medium - - - Select - - 2.2 + is_test + Test + activity_is_test + boolean + 0 + true + /(is.)?test(.activity)?/i + 2.0 + + Select + + + + medium_id + activity_medium_id + Activity Medium + int unsigned + NULL + Activity Medium, Implicit FK to civicrm_option_value where option_group = encounter_medium. + + encounter_medium + + + Select + + 2.2 - index_medium_id - medium_id - 2.2 + index_medium_id + medium_id + 2.2 - is_auto - Auto - boolean - 0 - 2.2 + is_auto + Auto + boolean + 0 + 2.2 - relationship_id - Relationship Id - int unsigned - NULL - FK to Relationship ID - 2.2 + relationship_id + Relationship Id + int unsigned + NULL + FK to Relationship ID + 2.2 - relationship_id - civicrm_relationship
- id - SET NULL + relationship_id + civicrm_relationship
+ id + SET NULL - is_current_revision - Is this activity a current revision in versioning chain? - boolean - 1 - true - /(is.)?(current.)?(revision|version(ing)?)/i - 2.2 - - CheckBox - + is_current_revision + Is this activity a current revision in versioning chain? + boolean + 1 + true + /(is.)?(current.)?(revision|version(ing)?)/i + 2.2 + + CheckBox + - index_is_current_revision - is_current_revision - 2.2 + index_is_current_revision + is_current_revision + 2.2 - original_id - int unsigned - Original Activity ID - Activity ID of the first activity record in versioning chain. - 2.2 + original_id + int unsigned + Original Activity ID + Activity ID of the first activity record in versioning chain. + 2.2 - original_id - civicrm_activity
- id - 2.2 - CASCADE + original_id + civicrm_activity
+ id + 2.2 + CASCADE - UI_original_id - original_id - 2.2 - 3.2 + UI_original_id + original_id + 2.2 + 3.2 - result - activity_result - varchar - Result - 255 - Currently being used to store result id for survey activity, FK to option value. - - Text - - 3.3 - - - is_deleted - activity_is_deleted - Activity is in the Trash - boolean - 0 - true - /(activity.)?(trash|deleted)/i - 2.2 - - Text - + result + activity_result + varchar + Result + 255 + Currently being used to store result id for survey activity, FK to option value. + + Text + + 3.3 + + + is_deleted + activity_is_deleted + Activity is in the Trash + boolean + 0 + true + /(activity.)?(trash|deleted)/i + 2.2 + + Text + - index_is_deleted - is_deleted - 2.2 + index_is_deleted + is_deleted + 2.2 - campaign_id - activity_campaign_id - int unsigned - Campaign - true - The campaign for which this activity has been triggered. - - civicrm_campaign
- id - title - - 3.4 - - CheckBox - + campaign_id + activity_campaign_id + int unsigned + Campaign + true + The campaign for which this activity has been triggered. + + civicrm_campaign
+ id + title + + 3.4 + + CheckBox + - campaign_id - civicrm_campaign
- id - SET NULL + campaign_id + civicrm_campaign
+ id + SET NULL - engagement_level - activity_engagement_level - int unsigned - Engagement Index - true - Assign a specific level of engagement to this activity. Used for tracking constituents in ladder of engagement. - - engagement_index - - - Select - - 3.4 - - - weight - int - 4.1 - - Text - + engagement_level + activity_engagement_level + int unsigned + Engagement Index + true + Assign a specific level of engagement to this activity. Used for tracking constituents in ladder of engagement. + + engagement_index + + + Select + + 3.4 + + + weight + int + 4.1 + + Text + diff --git a/xml/schema/Activity/ActivityAssignment.xml b/xml/schema/Activity/ActivityAssignment.xml index a8f3a17a4b..f3df06bb54 100644 --- a/xml/schema/Activity/ActivityAssignment.xml +++ b/xml/schema/Activity/ActivityAssignment.xml @@ -27,7 +27,7 @@ Name of table where item being referenced is stored (activity, phonecall or meeting). 1.8 2.0 - + activity_entity_id @@ -53,33 +53,33 @@ Name of table where item being referenced is stored (contact assigned to given activity). 1.8 2.0 - + - + target_entity_id int unsigned true Foreign key to the referenced item. 1.1 2.0 - + - + target_entity_id target_entity_table 1.8 2.0 - + - + activity_id int unsigned Activity ID true Foreign key to the activity for this assignment. 2.0 - - + + activity_id civicrm_activity
id @@ -87,15 +87,15 @@ CASCADE - + assignee_contact_id int unsigned Assignee Contact ID true Foreign key to the contact for this assignment. 2.0 - - + + assignee_contact_id civicrm_contact
id @@ -104,11 +104,11 @@ - UI_activity_assignee_contact_id - assignee_contact_id - activity_id - true - 2.0 + UI_activity_assignee_contact_id + assignee_contact_id + activity_id + true + 2.0 diff --git a/xml/schema/Campaign/Campaign.xml b/xml/schema/Campaign/Campaign.xml index 72a627fdcb..01e6767061 100644 --- a/xml/schema/Campaign/Campaign.xml +++ b/xml/schema/Campaign/Campaign.xml @@ -7,245 +7,245 @@ 3.3 - id - Campaign ID - int unsigned - true - Unique Campaign ID. - true - 3.3 + id + Campaign ID + int unsigned + true + Unique Campaign ID. + true + 3.3 - id - true + id + true - name - Campaign Name - varchar - 255 - true - Name of the Campaign. - true - - Text - - 3.3 + name + Campaign Name + varchar + 255 + true + Name of the Campaign. + true + + Text + + 3.3 - title - Campaign Title - varchar - 255 - Title of the Campaign. - true - - Text - - 3.3 + title + Campaign Title + varchar + 255 + Title of the Campaign. + true + + Text + + 3.3 - description - Campaign Description - text - - TextArea - 8 - 60 - - Full description of Campaign. - 3.3 + description + Campaign Description + text + + TextArea + 8 + 60 + + Full description of Campaign. + 3.3 - start_date - Campaign Start Date - datetime - /^start|(s(tart\s)?date)$/i - Date and time that Campaign starts. - true - - Select Date - - 3.3 + start_date + Campaign Start Date + datetime + /^start|(s(tart\s)?date)$/i + Date and time that Campaign starts. + true + + Select Date + + 3.3 - end_date - Campaign End Date - datetime - /^end|(e(nd\s)?date)$/i - Date and time that Campaign ends. - true - - Select Date - - 3.3 + end_date + Campaign End Date + datetime + /^end|(e(nd\s)?date)$/i + Date and time that Campaign ends. + true + + Select Date + + 3.3 - campaign_type_id - Campaign Type - int unsigned - NULL - Campaign Type ID.Implicit FK to civicrm_option_value where option_group = campaign_type - true - - campaign_type - - - Select - - 3.3 + campaign_type_id + Campaign Type + int unsigned + NULL + Campaign Type ID.Implicit FK to civicrm_option_value where option_group = campaign_type + true + + campaign_type + + + Select + + 3.3 - UI_campaign_type_id - campaign_type_id - 3.3 + UI_campaign_type_id + campaign_type_id + 3.3 - - status_id - Campaign Status - int unsigned - NULL - Campaign status ID.Implicit FK to civicrm_option_value where option_group = campaign_status - true - - campaign_status - - - Select - - 3.3 + + status_id + Campaign Status + int unsigned + NULL + Campaign status ID.Implicit FK to civicrm_option_value where option_group = campaign_status + true + + campaign_status + + + Select + + 3.3 - UI_campaign_status_id - status_id - 3.3 + UI_campaign_status_id + status_id + 3.3 - external_identifier - varchar - Campaign External ID - 32 - /external\s?id/i - /^\d{11,}$/ - Unique trusted external ID (generally from a legacy app/datasource). Particularly useful for deduping operations. - true - 3.3 - - Text - + external_identifier + varchar + Campaign External ID + 32 + /external\s?id/i + /^\d{11,}$/ + Unique trusted external ID (generally from a legacy app/datasource). Particularly useful for deduping operations. + true + 3.3 + + Text + - UI_external_identifier - true - external_identifier - 3.3 + UI_external_identifier + true + external_identifier + 3.3 - parent_id - Parent Campaign - int unsigned - NULL - Optional parent id for this Campaign. - true - 3.3 - - Autocomplete-Select - + parent_id + Parent Campaign + int unsigned + NULL + Optional parent id for this Campaign. + true + 3.3 + + Autocomplete-Select + - parent_id - civicrm_campaign
- id - 3.3 - SET NULL + parent_id + civicrm_campaign
+ id + 3.3 + SET NULL - is_active - Is Campaign Active? - boolean - 1 - Is this Campaign enabled or disabled/cancelled? - 3.3 - - CheckBox - + is_active + Is Campaign Active? + boolean + 1 + Is this Campaign enabled or disabled/cancelled? + 3.3 + + CheckBox + - created_id - int unsigned - Campaign Created By - FK to civicrm_contact, who created this Campaign. - 3.3 + created_id + int unsigned + Campaign Created By + FK to civicrm_contact, who created this Campaign. + 3.3 - created_id - civicrm_contact
- id - 3.3 - SET NULL + created_id + civicrm_contact
+ id + 3.3 + SET NULL - created_date - datetime - Campaign Created Date - Date and time that Campaign was created. - 3.3 - - Select Date - + created_date + datetime + Campaign Created Date + Date and time that Campaign was created. + 3.3 + + Select Date + - last_modified_id - int unsigned - Campaign Modified By - FK to civicrm_contact, who recently edited this Campaign. - 3.3 + last_modified_id + int unsigned + Campaign Modified By + FK to civicrm_contact, who recently edited this Campaign. + 3.3 - last_modified_id - civicrm_contact
- id - 3.3 - SET NULL + last_modified_id + civicrm_contact
+ id + 3.3 + SET NULL - last_modified_date - datetime - Campaign Modified Date - Date and time that Campaign was edited last time. - 3.3 - - - goal_general - text - Campaign Goals - General goals for Campaign. - 3.4 - - RichTextEditor - - - - goal_revenue - decimal - The target revenue for this campaign. - 3.4 - - Text - + last_modified_date + datetime + Campaign Modified Date + Date and time that Campaign was edited last time. + 3.3 + + + goal_general + text + Campaign Goals + General goals for Campaign. + 3.4 + + RichTextEditor + + + + goal_revenue + decimal + The target revenue for this campaign. + 3.4 + + Text + -- 2.25.1