CREATE TABLE [dbo].[DocumentUploadError]
(
[DocumentUploadErrorID] [int] NOT NULL IDENTITY(1, 1),
[DocumentUploadStatusFID] [int] NOT NULL,
[ErrorDateTime] [datetime] NOT NULL CONSTRAINT [DF_DocumentUploadError_ErrorDateTime] DEFAULT (getdate()),
[ErrorCodeFID] [int] NOT NULL,
[AdditionalData] [varchar] (64) COLLATE SQL_Latin1_General_CP1_CI_AS NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DocumentUploadError] ADD CONSTRAINT [PK_DocumentUploadError] PRIMARY KEY CLUSTERED  ([DocumentUploadErrorID]) WITH (FILLFACTOR=80) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [IX_DocumentUploadError_DocumentUploadStatusFID] ON [dbo].[DocumentUploadError] ([DocumentUploadStatusFID]) WITH (FILLFACTOR=80) ON [PRIMARY]
GO
ALTER TABLE [dbo].[DocumentUploadError] ADD CONSTRAINT [FK_DocumentUploadError_DocumentUploadStatus] FOREIGN KEY ([DocumentUploadStatusFID]) REFERENCES [dbo].[DocumentUploadStatus] ([DocumentUploadStatusID]) ON DELETE CASCADE
GO
ALTER TABLE [dbo].[DocumentUploadError] ADD CONSTRAINT [FK_DocumentUploadError_ErrorCode] FOREIGN KEY ([ErrorCodeFID]) REFERENCES [dbo].[ErrorCode] ([ECPriKey])
GO
GRANT SELECT ON  [dbo].[DocumentUploadError] TO [MssExec]
GRANT INSERT ON  [dbo].[DocumentUploadError] TO [MssExec]
GRANT DELETE ON  [dbo].[DocumentUploadError] TO [MssExec]
GRANT UPDATE ON  [dbo].[DocumentUploadError] TO [MssExec]
GO
EXEC sp_addextendedproperty N'MS_Description', N'Table used to track upload errors for documents that were uploaded from the Document Management Viewer to an external system, such as TransDocs.', 'SCHEMA', N'dbo', 'TABLE', N'DocumentUploadError', NULL, NULL
GO
EXEC sp_addextendedproperty N'MS_Description', N'Additional data returned from the external application relating to this error.', 'SCHEMA', N'dbo', 'TABLE', N'DocumentUploadError', 'COLUMN', N'AdditionalData'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Primary key of this table.', 'SCHEMA', N'dbo', 'TABLE', N'DocumentUploadError', 'COLUMN', N'DocumentUploadErrorID'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Foreign key linking this table to the DocumentUploadStatus table.', 'SCHEMA', N'dbo', 'TABLE', N'DocumentUploadError', 'COLUMN', N'DocumentUploadStatusFID'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Foreign key linking this table to the ErrorCode table.', 'SCHEMA', N'dbo', 'TABLE', N'DocumentUploadError', 'COLUMN', N'ErrorCodeFID'
GO
EXEC sp_addextendedproperty N'MS_Description', N'Date/time the error was processed', 'SCHEMA', N'dbo', 'TABLE', N'DocumentUploadError', 'COLUMN', N'ErrorDateTime'
GO