civicrm_log


Columns

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

Log 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.

data TEXT 65535 null

Updates does to this object if any.

modified_id INT UNSIGNED 10 null
civicrm_contact.id FK_civicrm_log_modified_id C

FK to Contact ID of person under whose credentials this data modification was made.

modified_date DATETIME 19 null

When was the referenced entity created or modified or deleted.

Table contained 181 rows

Indexes

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

Relationships