From bf76be712dc21642b7fb9ea28687bbd66bbb3b47 Mon Sep 17 00:00:00 2001 From: Eileen McNaughton Date: Fri, 22 Aug 2014 21:12:53 +1200 Subject: [PATCH] CRM-15168 add titles to more enities --- xml/schema/Campaign/Survey.xml | 22 ++++-- xml/schema/Core/Note.xml | 128 +++++++++++++++++---------------- xml/schema/Core/Tag.xml | 31 ++++---- xml/schema/Core/UFGroup.xml | 9 +++ 4 files changed, 111 insertions(+), 79 deletions(-) diff --git a/xml/schema/Campaign/Survey.xml b/xml/schema/Campaign/Survey.xml index e85b1eeb13..4e810ccb85 100644 --- a/xml/schema/Campaign/Survey.xml +++ b/xml/schema/Campaign/Survey.xml @@ -8,6 +8,7 @@ id + Survey ID int unsigned true Survey id. @@ -32,6 +33,7 @@ campaign_id + Survey Campaign ID int unsigned NULL Foreign key to the Campaign. @@ -73,6 +75,7 @@ recontact_interval + Follow up Interval text Recontact intervals for each status. @@ -85,6 +88,7 @@ instructions + Instructions text true Script instructions for volunteers to use for the survey. @@ -98,6 +102,7 @@ release_frequency + Survey Hold Duration int unsigned NULL Number of days for recurrence of release. @@ -124,6 +129,7 @@ is_active + Survey Is Active boolean 1 Is this survey enabled or disabled/cancelled? @@ -132,6 +138,7 @@ is_default + Is Default Survey boolean 0 Is this default survey? @@ -140,16 +147,17 @@ created_id + Survey Created By int unsigned FK to civicrm_contact, who created this Survey. 3.3 - created_id - civicrm_contact
- id - 3.3 - SET NULL + created_id + civicrm_contact
+ id + 3.3 + SET NULL @@ -162,6 +170,7 @@ last_modified_id + Survey Modified int unsigned FK to civicrm_contact, who recently edited this Survey. 3.3 @@ -176,6 +185,7 @@ last_modified_date + Survey Modified On datetime Date and time that Survey was edited last time. 3.3 @@ -183,6 +193,7 @@ result_id + Survey Result int unsigned NULL Used to store option group id. @@ -190,6 +201,7 @@ bypass_confirm + No Email Verification boolean 0 Bypass the email verification. diff --git a/xml/schema/Core/Note.xml b/xml/schema/Core/Note.xml index 9b6e0dba35..cb3740e01c 100644 --- a/xml/schema/Core/Note.xml +++ b/xml/schema/Core/Note.xml @@ -8,87 +8,95 @@ 1.1 true - id - int unsigned - true - Note ID - 1.1 + id + Note ID + int unsigned + true + Note ID + 1.1 - id - true + id + true - entity_table - varchar - 64 - true - Name of table where item being referenced is stored. - 1.1 + entity_table + Note Entity + varchar + 64 + true + Name of table where item being referenced is stored. + 1.1 - entity_id - int unsigned - true - Foreign key to the referenced item. - 1.1 + entity_id + Note Entity ID + int unsigned + true + Foreign key to the referenced item. + 1.1 - entity_id - entity_table - 1.1 + entity_id + entity_table + 1.1 - index_entity - entity_table - entity_id - 1.1 + index_entity + entity_table + entity_id + 1.1 - note - text - Note and/or Comment. - - TextArea - 4 - 60 - - true - /Note|Comment/i - // - 1.1 + note + Note + text + Note and/or Comment. + + TextArea + 4 + 60 + + true + /Note|Comment/i + // + 1.1 - contact_id - int unsigned - FK to Contact ID creator - 1.1 + contact_id + Note Created By + int unsigned + FK to Contact ID creator + 1.1 - contact_id - civicrm_contact
- id - 1.1 - SET NULL + contact_id + civicrm_contact
+ id + 1.1 + SET NULL - modified_date - date - When was this note last modified/edited - 1.1 + modified_date + Note Modified By + date + When was this note last modified/edited + 1.1 - subject - varchar - 255 - subject of note description - 1.5 + subject + Subject + varchar + 255 + subject of note description + 1.5 - privacy - varchar - 255 - Foreign Key to Note Privacy Level (which is an option value pair and hence an implicit FK) - 3.3 + privacy + Privacy + varchar + 255 + Foreign Key to Note Privacy Level (which is an option value pair and hence an implicit FK) + 3.3 diff --git a/xml/schema/Core/Tag.xml b/xml/schema/Core/Tag.xml index 7ca3b058d8..000b058046 100644 --- a/xml/schema/Core/Tag.xml +++ b/xml/schema/Core/Tag.xml @@ -9,6 +9,7 @@ true id + Tag ID int unsigned true Tag ID @@ -45,6 +46,7 @@ is_selectable + Display Tag? boolean 1 Is this tag selectable / displayed @@ -91,23 +93,24 @@ 3.2 - created_id - int unsigned - FK to civicrm_contact, who created this tag - 3.4 + created_id + Tag Created By + int unsigned + FK to civicrm_contact, who created this tag + 3.4 - created_id - civicrm_contact
- id - 3.4 - SET NULL + created_id + civicrm_contact
+ id + 3.4 + SET NULL - created_date - datetime - Tag Created Date - Date and time that tag was created. - 3.4 + created_date + datetime + Tag Created Date + Date and time that tag was created. + 3.4 diff --git a/xml/schema/Core/UFGroup.xml b/xml/schema/Core/UFGroup.xml index e9ae71bad8..40d2e21a96 100644 --- a/xml/schema/Core/UFGroup.xml +++ b/xml/schema/Core/UFGroup.xml @@ -130,6 +130,7 @@ add_to_group_id + Add Contact To Group int unsigned foreign key to civicrm_group_id @@ -141,6 +142,7 @@ add_captcha + Show Captcha On Profile boolean 0 Should a CAPTCHA widget be included this Profile form. @@ -148,6 +150,7 @@ is_map + Map Profile boolean 0 Do we want to map results from this profile. @@ -155,6 +158,7 @@ is_edit_link + Show Edit Link? boolean 0 Should edit link display in profile selector @@ -162,6 +166,7 @@ is_uf_link + Show Link to CMS User boolean 0 Should we display a link to the website profile in profile selector @@ -169,6 +174,7 @@ is_update_dupe + Update on Duplicate boolean 0 Should we update the contact record if we find a duplicate @@ -176,6 +182,7 @@ cancel_URL + Profile Cancel URL varchar 255 Redirect to URL when Cancle button clik . @@ -183,6 +190,7 @@ is_cms_user + Create CMS User? boolean 0 Should we create a cms user for this profile @@ -190,6 +198,7 @@ notify + Notify on Profile Submit text 1.8 -- 2.25.1