16 lines
672 B
Transact-SQL
16 lines
672 B
Transact-SQL
CREATE TABLE [dbo].[MemberNotificationInfo]
|
|
(
|
|
[MemberNotificationInfoId] INT NOT NULL PRIMARY KEY IDENTITY,
|
|
[DocumentProcessingInfoId] INT NOT NULL,
|
|
[UploadDate] DATETIME NOT NULL,
|
|
[DeliveryMethod] INT NULL,
|
|
[SentTimeStamp] DATETIME NULL,
|
|
[AgreeUserId] VARCHAR(50) NULL,
|
|
[EntityName] VARCHAR(100) NULL,
|
|
[EmailAddress] VARCHAR(100) NULL,
|
|
[NotificationStatusType] INT NOT NULL,
|
|
[Attempts] INT NOT NULL DEFAULT 0,
|
|
[ResponseTimeStamp] DATETIME NULL,
|
|
CONSTRAINT [FK_MemberNotificationInfo_DocumentProcessingInfo] FOREIGN KEY ([DocumentProcessingInfoId]) REFERENCES [DocumentProcessingInfo]([DocumentProcessingInfoId])
|
|
)
|