Tables [dbo].[SCTechnicianQualifications]
PropertyValue
Row Count (~)0
Created1:00:38 AM Thursday, March 21, 2019
Last Modified1:15:31 AM Thursday, March 21, 2019
KeyNameData TypeMax Length (Bytes)Allow NullsIdentity
Cluster Primary Key PK__SCTechni__C6EACAAE5443F38C: TechnicianQualificationIDTechnicianQualificationIDint4
False
1 - 1
Foreign Keys FK_SCTechnicianQualifications_TechnicianID_SCTechnicians: [dbo].[SCTechnicians].TechnicianIDTechnicianIDint4
False
Foreign Keys FK_SCTechnicianQualifications_QualificationCodeID_SCQualificationCodes: [dbo].[SCQualificationCodes].QualificationCodeIDQualificationCodeIDint4
False
KeyNameKey ColumnsUniqueFill Factor
Cluster Primary Key PK__SCTechni__C6EACAAE5443F38C: TechnicianQualificationIDPK__SCTechni__C6EACAAE5443F38CTechnicianQualificationID
True
80
NameColumns
FK_SCTechnicianQualifications_QualificationCodeID_SCQualificationCodesQualificationCodeID->[dbo].[SCQualificationCodes].[QualificationCodeID]
FK_SCTechnicianQualifications_TechnicianID_SCTechniciansTechnicianID->[dbo].[SCTechnicians].[TechnicianID]
CREATE TABLE [dbo].[SCTechnicianQualifications]
(
[TechnicianQualificationID] [int] NOT NULL IDENTITY(1, 1),
[TechnicianID] [int] NOT NULL,
[QualificationCodeID] [int] NOT NULL
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCTechnicianQualifications] ADD CONSTRAINT [PK__SCTechni__C6EACAAE5443F38C] PRIMARY KEY CLUSTERED  ([TechnicianQualificationID]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[SCTechnicianQualifications] ADD CONSTRAINT [FK_SCTechnicianQualifications_QualificationCodeID_SCQualificationCodes] FOREIGN KEY ([QualificationCodeID]) REFERENCES [dbo].[SCQualificationCodes] ([QualificationCodeID])
GO
ALTER TABLE [dbo].[SCTechnicianQualifications] ADD CONSTRAINT [FK_SCTechnicianQualifications_TechnicianID_SCTechnicians] FOREIGN KEY ([TechnicianID]) REFERENCES [dbo].[SCTechnicians] ([TechnicianID])
GO