Tables [dbo].[SCQualificationCodeCallTypeDetails]
PropertyValue
Row Count (~)0
Created1:00:13 AM Thursday, March 21, 2019
Last Modified1:15:27 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentity
Cluster Primary Key PK__SCQualif__135C314DE40C0B12: DetailIDDetailIDint4
False
1 - 1
Foreign Keys FK_SCQualificationCodeCallTypeDetails_QualificationCodeID_SCQualificationCodes: [dbo].[SCQualificationCodes].QualificationCodeIDQualificationCodeIDint4
False
Foreign Keys FK_SCQualificationCodeCallTypeDetails_CallTypeID_SCCallTypes: [dbo].[SCCallTypes].CallTypeIDCallTypeIDint4
True
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK__SCQualif__135C314DE40C0B12: DetailIDPK__SCQualif__135C314DE40C0B12DetailID
True
80
NameColumns
FK_SCQualificationCodeCallTypeDetails_CallTypeID_SCCallTypesCallTypeID->[dbo].[SCCallTypes].[CallTypeID]
FK_SCQualificationCodeCallTypeDetails_QualificationCodeID_SCQualificationCodesQualificationCodeID->[dbo].[SCQualificationCodes].[QualificationCodeID]
CREATE TABLE [dbo].[SCQualificationCodeCallTypeDetails]
(
[DetailID] [int] NOT NULL IDENTITY(1, 1),
[QualificationCodeID] [int] NOT NULL,
[CallTypeID] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCQualificationCodeCallTypeDetails] ADD CONSTRAINT [PK__SCQualif__135C314DE40C0B12] PRIMARY KEY CLUSTERED  ([DetailID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCQualificationCodeCallTypeDetails] ADD CONSTRAINT [FK_SCQualificationCodeCallTypeDetails_CallTypeID_SCCallTypes] FOREIGN KEY ([CallTypeID]) REFERENCES [dbo].[SCCallTypes] ([CallTypeID])
GO
ALTER TABLE [dbo].[SCQualificationCodeCallTypeDetails] ADD CONSTRAINT [FK_SCQualificationCodeCallTypeDetails_QualificationCodeID_SCQualificationCodes] FOREIGN KEY ([QualificationCodeID]) REFERENCES [dbo].[SCQualificationCodes] ([QualificationCodeID])
GO