CREATE TABLE [dbo].[SCWorkOrderNoteDetailFiles]
(
[NoteDetailID] [int] NOT NULL,
[NoteID] [int] NOT NULL,
[DBFileID] [int] NOT NULL,
[CreateDate] [datetime] NOT NULL CONSTRAINT [DF_SCWorkOrderNoteDetailFiles_CreateDate] DEFAULT (getdate()),
[LastUpdate] [datetime] NOT NULL CONSTRAINT [DF_SCWorkOrderNoteDetailFiles_LastUpdate] DEFAULT (getdate())
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCWorkOrderNoteDetailFiles] ADD CONSTRAINT [FK_SCWorkOrderNoteDetailFiles_DBFileID_DBFiles] FOREIGN KEY ([DBFileID]) REFERENCES [dbo].[DBFiles] ([DBFileID])
GO
ALTER TABLE [dbo].[SCWorkOrderNoteDetailFiles] ADD CONSTRAINT [FK_SCWorkOrderNoteDetailFiles_NoteDetailID_SCWorkOrderNoteDetails] FOREIGN KEY ([NoteDetailID]) REFERENCES [dbo].[SCWorkOrderNoteDetails] ([NoteDetailID])
GO
ALTER TABLE [dbo].[SCWorkOrderNoteDetailFiles] ADD CONSTRAINT [FK_SCWorkOrderNoteDetailFiles_NoteID_SCWorkOrderNotes] FOREIGN KEY ([NoteID]) REFERENCES [dbo].[SCWorkOrderNotes] ([NoteID])
GO