object_history

760619 rows


Columns

Column Type Size Nulls Auto Default Children Parents Comments
id INT 10 √ null
objectType VARCHAR 75 null
objectId INT 10 null
propertyName VARCHAR 75 null
oldValue TEXT 65535 √ NULL
newValue TEXT 65535 √ NULL
changedBy INT 10 null
changeDate INT 10 null
actionType TINYINT 3 √ 2

Indexes

Constraint Name Type Sort Column(s)
PRIMARY Primary key Asc id
actionType Performance Asc actionType
changedBy Performance Asc changedBy
objectType Performance Asc/Asc objectType + objectId

Relationships