SystemDataChanges


Columns

Column Type Size Nulls Auto Default Children Parents Comments
SystemDataChangesSeq int identity 4 √ null
SynDatabaseCode varchar 15 null
ModifiedByID int 4 √ null
ModifiedDate datetime 16,3 √ null
TableName varchar 100 null
FieldName varchar 100 null
Key1 varchar 15 null
Key2 varchar 15 √ null
Key3 varchar 15 √ null
Key4 varchar 15 √ null
Key5 varchar 15 √ null
OldValue varchar 2000 √ null
NewValue varchar 2000 √ null
ChangeReasonCode varchar 15 √ null
ChangeDescription varchar 255 √ null

Table contained -1 rows

Indexes

Constraint Name Type Sort Column(s)
PK_SystemDataChanges Primary key Asc SystemDataChangesSeq
AK_SystemDataChanges_FieldName Performance Asc FieldName
AK_SystemDataChanges_Key1 Performance Asc Key1
AK_SystemDataChanges_Key2 Performance Asc Key2
AK_SystemDataChanges_Key3 Performance Asc Key3
AK_SystemDataChanges_Key4 Performance Asc Key4
AK_SystemDataChanges_Key5 Performance Asc Key5
AK_SystemDataChanges_TableName Performance Asc TableName