create table Current_Work( ID int IDENTITY NOT NULL, Job_Type nvarchar(255) NULL, Module_Type nvarchar(10) NULL, Workstation_Name nvarchar(80) NULL, Operator_Name nvarchar(80) NULL, File_Name nvarchar(255) NULL, File_Path nvarchar(255) NULL, Date_Time datetime NULL, File_Creation_Date_Time datetime NULL, CONSTRAINT PK_current_work PRIMARY KEY CLUSTERED ( ID ), CONSTRAINT IX_current_work UNIQUE NONCLUSTERED ( ID, Job_Type, Module_Type, Workstation_Name, Operator_Name, Date_Time ) ) create table Deleted_Work( ID int IDENTITY NOT NULL, Job_Type nvarchar(255) NULL, Module_Type nvarchar(10) NULL, Workstation_Name nvarchar(80) NULL, Operator_Name nvarchar(80) NULL, File_Name nvarchar(255) NULL, File_Path nvarchar(255) NULL, Date_Time datetime NULL, File_Creation_Date_Time datetime NULL, CONSTRAINT PK_deleted_work PRIMARY KEY CLUSTERED ( ID ), CONSTRAINT IX_deleted_work UNIQUE NONCLUSTERED ( ID, Job_Type, Module_Type, Workstation_Name, Operator_Name, Date_Time ) ) create table Routed_Work( ID int IDENTITY NOT NULL, Job_Type nvarchar(255) NULL, Module_Type nvarchar(10) NULL, Workstation_Name nvarchar(80) NULL, Operator_Name nvarchar(80) NULL, File_Name nvarchar(255) NULL, File_Path nvarchar(255) NULL, Date_Time datetime NULL, File_Creation_Date_Time datetime NULL, Routed_To_Job_Type nvarchar(255) NULL, Routed_To_File_Path nvarchar(255) NULL, CONSTRAINT PK_routed_work PRIMARY KEY CLUSTERED ( ID ), CONSTRAINT IX_routed_work UNIQUE NONCLUSTERED ( ID, Job_Type, Module_Type, Workstation_Name, Operator_Name, Date_Time ) ) create table Completed_Work( ID int IDENTITY NOT NULL, Date_Time datetime NULL, Module_Type nvarchar(10) NULL, Job_Type nvarchar(255) NULL, Other_Destination nvarchar(80) NULL, Input_Filename nvarchar(255) NULL, Input_Directory nvarchar(255) NULL, Output_Filename nvarchar(255) NULL, Output_Directory nvarchar(255) NULL, Output_Email_Address nvarchar(255) NULL, Output_FtpServer_Address nvarchar(255) NULL, Output_File_Format nvarchar(5) NULL, Output_File_Size int NULL, Number_Of_Pages int NULL, Elapsed_Time int NULL, Routing_Rulename nvarchar(255) NULL, Processed_By nvarchar(80) NULL, KFI_Index_File nvarchar(255) NULL, KFI_Index_File2 nvarchar(255) NULL, Key_Strokes int NULL, Workstation_Name nvarchar(80) NULL, Operator_Name nvarchar(80) NULL, Zone_Errors int NULL, Scanner_Settings nvarchar(255) NULL, Enhancement_Settings nvarchar(255) NULL, File_Creation_Date_Time datetime NULL, CONSTRAINT PK_completed_work PRIMARY KEY CLUSTERED ( ID ), CONSTRAINT IX_completed_work UNIQUE NONCLUSTERED ( ID, Job_Type, Module_Type, Workstation_Name, Operator_Name, Date_Time ) )