Tables [dbo].[SCQualificationCodeModelDetails]
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__135C314D5AE13316: DetailIDDetailIDint4
False
1 - 1
Foreign Keys FK_SCQualificationCodeModelDetails_QualificationCodeID_SCQualificationCodes: [dbo].[SCQualificationCodes].QualificationCodeIDQualificationCodeIDint4
False
Foreign Keys FK_SCQualificationCodeModelDetails_ModelID_ICModels: [dbo].[ICModels].ModelIDModelIDint4
True
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK__SCQualif__135C314D5AE13316: DetailIDPK__SCQualif__135C314D5AE13316DetailID
True
80
NameColumns
FK_SCQualificationCodeModelDetails_ModelID_ICModelsModelID->[dbo].[ICModels].[ModelID]
FK_SCQualificationCodeModelDetails_QualificationCodeID_SCQualificationCodesQualificationCodeID->[dbo].[SCQualificationCodes].[QualificationCodeID]
CREATE TABLE [dbo].[SCQualificationCodeModelDetails]
(
[DetailID] [int] NOT NULL IDENTITY(1, 1),
[QualificationCodeID] [int] NOT NULL,
[ModelID] [int] NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCQualificationCodeModelDetails] ADD CONSTRAINT [PK__SCQualif__135C314D5AE13316] PRIMARY KEY CLUSTERED  ([DetailID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCQualificationCodeModelDetails] ADD CONSTRAINT [FK_SCQualificationCodeModelDetails_ModelID_ICModels] FOREIGN KEY ([ModelID]) REFERENCES [dbo].[ICModels] ([ModelID])
GO
ALTER TABLE [dbo].[SCQualificationCodeModelDetails] ADD CONSTRAINT [FK_SCQualificationCodeModelDetails_QualificationCodeID_SCQualificationCodes] FOREIGN KEY ([QualificationCodeID]) REFERENCES [dbo].[SCQualificationCodes] ([QualificationCodeID])
GO