CRM-13497 - getting there on main tables
[civicrm-core.git] / xml / schema / Grant / Grant.xml
index 3fe82f373a229f9dd0bbf5fbe41990e9f17a58b2..0301e2a4ee8ea95a2013aca3773f2e4302cf026c 100644 (file)
@@ -29,6 +29,9 @@
     <required>true</required>
     <comment>Contact ID of contact record given grant belongs to.</comment>
     <add>1.8</add>
+    <html>
+       <type>Autocomplete-Select</type>
+     </html>
   </field>
   <foreignKey>
     <name>contact_id</name>
@@ -36,7 +39,7 @@
     <key>id</key>
     <add>1.8</add>
     <onDelete>CASCADE</onDelete>
-  </foreignKey>  
+  </foreignKey>
   <field>
     <name>application_received_date</name>
     <title>Application received date</title>
@@ -52,6 +55,9 @@
     <comment>Date on which grant decision was made.</comment>
     <import>true</import>
     <add>1.8</add>
+    <html>
+      <type>Select Date</type>
+    </html>
   </field>
   <field>
     <name>money_transfer_date</name>
@@ -60,6 +66,9 @@
     <comment>Date on which grant money transfer was made.</comment>
     <import>true</import>
     <add>1.8</add>
+    <html>
+      <type>Select Date</type>
+    </html>
   </field>
   <field>
     <name>grant_due_date</name>
@@ -67,6 +76,9 @@
     <title>Grant Due Date</title>
     <comment>Date on which grant report is due.</comment>
     <add>1.8</add>
+    <html>
+      <type>Select Date</type>
+    </html>
   </field>
   <field>
     <name>grant_report_received</name>
@@ -75,6 +87,9 @@
     <comment>Yes/No field stating whether grant report was received by donor.</comment>
     <import>true</import>
     <add>1.8</add>
+    <html>
+      <type>CheckBox</type>
+    </html>
   </field>
   <field>
     <name>grant_type_id</name>
@@ -83,6 +98,9 @@
     <pseudoconstant>
       <optionGroupName>grant_type</optionGroupName>
     </pseudoconstant>
+    <html>
+      <type>Select></type>
+    </html>
     <export>false</export>
     <required>true</required>
     <comment>Type of grant. Implicit FK to civicrm_option_value in grant_type option_group.</comment>
     <pseudoconstant>
       <optionGroupName>grant_type</optionGroupName>
     </pseudoconstant>
+    <html>
+      <type>Select></type>
+    </html>
     <add>1.8</add>
   </index>
-  <field>     
+  <field>
     <name>amount_total</name>
     <title>Total Amount</title>
     <type>decimal</type>
     <import>true</import>
     <comment>Requested grant amount, in default currency.</comment>
     <add>1.8</add>
+   <html>
+     <type>Text</type>
+   </html>
   </field>
   <field>
     <name>amount_requested</name>
     <dataPattern>/^\d+(\.\d{2})?$/</dataPattern>
     <comment>Requested grant amount, in original currency (optional).</comment>
     <add>1.8</add>
+    <html>
+     <type>Text</type>
+   </html>
   </field>
   <field>
     <name>amount_granted</name>
     <import>true</import>
     <comment>Granted amount, in default currency.</comment>
     <add>1.8</add>
+    <html>
+          <type>Text</type>
+        </html>
   </field>
   <field>
     <name>currency</name>
+    <title>Grant Currency</title>
     <type>varchar</type>
     <length>3</length>
     <required>true</required>
       <pseudoconstant>
         <table>civicrm_currency</table>
         <keyColumn>name</keyColumn>
-        <labelColumn>symbol</labelColumn>
+        <labelColumn>full_name</labelColumn>
+        <nameColumn>numeric_code</nameColumn>
       </pseudoconstant>
+      <html>
+        <type>Select></type>
+      </html>
   </field>
   <field>
     <name>currency</name>
     <length>8</length>
     <default>NULL</default>
     <comment>3 character string, value from config setting or input via user.</comment>
-    <add>3.2</add>  
+    <add>3.2</add>
     <drop>4.3</drop>
   </field>
-  <field> 
+  <field>
     <name>rationale</name>
     <type>text</type>
     <title>Grant Rationale</title>
     <comment>Grant rationale.</comment>
-    <htmlType>textarea</htmlType>
-    <rows>4</rows>
-    <cols>60</cols>
+    <html>
+      <type>TextArea</type>
+      <rows>4</rows>
+      <cols>60</cols>
+    </html>
     <import>true</import>
     <add>1.8</add>
   </field>
-  <field> 
+  <field>
     <name>status_id</name>
     <type>int unsigned</type>
     <title>Grant Status Id</title>
     <uniqueName>grant_status_id</uniqueName>
     <required>true</required>
-    <import>true</import> 
+    <import>true</import>
     <export>false</export>
     <comment>Id of Grant status.</comment>
     <pseudoconstant>
       <optionGroupName>grant_status</optionGroupName>
     </pseudoconstant>
+    <html>
+      <type>Select></type>
+    </html>
     <add>1.8</add>
   </field>
-  <index> 
+  <index>
     <name>index_status_id</name>
     <fieldName>status_id</fieldName>
     <add>1.8</add>
   </index>
-  <field>  
-    <name>financial_type_id</name> 
+  <field>
+    <name>financial_type_id</name>
     <title>Financial Type</title>
-    <type>int unsigned</type>  
+    <type>int unsigned</type>
     <default>NULL</default>
     <comment>FK to Financial Type.</comment>
-    <add>4.3</add> 
-  </field>    
-  <foreignKey>  
-    <name>financial_type_id</name>  
-    <table>civicrm_financial_type</table>  
-    <key>id</key>  
+    <add>4.3</add>
+  </field>
+  <foreignKey>
+    <name>financial_type_id</name>
+    <table>civicrm_financial_type</table>
+    <key>id</key>
     <onDelete>SET NULL</onDelete>
     <add>4.3</add>
-  </foreignKey> 
+  </foreignKey>
 </table>