Merge pull request #9028 from patelnainesh222/patch-1
[civicrm-core.git] / xml / schema / Core / OptionGroup.xml
1 <?xml version="1.0" encoding="iso-8859-1" ?>
2
3 <table>
4 <base>CRM/Core</base>
5 <class>OptionGroup</class>
6 <name>civicrm_option_group</name>
7 <add>1.5</add>
8 <log>true</log>
9 <field>
10 <name>id</name>
11 <title>Option Group ID</title>
12 <type>int unsigned</type>
13 <required>true</required>
14 <comment>Option Group ID</comment>
15 <add>1.5</add>
16 </field>
17 <primaryKey>
18 <name>id</name>
19 <autoincrement>true</autoincrement>
20 </primaryKey>
21 <field>
22 <name>name</name>
23 <title>Option Group Name</title>
24 <type>varchar</type>
25 <length>64</length>
26 <required>true</required>
27 <comment>Option group name. Used as selection key by class properties which lookup options in civicrm_option_value.</comment>
28 <add>1.5</add>
29 </field>
30 <field>
31 <name>title</name>
32 <title>Option Group title</title>
33 <type>varchar</type>
34 <length>255</length>
35 <localizable>true</localizable>
36 <comment>Option Group title.</comment>
37 <add>1.5</add>
38 </field>
39 <field>
40 <name>description</name>
41 <title>Option Group Description</title>
42 <type>varchar</type>
43 <length>255</length>
44 <localizable>true</localizable>
45 <comment>Option group description.</comment>
46 <add>1.5</add>
47 </field>
48 <field>
49 <name>data_type</name>
50 <title>Data Type for this option group</title>
51 <type>varchar</type>
52 <length>128</length>
53 <comment>Option group description.</comment>
54 <pseudoconstant>
55 <callback>CRM_Utils_Type::dataTypes</callback>
56 </pseudoconstant>
57 <add>4.7</add>
58 </field>
59 <field>
60 <name>is_reserved</name>
61 <title>Option Group Is Reserved?</title>
62 <type>boolean</type>
63 <default>1</default>
64 <comment>Is this a predefined system option group (i.e. it can not be deleted)?</comment>
65 <add>1.5</add>
66 </field>
67 <field>
68 <name>is_active</name>
69 <title>Option Group Is Active?</title>
70 <type>boolean</type>
71 <comment>Is this option group active?</comment>
72 <add>1.5</add>
73 </field>
74 <field>
75 <name>is_locked</name>
76 <title>Option Group Is Locked</title>
77 <type>boolean</type>
78 <comment>A lock to remove the ability to add new options via the UI.</comment>
79 <add>4.5</add>
80 </field>
81 <index>
82 <name>UI_name</name>
83 <fieldName>name</fieldName>
84 <unique>true</unique>
85 <add>2.1</add>
86 </index>
87 </table>