Merge pull request #19525 from eileenmcnaughton/member_soft
[civicrm-core.git] / xml / schema / Core / Managed.xml
CommitLineData
6a488035
TO
1<?xml version="1.0" encoding="iso-8859-1" ?>
2
3<table>
4 <base>CRM/Core</base>
5 <class>Managed</class>
6 <name>civicrm_managed</name>
7 <comment>List of declaratively managed objects</comment>
8 <add>4.2</add>
9 <log>false</log>
10 <field>
11 <name>id</name>
fa6ace1a 12 <title>Managed ID</title>
6a488035
TO
13 <type>int unsigned</type>
14 <required>true</required>
15 <comment>Surrogate Key</comment>
0481e12c
A
16 <html>
17 <type>Number</type>
18 </html>
6a488035
TO
19 <add>4.2</add>
20 </field>
21 <primaryKey>
22 <name>id</name>
23 <autoincrement>true</autoincrement>
24 </primaryKey>
25 <field>
26 <name>module</name>
27 <title>Module</title>
28 <type>varchar</type>
29 <length>127</length>
30 <required>true</required>
31 <comment>Name of the module which declared this object</comment>
32 <add>4.2</add>
33 </field>
34 <field>
35 <name>name</name>
36 <title>Name</title>
37 <type>varchar</type>
38 <length>127</length>
39 <comment>Symbolic name used by the module to identify the object</comment>
40 <add>4.2</add>
41 </field>
42 <index>
43 <name>UI_managed_module_name</name>
44 <fieldName>module</fieldName>
45 <fieldName>name</fieldName>
46 <add>4.2</add>
47 </index>
48 <field>
49 <name>entity_type</name>
f3ea5182 50 <title>Entity Type</title>
6a488035
TO
51 <type>varchar</type>
52 <length>64</length>
53 <required>true</required>
54 <comment>API entity type</comment>
55 <add>4.2</add>
56 </field>
57 <field>
58 <name>entity_id</name>
f3ea5182 59 <title>Entity ID</title>
6a488035
TO
60 <type>int unsigned</type>
61 <required>true</required>
62 <comment>Foreign key to the referenced item.</comment>
63 <add>4.2</add>
64 </field>
1f103dc4
TO
65 <field>
66 <name>cleanup</name>
f3ea5182 67 <title>Cleanup Setting</title>
1f103dc4
TO
68 <type>varchar</type>
69 <length>32</length>
70 <comment>Policy on when to cleanup entity (always, never, unused)</comment>
71 <pseudoconstant>
72 <callback>CRM_Core_ManagedEntities::getCleanupOptions</callback>
73 </pseudoconstant>
74 <html>
75 <type>Select</type>
76 </html>
77 <add>4.5</add>
78 </field>
6a488035
TO
79 <index>
80 <name>UI_managed_entity</name>
81 <fieldName>entity_type</fieldName>
82 <fieldName>entity_id</fieldName>
83 <add>4.2</add>
84 </index>
85</table>