object_history

0 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 MEDIUMTEXT 16777215 NULL
newValue MEDIUMTEXT 16777215 NULL
changedBy INT 10 null
changeDate INT 10 null
actionType TINYINT 3 2

Indexes

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

Relationships