14 lines
431 B
Transact-SQL
14 lines
431 B
Transact-SQL
CREATE TABLE [dbo].[LoanAudit](
|
|
[AuditId] int NOT NULL IDENTITY,
|
|
[LoanId] int NULL,
|
|
[MemberNumber] VARCHAR(13) NULL,
|
|
[LoanNumber] VARCHAR(20) NULL,
|
|
[ModifiedBy] [varchar](50) NOT NULL,
|
|
[ModifiedDate] [smalldatetime] NOT NULL,
|
|
[OldValue] [varchar](MAX) NULL,
|
|
[NewValue] [varchar](MAX) NULL,
|
|
[ActivityType][varchar](20) NULL,
|
|
[AuditDescription] [varchar] (255) NULL,
|
|
CONSTRAINT [PK_LoanAudit] PRIMARY KEY (AuditId),
|
|
)
|