crm.fsf.org/20131203/files/sites/all/modules-new/civicrm/xml/schema/Contact/Contact.xml

   1 <?xml version="1.0" encoding="iso-8859-1" ?>
   2
   3 <table>
   4   <base>CRM/Contact</base>
   5   <class>Contact</class>
   6   <name>civicrm_contact</name>
   7   <comment>Contact objects are defined by a civicrm_contact record plus a related civicrm_contact_type record.</comment>
   8   <add>1.1</add>
   9   <log>true</log>
  10   <field>
  11     <name>id</name>
  12     <type>int unsigned</type>
  13     <title>Internal Contact ID</title>
  14     <import>true</import>
  15     <headerPattern>/internal|contact?|id$/i</headerPattern>
  16     <required>true</required>
  17     <comment>Unique Contact ID</comment>
  18     <add>1.1</add>
  19   </field>
  20   <primaryKey>
  21     <name>id</name>
  22     <autoincrement>true</autoincrement>
  23   </primaryKey>
  24   <field>
  25     <name>contact_type</name>
  26     <title>Contact Type</title>
  27     <type>varchar</type>
  28     <length>64</length>
  29     <comment>Type of Contact.</comment>
  30     <export>true</export>
  31     <pseudoconstant>
  32       <table>civicrm_contact_type</table>
  33       <keyColumn>name</keyColumn>
  34       <labelColumn>label</labelColumn>
  35       <condition>parent_id IS NULL</condition>
  36     </pseudoconstant>
  37     <html>
  38       <type>Select</type>
  39     </html>
  40     <add>1.1</add>
  41     <change>3.1</change>
  42   </field>
  43   <index>
  44     <name>index_contact_type</name>
  45     <fieldName>contact_type</fieldName>
  46     <add>2.1</add>
  47   </index>
  48   <field>
  49     <name>contact_sub_type</name>
  50     <title>Contact Subtype</title>
  51     <type>varchar</type>
  52     <length>255</length>
  53     <export>true</export>
  54     <import>true</import>
  55     <headerPattern>/C(ontact )?(subtype|sub-type|sub type)/i</headerPattern>
  56     <comment>May be used to over-ride contact view and edit templates.</comment>
  57     <pseudoconstant>
  58       <table>civicrm_contact_type</table>
  59       <keyColumn>name</keyColumn>
  60       <labelColumn>label</labelColumn>
  61       <condition>parent_id IS NOT NULL</condition>
  62     </pseudoconstant>
  63     <html>
  64       <type>Multi-Select</type>
  65     </html>
  66     <add>1.5</add>
  67   </field>
  68   <index>
  69     <name>index_contact_sub_type</name>
  70     <fieldName>contact_sub_type</fieldName>
  71     <html>
  72       <type>Multi-Select</type>
  73     </html>
  74     <add>2.1</add>
  75   </index>
  76   <field>
  77     <name>do_not_email</name>
  78     <type>boolean</type>
  79     <import>true</import>
  80     <headerPattern>/d(o )?(not )?(email)/i</headerPattern>
  81     <dataPattern>/^\d{1,}$/</dataPattern>
  82     <default>0</default>
  83     <html>
  84       <type>CheckBox</type>
  85     </html>
  86     <add>1.1</add>
  87   </field>
  88   <field>
  89     <name>do_not_phone</name>
  90     <type>boolean</type>
  91     <default>0</default>
  92     <import>true</import>
  93     <headerPattern>/d(o )?(not )?(call|phone)/i</headerPattern>
  94     <dataPattern>/^\d{1,}$/</dataPattern>
  95     <add>1.1</add>
  96     <html>
  97       <type>CheckBox</type>
  98     </html>
  99   </field>
 100   <field>
 101     <name>do_not_mail</name>
 102     <type>boolean</type>
 103     <import>true</import>
 104     <headerPattern>/^(d(o\s)?n(ot\s)?mail)|(\w*)?bulk\s?(\w*)$/i</headerPattern>
 105     <dataPattern>/^\d{1,}$/</dataPattern>
 106     <default>0</default>
 107     <add>1.1</add>
 108     <html>
 109       <type>CheckBox</type>
 110     </html>
 111   </field>
 112   <field>
 113     <name>do_not_sms</name>
 114     <type>boolean</type>
 115     <import>true</import>
 116     <headerPattern>/d(o )?(not )?(sms)/i</headerPattern>
 117     <dataPattern>/^\d{1,}$/</dataPattern>
 118     <default>0</default>
 119     <add>3.0</add>
 120     <html>
 121       <type>CheckBox</type>
 122     </html>
 123   </field>
 124   <field>
 125     <name>do_not_trade</name>
 126     <type>boolean</type>
 127     <import>true</import>
 128     <headerPattern>/d(o )?(not )?(trade)/i</headerPattern>
 129     <dataPattern>/^\d{1,}$/</dataPattern>
 130     <default>0</default>
 131     <add>1.1</add>
 132     <html>
 133       <type>CheckBox</type>
 134     </html>
 135   </field>
 136   <field>
 137     <name>is_opt_out</name>
 138     <type>boolean</type>
 139     <title>No Bulk Emails (User Opt Out)</title>
 140     <default>0</default>
 141     <import>true</import>
 142     <required>true</required>
 143     <comment>Has the contact opted out from receiving all bulk email from the organization or site domain?</comment>
 144     <add>1.1</add>
 145     <html>
 146       <type>CheckBox</type>
 147     </html>
 148   </field>
 149   <field>
 150     <name>legal_identifier</name>
 151     <type>varchar</type>
 152     <length>32</length>
 153     <import>true</import>
 154     <headerPattern>/legal\s?id/i</headerPattern>
 155     <dataPattern>/\w+?\d{5,}/</dataPattern>
 156     <comment>May be used for SSN, EIN/TIN, Household ID (census) or other applicable unique legal/government ID.
 157     </comment>
 158     <add>1.1</add>
 159     <html>
 160       <type>Text</type>
 161     </html>
 162   </field>
 163   <field>
 164     <name>external_identifier</name>
 165     <type>varchar</type>
 166     <length>64</length>
 167     <html>
 168       <type>Text</type>
 169       <size>EIGHT</size>
 170     </html>
 171
 172     <import>true</import>
 173     <headerPattern>/external\s?id/i</headerPattern>
 174     <dataPattern>/^\d{11,}$/</dataPattern>
 175     <comment>Unique trusted external ID (generally from a legacy app/datasource). Particularly useful for deduping operations.</comment>
 176     <add>1.1</add>
 177   </field>
 178   <index>
 179     <name>UI_external_identifier</name>
 180     <unique>true</unique>
 181     <fieldName>external_identifier</fieldName>
 182     <add>1.7</add>
 183   </index>
 184   <field>
 185     <name>sort_name</name>
 186     <title>Sort Name</title>
 187     <type>varchar</type>
 188     <length>128</length>
 189     <html>
 190       <type>Text</type>
 191       <size>BIG</size>
 192     </html>
 193
 194     <export>true</export>
 195     <comment>Name used for sorting different contact types</comment>
 196     <add>1.1</add>
 197   </field>
 198   <index>
 199     <name>index_sort_name</name>
 200     <fieldName>sort_name</fieldName>
 201     <add>2.1</add>
 202   </index>
 203   <field>
 204     <name>display_name</name>
 205     <title>Display Name</title>
 206     <type>varchar</type>
 207     <length>128</length>
 208     <html>
 209       <type>Text</type>
 210       <size>BIG</size>
 211     </html>
 212
 213     <export>true</export>
 214     <comment>Formatted name representing preferred format for display/print/other output.</comment>
 215     <add>1.1</add>
 216   </field>
 217   <field>
 218     <name>nick_name</name>
 219     <title>Nickname</title>
 220     <type>varchar</type>
 221     <length>128</length>
 222     <html>
 223       <type>Text</type>
 224       <size>BIG</size>
 225     </html>
 226
 227     <import>true</import>
 228     <headerPattern>/n(ick\s)name|nick$/i</headerPattern>
 229     <dataPattern>/^\w+$/</dataPattern>
 230     <comment>Nickname.</comment>
 231     <fulltext/>
 232     <add>1.1</add>
 233   </field>
 234   <field>
 235     <name>legal_name</name>
 236     <type>varchar</type>
 237     <length>128</length>
 238     <html>
 239       <type>Text</type>
 240       <size>BIG</size>
 241     </html>
 242
 243     <import>true</import>
 244     <headerPattern>/^legal|(l(egal\s)?name)$/i</headerPattern>
 245     <comment>Legal Name.</comment>
 246     <fulltext/>
 247     <add>1.1</add>
 248   </field>
 249   <field>
 250     <name>home_URL</name>
 251     <rule>url</rule>
 252     <title>Website</title>
 253     <type>varchar</type>
 254     <length>128</length>
 255     <html>
 256       <type>Text</type>
 257       <size>BIG</size>
 258     </html>
 259
 260     <import>true</import>
 261     <headerPattern>/^(home\sURL)|URL|web|site/i</headerPattern>
 262     <dataPattern>/^[\w\/\:\.]+$/</dataPattern>
 263     <comment>optional "home page" URL for this contact.</comment>
 264     <add>1.1</add>
 265     <drop>3.2</drop>
 266   </field>
 267   <field>
 268     <name>image_URL</name>
 269     <type>varchar</type>
 270     <length>255</length>
 271     <import>true</import>
 272     <comment>optional URL for preferred image (photo, logo, etc.) to display for this contact.</comment>
 273     <add>1.1</add>
 274     <html>
 275       <type>Text</type>
 276     </html>
 277   </field>
 278   <field>
 279     <name>preferred_communication_method</name>
 280     <title>Preferred Communication Method</title>
 281     <type>varchar</type>
 282     <length>255</length>
 283     <import>true</import>
 284     <headerPattern>/^p(ref\w*\s)?c(omm\w*)|( meth\w*)$/i</headerPattern>
 285     <dataPattern>/^\w+$/</dataPattern>
 286     <comment>What is the preferred mode of communication.</comment>
 287     <add>1.1</add>
 288     <pseudoconstant>
 289       <optionGroupName>preferred_communication_method</optionGroupName>
 290     </pseudoconstant>
 291     <html>
 292       <type>Select</type>
 293     </html>
 294   </field>
 295   <index>
 296     <name>index_preferred_communication_method</name>
 297     <fieldName>preferred_communication_method</fieldName>
 298     <add>1.6</add>
 299   </index>
 300   <field>
 301     <name>preferred_language</name>
 302     <title>Preferred Language</title>
 303     <type>varchar</type>
 304     <length>5</length>
 305     <comment>Which language is preferred for communication. FK to languages in civicrm_option_value.</comment>
 306     <headerPattern>/^lang/i</headerPattern>
 307     <import>true</import>
 308     <pseudoconstant>
 309       <optionGroupName>languages</optionGroupName>
 310       <keyColumn>name</keyColumn>
 311     </pseudoconstant>
 312     <html>
 313       <type>Select</type>
 314     </html>
 315     <add>3.2</add>
 316   </field>
 317   <field>
 318     <name>preferred_mail_format</name>
 319     <type>varchar</type>
 320     <length>8</length>
 321     <default>"Both"</default>
 322     <import>true</import>
 323     <headerPattern>/^p(ref\w*\s)?m(ail\s)?f(orm\w*)$/i</headerPattern>
 324     <comment>What is the preferred mode of sending an email.</comment>
 325     <add>1.1</add>
 326     <pseudoconstant>
 327       <callback>CRM_Core_SelectValues::pmf</callback>
 328     </pseudoconstant>
 329     <html>
 330       <type>Select</type>
 331     </html>
 332   </field>
 333   <field>
 334     <name>hash</name>
 335     <title>Contact Hash</title>
 336     <type>varchar</type>
 337     <length>32</length>
 338     <comment>Key for validating requests related to this contact.</comment>
 339     <add>1.1</add>
 340     <change>1.5</change>
 341     <export>true</export>
 342   </field>
 343   <index>
 344     <name>index_hash</name>
 345     <fieldName>hash</fieldName>
 346     <add>2.1</add>
 347   </index>
 348   <field>
 349     <name>api_key</name>
 350     <type>varchar</type>
 351     <length>32</length>
 352     <comment>API Key for validating requests related to this contact.</comment>
 353     <add>2.2</add>
 354   </field>
 355   <index>
 356     <name>index_api_key</name>
 357     <fieldName>api_key</fieldName>
 358     <add>2.1</add>
 359   </index>
 360   <field>
 361     <name>source</name>
 362     <title>Source of Contact Data</title>
 363     <uniqueName>contact_source</uniqueName>
 364     <type>varchar</type>
 365     <length>255</length>
 366     <html>
 367       <type>Text</type>
 368       <size>BIG</size>
 369     </html>
 370
 371     <import>true</import>
 372     <headerPattern>/(S(ource\s)?o(f\s)?C(ontact\s)?Data)$/i</headerPattern>
 373     <comment>where contact come from, e.g. import, donate module insert...</comment>
 374     <add>1.1</add>
 375   </field>
 376   <field>
 377     <name>first_name</name>
 378     <type>varchar</type>
 379     <length>64</length>
 380     <html>
 381       <type>Text</type>
 382       <size>BIG</size>
 383     </html>
 384     <import>true</import>
 385     <headerPattern>/^first|(f(irst\s)?name)$/i</headerPattern>
 386     <dataPattern>/^\w+$/</dataPattern>
 387     <fulltext/>
 388     <comment>First Name.</comment>
 389     <add>1.1</add>
 390   </field>
 391   <index>
 392     <name>index_first_name</name>
 393     <fieldName>first_name</fieldName>
 394     <add>1.8</add>
 395   </index>
 396   <field>
 397     <name>middle_name</name>
 398     <type>varchar</type>
 399     <length>64</length>
 400     <html>
 401       <type>Text</type>
 402       <size>MEDIUM</size>
 403     </html>
 404     <import>true</import>
 405     <headerPattern>/^middle|(m(iddle\s)?name)$/i</headerPattern>
 406     <dataPattern>/^\w+$/</dataPattern>
 407     <fulltext/>
 408     <comment>Middle Name.</comment>
 409     <add>1.1</add>
 410   </field>
 411   <field>
 412     <name>last_name</name>
 413     <type>varchar</type>
 414     <length>64</length>
 415     <html>
 416       <type>Text</type>
 417       <size>BIG</size>
 418     </html>
 419     <import>true</import>
 420     <headerPattern>/^last|(l(ast\s)?name)$/i</headerPattern>
 421     <dataPattern>/^\w+(\s\w+)?+$/</dataPattern>
 422     <comment>Last Name.</comment>
 423     <fulltext/>
 424     <add>1.1</add>
 425   </field>
 426   <index>
 427     <name>index_last_name</name>
 428     <fieldName>last_name</fieldName>
 429     <add>1.8</add>
 430     <html>
 431       <type>Text</type>
 432     </html>
 433   </index>
 434   <field>
 435     <name>prefix_id</name>
 436     <title>Individual Prefix</title>
 437     <type>int unsigned</type>
 438     <comment>Prefix or Title for name (Ms, Mr...). FK to prefix ID</comment>
 439     <pseudoconstant>
 440       <optionGroupName>individual_prefix</optionGroupName>
 441     </pseudoconstant>
 442     <html>
 443       <type>Select</type>
 444     </html>
 445     <headerPattern>/^(prefix|title)/i</headerPattern>
 446     <dataPattern>/^(mr|ms|mrs|sir|dr)\.?$/i</dataPattern>
 447     <import>true</import>
 448     <add>1.2</add>
 449   </field>
 450   <index>
 451     <name>UI_prefix</name>
 452     <fieldName>prefix_id</fieldName>
 453     <add>1.6</add>
 454   </index>
 455   <field>
 456     <name>suffix_id</name>
 457     <title>Individual Suffix</title>
 458     <type>int unsigned</type>
 459     <pseudoconstant>
 460       <optionGroupName>individual_suffix</optionGroupName>
 461     </pseudoconstant>
 462     <html>
 463       <type>Select</type>
 464     </html>
 465     <import>true</import>
 466     <comment>Suffix for name (Jr, Sr...). FK to suffix ID</comment>
 467     <headerPattern>/^suffix$/i</headerPattern>
 468     <dataPattern>/^(sr|jr)\.?|i{2,}$/</dataPattern>
 469     <add>1.2</add>
 470   </field>
 471   <index>
 472     <name>UI_suffix</name>
 473     <fieldName>suffix_id</fieldName>
 474     <add>1.6</add>
 475   </index>
 476   <field>
 477     <name>formal_title</name>
 478     <type>varchar</type>
 479     <length>64</length>
 480     <import>true</import>
 481     <headerPattern>/^title/i</headerPattern>
 482     <comment>Formal (academic or similar) title in front of name. (Prof., Dr. etc.)</comment>
 483     <add>4.5</add>
 484   </field>
 485   <field>
 486     <name>communication_style_id</name>
 487     <title>Communication Style</title>
 488     <type>int unsigned</type>
 489     <pseudoconstant>
 490       <optionGroupName>communication_style</optionGroupName>
 491     </pseudoconstant>
 492     <export>true</export>
 493     <comment>Communication style (e.g. formal vs. familiar) to use with this contact. FK to communication styles in civicrm_option_value.</comment>
 494     <add>4.4</add>
 495   </field>
 496   <index>
 497     <name>index_communication_style_id</name>
 498     <fieldName>communication_style_id</fieldName>
 499     <add>4.4</add>
 500   </index>
 501   <field>
 502     <name>greeting_type</name>
 503     <type>varchar</type>
 504     <length>128</length>
 505     <import>true</import>
 506     <comment>Preferred greeting format.</comment>
 507     <add>1.1</add>
 508     <drop>2.2</drop>
 509   </field>
 510   <field>
 511     <name>greeting_type_id</name>
 512     <title>Greeting Type</title>
 513     <type>int unsigned</type>
 514     <comment>FK to civicrm_option_value.id, that has to be valid, registered Greeting type.</comment>
 515     <add>2.2</add>
 516     <drop>3.0</drop>
 517   </field>
 518   <field>
 519     <name>custom_greeting</name>
 520     <type>varchar</type>
 521     <length>128</length>
 522     <import>true</import>
 523     <comment>Custom greeting message.</comment>
 524     <add>1.1</add>
 525     <drop>3.0</drop>
 526   </field>
 527   <field>
 528     <name>email_greeting_id</name>
 529     <type>int unsigned</type>
 530     <title>Email Greeting ID</title>
 531     <comment>FK to civicrm_option_value.id, that has to be valid registered Email Greeting.</comment>
 532     <add>3.0</add>
 533   </field>
 534   <field>
 535     <name>email_greeting_custom</name>
 536     <type>varchar</type>
 537     <length>128</length>
 538     <import>true</import>
 539     <export>false</export>
 540     <comment>Custom Email Greeting.</comment>
 541     <add>3.0</add>
 542     <html>
 543       <type>Text</type>
 544     </html>
 545   </field>
 546   <field>
 547     <name>email_greeting_display</name>
 548     <title>Email Greeting</title>
 549     <type>varchar</type>
 550     <length>255</length>
 551     <comment>Cache Email Greeting.</comment>
 552     <add>3.0</add>
 553     <html>
 554       <type>Text</type>
 555     </html>
 556   </field>
 557   <field>
 558     <name>postal_greeting_id</name>
 559     <type>int unsigned</type>
 560     <title>Postal Greeting ID</title>
 561     <comment>FK to civicrm_option_value.id, that has to be valid registered Postal Greeting.</comment>
 562     <add>3.0</add>
 563     <html>
 564       <type>Text</type>
 565     </html>
 566   </field>
 567   <field>
 568     <name>postal_greeting_custom</name>
 569     <type>varchar</type>
 570     <length>128</length>
 571     <import>true</import>
 572     <export>false</export>
 573     <comment>Custom Postal greeting.</comment>
 574     <add>3.0</add>
 575     <html>
 576       <type>Text</type>
 577     </html>
 578   </field>
 579   <field>
 580     <name>postal_greeting_display</name>
 581     <title>Postal Greeting</title>
 582     <type>varchar</type>
 583     <length>255</length>
 584     <comment>Cache Postal greeting.</comment>
 585     <add>3.0</add>
 586     <html>
 587       <type>Text</type>
 588     </html>
 589   </field>
 590   <field>
 591     <name>addressee_id</name>
 592     <type>int unsigned</type>
 593     <title>Addressee ID</title>
 594     <comment>FK to civicrm_option_value.id, that has to be valid registered Addressee.</comment>
 595     <add>3.0</add>
 596   </field>
 597   <field>
 598     <name>addressee_custom</name>
 599     <type>varchar</type>
 600     <length>128</length>
 601     <import>true</import>
 602     <export>false</export>
 603     <comment>Custom Addressee.</comment>
 604     <add>3.0</add>
 605     <html>
 606       <type>Text</type>
 607     </html>
 608   </field>
 609   <field>
 610     <name>addressee_display</name>
 611     <title>Addressee</title>
 612     <type>varchar</type>
 613     <length>255</length>
 614     <comment>Cache Addressee.</comment>
 615     <add>3.0</add>
 616     <html>
 617       <type>Text</type>
 618     </html>
 619   </field>
 620   <field>
 621     <name>job_title</name>
 622     <type>varchar</type>
 623     <length>255</length>
 624     <html>
 625       <type>Text</type>
 626       <size>MEDIUM</size>
 627     </html>
 628     <import>true</import>
 629     <headerPattern>/^job|(j(ob\s)?title)$/i</headerPattern>
 630     <dataPattern>//</dataPattern>
 631     <comment>Job Title</comment>
 632     <add>1.1</add>
 633   </field>
 634   <field>
 635     <name>gender_id</name>
 636     <title>Gender</title>
 637     <type>int unsigned</type>
 638     <pseudoconstant>
 639       <optionGroupName>gender</optionGroupName>
 640     </pseudoconstant>
 641     <html>
 642       <type>Select</type>
 643     </html>
 644     <headerPattern>/^gender$/i</headerPattern>
 645     <comment>FK to gender ID</comment>
 646     <import>true</import>
 647     <add>1.2</add>
 648   </field>
 649   <index>
 650     <name>UI_gender</name>
 651     <fieldName>gender_id</fieldName>
 652     <add>1.6</add>
 653     <html>
 654       <type>Select</type>
 655     </html>
 656   </index>
 657   <field>
 658     <name>birth_date</name>
 659     <type>date</type>
 660     <import>true</import>
 661     <headerPattern>/^birth|(b(irth\s)?date)|D(\W*)O(\W*)B(\W*)$/i</headerPattern>
 662     <dataPattern>/\d{4}-?\d{2}-?\d{2}/</dataPattern>
 663     <comment>Date of birth</comment>
 664     <add>1.1</add>
 665     <html>
 666       <type>Select Date</type>
 667     </html>
 668   </field>
 669   <field>
 670     <name>is_deceased</name>
 671     <title>Is Deceased</title>
 672     <import>true</import>
 673     <export>true</export>
 674     <headerPattern>/i(s\s)?d(eceased)$/i</headerPattern>
 675     <type>boolean</type>
 676     <default>0</default>
 677     <add>1.1</add>
 678     <html>
 679       <type>CheckBox</type>
 680     </html>
 681   </field>
 682   <field>
 683     <name>deceased_date</name>
 684     <type>date</type>
 685     <import>true</import>
 686     <export>true</export>
 687     <headerPattern>/^deceased|(d(eceased\s)?date)$/i</headerPattern>
 688     <comment>Date of deceased</comment>
 689     <add>1.5</add>
 690     <html>
 691       <type>Select Date</type>
 692     </html>
 693   </field>
 694   <field>
 695     <name>mail_to_household_id</name>
 696     <title>Mail to Household ID</title>
 697     <type>int unsigned</type>
 698     <comment>OPTIONAL FK to civicrm_contact_household record. If NOT NULL, direct mail communications to household rather than individual location. </comment>
 699     <export>true</export>
 700     <add>1.1</add>
 701     <drop>3.3</drop>
 702   </field>
 703   <foreignKey>
 704     <name>mail_to_household_id</name>
 705     <table>civicrm_contact</table>
 706     <key>id</key>
 707     <add>2.1</add>
 708     <onDelete>SET NULL</onDelete>
 709     <drop>3.3</drop>
 710   </foreignKey>
 711   <field>
 712     <name>household_name</name>
 713     <type>varchar</type>
 714     <length>128</length>
 715     <html>
 716       <type>Text</type>
 717       <size>BIG</size>
 718     </html>
 719     <import>true</import>
 720     <headerPattern>/^household|(h(ousehold\s)?name)$/i</headerPattern>
 721     <dataPattern>/^\w+$/</dataPattern>
 722     <comment>Household Name.</comment>
 723     <fulltext/>
 724     <add>1.1</add>
 725   </field>
 726   <index>
 727     <name>index_household_name</name>
 728     <fieldName>household_name</fieldName>
 729     <add>1.8</add>
 730   </index>
 731   <field>
 732     <name>primary_contact_id</name>
 733     <type>int unsigned</type>
 734     <title>Household Primary Contact ID</title>
 735     <comment>Optional FK to Primary Contact for this household.</comment>
 736     <add>1.1</add>
 737     <html>
 738       <type>Select</type>
 739     </html>
 740   </field>
 741   <foreignKey>
 742     <name>primary_contact_id</name>
 743     <table>civicrm_contact</table>
 744     <key>id</key>
 745     <add>1.1</add>
 746     <onDelete>SET NULL</onDelete>
 747   </foreignKey>
 748   <field>
 749     <name>organization_name</name>
 750     <type>varchar</type>
 751     <length>128</length>
 752     <html>
 753       <type>Text</type>
 754       <size>BIG</size>
 755     </html>
 756     <import>true</import>
 757     <headerPattern>/^organization|(o(rganization\s)?name)$/i</headerPattern>
 758     <dataPattern>/^\w+$/</dataPattern>
 759     <comment>Organization Name.</comment>
 760     <fulltext/>
 761     <add>1.1</add>
 762   </field>
 763   <index>
 764     <name>index_organization_name</name>
 765     <fieldName>organization_name</fieldName>
 766     <add>1.8</add>
 767   </index>
 768   <field>
 769     <name>sic_code</name>
 770     <type>varchar</type>
 771     <length>8</length>
 772     <import>true</import>
 773     <headerPattern>/^sic|(s(ic\s)?code)$/i</headerPattern>
 774     <comment>Standard Industry Classification Code.</comment>
 775     <add>1.1</add>
 776     <html>
 777       <type>Text</type>
 778     </html>
 779   </field>
 780   <field>
 781     <name>user_unique_id</name>
 782     <rule>url</rule>
 783     <title>Unique ID (OpenID)</title>
 784     <type>varchar</type>
 785     <length>255</length>
 786     <import>true</import>
 787     <headerPattern>/^Open\s?ID|u(niq\w*)?\s?ID/i</headerPattern>
 788     <dataPattern>/^[\w\/\:\.]+$/</dataPattern>
 789     <comment>the OpenID (or OpenID-style http://username.domain/) unique identifier for this contact mainly used for logging in to CiviCRM</comment>
 790     <add>2.0</add>
 791     <html>
 792       <type>Text</type>
 793     </html>
 794   </field>
 795   <field>
 796     <name>employer_id</name>
 797     <title>Current Employer ID</title>
 798     <uniqueName>current_employer_id</uniqueName>
 799     <type>int unsigned</type>
 800     <comment>OPTIONAL FK to civicrm_contact record.</comment>
 801     <export>true</export>
 802     <add>2.1</add>
 803     <html>
 804       <type>Autocomplete-Select</type>
 805     </html>
 806   </field>
 807   <foreignKey>
 808     <name>employer_id</name>
 809     <table>civicrm_contact</table>
 810     <key>id</key>
 811     <add>2.1</add>
 812     <onDelete>SET NULL</onDelete>
 813   </foreignKey>
 814   <field>
 815     <name>is_deleted</name>
 816     <title>Contact is in Trash</title>
 817     <uniqueName>contact_is_deleted</uniqueName>
 818     <type>boolean</type>
 819     <default>0</default>
 820     <required>true</required>
 821     <export>true</export>
 822     <add>3.2</add>
 823     <html>
 824       <type>CheckBox</type>
 825     </html>
 826   </field>
 827   <index>
 828     <name>index_is_deleted</name>
 829     <fieldName>is_deleted</fieldName>
 830     <add>3.2</add>
 831     <drop>4.4</drop>
 832   </index>
 833   <index>
 834     <name>index_is_deleted_sort_name</name>
 835     <fieldName>is_deleted</fieldName>
 836     <fieldName>sort_name</fieldName>
 837     <fieldName>id</fieldName>
 838     <add>4.4</add>
 839   </index>
 840   <field>
 841     <name>created_date</name>
 842     <type>timestamp</type>
 843     <comment>When was the contact was created.</comment>
 844     <required>false</required>
 845     <export>true</export>
 846     <default>NULL</default>
 847     <add>4.3</add>
 848   </field>
 849   <field>
 850     <name>modified_date</name>
 851     <type>timestamp</type>
 852     <comment>When was the contact (or closely related entity) was created or modified or deleted.</comment>
 853     <required>false</required>
 854     <export>true</export>
 855     <default>CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP</default>
 856     <add>4.3</add>
 857   </field>
 858 </table>