AuditInfo

Fields

Field name	Ordinal	Native type	Length	Precision	Scale	Is Nullable	Is PK	Is FK	Is Identity	Is Computed	Default value	Default sequence
AuditInfoID	1	int	0	10	0		Yes		Yes
ActionDateTime	2	datetime	0	0	0
AffectedEntityName	3	varchar	100	0	0
AuditActionTypeID	4	int	0	10	0			Yes
ActionData	5	varchar	250	0	0	Yes
UserID	6	varchar	15	0	0			Yes

Foreign key constraints

FK_AuditInfo_AuditActionType

Aspect	Value
Primary key table	dbo.AuditActionType
Delete rule	NoAction
Update rule	NoAction

Foreign key field	Primary key field
AuditActionTypeID	dbo.AuditActionType.AuditActionTypeID

FK_AuditInfo_User

Aspect	Value
Primary key table	dbo.User
Delete rule	NoAction
Update rule	NoAction

Foreign key field	Primary key field
UserID	dbo.User.UserID

Model elements mapped on this table

None.