X-Git-Url: https://vcs.fsf.org/?a=blobdiff_plain;f=xml%2Fschema%2FContact%2FIndividual.xml;h=007d5b52754b05e84bea4620a1ab31a02dec4d0d;hb=4240e48aca79411fbc1eb544b6530a507ad4ef30;hp=c361dc46ced3d620be738e4f2523383bce790cfb;hpb=adc13f865ee7ced5d485e801528f2481fb6da0b0;p=civicrm-core.git
diff --git a/xml/schema/Contact/Individual.xml b/xml/schema/Contact/Individual.xml
index c361dc46ce..007d5b5275 100644
--- a/xml/schema/Contact/Individual.xml
+++ b/xml/schema/Contact/Individual.xml
@@ -8,213 +8,219 @@
true
1.1
- id
- int unsigned
- true
- Unique Individual ID
- 1.1
+ id
+ int unsigned
+ true
+ Unique Individual ID
+ 1.1
- id
- true
+ id
+ true
- contact_id
- int unsigned
- true
- FK to Contact ID
- 1.1
+ contact_id
+ int unsigned
+ true
+ FK to Contact ID
+ 1.1
- contact_id
-
- id
- 1.1
+ contact_id
+
+ id
+ 1.1
- first_name
- varchar
- 64
- true
- /^first|(f(irst\s)?name)$/i
- /^\w+$/
-
- First Name.
- 1.1
+ first_name
+ varchar
+ 64
+ true
+ /^first|(f(irst\s)?name)$/i
+ /^\w+$/
+
+ First Name.
+ 1.1
- index_first_name
- first_name
- 1.8
+ index_first_name
+ first_name
+ 1.8
- middle_name
- varchar
- 64
- true
- /^middle|(m(iddle\s)?name)$/i
- /^\w+$/
-
- Middle Name.
- 1.1
-
-
- last_name
- varchar
- 64
- true
- /^(l(ast\s)?name)$/i
- /^\w+(\s\w+)?+$/
- Last Name.
-
- 1.1
+ middle_name
+ varchar
+ 64
+ true
+ /^middle|(m(iddle\s)?name)$/i
+ /^\w+$/
+
+ Middle Name.
+ 1.1
+
+
+ last_name
+ varchar
+ 64
+ true
+ /^(l(ast\s)?name)$/i
+ /^\w+(\s\w+)?+$/
+ Last Name.
+
+ 1.1
- index_last_name
- last_name
- 1.8
+ index_last_name
+ last_name
+ 1.8
- gender
- enum
- true
- Female, Male, Transgender
- 1.1
- 1.2
+ gender
+ enum
+ true
+ Female, Male, Transgender
+ 1.1
+ 1.2
- prefix_id
- int unsigned
- Prefix or Title for name (Ms, Mr...). FK to prefix ID
- /^(prefix|title)/i
- /^(mr|ms|mrs|sir|dr)\.?$/i
- 1.2
+ prefix_id
+ int unsigned
+ Prefix or Title for name (Ms, Mr...). FK to prefix ID
+ /^(prefix|title)/i
+ /^(mr|ms|mrs|sir|dr)\.?$/i
+ 1.2
- UI_prefix
- prefix_id
- 1.6
+ UI_prefix
+ prefix_id
+ 1.6
- suffix_id
- int unsigned
- Suffix for name (Jr, Sr...). FK to suffix ID
- /^suffix$/i
- /^(sr|jr)\.?|i{2,}$/
- 1.2
+ suffix_id
+ int unsigned
+ Suffix for name (Jr, Sr...). FK to suffix ID
+ /^suffix$/i
+ /^(sr|jr)\.?|i{2,}$/
+ 1.2
- UI_suffix
- suffix_id
- 1.6
+ UI_suffix
+ suffix_id
+ 1.6
- prefix
- varchar
- 64
- true
- Prefix to Name.
- 1.1
- 1.2
+ prefix
+ varchar
+ 64
+ true
+ Prefix to Name.
+ 1.1
+ 1.2
- suffix
- varchar
- 64
- true
- Suffix to Name.
- 1.1
- 1.2
+ suffix
+ varchar
+ 64
+ true
+ Suffix to Name.
+ 1.1
+ 1.2
- greeting_type
- varchar
- 128
- Preferred greeting format.
- 1.1
- 2.2
+ greeting_type
+ varchar
+ 128
+ Preferred greeting format.
+ 1.1
+ 2.2
- greeting_type_id
- Greeting Type
- int unsigned
- FK to civicrm_option_value.id, that has to be valid, registered Greeting type.
- 2.2
+ greeting_type_id
+ Greeting Type
+ int unsigned
+ FK to civicrm_option_value.id, that has to be valid, registered Greeting type.
+ 2.2
- custom_greeting
- varchar
- 128
- Custom greeting message.
- 1.1
+ custom_greeting
+ varchar
+ 128
+ Custom greeting message.
+ 1.1
- job_title
- varchar
- 64
- true
- /^job|(j(ob\s)?title)$/i
- //
- Job Title
- 1.1
+ job_title
+ varchar
+ 64
+ true
+ /^job|(j(ob\s)?title)$/i
+ //
+ Job Title
+ 1.1
- gender_id
- int unsigned
- /^gender$/i
- FK to gender ID
- 1.2
+ gender_id
+ int unsigned
+ /^gender$/i
+ FK to gender ID
+ 1.2
- UI_gender
- gender_id
- 1.6
+ UI_gender
+ gender_id
+ 1.6
- birth_date
- date
- true
- /^birth|(b(irth\s)?date)|D(\W*)O(\W*)B(\W*)$/i
- /\d{4}-?\d{2}-?\d{2}/
- Date of birth
- 1.1
-
-
- is_deceased
- Is Deceased
- true
- true
- /i(s\s)?d(eceased)$/i
- boolean
- 0
- 1.1
-
-
- deceased_date
- date
- true
- true
- /^deceased|(d(eceased\s)?date)$/i
- Date of deceased
- 1.5
-
-
- phone_to_household_id
- int unsigned
- OPTIONAL FK to civicrm_contact_household record. If NOT NULL, direct phone communications to household rather than individual location.
- 1.1
-
-
- email_to_household_id
- int unsigned
- OPTIONAL FK to civicrm_contact_household record. If NOT NULL, direct phone communications to household rather than individual location.
- 1.1
-
-
- mail_to_household_id
- int unsigned
- OPTIONAL FK to civicrm_contact_household record. If NOT NULL, direct mail communications to household rather than individual location.
- 1.1
+ birth_date
+ date
+ true
+ /^birth|(b(irth\s)?date)|D(\W*)O(\W*)B(\W*)$/i
+ /\d{4}-?\d{2}-?\d{2}/
+ Date of birth
+ 1.1
+
+
+ is_deceased
+ Deceased
+ true
+ true
+ /i(s\s)?d(eceased)$/i
+ boolean
+ 0
+ 1.1
+
+
+ deceased_date
+ date
+ true
+ true
+ /^deceased|(d(eceased\s)?date)$/i
+ Date of deceased
+ 1.5
+
+
+ phone_to_household_id
+ int unsigned
+ OPTIONAL FK to civicrm_contact_household record. If NOT NULL, direct phone communications to household
+ rather than individual location.
+
+ 1.1
+
+
+ email_to_household_id
+ int unsigned
+ OPTIONAL FK to civicrm_contact_household record. If NOT NULL, direct phone communications to household
+ rather than individual location.
+
+ 1.1
+
+
+ mail_to_household_id
+ int unsigned
+ OPTIONAL FK to civicrm_contact_household record. If NOT NULL, direct mail communications to household
+ rather than individual location.
+
+ 1.1
UI_contact