Column Type Size Nulls Auto Default Children Parents Comments
id INT UNSIGNED 10 null

Note ID

entity_table VARCHAR 64 null

Name of table where item being referenced is stored.

entity_id INT UNSIGNED 10 null

Foreign key to the referenced item.

note TEXT 65535 null

Note and/or Comment.

contact_id INT UNSIGNED 10 null FK_civicrm_note_contact_id N

FK to Contact ID creator

modified_date DATE 10 null

When was this note last modified/edited

subject VARCHAR 255 null

subject of note description

privacy VARCHAR 255 null

Foreign Key to Note Privacy Level (which is an option value pair and hence an implicit FK)

Table contained 0 rows


Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
FK_civicrm_note_contact_id Performance Asc contact_id
index_entity Performance Asc/Asc entity_table + entity_id