1 <?xml version=
"1.0" encoding=
"iso-8859-1" ?>
4 <base>CRM/Contact
</base>
5 <class>Organization
</class>
6 <name>civicrm_organization
</name>
7 <comment>Define organization specific properties
</comment>
12 <type>int unsigned
</type>
13 <required>true
</required>
14 <comment>Unique Organization 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>organization_name
</name>
39 <headerPattern>/^organization|(o(rganization\s)?name)$/i
</headerPattern>
40 <dataPattern>/^\w+$/
</dataPattern>
41 <comment>Organization Name.
</comment>
46 <name>index_organization_name
</name>
47 <fieldName>organization_name
</fieldName>
51 <name>legal_name
</name>
55 <headerPattern>/^legal|(l(egal\s)?name)$/i
</headerPattern>
56 <comment>Legal Name.
</comment>
65 <headerPattern>/^sic|(s(ic\s)?code)$/i
</headerPattern>
66 <comment>Standard Industry Classification Code.
</comment>
70 <name>primary_contact_id
</name>
71 <type>int unsigned
</type>
72 <comment>Optional FK to Primary Contact for this organization.
</comment>
76 <name>primary_contact_id
</name>
77 <table>civicrm_contact
</table>
82 <name>UI_contact
</name>
83 <fieldName>contact_id
</fieldName>