Tables [dbo].[RTFeatureOptions_ShowCallNotes]
PropertyValue
HeapTrue
Row Count (~)0
Created12:58:54 AM Thursday, March 21, 2019
Last Modified1:14:08 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow Nulls
Foreign Keys FK_RTFeatureOptions_ShowCallNotes_TechnicianID_SCTechnicians: [dbo].[SCTechnicians].TechnicianIDTechnicianIDint4
True
Foreign Keys FK_RTFeatureOptions_ShowCallNotes_NoteTypeID_SHNoteTypes: [dbo].[SHNoteTypes].NoteTypeIDNoteTypeIDint4
True
EntityTypeIDint4
False
NameColumns
FK_RTFeatureOptions_ShowCallNotes_NoteTypeID_SHNoteTypesNoteTypeID->[dbo].[SHNoteTypes].[NoteTypeID]
FK_RTFeatureOptions_ShowCallNotes_TechnicianID_SCTechniciansTechnicianID->[dbo].[SCTechnicians].[TechnicianID]
CREATE TABLE [dbo].[RTFeatureOptions_ShowCallNotes]
(
[TechnicianID] [int] NULL,
[NoteTypeID] [int] NULL,
[EntityTypeID] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[RTFeatureOptions_ShowCallNotes] ADD CONSTRAINT [FK_RTFeatureOptions_ShowCallNotes_NoteTypeID_SHNoteTypes] FOREIGN KEY ([NoteTypeID]) REFERENCES [dbo].[SHNoteTypes] ([NoteTypeID])
GO
ALTER TABLE [dbo].[RTFeatureOptions_ShowCallNotes] ADD CONSTRAINT [FK_RTFeatureOptions_ShowCallNotes_TechnicianID_SCTechnicians] FOREIGN KEY ([TechnicianID]) REFERENCES [dbo].[SCTechnicians] ([TechnicianID])
GO