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>
78 <name>prefix_id
</name>
79 <type>int unsigned
</type>
80 <comment>Prefix or Title for name (Ms, Mr...). FK to prefix ID
</comment>
81 <headerPattern>/^(prefix|title)/i
</headerPattern>
82 <dataPattern>/^(mr|ms|mrs|sir|dr)\.?$/i
</dataPattern>
86 <name>UI_prefix
</name>
87 <fieldName>prefix_id
</fieldName>
91 <name>suffix_id
</name>
92 <type>int unsigned
</type>
93 <comment>Suffix for name (Jr, Sr...). FK to suffix ID
</comment>
94 <headerPattern>/^suffix$/i
</headerPattern>
95 <dataPattern>/^(sr|jr)\.?|i{
2,}$/
</dataPattern>
99 <name>UI_suffix
</name>
100 <fieldName>suffix_id
</fieldName>
104 <name>greeting_type_id
</name>
105 <title>Greeting Type
</title>
106 <type>int unsigned
</type>
107 <comment>FK to civicrm_option_value.id, that has to be valid, registered Greeting type.
</comment>
111 <name>custom_greeting
</name>
114 <comment>Custom greeting message.
</comment>
118 <name>job_title
</name>
121 <import>true
</import>
122 <headerPattern>/^job|(j(ob\s)?title)$/i
</headerPattern>
123 <dataPattern>//
</dataPattern>
124 <comment>Job Title
</comment>
128 <name>gender_id
</name>
129 <type>int unsigned
</type>
130 <headerPattern>/^gender$/i
</headerPattern>
131 <comment>FK to gender ID
</comment>
135 <name>UI_gender
</name>
136 <fieldName>gender_id
</fieldName>
140 <name>birth_date
</name>
142 <import>true
</import>
143 <headerPattern>/^birth|(b(irth\s)?date)|D(\W*)O(\W*)B(\W*)$/i
</headerPattern>
144 <dataPattern>/\d{
4}-?\d{
2}-?\d{
2}/
</dataPattern>
145 <comment>Date of birth
</comment>
149 <name>is_deceased
</name>
150 <title>Deceased
</title>
151 <import>true
</import>
152 <export>true
</export>
153 <headerPattern>/i(s\s)?d(eceased)$/i
</headerPattern>
159 <name>deceased_date
</name>
161 <import>true
</import>
162 <export>true
</export>
163 <headerPattern>/^deceased|(d(eceased\s)?date)$/i
</headerPattern>
164 <comment>Date of deceased
</comment>
168 <name>phone_to_household_id
</name>
169 <type>int unsigned
</type>
170 <comment>OPTIONAL FK to civicrm_contact_household record. If NOT NULL, direct phone communications to household
171 rather than individual location.
176 <name>email_to_household_id
</name>
177 <type>int unsigned
</type>
178 <comment>OPTIONAL FK to civicrm_contact_household record. If NOT NULL, direct phone communications to household
179 rather than individual location.
184 <name>mail_to_household_id
</name>
185 <type>int unsigned
</type>
186 <comment>OPTIONAL FK to civicrm_contact_household record. If NOT NULL, direct mail communications to household
187 rather than individual location.
192 <name>UI_contact
</name>
193 <fieldName>contact_id
</fieldName>
194 <unique>true
</unique>