Merge pull request #22941 from sunilpawar/batch_copy_radio_clear_value
[civicrm-core.git] / xml / schema / Core / Mapping.xml
CommitLineData
6a488035
TO
1<?xml version="1.0" encoding="iso-8859-1" ?>
2
3<table>
4 <base>CRM/Core</base>
5 <class>Mapping</class>
6 <name>civicrm_mapping</name>
7 <comment>Store field mappings in import or export for reuse</comment>
8 <add>1.2</add>
9 <field>
8f069c03
EM
10 <name>id</name>
11 <type>int unsigned</type>
10d067c6 12 <title>Mapping ID</title>
8f069c03
EM
13 <required>true</required>
14 <comment>Mapping ID</comment>
0481e12c
A
15 <html>
16 <type>Number</type>
17 </html>
8f069c03 18 <add>1.2</add>
6a488035
TO
19 </field>
20 <primaryKey>
8f069c03
EM
21 <name>id</name>
22 <autoincrement>true</autoincrement>
23 <add>1.2</add>
6a488035
TO
24 </primaryKey>
25 <field>
8f069c03 26 <name>name</name>
110684e4 27 <title>Mapping Name</title>
8f069c03
EM
28 <type>varchar</type>
29 <length>64</length>
30 <comment>Name of Mapping</comment>
31 <add>1.2</add>
6a488035
TO
32 </field>
33 <field>
8f069c03 34 <name>description</name>
110684e4 35 <title>Description</title>
8f069c03
EM
36 <type>varchar</type>
37 <length>255</length>
38 <comment>Description of Mapping.</comment>
39 <add>1.2</add>
6a488035 40 </field>
6a488035 41 <field>
8f069c03
EM
42 <name>mapping_type_id</name>
43 <type>int unsigned</type>
10d067c6 44 <title>Mapping Type</title>
8f069c03
EM
45 <comment>Mapping Type</comment>
46 <add>2.1</add>
47 <pseudoconstant>
48 <optionGroupName>mapping_type</optionGroupName>
49 </pseudoconstant>
50 <html>
51 <type>Select</type>
52 </html>
6a488035
TO
53 </field>
54 <index>
55 <name>UI_name</name>
56 <fieldName>name</fieldName>
8f069c03 57 <add>1.2</add>
6a488035
TO
58 </index>
59</table>