ALTER TABLE [GIS_ADMIN].[PST_Xref_SamplesInvestigations] WITH CHECK ADD CONSTRAINT [FKPSTXrefINVES__6D0D32F4] FOREIGN KEY([INVESTIGATION_ID])
REFERENCES [GIS_ADMIN].PST_Investigations
ON DELETE CASCADE
GO
ALTER TABLE [GIS_ADMIN].[PST_Xref_SamplesInvestigations] CHECK CONSTRAINT [FKPSTXrefINVES__6D0D32F4]
GO
USE [Pollution_Source_Tracking]
GO
ALTER TABLE [GIS_ADMIN].[SAMPLE_IMAGES] WITH CHECK ADD CONSTRAINT [FK_SAMPLE_IMAGES_PST_SAMPLES] FOREIGN KEY([SAMPLEID])
REFERENCES [GIS_ADMIN].PST_SAMPLES
ON DELETE CASCADE
GO
ALTER TABLE [GIS_ADMIN].[SAMPLE_IMAGES] CHECK CONSTRAINT [FK_SAMPLE_IMAGES_PST_SAMPLES]
GO
USE [Pollution_Source_Tracking]
GO
ALTER TABLE [GIS_ADMIN].[PST_PersonelXsamples] WITH CHECK ADD CONSTRAINT [FK_PST_PersonelXsamples_PST_SAMPLES] FOREIGN KEY([SAMPLE_ID])
REFERENCES [GIS_ADMIN].PST_SAMPLES
ON DELETE CASCADE
GO
ALTER TABLE [GIS_ADMIN].[PST_PersonelXsamples] CHECK CONSTRAINT [FK_PST_PersonelXsamples_PST_SAMPLES]
GO
USE [Pollution_Source_Tracking] GO
ALTER TABLE [GIS_ADMIN].[PST_Xref_SamplesInvestigations] WITH CHECK ADD CONSTRAINT [FKPSTXrefINVES__6D0D32F4] FOREIGN KEY([INVESTIGATION_ID]) REFERENCES [GIS_ADMIN].PST_Investigations ON DELETE CASCADE GO
ALTER TABLE [GIS_ADMIN].[PST_Xref_SamplesInvestigations] CHECK CONSTRAINT [FKPSTXrefINVES__6D0D32F4] GO
USE [Pollution_Source_Tracking] GO
ALTER TABLE [GIS_ADMIN].[SAMPLE_IMAGES] WITH CHECK ADD CONSTRAINT [FK_SAMPLE_IMAGES_PST_SAMPLES] FOREIGN KEY([SAMPLEID]) REFERENCES [GIS_ADMIN].PST_SAMPLES ON DELETE CASCADE GO
ALTER TABLE [GIS_ADMIN].[SAMPLE_IMAGES] CHECK CONSTRAINT [FK_SAMPLE_IMAGES_PST_SAMPLES] GO
USE [Pollution_Source_Tracking] GO
ALTER TABLE [GIS_ADMIN].[PST_PersonelXsamples] WITH CHECK ADD CONSTRAINT [FK_PST_PersonelXsamples_PST_SAMPLES] FOREIGN KEY([SAMPLE_ID]) REFERENCES [GIS_ADMIN].PST_SAMPLES ON DELETE CASCADE GO
ALTER TABLE [GIS_ADMIN].[PST_PersonelXsamples] CHECK CONSTRAINT [FK_PST_PersonelXsamples_PST_SAMPLES] GO