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>
12 <type>int unsigned
</type>
13 <required>true
</required>
14 <comment>Note ID
</comment>
19 <autoincrement>true
</autoincrement>
22 <name>entity_table
</name>
25 <required>true
</required>
26 <comment>Name of table where item being referenced is stored.
</comment>
30 <name>entity_id
</name>
31 <type>int unsigned
</type>
32 <required>true
</required>
33 <comment>Foreign key to the referenced item.
</comment>
37 <idColumn>entity_id
</idColumn>
38 <typeColumn>entity_table
</typeColumn>
42 <name>index_entity
</name>
43 <fieldName>entity_table
</fieldName>
44 <fieldName>entity_id
</fieldName>
50 <comment>Note and/or Comment.
</comment>
51 <htmlType>textarea
</htmlType>
55 <headerPattern>/Note|Comment/i
</headerPattern>
56 <dataPattern>//
</dataPattern>
60 <name>contact_id
</name>
61 <type>int unsigned
</type>
62 <comment>FK to Contact ID creator
</comment>
66 <name>contact_id
</name>
67 <table>civicrm_contact
</table>
70 <onDelete>SET NULL
</onDelete>
73 <name>modified_date
</name>
75 <comment>When was this note last modified/edited
</comment>
82 <comment>subject of note description
</comment>
89 <comment>Foreign Key to Note Privacy Level (which is an option value pair and hence an implicit FK)
</comment>