spauditlogfield

Table info.

Title Sp Audit Log Field
Description Sp Audit Log Field

Fields

Name Type Required Index Hidden On form Title Pick list Description
SpAuditLogFieldID int(11) PRI
TimestampCreated datetime Timestamp Created Same information as timestampCreated in the spAuditLog table.
TimestampModified datetime Timestamp Modified Same information as timestampCreated in the spAuditLog table.
Version int(11) Version Internal number, always = 0. No reporting value.
FieldName varchar(128) Field Name Name of the data field which had a changed or deleted value.
NewValue text New Value Resulting value of changed field.
OldValue text Old Value Original value of the field before the change or deletion.
ModifiedByAgentID int(11) MUL
SpAuditLogID int(11) MUL
CreatedByAgentID int(11) MUL

Indexes

Name Fields Unique Nullable
FK154AE9D45327F942 ModifiedByAgentID
FK154AE9D469D0534A SpAuditLogID
FK154AE9D47699B003 CreatedByAgentID
PRIMARY SpAuditLogFieldID

Many-to-one relationships

Name Field Related table Related field
FK154AE9D45327F942 ModifiedByAgentID agent AgentID
FK154AE9D469D0534A SpAuditLogID spauditlog SpAuditLogID
FK154AE9D47699B003 CreatedByAgentID agent AgentID