Merge pull request #19525 from eileenmcnaughton/member_soft
[civicrm-core.git] / xml / schema / Financial / EntityFinancialAccount.xml
old mode 100755 (executable)
new mode 100644 (file)
index 51c6aba..95e3111
@@ -7,12 +7,16 @@
   <add>4.3</add>
   <comment>Map between an entity and a financial account, where there is a specific relationship between the financial account and the entity, e.g. Income Account for or AR Account for</comment>
   <log>true</log>
+  <component>CiviContribute</component>
   <field>
     <name>id</name>
     <title>Entity Financial Account ID</title>
     <type>int unsigned</type>
     <required>true</required>
     <comment>ID</comment>
+    <html>
+      <type>Number</type>
+    </html>
     <add>4.3</add>
   </field>
   <primaryKey>
@@ -59,7 +63,7 @@
   <field>
     <name>financial_account_id</name>
     <type>int unsigned</type>
-    <title>Financial Account</title>
+    <title>Financial Account ID</title>
     <required>true</required>
     <add>4.3</add>
     <comment>FK to the financial_account_id</comment>
@@ -70,6 +74,7 @@
     </pseudoconstant>
     <html>
       <type>Select</type>
+      <label>Financial Account</label>
     </html>
   </field>
   <foreignKey>
     <add>4.3</add>
     <onDelete>RESTRICT</onDelete>
   </foreignKey>
+  <index>
+    <name>index_entity_id_entity_table_account_relationship</name>
+    <fieldName>entity_id</fieldName>
+    <fieldName>entity_table</fieldName>
+    <fieldName>account_relationship</fieldName>
+    <unique>true</unique>
+    <add>4.7</add>
+  </index>
 </table>
-