27,579
社区成员
发帖
与我相关
我的任务
分享
CREATE TABLE [dbo].[Audit](
[Audit_nbr] [int] IDENTITY(1,1) PRIMARY KEY NOT NULL,
[AuditType] [char](1) NOT NULL CHECK([AuditType] IN ('I','U','D')),
[TableName] [nvarchar](128) NOT NULL,
[PrimaryKeyField] [nvarchar](128) NULL,
[PrimaryKeyValue] NVARCHAR(1000) NULL,
[ForeignKeyField] [nvarchar](128) NULL,
[ForeignKeyValue] NVARCHAR(1000) NULL,
[FieldName] [nvarchar](128) NULL,
[OldValue] [nvarchar](4000) NULL,
[NewValue] [nvarchar](4000) NULL,
[UserName] [nvarchar](128) NULL, --这个将要存储程序操作的用户Name,而不是sa 或pcname\xxx
[CreateDate] [datetime] NOT NULL DEFAULT(CURRENT_TIMESTAMP)
)