1 <?xml version=
"1.0" encoding=
"iso-8859-1" ?>
6 <name>civicrm_note
</name>
7 <comment>Notes can be linked to any object in the application.
</comment>
10 <icon>fa-sticky-note
</icon>
13 <title>Note ID
</title>
14 <type>int unsigned
</type>
15 <required>true
</required>
16 <comment>Note ID
</comment>
24 <autoincrement>true
</autoincrement>
27 <name>entity_table
</name>
28 <title>Note Entity
</title>
31 <required>true
</required>
32 <comment>Name of table where item being referenced is stored.
</comment>
34 <callback>CRM_Core_BAO_Note::entityTables
</callback>
39 <name>entity_id
</name>
40 <title>Note Entity ID
</title>
41 <type>int unsigned
</type>
42 <required>true
</required>
43 <comment>Foreign key to the referenced item.
</comment>
47 <idColumn>entity_id
</idColumn>
48 <typeColumn>entity_table
</typeColumn>
52 <name>index_entity
</name>
53 <fieldName>entity_table
</fieldName>
54 <fieldName>entity_id
</fieldName>
61 <comment>Note and/or Comment.
</comment>
68 <headerPattern>/Note|Comment/i
</headerPattern>
69 <dataPattern>//
</dataPattern>
73 <name>contact_id
</name>
74 <title>Created By Contact ID
</title>
75 <type>int unsigned
</type>
76 <comment>FK to Contact ID creator
</comment>
78 <label>Created By
</label>
83 <name>contact_id
</name>
84 <table>civicrm_contact
</table>
87 <onDelete>SET NULL
</onDelete>
90 <name>modified_date
</name>
91 <title>Note Modified By
</title>
92 <type>timestamp
</type>
93 <comment>When was this note last modified/edited
</comment>
94 <default>CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP
</default>
99 <title>Subject
</title>
102 <comment>subject of note description
</comment>
111 <title>Privacy
</title>
114 <comment>Foreign Key to Note Privacy Level (which is an option value pair and hence an implicit FK)
</comment>
120 <optionGroupName>note_privacy
</optionGroupName>