1 <?xml version=
"1.0" encoding=
"iso-8859-1" ?>
4 <base>CRM/Contact
</base>
5 <class>Individual
</class>
6 <name>civicrm_individual
</name>
7 <comment>Define contact-individual specific properties. Extends civicrm_contact.
</comment>
12 <type>int unsigned
</type>
13 <required>true
</required>
14 <comment>Unique Individual ID
</comment>
19 <autoincrement>true
</autoincrement>
22 <name>contact_id
</name>
23 <type>int unsigned
</type>
24 <required>true
</required>
25 <comment>FK to Contact ID
</comment>
29 <name>contact_id
</name>
30 <table>civicrm_contact
</table>
35 <name>first_name
</name>
39 <headerPattern>/^first|(f(irst\s)?name)$/i
</headerPattern>
40 <dataPattern>/^\w+$/
</dataPattern>
42 <comment>First Name.
</comment>
46 <name>index_first_name
</name>
47 <fieldName>first_name
</fieldName>
51 <name>middle_name
</name>
55 <headerPattern>/^middle|(m(iddle\s)?name)$/i
</headerPattern>
56 <dataPattern>/^\w+$/
</dataPattern>
58 <comment>Middle Name.
</comment>
62 <name>last_name
</name>
66 <headerPattern>/^(l(ast\s)?name)$/i
</headerPattern>
67 <dataPattern>/^\w+(\s\w+)?+$/
</dataPattern>
68 <comment>Last Name.
</comment>
73 <name>index_last_name
</name>
74 <fieldName>last_name
</fieldName>
81 <values>Female, Male, Other
</values>
86 <name>prefix_id
</name>
87 <type>int unsigned
</type>
88 <comment>Prefix or Title for name (Ms, Mr...). FK to prefix ID
</comment>
89 <headerPattern>/^(prefix|title)/i
</headerPattern>
90 <dataPattern>/^(mr|ms|mrs|sir|dr)\.?$/i
</dataPattern>
94 <name>UI_prefix
</name>
95 <fieldName>prefix_id
</fieldName>
99 <name>suffix_id
</name>
100 <type>int unsigned
</type>
101 <comment>Suffix for name (Jr, Sr...). FK to suffix ID
</comment>
102 <headerPattern>/^suffix$/i
</headerPattern>
103 <dataPattern>/^(sr|jr)\.?|i{
2,}$/
</dataPattern>
107 <name>UI_suffix
</name>
108 <fieldName>suffix_id
</fieldName>
115 <import>true
</import>
116 <comment>Prefix to Name.
</comment>
124 <import>true
</import>
125 <comment>Suffix to Name.
</comment>
130 <name>greeting_type
</name>
133 <comment>Preferred greeting format.
</comment>
138 <name>greeting_type_id
</name>
139 <title>Greeting Type
</title>
140 <type>int unsigned
</type>
141 <comment>FK to civicrm_option_value.id, that has to be valid, registered Greeting type.
</comment>
145 <name>custom_greeting
</name>
148 <comment>Custom greeting message.
</comment>
152 <name>job_title
</name>
155 <import>true
</import>
156 <headerPattern>/^job|(j(ob\s)?title)$/i
</headerPattern>
157 <dataPattern>//
</dataPattern>
158 <comment>Job Title
</comment>
162 <name>gender_id
</name>
163 <type>int unsigned
</type>
164 <headerPattern>/^gender$/i
</headerPattern>
165 <comment>FK to gender ID
</comment>
169 <name>UI_gender
</name>
170 <fieldName>gender_id
</fieldName>
174 <name>birth_date
</name>
176 <import>true
</import>
177 <headerPattern>/^birth|(b(irth\s)?date)|D(\W*)O(\W*)B(\W*)$/i
</headerPattern>
178 <dataPattern>/\d{
4}-?\d{
2}-?\d{
2}/
</dataPattern>
179 <comment>Date of birth
</comment>
183 <name>is_deceased
</name>
184 <title>Deceased
</title>
185 <import>true
</import>
186 <export>true
</export>
187 <headerPattern>/i(s\s)?d(eceased)$/i
</headerPattern>
193 <name>deceased_date
</name>
195 <import>true
</import>
196 <export>true
</export>
197 <headerPattern>/^deceased|(d(eceased\s)?date)$/i
</headerPattern>
198 <comment>Date of deceased
</comment>
202 <name>phone_to_household_id
</name>
203 <type>int unsigned
</type>
204 <comment>OPTIONAL FK to civicrm_contact_household record. If NOT NULL, direct phone communications to household
205 rather than individual location.
210 <name>email_to_household_id
</name>
211 <type>int unsigned
</type>
212 <comment>OPTIONAL FK to civicrm_contact_household record. If NOT NULL, direct phone communications to household
213 rather than individual location.
218 <name>mail_to_household_id
</name>
219 <type>int unsigned
</type>
220 <comment>OPTIONAL FK to civicrm_contact_household record. If NOT NULL, direct mail communications to household
221 rather than individual location.
226 <name>UI_contact
</name>
227 <fieldName>contact_id
</fieldName>
228 <unique>true
</unique>