Constraints

179 Foreign Key Constraints

Constraint Name Child Column Parent Column Delete Rule
FieldLogs_Points_ForeignKey
FieldLogs.PointId
Points.PointId
Cascade on delete
CPTInterpretationLayers_Layers_ForeignKey
CPTInterpretationLayers.LayerId
Layers.LayerId
Restrict delete
CPTInterpretationLayers_CPTInterpretations_ForeignKey
CPTInterpretationLayers.CPTInterpretationId
CPTInterpretations.CPTInterpretationId
Cascade on delete
DSSTests_Samples_ForeignKey
DSSTests.SampleId
Samples.SampleId
Cascade on delete
TriaxialTestStages_TriaxialTests_ForeignKey
TriaxialTestStages.TestId
TriaxialTests.TestId
Cascade on delete
HistoryValues_History_ForeignKey
HistoryValues.HistoryId
History.HistoryId
Cascade on delete
Samples_Layers_ForeignKey
Samples.LayerId
Layers.LayerId
Restrict delete
Samples_Points_ForeignKey
Samples.PointId
Points.PointId
Cascade on delete
Points_Companies_ForeignKey
Points.ContractorId
Companies.CompanyId
Restrict delete
Points_Projects_ForeignKey
Points.ProjectId
Projects.ProjectId
Cascade on delete
StandardDescriptions_Syntaxes_ForeignKey
StandardDescriptions.SyntaxId
Syntaxes.SyntaxId
Cascade on delete
SPTData_Points_ForeignKey
SPTData.PointId
Points.PointId
Cascade on delete
SPTData_Layers_ForeignKey
SPTData.LayerId
Layers.LayerId
Restrict delete
SyntaxElements_Syntaxes_ForeignKey
SyntaxElements.SyntaxId
Syntaxes.SyntaxId
Cascade on delete
SyntaxDesignations_SyntaxElements_ForeignKey
SyntaxDesignations.ElementId
SyntaxElements.ElementId
Cascade on delete
TriaxialTests_Samples_ForeignKey
TriaxialTests.SampleId
Samples.SampleId
Cascade on delete
TriaxialTests_Layers_ForeignKey
TriaxialTests.TestLayerId
Layers.LayerId
Restrict delete
Layers_LayerSeries_ForeignKey
Layers.SeriesId
LayerSeries.SeriesId
Cascade on delete
Layers_SoilTypes_ForeignKey
Layers.SoilTypeId
SoilTypes.SoilTypeId
Restrict delete
CPTData_CPTPush_ForeignKey
CPTData.TestId
CPTPush.TestId
Cascade on delete
CPTData_Layers_ForeignKey
CPTData.LayerId
Layers.LayerId
Restrict delete
Inclinations_Points_ForeignKey
Inclinations.PointId
Points.PointId
Cascade on delete
AnalysisAmberValues_Points_ForeignKey
AnalysisAmberValues.PointId
Points.PointId
Cascade on delete
AnalysisAmberValues_AnalysisParameters_ForeignKey
AnalysisAmberValues.ParameterId
AnalysisParameters.ParameterId
Restrict delete
AnalysisAmberValues_AnalysisUnits_ForeignKey
AnalysisAmberValues.UnitId
AnalysisUnits.UnitId
Restrict delete
AnalysisAmberValues_AnalysisMedia_ForeignKey
AnalysisAmberValues.MediumId
AnalysisMedia.MediumId
Restrict delete
SurfaceValues_Surfaces_ForeignKey
SurfaceValues.SurfaceId
Surfaces.SurfaceId
Cascade on delete
SurfaceValues_Strings_ForeignKey
SurfaceValues.StringId
Strings.StringId
Restrict delete
ConsolidationTests_Samples_ForeignKey
ConsolidationTests.SampleId
Samples.SampleId
Cascade on delete
PointLoadTests_Samples_ForeignKey
PointLoadTests.SampleId
Samples.SampleId
Cascade on delete
PointLoadTests_Layers_ForeignKey
PointLoadTests.TestLayerId
Layers.LayerId
Restrict delete
ShearBoxTests_Samples_ForeignKey
ShearBoxTests.SampleId
Samples.SampleId
Cascade on delete
ProctorTests_Samples_ForeignKey
ProctorTests.SampleId
Samples.SampleId
Cascade on delete
ProctorTests_Layers_ForeignKey
ProctorTests.TestLayerId
Layers.LayerId
Restrict delete
GLogs_Points_ForeignKey
GLogs.PointId
Points.PointId
Cascade on delete
Injections_Points_ForeignKey
Injections.PointId
Points.PointId
Cascade on delete
GrainSizeValues_GrainSizeTests_ForeignKey
GrainSizeValues.TestId
GrainSizeTests.TestId
Cascade on delete
DrillingObservations_Points_ForeignKey
DrillingObservations.PointId
Points.PointId
Cascade on delete
History_HistoryTransactions_ForeignKey
History.TransactionId
HistoryTransactions.TransactionId
Cascade on delete
UCTValues_UCTData_ForeignKey
UCTValues.TestId
UCTData.TestId
Cascade on delete
AnalysisRemarks_AnalysisSamples_ForeignKey
AnalysisRemarks.SampleId
AnalysisSamples.SampleId
Cascade on delete
SwellTests_Samples_ForeignKey
SwellTests.SampleId
Samples.SampleId
Cascade on delete
SwellTests_Layers_ForeignKey
SwellTests.TestLayerId
Layers.LayerId
Restrict delete
BrazilianTests_Samples_ForeignKey
BrazilianTests.SampleId
Samples.SampleId
Cascade on delete
AnalysisSamples_AnalysisMedia_ForeignKey
AnalysisSamples.MediumId
AnalysisMedia.MediumId
Restrict delete
AnalysisSamples_Points_ForeignKey
AnalysisSamples.PointId
Points.PointId
Cascade on delete
ClassificationTests_Layers_ForeignKey
ClassificationTests.TestLayerId
Layers.LayerId
Restrict delete
ClassificationTests_Samples_ForeignKey
ClassificationTests.SampleId
Samples.SampleId
Cascade on delete
DPTData_CPTPush_ForeignKey
DPTData.TestId
CPTPush.TestId
Cascade on delete
AnalysisGroupParameters_AnalysisSites_ForeignKey
AnalysisGroupParameters.SiteId
AnalysisSites.SiteId
Restrict delete
AnalysisGroupParameters_AnalysisMethods_ForeignKey
AnalysisGroupParameters.MethodId
AnalysisMethods.MethodId
Restrict delete
AnalysisGroupParameters_AnalysisGroups_ForeignKey
AnalysisGroupParameters.GroupId
AnalysisGroups.GroupId
Cascade on delete
AnalysisGroupParameters_AnalysisUnits_ForeignKey
AnalysisGroupParameters.UnitId
AnalysisUnits.UnitId
Restrict delete
AnalysisGroupParameters_AnalysisLaboratories_ForeignKey
AnalysisGroupParameters.LaboratoryId
AnalysisLaboratories.LaboratoryId
Restrict delete
AnalysisGroupParameters_AnalysisFiltrations_ForeignKey
AnalysisGroupParameters.FiltrationId
AnalysisFiltrations.FiltrationId
Restrict delete
AnalysisGroupParameters_AnalysisPreparations_ForeignKey
AnalysisGroupParameters.PreparationId
AnalysisPreparations.PreparationId
Restrict delete
AnalysisGroupParameters_AnalysisParameters_ForeignKey
AnalysisGroupParameters.ParameterId
AnalysisParameters.ParameterId
Restrict delete
ModelResults_ModelCells_ForeignKey
ModelResults.CellId
ModelCells.CellId
Cascade on delete
Grouting_Injections_ForeignKey
Grouting.InjectionId
Injections.InjectionId
Cascade on delete
SelectionIds_Selections_ForeignKey
SelectionIds.SelectionId
Selections.SelectionId
Cascade on delete
CPTPush_CPTCones_ForeignKey
CPTPush.Cone
CPTCones.Cone
Restrict delete
CPTPush_Points_ForeignKey
CPTPush.PointId
Points.PointId
Cascade on delete
PressuremeterTests_Layers_ForeignKey
PressuremeterTests.LayerId
Layers.LayerId
Restrict delete
PressuremeterTests_Points_ForeignKey
PressuremeterTests.PointId
Points.PointId
Cascade on delete
Measurements_MeasurementAggregations_ForeignKey
Measurements.AggregationId
MeasurementAggregations.AggregationId
Restrict delete
Measurements_Points_ForeignKey
Measurements.PointId
Points.PointId
Cascade on delete
Measurements_AnalysisParameters_ForeignKey
Measurements.ParameterId
AnalysisParameters.ParameterId
Restrict delete
Measurements_AnalysisUnits_ForeignKey
Measurements.UnitId
AnalysisUnits.UnitId
Restrict delete
Measurements_AnalysisMethods_ForeignKey
Measurements.MethodId
AnalysisMethods.MethodId
Restrict delete
Measurements_MeasurementTypes_ForeignKey
Measurements.Type
MeasurementTypes.Type
Restrict delete
Measurements_MeasurementDurations_ForeignKey
Measurements.DurationId
MeasurementDurations.DurationId
Restrict delete
ProjectSummary_Projects_ForeignKey
ProjectSummary.ProjectId
Projects.ProjectId
Cascade on delete
WaterStrikes_Points_ForeignKey
WaterStrikes.PointId
Points.PointId
Cascade on delete
AnalysisTriggerValues_AnalysisMedia_ForeignKey
AnalysisTriggerValues.MediumId
AnalysisMedia.MediumId
Restrict delete
AnalysisTriggerValues_AnalysisUnits_ForeignKey
AnalysisTriggerValues.UnitId
AnalysisUnits.UnitId
Restrict delete
AnalysisTriggerValues_AnalysisParameters_ForeignKey
AnalysisTriggerValues.ParameterId
AnalysisParameters.ParameterId
Restrict delete
ProjectPhases_Projects_ForeignKey
ProjectPhases.ProjectId
Projects.ProjectId
Cascade on delete
ProjectPhases_Companies_ForeignKey
ProjectPhases.PhaseCompanyId
Companies.CompanyId
Restrict delete
Strings_Projects_ForeignKey
Strings.ProjectId
Projects.ProjectId
Cascade on delete
WaterLevels_Intakes_ForeignKey
WaterLevels.IntakeId
Intakes.IntakeId
Cascade on delete
DSSTestValues_DSSTests_ForeignKey
DSSTestValues.TestId
DSSTests.TestId
Cascade on delete
AnalysisAttachedParameters_AnalysisUnits_ForeignKey
AnalysisAttachedParameters.UnitId
AnalysisUnits.UnitId
Restrict delete
AnalysisAttachedParameters_AnalysisMedia_ForeignKey
AnalysisAttachedParameters.MediumId
AnalysisMedia.MediumId
Restrict delete
AnalysisAttachedParameters_AnalysisParameters_ForeignKey
AnalysisAttachedParameters.ParameterId
AnalysisParameters.ParameterId
Cascade on delete
Documents_Points_ForeignKey
Documents.PointId
Points.PointId
Cascade on delete
Strata_Points_ForeignKey
Strata.PointId
Points.PointId
Cascade on delete
Strata_Interpretations_ForeignKey
Strata.Interpretation
Interpretations.Interpretation
Restrict delete
Strata_Layers_ForeignKey
Strata.LayerId
Layers.LayerId
Restrict delete
AnalysisUnitConversions_AnalysisUnits_ForeignKey
AnalysisUnitConversions.FromUnitId
AnalysisUnits.UnitId
Restrict delete
Areas_Projects_ForeignKey
Areas.ProjectId
Projects.ProjectId
Cascade on delete
AnalysisBottles_AnalysisSamples_ForeignKey
AnalysisBottles.SampleId
AnalysisSamples.SampleId
Cascade on delete
PenetrationTests_Layers_ForeignKey
PenetrationTests.LayerId
Layers.LayerId
Restrict delete
PenetrationTests_Points_ForeignKey
PenetrationTests.PointId
Points.PointId
Cascade on delete
LegPenetrations_Jackups_ForeignKey
LegPenetrations.JackupId
Jackups.JackupId
Cascade on delete
Initials_Companies_ForeignKey
Initials.CompanyId
Companies.CompanyId
Cascade on delete
AlignmentVertices_Alignments_ForeignKey
AlignmentVertices.AlignmentId
Alignments.AlignmentId
Cascade on delete
Sections_Alignments_ForeignKey
Sections.AlignmentId
Alignments.AlignmentId
Restrict delete
Sections_Projects_ForeignKey
Sections.ProjectId
Projects.ProjectId
Cascade on delete
AnalysisGroups_AnalysisScopes_ForeignKey
AnalysisGroups.ScopeId
AnalysisScopes.ScopeId
Restrict delete
AnalysisGroups_AnalysisPurposes_ForeignKey
AnalysisGroups.PurposeId
AnalysisPurposes.PurposeId
Restrict delete
AnalysisGroups_AnalysisCauses_ForeignKey
AnalysisGroups.CauseId
AnalysisCauses.CauseId
Restrict delete
AnalysisGroups_AnalysisExtents_ForeignKey
AnalysisGroups.ExtentId
AnalysisExtents.ExtentId
Restrict delete
ShearBoxTestValues_ShearBoxTests_ForeignKey
ShearBoxTestValues.TestId
ShearBoxTests.TestId
Cascade on delete
GrainSizes_Layers_ForeignKey
GrainSizes.TestLayerId
Layers.LayerId
Restrict delete
GrainSizes_GrainSizeClassifications_ForeignKey
GrainSizes.GrainSizeClassId
GrainSizeClassifications.GrainSizeClassId
Restrict delete
GrainSizes_Samples_ForeignKey
GrainSizes.SampleId
Samples.SampleId
Cascade on delete
GrainSizeClassificationValues_GrainSizeClassifications_ForeignKey
GrainSizeClassificationValues.GrainSizeClassId
GrainSizeClassifications.GrainSizeClassId
Cascade on delete
ProctorTestValues_ProctorTests_ForeignKey
ProctorTestValues.TestId
ProctorTests.TestId
Cascade on delete
HoleDiameters_Points_ForeignKey
HoleDiameters.PointId
Points.PointId
Cascade on delete
WaterVolumes_Points_ForeignKey
WaterVolumes.PointId
Points.PointId
Cascade on delete
PointSynonyms_Points_ForeignKey
PointSynonyms.PointId
Points.PointId
Cascade on delete
Surfaces_Projects_ForeignKey
Surfaces.ProjectId
Projects.ProjectId
Cascade on delete
Indurations_Layers_ForeignKey
Indurations.TestLayerId
Layers.LayerId
Restrict delete
Indurations_Samples_ForeignKey
Indurations.SampleId
Samples.SampleId
Cascade on delete
CPTInterpretationValues_CPTInterpretationLayers_ForeignKey
CPTInterpretationValues.CPTInterpretationLayerId
CPTInterpretationLayers.CPTInterpretationLayerId
Cascade on delete
ModelCells_Models_ForeignKey
ModelCells.ModelId
Models.ModelId
Cascade on delete
ModelCells_Layers_ForeignKey
ModelCells.LayerId
Layers.LayerId
Restrict delete
LabVaneTests_Samples_ForeignKey
LabVaneTests.SampleId
Samples.SampleId
Cascade on delete
LabVaneTests_Layers_ForeignKey
LabVaneTests.TestLayerId
Layers.LayerId
Restrict delete
DocumentRevisions_Documents_ForeignKey
DocumentRevisions.DocumentId
Documents.DocumentId
Cascade on delete
Projects_Interpretations_ForeignKey
Projects.Interpretation
Interpretations.Interpretation
Restrict delete
Projects_LayerSeries_ForeignKey
Projects.SeriesId
LayerSeries.SeriesId
Restrict delete
Projects_Companies_ForeignKey
Projects.CompanyId
Companies.CompanyId
Restrict delete
Projects_Projections_ForeignKey
Projects.Projection1
Projections.Epsg
Restrict delete
Projects_Syntaxes_ForeignKey
Projects.SyntaxId
Syntaxes.SyntaxId
Restrict delete
MeasurementData_Measurements_ForeignKey
MeasurementData.MeasurementId
Measurements.MeasurementId
Cascade on delete
AreaVertices_Areas_ForeignKey
AreaVertices.AreaId
Areas.AreaId
Cascade on delete
Fissures_Layers_ForeignKey
Fissures.TestLayerId
Layers.LayerId
Restrict delete
Fissures_Samples_ForeignKey
Fissures.SampleId
Samples.SampleId
Cascade on delete
SieveDiameters_Sieves_ForeignKey
SieveDiameters.SieveId
Sieves.SieveId
Cascade on delete
EMMTestValues_ClassificationTests_ForeignKey
EMMTestValues.TestId
ClassificationTests.TestId
Cascade on delete
ConsolidationTestCurves_ConsolidationTests_ForeignKey
ConsolidationTestCurves.TestId
ConsolidationTests.TestId
Cascade on delete
Alignments_Projects_ForeignKey
Alignments.ProjectId
Projects.ProjectId
Cascade on delete
Jackups_Points_ForeignKey
Jackups.PointId
Points.PointId
Cascade on delete
TriaxialTestCurves_TriaxialTestStages_ForeignKey
TriaxialTestCurves.StageId
TriaxialTestStages.StageId
Cascade on delete
AnalysisPurposes_AnalysisLimits_ForeignKey
AnalysisPurposes.LimitId
AnalysisLimits.LimitId
Restrict delete
SectionPoints_Sections_ForeignKey
SectionPoints.SectionId
Sections.SectionId
Cascade on delete
GLogValues_GLogs_ForeignKey
GLogValues.LogId
GLogs.LogId
Cascade on delete
InsituVaneTests_Points_ForeignKey
InsituVaneTests.PointId
Points.PointId
Cascade on delete
InsituVaneTests_Layers_ForeignKey
InsituVaneTests.LayerId
Layers.LayerId
Restrict delete
GrainSizeTests_GrainSizes_ForeignKey
GrainSizeTests.GrainSizeId
GrainSizes.GrainSizeId
Cascade on delete
GrainSizeTests_Hydrometers_ForeignKey
GrainSizeTests.HydrometerId
Hydrometers.HydrometerId
Restrict delete
GrainSizeTests_Sieves_ForeignKey
GrainSizeTests.SieveId
Sieves.SieveId
Restrict delete
DocumentItems_Documents_ForeignKey
DocumentItems.DocumentId
Documents.DocumentId
Cascade on delete
UserNotifications_Notifications_ForeignKey
UserNotifications.NotificationId
Notifications.NotificationId
Restrict delete
UserNotifications_Users_ForeignKey
UserNotifications.UserId
Users.UserId
Restrict delete
LayerSeries_Syntaxes_ForeignKey
LayerSeries.SyntaxId
Syntaxes.SyntaxId
Restrict delete
Models_Projects_ForeignKey
Models.ProjectId
Projects.ProjectId
Cascade on delete
Models_LayerSeries_ForeignKey
Models.SeriesId
LayerSeries.SeriesId
Restrict delete
UCTData_Samples_ForeignKey
UCTData.SampleId
Samples.SampleId
Cascade on delete
UCTData_Layers_ForeignKey
UCTData.TestLayerId
Layers.LayerId
Restrict delete
AnalysisValues_AnalysisUnits_ForeignKey
AnalysisValues.UnitId
AnalysisUnits.UnitId
Restrict delete
AnalysisValues_AnalysisMethods_ForeignKey
AnalysisValues.MethodId
AnalysisMethods.MethodId
Restrict delete
AnalysisValues_AnalysisSamples_ForeignKey
AnalysisValues.SampleId
AnalysisSamples.SampleId
Cascade on delete
AnalysisValues_AnalysisParameters_ForeignKey
AnalysisValues.ParameterId
AnalysisParameters.ParameterId
Restrict delete
ProjectRights_Projects_ForeignKey
ProjectRights.ProjectId
Projects.ProjectId
Cascade on delete
PlasticityTestValues_ClassificationTests_ForeignKey
PlasticityTestValues.TestId
ClassificationTests.TestId
Cascade on delete
PointSummary_Layers_ForeignKey
PointSummary.LayerId
Layers.LayerId
Restrict delete
PointSummary_Points_ForeignKey
PointSummary.PointId
Points.PointId
Cascade on delete
CPTSettings_CPTInterpretations_ForeignKey
CPTSettings.CPTInterpretationId2
CPTInterpretations.CPTInterpretationId
Restrict delete
CPTSettings_Projects_ForeignKey
CPTSettings.ProjectId
Projects.ProjectId
Cascade on delete
CPTInterpretations_LayerSeries_ForeignKey
CPTInterpretations.SeriesId
LayerSeries.SeriesId
Restrict delete
SyntaxSynonyms_SyntaxDesignations_ForeignKey
SyntaxSynonyms.LithologyId
SyntaxDesignations.LithologyId
Cascade on delete
AnalysisLimitValues_AnalysisParameters_ForeignKey
AnalysisLimitValues.ParameterId
AnalysisParameters.ParameterId
Restrict delete
AnalysisLimitValues_AnalysisLimits_ForeignKey
AnalysisLimitValues.LimitId
AnalysisLimits.LimitId
Cascade on delete
PumpingTests_Intakes_ForeignKey
PumpingTests.IntakeId
Intakes.IntakeId
Cascade on delete
PumpingTests_PumpingInterpTypes_ForeignKey
PumpingTests.InterpretationTypeId
PumpingInterpTypes.InterpretationTypeId
Restrict delete
PumpingTests_PumpingTestTypes_ForeignKey
PumpingTests.TestTypeId
PumpingTestTypes.TestTypeId
Restrict delete
Intakes_Points_ForeignKey
Intakes.PointId
Points.PointId
Cascade on delete
Intakes_Layers_ForeignKey
Intakes.LayerId
Layers.LayerId
Restrict delete
WaterLevelMPs_VerticalRefs_ForeignKey
WaterLevelMPs.VerticalRefId
VerticalRefs.VerticalRefId
Restrict delete
WaterLevelMPs_Intakes_ForeignKey
WaterLevelMPs.IntakeId
Intakes.IntakeId
Cascade on delete
CodeValues_Codes_ForeignKey
CodeValues.CodeId
Codes.CodeId
Cascade on delete
Municipalities_Regions_ForeignKey
Municipalities.RegionNo
Regions.RegionNo
Restrict delete
Casings_Points_ForeignKey
Casings.PointId
Points.PointId
Cascade on delete
SectionStrings_Sections_ForeignKey
SectionStrings.SectionId
Sections.SectionId
Cascade on delete
BackFill_Points_ForeignKey
BackFill.PointId
Points.PointId
Cascade on delete
BackFill_BackFillMaterial_ForeignKey
BackFill.MaterialId
BackFillMaterial.MaterialId
Restrict delete
ModelParameters_ModelCells_ForeignKey
ModelParameters.CellId
ModelCells.CellId
Cascade on delete

Check Constraints

Table Constraint Name Constraint
None detected