Merge pull request #1333 from eileenmcnaughton/CRM-13155

[civicrm-core.git] / xml / schema / Contact / RelationshipType.xml

<?xml version="1.0" encoding="iso-8859-1" ?>

<table>
  <base>CRM/Contact</base>
  <class>RelationshipType</class>
  <name>civicrm_relationship_type</name>
  <comment>Relationship types s/b structured with contact_a as the 'subject/child' contact and contact_b as the 'object/parent' contact (e.g. Individual A is Employee of Org B).</comment>
  <add>1.1</add>
  <log>true</log>
  <field>
      <name>id</name>
      <type>int unsigned</type>
      <title>Relationship Type ID</title>
      <required>true</required>
      <comment>Primary key</comment>
       <add>1.1</add>
  </field>
  <primaryKey>
       <name>id</name>
       <autoincrement>true</autoincrement>
  </primaryKey>
  <field>
       <name>name_a_b</name>
       <type>varchar</type>
       <title>Relationship Type Name A to B</title>
       <length>64</length>
       <comment>name for relationship of contact_a to contact_b.</comment>
       <add>1.1</add>
  </field>
  <field>
       <name>label_a_b</name>
       <type>varchar</type>
       <title>Relationship Type Label A to B</title>
       <length>64</length>
       <comment>label for relationship of contact_a to contact_b.</comment>
       <add>3.0</add>
  </field>
  <field>
       <name>name_b_a</name>
       <type>varchar</type>
       <title>Relationship Type Name B to A</title>
       <length>64</length>
       <comment>Optional name for relationship of contact_b to contact_a.</comment>
       <add>1.1</add>
  </field>
  <field>
       <name>label_b_a</name>
       <type>varchar</type>
       <title>Relationship Type Label B to A</title>
       <length>64</length>
       <comment>Optional label for relationship of contact_b to contact_a.</comment>
       <add>3.0</add>
  </field>
  <field>
       <name>description</name>
       <type>varchar</type>
       <title>Relationship Description</title>
       <length>255</length>
       <comment>Optional verbose description of the relationship type.</comment>
       <add>1.1</add>
  </field>
  <field>
       <name>contact_type_a</name>
       <type>enum</type>
       <title>Contact Type for Contact A</title>
       <values>Individual, Organization, Household</values>
       <comment>If defined, contact_a in a relationship of this type must be a specific contact_type.</comment>
       <add>1.1</add>
  </field>
  <field>
       <name>contact_type_b</name>
       <type>enum</type>
       <title>Contact Type for Contact B</title>
       <values>Individual, Organization, Household</values>
       <comment>If defined, contact_b in a relationship of this type must be a specific contact_type.</comment>
       <add>1.1</add>
  </field>
  <field>
       <name>contact_sub_type_a</name>
       <title>Contact Subtype A</title>
       <type>varchar</type>
       <length>64</length>
       <comment>If defined, contact_sub_type_a in a relationship of this type must be a specific contact_sub_type.</comment>
       <add>3.1</add>
  </field>
  <field>
       <name>contact_sub_type_b</name>
       <title>Contact Subtype B</title>
       <type>varchar</type>
       <length>64</length>
       <comment>If defined, contact_sub_type_b in a relationship of this type must be a specific contact_sub_type.</comment>
       <add>3.1</add>
  </field>
  <field>
       <name>is_reserved</name>
       <type>boolean</type>
        <title>Relationship Type is Reserved</title>
       <comment>Is this relationship type a predefined system type (can not be changed or de-activated)?</comment>
       <add>1.1</add>
  </field>
  <field>
       <name>is_active</name>
       <title>Relationship Type is Active</title>
       <type>boolean</type>
       <default>1</default>
       <comment>Is this relationship type currently active (i.e. can be used when creating or editing relationships)?</comment>
       <add>1.1</add>
  </field>
  <index>
    <name>UI_name_a_b</name>
    <fieldName>name_a_b</fieldName>
    <unique>true</unique>
    <add>2.1</add>
  </index>
  <index>
    <name>UI_name_b_a</name>
    <fieldName>name_b_a</fieldName>
    <unique>true</unique>
    <add>2.1</add>
  </index>
</table>