xml/schema/Core/UFMatch.xml

   1 <?xml version="1.0" encoding="iso-8859-1" ?>
   2
   3 <table>
   4   <base>CRM/Core</base>
   5   <class>UFMatch</class>
   6   <name>civicrm_uf_match</name>
   7   <comment>The mapping from an user framework (UF) object to a CRM object.</comment>
   8   <add>1.1</add>
   9   <log>true</log>
  10   <field>
  11       <name>id</name>
  12       <type>int unsigned</type>
  13       <required>true</required>
  14       <comment>System generated ID.</comment>
  15       <add>1.1</add>
  16   </field>
  17   <primaryKey>
  18        <name>id</name>
  19        <autoincrement>true</autoincrement>
  20   </primaryKey>
  21   <field>
  22       <name>domain_id</name>
  23       <type>int unsigned</type>
  24       <required>true</required>
  25       <comment>Which Domain is this match entry for</comment>
  26       <pseudoconstant>
  27           <table>civicrm_domain</table>
  28           <keyColumn>id</keyColumn>
  29           <labelColumn>name</labelColumn>
  30       </pseudoconstant>
  31       <add>3.0</add>
  32   </field>
  33   <foreignKey>
  34        <name>domain_id</name>
  35        <table>civicrm_domain</table>
  36        <key>id</key>
  37        <add>3.0</add>
  38   </foreignKey>
  39   <field>
  40        <name>uf_id</name>
  41        <type>int unsigned</type>
  42        <required>true</required>
  43        <comment>UF ID</comment>
  44        <add>1.1</add>
  45   </field>
  46   <index>
  47      <name>I_civicrm_uf_match_uf_id</name>
  48      <fieldName>uf_id</fieldName>
  49      <add>3.3</add>
  50   </index>
  51   <field>
  52        <name>uf_name</name>
  53        <type>varchar</type>
  54        <length>128</length>
  55        <comment>UF Name</comment>
  56        <add>1.9.kabissa</add>
  57   </field>
  58   <field>
  59        <name>contact_id</name>
  60       <type>int unsigned</type>
  61       <comment>FK to Contact ID</comment>
  62       <add>1.1</add>
  63   </field>
  64   <foreignKey>
  65        <name>contact_id</name>
  66        <table>civicrm_contact</table>
  67        <key>id</key>
  68        <add>1.1</add>
  69        <onDelete>CASCADE</onDelete>
  70   </foreignKey>
  71   <field>
  72        <name>email</name>
  73        <type>varchar</type>
  74        <length>64</length>
  75        <rule>email</rule>
  76        <comment>Email address</comment>
  77        <add>1.1</add>
  78        <drop>2.0</drop>
  79   </field>
  80   <field>
  81     <name>language</name>
  82     <type>varchar</type>
  83     <length>5</length>
  84     <comment>UI language preferred by the given user/contact</comment>
  85     <add>2.1</add>
  86   </field>
  87   <index>
  88      <name>UI_uf_id_domain_id</name>
  89      <fieldName>uf_id</fieldName>
  90      <fieldName>domain_id</fieldName>
  91      <unique>true</unique>
  92      <add>1.5</add>
  93      <drop>1.7</drop>
  94   </index>
  95   <index>
  96      <name>UI_uf_name_domain_id</name>
  97      <fieldName>uf_name</fieldName>
  98      <fieldName>domain_id</fieldName>
  99      <unique>true</unique>
 100      <add>2.1</add>
 101   </index>
 102   <index>
 103     <name>UI_contact_domain_id</name>
 104     <fieldName>contact_id</fieldName>
 105      <fieldName>domain_id</fieldName>
 106     <unique>true</unique>
 107     <add>1.6</add>
 108   </index>
 109 </table>