Tables [dbo].[SCWorkOrderNoteDetailFiles]
PropertyValue
HeapTrue
Row Count (~)0
Created1:00:39 AM Thursday, March 21, 2019
Last Modified1:15:31 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsDefault
Foreign Keys FK_SCWorkOrderNoteDetailFiles_NoteDetailID_SCWorkOrderNoteDetails: [dbo].[SCWorkOrderNoteDetails].NoteDetailIDNoteDetailIDint4
False
Foreign Keys FK_SCWorkOrderNoteDetailFiles_NoteID_SCWorkOrderNotes: [dbo].[SCWorkOrderNotes].NoteIDNoteIDint4
False
Foreign Keys FK_SCWorkOrderNoteDetailFiles_DBFileID_DBFiles: [dbo].[DBFiles].DBFileIDDBFileIDint4
False
CreateDatedatetime8
False
(getdate())
LastUpdatedatetime8
False
(getdate())
NameColumns
FK_SCWorkOrderNoteDetailFiles_DBFileID_DBFilesDBFileID->[dbo].[DBFiles].[DBFileID]
FK_SCWorkOrderNoteDetailFiles_NoteDetailID_SCWorkOrderNoteDetailsNoteDetailID->[dbo].[SCWorkOrderNoteDetails].[NoteDetailID]
FK_SCWorkOrderNoteDetailFiles_NoteID_SCWorkOrderNotesNoteID->[dbo].[SCWorkOrderNotes].[NoteID]
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