Index: Riskeer/Migration/src/Riskeer.Migration.Core/EmbeddedResources/DatabaseStructure23.2.sql =================================================================== diff -u -r786a8396c99eedb03a0f98445f9378cb7e4b6234 -rd6162ddb92f91604595c816d43d2d6d0370c0994 --- Riskeer/Migration/src/Riskeer.Migration.Core/EmbeddedResources/DatabaseStructure23.2.sql (.../DatabaseStructure23.2.sql) (revision 786a8396c99eedb03a0f98445f9378cb7e4b6234) +++ Riskeer/Migration/src/Riskeer.Migration.Core/EmbeddedResources/DatabaseStructure23.2.sql (.../DatabaseStructure23.2.sql) (revision d6162ddb92f91604595c816d43d2d6d0370c0994) @@ -1,6 +1,6 @@ /* ---------------------------------------------------- */ /* Generated by Enterprise Architect Version 16.1 */ -/* Created On : 25-mei-2023 12:58:18 */ +/* Created On : 27-feb-2024 16:36:22 */ /* DBMS : SQLite */ /* ---------------------------------------------------- */ @@ -304,2461 +304,2628 @@ CREATE TABLE VersionEntity ( - VersionId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - Version VARCHAR (20) NOT NULL, - Timestamp DATETIME NOT NULL, - FingerPrint BLOB NOT NULL + VersionId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + Version VARCHAR(20) NOT NULL, + Timestamp DATETIME NOT NULL, + FingerPrint BLOB NOT NULL ) ; CREATE TABLE ProjectEntity ( - ProjectEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - Description VARCHAR (260) NULL + ProjectEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + Description VARCHAR(260) NULL ) ; CREATE TABLE AssessmentSectionEntity ( - AssessmentSectionEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - ProjectEntityId INTEGER NOT NULL, - HydraulicLocationCalculationCollectionEntity1Id INTEGER NOT NULL, -- Represents the water level signal flooding probability - HydraulicLocationCalculationCollectionEntity2Id INTEGER NOT NULL, -- Represents the water level maximum allowable flooding probability - Id TEXT NULL COLLATE NOCASE, - Name VARCHAR (260) NULL, - Comments TEXT NULL COLLATE NOCASE, - MaximumAllowableFloodingProbability REAL NOT NULL, - SignalFloodingProbability REAL NOT NULL, - NormativeProbabilityType TINYINT (1) NOT NULL, -- EnumType: 1 = MaximumAllowableFloodingProbability, 2 = SignalFloodingProbability - Composition TINYINT (1) NOT NULL, -- Enum: 1 = Dike, 2 = Dune, 3 = DikeAndDune - ReferenceLinePointXml TEXT NULL COLLATE NOCASE, - CONSTRAINT FK_AssessmentSectionEntity_HydraulicLocationCalculationCollectionEntity1 FOREIGN KEY (HydraulicLocationCalculationCollectionEntity1Id) REFERENCES HydraulicLocationCalculationCollectionEntity (HydraulicLocationCalculationCollectionEntityId) ON DELETE No Action ON UPDATE Cascade, - CONSTRAINT FK_AssessmentSectionEntity_HydraulicLocationCalculationCollectionEntity2 FOREIGN KEY (HydraulicLocationCalculationCollectionEntity2Id) REFERENCES HydraulicLocationCalculationCollectionEntity (HydraulicLocationCalculationCollectionEntityId) ON DELETE No Action ON UPDATE Cascade, - CONSTRAINT FK_AssessmentSectionEntity_ProjectEntity FOREIGN KEY (ProjectEntityId) REFERENCES ProjectEntity (ProjectEntityId) ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT U_HydraulicLocationCalculationCollectionEntity1Id UNIQUE (HydraulicLocationCalculationCollectionEntity1Id), - CONSTRAINT U_HydraulicLocationCalculationCollectionEntity2Id UNIQUE (HydraulicLocationCalculationCollectionEntity2Id) + AssessmentSectionEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + ProjectEntityId INTEGER NOT NULL, + HydraulicLocationCalculationCollectionEntity1Id INTEGER NOT NULL, -- Represents the water level signal flooding probability + HydraulicLocationCalculationCollectionEntity2Id INTEGER NOT NULL, -- Represents the water level maximum allowable flooding probability + Id TEXT NULL COLLATE NOCASE, + Name VARCHAR(260) NULL, + Comments TEXT NULL COLLATE NOCASE, + MaximumAllowableFloodingProbability REAL NOT NULL, + SignalFloodingProbability REAL NOT NULL, + NormativeProbabilityType TINYINT (1) NOT NULL, -- EnumType: 1 = MaximumAllowableFloodingProbability, 2 = SignalFloodingProbability + Composition TINYINT (1) NOT NULL, -- Enum: 1 = Dike, 2 = Dune, 3 = DikeAndDune + ReferenceLinePointXml TEXT NULL COLLATE NOCASE, + AreFailureMechanismsCorrelated TINYINT (1) NOT NULL, -- true or false + CONSTRAINT FK_AssessmentSectionEntity_HydraulicLocationCalculationCollectionEntity1 FOREIGN KEY (HydraulicLocationCalculationCollectionEntity1Id) REFERENCES HydraulicLocationCalculationCollectionEntity (HydraulicLocationCalculationCollectionEntityId) ON DELETE No Action ON UPDATE Cascade, + CONSTRAINT FK_AssessmentSectionEntity_HydraulicLocationCalculationCollectionEntity2 FOREIGN KEY (HydraulicLocationCalculationCollectionEntity2Id) REFERENCES HydraulicLocationCalculationCollectionEntity (HydraulicLocationCalculationCollectionEntityId) ON DELETE No Action ON UPDATE Cascade, + CONSTRAINT FK_AssessmentSectionEntity_ProjectEntity FOREIGN KEY (ProjectEntityId) REFERENCES ProjectEntity (ProjectEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT U_HydraulicLocationCalculationCollectionEntity1Id UNIQUE (HydraulicLocationCalculationCollectionEntity1Id), + CONSTRAINT U_HydraulicLocationCalculationCollectionEntity2Id UNIQUE (HydraulicLocationCalculationCollectionEntity2Id) ) ; CREATE TABLE FailureMechanismSectionEntity ( - FailureMechanismSectionEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - Name VARCHAR (260) NOT NULL, - FailureMechanismSectionPointXml TEXT NOT NULL COLLATE NOCASE + FailureMechanismSectionEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + Name VARCHAR(260) NOT NULL, + FailureMechanismSectionPointXml TEXT NOT NULL COLLATE NOCASE ) ; CREATE TABLE FailureMechanismEntity ( - FailureMechanismEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - AssessmentSectionEntityId INTEGER NOT NULL, - CalculationGroupEntityId INTEGER NULL, - FailureMechanismType SMALLINT NOT NULL, -- Enum: 1 = Piping, 2 = Macrostabiliteit binnenwaarts, 3= Golfklappen op asfaltbekleding, 4= Grasbekleding erosie buitentalud, 5 = Grasbekleding afschuiven buitentalud, 6 = Grasbekleding erosie kruin en binnentalud, 7 = Stabiliteit steenzetting, 8 = Duinafslag, 9 = Hoogte kunstwerk, 10 = Betrouwbaarheid sluiten kunstwerk, 11 = Piping bij kunstwerk, 12 = Sterkte en stabiliteit puntconstructires, 13 = Microstabiliteit, 14 = Wateroverdruk bij asfaltbekleding, 15 = Grasbekleding afschuiven binnentalud - InAssembly TINYINT (1) NOT NULL, -- true or false - FailureMechanismSectionCollectionSourcePath TEXT NULL COLLATE NOCASE, - InAssemblyInputComments TEXT NULL COLLATE NOCASE, - InAssemblyOutputComments TEXT NULL COLLATE NOCASE, - NotInAssemblyComments TEXT NULL COLLATE NOCASE, - CalculationsInputComments TEXT NULL COLLATE NOCASE, - FailureMechanismAssemblyResultProbabilityResultType TINYINT (1) NOT NULL, -- Enum: None = 1, P1 = 2, P2 = 3, Manual = 4 - FailureMechanismAssemblyResultManualFailureMechanismAssemblyProbability REAL NULL, - CONSTRAINT FK_FailureMechanismEntity_AssessmentSectionEntity FOREIGN KEY (AssessmentSectionEntityId) REFERENCES AssessmentSectionEntity (AssessmentSectionEntityId) ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT FK_FailureMechanismEntity_CalculationGroupEntity FOREIGN KEY (CalculationGroupEntityId) REFERENCES CalculationGroupEntity (CalculationGroupEntityId) ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT UI_AssessmentSectionEntityId_FailureMechanismType UNIQUE (AssessmentSectionEntityId,FailureMechanismType) + FailureMechanismEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + AssessmentSectionEntityId INTEGER NOT NULL, + CalculationGroupEntityId INTEGER NULL, + FailureMechanismType SMALLINT NOT NULL, -- Enum: 1 = Piping, 2 = Macrostabiliteit binnenwaarts, 3= Golfklappen op asfaltbekleding, 4= Grasbekleding erosie buitentalud, 5 = Grasbekleding afschuiven buitentalud, 6 = Grasbekleding erosie kruin en binnentalud, 7 = Stabiliteit steenzetting, 8 = Duinafslag, 9 = Hoogte kunstwerk, 10 = Betrouwbaarheid sluiten kunstwerk, 11 = Piping bij kunstwerk, 12 = Sterkte en stabiliteit puntconstructires, 13 = Microstabiliteit, 14 = Wateroverdruk bij asfaltbekleding, 15 = Grasbekleding afschuiven binnentalud + InAssembly TINYINT (1) NOT NULL, -- true or false + FailureMechanismSectionCollectionSourcePath TEXT NULL COLLATE NOCASE, + InAssemblyInputComments TEXT NULL COLLATE NOCASE, + InAssemblyOutputComments TEXT NULL COLLATE NOCASE, + NotInAssemblyComments TEXT NULL COLLATE NOCASE, + CalculationsInputComments TEXT NULL COLLATE NOCASE, + FailureMechanismAssemblyResultProbabilityResultType TINYINT (1) NOT NULL, -- Enum: None = 1, P1 = 2, P2 = 3, Manual = 4 + FailureMechanismAssemblyResultManualFailureMechanismAssemblyProbability REAL NULL, + CONSTRAINT FK_FailureMechanismEntity_AssessmentSectionEntity FOREIGN KEY (AssessmentSectionEntityId) REFERENCES AssessmentSectionEntity (AssessmentSectionEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT FK_FailureMechanismEntity_CalculationGroupEntity FOREIGN KEY (CalculationGroupEntityId) REFERENCES CalculationGroupEntity (CalculationGroupEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT UI_AssessmentSectionEntityId_FailureMechanismType UNIQUE (AssessmentSectionEntityId, FailureMechanismType) ) ; CREATE TABLE ClosingStructuresFailureMechanismMetaEntity ( - ClosingStructuresFailureMechanismMetaEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - FailureMechanismEntityId INTEGER NOT NULL, - N2A INT (4) NOT NULL, - ClosingStructureCollectionSourcePath TEXT NULL COLLATE NOCASE, - ForeshoreProfileCollectionSourcePath TEXT NULL COLLATE NOCASE, - CONSTRAINT FK_ClosingStructuresFailureMechanismMetaEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade + ClosingStructuresFailureMechanismMetaEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + FailureMechanismEntityId INTEGER NOT NULL, + N2A INT (4) NOT NULL, + ClosingStructureCollectionSourcePath TEXT NULL COLLATE NOCASE, + ForeshoreProfileCollectionSourcePath TEXT NULL COLLATE NOCASE, + CONSTRAINT FK_ClosingStructuresFailureMechanismMetaEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; CREATE TABLE CalculationGroupEntity ( - CalculationGroupEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - ParentCalculationGroupEntityId INTEGER NULL, - Name VARCHAR (260) NULL, - 'Order' INT (4) NOT NULL, - CONSTRAINT FK_CalculationGroupEntity_CalculationGroupEntity FOREIGN KEY (ParentCalculationGroupEntityId) REFERENCES CalculationGroupEntity (CalculationGroupEntityId) ON DELETE Cascade ON UPDATE Cascade -) + CalculationGroupEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + ParentCalculationGroupEntityId INTEGER NULL, + Name VARCHAR(260) NULL, 'Order' + INT +( + 4 +) NOT NULL, + CONSTRAINT FK_CalculationGroupEntity_CalculationGroupEntity FOREIGN KEY (ParentCalculationGroupEntityId) REFERENCES CalculationGroupEntity (CalculationGroupEntityId) ON DELETE Cascade ON UPDATE Cascade + ) ; CREATE TABLE HydraulicLocationEntity ( - HydraulicLocationEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - HydraulicBoundaryDatabaseEntityId INTEGER NOT NULL, - LocationId INTEGER NOT NULL, - Name VARCHAR (260) NOT NULL, - LocationX REAL NULL, - LocationY REAL NULL, - 'Order' INT (4) NOT NULL, - CONSTRAINT FK_HydraulicLocationEntity_HydraulicBoundaryDatabaseEntity FOREIGN KEY (HydraulicBoundaryDatabaseEntityId) REFERENCES HydraulicBoundaryDatabaseEntity (HydraulicBoundaryDatabaseEntityId) ON DELETE Cascade ON UPDATE Cascade -) + HydraulicLocationEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + HydraulicBoundaryDatabaseEntityId INTEGER NOT NULL, + LocationId INTEGER NOT NULL, + Name VARCHAR(260) NOT NULL, + LocationX REAL NULL, + LocationY REAL NULL, 'Order' + INT +( + 4 +) NOT NULL, + CONSTRAINT FK_HydraulicLocationEntity_HydraulicBoundaryDatabaseEntity FOREIGN KEY (HydraulicBoundaryDatabaseEntityId) REFERENCES HydraulicBoundaryDatabaseEntity (HydraulicBoundaryDatabaseEntityId) ON DELETE Cascade ON UPDATE Cascade + ) ; CREATE TABLE GrassCoverErosionInwardsFailureMechanismMetaEntity ( - GrassCoverErosionInwardsFailureMechanismMetaEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - FailureMechanismEntityId INTEGER NOT NULL, - N REAL NOT NULL, - DikeProfileCollectionSourcePath TEXT NULL COLLATE NOCASE, - ApplyLengthEffectInSection TINYINT (1) NOT NULL, - CONSTRAINT FK_GrassCoverErosionInwardsFailureMechanismMetaEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade + GrassCoverErosionInwardsFailureMechanismMetaEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + FailureMechanismEntityId INTEGER NOT NULL, + N REAL NOT NULL, + DikeProfileCollectionSourcePath TEXT NULL COLLATE NOCASE, + ApplyLengthEffectInSection TINYINT (1) NOT NULL, + CONSTRAINT FK_GrassCoverErosionInwardsFailureMechanismMetaEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; CREATE TABLE SemiProbabilisticPipingCalculationEntity ( - SemiProbabilisticPipingCalculationEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - CalculationGroupEntityId INTEGER NOT NULL, - SurfaceLineEntityId INTEGER NULL, - PipingStochasticSoilProfileEntityId INTEGER NULL, - HydraulicLocationEntityId INTEGER NULL, - 'Order' INT (4) NOT NULL, - Name VARCHAR (260) NULL, - Comments TEXT NULL COLLATE NOCASE, - EntryPointL REAL NULL, - ExitPointL REAL NULL, - PhreaticLevelExitMean REAL NULL, - PhreaticLevelExitStandardDeviation REAL NULL, - DampingFactorExitMean REAL NULL, - DampingFactorExitStandardDeviation REAL NULL, - RelevantForScenario TINYINT (1) NOT NULL, -- true or false - ScenarioContribution REAL NOT NULL, - AssessmentLevel REAL NULL, - UseAssessmentLevelManualInput TINYINT (1) NOT NULL, -- true or false - CONSTRAINT FK_SemiProbabilisticPipingCalculationEntity_CalculationGroupEntity FOREIGN KEY (CalculationGroupEntityId) REFERENCES CalculationGroupEntity (CalculationGroupEntityId) ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT FK_SemiProbabilisticPipingCalculationEntity_HydraulicLocationEntity FOREIGN KEY (HydraulicLocationEntityId) REFERENCES HydraulicLocationEntity (HydraulicLocationEntityId) ON DELETE Set Null ON UPDATE Cascade, - CONSTRAINT FK_SemiProbabilisticPipingCalculationEntity_PipingStochasticSoilProfileEntity FOREIGN KEY (PipingStochasticSoilProfileEntityId) REFERENCES PipingStochasticSoilProfileEntity (PipingStochasticSoilProfileEntityId) ON DELETE Set Null ON UPDATE Cascade, - CONSTRAINT FK_SemiProbabilisticPipingCalculationEntity_SurfaceLineEntity FOREIGN KEY (SurfaceLineEntityId) REFERENCES SurfaceLineEntity (SurfaceLineEntityId) ON DELETE Set Null ON UPDATE Cascade -) + SemiProbabilisticPipingCalculationEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + CalculationGroupEntityId INTEGER NOT NULL, + SurfaceLineEntityId INTEGER NULL, + PipingStochasticSoilProfileEntityId INTEGER NULL, + HydraulicLocationEntityId INTEGER NULL, 'Order' + INT +( + 4 +) NOT NULL, + Name VARCHAR(260) NULL, + Comments TEXT NULL COLLATE NOCASE, + EntryPointL REAL NULL, + ExitPointL REAL NULL, + PhreaticLevelExitMean REAL NULL, + PhreaticLevelExitStandardDeviation REAL NULL, + DampingFactorExitMean REAL NULL, + DampingFactorExitStandardDeviation REAL NULL, + RelevantForScenario TINYINT (1) NOT NULL, -- true or false + ScenarioContribution REAL NOT NULL, + AssessmentLevel REAL NULL, + UseAssessmentLevelManualInput TINYINT (1) NOT NULL, -- true or false + CONSTRAINT FK_SemiProbabilisticPipingCalculationEntity_CalculationGroupEntity FOREIGN KEY (CalculationGroupEntityId) REFERENCES CalculationGroupEntity (CalculationGroupEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT FK_SemiProbabilisticPipingCalculationEntity_HydraulicLocationEntity FOREIGN KEY (HydraulicLocationEntityId) REFERENCES HydraulicLocationEntity (HydraulicLocationEntityId) ON DELETE Set Null ON UPDATE Cascade, + CONSTRAINT FK_SemiProbabilisticPipingCalculationEntity_PipingStochasticSoilProfileEntity FOREIGN KEY (PipingStochasticSoilProfileEntityId) REFERENCES PipingStochasticSoilProfileEntity (PipingStochasticSoilProfileEntityId) ON DELETE Set Null ON UPDATE Cascade, + CONSTRAINT FK_SemiProbabilisticPipingCalculationEntity_SurfaceLineEntity FOREIGN KEY (SurfaceLineEntityId) REFERENCES SurfaceLineEntity (SurfaceLineEntityId) ON DELETE Set Null ON UPDATE Cascade + ) ; CREATE TABLE GrassCoverErosionInwardsCalculationEntity ( - GrassCoverErosionInwardsCalculationEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - CalculationGroupEntityId INTEGER NOT NULL, - HydraulicLocationEntityId INTEGER NULL, - DikeProfileEntityId INTEGER NULL, - 'Order' INT (4) NOT NULL, - Name VARCHAR (260) NULL, - Comments TEXT NULL COLLATE NOCASE, - Orientation REAL NULL, - CriticalFlowRateMean REAL NULL, - CriticalFlowRateStandardDeviation REAL NULL, - UseForeshore TINYINT (1) NOT NULL, -- true or false - DikeHeight REAL NULL, - UseBreakWater TINYINT (1) NOT NULL, -- true or false - BreakWaterType TINYINT (1) NOT NULL, -- Enum: 1 = Wall, 2 = Caisson, 3 = Dam - BreakWaterHeight REAL NULL, - ShouldOvertoppingOutputIllustrationPointsBeCalculated TINYINT (1) NOT NULL, -- true or false - ShouldDikeHeightBeCalculated TINYINT (1) NOT NULL, -- true or false - DikeHeightTargetProbability REAL NOT NULL, - ShouldDikeHeightIllustrationPointsBeCalculated TINYINT (1) NOT NULL, -- true or false - ShouldOvertoppingRateBeCalculated TINYINT (1) NOT NULL, -- true or false - OvertoppingRateTargetProbability REAL NOT NULL, - ShouldOvertoppingRateIllustrationPointsBeCalculated TINYINT (1) NOT NULL, -- true or false - RelevantForScenario TINYINT (1) NOT NULL, -- true or false - ScenarioContribution REAL NOT NULL, - CONSTRAINT FK_GrassCoverErosionInwardsCalculationEntity_CalculationGroupEntity FOREIGN KEY (CalculationGroupEntityId) REFERENCES CalculationGroupEntity (CalculationGroupEntityId) ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT FK_GrassCoverErosionInwardsCalculationEntity_DikeProfileEntity FOREIGN KEY (DikeProfileEntityId) REFERENCES DikeProfileEntity (DikeProfileEntityId) ON DELETE Set Null ON UPDATE Cascade, - CONSTRAINT FK_GrassCoverErosionInwardsCalculationEntity_HydraulicLocationEntity FOREIGN KEY (HydraulicLocationEntityId) REFERENCES HydraulicLocationEntity (HydraulicLocationEntityId) ON DELETE Set Null ON UPDATE Cascade -) + GrassCoverErosionInwardsCalculationEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + CalculationGroupEntityId INTEGER NOT NULL, + HydraulicLocationEntityId INTEGER NULL, + DikeProfileEntityId INTEGER NULL, 'Order' + INT +( + 4 +) NOT NULL, + Name VARCHAR(260) NULL, + Comments TEXT NULL COLLATE NOCASE, + Orientation REAL NULL, + CriticalFlowRateMean REAL NULL, + CriticalFlowRateStandardDeviation REAL NULL, + UseForeshore TINYINT (1) NOT NULL, -- true or false + DikeHeight REAL NULL, + UseBreakWater TINYINT (1) NOT NULL, -- true or false + BreakWaterType TINYINT (1) NOT NULL, -- Enum: 1 = Wall, 2 = Caisson, 3 = Dam + BreakWaterHeight REAL NULL, + ShouldOvertoppingOutputIllustrationPointsBeCalculated TINYINT (1) NOT NULL, -- true or false + ShouldDikeHeightBeCalculated TINYINT (1) NOT NULL, -- true or false + DikeHeightTargetProbability REAL NOT NULL, + ShouldDikeHeightIllustrationPointsBeCalculated TINYINT (1) NOT NULL, -- true or false + ShouldOvertoppingRateBeCalculated TINYINT (1) NOT NULL, -- true or false + OvertoppingRateTargetProbability REAL NOT NULL, + ShouldOvertoppingRateIllustrationPointsBeCalculated TINYINT (1) NOT NULL, -- true or false + RelevantForScenario TINYINT (1) NOT NULL, -- true or false + ScenarioContribution REAL NOT NULL, + CONSTRAINT FK_GrassCoverErosionInwardsCalculationEntity_CalculationGroupEntity FOREIGN KEY (CalculationGroupEntityId) REFERENCES CalculationGroupEntity (CalculationGroupEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT FK_GrassCoverErosionInwardsCalculationEntity_DikeProfileEntity FOREIGN KEY (DikeProfileEntityId) REFERENCES DikeProfileEntity (DikeProfileEntityId) ON DELETE Set Null ON UPDATE Cascade, + CONSTRAINT FK_GrassCoverErosionInwardsCalculationEntity_HydraulicLocationEntity FOREIGN KEY (HydraulicLocationEntityId) REFERENCES HydraulicLocationEntity (HydraulicLocationEntityId) ON DELETE Set Null ON UPDATE Cascade + ) ; CREATE TABLE GrassCoverSlipOffInwardsFailureMechanismMetaEntity ( - GrassCoverSlipOffInwardsFailureMechanismMetaEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - FailureMechanismEntityId INTEGER NOT NULL, - N REAL NOT NULL, - ApplyLengthEffectInSection TINYINT (1) NOT NULL, - CONSTRAINT FK_GrassCoverSlipOffInwardsFailureMechanismMetaEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade + GrassCoverSlipOffInwardsFailureMechanismMetaEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + FailureMechanismEntityId INTEGER NOT NULL, + N REAL NOT NULL, + ApplyLengthEffectInSection TINYINT (1) NOT NULL, + CONSTRAINT FK_GrassCoverSlipOffInwardsFailureMechanismMetaEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; CREATE TABLE GrassCoverErosionOutwardsFailureMechanismMetaEntity ( - GrassCoverErosionOutwardsFailureMechanismMetaEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - FailureMechanismEntityId INTEGER NOT NULL, - N REAL NOT NULL, - ForeshoreProfileCollectionSourcePath TEXT NULL COLLATE NOCASE, - ApplyLengthEffectInSection TINYINT (1) NOT NULL, - CONSTRAINT FK_GrassCoverErosionOutwardsFailureMechanismMetaEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade + GrassCoverErosionOutwardsFailureMechanismMetaEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + FailureMechanismEntityId INTEGER NOT NULL, + N REAL NOT NULL, + ForeshoreProfileCollectionSourcePath TEXT NULL COLLATE NOCASE, + ApplyLengthEffectInSection TINYINT (1) NOT NULL, + CONSTRAINT FK_GrassCoverErosionOutwardsFailureMechanismMetaEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; CREATE TABLE PipingSoilLayerEntity ( - PipingSoilLayerEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - PipingSoilProfileEntityId INTEGER NOT NULL, - Top REAL NULL, - IsAquifer TINYINT (1) NOT NULL, -- true or false - Color INTEGER NULL, -- ARGB value of Color. - MaterialName TEXT NOT NULL COLLATE NOCASE, - BelowPhreaticLevelMean REAL NULL, - BelowPhreaticLevelDeviation REAL NULL, - BelowPhreaticLevelShift REAL NULL, - DiameterD70Mean REAL NULL, - DiameterD70CoefficientOfVariation REAL NULL, - PermeabilityMean REAL NULL, - PermeabilityCoefficientOfVariation REAL NULL, - 'Order' INT (4) NOT NULL, - CONSTRAINT FK_PipingSoilLayerEntity_SoilProfileEntity FOREIGN KEY (PipingSoilProfileEntityId) REFERENCES PipingSoilProfileEntity (PipingSoilProfileEntityId) ON DELETE Cascade ON UPDATE Cascade -) + PipingSoilLayerEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + PipingSoilProfileEntityId INTEGER NOT NULL, + Top REAL NULL, + IsAquifer TINYINT (1) NOT NULL, -- true or false + Color INTEGER NULL, -- ARGB value of Color. + MaterialName TEXT NOT NULL COLLATE NOCASE, + BelowPhreaticLevelMean REAL NULL, + BelowPhreaticLevelDeviation REAL NULL, + BelowPhreaticLevelShift REAL NULL, + DiameterD70Mean REAL NULL, + DiameterD70CoefficientOfVariation REAL NULL, + PermeabilityMean REAL NULL, + PermeabilityCoefficientOfVariation REAL NULL, 'Order' + INT +( + 4 +) NOT NULL, + CONSTRAINT FK_PipingSoilLayerEntity_SoilProfileEntity FOREIGN KEY (PipingSoilProfileEntityId) REFERENCES PipingSoilProfileEntity (PipingSoilProfileEntityId) ON DELETE Cascade ON UPDATE Cascade + ) ; CREATE TABLE PipingSoilProfileEntity ( - PipingSoilProfileEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - Bottom REAL NULL, - Name TEXT NOT NULL COLLATE NOCASE, - SourceType TINYINT (1) NOT NULL -- Enum: 1 = SoilProfile1D, 2 = SoilProfile2D + PipingSoilProfileEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + Bottom REAL NULL, + Name TEXT NOT NULL COLLATE NOCASE, + SourceType TINYINT (1) NOT NULL -- Enum: 1 = SoilProfile1D, 2 = SoilProfile2D ) ; CREATE TABLE PipingStochasticSoilProfileEntity ( - PipingStochasticSoilProfileEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - PipingSoilProfileEntityId INTEGER NOT NULL, - StochasticSoilModelEntityId INTEGER NOT NULL, - Probability REAL NOT NULL, - 'Order' INT (4) NOT NULL, - CONSTRAINT FK_PipingStochasticSoilProfileEntity_SoilProfileEntity FOREIGN KEY (PipingSoilProfileEntityId) REFERENCES PipingSoilProfileEntity (PipingSoilProfileEntityId) ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT FK_PipingStochasticSoilProfileEntity_StochasticSoilModelEntity FOREIGN KEY (StochasticSoilModelEntityId) REFERENCES StochasticSoilModelEntity (StochasticSoilModelEntityId) ON DELETE Cascade ON UPDATE Cascade -) + PipingStochasticSoilProfileEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + PipingSoilProfileEntityId INTEGER NOT NULL, + StochasticSoilModelEntityId INTEGER NOT NULL, + Probability REAL NOT NULL, 'Order' + INT +( + 4 +) NOT NULL, + CONSTRAINT FK_PipingStochasticSoilProfileEntity_SoilProfileEntity FOREIGN KEY (PipingSoilProfileEntityId) REFERENCES PipingSoilProfileEntity (PipingSoilProfileEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT FK_PipingStochasticSoilProfileEntity_StochasticSoilModelEntity FOREIGN KEY (StochasticSoilModelEntityId) REFERENCES StochasticSoilModelEntity (StochasticSoilModelEntityId) ON DELETE Cascade ON UPDATE Cascade + ) ; CREATE TABLE PipingScenarioConfigurationPerFailureMechanismSectionEntity ( - PipingScenarioConfigurationPerFailureMechanismSectionEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - FailureMechanismSectionEntityId INTEGER NOT NULL, - PipingScenarioConfigurationPerFailureMechanismSectionType TINYINT (1) NOT NULL, -- Enum: SemiProbabilistic = 1 Probabilistic = 2 - CONSTRAINT FK_PipingScenarioConfigurationPerFailureMechanismSectionEntity_FailureMechanismSectionEntity FOREIGN KEY (FailureMechanismSectionEntityId) REFERENCES FailureMechanismSectionEntity (FailureMechanismSectionEntityId) ON DELETE Cascade ON UPDATE Cascade + PipingScenarioConfigurationPerFailureMechanismSectionEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + FailureMechanismSectionEntityId INTEGER NOT NULL, + PipingScenarioConfigurationPerFailureMechanismSectionType TINYINT (1) NOT NULL, -- Enum: SemiProbabilistic = 1 Probabilistic = 2 + CONSTRAINT FK_PipingScenarioConfigurationPerFailureMechanismSectionEntity_FailureMechanismSectionEntity FOREIGN KEY (FailureMechanismSectionEntityId) REFERENCES FailureMechanismSectionEntity (FailureMechanismSectionEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; CREATE TABLE StochasticSoilModelEntity ( - StochasticSoilModelEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - FailureMechanismEntityId INTEGER NOT NULL, - Name TEXT NOT NULL COLLATE NOCASE, - StochasticSoilModelSegmentPointXml TEXT NOT NULL COLLATE NOCASE, - 'Order' INT (4) NOT NULL, - CONSTRAINT FK_StochasticSoilModelEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT UQ_StochasticSoilModelEntity_NameFailureMechanismEntityId UNIQUE (Name,FailureMechanismEntityId) -) + StochasticSoilModelEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + FailureMechanismEntityId INTEGER NOT NULL, + Name TEXT NOT NULL COLLATE NOCASE, + StochasticSoilModelSegmentPointXml TEXT NOT NULL COLLATE NOCASE, 'Order' + INT +( + 4 +) NOT NULL, + CONSTRAINT FK_StochasticSoilModelEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT UQ_StochasticSoilModelEntity_NameFailureMechanismEntityId UNIQUE (Name, FailureMechanismEntityId) + ) ; CREATE TABLE SurfaceLineEntity ( - SurfaceLineEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - FailureMechanismEntityId INTEGER NOT NULL, - Name VARCHAR (260) NOT NULL, - ReferenceLineIntersectionX REAL NULL, - ReferenceLineIntersectionY REAL NULL, - PointsXml TEXT NOT NULL COLLATE NOCASE, - 'Order' INT (4) NOT NULL, - CONSTRAINT FK_SurfaceLineEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT UQ_SurfaceLineEntity_NameFailureMechanismEntityId UNIQUE (Name,FailureMechanismEntityId) -) + SurfaceLineEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + FailureMechanismEntityId INTEGER NOT NULL, + Name VARCHAR(260) NOT NULL, + ReferenceLineIntersectionX REAL NULL, + ReferenceLineIntersectionY REAL NULL, + PointsXml TEXT NOT NULL COLLATE NOCASE, 'Order' + INT +( + 4 +) NOT NULL, + CONSTRAINT FK_SurfaceLineEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT UQ_SurfaceLineEntity_NameFailureMechanismEntityId UNIQUE (Name, FailureMechanismEntityId) + ) ; CREATE TABLE PipingCharacteristicPointEntity ( - PipingCharacteristicPointEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - SurfaceLineEntityId INTEGER NOT NULL, - Type TINYINT (1) NOT NULL, -- Enum: 1 = DikeToeAtRiver, 2 = DikeToeAtPolder, 3 = DitchDikeSide, 4 = BottomDitchDikeSide, 5 = BottomDitchPolderSide, 6 = DitchPolderSide - X REAL NULL, - Y REAL NULL, - Z REAL NULL, - CONSTRAINT FK_SurfaceLinePointEntity_SurfaceLineEntity FOREIGN KEY (SurfaceLineEntityId) REFERENCES SurfaceLineEntity (SurfaceLineEntityId) ON DELETE Cascade ON UPDATE Cascade + PipingCharacteristicPointEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + SurfaceLineEntityId INTEGER NOT NULL, + Type TINYINT (1) NOT NULL, -- Enum: 1 = DikeToeAtRiver, 2 = DikeToeAtPolder, 3 = DitchDikeSide, 4 = BottomDitchDikeSide, 5 = BottomDitchPolderSide, 6 = DitchPolderSide + X REAL NULL, + Y REAL NULL, + Z REAL NULL, + CONSTRAINT FK_SurfaceLinePointEntity_SurfaceLineEntity FOREIGN KEY (SurfaceLineEntityId) REFERENCES SurfaceLineEntity (SurfaceLineEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; CREATE TABLE WaterPressureAsphaltCoverFailureMechanismMetaEntity ( - WaterPressureAsphaltCoverFailureMechanismMetaEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - FailureMechanismEntityId INTEGER NOT NULL, - N REAL NOT NULL, - ApplyLengthEffectInSection TINYINT (1) NOT NULL, - CONSTRAINT FK_WaterPressureAsphaltCoverFailureMechanismMetaEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade + WaterPressureAsphaltCoverFailureMechanismMetaEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + FailureMechanismEntityId INTEGER NOT NULL, + N REAL NOT NULL, + ApplyLengthEffectInSection TINYINT (1) NOT NULL, + CONSTRAINT FK_WaterPressureAsphaltCoverFailureMechanismMetaEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; CREATE TABLE WaveImpactAsphaltCoverFailureMechanismMetaEntity ( - WaveImpactAsphaltCoverFailureMechanismMetaEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - FailureMechanismEntityId INTEGER NOT NULL, - ForeshoreProfileCollectionSourcePath TEXT NULL COLLATE NOCASE, - DeltaL REAL NOT NULL, - ApplyLengthEffectInSection TINYINT (1) NOT NULL, - CONSTRAINT FK_WaveImpactAsphaltCoverFailureMechanismMetaEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade + WaveImpactAsphaltCoverFailureMechanismMetaEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + FailureMechanismEntityId INTEGER NOT NULL, + ForeshoreProfileCollectionSourcePath TEXT NULL COLLATE NOCASE, + DeltaL REAL NOT NULL, + ApplyLengthEffectInSection TINYINT (1) NOT NULL, + CONSTRAINT FK_WaveImpactAsphaltCoverFailureMechanismMetaEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; CREATE TABLE AdoptableFailureMechanismSectionResultEntity ( - AdoptableFailureMechanismSectionResultEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - FailureMechanismSectionEntityId INTEGER NOT NULL, - IsRelevant TINYINT (1) NOT NULL, -- true or false - InitialFailureMechanismResultType TINYINT (1) NOT NULL, -- Enum: Adopt = 1 Manual = 2 NoFailureProbability = 3 - ManualInitialFailureMechanismResultSectionProbability REAL NULL, - FurtherAnalysisType TINYINT (1) NOT NULL, -- Enum: NotNecessary = 1 Necessary = 2 Executed = 3 - RefinedSectionProbability REAL NULL, - CONSTRAINT FK_AdoptableFailureMechanismSectionResultEntity_FailureMechanismSectionEntity FOREIGN KEY (FailureMechanismSectionEntityId) REFERENCES FailureMechanismSectionEntity (FailureMechanismSectionEntityId) ON DELETE Cascade ON UPDATE Cascade + AdoptableFailureMechanismSectionResultEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + FailureMechanismSectionEntityId INTEGER NOT NULL, + IsRelevant TINYINT (1) NOT NULL, -- true or false + InitialFailureMechanismResultType TINYINT (1) NOT NULL, -- Enum: Adopt = 1 Manual = 2 NoFailureProbability = 3 + ManualInitialFailureMechanismResultSectionProbability REAL NULL, + FurtherAnalysisType TINYINT (1) NOT NULL, -- Enum: NotNecessary = 1 Necessary = 2 Executed = 3 + RefinedSectionProbability REAL NULL, + CONSTRAINT FK_AdoptableFailureMechanismSectionResultEntity_FailureMechanismSectionEntity FOREIGN KEY (FailureMechanismSectionEntityId) REFERENCES FailureMechanismSectionEntity (FailureMechanismSectionEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; CREATE TABLE AdoptableWithProfileProbabilityFailureMechanismSectionResultEntity ( - AdoptableWithProfileProbabilityFailureMechanismSectionResultEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - FailureMechanismSectionEntityId INTEGER NOT NULL, - IsRelevant TINYINT (1) NOT NULL, -- true or false - InitialFailureMechanismResultType TINYINT (1) NOT NULL, -- Enum: Adopt = 1 Manual = 2 NoFailureProbability = 3 - ManualInitialFailureMechanismResultSectionProbability REAL NULL, - ManualInitialFailureMechanismResultProfileProbability REAL NULL, - FurtherAnalysisType TINYINT (1) NOT NULL, -- Enum: NotNecessary = 1 Necessary = 2 Executed = 3 - ProbabilityRefinementType TINYINT (1) NOT NULL, -- Enum: Profile = 1 Section = 2 Both = 3 - RefinedSectionProbability REAL NULL, - RefinedProfileProbability REAL NULL, - CONSTRAINT FK_AdoptableWithProfileProbabilityFailureMechanismSectionResultEntity_FailureMechanismSectionEntity FOREIGN KEY (FailureMechanismSectionEntityId) REFERENCES FailureMechanismSectionEntity (FailureMechanismSectionEntityId) ON DELETE Cascade ON UPDATE Cascade + AdoptableWithProfileProbabilityFailureMechanismSectionResultEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + FailureMechanismSectionEntityId INTEGER NOT NULL, + IsRelevant TINYINT (1) NOT NULL, -- true or false + InitialFailureMechanismResultType TINYINT (1) NOT NULL, -- Enum: Adopt = 1 Manual = 2 NoFailureProbability = 3 + ManualInitialFailureMechanismResultSectionProbability REAL NULL, + ManualInitialFailureMechanismResultProfileProbability REAL NULL, + FurtherAnalysisType TINYINT (1) NOT NULL, -- Enum: NotNecessary = 1 Necessary = 2 Executed = 3 + ProbabilityRefinementType TINYINT (1) NOT NULL, -- Enum: Profile = 1 Section = 2 Both = 3 + RefinedSectionProbability REAL NULL, + RefinedProfileProbability REAL NULL, + CONSTRAINT FK_AdoptableWithProfileProbabilityFailureMechanismSectionResultEntity_FailureMechanismSectionEntity FOREIGN KEY (FailureMechanismSectionEntityId) REFERENCES FailureMechanismSectionEntity (FailureMechanismSectionEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; CREATE TABLE BackgroundDataEntity ( - BackgroundDataEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - AssessmentSectionEntityId INTEGER NOT NULL, - Name TEXT NOT NULL COLLATE NOCASE, - IsVisible TINYINT (1) NOT NULL, -- true or false - Transparency REAL NOT NULL, - BackgroundDataType TINYINT (1) NOT NULL, -- Enum: 1 = Wmts, 2 = WellKnown - CONSTRAINT FK_BackgroundDataEntity_AssessmentSectionEntity FOREIGN KEY (AssessmentSectionEntityId) REFERENCES AssessmentSectionEntity (AssessmentSectionEntityId) ON DELETE Cascade ON UPDATE Cascade + BackgroundDataEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + AssessmentSectionEntityId INTEGER NOT NULL, + Name TEXT NOT NULL COLLATE NOCASE, + IsVisible TINYINT (1) NOT NULL, -- true or false + Transparency REAL NOT NULL, + BackgroundDataType TINYINT (1) NOT NULL, -- Enum: 1 = Wmts, 2 = WellKnown + CONSTRAINT FK_BackgroundDataEntity_AssessmentSectionEntity FOREIGN KEY (AssessmentSectionEntityId) REFERENCES AssessmentSectionEntity (AssessmentSectionEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; CREATE TABLE BackgroundDataMetaEntity ( - BackgroundDataMetaEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - BackgroundDataEntityId INTEGER NOT NULL, - 'Key' TEXT NOT NULL COLLATE NOCASE, - Value TEXT NOT NULL COLLATE NOCASE, - CONSTRAINT FK_BackgroundDataMetaEntity_BackgroundDataEntity FOREIGN KEY (BackgroundDataEntityId) REFERENCES BackgroundDataEntity (BackgroundDataEntityId) ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT U_BackgroundDataEntityId_Key UNIQUE (BackgroundDataEntityId,'Key') + BackgroundDataMetaEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + BackgroundDataEntityId INTEGER NOT NULL, 'Key' + TEXT + NOT + NULL + COLLATE + NOCASE, + Value TEXT NOT NULL COLLATE NOCASE, + CONSTRAINT FK_BackgroundDataMetaEntity_BackgroundDataEntity FOREIGN KEY (BackgroundDataEntityId) REFERENCES BackgroundDataEntity (BackgroundDataEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT U_BackgroundDataEntityId_Key UNIQUE (BackgroundDataEntityId, 'Key') ) ; CREATE TABLE ClosingStructureEntity ( - ClosingStructureEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - FailureMechanismEntityId INTEGER NOT NULL, - 'Order' INT (4) NOT NULL, - Name VARCHAR (260) NOT NULL, - Id VARCHAR (260) NOT NULL, - X REAL NULL, - Y REAL NULL, - StructureNormalOrientation REAL NULL, - StorageStructureAreaMean REAL NULL, - StorageStructureAreaCoefficientOfVariation REAL NULL, - AllowedLevelIncreaseStorageMean REAL NULL, - AllowedLevelIncreaseStorageStandardDeviation REAL NULL, - WidthFlowAperturesMean REAL NULL, - WidthFlowAperturesStandardDeviation REAL NULL, - LevelCrestStructureNotClosingMean REAL NULL, - LevelCrestStructureNotClosingStandardDeviation REAL NULL, - InsideWaterLevelMean REAL NULL, - InsideWaterLevelStandardDeviation REAL NULL, - ThresholdHeightOpenWeirMean REAL NULL, - ThresholdHeightOpenWeirStandardDeviation REAL NULL, - AreaFlowAperturesMean REAL NULL, - AreaFlowAperturesStandardDeviation REAL NULL, - CriticalOvertoppingDischargeMean REAL NULL, - CriticalOvertoppingDischargeCoefficientOfVariation REAL NULL, - FlowWidthAtBottomProtectionMean REAL NULL, - FlowWidthAtBottomProtectionStandardDeviation REAL NULL, - ProbabilityOpenStructureBeforeFlooding REAL NULL, - FailureProbabilityOpenStructure REAL NULL, - IdenticalApertures INT (4) NOT NULL, - FailureProbabilityReparation REAL NULL, - InflowModelType TINYINT (1) NOT NULL, -- Enum: 1 = VerticalWall, 2 = LowSill, 3 = FloodedCulvert - CONSTRAINT FK_ClosingStructureEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT U_Id_FailureMechanismEntityId UNIQUE (FailureMechanismEntityId,Id) -) + ClosingStructureEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + FailureMechanismEntityId INTEGER NOT NULL, 'Order' + INT +( + 4 +) NOT NULL, + Name VARCHAR(260) NOT NULL, + Id VARCHAR(260) NOT NULL, + X REAL NULL, + Y REAL NULL, + StructureNormalOrientation REAL NULL, + StorageStructureAreaMean REAL NULL, + StorageStructureAreaCoefficientOfVariation REAL NULL, + AllowedLevelIncreaseStorageMean REAL NULL, + AllowedLevelIncreaseStorageStandardDeviation REAL NULL, + WidthFlowAperturesMean REAL NULL, + WidthFlowAperturesStandardDeviation REAL NULL, + LevelCrestStructureNotClosingMean REAL NULL, + LevelCrestStructureNotClosingStandardDeviation REAL NULL, + InsideWaterLevelMean REAL NULL, + InsideWaterLevelStandardDeviation REAL NULL, + ThresholdHeightOpenWeirMean REAL NULL, + ThresholdHeightOpenWeirStandardDeviation REAL NULL, + AreaFlowAperturesMean REAL NULL, + AreaFlowAperturesStandardDeviation REAL NULL, + CriticalOvertoppingDischargeMean REAL NULL, + CriticalOvertoppingDischargeCoefficientOfVariation REAL NULL, + FlowWidthAtBottomProtectionMean REAL NULL, + FlowWidthAtBottomProtectionStandardDeviation REAL NULL, + ProbabilityOpenStructureBeforeFlooding REAL NULL, + FailureProbabilityOpenStructure REAL NULL, + IdenticalApertures INT (4) NOT NULL, + FailureProbabilityReparation REAL NULL, + InflowModelType TINYINT (1) NOT NULL, -- Enum: 1 = VerticalWall, 2 = LowSill, 3 = FloodedCulvert + CONSTRAINT FK_ClosingStructureEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT U_Id_FailureMechanismEntityId UNIQUE (FailureMechanismEntityId, Id) + ) ; CREATE TABLE ClosingStructuresCalculationEntity ( - ClosingStructuresCalculationEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - CalculationGroupEntityId INTEGER NOT NULL, - ForeshoreProfileEntityId INTEGER NULL, - HydraulicLocationEntityId INTEGER NULL, - ClosingStructureEntityId INTEGER NULL, - 'Order' INT (4) NOT NULL, - Name VARCHAR (255) NULL, - Comments TEXT NULL COLLATE NOCASE, - UseBreakWater TINYINT (1) NOT NULL, -- true or false - BreakWaterType TINYINT (1) NOT NULL, -- Enum: 1 = Wall, 2 = Caisson, 3 = Dam - BreakWaterHeight REAL NULL, - UseForeshore TINYINT (1) NOT NULL, -- true or false - Orientation REAL NULL, - StructureNormalOrientation REAL NULL, - StorageStructureAreaMean REAL NULL, - StorageStructureAreaCoefficientOfVariation REAL NULL, - AllowedLevelIncreaseStorageMean REAL NULL, - AllowedLevelIncreaseStorageStandardDeviation REAL NULL, - WidthFlowAperturesMean REAL NULL, - WidthFlowAperturesStandardDeviation REAL NULL, - LevelCrestStructureNotClosingMean REAL NULL, - LevelCrestStructureNotClosingStandardDeviation REAL NULL, - InsideWaterLevelMean REAL NULL, - InsideWaterLevelStandardDeviation REAL NULL, - ThresholdHeightOpenWeirMean REAL NULL, - ThresholdHeightOpenWeirStandardDeviation REAL NULL, - AreaFlowAperturesMean REAL NULL, - AreaFlowAperturesStandardDeviation REAL NULL, - CriticalOvertoppingDischargeMean REAL NULL, - CriticalOvertoppingDischargeCoefficientOfVariation REAL NULL, - FlowWidthAtBottomProtectionMean REAL NULL, - FlowWidthAtBottomProtectionStandardDeviation REAL NULL, - ProbabilityOpenStructureBeforeFlooding REAL NOT NULL, - FailureProbabilityOpenStructure REAL NOT NULL, - IdenticalApertures INT (4) NOT NULL, - FailureProbabilityReparation REAL NOT NULL, - InflowModelType TINYINT (1) NOT NULL, -- Enum: 1 = VerticalWall, 2 = LowSill, 3 = FloodedCulvert - FailureProbabilityStructureWithErosion REAL NOT NULL, - DeviationWaveDirection REAL NULL, - DrainCoefficientMean REAL NULL, - DrainCoefficientStandardDeviation REAL NULL, - ModelFactorSuperCriticalFlowMean REAL NULL, - StormDurationMean REAL NULL, - FactorStormDurationOpenStructure REAL NULL, - ShouldIllustrationPointsBeCalculated TINYINT (1) NOT NULL, -- true or false - RelevantForScenario TINYINT (1) NOT NULL, -- true or false - ScenarioContribution REAL NOT NULL, - CONSTRAINT FK_ClosingStructuresCalculationEntity_CalculationGroupEntity FOREIGN KEY (CalculationGroupEntityId) REFERENCES CalculationGroupEntity (CalculationGroupEntityId) ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT FK_ClosingStructuresCalculationEntity_ClosingStructureEntity FOREIGN KEY (ClosingStructureEntityId) REFERENCES ClosingStructureEntity (ClosingStructureEntityId) ON DELETE Set Null ON UPDATE Cascade, - CONSTRAINT FK_ClosingStructuresCalculationEntity_ForeshoreProfileEntity FOREIGN KEY (ForeshoreProfileEntityId) REFERENCES ForeshoreProfileEntity (ForeshoreProfileEntityId) ON DELETE Set Null ON UPDATE Cascade, - CONSTRAINT FK_ClosingStructuresCalculationEntity_HydraulicLocationEntity FOREIGN KEY (HydraulicLocationEntityId) REFERENCES HydraulicLocationEntity (HydraulicLocationEntityId) ON DELETE Set Null ON UPDATE Cascade -) + ClosingStructuresCalculationEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + CalculationGroupEntityId INTEGER NOT NULL, + ForeshoreProfileEntityId INTEGER NULL, + HydraulicLocationEntityId INTEGER NULL, + ClosingStructureEntityId INTEGER NULL, 'Order' + INT +( + 4 +) NOT NULL, + Name VARCHAR(255) NULL, + Comments TEXT NULL COLLATE NOCASE, + UseBreakWater TINYINT (1) NOT NULL, -- true or false + BreakWaterType TINYINT (1) NOT NULL, -- Enum: 1 = Wall, 2 = Caisson, 3 = Dam + BreakWaterHeight REAL NULL, + UseForeshore TINYINT (1) NOT NULL, -- true or false + Orientation REAL NULL, + StructureNormalOrientation REAL NULL, + StorageStructureAreaMean REAL NULL, + StorageStructureAreaCoefficientOfVariation REAL NULL, + AllowedLevelIncreaseStorageMean REAL NULL, + AllowedLevelIncreaseStorageStandardDeviation REAL NULL, + WidthFlowAperturesMean REAL NULL, + WidthFlowAperturesStandardDeviation REAL NULL, + LevelCrestStructureNotClosingMean REAL NULL, + LevelCrestStructureNotClosingStandardDeviation REAL NULL, + InsideWaterLevelMean REAL NULL, + InsideWaterLevelStandardDeviation REAL NULL, + ThresholdHeightOpenWeirMean REAL NULL, + ThresholdHeightOpenWeirStandardDeviation REAL NULL, + AreaFlowAperturesMean REAL NULL, + AreaFlowAperturesStandardDeviation REAL NULL, + CriticalOvertoppingDischargeMean REAL NULL, + CriticalOvertoppingDischargeCoefficientOfVariation REAL NULL, + FlowWidthAtBottomProtectionMean REAL NULL, + FlowWidthAtBottomProtectionStandardDeviation REAL NULL, + ProbabilityOpenStructureBeforeFlooding REAL NOT NULL, + FailureProbabilityOpenStructure REAL NOT NULL, + IdenticalApertures INT (4) NOT NULL, + FailureProbabilityReparation REAL NOT NULL, + InflowModelType TINYINT (1) NOT NULL, -- Enum: 1 = VerticalWall, 2 = LowSill, 3 = FloodedCulvert + FailureProbabilityStructureWithErosion REAL NOT NULL, + DeviationWaveDirection REAL NULL, + DrainCoefficientMean REAL NULL, + DrainCoefficientStandardDeviation REAL NULL, + ModelFactorSuperCriticalFlowMean REAL NULL, + StormDurationMean REAL NULL, + FactorStormDurationOpenStructure REAL NULL, + ShouldIllustrationPointsBeCalculated TINYINT (1) NOT NULL, -- true or false + RelevantForScenario TINYINT (1) NOT NULL, -- true or false + ScenarioContribution REAL NOT NULL, + CONSTRAINT FK_ClosingStructuresCalculationEntity_CalculationGroupEntity FOREIGN KEY (CalculationGroupEntityId) REFERENCES CalculationGroupEntity (CalculationGroupEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT FK_ClosingStructuresCalculationEntity_ClosingStructureEntity FOREIGN KEY (ClosingStructureEntityId) REFERENCES ClosingStructureEntity (ClosingStructureEntityId) ON DELETE Set Null ON UPDATE Cascade, + CONSTRAINT FK_ClosingStructuresCalculationEntity_ForeshoreProfileEntity FOREIGN KEY (ForeshoreProfileEntityId) REFERENCES ForeshoreProfileEntity (ForeshoreProfileEntityId) ON DELETE Set Null ON UPDATE Cascade, + CONSTRAINT FK_ClosingStructuresCalculationEntity_HydraulicLocationEntity FOREIGN KEY (HydraulicLocationEntityId) REFERENCES HydraulicLocationEntity (HydraulicLocationEntityId) ON DELETE Set Null ON UPDATE Cascade + ) ; CREATE TABLE ClosingStructuresOutputEntity ( - ClosingStructuresOutputEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - ClosingStructuresCalculationEntityId INTEGER NOT NULL, - GeneralResultFaultTreeIllustrationPointEntityId INTEGER NULL, - Reliability REAL NULL, - CONSTRAINT FK_ClosingStructuresOutputEntity_ClosingStructuresCalculationEntity FOREIGN KEY (ClosingStructuresCalculationEntityId) REFERENCES ClosingStructuresCalculationEntity (ClosingStructuresCalculationEntityId) ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT FK_ClosingStructuresOutputEntity_GeneralResultFaultTreeIllustrationPointEntity FOREIGN KEY (GeneralResultFaultTreeIllustrationPointEntityId) REFERENCES GeneralResultFaultTreeIllustrationPointEntity (GeneralResultFaultTreeIllustrationPointEntityId) ON DELETE Set Null ON UPDATE Cascade, - CONSTRAINT U_ClosingStructuresCalculationEntity UNIQUE (ClosingStructuresCalculationEntityId) + ClosingStructuresOutputEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + ClosingStructuresCalculationEntityId INTEGER NOT NULL, + GeneralResultFaultTreeIllustrationPointEntityId INTEGER NULL, + Reliability REAL NULL, + CONSTRAINT FK_ClosingStructuresOutputEntity_ClosingStructuresCalculationEntity FOREIGN KEY (ClosingStructuresCalculationEntityId) REFERENCES ClosingStructuresCalculationEntity (ClosingStructuresCalculationEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT FK_ClosingStructuresOutputEntity_GeneralResultFaultTreeIllustrationPointEntity FOREIGN KEY (GeneralResultFaultTreeIllustrationPointEntityId) REFERENCES GeneralResultFaultTreeIllustrationPointEntity (GeneralResultFaultTreeIllustrationPointEntityId) ON DELETE Set Null ON UPDATE Cascade, + CONSTRAINT U_ClosingStructuresCalculationEntity UNIQUE (ClosingStructuresCalculationEntityId) ) ; CREATE TABLE DikeProfileEntity ( - DikeProfileEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - FailureMechanismEntityId INTEGER NOT NULL, - Id VARCHAR (260) NOT NULL, - Name VARCHAR (260) NOT NULL, - Orientation REAL NULL, - BreakWaterType TINYINT (1) NULL, -- Enum: 1 = Wall 2 = Caisson 3 = Dam - BreakWaterHeight REAL NULL, - ForeshoreXml TEXT NOT NULL COLLATE NOCASE, - DikeGeometryXml TEXT NOT NULL COLLATE NOCASE, - DikeHeight REAL NULL, - X REAL NULL, - Y REAL NULL, - X0 REAL NULL, - 'Order' INT (4) NOT NULL, - CONSTRAINT FK_DikeProfileEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT UQ_DikeProfileEntity_IdFailureMechanismEntityId UNIQUE (Id,FailureMechanismEntityId) -) + DikeProfileEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + FailureMechanismEntityId INTEGER NOT NULL, + Id VARCHAR(260) NOT NULL, + Name VARCHAR(260) NOT NULL, + Orientation REAL NULL, + BreakWaterType TINYINT (1) NULL, -- Enum: 1 = Wall 2 = Caisson 3 = Dam + BreakWaterHeight REAL NULL, + ForeshoreXml TEXT NOT NULL COLLATE NOCASE, + DikeGeometryXml TEXT NOT NULL COLLATE NOCASE, + DikeHeight REAL NULL, + X REAL NULL, + Y REAL NULL, + X0 REAL NULL, 'Order' + INT +( + 4 +) NOT NULL, + CONSTRAINT FK_DikeProfileEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT UQ_DikeProfileEntity_IdFailureMechanismEntityId UNIQUE (Id, FailureMechanismEntityId) + ) ; CREATE TABLE DuneErosionFailureMechanismMetaEntity ( - DuneErosionFailureMechanismMetaEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - FailureMechanismEntityId INTEGER NOT NULL, - N REAL NOT NULL, - CONSTRAINT FK_DuneErosionFailureMechanismMetaEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade + DuneErosionFailureMechanismMetaEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + FailureMechanismEntityId INTEGER NOT NULL, + N REAL NOT NULL, + CONSTRAINT FK_DuneErosionFailureMechanismMetaEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; CREATE TABLE DuneLocationCalculationEntity ( - DuneLocationCalculationEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - DuneLocationEntityId INTEGER NOT NULL, - DuneLocationCalculationForTargetProbabilityCollectionEntityId INTEGER NOT NULL, - CONSTRAINT FK_DuneLocationCalculationEntity_DuneLocationCalculationCollectionEntity FOREIGN KEY (DuneLocationCalculationForTargetProbabilityCollectionEntityId) REFERENCES DuneLocationCalculationForTargetProbabilityCollectionEntity (DuneLocationCalculationCollectionEntityId) ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT FK_DuneLocationCalculationEntity_DuneLocationEntity FOREIGN KEY (DuneLocationEntityId) REFERENCES DuneLocationEntity (DuneLocationEntityId) ON DELETE Cascade ON UPDATE Cascade + DuneLocationCalculationEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + DuneLocationEntityId INTEGER NOT NULL, + DuneLocationCalculationForTargetProbabilityCollectionEntityId INTEGER NOT NULL, + CONSTRAINT FK_DuneLocationCalculationEntity_DuneLocationCalculationCollectionEntity FOREIGN KEY (DuneLocationCalculationForTargetProbabilityCollectionEntityId) REFERENCES DuneLocationCalculationForTargetProbabilityCollectionEntity (DuneLocationCalculationCollectionEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT FK_DuneLocationCalculationEntity_DuneLocationEntity FOREIGN KEY (DuneLocationEntityId) REFERENCES DuneLocationEntity (DuneLocationEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; CREATE TABLE DuneLocationCalculationForTargetProbabilityCollectionEntity ( - DuneLocationCalculationCollectionEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - DuneErosionFailureMechanismMetaEntityId INTEGER NOT NULL, - 'Order' INT (4) NOT NULL, - TargetProbability REAL NOT NULL, - CONSTRAINT FK_DuneLocationCalculationForTargetProbabilityCollectionEntity_DuneErosionFailureMechanismMetaEntity FOREIGN KEY (DuneErosionFailureMechanismMetaEntityId) REFERENCES DuneErosionFailureMechanismMetaEntity (DuneErosionFailureMechanismMetaEntityId) ON DELETE Cascade ON UPDATE Cascade -) + DuneLocationCalculationCollectionEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + DuneErosionFailureMechanismMetaEntityId INTEGER NOT NULL, 'Order' + INT +( + 4 +) NOT NULL, + TargetProbability REAL NOT NULL, + CONSTRAINT FK_DuneLocationCalculationForTargetProbabilityCollectionEntity_DuneErosionFailureMechanismMetaEntity FOREIGN KEY (DuneErosionFailureMechanismMetaEntityId) REFERENCES DuneErosionFailureMechanismMetaEntity (DuneErosionFailureMechanismMetaEntityId) ON DELETE Cascade ON UPDATE Cascade + ) ; CREATE TABLE DuneLocationCalculationOutputEntity ( - DuneLocationCalculationOutputEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - DuneLocationCalculationEntityId INTEGER NOT NULL, - WaterLevel REAL NULL, - WaveHeight REAL NULL, - WavePeriod REAL NULL, - MeanTidalAmplitude REAL NULL, - WaveDirectionalSpread REAL NULL, - TideSurgePhaseDifference REAL NULL, - TargetProbability REAL NULL, - TargetReliability REAL NULL, - CalculatedProbability REAL NULL, - CalculatedReliability REAL NULL, - CalculationConvergence TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated, 2 = CalculatedNotConverged, 3 = CalculatedConverged - CONSTRAINT FK_DuneLocationCalculationOutputEntity_DuneLocationCalculationEntity FOREIGN KEY (DuneLocationCalculationEntityId) REFERENCES DuneLocationCalculationEntity (DuneLocationCalculationEntityId) ON DELETE Cascade ON UPDATE Cascade + DuneLocationCalculationOutputEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + DuneLocationCalculationEntityId INTEGER NOT NULL, + WaterLevel REAL NULL, + WaveHeight REAL NULL, + WavePeriod REAL NULL, + MeanTidalAmplitude REAL NULL, + WaveDirectionalSpread REAL NULL, + TideSurgePhaseDifference REAL NULL, + TargetProbability REAL NULL, + TargetReliability REAL NULL, + CalculatedProbability REAL NULL, + CalculatedReliability REAL NULL, + CalculationConvergence TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated, 2 = CalculatedNotConverged, 3 = CalculatedConverged + CONSTRAINT FK_DuneLocationCalculationOutputEntity_DuneLocationCalculationEntity FOREIGN KEY (DuneLocationCalculationEntityId) REFERENCES DuneLocationCalculationEntity (DuneLocationCalculationEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; CREATE TABLE DuneLocationEntity ( - DuneLocationEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - HydraulicLocationEntityId INTEGER NOT NULL, - FailureMechanismEntityId INTEGER NOT NULL, - Name VARCHAR (260) NOT NULL, - CoastalAreaId INT (4) NOT NULL, - 'Offset' REAL NULL, - 'Order' INT (4) NOT NULL, - CONSTRAINT FK_DuneLocationEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT FK_DuneLocationEntity_HydraulicLocationEntity FOREIGN KEY (HydraulicLocationEntityId) REFERENCES HydraulicLocationEntity (HydraulicLocationEntityId) ON DELETE Cascade ON UPDATE Cascade -) + DuneLocationEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + HydraulicLocationEntityId INTEGER NOT NULL, + FailureMechanismEntityId INTEGER NOT NULL, + Name VARCHAR(260) NOT NULL, + CoastalAreaId INT (4) NOT NULL, 'Offset' + REAL + NULL, 'Order' + INT +( + 4 +) NOT NULL, + CONSTRAINT FK_DuneLocationEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT FK_DuneLocationEntity_HydraulicLocationEntity FOREIGN KEY (HydraulicLocationEntityId) REFERENCES HydraulicLocationEntity (HydraulicLocationEntityId) ON DELETE Cascade ON UPDATE Cascade + ) ; CREATE TABLE FailureMechanismFailureMechanismSectionEntity ( - FailureMechanismEntityId INTEGER NOT NULL, - FailureMechanismSectionEntityId INTEGER NOT NULL, - CONSTRAINT PK_FailureMechanismFailureMechanismSectionEntity PRIMARY KEY (FailureMechanismSectionEntityId,FailureMechanismEntityId), - CONSTRAINT FK_FailureMechanismFailureMechanismSectionEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT FK_FailureMechanismFailureMechanismSectionEntity_FailureMechanismSectionEntity FOREIGN KEY (FailureMechanismSectionEntityId) REFERENCES FailureMechanismSectionEntity (FailureMechanismSectionEntityId) ON DELETE Cascade ON UPDATE Cascade + FailureMechanismEntityId INTEGER NOT NULL, + FailureMechanismSectionEntityId INTEGER NOT NULL, + CONSTRAINT PK_FailureMechanismFailureMechanismSectionEntity PRIMARY KEY (FailureMechanismSectionEntityId, FailureMechanismEntityId), + CONSTRAINT FK_FailureMechanismFailureMechanismSectionEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT FK_FailureMechanismFailureMechanismSectionEntity_FailureMechanismSectionEntity FOREIGN KEY (FailureMechanismSectionEntityId) REFERENCES FailureMechanismSectionEntity (FailureMechanismSectionEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; CREATE TABLE FaultTreeIllustrationPointEntity ( - FaultTreeIllustrationPointEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - ParentFaultTreeIllustrationPointEntityId INTEGER NULL, - Name TEXT NOT NULL COLLATE NOCASE, - Beta REAL NOT NULL, - CombinationType TINYINT (1) NOT NULL, -- Enum: 1 = Or, 2 = And - 'Order' INT (4) NOT NULL, - CONSTRAINT FK_FaultTreeIllustrationPoint_FaultTreeIllustrationPoint FOREIGN KEY (ParentFaultTreeIllustrationPointEntityId) REFERENCES FaultTreeIllustrationPointEntity (FaultTreeIllustrationPointEntityId) ON DELETE Cascade ON UPDATE Cascade -) + FaultTreeIllustrationPointEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + ParentFaultTreeIllustrationPointEntityId INTEGER NULL, + Name TEXT NOT NULL COLLATE NOCASE, + Beta REAL NOT NULL, + CombinationType TINYINT (1) NOT NULL, -- Enum: 1 = Or, 2 = And + 'Order' + INT +( + 4 +) NOT NULL, + CONSTRAINT FK_FaultTreeIllustrationPoint_FaultTreeIllustrationPoint FOREIGN KEY (ParentFaultTreeIllustrationPointEntityId) REFERENCES FaultTreeIllustrationPointEntity (FaultTreeIllustrationPointEntityId) ON DELETE Cascade ON UPDATE Cascade + ) ; CREATE TABLE FaultTreeIllustrationPointStochastEntity ( - FaultTreeIllustrationPointEntityId INTEGER NOT NULL, - StochastEntityId INTEGER NOT NULL, - CONSTRAINT PK_FaultTreeIllustrationPointStochastEntity PRIMARY KEY (FaultTreeIllustrationPointEntityId,StochastEntityId), - CONSTRAINT FK_FaultTreeIllustrationPointStochastEntity_FaultTreeIllustrationPoint FOREIGN KEY (FaultTreeIllustrationPointEntityId) REFERENCES FaultTreeIllustrationPointEntity (FaultTreeIllustrationPointEntityId) ON DELETE No Action ON UPDATE No Action, - CONSTRAINT FK_FaultTreeIllustrationPointStochastEntity_StochastEntity FOREIGN KEY (StochastEntityId) REFERENCES StochastEntity (StochastEntityId) ON DELETE Cascade ON UPDATE Cascade + FaultTreeIllustrationPointEntityId INTEGER NOT NULL, + StochastEntityId INTEGER NOT NULL, + CONSTRAINT PK_FaultTreeIllustrationPointStochastEntity PRIMARY KEY (FaultTreeIllustrationPointEntityId, StochastEntityId), + CONSTRAINT FK_FaultTreeIllustrationPointStochastEntity_FaultTreeIllustrationPoint FOREIGN KEY (FaultTreeIllustrationPointEntityId) REFERENCES FaultTreeIllustrationPointEntity (FaultTreeIllustrationPointEntityId) ON DELETE No Action ON UPDATE No Action, + CONSTRAINT FK_FaultTreeIllustrationPointStochastEntity_StochastEntity FOREIGN KEY (StochastEntityId) REFERENCES StochastEntity (StochastEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; CREATE TABLE FaultTreeSubmechanismIllustrationPointEntity ( - SubMechanismIllustrationPointEntityId INTEGER NOT NULL, - FaultTreeIllustrationPointEntityId INTEGER NOT NULL, - CONSTRAINT PK_FaultTreeSubMechanismIllustrationPointEntityId PRIMARY KEY (SubMechanismIllustrationPointEntityId,FaultTreeIllustrationPointEntityId), - CONSTRAINT FK_FaultTreeIllustrationPointEntity_FaultTreeIllustrationPointEntity FOREIGN KEY (FaultTreeIllustrationPointEntityId) REFERENCES FaultTreeIllustrationPointEntity (FaultTreeIllustrationPointEntityId) ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT FK_FaultTreeIllustrationPointEntity_SubMechanismIllustrationPointEntity FOREIGN KEY (SubMechanismIllustrationPointEntityId) REFERENCES SubMechanismIllustrationPointEntity (SubMechanismIllustrationPointEntityId) ON DELETE Cascade ON UPDATE Cascade + SubMechanismIllustrationPointEntityId INTEGER NOT NULL, + FaultTreeIllustrationPointEntityId INTEGER NOT NULL, + CONSTRAINT PK_FaultTreeSubMechanismIllustrationPointEntityId PRIMARY KEY (SubMechanismIllustrationPointEntityId, + FaultTreeIllustrationPointEntityId), + CONSTRAINT FK_FaultTreeIllustrationPointEntity_FaultTreeIllustrationPointEntity FOREIGN KEY (FaultTreeIllustrationPointEntityId) REFERENCES FaultTreeIllustrationPointEntity (FaultTreeIllustrationPointEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT FK_FaultTreeIllustrationPointEntity_SubMechanismIllustrationPointEntity FOREIGN KEY (SubMechanismIllustrationPointEntityId) REFERENCES SubMechanismIllustrationPointEntity (SubMechanismIllustrationPointEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; CREATE TABLE ForeshoreProfileEntity ( - ForeshoreProfileEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - FailureMechanismEntityId INTEGER NOT NULL, - Id VARCHAR (260) NOT NULL, - Name VARCHAR (260) NOT NULL, - Orientation REAL NULL, - BreakWaterType TINYINT (1) NULL, -- Enum: 1 = Wall, 2 = Caisson, 3 = Dam - BreakWaterHeight REAL NULL, - GeometryXml TEXT NOT NULL COLLATE NOCASE, - X REAL NULL, - Y REAL NULL, - X0 REAL NULL, - 'Order' INT (4) NOT NULL, - CONSTRAINT FK_ForeshoreProfileEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT UQ_ForeshoreProfileEntity_IdFailureMechanismEntityId UNIQUE (Id,FailureMechanismEntityId) -) + ForeshoreProfileEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + FailureMechanismEntityId INTEGER NOT NULL, + Id VARCHAR(260) NOT NULL, + Name VARCHAR(260) NOT NULL, + Orientation REAL NULL, + BreakWaterType TINYINT (1) NULL, -- Enum: 1 = Wall, 2 = Caisson, 3 = Dam + BreakWaterHeight REAL NULL, + GeometryXml TEXT NOT NULL COLLATE NOCASE, + X REAL NULL, + Y REAL NULL, + X0 REAL NULL, 'Order' + INT +( + 4 +) NOT NULL, + CONSTRAINT FK_ForeshoreProfileEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT UQ_ForeshoreProfileEntity_IdFailureMechanismEntityId UNIQUE (Id, FailureMechanismEntityId) + ) ; CREATE TABLE GeneralResultFaultTreeIllustrationPointEntity ( - GeneralResultFaultTreeIllustrationPointEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - GoverningWindDirectionName TEXT NOT NULL COLLATE NOCASE, - GoverningWindDirectionAngle REAL NOT NULL + GeneralResultFaultTreeIllustrationPointEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + GoverningWindDirectionName TEXT NOT NULL COLLATE NOCASE, + GoverningWindDirectionAngle REAL NOT NULL ) ; CREATE TABLE GeneralResultFaultTreeIllustrationPointStochastEntity ( - GeneralResultFaultTreeIllustrationPointEntityId INTEGER NOT NULL, - StochastEntityId INTEGER NOT NULL, - CONSTRAINT PK_GeneralResultFaultTreeIllustrationPointStochastEntity PRIMARY KEY (GeneralResultFaultTreeIllustrationPointEntityId,StochastEntityId), - CONSTRAINT FK_GeneralResultFaultTreeIllustrationPointStochastEntity_GeneralResultFaultTreeIllustrationPointEntity FOREIGN KEY (GeneralResultFaultTreeIllustrationPointEntityId) REFERENCES GeneralResultFaultTreeIllustrationPointEntity (GeneralResultFaultTreeIllustrationPointEntityId) ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT FK_GeneralResultFaultTreeIllustrationPointStochastEntity_StochastEntity FOREIGN KEY (StochastEntityId) REFERENCES StochastEntity (StochastEntityId) ON DELETE Cascade ON UPDATE Cascade + GeneralResultFaultTreeIllustrationPointEntityId INTEGER NOT NULL, + StochastEntityId INTEGER NOT NULL, + CONSTRAINT PK_GeneralResultFaultTreeIllustrationPointStochastEntity PRIMARY KEY (GeneralResultFaultTreeIllustrationPointEntityId, StochastEntityId), + CONSTRAINT FK_GeneralResultFaultTreeIllustrationPointStochastEntity_GeneralResultFaultTreeIllustrationPointEntity FOREIGN KEY (GeneralResultFaultTreeIllustrationPointEntityId) REFERENCES GeneralResultFaultTreeIllustrationPointEntity (GeneralResultFaultTreeIllustrationPointEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT FK_GeneralResultFaultTreeIllustrationPointStochastEntity_StochastEntity FOREIGN KEY (StochastEntityId) REFERENCES StochastEntity (StochastEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; CREATE TABLE GeneralResultSubMechanismIllustrationPointEntity ( - GeneralResultSubMechanismIllustrationPointEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - GoverningWindDirectionName TEXT NOT NULL COLLATE NOCASE, - GoverningWindDirectionAngle REAL NOT NULL + GeneralResultSubMechanismIllustrationPointEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + GoverningWindDirectionName TEXT NOT NULL COLLATE NOCASE, + GoverningWindDirectionAngle REAL NOT NULL ) ; CREATE TABLE GeneralResultSubMechanismIllustrationPointStochastEntity ( - GeneralResultSubMechanismIllustrationPointEntityId INTEGER NOT NULL, - StochastEntityId INTEGER NOT NULL, - CONSTRAINT PK_GeneralResultSubMechanismIllustrationPointStochastEntity PRIMARY KEY (GeneralResultSubMechanismIllustrationPointEntityId,StochastEntityId), - CONSTRAINT FK_GeneralResultSubMechanisIllustrationPointStochastEntity_GeneralResultSubMechanismIllustrationPointEntity FOREIGN KEY (GeneralResultSubMechanismIllustrationPointEntityId) REFERENCES GeneralResultSubMechanismIllustrationPointEntity (GeneralResultSubMechanismIllustrationPointEntityId) ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT FK_GeneralResultSubMechanismIllustrationPointStochastEntity_StochastEntity FOREIGN KEY (StochastEntityId) REFERENCES StochastEntity (StochastEntityId) ON DELETE Cascade ON UPDATE Cascade + GeneralResultSubMechanismIllustrationPointEntityId INTEGER NOT NULL, + StochastEntityId INTEGER NOT NULL, + CONSTRAINT PK_GeneralResultSubMechanismIllustrationPointStochastEntity PRIMARY KEY (GeneralResultSubMechanismIllustrationPointEntityId, StochastEntityId), + CONSTRAINT FK_GeneralResultSubMechanisIllustrationPointStochastEntity_GeneralResultSubMechanismIllustrationPointEntity FOREIGN KEY (GeneralResultSubMechanismIllustrationPointEntityId) REFERENCES GeneralResultSubMechanismIllustrationPointEntity (GeneralResultSubMechanismIllustrationPointEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT FK_GeneralResultSubMechanismIllustrationPointStochastEntity_StochastEntity FOREIGN KEY (StochastEntityId) REFERENCES StochastEntity (StochastEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; CREATE TABLE GrassCoverErosionInwardsDikeHeightOutputEntity ( - GrassCoverErosionInwardsDikeHeightOutputEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - GrassCoverErosionInwardsOutputEntityId INTEGER NOT NULL, - GeneralResultFaultTreeIllustrationPointEntityId INTEGER NULL, - DikeHeight REAL NULL, - TargetProbability REAL NULL, - TargetReliability REAL NULL, - CalculatedProbability REAL NULL, - CalculatedReliability REAL NULL, - CalculationConvergence TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated, 2 = CalculationNotConverged, 3 = CalculationConverged - CONSTRAINT FK_GrassCoverErosionInwardsDikeHeightOutputEntity_GeneralResultFaultTreeIllustrationPointEntity FOREIGN KEY (GeneralResultFaultTreeIllustrationPointEntityId) REFERENCES GeneralResultFaultTreeIllustrationPointEntity (GeneralResultFaultTreeIllustrationPointEntityId) ON DELETE Set Null ON UPDATE Cascade, - CONSTRAINT FK_GrassCoverErosionInwardsDikeHeightOutputEntity_GrassCoverErosionInwardsOutputEntity FOREIGN KEY (GrassCoverErosionInwardsOutputEntityId) REFERENCES GrassCoverErosionInwardsOutputEntity (GrassCoverErosionInwardsOutputEntityId) ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT U_GrassCoverErosionInwardsOutputEntity UNIQUE (GrassCoverErosionInwardsOutputEntityId) + GrassCoverErosionInwardsDikeHeightOutputEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + GrassCoverErosionInwardsOutputEntityId INTEGER NOT NULL, + GeneralResultFaultTreeIllustrationPointEntityId INTEGER NULL, + DikeHeight REAL NULL, + TargetProbability REAL NULL, + TargetReliability REAL NULL, + CalculatedProbability REAL NULL, + CalculatedReliability REAL NULL, + CalculationConvergence TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated, 2 = CalculationNotConverged, 3 = CalculationConverged + CONSTRAINT FK_GrassCoverErosionInwardsDikeHeightOutputEntity_GeneralResultFaultTreeIllustrationPointEntity FOREIGN KEY (GeneralResultFaultTreeIllustrationPointEntityId) REFERENCES GeneralResultFaultTreeIllustrationPointEntity (GeneralResultFaultTreeIllustrationPointEntityId) ON DELETE Set Null ON UPDATE Cascade, + CONSTRAINT FK_GrassCoverErosionInwardsDikeHeightOutputEntity_GrassCoverErosionInwardsOutputEntity FOREIGN KEY (GrassCoverErosionInwardsOutputEntityId) REFERENCES GrassCoverErosionInwardsOutputEntity (GrassCoverErosionInwardsOutputEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT U_GrassCoverErosionInwardsOutputEntity UNIQUE (GrassCoverErosionInwardsOutputEntityId) ) ; CREATE TABLE GrassCoverErosionInwardsOutputEntity ( - GrassCoverErosionInwardsOutputEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - GrassCoverErosionInwardsCalculationEntityId INTEGER NOT NULL, - GeneralResultFaultTreeIllustrationPointEntityId INTEGER NULL, - 'Order' INT (4) NOT NULL, - IsOvertoppingDominant TINYINT (1) NOT NULL, -- true or false - WaveHeight REAL NULL, - Reliability REAL NULL, - CONSTRAINT FK_GrassCoverErosionInwardsOutputEntity_GeneralResultFaultTreeIllustrationPointEntity FOREIGN KEY (GeneralResultFaultTreeIllustrationPointEntityId) REFERENCES GeneralResultFaultTreeIllustrationPointEntity (GeneralResultFaultTreeIllustrationPointEntityId) ON DELETE Set Null ON UPDATE Cascade, - CONSTRAINT FK_GrassCoverErosionInwardsOutputEntity_GrassCoverErosionInwardsCalculationEntity FOREIGN KEY (GrassCoverErosionInwardsCalculationEntityId) REFERENCES GrassCoverErosionInwardsCalculationEntity (GrassCoverErosionInwardsCalculationEntityId) ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT U_GrassCoverErosionInwardsCalculationEntity UNIQUE (GrassCoverErosionInwardsCalculationEntityId) -) + GrassCoverErosionInwardsOutputEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + GrassCoverErosionInwardsCalculationEntityId INTEGER NOT NULL, + GeneralResultFaultTreeIllustrationPointEntityId INTEGER NULL, 'Order' + INT +( + 4 +) NOT NULL, + IsOvertoppingDominant TINYINT (1) NOT NULL, -- true or false + WaveHeight REAL NULL, + Reliability REAL NULL, + CONSTRAINT FK_GrassCoverErosionInwardsOutputEntity_GeneralResultFaultTreeIllustrationPointEntity FOREIGN KEY (GeneralResultFaultTreeIllustrationPointEntityId) REFERENCES GeneralResultFaultTreeIllustrationPointEntity (GeneralResultFaultTreeIllustrationPointEntityId) ON DELETE Set Null ON UPDATE Cascade, + CONSTRAINT FK_GrassCoverErosionInwardsOutputEntity_GrassCoverErosionInwardsCalculationEntity FOREIGN KEY (GrassCoverErosionInwardsCalculationEntityId) REFERENCES GrassCoverErosionInwardsCalculationEntity (GrassCoverErosionInwardsCalculationEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT U_GrassCoverErosionInwardsCalculationEntity UNIQUE (GrassCoverErosionInwardsCalculationEntityId) + ) ; CREATE TABLE GrassCoverErosionInwardsOvertoppingRateOutputEntity ( - GrassCoverErosionInwardsOvertoppingRateOutputEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - GrassCoverErosionInwardsOutputEntityId INTEGER NOT NULL, - GeneralResultFaultTreeIllustrationPointEntityId INTEGER NULL, - OvertoppingRate REAL NULL, - TargetProbability REAL NULL, - TargetReliability REAL NULL, - CalculatedProbability REAL NULL, - CalculatedReliability REAL NULL, - CalculationConvergence TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated, 2 = CalculationNotConverged, 3 = CalculationConverged - CONSTRAINT FK_GrassCoverErosionInwardsOvertoppingRateOutputEntity_GeneralResultFaultTreeIllustrationPointEntity FOREIGN KEY (GeneralResultFaultTreeIllustrationPointEntityId) REFERENCES GeneralResultFaultTreeIllustrationPointEntity (GeneralResultFaultTreeIllustrationPointEntityId) ON DELETE Set Null ON UPDATE Cascade, - CONSTRAINT FK_GrassCoverErosionInwardsOvertoppingRateOutputEntity_GrassCoverErosionInwardsOutputEntity FOREIGN KEY (GrassCoverErosionInwardsOutputEntityId) REFERENCES GrassCoverErosionInwardsOutputEntity (GrassCoverErosionInwardsOutputEntityId) ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT U_GrassCoverErosionInwardsOutputEntity UNIQUE (GrassCoverErosionInwardsOutputEntityId) + GrassCoverErosionInwardsOvertoppingRateOutputEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + GrassCoverErosionInwardsOutputEntityId INTEGER NOT NULL, + GeneralResultFaultTreeIllustrationPointEntityId INTEGER NULL, + OvertoppingRate REAL NULL, + TargetProbability REAL NULL, + TargetReliability REAL NULL, + CalculatedProbability REAL NULL, + CalculatedReliability REAL NULL, + CalculationConvergence TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated, 2 = CalculationNotConverged, 3 = CalculationConverged + CONSTRAINT FK_GrassCoverErosionInwardsOvertoppingRateOutputEntity_GeneralResultFaultTreeIllustrationPointEntity FOREIGN KEY (GeneralResultFaultTreeIllustrationPointEntityId) REFERENCES GeneralResultFaultTreeIllustrationPointEntity (GeneralResultFaultTreeIllustrationPointEntityId) ON DELETE Set Null ON UPDATE Cascade, + CONSTRAINT FK_GrassCoverErosionInwardsOvertoppingRateOutputEntity_GrassCoverErosionInwardsOutputEntity FOREIGN KEY (GrassCoverErosionInwardsOutputEntityId) REFERENCES GrassCoverErosionInwardsOutputEntity (GrassCoverErosionInwardsOutputEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT U_GrassCoverErosionInwardsOutputEntity UNIQUE (GrassCoverErosionInwardsOutputEntityId) ) ; CREATE TABLE GrassCoverErosionOutwardsWaveConditionsCalculationEntity ( - GrassCoverErosionOutwardsWaveConditionsCalculationEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - CalculationGroupEntityId INTEGER NOT NULL, - ForeshoreProfileEntityId INTEGER NULL, - HydraulicLocationEntityId INTEGER NULL, - HydraulicLocationCalculationForTargetProbabilityCollectionEntityId INTEGER NULL, - 'Order' INT (4) NOT NULL, - Name VARCHAR (260) NULL, - Comments TEXT NULL COLLATE NOCASE, - UseBreakWater TINYINT (1) NOT NULL, -- true or false - BreakWaterType TINYINT (1) NOT NULL, -- Enum: 1 = Wall, 2 = Caisson, 3 = Dam - BreakWaterHeight REAL NULL, - UseForeshore TINYINT (1) NOT NULL, -- true or false - Orientation REAL NULL, - UpperBoundaryRevetment REAL NULL, - LowerBoundaryRevetment REAL NULL, - UpperBoundaryWaterLevels REAL NULL, - LowerBoundaryWaterLevels REAL NULL, - StepSize TINYINT (1) NOT NULL, -- Enum: 1 = 0.5, 2 = 1.0, 3 = 2.0 - CalculationType TINYINT (1) NOT NULL, -- Enum: 1 = WaveRunUp 2 = WaveImpact 3 = WaveRunUpAndWaveImpact 4 = WaveImpactWithWaveDirection 5 = WaveRunUpAndWaveImpactWithWaveDirection 6 = All - WaterLevelType TINYINT (1) NOT NULL, -- Enum: 1 = None, 2 = MaximumAllowableFloodingProbability, 3 = SignalFloodingProbability, 4 = UserDefinedTargetProbability - CONSTRAINT FK_GrassCoverErosionOutwardsWaveConditionsCalculationEntity_CalculationGroupEntity FOREIGN KEY (CalculationGroupEntityId) REFERENCES CalculationGroupEntity (CalculationGroupEntityId) ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT FK_GrassCoverErosionOutwardsWaveConditionsCalculationEntity_ForeshoreProfileEntity FOREIGN KEY (ForeshoreProfileEntityId) REFERENCES ForeshoreProfileEntity (ForeshoreProfileEntityId) ON DELETE Set Null ON UPDATE Cascade, - CONSTRAINT FK_GrassCoverErosionOutwardsWaveConditionsCalculationEntity_HydraulicLocationCalculationForTargetProbabilityCollectionEntity FOREIGN KEY (HydraulicLocationCalculationForTargetProbabilityCollectionEntityId) REFERENCES HydraulicLocationCalculationForTargetProbabilityCollectionEntity (HydraulicLocationCalculationForTargetProbabilityCollectionEntityId) ON DELETE Set Null ON UPDATE Cascade, - CONSTRAINT FK_GrassCoverErosionOutwardsWaveConditionsCalculationEntity_HydraulicLocationEntity FOREIGN KEY (HydraulicLocationEntityId) REFERENCES HydraulicLocationEntity (HydraulicLocationEntityId) ON DELETE Set Null ON UPDATE Cascade -) + GrassCoverErosionOutwardsWaveConditionsCalculationEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + CalculationGroupEntityId INTEGER NOT NULL, + ForeshoreProfileEntityId INTEGER NULL, + HydraulicLocationEntityId INTEGER NULL, + HydraulicLocationCalculationForTargetProbabilityCollectionEntityId INTEGER NULL, 'Order' + INT +( + 4 +) NOT NULL, + Name VARCHAR(260) NULL, + Comments TEXT NULL COLLATE NOCASE, + UseBreakWater TINYINT (1) NOT NULL, -- true or false + BreakWaterType TINYINT (1) NOT NULL, -- Enum: 1 = Wall, 2 = Caisson, 3 = Dam + BreakWaterHeight REAL NULL, + UseForeshore TINYINT (1) NOT NULL, -- true or false + Orientation REAL NULL, + UpperBoundaryRevetment REAL NULL, + LowerBoundaryRevetment REAL NULL, + UpperBoundaryWaterLevels REAL NULL, + LowerBoundaryWaterLevels REAL NULL, + StepSize TINYINT (1) NOT NULL, -- Enum: 1 = 0.5, 2 = 1.0, 3 = 2.0 + CalculationType TINYINT (1) NOT NULL, -- Enum: 1 = WaveRunUp 2 = WaveImpact 3 = WaveRunUpAndWaveImpact 4 = WaveImpactWithWaveDirection 5 = WaveRunUpAndWaveImpactWithWaveDirection 6 = All + WaterLevelType TINYINT (1) NOT NULL, -- Enum: 1 = None, 2 = MaximumAllowableFloodingProbability, 3 = SignalFloodingProbability, 4 = UserDefinedTargetProbability + CONSTRAINT FK_GrassCoverErosionOutwardsWaveConditionsCalculationEntity_CalculationGroupEntity FOREIGN KEY (CalculationGroupEntityId) REFERENCES CalculationGroupEntity (CalculationGroupEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT FK_GrassCoverErosionOutwardsWaveConditionsCalculationEntity_ForeshoreProfileEntity FOREIGN KEY (ForeshoreProfileEntityId) REFERENCES ForeshoreProfileEntity (ForeshoreProfileEntityId) ON DELETE Set Null ON UPDATE Cascade, + CONSTRAINT FK_GrassCoverErosionOutwardsWaveConditionsCalculationEntity_HydraulicLocationCalculationForTargetProbabilityCollectionEntity FOREIGN KEY (HydraulicLocationCalculationForTargetProbabilityCollectionEntityId) REFERENCES HydraulicLocationCalculationForTargetProbabilityCollectionEntity (HydraulicLocationCalculationForTargetProbabilityCollectionEntityId) ON DELETE Set Null ON UPDATE Cascade, + CONSTRAINT FK_GrassCoverErosionOutwardsWaveConditionsCalculationEntity_HydraulicLocationEntity FOREIGN KEY (HydraulicLocationEntityId) REFERENCES HydraulicLocationEntity (HydraulicLocationEntityId) ON DELETE Set Null ON UPDATE Cascade + ) ; CREATE TABLE GrassCoverErosionOutwardsWaveConditionsOutputEntity ( - GrassCoverErosionOutwardsWaveConditionsOutputEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - GrassCoverErosionOutwardsWaveConditionsCalculationEntityId INTEGER NOT NULL, - 'Order' INT (4) NOT NULL, - OutputType TINYINT (1) NOT NULL, -- Enum: 1 = WaveRunUp 2 = WaveImpact 3 = WaveImpactWithWaveDirection - WaterLevel REAL NULL, - WaveHeight REAL NULL, - WavePeakPeriod REAL NULL, - WaveAngle REAL NULL, - WaveDirection REAL NULL, - TargetProbability REAL NULL, - TargetReliability REAL NULL, - CalculatedProbability REAL NULL, - CalculatedReliability REAL NULL, - CalculationConvergence TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated, 2 = CalculationNotConverged, 3 = CalculationConverged - CONSTRAINT FK_GrassCoverErosionOutwardsWaveConditionsOutputEntity_GrassCoverErosionOutwardsWaveConditionsCalculationEntity FOREIGN KEY (GrassCoverErosionOutwardsWaveConditionsCalculationEntityId) REFERENCES GrassCoverErosionOutwardsWaveConditionsCalculationEntity (GrassCoverErosionOutwardsWaveConditionsCalculationEntityId) ON DELETE Cascade ON UPDATE Cascade -) + GrassCoverErosionOutwardsWaveConditionsOutputEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + GrassCoverErosionOutwardsWaveConditionsCalculationEntityId INTEGER NOT NULL, 'Order' + INT +( + 4 +) NOT NULL, + OutputType TINYINT (1) NOT NULL, -- Enum: 1 = WaveRunUp 2 = WaveImpact 3 = WaveImpactWithWaveDirection + WaterLevel REAL NULL, + WaveHeight REAL NULL, + WavePeakPeriod REAL NULL, + WaveAngle REAL NULL, + WaveDirection REAL NULL, + TargetProbability REAL NULL, + TargetReliability REAL NULL, + CalculatedProbability REAL NULL, + CalculatedReliability REAL NULL, + CalculationConvergence TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated, 2 = CalculationNotConverged, 3 = CalculationConverged + CONSTRAINT FK_GrassCoverErosionOutwardsWaveConditionsOutputEntity_GrassCoverErosionOutwardsWaveConditionsCalculationEntity FOREIGN KEY (GrassCoverErosionOutwardsWaveConditionsCalculationEntityId) REFERENCES GrassCoverErosionOutwardsWaveConditionsCalculationEntity (GrassCoverErosionOutwardsWaveConditionsCalculationEntityId) ON DELETE Cascade ON UPDATE Cascade + ) ; CREATE TABLE GrassCoverSlipOffOutwardsFailureMechanismMetaEntity ( - GrassCoverSlipOffOutwardsFailureMechanismMetaEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - FailureMechanismEntityId INTEGER NOT NULL, - N REAL NOT NULL, - ApplyLengthEffectInSection TINYINT (1) NOT NULL, - CONSTRAINT FK_GrassCoverSlipOffOutwardsFailureMechanismMetaEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade + GrassCoverSlipOffOutwardsFailureMechanismMetaEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + FailureMechanismEntityId INTEGER NOT NULL, + N REAL NOT NULL, + ApplyLengthEffectInSection TINYINT (1) NOT NULL, + CONSTRAINT FK_GrassCoverSlipOffOutwardsFailureMechanismMetaEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; CREATE TABLE HeightStructureEntity ( - HeightStructureEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - FailureMechanismEntityId INTEGER NOT NULL, - 'Order' INT (4) NOT NULL, - Name VARCHAR (260) NOT NULL, - Id VARCHAR (260) NOT NULL, - X REAL NULL, - Y REAL NULL, - StructureNormalOrientation REAL NULL, - LevelCrestStructureMean REAL NULL, - LevelCrestStructureStandardDeviation REAL NULL, - FlowWidthAtBottomProtectionMean REAL NULL, - FlowWidthAtBottomProtectionStandardDeviation REAL NULL, - CriticalOvertoppingDischargeMean REAL NULL, - CriticalOvertoppingDischargeCoefficientOfVariation REAL NULL, - WidthFlowAperturesMean REAL NULL, - WidthFlowAperturesStandardDeviation REAL NULL, - FailureProbabilityStructureWithErosion REAL NULL, - StorageStructureAreaMean REAL NULL, - StorageStructureAreaCoefficientOfVariation REAL NULL, - AllowedLevelIncreaseStorageMean REAL NULL, - AllowedLevelIncreaseStorageStandardDeviation REAL NULL, - CONSTRAINT FK_HeightStructure_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT U_Id_FailureMechanismEntityId UNIQUE (FailureMechanismEntityId,Id) -) + HeightStructureEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + FailureMechanismEntityId INTEGER NOT NULL, 'Order' + INT +( + 4 +) NOT NULL, + Name VARCHAR(260) NOT NULL, + Id VARCHAR(260) NOT NULL, + X REAL NULL, + Y REAL NULL, + StructureNormalOrientation REAL NULL, + LevelCrestStructureMean REAL NULL, + LevelCrestStructureStandardDeviation REAL NULL, + FlowWidthAtBottomProtectionMean REAL NULL, + FlowWidthAtBottomProtectionStandardDeviation REAL NULL, + CriticalOvertoppingDischargeMean REAL NULL, + CriticalOvertoppingDischargeCoefficientOfVariation REAL NULL, + WidthFlowAperturesMean REAL NULL, + WidthFlowAperturesStandardDeviation REAL NULL, + FailureProbabilityStructureWithErosion REAL NULL, + StorageStructureAreaMean REAL NULL, + StorageStructureAreaCoefficientOfVariation REAL NULL, + AllowedLevelIncreaseStorageMean REAL NULL, + AllowedLevelIncreaseStorageStandardDeviation REAL NULL, + CONSTRAINT FK_HeightStructure_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT U_Id_FailureMechanismEntityId UNIQUE (FailureMechanismEntityId, Id) + ) ; CREATE TABLE HeightStructuresCalculationEntity ( - HeightStructuresCalculationEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - CalculationGroupEntityId INTEGER NOT NULL, - HydraulicLocationEntityId INTEGER NULL, - HeightStructureEntityId INTEGER NULL, - ForeshoreProfileEntityId INTEGER NULL, - 'Order' INT (4) NOT NULL, - Name VARCHAR (260) NULL, - Comments TEXT NULL COLLATE NOCASE, - ModelFactorSuperCriticalFlowMean REAL NULL, - StructureNormalOrientation REAL NULL, - AllowedLevelIncreaseStorageMean REAL NULL, - AllowedLevelIncreaseStorageStandardDeviation REAL NULL, - StorageStructureAreaMean REAL NULL, - StorageStructureAreaCoefficientOfVariation REAL NULL, - FlowWidthAtBottomProtectionMean REAL NULL, - FlowWidthAtBottomProtectionStandardDeviation REAL NULL, - CriticalOvertoppingDischargeMean REAL NULL, - CriticalOvertoppingDischargeCoefficientOfVariation REAL NULL, - FailureProbabilityStructureWithErosion REAL NOT NULL, - WidthFlowAperturesMean REAL NULL, - WidthFlowAperturesStandardDeviation REAL NULL, - StormDurationMean REAL NULL, - LevelCrestStructureMean REAL NULL, - LevelCrestStructureStandardDeviation REAL NULL, - DeviationWaveDirection REAL NULL, - UseBreakWater TINYINT (1) NOT NULL, -- true or false - UseForeshore TINYINT (1) NOT NULL, -- true or false - BreakWaterType TINYINT (1) NOT NULL, -- Enum: 1 = Wall, 2 = Caisson, 3 = Dam - BreakWaterHeight REAL NULL, - ShouldIllustrationPointsBeCalculated TINYINT (1) NOT NULL, -- true or false - RelevantForScenario TINYINT (1) NOT NULL, -- true or false - ScenarioContribution REAL NOT NULL, - CONSTRAINT FK_HeightStructuresCalculationEntity_CalculationGroupEntity FOREIGN KEY (CalculationGroupEntityId) REFERENCES CalculationGroupEntity (CalculationGroupEntityId) ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT FK_HeightStructuresCalculationEntity_ForeshoreProfileEntity FOREIGN KEY (ForeshoreProfileEntityId) REFERENCES ForeshoreProfileEntity (ForeshoreProfileEntityId) ON DELETE Set Null ON UPDATE Cascade, - CONSTRAINT FK_HeightStructuresCalculationEntity_HeightStructureEntity FOREIGN KEY (HeightStructureEntityId) REFERENCES HeightStructureEntity (HeightStructureEntityId) ON DELETE Set Null ON UPDATE Cascade, - CONSTRAINT FK_HeightStructuresCalculationEntity_HydraulicLocationEntity FOREIGN KEY (HydraulicLocationEntityId) REFERENCES HydraulicLocationEntity (HydraulicLocationEntityId) ON DELETE Set Null ON UPDATE Cascade -) + HeightStructuresCalculationEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + CalculationGroupEntityId INTEGER NOT NULL, + HydraulicLocationEntityId INTEGER NULL, + HeightStructureEntityId INTEGER NULL, + ForeshoreProfileEntityId INTEGER NULL, 'Order' + INT +( + 4 +) NOT NULL, + Name VARCHAR(260) NULL, + Comments TEXT NULL COLLATE NOCASE, + ModelFactorSuperCriticalFlowMean REAL NULL, + StructureNormalOrientation REAL NULL, + AllowedLevelIncreaseStorageMean REAL NULL, + AllowedLevelIncreaseStorageStandardDeviation REAL NULL, + StorageStructureAreaMean REAL NULL, + StorageStructureAreaCoefficientOfVariation REAL NULL, + FlowWidthAtBottomProtectionMean REAL NULL, + FlowWidthAtBottomProtectionStandardDeviation REAL NULL, + CriticalOvertoppingDischargeMean REAL NULL, + CriticalOvertoppingDischargeCoefficientOfVariation REAL NULL, + FailureProbabilityStructureWithErosion REAL NOT NULL, + WidthFlowAperturesMean REAL NULL, + WidthFlowAperturesStandardDeviation REAL NULL, + StormDurationMean REAL NULL, + LevelCrestStructureMean REAL NULL, + LevelCrestStructureStandardDeviation REAL NULL, + DeviationWaveDirection REAL NULL, + UseBreakWater TINYINT (1) NOT NULL, -- true or false + UseForeshore TINYINT (1) NOT NULL, -- true or false + BreakWaterType TINYINT (1) NOT NULL, -- Enum: 1 = Wall, 2 = Caisson, 3 = Dam + BreakWaterHeight REAL NULL, + ShouldIllustrationPointsBeCalculated TINYINT (1) NOT NULL, -- true or false + RelevantForScenario TINYINT (1) NOT NULL, -- true or false + ScenarioContribution REAL NOT NULL, + CONSTRAINT FK_HeightStructuresCalculationEntity_CalculationGroupEntity FOREIGN KEY (CalculationGroupEntityId) REFERENCES CalculationGroupEntity (CalculationGroupEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT FK_HeightStructuresCalculationEntity_ForeshoreProfileEntity FOREIGN KEY (ForeshoreProfileEntityId) REFERENCES ForeshoreProfileEntity (ForeshoreProfileEntityId) ON DELETE Set Null ON UPDATE Cascade, + CONSTRAINT FK_HeightStructuresCalculationEntity_HeightStructureEntity FOREIGN KEY (HeightStructureEntityId) REFERENCES HeightStructureEntity (HeightStructureEntityId) ON DELETE Set Null ON UPDATE Cascade, + CONSTRAINT FK_HeightStructuresCalculationEntity_HydraulicLocationEntity FOREIGN KEY (HydraulicLocationEntityId) REFERENCES HydraulicLocationEntity (HydraulicLocationEntityId) ON DELETE Set Null ON UPDATE Cascade + ) ; CREATE TABLE HeightStructuresFailureMechanismMetaEntity ( - HeightStructuresFailureMechanismMetaEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - FailureMechanismEntityId INTEGER NOT NULL, - N REAL NOT NULL, - HeightStructureCollectionSourcePath TEXT NULL COLLATE NOCASE, - ForeshoreProfileCollectionSourcePath TEXT NULL COLLATE NOCASE, - CONSTRAINT FK_HeightStructuresFailureMechanismMetaEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade + HeightStructuresFailureMechanismMetaEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + FailureMechanismEntityId INTEGER NOT NULL, + N REAL NOT NULL, + HeightStructureCollectionSourcePath TEXT NULL COLLATE NOCASE, + ForeshoreProfileCollectionSourcePath TEXT NULL COLLATE NOCASE, + CONSTRAINT FK_HeightStructuresFailureMechanismMetaEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; CREATE TABLE HeightStructuresOutputEntity ( - HeightStructuresOutputEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - HeightStructuresCalculationEntityId INTEGER NOT NULL, - GeneralResultFaultTreeIllustrationPointEntityId INTEGER NULL, - Reliability REAL NULL, - CONSTRAINT FK_HeightStructuresOutputEntity_GeneralResultFaultTreeIllustrationPointEntity FOREIGN KEY (GeneralResultFaultTreeIllustrationPointEntityId) REFERENCES GeneralResultFaultTreeIllustrationPointEntity (GeneralResultFaultTreeIllustrationPointEntityId) ON DELETE Set Null ON UPDATE Cascade, - CONSTRAINT FK_HeightStructuresOutputEntity_HeightStructuresCalculationEntity FOREIGN KEY (HeightStructuresCalculationEntityId) REFERENCES HeightStructuresCalculationEntity (HeightStructuresCalculationEntityId) ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT U_HeightStructuresCalculationEntity UNIQUE (HeightStructuresCalculationEntityId) + HeightStructuresOutputEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + HeightStructuresCalculationEntityId INTEGER NOT NULL, + GeneralResultFaultTreeIllustrationPointEntityId INTEGER NULL, + Reliability REAL NULL, + CONSTRAINT FK_HeightStructuresOutputEntity_GeneralResultFaultTreeIllustrationPointEntity FOREIGN KEY (GeneralResultFaultTreeIllustrationPointEntityId) REFERENCES GeneralResultFaultTreeIllustrationPointEntity (GeneralResultFaultTreeIllustrationPointEntityId) ON DELETE Set Null ON UPDATE Cascade, + CONSTRAINT FK_HeightStructuresOutputEntity_HeightStructuresCalculationEntity FOREIGN KEY (HeightStructuresCalculationEntityId) REFERENCES HeightStructuresCalculationEntity (HeightStructuresCalculationEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT U_HeightStructuresCalculationEntity UNIQUE (HeightStructuresCalculationEntityId) ) ; CREATE TABLE HydraulicBoundaryDatabaseEntity ( - HydraulicBoundaryDatabaseEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - HydraulicBoundaryDataEntityId INTEGER NOT NULL, - Version TEXT NOT NULL COLLATE NOCASE, - FilePath TEXT NOT NULL COLLATE NOCASE, - UsePreprocessorClosure TINYINT (1) NOT NULL, -- True or false - 'Order' INT (4) NOT NULL, - CONSTRAINT FK_HydraulicBoundaryDatabaseEntity_HydraulicBoundaryDataEntity FOREIGN KEY (HydraulicBoundaryDataEntityId) REFERENCES HydraulicBoundaryDataEntity (HydraulicBoundaryDataEntityId) ON DELETE Cascade ON UPDATE Cascade -) + HydraulicBoundaryDatabaseEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + HydraulicBoundaryDataEntityId INTEGER NOT NULL, + Version TEXT NOT NULL COLLATE NOCASE, + FilePath TEXT NOT NULL COLLATE NOCASE, + UsePreprocessorClosure TINYINT (1) NOT NULL, -- True or false + 'Order' + INT +( + 4 +) NOT NULL, + CONSTRAINT FK_HydraulicBoundaryDatabaseEntity_HydraulicBoundaryDataEntity FOREIGN KEY (HydraulicBoundaryDataEntityId) REFERENCES HydraulicBoundaryDataEntity (HydraulicBoundaryDataEntityId) ON DELETE Cascade ON UPDATE Cascade + ) ; CREATE TABLE HydraulicBoundaryDataEntity ( - HydraulicBoundaryDataEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - AssessmentSectionEntityId INTEGER NOT NULL, - HydraulicLocationConfigurationDatabaseFilePath TEXT NOT NULL COLLATE NOCASE, - HydraulicLocationConfigurationDatabaseScenarioName TEXT NOT NULL COLLATE NOCASE, - HydraulicLocationConfigurationDatabaseYear INT (4) NOT NULL, - HydraulicLocationConfigurationDatabaseScope TEXT NOT NULL COLLATE NOCASE, - HydraulicLocationConfigurationDatabaseSeaLevel TEXT NULL COLLATE NOCASE, - HydraulicLocationConfigurationDatabaseRiverDischarge TEXT NULL COLLATE NOCASE, - HydraulicLocationConfigurationDatabaseLakeLevel TEXT NULL COLLATE NOCASE, - HydraulicLocationConfigurationDatabaseWindDirection TEXT NULL COLLATE NOCASE, - HydraulicLocationConfigurationDatabaseWindSpeed TEXT NULL COLLATE NOCASE, - HydraulicLocationConfigurationDatabaseComment TEXT NULL COLLATE NOCASE, - CONSTRAINT FK_HydraulicBoundaryDatabaseEntity_AssessmentSectionEntity FOREIGN KEY (AssessmentSectionEntityId) REFERENCES AssessmentSectionEntity (AssessmentSectionEntityId) ON DELETE Cascade ON UPDATE Cascade + HydraulicBoundaryDataEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + AssessmentSectionEntityId INTEGER NOT NULL, + HydraulicLocationConfigurationDatabaseFilePath TEXT NOT NULL COLLATE NOCASE, + HydraulicLocationConfigurationDatabaseScenarioName TEXT NOT NULL COLLATE NOCASE, + HydraulicLocationConfigurationDatabaseYear INT (4) NOT NULL, + HydraulicLocationConfigurationDatabaseScope TEXT NOT NULL COLLATE NOCASE, + HydraulicLocationConfigurationDatabaseSeaLevel TEXT NULL COLLATE NOCASE, + HydraulicLocationConfigurationDatabaseRiverDischarge TEXT NULL COLLATE NOCASE, + HydraulicLocationConfigurationDatabaseLakeLevel TEXT NULL COLLATE NOCASE, + HydraulicLocationConfigurationDatabaseWindDirection TEXT NULL COLLATE NOCASE, + HydraulicLocationConfigurationDatabaseWindSpeed TEXT NULL COLLATE NOCASE, + HydraulicLocationConfigurationDatabaseComment TEXT NULL COLLATE NOCASE, + CONSTRAINT FK_HydraulicBoundaryDatabaseEntity_AssessmentSectionEntity FOREIGN KEY (AssessmentSectionEntityId) REFERENCES AssessmentSectionEntity (AssessmentSectionEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; CREATE TABLE HydraulicLocationCalculationCollectionEntity ( - HydraulicLocationCalculationCollectionEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT + HydraulicLocationCalculationCollectionEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT ) ; CREATE TABLE HydraulicLocationCalculationCollectionHydraulicLocationCalculationEntity ( - HydraulicLocationCalculationCollectionEntityId INTEGER NOT NULL, - HydraulicLocationCalculationEntityId INTEGER NOT NULL, - CONSTRAINT PK_HydraulicLocationCalculationCollectionHydraulicLocationCalculationEntity PRIMARY KEY (HydraulicLocationCalculationCollectionEntityId,HydraulicLocationCalculationEntityId), - CONSTRAINT HydraulicLocationCalculationCollectionHydraulicLocationCalculationEntity_HydraulicLocationCalculationCollectionEntityId FOREIGN KEY (HydraulicLocationCalculationCollectionEntityId) REFERENCES HydraulicLocationCalculationCollectionEntity (HydraulicLocationCalculationCollectionEntityId) ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT HydraulicLocationCalculationEntityId FOREIGN KEY (HydraulicLocationCalculationEntityId) REFERENCES HydraulicLocationCalculationEntity (HydraulicLocationCalculationEntityId) ON DELETE Cascade ON UPDATE Cascade + HydraulicLocationCalculationCollectionEntityId INTEGER NOT NULL, + HydraulicLocationCalculationEntityId INTEGER NOT NULL, + CONSTRAINT PK_HydraulicLocationCalculationCollectionHydraulicLocationCalculationEntity PRIMARY KEY (HydraulicLocationCalculationCollectionEntityId, + HydraulicLocationCalculationEntityId), + CONSTRAINT HydraulicLocationCalculationCollectionHydraulicLocationCalculationEntity_HydraulicLocationCalculationCollectionEntityId FOREIGN KEY (HydraulicLocationCalculationCollectionEntityId) REFERENCES HydraulicLocationCalculationCollectionEntity (HydraulicLocationCalculationCollectionEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT HydraulicLocationCalculationEntityId FOREIGN KEY (HydraulicLocationCalculationEntityId) REFERENCES HydraulicLocationCalculationEntity (HydraulicLocationCalculationEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; CREATE TABLE HydraulicLocationCalculationEntity ( - HydraulicLocationCalculationEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - HydraulicLocationEntityId INTEGER NOT NULL, - ShouldIllustrationPointsBeCalculated TINYINT (1) NOT NULL, -- True or false - CONSTRAINT FK_HydraulicLocationCalculationEntity_HydraulicLocationEntity FOREIGN KEY (HydraulicLocationEntityId) REFERENCES HydraulicLocationEntity (HydraulicLocationEntityId) ON DELETE Cascade ON UPDATE Cascade + HydraulicLocationCalculationEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + HydraulicLocationEntityId INTEGER NOT NULL, + ShouldIllustrationPointsBeCalculated TINYINT (1) NOT NULL, -- True or false + CONSTRAINT FK_HydraulicLocationCalculationEntity_HydraulicLocationEntity FOREIGN KEY (HydraulicLocationEntityId) REFERENCES HydraulicLocationEntity (HydraulicLocationEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; CREATE TABLE HydraulicLocationCalculationForTargetProbabilityCollectionEntity ( - HydraulicLocationCalculationForTargetProbabilityCollectionEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - AssessmentSectionEntityId INTEGER NOT NULL, - 'Order' INT (4) NOT NULL, - HydraulicBoundaryLocationCalculationType TINYINT (1) NOT NULL, -- Enum: 1 = Waterlevel 2 = Waveheight - TargetProbability REAL NOT NULL, - CONSTRAINT FK_HydraulicBoundaryLocationCalculationsForTargetProbabilityEntity_AssessmentSectionEntity FOREIGN KEY (AssessmentSectionEntityId) REFERENCES AssessmentSectionEntity (AssessmentSectionEntityId) ON DELETE Cascade ON UPDATE Cascade -) + HydraulicLocationCalculationForTargetProbabilityCollectionEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + AssessmentSectionEntityId INTEGER NOT NULL, 'Order' + INT +( + 4 +) NOT NULL, + HydraulicBoundaryLocationCalculationType TINYINT (1) NOT NULL, -- Enum: 1 = Waterlevel 2 = Waveheight + TargetProbability REAL NOT NULL, + CONSTRAINT FK_HydraulicBoundaryLocationCalculationsForTargetProbabilityEntity_AssessmentSectionEntity FOREIGN KEY (AssessmentSectionEntityId) REFERENCES AssessmentSectionEntity (AssessmentSectionEntityId) ON DELETE Cascade ON UPDATE Cascade + ) ; CREATE TABLE HydraulicLocationCalculationForTargetProbabilityCollectionHydraulicLocationCalculationEntity ( - HydraulicLocationCalculationForTargetProbabilityCollectionEntityId INTEGER NOT NULL, - HydraulicLocationCalculationEntityId INTEGER NOT NULL, - CONSTRAINT PK_HydraulicBoundaryLocationCalculationsForTargetProbabilityHydraulicLocationCalculationEntity PRIMARY KEY (HydraulicLocationCalculationForTargetProbabilityCollectionEntityId,HydraulicLocationCalculationEntityId), - CONSTRAINT HydraulicBoundaryLocationCalculationsForTargetProbabilityHydraulicLocationCalculationEntity_HydraulicBoundaryLocationCalculationsForTargetProbabilityEntityId FOREIGN KEY (HydraulicLocationCalculationForTargetProbabilityCollectionEntityId) REFERENCES HydraulicLocationCalculationForTargetProbabilityCollectionEntity (HydraulicLocationCalculationForTargetProbabilityCollectionEntityId) ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT HydraulicBoundaryLocationCalculationsForTargetProbabilityHydraulicLocationCalculationEntity_HydraulicLocationCalculationEntityId FOREIGN KEY (HydraulicLocationCalculationEntityId) REFERENCES HydraulicLocationCalculationEntity (HydraulicLocationCalculationEntityId) ON DELETE No Action ON UPDATE No Action + HydraulicLocationCalculationForTargetProbabilityCollectionEntityId INTEGER NOT NULL, + HydraulicLocationCalculationEntityId INTEGER NOT NULL, + CONSTRAINT PK_HydraulicBoundaryLocationCalculationsForTargetProbabilityHydraulicLocationCalculationEntity PRIMARY KEY (HydraulicLocationCalculationForTargetProbabilityCollectionEntityId, + HydraulicLocationCalculationEntityId), + CONSTRAINT HydraulicBoundaryLocationCalculationsForTargetProbabilityHydraulicLocationCalculationEntity_HydraulicBoundaryLocationCalculationsForTargetProbabilityEntityId FOREIGN KEY (HydraulicLocationCalculationForTargetProbabilityCollectionEntityId) REFERENCES HydraulicLocationCalculationForTargetProbabilityCollectionEntity (HydraulicLocationCalculationForTargetProbabilityCollectionEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT HydraulicBoundaryLocationCalculationsForTargetProbabilityHydraulicLocationCalculationEntity_HydraulicLocationCalculationEntityId FOREIGN KEY (HydraulicLocationCalculationEntityId) REFERENCES HydraulicLocationCalculationEntity (HydraulicLocationCalculationEntityId) ON DELETE No Action ON UPDATE No Action ) ; CREATE TABLE HydraulicLocationOutputEntity ( - HydraulicLocationOutputEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - HydraulicLocationCalculationEntityId INTEGER NOT NULL, - GeneralResultSubMechanismIllustrationPointEntityId INTEGER NULL, - Result REAL NULL, - TargetProbability REAL NULL, - TargetReliability REAL NULL, - CalculatedProbability REAL NULL, - CalculatedReliability REAL NULL, - CalculationConvergence TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated, 2 = CalculatedNotConverged, 3 = CalculatedConverged - CONSTRAINT FK_HydraulicLocationOutputEntity_GeneralResultSubMechanismIllustrationPointEntity FOREIGN KEY (GeneralResultSubMechanismIllustrationPointEntityId) REFERENCES GeneralResultSubMechanismIllustrationPointEntity (GeneralResultSubMechanismIllustrationPointEntityId) ON DELETE Set Null ON UPDATE Cascade, - CONSTRAINT FK_HydraulicLocationOutputEntity_HydraulicLocationCalculationEntity FOREIGN KEY (HydraulicLocationCalculationEntityId) REFERENCES HydraulicLocationCalculationEntity (HydraulicLocationCalculationEntityId) ON DELETE Set Null ON UPDATE Cascade + HydraulicLocationOutputEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + HydraulicLocationCalculationEntityId INTEGER NOT NULL, + GeneralResultSubMechanismIllustrationPointEntityId INTEGER NULL, + Result REAL NULL, + TargetProbability REAL NULL, + TargetReliability REAL NULL, + CalculatedProbability REAL NULL, + CalculatedReliability REAL NULL, + CalculationConvergence TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated, 2 = CalculatedNotConverged, 3 = CalculatedConverged + CONSTRAINT FK_HydraulicLocationOutputEntity_GeneralResultSubMechanismIllustrationPointEntity FOREIGN KEY (GeneralResultSubMechanismIllustrationPointEntityId) REFERENCES GeneralResultSubMechanismIllustrationPointEntity (GeneralResultSubMechanismIllustrationPointEntityId) ON DELETE Set Null ON UPDATE Cascade, + CONSTRAINT FK_HydraulicLocationOutputEntity_HydraulicLocationCalculationEntity FOREIGN KEY (HydraulicLocationCalculationEntityId) REFERENCES HydraulicLocationCalculationEntity (HydraulicLocationCalculationEntityId) ON DELETE Set Null ON UPDATE Cascade ) ; CREATE TABLE IllustrationPointResultEntity ( - IllustrationPointResultEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - SubMechanismIllustrationPointEntityId INTEGER NOT NULL, - Description TEXT NOT NULL COLLATE NOCASE, - Unit TEXT NOT NULL COLLATE NOCASE, - Value REAL NOT NULL, - 'Order' INT (4) NOT NULL, - CONSTRAINT FK_IllustrationPointResultEntity_SubMechanismIllustrationPointEntity FOREIGN KEY (SubMechanismIllustrationPointEntityId) REFERENCES SubMechanismIllustrationPointEntity (SubMechanismIllustrationPointEntityId) ON DELETE Cascade ON UPDATE Cascade -) + IllustrationPointResultEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + SubMechanismIllustrationPointEntityId INTEGER NOT NULL, + Description TEXT NOT NULL COLLATE NOCASE, + Unit TEXT NOT NULL COLLATE NOCASE, + Value REAL NOT NULL, 'Order' + INT +( + 4 +) NOT NULL, + CONSTRAINT FK_IllustrationPointResultEntity_SubMechanismIllustrationPointEntity FOREIGN KEY (SubMechanismIllustrationPointEntityId) REFERENCES SubMechanismIllustrationPointEntity (SubMechanismIllustrationPointEntityId) ON DELETE Cascade ON UPDATE Cascade + ) ; CREATE TABLE MacroStabilityInwardsCalculationEntity ( - MacroStabilityInwardsCalculationEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - CalculationGroupEntityId INTEGER NOT NULL, - SurfaceLineEntityId INTEGER NULL, - MacroStabilityInwardsStochasticSoilProfileEntityId INTEGER NULL, - HydraulicLocationEntityId INTEGER NULL, - 'Order' INT (4) NOT NULL, - Name VARCHAR (260) NULL, - Comment TEXT NULL COLLATE NOCASE, - RelevantForScenario TINYINT (1) NOT NULL, -- true or false - ScenarioContribution REAL NOT NULL, - AssessmentLevel REAL NULL, - UseAssessmentLevelManualInput TINYINT (1) NOT NULL, -- true or false - SlipPlaneMinimumDepth REAL NULL, - SlipPlaneMinimumLength REAL NULL, - MaximumSliceWidth REAL NULL, - MoveGrid TINYINT (1) NOT NULL, -- true or false - GridDeterminationType TINYINT (1) NOT NULL, -- Enumtype: 1 = Automatic, 2 = Manual - TangentLineDeterminationType TINYINT (1) NOT NULL, -- Enumtype: 1 = Specified, 2 = LayerSeparated - TangentLineZTop REAL NULL, - TangentLineZBottom REAL NULL, - TangentLineNumber INT (4) NOT NULL, - LeftGridXLeft REAL NULL, - LeftGridXRight REAL NULL, - LeftGridNrOfHorizontalPoints INT (4) NOT NULL, - LeftGridZTop REAL NULL, - LeftGridZBottom REAL NULL, - LeftGridNrOfVerticalPoints INT (4) NOT NULL, - RightGridXLeft REAL NULL, - RightGridXRight REAL NULL, - RightGridNrOfHorizontalPoints INT (4) NOT NULL, - RightGridZTop REAL NULL, - RightGridZBottom REAL NULL, - RightGridNrOfVerticalPoints INT (4) NOT NULL, - DikeSoilScenario TINYINT (1) NOT NULL, -- Enumtype: 1 = ClayDikeOnClay, 2 = SandDikeOnClay, 3 = ClayDikeOnSand, 4 = SandDikeOnSand - WaterLevelRiverAverage REAL NULL, - DrainageConstructionPresent TINYINT (1) NOT NULL, -- true or false - DrainageConstructionCoordinateX REAL NULL, - DrainageConstructionCoordinateZ REAL NULL, - MinimumLevelPhreaticLineAtDikeTopRiver REAL NULL, - MinimumLevelPhreaticLineAtDikeTopPolder REAL NULL, - AdjustPhreaticLine3And4ForUplift TINYINT (1) NOT NULL, -- true or false - LeakageLengthOutwardsPhreaticLine3 REAL NULL, - LeakageLengthInwardsPhreaticLine3 REAL NULL, - LeakageLengthOutwardsPhreaticLine4 REAL NULL, - LeakageLengthInwardsPhreaticLine4 REAL NULL, - PiezometricHeadPhreaticLine2Outwards REAL NULL, - PiezometricHeadPhreaticLine2Inwards REAL NULL, - LocationInputExtremeWaterLevelPolder REAL NULL, - LocationInputExtremeUseDefaultOffsets TINYINT (1) NOT NULL, -- true or false - LocationInputExtremePhreaticLineOffsetBelowDikeTopAtRiver REAL NULL, - LocationInputExtremePhreaticLineOffsetBelowDikeTopAtPolder REAL NULL, - LocationInputExtremePhreaticLineOffsetBelowShoulderBaseInside REAL NULL, - LocationInputExtremePhreaticLineOffsetDikeToeAtPolder REAL NULL, - LocationInputExtremePenetrationLength REAL NULL, - LocationInputDailyWaterLevelPolder REAL NULL, - LocationInputDailyUseDefaultOffsets TINYINT (1) NOT NULL, -- true or false - LocationInputDailyPhreaticLineOffsetBelowDikeTopAtRiver REAL NULL, - LocationInputDailyPhreaticLineOffsetBelowDikeTopAtPolder REAL NULL, - LocationInputDailyPhreaticLineOffsetBelowShoulderBaseInside REAL NULL, - LocationInputDailyPhreaticLineOffsetDikeToeAtPolder REAL NULL, - CreateZones TINYINT (1) NOT NULL, -- true or false - ZoningBoundariesDeterminationType TINYINT (1) NOT NULL, -- Enumtype: 1 = Automatic 2 = Manual - ZoneBoundaryLeft REAL NULL, - ZoneBoundaryRight REAL NULL, - CONSTRAINT FK_MacroStabilityInwardsCalculationEntity_CalculationGroupEntity FOREIGN KEY (CalculationGroupEntityId) REFERENCES CalculationGroupEntity (CalculationGroupEntityId) ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT FK_MacroStabilityInwardsCalculationEntity_HydraulicLocationEntity FOREIGN KEY (HydraulicLocationEntityId) REFERENCES HydraulicLocationEntity (HydraulicLocationEntityId) ON DELETE Set Null ON UPDATE Cascade, - CONSTRAINT FK_MacroStabilityInwardsCalculationEntity_MacroStabilityInwardsStochasticSoilProfileEntity FOREIGN KEY (MacroStabilityInwardsStochasticSoilProfileEntityId) REFERENCES MacroStabilityInwardsStochasticSoilProfileEntity (MacroStabilityInwardsStochasticSoilProfileEntityId) ON DELETE Set Null ON UPDATE Cascade, - CONSTRAINT FK_MacroStabilityInwardsCalculationEntity_SurfaceLineEntity FOREIGN KEY (SurfaceLineEntityId) REFERENCES SurfaceLineEntity (SurfaceLineEntityId) ON DELETE Set Null ON UPDATE Cascade -) + MacroStabilityInwardsCalculationEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + CalculationGroupEntityId INTEGER NOT NULL, + SurfaceLineEntityId INTEGER NULL, + MacroStabilityInwardsStochasticSoilProfileEntityId INTEGER NULL, + HydraulicLocationEntityId INTEGER NULL, 'Order' + INT +( + 4 +) NOT NULL, + Name VARCHAR(260) NULL, + Comment TEXT NULL COLLATE NOCASE, + RelevantForScenario TINYINT (1) NOT NULL, -- true or false + ScenarioContribution REAL NOT NULL, + AssessmentLevel REAL NULL, + UseAssessmentLevelManualInput TINYINT (1) NOT NULL, -- true or false + SlipPlaneMinimumDepth REAL NULL, + SlipPlaneMinimumLength REAL NULL, + MaximumSliceWidth REAL NULL, + MoveGrid TINYINT (1) NOT NULL, -- true or false + GridDeterminationType TINYINT (1) NOT NULL, -- Enumtype: 1 = Automatic, 2 = Manual + TangentLineDeterminationType TINYINT (1) NOT NULL, -- Enumtype: 1 = Specified, 2 = LayerSeparated + TangentLineZTop REAL NULL, + TangentLineZBottom REAL NULL, + TangentLineNumber INT (4) NOT NULL, + LeftGridXLeft REAL NULL, + LeftGridXRight REAL NULL, + LeftGridNrOfHorizontalPoints INT (4) NOT NULL, + LeftGridZTop REAL NULL, + LeftGridZBottom REAL NULL, + LeftGridNrOfVerticalPoints INT (4) NOT NULL, + RightGridXLeft REAL NULL, + RightGridXRight REAL NULL, + RightGridNrOfHorizontalPoints INT (4) NOT NULL, + RightGridZTop REAL NULL, + RightGridZBottom REAL NULL, + RightGridNrOfVerticalPoints INT (4) NOT NULL, + DikeSoilScenario TINYINT (1) NOT NULL, -- Enumtype: 1 = ClayDikeOnClay, 2 = SandDikeOnClay, 3 = ClayDikeOnSand, 4 = SandDikeOnSand + WaterLevelRiverAverage REAL NULL, + DrainageConstructionPresent TINYINT (1) NOT NULL, -- true or false + DrainageConstructionCoordinateX REAL NULL, + DrainageConstructionCoordinateZ REAL NULL, + MinimumLevelPhreaticLineAtDikeTopRiver REAL NULL, + MinimumLevelPhreaticLineAtDikeTopPolder REAL NULL, + AdjustPhreaticLine3And4ForUplift TINYINT (1) NOT NULL, -- true or false + LeakageLengthOutwardsPhreaticLine3 REAL NULL, + LeakageLengthInwardsPhreaticLine3 REAL NULL, + LeakageLengthOutwardsPhreaticLine4 REAL NULL, + LeakageLengthInwardsPhreaticLine4 REAL NULL, + PiezometricHeadPhreaticLine2Outwards REAL NULL, + PiezometricHeadPhreaticLine2Inwards REAL NULL, + LocationInputExtremeWaterLevelPolder REAL NULL, + LocationInputExtremeUseDefaultOffsets TINYINT (1) NOT NULL, -- true or false + LocationInputExtremePhreaticLineOffsetBelowDikeTopAtRiver REAL NULL, + LocationInputExtremePhreaticLineOffsetBelowDikeTopAtPolder REAL NULL, + LocationInputExtremePhreaticLineOffsetBelowShoulderBaseInside REAL NULL, + LocationInputExtremePhreaticLineOffsetDikeToeAtPolder REAL NULL, + LocationInputExtremePenetrationLength REAL NULL, + LocationInputDailyWaterLevelPolder REAL NULL, + LocationInputDailyUseDefaultOffsets TINYINT (1) NOT NULL, -- true or false + LocationInputDailyPhreaticLineOffsetBelowDikeTopAtRiver REAL NULL, + LocationInputDailyPhreaticLineOffsetBelowDikeTopAtPolder REAL NULL, + LocationInputDailyPhreaticLineOffsetBelowShoulderBaseInside REAL NULL, + LocationInputDailyPhreaticLineOffsetDikeToeAtPolder REAL NULL, + CreateZones TINYINT (1) NOT NULL, -- true or false + ZoningBoundariesDeterminationType TINYINT (1) NOT NULL, -- Enumtype: 1 = Automatic 2 = Manual + ZoneBoundaryLeft REAL NULL, + ZoneBoundaryRight REAL NULL, + CONSTRAINT FK_MacroStabilityInwardsCalculationEntity_CalculationGroupEntity FOREIGN KEY (CalculationGroupEntityId) REFERENCES CalculationGroupEntity (CalculationGroupEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT FK_MacroStabilityInwardsCalculationEntity_HydraulicLocationEntity FOREIGN KEY (HydraulicLocationEntityId) REFERENCES HydraulicLocationEntity (HydraulicLocationEntityId) ON DELETE Set Null ON UPDATE Cascade, + CONSTRAINT FK_MacroStabilityInwardsCalculationEntity_MacroStabilityInwardsStochasticSoilProfileEntity FOREIGN KEY (MacroStabilityInwardsStochasticSoilProfileEntityId) REFERENCES MacroStabilityInwardsStochasticSoilProfileEntity (MacroStabilityInwardsStochasticSoilProfileEntityId) ON DELETE Set Null ON UPDATE Cascade, + CONSTRAINT FK_MacroStabilityInwardsCalculationEntity_SurfaceLineEntity FOREIGN KEY (SurfaceLineEntityId) REFERENCES SurfaceLineEntity (SurfaceLineEntityId) ON DELETE Set Null ON UPDATE Cascade + ) ; CREATE TABLE MacroStabilityInwardsCalculationOutputEntity ( - MacroStabilityInwardsCalculationOutputEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - MacroStabilityInwardsCalculationEntityId INTEGER NOT NULL, - FactorOfStability REAL NULL, - ForbiddenZonesXEntryMin REAL NULL, - ForbiddenZonesXEntryMax REAL NULL, - SlidingCurveLeftSlidingCircleCenterX REAL NULL, - SlidingCurveLeftSlidingCircleCenterY REAL NULL, - SlidingCurveLeftSlidingCircleRadius REAL NULL, - SlidingCurveLeftSlidingCircleIsActive TINYINT (1) NOT NULL, -- true or false - SlidingCurveLeftSlidingCircleNonIteratedForce REAL NULL, - SlidingCurveLeftSlidingCircleIteratedForce REAL NULL, - SlidingCurveLeftSlidingCircleDrivingMoment REAL NULL, - SlidingCurveLeftSlidingCircleResistingMoment REAL NULL, - SlidingCurveRightSlidingCircleCenterX REAL NULL, - SlidingCurveRightSlidingCircleCenterY REAL NULL, - SlidingCurveRightSlidingCircleRadius REAL NULL, - SlidingCurveRightSlidingCircleIsActive TINYINT (1) NOT NULL, -- true or false - SlidingCurveRightSlidingCircleNonIteratedForce REAL NULL, - SlidingCurveRightSlidingCircleIteratedForce REAL NULL, - SlidingCurveRightSlidingCircleDrivingMoment REAL NULL, - SlidingCurveRightSlidingCircleResistingMoment REAL NULL, - SlidingCurveNonIteratedHorizontalForce REAL NULL, - SlidingCurveIteratedHorizontalForce REAL NULL, - SlidingCurveSliceXML TEXT NOT NULL COLLATE NOCASE, -- XML representation of MacroStabilityInwardsSlice - SlipPlaneLeftGridXLeft REAL NULL, - SlipPlaneLeftGridXRight REAL NULL, - SlipPlaneLeftGridNrOfHorizontalPoints INT (4) NOT NULL, - SlipPlaneLeftGridZTop REAL NULL, - SlipPlaneLeftGridZBottom REAL NULL, - SlipPlaneLeftGridNrOfVerticalPoints INT (4) NOT NULL, - SlipPlaneRightGridXLeft REAL NULL, - SlipPlaneRightGridXRight REAL NULL, - SlipPlaneRightGridNrOfHorizontalPoints INT (4) NOT NULL, - SlipPlaneRightGridZTop REAL NULL, - SlipPlaneRightGridZBottom REAL NULL, - SlipPlaneRightGridNrOfVerticalPoints INT (4) NOT NULL, - SlipPlaneTangentLinesXml TEXT NOT NULL COLLATE NOCASE, -- XML representation of TangentLines - CONSTRAINT FK_MacroStabilityInwardsCalculationOutput_MacroStabilityInwardsCalculationEntity FOREIGN KEY (MacroStabilityInwardsCalculationEntityId) REFERENCES MacroStabilityInwardsCalculationEntity (MacroStabilityInwardsCalculationEntityId) ON DELETE Cascade ON UPDATE Cascade + MacroStabilityInwardsCalculationOutputEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + MacroStabilityInwardsCalculationEntityId INTEGER NOT NULL, + FactorOfStability REAL NULL, + ForbiddenZonesXEntryMin REAL NULL, + ForbiddenZonesXEntryMax REAL NULL, + SlidingCurveLeftSlidingCircleCenterX REAL NULL, + SlidingCurveLeftSlidingCircleCenterY REAL NULL, + SlidingCurveLeftSlidingCircleRadius REAL NULL, + SlidingCurveLeftSlidingCircleIsActive TINYINT (1) NOT NULL, -- true or false + SlidingCurveLeftSlidingCircleNonIteratedForce REAL NULL, + SlidingCurveLeftSlidingCircleIteratedForce REAL NULL, + SlidingCurveLeftSlidingCircleDrivingMoment REAL NULL, + SlidingCurveLeftSlidingCircleResistingMoment REAL NULL, + SlidingCurveRightSlidingCircleCenterX REAL NULL, + SlidingCurveRightSlidingCircleCenterY REAL NULL, + SlidingCurveRightSlidingCircleRadius REAL NULL, + SlidingCurveRightSlidingCircleIsActive TINYINT (1) NOT NULL, -- true or false + SlidingCurveRightSlidingCircleNonIteratedForce REAL NULL, + SlidingCurveRightSlidingCircleIteratedForce REAL NULL, + SlidingCurveRightSlidingCircleDrivingMoment REAL NULL, + SlidingCurveRightSlidingCircleResistingMoment REAL NULL, + SlidingCurveNonIteratedHorizontalForce REAL NULL, + SlidingCurveIteratedHorizontalForce REAL NULL, + SlidingCurveSliceXML TEXT NOT NULL COLLATE NOCASE, -- XML representation of MacroStabilityInwardsSlice + SlipPlaneLeftGridXLeft REAL NULL, + SlipPlaneLeftGridXRight REAL NULL, + SlipPlaneLeftGridNrOfHorizontalPoints INT (4) NOT NULL, + SlipPlaneLeftGridZTop REAL NULL, + SlipPlaneLeftGridZBottom REAL NULL, + SlipPlaneLeftGridNrOfVerticalPoints INT (4) NOT NULL, + SlipPlaneRightGridXLeft REAL NULL, + SlipPlaneRightGridXRight REAL NULL, + SlipPlaneRightGridNrOfHorizontalPoints INT (4) NOT NULL, + SlipPlaneRightGridZTop REAL NULL, + SlipPlaneRightGridZBottom REAL NULL, + SlipPlaneRightGridNrOfVerticalPoints INT (4) NOT NULL, + SlipPlaneTangentLinesXml TEXT NOT NULL COLLATE NOCASE, -- XML representation of TangentLines + CONSTRAINT FK_MacroStabilityInwardsCalculationOutput_MacroStabilityInwardsCalculationEntity FOREIGN KEY (MacroStabilityInwardsCalculationEntityId) REFERENCES MacroStabilityInwardsCalculationEntity (MacroStabilityInwardsCalculationEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; CREATE TABLE MacroStabilityInwardsCharacteristicPointEntity ( - MacroStabilityInwardsCharacteristicPointEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - SurfaceLineEntityId INTEGER NOT NULL, - Type SMALLINT NOT NULL, -- Enumtype: 1 = SurfaceLevelOutside 2 = DikeTopAtRiver 3 = DikeToeAtRiver 4 = DikeTopAtPolder 5 = ShoulderBaseInside 6 = ShoulderTopInside 7 = DikeToeAtPolder 8 = DitchDikeSide 9 = BottomDitchDikeSide 10 = BottomDitchPolderSide 11 = DitchPolderSide 12 = SurfaceLevelInside - X REAL NULL, - Y REAL NULL, - Z REAL NULL, - CONSTRAINT FK_MacroStabilityInwardsCharacteristicPointEntity_SurfaceLineEntity FOREIGN KEY (SurfaceLineEntityId) REFERENCES SurfaceLineEntity (SurfaceLineEntityId) ON DELETE Cascade ON UPDATE Cascade + MacroStabilityInwardsCharacteristicPointEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + SurfaceLineEntityId INTEGER NOT NULL, + Type SMALLINT NOT NULL, -- Enumtype: 1 = SurfaceLevelOutside 2 = DikeTopAtRiver 3 = DikeToeAtRiver 4 = DikeTopAtPolder 5 = ShoulderBaseInside 6 = ShoulderTopInside 7 = DikeToeAtPolder 8 = DitchDikeSide 9 = BottomDitchDikeSide 10 = BottomDitchPolderSide 11 = DitchPolderSide 12 = SurfaceLevelInside + X REAL NULL, + Y REAL NULL, + Z REAL NULL, + CONSTRAINT FK_MacroStabilityInwardsCharacteristicPointEntity_SurfaceLineEntity FOREIGN KEY (SurfaceLineEntityId) REFERENCES SurfaceLineEntity (SurfaceLineEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; CREATE TABLE MacroStabilityInwardsFailureMechanismMetaEntity ( - MacroStabilityInwardsFailureMechanismMetaEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - FailureMechanismEntityId INTEGER NOT NULL, - A REAL NOT NULL, - StochasticSoilModelCollectionSourcePath TEXT NULL COLLATE NOCASE, - SurfaceLineCollectionSourcePath TEXT NULL COLLATE NOCASE, - CONSTRAINT FK_MacroStabilityInwardsFailureMechanismMetaEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade + MacroStabilityInwardsFailureMechanismMetaEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + FailureMechanismEntityId INTEGER NOT NULL, + A REAL NOT NULL, + StochasticSoilModelCollectionSourcePath TEXT NULL COLLATE NOCASE, + SurfaceLineCollectionSourcePath TEXT NULL COLLATE NOCASE, + CONSTRAINT FK_MacroStabilityInwardsFailureMechanismMetaEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; CREATE TABLE MacroStabilityInwardsPreconsolidationStressEntity ( - MacroStabilityInwardsPreconsolidationStressEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - MacroStabilityInwardsSoilProfileTwoDEntityId INTEGER NOT NULL, - CoordinateX REAL NOT NULL, - CoordinateZ REAL NOT NULL, - PreconsolidationStressMean REAL NULL, - PreconsolidationStressCoefficientOfVariation REAL NULL, - 'Order' INT (4) NOT NULL, - CONSTRAINT FK_MacroStabilityInwardsPreconsolidationStressEntity_MacroStabilityInwardsSoilProfileTwoDEntity FOREIGN KEY (MacroStabilityInwardsSoilProfileTwoDEntityId) REFERENCES MacroStabilityInwardsSoilProfileTwoDEntity (MacroStabilityInwardsSoilProfileTwoDEntityId) ON DELETE Cascade ON UPDATE Cascade -) + MacroStabilityInwardsPreconsolidationStressEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + MacroStabilityInwardsSoilProfileTwoDEntityId INTEGER NOT NULL, + CoordinateX REAL NOT NULL, + CoordinateZ REAL NOT NULL, + PreconsolidationStressMean REAL NULL, + PreconsolidationStressCoefficientOfVariation REAL NULL, 'Order' + INT +( + 4 +) NOT NULL, + CONSTRAINT FK_MacroStabilityInwardsPreconsolidationStressEntity_MacroStabilityInwardsSoilProfileTwoDEntity FOREIGN KEY (MacroStabilityInwardsSoilProfileTwoDEntityId) REFERENCES MacroStabilityInwardsSoilProfileTwoDEntity (MacroStabilityInwardsSoilProfileTwoDEntityId) ON DELETE Cascade ON UPDATE Cascade + ) ; CREATE TABLE MacroStabilityInwardsSoilLayerOneDEntity ( - MacroStabilityInwardsSoilLayerOneDEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - MacroStabilityInwardsSoilProfileOneDEntityId INTEGER NOT NULL, - Top REAL NULL, - IsAquifer TINYINT (1) NOT NULL, -- true or false - Color INTEGER NULL, -- ARGB value of Color. - MaterialName TEXT NOT NULL COLLATE NOCASE, - ShearStrengthModel TINYINT (1) NOT NULL, -- Enumtype: 1 = SuCalculated, 2 = CPhi, 3 = CPhiOrSuCalculated - UsePop TINYINT (1) NOT NULL, -- true of false - AbovePhreaticLevelMean REAL NULL, - AbovePhreaticLevelCoefficientOfVariation REAL NULL, - AbovePhreaticLevelShift REAL NULL, - BelowPhreaticLevelMean REAL NULL, - BelowPhreaticLevelCoefficientOfVariation REAL NULL, - BelowPhreaticLevelShift REAL NULL, - CohesionMean REAL NULL, - CohesionCoefficientOfVariation REAL NULL, - FrictionAngleMean REAL NULL, - FrictionAngleCoefficientOfVariation REAL NULL, - ShearStrengthRatioMean REAL NULL, - ShearStrengthRatioCoefficientOfVariation REAL NULL, - StrengthIncreaseExponentMean REAL NULL, - StrengthIncreaseExponentCoefficientOfVariation REAL NULL, - PopMean REAL NULL, - PopCoefficientOfVariation REAL NULL, - 'Order' INT (4) NOT NULL, - CONSTRAINT FK_MacroStabilityInwardsSoilLayerOneDEntity_MacroStabilityInwardsSoilProfileOneDEntity FOREIGN KEY (MacroStabilityInwardsSoilProfileOneDEntityId) REFERENCES MacroStabilityInwardsSoilProfileOneDEntity (MacroStabilityInwardsSoilProfileOneDEntityId) ON DELETE Cascade ON UPDATE Cascade -) + MacroStabilityInwardsSoilLayerOneDEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + MacroStabilityInwardsSoilProfileOneDEntityId INTEGER NOT NULL, + Top REAL NULL, + IsAquifer TINYINT (1) NOT NULL, -- true or false + Color INTEGER NULL, -- ARGB value of Color. + MaterialName TEXT NOT NULL COLLATE NOCASE, + ShearStrengthModel TINYINT (1) NOT NULL, -- Enumtype: 1 = SuCalculated, 2 = CPhi, 3 = CPhiOrSuCalculated + UsePop TINYINT (1) NOT NULL, -- true of false + AbovePhreaticLevelMean REAL NULL, + AbovePhreaticLevelCoefficientOfVariation REAL NULL, + AbovePhreaticLevelShift REAL NULL, + BelowPhreaticLevelMean REAL NULL, + BelowPhreaticLevelCoefficientOfVariation REAL NULL, + BelowPhreaticLevelShift REAL NULL, + CohesionMean REAL NULL, + CohesionCoefficientOfVariation REAL NULL, + FrictionAngleMean REAL NULL, + FrictionAngleCoefficientOfVariation REAL NULL, + ShearStrengthRatioMean REAL NULL, + ShearStrengthRatioCoefficientOfVariation REAL NULL, + StrengthIncreaseExponentMean REAL NULL, + StrengthIncreaseExponentCoefficientOfVariation REAL NULL, + PopMean REAL NULL, + PopCoefficientOfVariation REAL NULL, 'Order' + INT +( + 4 +) NOT NULL, + CONSTRAINT FK_MacroStabilityInwardsSoilLayerOneDEntity_MacroStabilityInwardsSoilProfileOneDEntity FOREIGN KEY (MacroStabilityInwardsSoilProfileOneDEntityId) REFERENCES MacroStabilityInwardsSoilProfileOneDEntity (MacroStabilityInwardsSoilProfileOneDEntityId) ON DELETE Cascade ON UPDATE Cascade + ) ; CREATE TABLE MacroStabilityInwardsSoilLayerTwoDEntity ( - MacroStabilityInwardsSoilLayerTwoDEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - ParentMacroStabilityInwardsSoilLayerTwoDEntityId INTEGER NULL, - IsAquifer TINYINT (1) NOT NULL, -- true or false - Color INTEGER NULL, -- ARGB value of Color. - MaterialName TEXT NOT NULL COLLATE NOCASE, - ShearStrengthModel TINYINT (1) NOT NULL, -- Enumtype: 1 = SuCalculated, 2 = CPhi, 3 = CPhiOrSuCalculated - UsePop TINYINT (1) NOT NULL, -- true of false - AbovePhreaticLevelMean REAL NULL, - AbovePhreaticLevelCoefficientOfVariation REAL NULL, - AbovePhreaticLevelShift REAL NULL, - BelowPhreaticLevelMean REAL NULL, - BelowPhreaticLevelCoefficientOfVariation REAL NULL, - BelowPhreaticLevelShift REAL NULL, - CohesionMean REAL NULL, - CohesionCoefficientOfVariation REAL NULL, - FrictionAngleMean REAL NULL, - FrictionAngleCoefficientOfVariation REAL NULL, - ShearStrengthRatioMean REAL NULL, - ShearStrengthRatioCoefficientOfVariation REAL NULL, - StrengthIncreaseExponentMean REAL NULL, - StrengthIncreaseExponentCoefficientOfVariation REAL NULL, - PopMean REAL NULL, - PopCoefficientOfVariation REAL NULL, - OuterRingXml TEXT NOT NULL COLLATE NOCASE, - 'Order' INT (4) NOT NULL, - CONSTRAINT FK_MacroStabilityInwardsSoilLayerTwoDEntity_MacroStabilityInwardsSoilLayerTwoDEntity FOREIGN KEY (ParentMacroStabilityInwardsSoilLayerTwoDEntityId) REFERENCES MacroStabilityInwardsSoilLayerTwoDEntity (MacroStabilityInwardsSoilLayerTwoDEntityId) ON DELETE Cascade ON UPDATE Cascade -) + MacroStabilityInwardsSoilLayerTwoDEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + ParentMacroStabilityInwardsSoilLayerTwoDEntityId INTEGER NULL, + IsAquifer TINYINT (1) NOT NULL, -- true or false + Color INTEGER NULL, -- ARGB value of Color. + MaterialName TEXT NOT NULL COLLATE NOCASE, + ShearStrengthModel TINYINT (1) NOT NULL, -- Enumtype: 1 = SuCalculated, 2 = CPhi, 3 = CPhiOrSuCalculated + UsePop TINYINT (1) NOT NULL, -- true of false + AbovePhreaticLevelMean REAL NULL, + AbovePhreaticLevelCoefficientOfVariation REAL NULL, + AbovePhreaticLevelShift REAL NULL, + BelowPhreaticLevelMean REAL NULL, + BelowPhreaticLevelCoefficientOfVariation REAL NULL, + BelowPhreaticLevelShift REAL NULL, + CohesionMean REAL NULL, + CohesionCoefficientOfVariation REAL NULL, + FrictionAngleMean REAL NULL, + FrictionAngleCoefficientOfVariation REAL NULL, + ShearStrengthRatioMean REAL NULL, + ShearStrengthRatioCoefficientOfVariation REAL NULL, + StrengthIncreaseExponentMean REAL NULL, + StrengthIncreaseExponentCoefficientOfVariation REAL NULL, + PopMean REAL NULL, + PopCoefficientOfVariation REAL NULL, + OuterRingXml TEXT NOT NULL COLLATE NOCASE, 'Order' + INT +( + 4 +) NOT NULL, + CONSTRAINT FK_MacroStabilityInwardsSoilLayerTwoDEntity_MacroStabilityInwardsSoilLayerTwoDEntity FOREIGN KEY (ParentMacroStabilityInwardsSoilLayerTwoDEntityId) REFERENCES MacroStabilityInwardsSoilLayerTwoDEntity (MacroStabilityInwardsSoilLayerTwoDEntityId) ON DELETE Cascade ON UPDATE Cascade + ) ; CREATE TABLE MacroStabilityInwardsSoilProfileOneDEntity ( - MacroStabilityInwardsSoilProfileOneDEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - Name TEXT NOT NULL COLLATE NOCASE, - Bottom REAL NULL + MacroStabilityInwardsSoilProfileOneDEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + Name TEXT NOT NULL COLLATE NOCASE, + Bottom REAL NULL ) ; CREATE TABLE MacroStabilityInwardsSoilProfileTwoDEntity ( - MacroStabilityInwardsSoilProfileTwoDEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - Name TEXT NOT NULL COLLATE NOCASE + MacroStabilityInwardsSoilProfileTwoDEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + Name TEXT NOT NULL COLLATE NOCASE ) ; CREATE TABLE MacroStabilityInwardsSoilProfileTwoDSoilLayerTwoDEntity ( - MacroStabilityInwardsSoilProfileTwoDEntityId INTEGER NOT NULL, - MacroStabilityInwardsSoilLayerTwoDEntityId INTEGER NOT NULL, - CONSTRAINT PK_MacroStabilityInwardsSoilProfileTwoDSoilLayerTwoDEntity PRIMARY KEY (MacroStabilityInwardsSoilProfileTwoDEntityId,MacroStabilityInwardsSoilLayerTwoDEntityId), - CONSTRAINT FK_MacroStabilityInwardsSoilProfileTwoDSoilLayerTwoDEntity_MacroStabilityInwardsSoilLayerTwoDEntity FOREIGN KEY (MacroStabilityInwardsSoilLayerTwoDEntityId) REFERENCES MacroStabilityInwardsSoilLayerTwoDEntity (MacroStabilityInwardsSoilLayerTwoDEntityId) ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT FK_MacroStabilityInwardsSoilProfileTwoDSoilLayerTwoDEntity_MacroStabilityInwardsSoilProfileTwoDEntity FOREIGN KEY (MacroStabilityInwardsSoilProfileTwoDEntityId) REFERENCES MacroStabilityInwardsSoilProfileTwoDEntity (MacroStabilityInwardsSoilProfileTwoDEntityId) ON DELETE Cascade ON UPDATE Cascade + MacroStabilityInwardsSoilProfileTwoDEntityId INTEGER NOT NULL, + MacroStabilityInwardsSoilLayerTwoDEntityId INTEGER NOT NULL, + CONSTRAINT PK_MacroStabilityInwardsSoilProfileTwoDSoilLayerTwoDEntity PRIMARY KEY (MacroStabilityInwardsSoilProfileTwoDEntityId, + MacroStabilityInwardsSoilLayerTwoDEntityId), + CONSTRAINT FK_MacroStabilityInwardsSoilProfileTwoDSoilLayerTwoDEntity_MacroStabilityInwardsSoilLayerTwoDEntity FOREIGN KEY (MacroStabilityInwardsSoilLayerTwoDEntityId) REFERENCES MacroStabilityInwardsSoilLayerTwoDEntity (MacroStabilityInwardsSoilLayerTwoDEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT FK_MacroStabilityInwardsSoilProfileTwoDSoilLayerTwoDEntity_MacroStabilityInwardsSoilProfileTwoDEntity FOREIGN KEY (MacroStabilityInwardsSoilProfileTwoDEntityId) REFERENCES MacroStabilityInwardsSoilProfileTwoDEntity (MacroStabilityInwardsSoilProfileTwoDEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; CREATE TABLE MacroStabilityInwardsStochasticSoilProfileEntity ( - MacroStabilityInwardsStochasticSoilProfileEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - StochasticSoilModelEntityId INTEGER NOT NULL, - MacroStabilityInwardsSoilProfileOneDEntityId INTEGER NULL, - MacroStabilityInwardsSoilProfileTwoDEntityId INTEGER NULL, - Probability REAL NOT NULL, - 'Order' INT (4) NOT NULL, - CONSTRAINT FK_MacroStabilityInwardsStochasticSoilProfileEntity_MacroStabilityInwardsSoilProfileOneDEntity FOREIGN KEY (MacroStabilityInwardsSoilProfileOneDEntityId) REFERENCES MacroStabilityInwardsSoilProfileOneDEntity (MacroStabilityInwardsSoilProfileOneDEntityId) ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT FK_MacroStabilityInwardsStochasticSoilProfileEntity_MacroStabilityInwardsSoilProfileTwoDEntity FOREIGN KEY (MacroStabilityInwardsSoilProfileTwoDEntityId) REFERENCES MacroStabilityInwardsSoilProfileTwoDEntity (MacroStabilityInwardsSoilProfileTwoDEntityId) ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT FK_MacroStabilityInwardsStochasticSoilProfileEntity_StochasticSoilModelEntity FOREIGN KEY (StochasticSoilModelEntityId) REFERENCES StochasticSoilModelEntity (StochasticSoilModelEntityId) ON DELETE Cascade ON UPDATE Cascade -) + MacroStabilityInwardsStochasticSoilProfileEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + StochasticSoilModelEntityId INTEGER NOT NULL, + MacroStabilityInwardsSoilProfileOneDEntityId INTEGER NULL, + MacroStabilityInwardsSoilProfileTwoDEntityId INTEGER NULL, + Probability REAL NOT NULL, 'Order' + INT +( + 4 +) NOT NULL, + CONSTRAINT FK_MacroStabilityInwardsStochasticSoilProfileEntity_MacroStabilityInwardsSoilProfileOneDEntity FOREIGN KEY (MacroStabilityInwardsSoilProfileOneDEntityId) REFERENCES MacroStabilityInwardsSoilProfileOneDEntity (MacroStabilityInwardsSoilProfileOneDEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT FK_MacroStabilityInwardsStochasticSoilProfileEntity_MacroStabilityInwardsSoilProfileTwoDEntity FOREIGN KEY (MacroStabilityInwardsSoilProfileTwoDEntityId) REFERENCES MacroStabilityInwardsSoilProfileTwoDEntity (MacroStabilityInwardsSoilProfileTwoDEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT FK_MacroStabilityInwardsStochasticSoilProfileEntity_StochasticSoilModelEntity FOREIGN KEY (StochasticSoilModelEntityId) REFERENCES StochasticSoilModelEntity (StochasticSoilModelEntityId) ON DELETE Cascade ON UPDATE Cascade + ) ; CREATE TABLE MicrostabilityFailureMechanismMetaEntity ( - MicrostabilityFailureMechanismMetaEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - FailureMechanismEntityId INTEGER NOT NULL, - N REAL NOT NULL, - ApplyLengthEffectInSection TINYINT (1) NOT NULL, - CONSTRAINT FK_MicrostabilityFailureMechanismMetaEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade + MicrostabilityFailureMechanismMetaEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + FailureMechanismEntityId INTEGER NOT NULL, + N REAL NOT NULL, + ApplyLengthEffectInSection TINYINT (1) NOT NULL, + CONSTRAINT FK_MicrostabilityFailureMechanismMetaEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; CREATE TABLE NonAdoptableFailureMechanismSectionResultEntity ( - NonAdoptableFailureMechanismSectionResultEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - FailureMechanismSectionEntityId INTEGER NOT NULL, - IsRelevant TINYINT (1) NOT NULL, -- true or false - InitialFailureMechanismResultType TINYINT (1) NOT NULL, -- Enum: Manual = 1, NoFailureProbability = 2 - ManualInitialFailureMechanismResultSectionProbability REAL NULL, - FurtherAnalysisType TINYINT (1) NOT NULL, -- Enum: NotNecessary = 1 Necessary = 2 Executed = 3 - RefinedSectionProbability REAL NULL, - CONSTRAINT FK_NonAdoptableFailureMechanismSectionResultEntity_FailureMechanismSectionEntity FOREIGN KEY (FailureMechanismSectionEntityId) REFERENCES FailureMechanismSectionEntity (FailureMechanismSectionEntityId) ON DELETE Cascade ON UPDATE Cascade + NonAdoptableFailureMechanismSectionResultEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + FailureMechanismSectionEntityId INTEGER NOT NULL, + IsRelevant TINYINT (1) NOT NULL, -- true or false + InitialFailureMechanismResultType TINYINT (1) NOT NULL, -- Enum: Manual = 1, NoFailureProbability = 2 + ManualInitialFailureMechanismResultSectionProbability REAL NULL, + FurtherAnalysisType TINYINT (1) NOT NULL, -- Enum: NotNecessary = 1 Necessary = 2 Executed = 3 + RefinedSectionProbability REAL NULL, + CONSTRAINT FK_NonAdoptableFailureMechanismSectionResultEntity_FailureMechanismSectionEntity FOREIGN KEY (FailureMechanismSectionEntityId) REFERENCES FailureMechanismSectionEntity (FailureMechanismSectionEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; CREATE TABLE NonAdoptableWithProfileProbabilityFailureMechanismSectionResultEntity ( - NonAdoptableWithProfileProbabilityFailureMechanismSectionResultEntity INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - FailureMechanismSectionEntityId INTEGER NULL, - IsRelevant TINYINT (1) NOT NULL, -- true or false - InitialFailureMechanismResultType TINYINT (1) NOT NULL, -- Enum: Manual = 1 NoFailureProbability = 2 - ManualInitialFailureMechanismResultSectionProbability REAL NULL, - ManualInitialFailureMechanismResultProfileProbability REAL NULL, - FurtherAnalysisType TINYINT (1) NOT NULL, -- Enum: NotNecessary = 1 Necessary = 2 Executed = 3 - RefinedSectionProbability REAL NULL, - RefinedProfileProbability REAL NULL, - CONSTRAINT FK_NonAdoptableWithProfileProbabilityFailureMechanismSectionResultEntity_FailureMechanismSectionEntity FOREIGN KEY (FailureMechanismSectionEntityId) REFERENCES FailureMechanismSectionEntity (FailureMechanismSectionEntityId) ON DELETE Cascade ON UPDATE Cascade + NonAdoptableWithProfileProbabilityFailureMechanismSectionResultEntity INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + FailureMechanismSectionEntityId INTEGER NULL, + IsRelevant TINYINT (1) NOT NULL, -- true or false + InitialFailureMechanismResultType TINYINT (1) NOT NULL, -- Enum: Manual = 1 NoFailureProbability = 2 + ManualInitialFailureMechanismResultSectionProbability REAL NULL, + ManualInitialFailureMechanismResultProfileProbability REAL NULL, + FurtherAnalysisType TINYINT (1) NOT NULL, -- Enum: NotNecessary = 1 Necessary = 2 Executed = 3 + RefinedSectionProbability REAL NULL, + RefinedProfileProbability REAL NULL, + CONSTRAINT FK_NonAdoptableWithProfileProbabilityFailureMechanismSectionResultEntity_FailureMechanismSectionEntity FOREIGN KEY (FailureMechanismSectionEntityId) REFERENCES FailureMechanismSectionEntity (FailureMechanismSectionEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; CREATE TABLE PipingFailureMechanismMetaEntity ( - PipingFailureMechanismMetaEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - FailureMechanismEntityId INTEGER NOT NULL, - A REAL NOT NULL, - WaterVolumetricWeight REAL NOT NULL, - StochasticSoilModelCollectionSourcePath TEXT NULL COLLATE NOCASE, - SurfaceLineCollectionSourcePath TEXT NULL COLLATE NOCASE, - PipingScenarioConfigurationType TINYINT (1) NOT NULL, -- Enum: SemiProbabilistic = 1 Probabilistic = 2 PerFailureMechanismSection = 3 - CONSTRAINT FK_PipingFailureMechanismMetaEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade + PipingFailureMechanismMetaEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + FailureMechanismEntityId INTEGER NOT NULL, + A REAL NOT NULL, + WaterVolumetricWeight REAL NOT NULL, + StochasticSoilModelCollectionSourcePath TEXT NULL COLLATE NOCASE, + SurfaceLineCollectionSourcePath TEXT NULL COLLATE NOCASE, + PipingScenarioConfigurationType TINYINT (1) NOT NULL, -- Enum: SemiProbabilistic = 1 Probabilistic = 2 PerFailureMechanismSection = 3 + CONSTRAINT FK_PipingFailureMechanismMetaEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; CREATE TABLE PipingStructureFailureMechanismMetaEntity ( - PipingStructureFailureMechanismMetaEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - FailureMechanismEntityId INTEGER NOT NULL, - N REAL NOT NULL, - CONSTRAINT FK_PipingStructureFailureMechanismMetaEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade + PipingStructureFailureMechanismMetaEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + FailureMechanismEntityId INTEGER NOT NULL, + N REAL NOT NULL, + CONSTRAINT FK_PipingStructureFailureMechanismMetaEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; CREATE TABLE ProbabilisticPipingCalculationEntity ( - ProbabilisticPipingCalculationEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - CalculationGroupEntityId INTEGER NOT NULL, - SurfaceLineEntityId INTEGER NULL, - PipingStochasticSoilProfileEntityId INTEGER NULL, - HydraulicLocationEntityId INTEGER NULL, - 'Order' INT (4) NOT NULL, - Name VARCHAR (260) NULL, - Comments TEXT NULL COLLATE NOCASE, - EntryPointL REAL NULL, - ExitPointL REAL NULL, - PhreaticLevelExitMean REAL NULL, - PhreaticLevelExitStandardDeviation REAL NULL, - DampingFactorExitMean REAL NULL, - DampingFactorExitStandardDeviation REAL NULL, - RelevantForScenario TINYINT (1) NOT NULL, -- true or false - ScenarioContribution REAL NOT NULL, - ShouldProfileSpecificIllustrationPointsBeCalculated TINYINT (1) NOT NULL, -- true or false - ShouldSectionSpecificIllustrationPointsBeCalculated TINYINT (1) NOT NULL, -- true or false - CONSTRAINT FK_ProbabilisticPipingCalculationEntity_CalculationGroupEntity FOREIGN KEY (CalculationGroupEntityId) REFERENCES CalculationGroupEntity (CalculationGroupEntityId) ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT FK_ProbabilisticPipingCalculationEntity_HydraulicLocationEntity FOREIGN KEY (HydraulicLocationEntityId) REFERENCES HydraulicLocationEntity (HydraulicLocationEntityId) ON DELETE Set Null ON UPDATE Cascade, - CONSTRAINT FK_ProbabilisticPipingCalculationEntity_PipingStochasticSoilProfileEntity FOREIGN KEY (PipingStochasticSoilProfileEntityId) REFERENCES PipingStochasticSoilProfileEntity (PipingStochasticSoilProfileEntityId) ON DELETE Set Null ON UPDATE Cascade, - CONSTRAINT FK_ProbabilisticPipingCalculationEntity_SurfaceLineEntity FOREIGN KEY (SurfaceLineEntityId) REFERENCES SurfaceLineEntity (SurfaceLineEntityId) ON DELETE Set Null ON UPDATE Cascade -) + ProbabilisticPipingCalculationEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + CalculationGroupEntityId INTEGER NOT NULL, + SurfaceLineEntityId INTEGER NULL, + PipingStochasticSoilProfileEntityId INTEGER NULL, + HydraulicLocationEntityId INTEGER NULL, 'Order' + INT +( + 4 +) NOT NULL, + Name VARCHAR(260) NULL, + Comments TEXT NULL COLLATE NOCASE, + EntryPointL REAL NULL, + ExitPointL REAL NULL, + PhreaticLevelExitMean REAL NULL, + PhreaticLevelExitStandardDeviation REAL NULL, + DampingFactorExitMean REAL NULL, + DampingFactorExitStandardDeviation REAL NULL, + RelevantForScenario TINYINT (1) NOT NULL, -- true or false + ScenarioContribution REAL NOT NULL, + ShouldProfileSpecificIllustrationPointsBeCalculated TINYINT (1) NOT NULL, -- true or false + ShouldSectionSpecificIllustrationPointsBeCalculated TINYINT (1) NOT NULL, -- true or false + CONSTRAINT FK_ProbabilisticPipingCalculationEntity_CalculationGroupEntity FOREIGN KEY (CalculationGroupEntityId) REFERENCES CalculationGroupEntity (CalculationGroupEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT FK_ProbabilisticPipingCalculationEntity_HydraulicLocationEntity FOREIGN KEY (HydraulicLocationEntityId) REFERENCES HydraulicLocationEntity (HydraulicLocationEntityId) ON DELETE Set Null ON UPDATE Cascade, + CONSTRAINT FK_ProbabilisticPipingCalculationEntity_PipingStochasticSoilProfileEntity FOREIGN KEY (PipingStochasticSoilProfileEntityId) REFERENCES PipingStochasticSoilProfileEntity (PipingStochasticSoilProfileEntityId) ON DELETE Set Null ON UPDATE Cascade, + CONSTRAINT FK_ProbabilisticPipingCalculationEntity_SurfaceLineEntity FOREIGN KEY (SurfaceLineEntityId) REFERENCES SurfaceLineEntity (SurfaceLineEntityId) ON DELETE Set Null ON UPDATE Cascade + ) ; CREATE TABLE ProbabilisticPipingCalculationOutputEntity ( - ProbabilisticPipingCalculationOutputEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - ProbabilisticPipingCalculationEntityId INTEGER NOT NULL, - ProfileSpecificGeneralResultFaultTreeIllustrationPointEntityId INTEGER NULL, - SectionSpecificGeneralResultFaultTreeIllustrationPointEntityId INTEGER NULL, - ProfileSpecificGeneralResultSubMechanismIllustrationPointEntityId INTEGER NULL, - SectionSpecificGeneralResultSubMechanismIllustrationPointEntityId INTEGER NULL, - 'Order' INT (4) NOT NULL, - ProfileSpecificReliability REAL NULL, - SectionSpecificReliability REAL NULL, - CONSTRAINT FK_ProbabilisticPipingCalculationOutputEntity_ProbabilisticPipingCalculationEntity FOREIGN KEY (ProbabilisticPipingCalculationEntityId) REFERENCES ProbabilisticPipingCalculationEntity (ProbabilisticPipingCalculationEntityId) ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT FK_ProbabilisticPipingCalculationOutputEntity_Profile_GeneralResultFaultTreeIllustrationPointEntity FOREIGN KEY (ProfileSpecificGeneralResultFaultTreeIllustrationPointEntityId) REFERENCES GeneralResultFaultTreeIllustrationPointEntity (GeneralResultFaultTreeIllustrationPointEntityId) ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT FK_ProbabilisticPipingCalculationOutputEntity_Profile_GeneralResultSubMechanismIllustrationPointEntity FOREIGN KEY (ProfileSpecificGeneralResultSubMechanismIllustrationPointEntityId) REFERENCES GeneralResultSubMechanismIllustrationPointEntity (GeneralResultSubMechanismIllustrationPointEntityId) ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT FK_ProbabilisticPipingCalculationOutputEntity_Section_GeneralResultFaultTreeIllustrationPointEntity FOREIGN KEY (SectionSpecificGeneralResultFaultTreeIllustrationPointEntityId) REFERENCES GeneralResultFaultTreeIllustrationPointEntity (GeneralResultFaultTreeIllustrationPointEntityId) ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT FK_ProbabilisticPipingCalculationOutputEntity_Section_GeneralResultSubMechanismIllustrationPointEntity FOREIGN KEY (SectionSpecificGeneralResultSubMechanismIllustrationPointEntityId) REFERENCES GeneralResultSubMechanismIllustrationPointEntity (GeneralResultSubMechanismIllustrationPointEntityId) ON DELETE No Action ON UPDATE No Action, - CONSTRAINT U_ProbabilisticPipingCalculationEntity UNIQUE (ProbabilisticPipingCalculationEntityId) -) + ProbabilisticPipingCalculationOutputEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + ProbabilisticPipingCalculationEntityId INTEGER NOT NULL, + ProfileSpecificGeneralResultFaultTreeIllustrationPointEntityId INTEGER NULL, + SectionSpecificGeneralResultFaultTreeIllustrationPointEntityId INTEGER NULL, + ProfileSpecificGeneralResultSubMechanismIllustrationPointEntityId INTEGER NULL, + SectionSpecificGeneralResultSubMechanismIllustrationPointEntityId INTEGER NULL, 'Order' + INT +( + 4 +) NOT NULL, + ProfileSpecificReliability REAL NULL, + SectionSpecificReliability REAL NULL, + CONSTRAINT FK_ProbabilisticPipingCalculationOutputEntity_ProbabilisticPipingCalculationEntity FOREIGN KEY (ProbabilisticPipingCalculationEntityId) REFERENCES ProbabilisticPipingCalculationEntity (ProbabilisticPipingCalculationEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT FK_ProbabilisticPipingCalculationOutputEntity_Profile_GeneralResultFaultTreeIllustrationPointEntity FOREIGN KEY (ProfileSpecificGeneralResultFaultTreeIllustrationPointEntityId) REFERENCES GeneralResultFaultTreeIllustrationPointEntity (GeneralResultFaultTreeIllustrationPointEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT FK_ProbabilisticPipingCalculationOutputEntity_Profile_GeneralResultSubMechanismIllustrationPointEntity FOREIGN KEY (ProfileSpecificGeneralResultSubMechanismIllustrationPointEntityId) REFERENCES GeneralResultSubMechanismIllustrationPointEntity (GeneralResultSubMechanismIllustrationPointEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT FK_ProbabilisticPipingCalculationOutputEntity_Section_GeneralResultFaultTreeIllustrationPointEntity FOREIGN KEY (SectionSpecificGeneralResultFaultTreeIllustrationPointEntityId) REFERENCES GeneralResultFaultTreeIllustrationPointEntity (GeneralResultFaultTreeIllustrationPointEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT FK_ProbabilisticPipingCalculationOutputEntity_Section_GeneralResultSubMechanismIllustrationPointEntity FOREIGN KEY (SectionSpecificGeneralResultSubMechanismIllustrationPointEntityId) REFERENCES GeneralResultSubMechanismIllustrationPointEntity (GeneralResultSubMechanismIllustrationPointEntityId) ON DELETE No Action ON UPDATE No Action, + CONSTRAINT U_ProbabilisticPipingCalculationEntity UNIQUE (ProbabilisticPipingCalculationEntityId) + ) ; CREATE TABLE SemiProbabilisticPipingCalculationOutputEntity ( - SemiProbabilisticPipingCalculationOutputEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - SemiProbabilisticPipingCalculationEntityId INTEGER NOT NULL, - 'Order' INT (4) NOT NULL, - HeaveFactorOfSafety REAL NULL, - UpliftFactorOfSafety REAL NULL, - SellmeijerFactorOfSafety REAL NULL, - UpliftEffectiveStress REAL NULL, - HeaveGradient REAL NULL, - SellmeijerCreepCoefficient REAL NULL, - SellmeijerCriticalFall REAL NULL, - SellmeijerReducedFall REAL NULL, - CONSTRAINT FK_SemiProbabilisticPipingCalculationOutputEntity_SemiProbabilisticPipingCalculationEntity FOREIGN KEY (SemiProbabilisticPipingCalculationEntityId) REFERENCES SemiProbabilisticPipingCalculationEntity (SemiProbabilisticPipingCalculationEntityId) ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT U_SemiProbabilisticPipingCalculationEntity UNIQUE (SemiProbabilisticPipingCalculationEntityId) -) + SemiProbabilisticPipingCalculationOutputEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + SemiProbabilisticPipingCalculationEntityId INTEGER NOT NULL, 'Order' + INT +( + 4 +) NOT NULL, + HeaveFactorOfSafety REAL NULL, + UpliftFactorOfSafety REAL NULL, + SellmeijerFactorOfSafety REAL NULL, + UpliftEffectiveStress REAL NULL, + HeaveGradient REAL NULL, + SellmeijerCreepCoefficient REAL NULL, + SellmeijerCriticalFall REAL NULL, + SellmeijerReducedFall REAL NULL, + CONSTRAINT FK_SemiProbabilisticPipingCalculationOutputEntity_SemiProbabilisticPipingCalculationEntity FOREIGN KEY (SemiProbabilisticPipingCalculationEntityId) REFERENCES SemiProbabilisticPipingCalculationEntity (SemiProbabilisticPipingCalculationEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT U_SemiProbabilisticPipingCalculationEntity UNIQUE (SemiProbabilisticPipingCalculationEntityId) + ) ; CREATE TABLE SpecificFailureMechanismEntity ( - SpecificFailureMechanismEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - AssessmentSectionEntityId INTEGER NOT NULL, - Name VARCHAR (260) NULL, - Code VARCHAR (260) NULL, - 'Order' INT (4) NOT NULL, - InAssembly TINYINT (1) NOT NULL, -- true or false - FailureMechanismSectionCollectionSourcePath TEXT NULL COLLATE NOCASE, - InAssemblyInputComments TEXT NULL COLLATE NOCASE, - InAssemblyOutputComments TEXT NULL COLLATE NOCASE, - NotInAssemblyComments TEXT NULL COLLATE NOCASE, - N REAL NOT NULL, - FailureMechanismAssemblyResultProbabilityResultType TINYINT (1) NOT NULL, -- Enum: None = 1, P1 = 2, P2 = 3, Manual = 4 - FailureMechanismAssemblyResultManualFailureMechanismAssemblyProbability REAL NULL, - ApplyLengthEffectInSection TINYINT (1) NOT NULL, - CONSTRAINT FK_SpecificFailureMechanismEntity_AssessmentSectionEntity FOREIGN KEY (AssessmentSectionEntityId) REFERENCES AssessmentSectionEntity (AssessmentSectionEntityId) ON DELETE Cascade ON UPDATE Cascade -) + SpecificFailureMechanismEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + AssessmentSectionEntityId INTEGER NOT NULL, + Name VARCHAR(260) NULL, + Code VARCHAR(260) NULL, 'Order' + INT +( + 4 +) NOT NULL, + InAssembly TINYINT (1) NOT NULL, -- true or false + FailureMechanismSectionCollectionSourcePath TEXT NULL COLLATE NOCASE, + InAssemblyInputComments TEXT NULL COLLATE NOCASE, + InAssemblyOutputComments TEXT NULL COLLATE NOCASE, + NotInAssemblyComments TEXT NULL COLLATE NOCASE, + N REAL NOT NULL, + FailureMechanismAssemblyResultProbabilityResultType TINYINT (1) NOT NULL, -- Enum: None = 1, P1 = 2, P2 = 3, Manual = 4 + FailureMechanismAssemblyResultManualFailureMechanismAssemblyProbability REAL NULL, + ApplyLengthEffectInSection TINYINT (1) NOT NULL, + CONSTRAINT FK_SpecificFailureMechanismEntity_AssessmentSectionEntity FOREIGN KEY (AssessmentSectionEntityId) REFERENCES AssessmentSectionEntity (AssessmentSectionEntityId) ON DELETE Cascade ON UPDATE Cascade + ) ; CREATE TABLE SpecificFailureMechanismFailureMechanismSectionEntity ( - SpecificFailureMechanismEntityId INTEGER NOT NULL, - FailureMechanismSectionEntityId INTEGER NOT NULL, - CONSTRAINT PK_SpecificFailureMechanismFailureMechanismSectionEntity PRIMARY KEY (SpecificFailureMechanismEntityId,FailureMechanismSectionEntityId), - CONSTRAINT FK_SpecificFailureMechanismFailureMechanismSectionEntity_FailureMechanismSectionEntity FOREIGN KEY (FailureMechanismSectionEntityId) REFERENCES FailureMechanismSectionEntity (FailureMechanismSectionEntityId) ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT FK_SpecificFailureMechanismFailureMechanismSectionEntity_SpecificFailureMechanismEntity FOREIGN KEY (SpecificFailureMechanismEntityId) REFERENCES SpecificFailureMechanismEntity (SpecificFailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade + SpecificFailureMechanismEntityId INTEGER NOT NULL, + FailureMechanismSectionEntityId INTEGER NOT NULL, + CONSTRAINT PK_SpecificFailureMechanismFailureMechanismSectionEntity PRIMARY KEY (SpecificFailureMechanismEntityId, FailureMechanismSectionEntityId), + CONSTRAINT FK_SpecificFailureMechanismFailureMechanismSectionEntity_FailureMechanismSectionEntity FOREIGN KEY (FailureMechanismSectionEntityId) REFERENCES FailureMechanismSectionEntity (FailureMechanismSectionEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT FK_SpecificFailureMechanismFailureMechanismSectionEntity_SpecificFailureMechanismEntity FOREIGN KEY (SpecificFailureMechanismEntityId) REFERENCES SpecificFailureMechanismEntity (SpecificFailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; CREATE TABLE StabilityPointStructureEntity ( - StabilityPointStructureEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - FailureMechanismEntityId INTEGER NOT NULL, - 'Order' INT (4) NOT NULL, - Name VARCHAR (260) NOT NULL, - Id VARCHAR (260) NOT NULL, - X REAL NULL, - Y REAL NULL, - StructureNormalOrientation REAL NULL, - StorageStructureAreaMean REAL NULL, - StorageStructureAreaCoefficientOfVariation REAL NULL, - AllowedLevelIncreaseStorageMean REAL NULL, - AllowedLevelIncreaseStorageStandardDeviation REAL NULL, - WidthFlowAperturesMean REAL NULL, - WidthFlowAperturesStandardDeviation REAL NULL, - InsideWaterLevelMean REAL NULL, - InsideWaterLevelStandardDeviation REAL NULL, - ThresholdHeightOpenWeirMean REAL NULL, - ThresholdHeightOpenWeirStandardDeviation REAL NULL, - CriticalOvertoppingDischargeMean REAL NULL, - CriticalOvertoppingDischargeCoefficientOfVariation REAL NULL, - FlowWidthAtBottomProtectionMean REAL NULL, - FlowWidthAtBottomProtectionStandardDeviation REAL NULL, - ConstructiveStrengthLinearLoadModelMean REAL NULL, - ConstructiveStrengthLinearLoadModelCoefficientOfVariation REAL NULL, - ConstructiveStrengthQuadraticLoadModelMean REAL NULL, - ConstructiveStrengthQuadraticLoadModelCoefficientOfVariation REAL NULL, - BankWidthMean REAL NULL, - BankWidthStandardDeviation REAL NULL, - InsideWaterLevelFailureConstructionMean REAL NULL, - InsideWaterLevelFailureConstructionStandardDeviation REAL NULL, - EvaluationLevel REAL NULL, - LevelCrestStructureMean REAL NULL, - LevelCrestStructureStandardDeviation REAL NULL, - VerticalDistance REAL NULL, - FailureProbabilityRepairClosure REAL NULL, - FailureCollisionEnergyMean REAL NULL, - FailureCollisionEnergyCoefficientOfVariation REAL NULL, - ShipMassMean REAL NULL, - ShipMassCoefficientOfVariation REAL NULL, - ShipVelocityMean REAL NULL, - ShipVelocityCoefficientOfVariation REAL NULL, - LevellingCount INT (4) NOT NULL, - ProbabilityCollisionSecondaryStructure REAL NULL, - FlowVelocityStructureClosableMean REAL NULL, - StabilityLinearLoadModelMean REAL NULL, - StabilityLinearLoadModelCoefficientOfVariation REAL NULL, - StabilityQuadraticLoadModelMean REAL NULL, - StabilityQuadraticLoadModelCoefficientOfVariation REAL NULL, - AreaFlowAperturesMean REAL NULL, - AreaFlowAperturesStandardDeviation REAL NULL, - InflowModelType TINYINT (1) NOT NULL, -- Enum: 1 = LowSill, 2 = FloodedCulvert - CONSTRAINT FK_StabilityPointStructureEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT U_Id_FailureMechanismEntityId UNIQUE (FailureMechanismEntityId,Id) -) + StabilityPointStructureEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + FailureMechanismEntityId INTEGER NOT NULL, 'Order' + INT +( + 4 +) NOT NULL, + Name VARCHAR(260) NOT NULL, + Id VARCHAR(260) NOT NULL, + X REAL NULL, + Y REAL NULL, + StructureNormalOrientation REAL NULL, + StorageStructureAreaMean REAL NULL, + StorageStructureAreaCoefficientOfVariation REAL NULL, + AllowedLevelIncreaseStorageMean REAL NULL, + AllowedLevelIncreaseStorageStandardDeviation REAL NULL, + WidthFlowAperturesMean REAL NULL, + WidthFlowAperturesStandardDeviation REAL NULL, + InsideWaterLevelMean REAL NULL, + InsideWaterLevelStandardDeviation REAL NULL, + ThresholdHeightOpenWeirMean REAL NULL, + ThresholdHeightOpenWeirStandardDeviation REAL NULL, + CriticalOvertoppingDischargeMean REAL NULL, + CriticalOvertoppingDischargeCoefficientOfVariation REAL NULL, + FlowWidthAtBottomProtectionMean REAL NULL, + FlowWidthAtBottomProtectionStandardDeviation REAL NULL, + ConstructiveStrengthLinearLoadModelMean REAL NULL, + ConstructiveStrengthLinearLoadModelCoefficientOfVariation REAL NULL, + ConstructiveStrengthQuadraticLoadModelMean REAL NULL, + ConstructiveStrengthQuadraticLoadModelCoefficientOfVariation REAL NULL, + BankWidthMean REAL NULL, + BankWidthStandardDeviation REAL NULL, + InsideWaterLevelFailureConstructionMean REAL NULL, + InsideWaterLevelFailureConstructionStandardDeviation REAL NULL, + EvaluationLevel REAL NULL, + LevelCrestStructureMean REAL NULL, + LevelCrestStructureStandardDeviation REAL NULL, + VerticalDistance REAL NULL, + FailureProbabilityRepairClosure REAL NULL, + FailureCollisionEnergyMean REAL NULL, + FailureCollisionEnergyCoefficientOfVariation REAL NULL, + ShipMassMean REAL NULL, + ShipMassCoefficientOfVariation REAL NULL, + ShipVelocityMean REAL NULL, + ShipVelocityCoefficientOfVariation REAL NULL, + LevellingCount INT (4) NOT NULL, + ProbabilityCollisionSecondaryStructure REAL NULL, + FlowVelocityStructureClosableMean REAL NULL, + StabilityLinearLoadModelMean REAL NULL, + StabilityLinearLoadModelCoefficientOfVariation REAL NULL, + StabilityQuadraticLoadModelMean REAL NULL, + StabilityQuadraticLoadModelCoefficientOfVariation REAL NULL, + AreaFlowAperturesMean REAL NULL, + AreaFlowAperturesStandardDeviation REAL NULL, + InflowModelType TINYINT (1) NOT NULL, -- Enum: 1 = LowSill, 2 = FloodedCulvert + CONSTRAINT FK_StabilityPointStructureEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT U_Id_FailureMechanismEntityId UNIQUE (FailureMechanismEntityId, Id) + ) ; CREATE TABLE StabilityPointStructuresCalculationEntity ( - StabilityPointStructuresCalculationEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - CalculationGroupEntityId INTEGER NOT NULL, - ForeshoreProfileEntityId INTEGER NULL, - HydraulicLocationEntityId INTEGER NULL, - StabilityPointStructureEntityId INTEGER NULL, - 'Order' INT (4) NOT NULL, - Name VARCHAR (260) NULL, - Comments TEXT NULL COLLATE NOCASE, - UseBreakWater TINYINT (1) NOT NULL, -- true or false - BreakWaterType TINYINT (1) NOT NULL, -- Enum: 1 = Wall, 2 = Caisson, 3 = Dam - BreakWaterHeight REAL NULL, - UseForeshore TINYINT (1) NOT NULL, -- true or false - StructureNormalOrientation REAL NULL, - StorageStructureAreaMean REAL NULL, - StorageStructureAreaCoefficientOfVariation REAL NULL, - AllowedLevelIncreaseStorageMean REAL NULL, - AllowedLevelIncreaseStorageStandardDeviation REAL NULL, - WidthFlowAperturesMean REAL NULL, - WidthFlowAperturesStandardDeviation REAL NULL, - InsideWaterLevelMean REAL NULL, - InsideWaterLevelStandardDeviation REAL NULL, - ThresholdHeightOpenWeirMean REAL NULL, - ThresholdHeightOpenWeirStandardDeviation REAL NULL, - CriticalOvertoppingDischargeMean REAL NULL, - CriticalOvertoppingDischargeCoefficientOfVariation REAL NULL, - FlowWidthAtBottomProtectionMean REAL NULL, - FlowWidthAtBottomProtectionStandardDeviation REAL NULL, - ConstructiveStrengthLinearLoadModelMean REAL NULL, - ConstructiveStrengthLinearLoadModelCoefficientOfVariation REAL NULL, - ConstructiveStrengthQuadraticLoadModelMean REAL NULL, - ConstructiveStrengthQuadraticLoadModelCoefficientOfVariation REAL NULL, - BankWidthMean REAL NULL, - BankWidthStandardDeviation REAL NULL, - InsideWaterLevelFailureConstructionMean REAL NULL, - InsideWaterLevelFailureConstructionStandardDeviation REAL NULL, - EvaluationLevel REAL NULL, - LevelCrestStructureMean REAL NULL, - LevelCrestStructureStandardDeviation REAL NULL, - VerticalDistance REAL NULL, - FailureProbabilityRepairClosure REAL NOT NULL, - FailureCollisionEnergyMean REAL NULL, - FailureCollisionEnergyCoefficientOfVariation REAL NULL, - ShipMassMean REAL NULL, - ShipMassCoefficientOfVariation REAL NULL, - ShipVelocityMean REAL NULL, - ShipVelocityCoefficientOfVariation REAL NULL, - LevellingCount INT (4) NOT NULL, - ProbabilityCollisionSecondaryStructure REAL NOT NULL, - FlowVelocityStructureClosableMean REAL NULL, - StabilityLinearLoadModelMean REAL NULL, - StabilityLinearLoadModelCoefficientOfVariation REAL NULL, - StabilityQuadraticLoadModelMean REAL NULL, - StabilityQuadraticLoadModelCoefficientOfVariation REAL NULL, - AreaFlowAperturesMean REAL NULL, - AreaFlowAperturesStandardDeviation REAL NULL, - InflowModelType TINYINT (1) NOT NULL, -- Enum: 1 = VerticalWall, 2 = LowSill, 3 = FloodedCulvert - LoadSchematizationType TINYINT (1) NOT NULL, -- Enum: 1 = Linear, 2 = Quadratic - VolumicWeightWater REAL NULL, - StormDurationMean REAL NULL, - FactorStormDurationOpenStructure REAL NULL, - DrainCoefficientMean REAL NULL, - DrainCoefficientStandardDeviation REAL NULL, - FailureProbabilityStructureWithErosion REAL NOT NULL, - ShouldIllustrationPointsBeCalculated TINYINT (1) NOT NULL, -- true or false - RelevantForScenario TINYINT (1) NOT NULL, -- true or false - ScenarioContribution REAL NOT NULL, - CONSTRAINT FK_StabilityPointStructuresCalculationEntity_CalculationGroupEntity FOREIGN KEY (CalculationGroupEntityId) REFERENCES CalculationGroupEntity (CalculationGroupEntityId) ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT FK_StabilityPointStructuresCalculationEntity_ForeshoreProfileEntity FOREIGN KEY (ForeshoreProfileEntityId) REFERENCES ForeshoreProfileEntity (ForeshoreProfileEntityId) ON DELETE Set Null ON UPDATE Cascade, - CONSTRAINT FK_StabilityPointStructuresCalculationEntity_HydraulicLocationEntity FOREIGN KEY (HydraulicLocationEntityId) REFERENCES HydraulicLocationEntity (HydraulicLocationEntityId) ON DELETE Set Null ON UPDATE Cascade, - CONSTRAINT FK_StabilityPointStructuresCalculationEntity_StabilityPointStructureEntity FOREIGN KEY (StabilityPointStructureEntityId) REFERENCES StabilityPointStructureEntity (StabilityPointStructureEntityId) ON DELETE Set Null ON UPDATE Cascade -) + StabilityPointStructuresCalculationEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + CalculationGroupEntityId INTEGER NOT NULL, + ForeshoreProfileEntityId INTEGER NULL, + HydraulicLocationEntityId INTEGER NULL, + StabilityPointStructureEntityId INTEGER NULL, 'Order' + INT +( + 4 +) NOT NULL, + Name VARCHAR(260) NULL, + Comments TEXT NULL COLLATE NOCASE, + UseBreakWater TINYINT (1) NOT NULL, -- true or false + BreakWaterType TINYINT (1) NOT NULL, -- Enum: 1 = Wall, 2 = Caisson, 3 = Dam + BreakWaterHeight REAL NULL, + UseForeshore TINYINT (1) NOT NULL, -- true or false + StructureNormalOrientation REAL NULL, + StorageStructureAreaMean REAL NULL, + StorageStructureAreaCoefficientOfVariation REAL NULL, + AllowedLevelIncreaseStorageMean REAL NULL, + AllowedLevelIncreaseStorageStandardDeviation REAL NULL, + WidthFlowAperturesMean REAL NULL, + WidthFlowAperturesStandardDeviation REAL NULL, + InsideWaterLevelMean REAL NULL, + InsideWaterLevelStandardDeviation REAL NULL, + ThresholdHeightOpenWeirMean REAL NULL, + ThresholdHeightOpenWeirStandardDeviation REAL NULL, + CriticalOvertoppingDischargeMean REAL NULL, + CriticalOvertoppingDischargeCoefficientOfVariation REAL NULL, + FlowWidthAtBottomProtectionMean REAL NULL, + FlowWidthAtBottomProtectionStandardDeviation REAL NULL, + ConstructiveStrengthLinearLoadModelMean REAL NULL, + ConstructiveStrengthLinearLoadModelCoefficientOfVariation REAL NULL, + ConstructiveStrengthQuadraticLoadModelMean REAL NULL, + ConstructiveStrengthQuadraticLoadModelCoefficientOfVariation REAL NULL, + BankWidthMean REAL NULL, + BankWidthStandardDeviation REAL NULL, + InsideWaterLevelFailureConstructionMean REAL NULL, + InsideWaterLevelFailureConstructionStandardDeviation REAL NULL, + EvaluationLevel REAL NULL, + LevelCrestStructureMean REAL NULL, + LevelCrestStructureStandardDeviation REAL NULL, + VerticalDistance REAL NULL, + FailureProbabilityRepairClosure REAL NOT NULL, + FailureCollisionEnergyMean REAL NULL, + FailureCollisionEnergyCoefficientOfVariation REAL NULL, + ShipMassMean REAL NULL, + ShipMassCoefficientOfVariation REAL NULL, + ShipVelocityMean REAL NULL, + ShipVelocityCoefficientOfVariation REAL NULL, + LevellingCount INT (4) NOT NULL, + ProbabilityCollisionSecondaryStructure REAL NOT NULL, + FlowVelocityStructureClosableMean REAL NULL, + StabilityLinearLoadModelMean REAL NULL, + StabilityLinearLoadModelCoefficientOfVariation REAL NULL, + StabilityQuadraticLoadModelMean REAL NULL, + StabilityQuadraticLoadModelCoefficientOfVariation REAL NULL, + AreaFlowAperturesMean REAL NULL, + AreaFlowAperturesStandardDeviation REAL NULL, + InflowModelType TINYINT (1) NOT NULL, -- Enum: 1 = VerticalWall, 2 = LowSill, 3 = FloodedCulvert + LoadSchematizationType TINYINT (1) NOT NULL, -- Enum: 1 = Linear, 2 = Quadratic + VolumicWeightWater REAL NULL, + StormDurationMean REAL NULL, + FactorStormDurationOpenStructure REAL NULL, + DrainCoefficientMean REAL NULL, + DrainCoefficientStandardDeviation REAL NULL, + FailureProbabilityStructureWithErosion REAL NOT NULL, + ShouldIllustrationPointsBeCalculated TINYINT (1) NOT NULL, -- true or false + RelevantForScenario TINYINT (1) NOT NULL, -- true or false + ScenarioContribution REAL NOT NULL, + CONSTRAINT FK_StabilityPointStructuresCalculationEntity_CalculationGroupEntity FOREIGN KEY (CalculationGroupEntityId) REFERENCES CalculationGroupEntity (CalculationGroupEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT FK_StabilityPointStructuresCalculationEntity_ForeshoreProfileEntity FOREIGN KEY (ForeshoreProfileEntityId) REFERENCES ForeshoreProfileEntity (ForeshoreProfileEntityId) ON DELETE Set Null ON UPDATE Cascade, + CONSTRAINT FK_StabilityPointStructuresCalculationEntity_HydraulicLocationEntity FOREIGN KEY (HydraulicLocationEntityId) REFERENCES HydraulicLocationEntity (HydraulicLocationEntityId) ON DELETE Set Null ON UPDATE Cascade, + CONSTRAINT FK_StabilityPointStructuresCalculationEntity_StabilityPointStructureEntity FOREIGN KEY (StabilityPointStructureEntityId) REFERENCES StabilityPointStructureEntity (StabilityPointStructureEntityId) ON DELETE Set Null ON UPDATE Cascade + ) ; CREATE TABLE StabilityPointStructuresFailureMechanismMetaEntity ( - StabilityPointStructuresFailureMechanismMetaEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - FailureMechanismEntityId INTEGER NOT NULL, - N REAL NOT NULL, - ForeshoreProfileCollectionSourcePath TEXT NULL COLLATE NOCASE, - StabilityPointStructureCollectionSourcePath TEXT NULL COLLATE NOCASE, - CONSTRAINT FK_StrengthStabilityPointConstructionFailureMechanismMetaEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade + StabilityPointStructuresFailureMechanismMetaEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + FailureMechanismEntityId INTEGER NOT NULL, + N REAL NOT NULL, + ForeshoreProfileCollectionSourcePath TEXT NULL COLLATE NOCASE, + StabilityPointStructureCollectionSourcePath TEXT NULL COLLATE NOCASE, + CONSTRAINT FK_StrengthStabilityPointConstructionFailureMechanismMetaEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; CREATE TABLE StabilityPointStructuresOutputEntity ( - StabilityPointStructuresOutputEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - StabilityPointStructuresCalculationEntityId INTEGER NOT NULL, - GeneralResultFaultTreeIllustrationPointEntityId INTEGER NULL, - Reliability REAL NULL, - CONSTRAINT FK_StabilityPointStructuresOutputEntity_GeneralResultFaultTreeIllustrationPointEntity FOREIGN KEY (GeneralResultFaultTreeIllustrationPointEntityId) REFERENCES GeneralResultFaultTreeIllustrationPointEntity (GeneralResultFaultTreeIllustrationPointEntityId) ON DELETE Set Null ON UPDATE Cascade, - CONSTRAINT FK_StabilityPointStructuresOutputEntity_StabilityPointStructuresCalculationEntity FOREIGN KEY (StabilityPointStructuresCalculationEntityId) REFERENCES StabilityPointStructuresCalculationEntity (StabilityPointStructuresCalculationEntityId) ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT U_StabilityPointStructuresCalculationEntity UNIQUE (StabilityPointStructuresCalculationEntityId) + StabilityPointStructuresOutputEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + StabilityPointStructuresCalculationEntityId INTEGER NOT NULL, + GeneralResultFaultTreeIllustrationPointEntityId INTEGER NULL, + Reliability REAL NULL, + CONSTRAINT FK_StabilityPointStructuresOutputEntity_GeneralResultFaultTreeIllustrationPointEntity FOREIGN KEY (GeneralResultFaultTreeIllustrationPointEntityId) REFERENCES GeneralResultFaultTreeIllustrationPointEntity (GeneralResultFaultTreeIllustrationPointEntityId) ON DELETE Set Null ON UPDATE Cascade, + CONSTRAINT FK_StabilityPointStructuresOutputEntity_StabilityPointStructuresCalculationEntity FOREIGN KEY (StabilityPointStructuresCalculationEntityId) REFERENCES StabilityPointStructuresCalculationEntity (StabilityPointStructuresCalculationEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT U_StabilityPointStructuresCalculationEntity UNIQUE (StabilityPointStructuresCalculationEntityId) ) ; CREATE TABLE StabilityStoneCoverFailureMechanismMetaEntity ( - StabilityStoneCoverFailureMechanismMetaEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - FailureMechanismEntityId INTEGER NOT NULL, - ForeshoreProfileCollectionSourcePath TEXT NULL COLLATE NOCASE, - N REAL NOT NULL, - ApplyLengthEffectInSection TINYINT (1) NOT NULL, - CONSTRAINT FK_StabilityStoneCoverFailureMechanismMetaEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade + StabilityStoneCoverFailureMechanismMetaEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + FailureMechanismEntityId INTEGER NOT NULL, + ForeshoreProfileCollectionSourcePath TEXT NULL COLLATE NOCASE, + N REAL NOT NULL, + ApplyLengthEffectInSection TINYINT (1) NOT NULL, + CONSTRAINT FK_StabilityStoneCoverFailureMechanismMetaEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; CREATE TABLE StabilityStoneCoverWaveConditionsCalculationEntity ( - StabilityStoneCoverWaveConditionsCalculationEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - CalculationGroupEntityId INTEGER NOT NULL, - ForeshoreProfileEntityId INTEGER NULL, - HydraulicLocationEntityId INTEGER NULL, - HydraulicLocationCalculationForTargetProbabilityCollectionEntityId INTEGER NULL, - 'Order' INT (4) NOT NULL, - Name VARCHAR (260) NULL, - Comments TEXT NULL COLLATE NOCASE, - UseBreakWater TINYINT (1) NOT NULL, -- true or false - BreakWaterType TINYINT (1) NOT NULL, -- Enum: 1 = Wall, 2 = Caisson, 3 = Dam - BreakWaterHeight REAL NULL, - UseForeshore TINYINT (1) NOT NULL, -- true or false - Orientation REAL NULL, - UpperBoundaryRevetment REAL NULL, - LowerBoundaryRevetment REAL NULL, - UpperBoundaryWaterLevels REAL NULL, - LowerBoundaryWaterLevels REAL NULL, - StepSize TINYINT (1) NOT NULL, -- Enum: 1 = 0.5, 2 = 1.0, 3 = 2.0 - CalculationType TINYINT (1) NOT NULL, -- Enum: 1 = Blocks, 2 = Columns, 3 = Both - WaterLevelType TINYINT (1) NOT NULL, -- Enum: 1 = None, 2 = MaximumAllowableFloodingProbability, 3 = SignalFloodingProbability, 4 = UserDefinedTargetProbability - CONSTRAINT FK_StabilityStoneCoverWaveConditionsCalculationEntity_CalculationGroupEntity FOREIGN KEY (CalculationGroupEntityId) REFERENCES CalculationGroupEntity (CalculationGroupEntityId) ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT FK_StabilityStoneCoverWaveConditionsCalculationEntity_ForeshoreProfileEntity FOREIGN KEY (ForeshoreProfileEntityId) REFERENCES ForeshoreProfileEntity (ForeshoreProfileEntityId) ON DELETE Set Null ON UPDATE Cascade, - CONSTRAINT FK_StabilityStoneCoverWaveConditionsCalculationEntity_HydraulicLocationCalculationForTargetProbabilityCollectionEntity FOREIGN KEY (HydraulicLocationCalculationForTargetProbabilityCollectionEntityId) REFERENCES HydraulicLocationCalculationForTargetProbabilityCollectionEntity (HydraulicLocationCalculationForTargetProbabilityCollectionEntityId) ON DELETE Set Null ON UPDATE Cascade, - CONSTRAINT FK_StabilityStoneCoverWaveConditionsCalculationEntity_HydraulicLocationEntity FOREIGN KEY (HydraulicLocationEntityId) REFERENCES HydraulicLocationEntity (HydraulicLocationEntityId) ON DELETE Set Null ON UPDATE Cascade -) + StabilityStoneCoverWaveConditionsCalculationEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + CalculationGroupEntityId INTEGER NOT NULL, + ForeshoreProfileEntityId INTEGER NULL, + HydraulicLocationEntityId INTEGER NULL, + HydraulicLocationCalculationForTargetProbabilityCollectionEntityId INTEGER NULL, 'Order' + INT +( + 4 +) NOT NULL, + Name VARCHAR(260) NULL, + Comments TEXT NULL COLLATE NOCASE, + UseBreakWater TINYINT (1) NOT NULL, -- true or false + BreakWaterType TINYINT (1) NOT NULL, -- Enum: 1 = Wall, 2 = Caisson, 3 = Dam + BreakWaterHeight REAL NULL, + UseForeshore TINYINT (1) NOT NULL, -- true or false + Orientation REAL NULL, + UpperBoundaryRevetment REAL NULL, + LowerBoundaryRevetment REAL NULL, + UpperBoundaryWaterLevels REAL NULL, + LowerBoundaryWaterLevels REAL NULL, + StepSize TINYINT (1) NOT NULL, -- Enum: 1 = 0.5, 2 = 1.0, 3 = 2.0 + CalculationType TINYINT (1) NOT NULL, -- Enum: 1 = Blocks, 2 = Columns, 3 = Both + WaterLevelType TINYINT (1) NOT NULL, -- Enum: 1 = None, 2 = MaximumAllowableFloodingProbability, 3 = SignalFloodingProbability, 4 = UserDefinedTargetProbability + CONSTRAINT FK_StabilityStoneCoverWaveConditionsCalculationEntity_CalculationGroupEntity FOREIGN KEY (CalculationGroupEntityId) REFERENCES CalculationGroupEntity (CalculationGroupEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT FK_StabilityStoneCoverWaveConditionsCalculationEntity_ForeshoreProfileEntity FOREIGN KEY (ForeshoreProfileEntityId) REFERENCES ForeshoreProfileEntity (ForeshoreProfileEntityId) ON DELETE Set Null ON UPDATE Cascade, + CONSTRAINT FK_StabilityStoneCoverWaveConditionsCalculationEntity_HydraulicLocationCalculationForTargetProbabilityCollectionEntity FOREIGN KEY (HydraulicLocationCalculationForTargetProbabilityCollectionEntityId) REFERENCES HydraulicLocationCalculationForTargetProbabilityCollectionEntity (HydraulicLocationCalculationForTargetProbabilityCollectionEntityId) ON DELETE Set Null ON UPDATE Cascade, + CONSTRAINT FK_StabilityStoneCoverWaveConditionsCalculationEntity_HydraulicLocationEntity FOREIGN KEY (HydraulicLocationEntityId) REFERENCES HydraulicLocationEntity (HydraulicLocationEntityId) ON DELETE Set Null ON UPDATE Cascade + ) ; CREATE TABLE StabilityStoneCoverWaveConditionsOutputEntity ( - StabilityStoneCoverWaveConditionsOutputEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - StabilityStoneCoverWaveConditionsCalculationEntityId INTEGER NOT NULL, - 'Order' INT (4) NOT NULL, - OutputType TINYINT (1) NOT NULL, -- Enum: 1 = Column, 2 = Block - WaterLevel REAL NULL, - WaveHeight REAL NULL, - WavePeakPeriod REAL NULL, - WaveAngle REAL NULL, - WaveDirection REAL NULL, - TargetProbability REAL NULL, - TargetReliability REAL NULL, - CalculatedProbability REAL NULL, - CalculatedReliability REAL NULL, - CalculationConvergence TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated, 2 = CalculationNotConverged, 3 = CalculationConverged - CONSTRAINT FK_StabilityStoneCoverWaveConditionsOutputEntity_StabilityStoneCoverWaveConditionsCalculationEntity FOREIGN KEY (StabilityStoneCoverWaveConditionsCalculationEntityId) REFERENCES StabilityStoneCoverWaveConditionsCalculationEntity (StabilityStoneCoverWaveConditionsCalculationEntityId) ON DELETE Cascade ON UPDATE Cascade -) + StabilityStoneCoverWaveConditionsOutputEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + StabilityStoneCoverWaveConditionsCalculationEntityId INTEGER NOT NULL, 'Order' + INT +( + 4 +) NOT NULL, + OutputType TINYINT (1) NOT NULL, -- Enum: 1 = Column, 2 = Block + WaterLevel REAL NULL, + WaveHeight REAL NULL, + WavePeakPeriod REAL NULL, + WaveAngle REAL NULL, + WaveDirection REAL NULL, + TargetProbability REAL NULL, + TargetReliability REAL NULL, + CalculatedProbability REAL NULL, + CalculatedReliability REAL NULL, + CalculationConvergence TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated, 2 = CalculationNotConverged, 3 = CalculationConverged + CONSTRAINT FK_StabilityStoneCoverWaveConditionsOutputEntity_StabilityStoneCoverWaveConditionsCalculationEntity FOREIGN KEY (StabilityStoneCoverWaveConditionsCalculationEntityId) REFERENCES StabilityStoneCoverWaveConditionsCalculationEntity (StabilityStoneCoverWaveConditionsCalculationEntityId) ON DELETE Cascade ON UPDATE Cascade + ) ; CREATE TABLE StochastEntity ( - StochastEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - Name TEXT NOT NULL COLLATE NOCASE, - Duration REAL NOT NULL, - Alpha REAL NOT NULL, - 'Order' INT (4) NOT NULL -) + StochastEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + Name TEXT NOT NULL COLLATE NOCASE, + Duration REAL NOT NULL, + Alpha REAL NOT NULL, 'Order' + INT +( + 4 +) NOT NULL + ) ; CREATE TABLE SubMechanismIllustrationPointEntity ( - SubMechanismIllustrationPointEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - Name TEXT NOT NULL COLLATE NOCASE, - Beta REAL NOT NULL, - 'Order' INT (4) NOT NULL -) + SubMechanismIllustrationPointEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + Name TEXT NOT NULL COLLATE NOCASE, + Beta REAL NOT NULL, 'Order' + INT +( + 4 +) NOT NULL + ) ; CREATE TABLE SubMechanismIllustrationPointStochastEntity ( - SubMechanismIllustrationPointStochastEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - SubMechanismIllustrationPointEntityId INTEGER NOT NULL, - Name TEXT NOT NULL COLLATE NOCASE, - Unit TEXT NOT NULL COLLATE NOCASE, - Duration REAL NOT NULL, - Alpha REAL NOT NULL, - Realization REAL NOT NULL, - 'Order' INT (4) NOT NULL, - CONSTRAINT FK_SubMechanismIllustrationPointStochast_SubMechanismIllustrationPointEntity FOREIGN KEY (SubMechanismIllustrationPointEntityId) REFERENCES SubMechanismIllustrationPointEntity (SubMechanismIllustrationPointEntityId) ON DELETE No Action ON UPDATE No Action -) + SubMechanismIllustrationPointStochastEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + SubMechanismIllustrationPointEntityId INTEGER NOT NULL, + Name TEXT NOT NULL COLLATE NOCASE, + Unit TEXT NOT NULL COLLATE NOCASE, + Duration REAL NOT NULL, + Alpha REAL NOT NULL, + Realization REAL NOT NULL, 'Order' + INT +( + 4 +) NOT NULL, + CONSTRAINT FK_SubMechanismIllustrationPointStochast_SubMechanismIllustrationPointEntity FOREIGN KEY (SubMechanismIllustrationPointEntityId) REFERENCES SubMechanismIllustrationPointEntity (SubMechanismIllustrationPointEntityId) ON DELETE No Action ON UPDATE No Action + ) ; CREATE TABLE TopLevelFaultTreeIllustrationPointEntity ( - TopLevelFaultTreeIllustrationPointEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - FaultTreeIllustrationPointEntityId INTEGER NOT NULL, - GeneralResultFaultTreeIllustrationPointEntityId INTEGER NOT NULL, - ClosingSituation TEXT NOT NULL COLLATE NOCASE, - WindDirectionName TEXT NOT NULL COLLATE NOCASE, - WindDirectionAngle REAL NOT NULL, - 'Order' INT (4) NOT NULL, - CONSTRAINT FK_TopLevelFaultTreeIllustrationPointEntity_FaultTreeIllustrationPointEntity FOREIGN KEY (FaultTreeIllustrationPointEntityId) REFERENCES FaultTreeIllustrationPointEntity (FaultTreeIllustrationPointEntityId) ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT FK_TopLevelFaultTreeIllustrationPointEntity_GeneralResultFaultTreeIllustrationPointEntity FOREIGN KEY (GeneralResultFaultTreeIllustrationPointEntityId) REFERENCES GeneralResultFaultTreeIllustrationPointEntity (GeneralResultFaultTreeIllustrationPointEntityId) ON DELETE Cascade ON UPDATE Cascade -) + TopLevelFaultTreeIllustrationPointEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + FaultTreeIllustrationPointEntityId INTEGER NOT NULL, + GeneralResultFaultTreeIllustrationPointEntityId INTEGER NOT NULL, + ClosingSituation TEXT NOT NULL COLLATE NOCASE, + WindDirectionName TEXT NOT NULL COLLATE NOCASE, + WindDirectionAngle REAL NOT NULL, 'Order' + INT +( + 4 +) NOT NULL, + CONSTRAINT FK_TopLevelFaultTreeIllustrationPointEntity_FaultTreeIllustrationPointEntity FOREIGN KEY (FaultTreeIllustrationPointEntityId) REFERENCES FaultTreeIllustrationPointEntity (FaultTreeIllustrationPointEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT FK_TopLevelFaultTreeIllustrationPointEntity_GeneralResultFaultTreeIllustrationPointEntity FOREIGN KEY (GeneralResultFaultTreeIllustrationPointEntityId) REFERENCES GeneralResultFaultTreeIllustrationPointEntity (GeneralResultFaultTreeIllustrationPointEntityId) ON DELETE Cascade ON UPDATE Cascade + ) ; CREATE TABLE TopLevelSubMechanismIllustrationPointEntity ( - TopLevelSubMechanismIllustrationPointEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - GeneralResultSubMechanismIllustrationPointEntityId INTEGER NOT NULL, - SubMechanismIllustrationPointEntityId INTEGER NOT NULL, - ClosingSituation TEXT NOT NULL COLLATE NOCASE, - WindDirectionName TEXT NOT NULL COLLATE NOCASE, - WindDirectionAngle REAL NOT NULL, - 'Order' INT (4) NOT NULL, - CONSTRAINT FK_TopLevelSubMechanismIllustrationPointEntity_GeneralResultSubMechanismIllustrationPointEntity FOREIGN KEY (GeneralResultSubMechanismIllustrationPointEntityId) REFERENCES GeneralResultSubMechanismIllustrationPointEntity (GeneralResultSubMechanismIllustrationPointEntityId) ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT FK_TopLevelSubMechanismIllustrationPointEntity_SubMechanismIllustrationPointEntity FOREIGN KEY (SubMechanismIllustrationPointEntityId) REFERENCES SubMechanismIllustrationPointEntity (SubMechanismIllustrationPointEntityId) ON DELETE Cascade ON UPDATE Cascade -) + TopLevelSubMechanismIllustrationPointEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + GeneralResultSubMechanismIllustrationPointEntityId INTEGER NOT NULL, + SubMechanismIllustrationPointEntityId INTEGER NOT NULL, + ClosingSituation TEXT NOT NULL COLLATE NOCASE, + WindDirectionName TEXT NOT NULL COLLATE NOCASE, + WindDirectionAngle REAL NOT NULL, 'Order' + INT +( + 4 +) NOT NULL, + CONSTRAINT FK_TopLevelSubMechanismIllustrationPointEntity_GeneralResultSubMechanismIllustrationPointEntity FOREIGN KEY (GeneralResultSubMechanismIllustrationPointEntityId) REFERENCES GeneralResultSubMechanismIllustrationPointEntity (GeneralResultSubMechanismIllustrationPointEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT FK_TopLevelSubMechanismIllustrationPointEntity_SubMechanismIllustrationPointEntity FOREIGN KEY (SubMechanismIllustrationPointEntityId) REFERENCES SubMechanismIllustrationPointEntity (SubMechanismIllustrationPointEntityId) ON DELETE Cascade ON UPDATE Cascade + ) ; CREATE TABLE WaveImpactAsphaltCoverWaveConditionsCalculationEntity ( - WaveImpactAsphaltCoverWaveConditionsCalculationEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - CalculationGroupEntityId INTEGER NOT NULL, - ForeshoreProfileEntityId INTEGER NULL, - HydraulicLocationEntityId INTEGER NULL, - HydraulicLocationCalculationForTargetProbabilityCollectionEntityId INTEGER NULL, - 'Order' INT (4) NOT NULL, - Name VARCHAR (260) NULL, - Comments TEXT NULL COLLATE NOCASE, - UseBreakWater TINYINT (1) NOT NULL, -- true or false - BreakWaterType TINYINT (1) NOT NULL, -- Enum: 1 = Wall, 2 = Caisson, 3 = Dam - BreakWaterHeight REAL NULL, - UseForeshore TINYINT (1) NOT NULL, -- true or false - Orientation REAL NULL, - UpperBoundaryRevetment REAL NULL, - LowerBoundaryRevetment REAL NULL, - UpperBoundaryWaterLevels REAL NULL, - LowerBoundaryWaterLevels REAL NULL, - StepSize TINYINT (1) NOT NULL, -- Enum: 1 = 0.5, 2 = 1.0, 3 = 2.0 - WaterLevelType TINYINT (1) NOT NULL, -- Enum: 1 = None, 2 = MaximumAllowableFloodingProbability, 3 = SignalFloodingProbability, 4 = UserDefinedTargetProbability - CONSTRAINT FK_WaveImpactAsphaltCoverWaveConditionsCalculationEntity_CalculationGroupEntity FOREIGN KEY (CalculationGroupEntityId) REFERENCES CalculationGroupEntity (CalculationGroupEntityId) ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT FK_WaveImpactAsphaltCoverWaveConditionsCalculationEntity_ForeshoreProfileEntity FOREIGN KEY (ForeshoreProfileEntityId) REFERENCES ForeshoreProfileEntity (ForeshoreProfileEntityId) ON DELETE Set Null ON UPDATE Cascade, - CONSTRAINT FK_WaveImpactAsphaltCoverWaveConditionsCalculationEntity_HydraulicLocationCalculationForTargetProbabilityCollectionEntity FOREIGN KEY (HydraulicLocationCalculationForTargetProbabilityCollectionEntityId) REFERENCES HydraulicLocationCalculationForTargetProbabilityCollectionEntity (HydraulicLocationCalculationForTargetProbabilityCollectionEntityId) ON DELETE Set Null ON UPDATE Cascade, - CONSTRAINT FK_WaveImpactAsphaltCoverWaveConditionsCalculationEntity_HydraulicLocationEntity FOREIGN KEY (HydraulicLocationEntityId) REFERENCES HydraulicLocationEntity (HydraulicLocationEntityId) ON DELETE Set Null ON UPDATE Cascade -) + WaveImpactAsphaltCoverWaveConditionsCalculationEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + CalculationGroupEntityId INTEGER NOT NULL, + ForeshoreProfileEntityId INTEGER NULL, + HydraulicLocationEntityId INTEGER NULL, + HydraulicLocationCalculationForTargetProbabilityCollectionEntityId INTEGER NULL, 'Order' + INT +( + 4 +) NOT NULL, + Name VARCHAR(260) NULL, + Comments TEXT NULL COLLATE NOCASE, + UseBreakWater TINYINT (1) NOT NULL, -- true or false + BreakWaterType TINYINT (1) NOT NULL, -- Enum: 1 = Wall, 2 = Caisson, 3 = Dam + BreakWaterHeight REAL NULL, + UseForeshore TINYINT (1) NOT NULL, -- true or false + Orientation REAL NULL, + UpperBoundaryRevetment REAL NULL, + LowerBoundaryRevetment REAL NULL, + UpperBoundaryWaterLevels REAL NULL, + LowerBoundaryWaterLevels REAL NULL, + StepSize TINYINT (1) NOT NULL, -- Enum: 1 = 0.5, 2 = 1.0, 3 = 2.0 + WaterLevelType TINYINT (1) NOT NULL, -- Enum: 1 = None, 2 = MaximumAllowableFloodingProbability, 3 = SignalFloodingProbability, 4 = UserDefinedTargetProbability + CONSTRAINT FK_WaveImpactAsphaltCoverWaveConditionsCalculationEntity_CalculationGroupEntity FOREIGN KEY (CalculationGroupEntityId) REFERENCES CalculationGroupEntity (CalculationGroupEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT FK_WaveImpactAsphaltCoverWaveConditionsCalculationEntity_ForeshoreProfileEntity FOREIGN KEY (ForeshoreProfileEntityId) REFERENCES ForeshoreProfileEntity (ForeshoreProfileEntityId) ON DELETE Set Null ON UPDATE Cascade, + CONSTRAINT FK_WaveImpactAsphaltCoverWaveConditionsCalculationEntity_HydraulicLocationCalculationForTargetProbabilityCollectionEntity FOREIGN KEY (HydraulicLocationCalculationForTargetProbabilityCollectionEntityId) REFERENCES HydraulicLocationCalculationForTargetProbabilityCollectionEntity (HydraulicLocationCalculationForTargetProbabilityCollectionEntityId) ON DELETE Set Null ON UPDATE Cascade, + CONSTRAINT FK_WaveImpactAsphaltCoverWaveConditionsCalculationEntity_HydraulicLocationEntity FOREIGN KEY (HydraulicLocationEntityId) REFERENCES HydraulicLocationEntity (HydraulicLocationEntityId) ON DELETE Set Null ON UPDATE Cascade + ) ; CREATE TABLE WaveImpactAsphaltCoverWaveConditionsOutputEntity ( - WaveImpactAsphaltCoverWaveConditionsOutputEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - WaveImpactAsphaltCoverWaveConditionsCalculationEntityId INTEGER NOT NULL, - 'Order' INT (4) NOT NULL, - WaterLevel REAL NULL, - WaveHeight REAL NULL, - WavePeakPeriod REAL NULL, - WaveAngle REAL NULL, - WaveDirection REAL NULL, - TargetProbability REAL NULL, - TargetReliability REAL NULL, - CalculatedProbability REAL NULL, - CalculatedReliability REAL NULL, - CalculationConvergence TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated, 2 = CalculationNotConverged, 3 = CalculationConverged - CONSTRAINT FK_WaveImpactAsphaltCoverWaveConditionsOutputEntity_WaveImpactAsphaltCoverWaveConditionsCalculationEntity FOREIGN KEY (WaveImpactAsphaltCoverWaveConditionsCalculationEntityId) REFERENCES WaveImpactAsphaltCoverWaveConditionsCalculationEntity (WaveImpactAsphaltCoverWaveConditionsCalculationEntityId) ON DELETE Cascade ON UPDATE Cascade -) + WaveImpactAsphaltCoverWaveConditionsOutputEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + WaveImpactAsphaltCoverWaveConditionsCalculationEntityId INTEGER NOT NULL, 'Order' + INT +( + 4 +) NOT NULL, + WaterLevel REAL NULL, + WaveHeight REAL NULL, + WavePeakPeriod REAL NULL, + WaveAngle REAL NULL, + WaveDirection REAL NULL, + TargetProbability REAL NULL, + TargetReliability REAL NULL, + CalculatedProbability REAL NULL, + CalculatedReliability REAL NULL, + CalculationConvergence TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated, 2 = CalculationNotConverged, 3 = CalculationConverged + CONSTRAINT FK_WaveImpactAsphaltCoverWaveConditionsOutputEntity_WaveImpactAsphaltCoverWaveConditionsCalculationEntity FOREIGN KEY (WaveImpactAsphaltCoverWaveConditionsCalculationEntityId) REFERENCES WaveImpactAsphaltCoverWaveConditionsCalculationEntity (WaveImpactAsphaltCoverWaveConditionsCalculationEntityId) ON DELETE Cascade ON UPDATE Cascade + ) ; /* Create Indexes and Triggers */ CREATE INDEX IXFK_AssessmentSectionEntity_HydraulicLocationCalculationCollectionEntity1 - ON AssessmentSectionEntity (HydraulicLocationCalculationCollectionEntity1Id ASC) + ON AssessmentSectionEntity (HydraulicLocationCalculationCollectionEntity1Id ASC) ; CREATE INDEX IXFK_AssessmentSectionEntity_HydraulicLocationCalculationCollectionEntity2 - ON AssessmentSectionEntity (HydraulicLocationCalculationCollectionEntity2Id ASC) + ON AssessmentSectionEntity (HydraulicLocationCalculationCollectionEntity2Id ASC) ; CREATE INDEX IXFK_AssessmentSectionEntity_ProjectEntity - ON AssessmentSectionEntity (ProjectEntityId ASC) + ON AssessmentSectionEntity (ProjectEntityId ASC) ; CREATE TRIGGER [TR_AfterDeleteAssessmentSectionEntity_RemoveHydraulicLocationCalculationCollectionEntities] - AFTER DELETE - ON AssessmentSectionEntity + AFTER +DELETE +ON AssessmentSectionEntity FOR EACH ROW BEGIN - DELETE - FROM HydraulicLocationCalculationCollectionEntity - WHERE HydraulicLocationCalculationCollectionEntityId IS OLD.HydraulicLocationCalculationCollectionEntity1Id - OR HydraulicLocationCalculationCollectionEntityId IS OLD.HydraulicLocationCalculationCollectionEntity2Id; +DELETE +FROM HydraulicLocationCalculationCollectionEntity +WHERE HydraulicLocationCalculationCollectionEntityId IS OLD.HydraulicLocationCalculationCollectionEntity1Id + OR HydraulicLocationCalculationCollectionEntityId IS OLD.HydraulicLocationCalculationCollectionEntity2Id; END; ; CREATE INDEX IXFK_FailureMechanismEntity_AssessmentSectionEntity - ON FailureMechanismEntity (AssessmentSectionEntityId ASC) + ON FailureMechanismEntity (AssessmentSectionEntityId ASC) ; CREATE INDEX IXFK_FailureMechanismEntity_CalculationGroupEntity - ON FailureMechanismEntity (CalculationGroupEntityId ASC) + ON FailureMechanismEntity (CalculationGroupEntityId ASC) ; CREATE INDEX IXFK_ClosingStructuresFailureMechanismMetaEntity_FailureMechanismEntity - ON ClosingStructuresFailureMechanismMetaEntity (FailureMechanismEntityId ASC) + ON ClosingStructuresFailureMechanismMetaEntity (FailureMechanismEntityId ASC) ; CREATE INDEX IXFK_CalculationGroupEntity_CalculationGroupEntity - ON CalculationGroupEntity (ParentCalculationGroupEntityId ASC) + ON CalculationGroupEntity (ParentCalculationGroupEntityId ASC) ; CREATE INDEX IXFK_HydraulicLocationEntity_HydraulicBoundaryDatabaseEntity - ON HydraulicLocationEntity (HydraulicBoundaryDatabaseEntityId ASC) + ON HydraulicLocationEntity (HydraulicBoundaryDatabaseEntityId ASC) ; CREATE INDEX IXFK_GrassCoverErosionInwardsFailureMechanismMetaEntity_FailureMechanismEntity - ON GrassCoverErosionInwardsFailureMechanismMetaEntity (FailureMechanismEntityId ASC) + ON GrassCoverErosionInwardsFailureMechanismMetaEntity (FailureMechanismEntityId ASC) ; CREATE INDEX IXFK_SemiProbabilisticPipingCalculationEntity_PipingStochasticSoilProfileEntity - ON SemiProbabilisticPipingCalculationEntity (PipingStochasticSoilProfileEntityId ASC) + ON SemiProbabilisticPipingCalculationEntity (PipingStochasticSoilProfileEntityId ASC) ; CREATE INDEX IXFK_SemiProbabilisticPipingCalculationEntity_SurfaceLineEntity - ON SemiProbabilisticPipingCalculationEntity (SurfaceLineEntityId ASC) + ON SemiProbabilisticPipingCalculationEntity (SurfaceLineEntityId ASC) ; CREATE INDEX IXFK_SemiProbabilisticPipingCalculationEntity_HydraulicLocationEntity - ON SemiProbabilisticPipingCalculationEntity (HydraulicLocationEntityId ASC) + ON SemiProbabilisticPipingCalculationEntity (HydraulicLocationEntityId ASC) ; CREATE INDEX IXFK_SemiProbabilisticPipingCalculationEntity_CalculationGroupEntity - ON SemiProbabilisticPipingCalculationEntity (CalculationGroupEntityId ASC) + ON SemiProbabilisticPipingCalculationEntity (CalculationGroupEntityId ASC) ; CREATE INDEX IXFK_GrassCoverErosionInwardsCalculationEntity_CalculationGroupEntity - ON GrassCoverErosionInwardsCalculationEntity (CalculationGroupEntityId ASC) + ON GrassCoverErosionInwardsCalculationEntity (CalculationGroupEntityId ASC) ; CREATE INDEX IXFK_GrassCoverErosionInwardsCalculationEntity_DikeProfileEntity - ON GrassCoverErosionInwardsCalculationEntity (DikeProfileEntityId ASC) + ON GrassCoverErosionInwardsCalculationEntity (DikeProfileEntityId ASC) ; CREATE INDEX IXFK_GrassCoverErosionInwardsCalculationEntity_HydraulicLocationEntity - ON GrassCoverErosionInwardsCalculationEntity (HydraulicLocationEntityId ASC) + ON GrassCoverErosionInwardsCalculationEntity (HydraulicLocationEntityId ASC) ; CREATE INDEX IXFK_GrassCoverSlipOffInwardsFailureMechanismMetaEntity_FailureMechanismEntity - ON GrassCoverSlipOffInwardsFailureMechanismMetaEntity (FailureMechanismEntityId ASC) + ON GrassCoverSlipOffInwardsFailureMechanismMetaEntity (FailureMechanismEntityId ASC) ; CREATE INDEX IXFK_GrassCoverErosionOutwardsFailureMechanismMetaEntity_FailureMechanismEntity - ON GrassCoverErosionOutwardsFailureMechanismMetaEntity (FailureMechanismEntityId ASC) + ON GrassCoverErosionOutwardsFailureMechanismMetaEntity (FailureMechanismEntityId ASC) ; CREATE INDEX IXFK_PipingStochasticSoilProfileEntity_SoilProfileEntity - ON PipingStochasticSoilProfileEntity (PipingSoilProfileEntityId ASC) + ON PipingStochasticSoilProfileEntity (PipingSoilProfileEntityId ASC) ; CREATE INDEX IXFK_PipingStochasticSoilProfileEntity_StochasticSoilModelEntity - ON PipingStochasticSoilProfileEntity (StochasticSoilModelEntityId ASC) + ON PipingStochasticSoilProfileEntity (StochasticSoilModelEntityId ASC) ; CREATE INDEX IXFK_PipingScenarioConfigurationPerFailureMechanismSectionEntity_FailureMechanismSectionEntity - ON PipingScenarioConfigurationPerFailureMechanismSectionEntity (FailureMechanismSectionEntityId ASC) + ON PipingScenarioConfigurationPerFailureMechanismSectionEntity (FailureMechanismSectionEntityId ASC) ; CREATE INDEX IXFK_StochasticSoilModelEntity_FailureMechanismEntity - ON StochasticSoilModelEntity (FailureMechanismEntityId ASC) + ON StochasticSoilModelEntity (FailureMechanismEntityId ASC) ; CREATE INDEX IXFK_SurfaceLineEntity_FailureMechanismEntity - ON SurfaceLineEntity (FailureMechanismEntityId ASC) + ON SurfaceLineEntity (FailureMechanismEntityId ASC) ; CREATE INDEX IXFK_SurfaceLinePointEntity_SurfaceLineEntity - ON PipingCharacteristicPointEntity (SurfaceLineEntityId ASC) + ON PipingCharacteristicPointEntity (SurfaceLineEntityId ASC) ; CREATE INDEX IXFK_WaterPressureAsphaltCoverFailureMechanismMetaEntity_FailureMechanismEntity - ON WaterPressureAsphaltCoverFailureMechanismMetaEntity (FailureMechanismEntityId ASC) + ON WaterPressureAsphaltCoverFailureMechanismMetaEntity (FailureMechanismEntityId ASC) ; CREATE INDEX IXFK_WaveImpactAsphaltCoverFailureMechanismMetaEntity_FailureMechanismEntity - ON WaveImpactAsphaltCoverFailureMechanismMetaEntity (FailureMechanismEntityId ASC) + ON WaveImpactAsphaltCoverFailureMechanismMetaEntity (FailureMechanismEntityId ASC) ; CREATE INDEX IXFK_AdoptableFailureMechanismSectionResultEntity_FailureMechanismSectionEntity - ON AdoptableFailureMechanismSectionResultEntity (FailureMechanismSectionEntityId ASC) + ON AdoptableFailureMechanismSectionResultEntity (FailureMechanismSectionEntityId ASC) ; CREATE INDEX IXFK_AdoptableWithProfileProbabilityFailureMechanismSectionResultEntity_FailureMechanismSectionEntity - ON AdoptableWithProfileProbabilityFailureMechanismSectionResultEntity (FailureMechanismSectionEntityId ASC) + ON AdoptableWithProfileProbabilityFailureMechanismSectionResultEntity (FailureMechanismSectionEntityId ASC) ; CREATE INDEX IXFK_BackgroundDataEntity_AssessmentSectionEntity - ON BackgroundDataEntity (AssessmentSectionEntityId ASC) + ON BackgroundDataEntity (AssessmentSectionEntityId ASC) ; CREATE INDEX IXFK_BackgroundDataMetaEntity_BackgroundDataEntity - ON BackgroundDataMetaEntity (BackgroundDataEntityId ASC) + ON BackgroundDataMetaEntity (BackgroundDataEntityId ASC) ; CREATE INDEX IXFK_ClosingStructureEntity_FailureMechanismEntity - ON ClosingStructureEntity (FailureMechanismEntityId ASC) + ON ClosingStructureEntity (FailureMechanismEntityId ASC) ; CREATE INDEX IXFK_ClosingStructuresCalculationEntity_CalculationGroupEntity - ON ClosingStructuresCalculationEntity (CalculationGroupEntityId ASC) + ON ClosingStructuresCalculationEntity (CalculationGroupEntityId ASC) ; CREATE INDEX IXFK_ClosingStructuresCalculationEntity_ClosingStructureEntity - ON ClosingStructuresCalculationEntity (ClosingStructureEntityId ASC) + ON ClosingStructuresCalculationEntity (ClosingStructureEntityId ASC) ; CREATE INDEX IXFK_ClosingStructuresCalculationEntity_ForeshoreProfileEntity - ON ClosingStructuresCalculationEntity (ForeshoreProfileEntityId ASC) + ON ClosingStructuresCalculationEntity (ForeshoreProfileEntityId ASC) ; CREATE INDEX IXFK_ClosingStructuresCalculationEntity_HydraulicLocationEntity - ON ClosingStructuresCalculationEntity (HydraulicLocationEntityId ASC) + ON ClosingStructuresCalculationEntity (HydraulicLocationEntityId ASC) ; CREATE INDEX IXFK_ClosingStructuresOutputEntity_ClosingStructuresCalculationEntity - ON ClosingStructuresOutputEntity (ClosingStructuresCalculationEntityId ASC) + ON ClosingStructuresOutputEntity (ClosingStructuresCalculationEntityId ASC) ; CREATE TRIGGER [TR_AfterDeleteClosingStructuresOutputEntity_RemoveGeneralResultFaultTreeIllustrationPointEntity] - AFTER DELETE - ON ClosingStructuresOutputEntity + AFTER +DELETE +ON ClosingStructuresOutputEntity FOR EACH ROW BEGIN - DELETE - FROM GeneralResultFaultTreeIllustrationPointEntity - WHERE OLD.GeneralResultFaultTreeIllustrationPointEntityId IS NOT NULL - AND GeneralResultFaultTreeIllustrationPointEntityId IS OLD.GeneralResultFaultTreeIllustrationPointEntityId; +DELETE +FROM GeneralResultFaultTreeIllustrationPointEntity +WHERE OLD.GeneralResultFaultTreeIllustrationPointEntityId IS NOT NULL + AND GeneralResultFaultTreeIllustrationPointEntityId IS OLD.GeneralResultFaultTreeIllustrationPointEntityId; END; ; CREATE INDEX IXFK_DikeProfileEntity_FailureMechanismEntity - ON DikeProfileEntity (FailureMechanismEntityId ASC) + ON DikeProfileEntity (FailureMechanismEntityId ASC) ; CREATE INDEX IXFK_DuneErosionFailureMechanismMetaEntity_FailureMechanismEntity - ON DuneErosionFailureMechanismMetaEntity (FailureMechanismEntityId ASC) + ON DuneErosionFailureMechanismMetaEntity (FailureMechanismEntityId ASC) ; CREATE INDEX IXFK_DuneLocationCalculationEntity_DuneLocationCalculationCollectionEntity - ON DuneLocationCalculationEntity (DuneLocationCalculationForTargetProbabilityCollectionEntityId ASC) + ON DuneLocationCalculationEntity (DuneLocationCalculationForTargetProbabilityCollectionEntityId ASC) ; CREATE INDEX IXFK_DuneLocationCalculationEntity_DuneLocationEntity - ON DuneLocationCalculationEntity (DuneLocationEntityId ASC) + ON DuneLocationCalculationEntity (DuneLocationEntityId ASC) ; CREATE INDEX IXFK_DuneLocationCalculationForTargetProbabilityCollectionEntity_DuneErosionFailureMechanismMetaEntity - ON DuneLocationCalculationForTargetProbabilityCollectionEntity (DuneErosionFailureMechanismMetaEntityId ASC) + ON DuneLocationCalculationForTargetProbabilityCollectionEntity (DuneErosionFailureMechanismMetaEntityId ASC) ; CREATE INDEX IXFK_DuneLocationCalculationOutputEntity_DuneLocationCalculationEntity - ON DuneLocationCalculationOutputEntity (DuneLocationCalculationEntityId ASC) + ON DuneLocationCalculationOutputEntity (DuneLocationCalculationEntityId ASC) ; CREATE INDEX IXFK_DuneLocationEntity_FailureMechanismEntity - ON DuneLocationEntity (FailureMechanismEntityId ASC) + ON DuneLocationEntity (FailureMechanismEntityId ASC) ; CREATE INDEX IXFK_DuneLocationEntity_HydraulicLocationEntity - ON DuneLocationEntity (HydraulicLocationEntityId ASC) + ON DuneLocationEntity (HydraulicLocationEntityId ASC) ; CREATE INDEX IXFK_FailureMechanismFailureMechanismSectionEntity_FailureMechanismEntity - ON FailureMechanismFailureMechanismSectionEntity (FailureMechanismEntityId ASC) + ON FailureMechanismFailureMechanismSectionEntity (FailureMechanismEntityId ASC) ; CREATE INDEX IXFK_FailureMechanismFailureMechanismSectionEntity_FailureMechanismSectionEntity - ON FailureMechanismFailureMechanismSectionEntity (FailureMechanismSectionEntityId ASC) + ON FailureMechanismFailureMechanismSectionEntity (FailureMechanismSectionEntityId ASC) ; CREATE TRIGGER [TR_AfterDeleteFailureMechanismFailureMechanismSectionEntity_RemoveFailureMechanismSectionEntityId] - AFTER DELETE - ON FailureMechanismFailureMechanismSectionEntity + AFTER +DELETE +ON FailureMechanismFailureMechanismSectionEntity FOR EACH ROW BEGIN - DELETE - FROM FailureMechanismSectionEntity - WHERE OLD.FailureMechanismSectionEntityId IS NOT NULL - AND FailureMechanismSectionEntityId IS OLD.FailureMechanismSectionEntityId; +DELETE +FROM FailureMechanismSectionEntity +WHERE OLD.FailureMechanismSectionEntityId IS NOT NULL + AND FailureMechanismSectionEntityId IS OLD.FailureMechanismSectionEntityId; END; ; CREATE INDEX IXFK_FaultTreeIllustrationPoint_FaultTreeIllustrationPoint - ON FaultTreeIllustrationPointEntity (ParentFaultTreeIllustrationPointEntityId ASC) + ON FaultTreeIllustrationPointEntity (ParentFaultTreeIllustrationPointEntityId ASC) ; CREATE INDEX IXFK_FaultTreeIllustrationPointStochastEntity_FaultTreeIllustrationPoint - ON FaultTreeIllustrationPointStochastEntity (FaultTreeIllustrationPointEntityId ASC) + ON FaultTreeIllustrationPointStochastEntity (FaultTreeIllustrationPointEntityId ASC) ; CREATE INDEX IXFK_FaultTreeIllustrationPointStochastEntity_StochastEntity - ON FaultTreeIllustrationPointStochastEntity (StochastEntityId ASC) + ON FaultTreeIllustrationPointStochastEntity (StochastEntityId ASC) ; CREATE TRIGGER [TR_AfterDeleteFaultTreeIllustrationPointStochastEntity_RemoveStochastEntity] - AFTER DELETE - ON FaultTreeIllustrationPointStochastEntity + AFTER +DELETE +ON FaultTreeIllustrationPointStochastEntity FOR EACH ROW BEGIN - DELETE - FROM StochastEntity - WHERE OLD.StochastEntityId IS NOT NULL - AND StochastEntityId IS OLD.StochastEntityId; +DELETE +FROM StochastEntity +WHERE OLD.StochastEntityId IS NOT NULL + AND StochastEntityId IS OLD.StochastEntityId; END; ; CREATE INDEX IXFK_FaultTreeIllustrationPointEntity_FaultTreeIllustrationPointEntity - ON FaultTreeSubmechanismIllustrationPointEntity (FaultTreeIllustrationPointEntityId ASC) + ON FaultTreeSubmechanismIllustrationPointEntity (FaultTreeIllustrationPointEntityId ASC) ; CREATE INDEX IXFK_FaultTreeIllustrationPointEntity_SubMechanismIllustrationPointEntity - ON FaultTreeSubmechanismIllustrationPointEntity (SubMechanismIllustrationPointEntityId ASC) + ON FaultTreeSubmechanismIllustrationPointEntity (SubMechanismIllustrationPointEntityId ASC) ; CREATE TRIGGER [TR_AfterDeleteFaultTreeSubmechanismIllustrationPointEntity_RemoveSubmechanismIllustrationPointEntity] - AFTER DELETE - ON FaultTreeSubmechanismIllustrationPointEntity + AFTER +DELETE +ON FaultTreeSubmechanismIllustrationPointEntity FOR EACH ROW BEGIN - DELETE - FROM SubmechanismIllustrationPointEntity - WHERE OLD.SubmechanismIllustrationPointEntityId IS NOT NULL - AND SubmechanismIllustrationPointEntityId IS OLD.SubmechanismIllustrationPointEntityId; +DELETE +FROM SubmechanismIllustrationPointEntity +WHERE OLD.SubmechanismIllustrationPointEntityId IS NOT NULL + AND SubmechanismIllustrationPointEntityId IS OLD.SubmechanismIllustrationPointEntityId; END; ; CREATE INDEX IXFK_ForeshoreProfileEntity_FailureMechanismEntity - ON ForeshoreProfileEntity (FailureMechanismEntityId ASC) + ON ForeshoreProfileEntity (FailureMechanismEntityId ASC) ; CREATE INDEX IXFK_GeneralResultFaultTreeIllustrationPointStochastEntity_GeneralResultFaultTreeIllustrationPointEntity - ON GeneralResultFaultTreeIllustrationPointStochastEntity (GeneralResultFaultTreeIllustrationPointEntityId ASC) + ON GeneralResultFaultTreeIllustrationPointStochastEntity (GeneralResultFaultTreeIllustrationPointEntityId ASC) ; CREATE INDEX IXFK_GeneralResultFaultTreeIllustrationPointStochastEntity_StochastEntity - ON GeneralResultFaultTreeIllustrationPointStochastEntity (StochastEntityId ASC) + ON GeneralResultFaultTreeIllustrationPointStochastEntity (StochastEntityId ASC) ; CREATE TRIGGER [TR_AfterDeleteGeneralResultFaultTreeIllustrationPointStochastEntity_RemoveStochastEntity] - AFTER DELETE - ON GeneralResultFaultTreeIllustrationPointStochastEntity + AFTER +DELETE +ON GeneralResultFaultTreeIllustrationPointStochastEntity FOR EACH ROW BEGIN - DELETE - FROM StochastEntity - WHERE OLD.StochastEntityId IS NOT NULL - AND StochastEntityId IS OLD.StochastEntityId; +DELETE +FROM StochastEntity +WHERE OLD.StochastEntityId IS NOT NULL + AND StochastEntityId IS OLD.StochastEntityId; END; ; CREATE INDEX IXFK_GeneralResultSubMechanismIllustrationPointStochastEntity_GeneralResultSubMechanismIllustrationPointEntity - ON GeneralResultSubMechanismIllustrationPointStochastEntity (GeneralResultSubMechanismIllustrationPointEntityId ASC) + ON GeneralResultSubMechanismIllustrationPointStochastEntity (GeneralResultSubMechanismIllustrationPointEntityId ASC) ; CREATE INDEX IXFK_GeneralResultSubMechanismIllustrationPointStochastEntity_StochastEntity - ON GeneralResultSubMechanismIllustrationPointStochastEntity (StochastEntityId ASC) + ON GeneralResultSubMechanismIllustrationPointStochastEntity (StochastEntityId ASC) ; CREATE TRIGGER [TR_AfterDeleteGeneralResultSubMechanismIllustrationPointStochastEntity_RemoveStochastEntity] - AFTER DELETE - ON GeneralResultSubMechanismIllustrationPointStochastEntity + AFTER +DELETE +ON GeneralResultSubMechanismIllustrationPointStochastEntity FOR EACH ROW BEGIN - DELETE - FROM StochastEntity - WHERE OLD.StochastEntityId IS NOT NULL - AND StochastEntityId IS OLD.StochastEntityId; +DELETE +FROM StochastEntity +WHERE OLD.StochastEntityId IS NOT NULL + AND StochastEntityId IS OLD.StochastEntityId; END; ; CREATE INDEX IXFK_GrassCoverErosionInwardsDikeHeightOutputEntity_GeneralResultFaultTreeIllustrationPointEntity - ON GrassCoverErosionInwardsDikeHeightOutputEntity (GeneralResultFaultTreeIllustrationPointEntityId ASC) + ON GrassCoverErosionInwardsDikeHeightOutputEntity (GeneralResultFaultTreeIllustrationPointEntityId ASC) ; CREATE INDEX IXFK_GrassCoverErosionInwardsDikeHeightOutputEntity_GrassCoverErosionInwardsOutputEntity - ON GrassCoverErosionInwardsDikeHeightOutputEntity (GrassCoverErosionInwardsOutputEntityId ASC) + ON GrassCoverErosionInwardsDikeHeightOutputEntity (GrassCoverErosionInwardsOutputEntityId ASC) ; CREATE TRIGGER [TR_AfterDeleteGrassCoverErosionInwardsDikeHeightOutputEntity_RemoveGeneralResultFaultTreeIllustrationPointEntity] - AFTER DELETE - ON GrassCoverErosionInwardsDikeHeightOutputEntity + AFTER +DELETE +ON GrassCoverErosionInwardsDikeHeightOutputEntity FOR EACH ROW BEGIN - DELETE - FROM GeneralResultFaultTreeIllustrationPointEntity - WHERE OLD.GeneralResultFaultTreeIllustrationPointEntityId IS NOT NULL - AND GeneralResultFaultTreeIllustrationPointEntityId IS OLD.GeneralResultFaultTreeIllustrationPointEntityId; +DELETE +FROM GeneralResultFaultTreeIllustrationPointEntity +WHERE OLD.GeneralResultFaultTreeIllustrationPointEntityId IS NOT NULL + AND GeneralResultFaultTreeIllustrationPointEntityId IS OLD.GeneralResultFaultTreeIllustrationPointEntityId; END; ; CREATE INDEX IXFK_GrassCoverErosionInwardsOutputEntity_GeneralResultFaultTreeIllustrationPointEntity - ON GrassCoverErosionInwardsOutputEntity (GeneralResultFaultTreeIllustrationPointEntityId ASC) + ON GrassCoverErosionInwardsOutputEntity (GeneralResultFaultTreeIllustrationPointEntityId ASC) ; CREATE INDEX IXFK_GrassCoverErosionInwardsOutputEntity_GrassCoverErosionInwardsCalculationEntity - ON GrassCoverErosionInwardsOutputEntity (GrassCoverErosionInwardsCalculationEntityId ASC) + ON GrassCoverErosionInwardsOutputEntity (GrassCoverErosionInwardsCalculationEntityId ASC) ; CREATE TRIGGER [TR_AfterDeleteGrassCoverErosionInwardsOutputEntity_RemoveGeneralResultFaultTreeIllustrationPointEntity] - AFTER DELETE - ON GrassCoverErosionInwardsOutputEntity + AFTER +DELETE +ON GrassCoverErosionInwardsOutputEntity FOR EACH ROW BEGIN - DELETE - FROM GeneralResultFaultTreeIllustrationPointEntity - WHERE OLD.GeneralResultFaultTreeIllustrationPointEntityId IS NOT NULL - AND GeneralResultFaultTreeIllustrationPointEntityId IS OLD.GeneralResultFaultTreeIllustrationPointEntityId; +DELETE +FROM GeneralResultFaultTreeIllustrationPointEntity +WHERE OLD.GeneralResultFaultTreeIllustrationPointEntityId IS NOT NULL + AND GeneralResultFaultTreeIllustrationPointEntityId IS OLD.GeneralResultFaultTreeIllustrationPointEntityId; END; ; CREATE INDEX IXFK_GrassCoverErosionInwardsOvertoppingRateOutputEntity_GeneralResultFaultTreeIllustrationPointEntity - ON GrassCoverErosionInwardsOvertoppingRateOutputEntity (GeneralResultFaultTreeIllustrationPointEntityId ASC) + ON GrassCoverErosionInwardsOvertoppingRateOutputEntity (GeneralResultFaultTreeIllustrationPointEntityId ASC) ; CREATE INDEX IXFK_GrassCoverErosionInwardsOvertoppingRateOutputEntity_GrassCoverErosionInwardsOutputEntity - ON GrassCoverErosionInwardsOvertoppingRateOutputEntity (GrassCoverErosionInwardsOutputEntityId ASC) + ON GrassCoverErosionInwardsOvertoppingRateOutputEntity (GrassCoverErosionInwardsOutputEntityId ASC) ; CREATE TRIGGER [TR_AfterDeleteGrassCoverErosionInwardsOvertoppingRateOutputEntity_RemoveGeneralResultFaultTreeIllustrationPointEntity] - AFTER DELETE - ON GrassCoverErosionInwardsOvertoppingRateOutputEntity + AFTER +DELETE +ON GrassCoverErosionInwardsOvertoppingRateOutputEntity FOR EACH ROW BEGIN - DELETE - FROM GeneralResultFaultTreeIllustrationPointEntity - WHERE OLD.GeneralResultFaultTreeIllustrationPointEntityId IS NOT NULL - AND GeneralResultFaultTreeIllustrationPointEntityId IS OLD.GeneralResultFaultTreeIllustrationPointEntityId; +DELETE +FROM GeneralResultFaultTreeIllustrationPointEntity +WHERE OLD.GeneralResultFaultTreeIllustrationPointEntityId IS NOT NULL + AND GeneralResultFaultTreeIllustrationPointEntityId IS OLD.GeneralResultFaultTreeIllustrationPointEntityId; END; ; CREATE INDEX IXFK_GrassCoverErosionOutwardsWaveConditionsCalculationEntity_CalculationGroupEntity - ON GrassCoverErosionOutwardsWaveConditionsCalculationEntity (CalculationGroupEntityId ASC) + ON GrassCoverErosionOutwardsWaveConditionsCalculationEntity (CalculationGroupEntityId ASC) ; CREATE INDEX IXFK_GrassCoverErosionOutwardsWaveConditionsCalculationEntity_ForeshoreProfileEntity - ON GrassCoverErosionOutwardsWaveConditionsCalculationEntity (ForeshoreProfileEntityId ASC) + ON GrassCoverErosionOutwardsWaveConditionsCalculationEntity (ForeshoreProfileEntityId ASC) ; CREATE INDEX IXFK_GrassCoverErosionOutwardsWaveConditionsCalculationEntity_HydraulicLocationCalculationForTargetProbabilityCollectionEntity - ON GrassCoverErosionOutwardsWaveConditionsCalculationEntity (HydraulicLocationCalculationForTargetProbabilityCollectionEntityId ASC) + ON GrassCoverErosionOutwardsWaveConditionsCalculationEntity (HydraulicLocationCalculationForTargetProbabilityCollectionEntityId + ASC) ; CREATE INDEX IXFK_GrassCoverErosionOutwardsWaveConditionsCalculationEntity_HydraulicLocationEntity - ON GrassCoverErosionOutwardsWaveConditionsCalculationEntity (HydraulicLocationEntityId ASC) + ON GrassCoverErosionOutwardsWaveConditionsCalculationEntity (HydraulicLocationEntityId ASC) ; CREATE INDEX IXFK_GrassCoverErosionOutwardsWaveConditionsOutputEntity_GrassCoverErosionOutwardsWaveConditionsCalculationEntity - ON GrassCoverErosionOutwardsWaveConditionsOutputEntity (GrassCoverErosionOutwardsWaveConditionsCalculationEntityId ASC) + ON GrassCoverErosionOutwardsWaveConditionsOutputEntity (GrassCoverErosionOutwardsWaveConditionsCalculationEntityId ASC) ; CREATE INDEX IXFK_GrassCoverSlipOffOutwardsFailureMechanismMetaEntity_FailureMechanismEntity - ON GrassCoverSlipOffOutwardsFailureMechanismMetaEntity (FailureMechanismEntityId ASC) + ON GrassCoverSlipOffOutwardsFailureMechanismMetaEntity (FailureMechanismEntityId ASC) ; CREATE INDEX IXFK_HeightStructure_FailureMechanismEntity - ON HeightStructureEntity (FailureMechanismEntityId ASC) + ON HeightStructureEntity (FailureMechanismEntityId ASC) ; CREATE INDEX IXFK_HeightStructuresCalculationEntity_CalculationGroupEntity - ON HeightStructuresCalculationEntity (CalculationGroupEntityId ASC) + ON HeightStructuresCalculationEntity (CalculationGroupEntityId ASC) ; CREATE INDEX IXFK_HeightStructuresCalculationEntity_ForeshoreProfileEntity - ON HeightStructuresCalculationEntity (ForeshoreProfileEntityId ASC) + ON HeightStructuresCalculationEntity (ForeshoreProfileEntityId ASC) ; CREATE INDEX IXFK_HeightStructuresCalculationEntity_HeightStructureEntity - ON HeightStructuresCalculationEntity (HeightStructureEntityId ASC) + ON HeightStructuresCalculationEntity (HeightStructureEntityId ASC) ; CREATE INDEX IXFK_HeightStructuresCalculationEntity_HydraulicLocationEntity - ON HeightStructuresCalculationEntity (HydraulicLocationEntityId ASC) + ON HeightStructuresCalculationEntity (HydraulicLocationEntityId ASC) ; CREATE INDEX IXFK_HeightStructuresFailureMechanismMetaEntity_FailureMechanismEntity - ON HeightStructuresFailureMechanismMetaEntity (FailureMechanismEntityId ASC) + ON HeightStructuresFailureMechanismMetaEntity (FailureMechanismEntityId ASC) ; CREATE INDEX IXFK_HeightStructuresOutputEntity_HeightStructuresCalculationEntity - ON HeightStructuresOutputEntity (HeightStructuresCalculationEntityId ASC) + ON HeightStructuresOutputEntity (HeightStructuresCalculationEntityId ASC) ; CREATE TRIGGER [TR_AfterDeleteHeightStructuresOutputEntity_RemoveGeneralResultFaultTreeIllustrationPointEntity] - AFTER DELETE - ON HeightStructuresOutputEntity + AFTER +DELETE +ON HeightStructuresOutputEntity FOR EACH ROW BEGIN - DELETE - FROM GeneralResultFaultTreeIllustrationPointEntity - WHERE OLD.GeneralResultFaultTreeIllustrationPointEntityId IS NOT NULL - AND GeneralResultFaultTreeIllustrationPointEntityId IS OLD.GeneralResultFaultTreeIllustrationPointEntityId; +DELETE +FROM GeneralResultFaultTreeIllustrationPointEntity +WHERE OLD.GeneralResultFaultTreeIllustrationPointEntityId IS NOT NULL + AND GeneralResultFaultTreeIllustrationPointEntityId IS OLD.GeneralResultFaultTreeIllustrationPointEntityId; END; ; CREATE INDEX IXFK_HydraulicBoundaryDatabaseEntity_HydraulicBoundaryDataEntity - ON HydraulicBoundaryDatabaseEntity (HydraulicBoundaryDataEntityId ASC) + ON HydraulicBoundaryDatabaseEntity (HydraulicBoundaryDataEntityId ASC) ; CREATE INDEX IXFK_HydraulicBoundaryDatabaseEntity_AssessmentSectionEntity - ON HydraulicBoundaryDataEntity (AssessmentSectionEntityId ASC) + ON HydraulicBoundaryDataEntity (AssessmentSectionEntityId ASC) ; CREATE INDEX IXFK_HydraulicLocationCalculationCollectionHydraulicLocationCalculationEntity_HydraulicLocationCalculationCollectionEntity - ON HydraulicLocationCalculationCollectionHydraulicLocationCalculationEntity (HydraulicLocationCalculationCollectionEntityId ASC) + ON HydraulicLocationCalculationCollectionHydraulicLocationCalculationEntity (HydraulicLocationCalculationCollectionEntityId ASC) ; CREATE INDEX IXFK_HydraulicLocationCalculationCollectionHydraulicLocationCalculationEntity_HydraulicLocationCalculationEntity - ON HydraulicLocationCalculationCollectionHydraulicLocationCalculationEntity (HydraulicLocationCalculationEntityId ASC) + ON HydraulicLocationCalculationCollectionHydraulicLocationCalculationEntity (HydraulicLocationCalculationEntityId ASC) ; CREATE TRIGGER [TR_AfterDeleteHydraulicLocationCalculationCollectionHydraulicLocationCalculationEntity_RemoveHydraulicLocationCalculationEntity] - AFTER DELETE - ON HydraulicLocationCalculationCollectionHydraulicLocationCalculationEntity + AFTER +DELETE +ON HydraulicLocationCalculationCollectionHydraulicLocationCalculationEntity FOR EACH ROW BEGIN - DELETE - FROM HydraulicLocationCalculationEntity - WHERE OLD.HydraulicLocationCalculationEntityId IS NOT NULL - AND HydraulicLocationCalculationEntityId IS OLD.HydraulicLocationCalculationEntityId; +DELETE +FROM HydraulicLocationCalculationEntity +WHERE OLD.HydraulicLocationCalculationEntityId IS NOT NULL + AND HydraulicLocationCalculationEntityId IS OLD.HydraulicLocationCalculationEntityId; END; ; CREATE INDEX IXFK_HydraulicLocationCalculationEntity_HydraulicLocationEntity - ON HydraulicLocationCalculationEntity (HydraulicLocationEntityId ASC) + ON HydraulicLocationCalculationEntity (HydraulicLocationEntityId ASC) ; CREATE INDEX IXFK_HydraulicBoundaryLocationCalculationsForTargetProbabilityEntity_AssessmentSectionEntity - ON HydraulicLocationCalculationForTargetProbabilityCollectionEntity (AssessmentSectionEntityId ASC) + ON HydraulicLocationCalculationForTargetProbabilityCollectionEntity (AssessmentSectionEntityId ASC) ; CREATE INDEX IXFK_HydraulicBoundaryLocationCalculationsForTargetProbabilityHydraulicLocationCalculationEntity_HydraulicBoundaryLocationCalculationsForTargetProbabilityEntity - ON HydraulicLocationCalculationForTargetProbabilityCollectionHydraulicLocationCalculationEntity (HydraulicLocationCalculationForTargetProbabilityCollectionEntityId ASC) + ON HydraulicLocationCalculationForTargetProbabilityCollectionHydraulicLocationCalculationEntity (HydraulicLocationCalculationForTargetProbabilityCollectionEntityId + ASC) ; CREATE INDEX IXFK_HydraulicBoundaryLocationCalculationsForTargetProbabilityHydraulicLocationCalculationEntity_HydraulicLocationCalculationEntity - ON HydraulicLocationCalculationForTargetProbabilityCollectionHydraulicLocationCalculationEntity (HydraulicLocationCalculationEntityId ASC) + ON HydraulicLocationCalculationForTargetProbabilityCollectionHydraulicLocationCalculationEntity (HydraulicLocationCalculationEntityId ASC) ; CREATE TRIGGER [TR_AfterDeleteHydraulicLocationCalculationForTargetProbabilityCollectionHydraulicLocationCalculationEntity_RemoveHydraulicLocationCalculationEntity] - AFTER DELETE - ON HydraulicLocationCalculationForTargetProbabilityCollectionHydraulicLocationCalculationEntity + AFTER +DELETE +ON HydraulicLocationCalculationForTargetProbabilityCollectionHydraulicLocationCalculationEntity FOR EACH ROW BEGIN - DELETE - FROM HydraulicLocationCalculationEntity - WHERE OLD.HydraulicLocationCalculationEntityId IS NOT NULL - AND HydraulicLocationCalculationEntityId IS OLD.HydraulicLocationCalculationEntityId; +DELETE +FROM HydraulicLocationCalculationEntity +WHERE OLD.HydraulicLocationCalculationEntityId IS NOT NULL + AND HydraulicLocationCalculationEntityId IS OLD.HydraulicLocationCalculationEntityId; END; ; CREATE INDEX IXFK_HydraulicLocationOutputEntity_GeneralResultSubMechanismIllustrationPointEntity - ON HydraulicLocationOutputEntity (GeneralResultSubMechanismIllustrationPointEntityId ASC) + ON HydraulicLocationOutputEntity (GeneralResultSubMechanismIllustrationPointEntityId ASC) ; CREATE INDEX IXFK_HydraulicLocationOutputEntity_HydraulicLocationCalculationEntity - ON HydraulicLocationOutputEntity (HydraulicLocationCalculationEntityId ASC) + ON HydraulicLocationOutputEntity (HydraulicLocationCalculationEntityId ASC) ; CREATE TRIGGER [TR_AfterDeleteHydraulicLocationOutputEntity_RemoveGeneralResultSubMechanismIllustrationPointEntity] - AFTER DELETE - ON HydraulicLocationOutputEntity + AFTER +DELETE +ON HydraulicLocationOutputEntity FOR EACH ROW BEGIN - DELETE - FROM GeneralResultSubMechanismIllustrationPointEntity - WHERE OLD.GeneralResultSubMechanismIllustrationPointEntityId IS NOT NULL - AND GeneralResultSubMechanismIllustrationPointEntityId IS OLD.GeneralResultSubMechanismIllustrationPointEntityId; +DELETE +FROM GeneralResultSubMechanismIllustrationPointEntity +WHERE OLD.GeneralResultSubMechanismIllustrationPointEntityId IS NOT NULL + AND GeneralResultSubMechanismIllustrationPointEntityId IS OLD.GeneralResultSubMechanismIllustrationPointEntityId; END; ; CREATE INDEX IXFK_IllustrationPointResultEntity_SubMechanismIllustrationPointEntity - ON IllustrationPointResultEntity (SubMechanismIllustrationPointEntityId ASC) + ON IllustrationPointResultEntity (SubMechanismIllustrationPointEntityId ASC) ; CREATE INDEX IXFK_MacroStabilityInwardsCalculationEntity_CalculationGroupEntity - ON MacroStabilityInwardsCalculationEntity (CalculationGroupEntityId ASC) + ON MacroStabilityInwardsCalculationEntity (CalculationGroupEntityId ASC) ; CREATE INDEX IXFK_MacroStabilityInwardsCalculationEntity_HydraulicLocationEntity - ON MacroStabilityInwardsCalculationEntity (HydraulicLocationEntityId ASC) + ON MacroStabilityInwardsCalculationEntity (HydraulicLocationEntityId ASC) ; CREATE INDEX IXFK_MacroStabilityInwardsCalculationEntity_MacroStabilityInwardsStochasticSoilProfileEntity - ON MacroStabilityInwardsCalculationEntity (MacroStabilityInwardsStochasticSoilProfileEntityId ASC) + ON MacroStabilityInwardsCalculationEntity (MacroStabilityInwardsStochasticSoilProfileEntityId ASC) ; CREATE INDEX IXFK_MacroStabilityInwardsCalculationOutput_MacroStabilityInwardsCalculationEntity - ON MacroStabilityInwardsCalculationOutputEntity (MacroStabilityInwardsCalculationEntityId ASC) + ON MacroStabilityInwardsCalculationOutputEntity (MacroStabilityInwardsCalculationEntityId ASC) ; CREATE INDEX IXFK_MacroStabilityCharacteristicPointEntity_SurfaceLineEntity - ON MacroStabilityInwardsCharacteristicPointEntity (SurfaceLineEntityId ASC) + ON MacroStabilityInwardsCharacteristicPointEntity (SurfaceLineEntityId ASC) ; CREATE INDEX IXFK_MacroStabilityInwardsFailureMechanismMetaEntity_FailureMechanismEntity - ON MacroStabilityInwardsFailureMechanismMetaEntity (FailureMechanismEntityId ASC) + ON MacroStabilityInwardsFailureMechanismMetaEntity (FailureMechanismEntityId ASC) ; CREATE INDEX IXFK_MacroStabilityInwardsSoilLayerOneDEntity_MacroStabilityInwardsSoilProfileOneDEntity - ON MacroStabilityInwardsSoilLayerOneDEntity (MacroStabilityInwardsSoilProfileOneDEntityId ASC) + ON MacroStabilityInwardsSoilLayerOneDEntity (MacroStabilityInwardsSoilProfileOneDEntityId ASC) ; CREATE TRIGGER [TR_AfterDeleteMacroStabilityInwardsSoilProfileTwoDEntity_MacroStabilityInwardsSoilLayerTwoDEntity] - AFTER DELETE - ON MacroStabilityInwardsSoilProfileTwoDEntity + AFTER +DELETE +ON MacroStabilityInwardsSoilProfileTwoDEntity FOR EACH ROW BEGIN - DELETE - FROM MacroStabilityInwardsSoilLayerTwoDEntity - WHERE OLD.MacroStabilityInwardsSoilLayerTwoDEntity IS NOT NULL - AND MacroStabilityInwardsSoilLayerTwoDEntity IS OLD.MacroStabilityInwardsSoilLayerTwoDEntity; +DELETE +FROM MacroStabilityInwardsSoilLayerTwoDEntity +WHERE OLD.MacroStabilityInwardsSoilLayerTwoDEntity IS NOT NULL + AND MacroStabilityInwardsSoilLayerTwoDEntity IS OLD.MacroStabilityInwardsSoilLayerTwoDEntity; END; ; CREATE INDEX IXFK_MacroStabilityInwardsStochasticSoilProfileEntity_StochasticSoilModelEntity - ON MacroStabilityInwardsStochasticSoilProfileEntity (StochasticSoilModelEntityId ASC) + ON MacroStabilityInwardsStochasticSoilProfileEntity (StochasticSoilModelEntityId ASC) ; CREATE TRIGGER [TR_BeforeInsertMacroStabilityInwardsStochasticSoilProfileEntity_MustHaveOneDOrTwoD] BEFORE INSERT ON MacroStabilityInwardsStochasticSoilProfileEntity FOR EACH ROW BEGIN - SELECT - CASE - WHEN - ( - NEW.MacroStabilityInwardsSoilProfileOneDEntityId IS NULL AND NEW.MacroStabilityInwardsSoilProfileTwoDEntityId IS NULL - ) OR ( - NEW.MacroStabilityInwardsSoilProfileOneDEntityId IS NOT NULL AND NEW.MacroStabilityInwardsSoilProfileTwoDEntityId IS NOT NULL - ) - THEN RAISE(FAIL, 'Either SoilProfile1D or SoilProfile2D must be set.') - END; +SELECT CASE + WHEN + ( + NEW.MacroStabilityInwardsSoilProfileOneDEntityId IS NULL AND + NEW.MacroStabilityInwardsSoilProfileTwoDEntityId IS NULL + ) OR ( + NEW.MacroStabilityInwardsSoilProfileOneDEntityId IS NOT NULL AND + NEW.MacroStabilityInwardsSoilProfileTwoDEntityId IS NOT NULL + ) + THEN RAISE(FAIL, 'Either SoilProfile1D or SoilProfile2D must be set.') + END; END; ; CREATE TRIGGER [TR_BeforeUpdateMacroStabilityInwardsStochasticSoilProfileEntity_MustHaveOneDOrTwoD] - BEFORE UPDATE - ON MacroStabilityInwardsStochasticSoilProfileEntity - FOR EACH ROW + BEFORE +UPDATE + ON MacroStabilityInwardsStochasticSoilProfileEntity + FOR EACH ROW BEGIN - SELECT - CASE - WHEN - ( - NEW.MacroStabilityInwardsSoilProfileOneDEntityId IS NULL AND NEW.MacroStabilityInwardsSoilProfileTwoDEntityId IS NULL - ) OR ( - NEW.MacroStabilityInwardsSoilProfileOneDEntityId IS NOT NULL AND NEW.MacroStabilityInwardsSoilProfileTwoDEntityId IS NOT NULL - ) - THEN RAISE(FAIL, 'Either SoilProfile1D or SoilProfile2D must be set.') - END; +SELECT CASE + WHEN + ( + NEW.MacroStabilityInwardsSoilProfileOneDEntityId IS NULL AND + NEW.MacroStabilityInwardsSoilProfileTwoDEntityId IS NULL + ) OR ( + NEW.MacroStabilityInwardsSoilProfileOneDEntityId IS NOT NULL AND + NEW.MacroStabilityInwardsSoilProfileTwoDEntityId IS NOT NULL + ) + THEN RAISE(FAIL, 'Either SoilProfile1D or SoilProfile2D must be set.') + END; END; ; CREATE INDEX IXFK_MicrostabilityFailureMechanismMetaEntity_FailureMechanismEntity - ON MicrostabilityFailureMechanismMetaEntity (FailureMechanismEntityId ASC) + ON MicrostabilityFailureMechanismMetaEntity (FailureMechanismEntityId ASC) ; CREATE INDEX IXFK_NonAdoptableFailureMechanismSectionResultEntity_FailureMechanismSectionEntity - ON NonAdoptableFailureMechanismSectionResultEntity (FailureMechanismSectionEntityId ASC) + ON NonAdoptableFailureMechanismSectionResultEntity (FailureMechanismSectionEntityId ASC) ; CREATE INDEX IXFK_NonAdoptableWithProfileProbabilityFailureMechanismSectionResultEntity_FailureMechanismSectionEntity - ON NonAdoptableWithProfileProbabilityFailureMechanismSectionResultEntity (FailureMechanismSectionEntityId ASC) + ON NonAdoptableWithProfileProbabilityFailureMechanismSectionResultEntity (FailureMechanismSectionEntityId ASC) ; CREATE INDEX IXFK_PipingFailureMechanismMetaEntity_FailureMechanismEntity - ON PipingFailureMechanismMetaEntity (FailureMechanismEntityId ASC) + ON PipingFailureMechanismMetaEntity (FailureMechanismEntityId ASC) ; CREATE INDEX IXFK_PipingStructureFailureMechanismMetaEntity_FailureMechanismEntity - ON PipingStructureFailureMechanismMetaEntity (FailureMechanismEntityId ASC) + ON PipingStructureFailureMechanismMetaEntity (FailureMechanismEntityId ASC) ; CREATE INDEX IXFK_ProbabilisticPipingCalculationEntity_CalculationGroupEntity - ON ProbabilisticPipingCalculationEntity (CalculationGroupEntityId ASC) + ON ProbabilisticPipingCalculationEntity (CalculationGroupEntityId ASC) ; CREATE INDEX IXFK_ProbabilisticPipingCalculationEntity_HydraulicLocationEntity - ON ProbabilisticPipingCalculationEntity (HydraulicLocationEntityId ASC) + ON ProbabilisticPipingCalculationEntity (HydraulicLocationEntityId ASC) ; CREATE INDEX IXFK_ProbabilisticPipingCalculationEntity_PipingStochasticSoilProfileEntity - ON ProbabilisticPipingCalculationEntity (PipingStochasticSoilProfileEntityId ASC) + ON ProbabilisticPipingCalculationEntity (PipingStochasticSoilProfileEntityId ASC) ; CREATE INDEX IXFK_ProbabilisticPipingCalculationEntity_SurfaceLineEntity - ON ProbabilisticPipingCalculationEntity (SurfaceLineEntityId ASC) + ON ProbabilisticPipingCalculationEntity (SurfaceLineEntityId ASC) ; CREATE INDEX IXFK_ProbabilisticPipingCalculationOutputEntity_ProbabilisticPipingCalculationEntity - ON ProbabilisticPipingCalculationOutputEntity (ProbabilisticPipingCalculationEntityId ASC) + ON ProbabilisticPipingCalculationOutputEntity (ProbabilisticPipingCalculationEntityId ASC) ; CREATE INDEX IXFK_ProbabilisticPipingCalculationOutputEntity_Profile_GeneralResultFaultTreeIllustrationPointEntity - ON ProbabilisticPipingCalculationOutputEntity (ProfileSpecificGeneralResultFaultTreeIllustrationPointEntityId ASC) + ON ProbabilisticPipingCalculationOutputEntity (ProfileSpecificGeneralResultFaultTreeIllustrationPointEntityId ASC) ; CREATE INDEX IXFK_ProbabilisticPipingCalculationOutputEntity_Profile_GeneralResultSubMechanismIllustrationPointEntity - ON ProbabilisticPipingCalculationOutputEntity (ProfileSpecificGeneralResultSubMechanismIllustrationPointEntityId ASC) + ON ProbabilisticPipingCalculationOutputEntity (ProfileSpecificGeneralResultSubMechanismIllustrationPointEntityId ASC) ; CREATE INDEX IXFK_ProbabilisticPipingCalculationOutputEntity_Section_GeneralResultFaultTreeIllustrationPointEntity - ON ProbabilisticPipingCalculationOutputEntity (ProfileSpecificGeneralResultFaultTreeIllustrationPointEntityId ASC) + ON ProbabilisticPipingCalculationOutputEntity (ProfileSpecificGeneralResultFaultTreeIllustrationPointEntityId ASC) ; CREATE INDEX IXFK_ProbabilisticPipingCalculationOutputEntity_Section_GeneralResultSubMechanismIllustrationPointEntity - ON ProbabilisticPipingCalculationOutputEntity (SectionSpecificGeneralResultSubMechanismIllustrationPointEntityId ASC) + ON ProbabilisticPipingCalculationOutputEntity (SectionSpecificGeneralResultSubMechanismIllustrationPointEntityId ASC) ; CREATE INDEX IXFK_SemiProbabilisticPipingCalculationOutputEntity_SemiProbabilisticPipingCalculationEntity - ON SemiProbabilisticPipingCalculationOutputEntity (SemiProbabilisticPipingCalculationEntityId ASC) + ON SemiProbabilisticPipingCalculationOutputEntity (SemiProbabilisticPipingCalculationEntityId ASC) ; CREATE INDEX IXFK_SpecificFailureMechanismEntity_AssessmentSectionEntity - ON SpecificFailureMechanismEntity (AssessmentSectionEntityId ASC) + ON SpecificFailureMechanismEntity (AssessmentSectionEntityId ASC) ; CREATE INDEX IXFK_SpecificFailureMechanismFailureMechanismSectionEntity_FailureMechanismSectionEntity - ON SpecificFailureMechanismFailureMechanismSectionEntity (FailureMechanismSectionEntityId ASC) + ON SpecificFailureMechanismFailureMechanismSectionEntity (FailureMechanismSectionEntityId ASC) ; CREATE INDEX IXFK_SpecificFailureMechanismFailureMechanismSectionEntity_SpecificFailureMechanismEntity - ON SpecificFailureMechanismFailureMechanismSectionEntity (SpecificFailureMechanismEntityId ASC) + ON SpecificFailureMechanismFailureMechanismSectionEntity (SpecificFailureMechanismEntityId ASC) ; CREATE TRIGGER [TR_AfterDeleteSpecificFailureMechanismFailureMechanismSectionEntity_RemoveFailureMechanismSectionEntityId] - AFTER DELETE - ON SpecificFailureMechanismFailureMechanismSectionEntity + AFTER +DELETE +ON SpecificFailureMechanismFailureMechanismSectionEntity FOR EACH ROW BEGIN - DELETE - FROM FailureMechanismSectionEntity - WHERE OLD.FailureMechanismSectionEntityId IS NOT NULL - AND FailureMechanismSectionEntityId IS OLD.FailureMechanismSectionEntityId; +DELETE +FROM FailureMechanismSectionEntity +WHERE OLD.FailureMechanismSectionEntityId IS NOT NULL + AND FailureMechanismSectionEntityId IS OLD.FailureMechanismSectionEntityId; END; ; CREATE INDEX IXFK_StabilityPointStructureEntity_FailureMechanismEntity - ON StabilityPointStructureEntity (FailureMechanismEntityId ASC) + ON StabilityPointStructureEntity (FailureMechanismEntityId ASC) ; CREATE INDEX IXFK_StabilityPointStructuresCalculationEntity_CalculationGroupEntity - ON StabilityPointStructuresCalculationEntity (CalculationGroupEntityId ASC) + ON StabilityPointStructuresCalculationEntity (CalculationGroupEntityId ASC) ; CREATE INDEX IXFK_StabilityPointStructuresCalculationEntity_ForeshoreProfileEntity - ON StabilityPointStructuresCalculationEntity (ForeshoreProfileEntityId ASC) + ON StabilityPointStructuresCalculationEntity (ForeshoreProfileEntityId ASC) ; CREATE INDEX IXFK_StabilityPointStructuresCalculationEntity_HydraulicLocationEntity - ON StabilityPointStructuresCalculationEntity (HydraulicLocationEntityId ASC) + ON StabilityPointStructuresCalculationEntity (HydraulicLocationEntityId ASC) ; CREATE INDEX IXFK_StabilityPointStructuresCalculationEntity_StabilityPointStructureEntity - ON StabilityPointStructuresCalculationEntity (StabilityPointStructureEntityId ASC) + ON StabilityPointStructuresCalculationEntity (StabilityPointStructureEntityId ASC) ; CREATE INDEX IXFK_StrengthStabilityPointConstructionFailureMechanismMetaEntity_FailureMechanismEntity - ON StabilityPointStructuresFailureMechanismMetaEntity (FailureMechanismEntityId ASC) + ON StabilityPointStructuresFailureMechanismMetaEntity (FailureMechanismEntityId ASC) ; CREATE INDEX IXFK_StabilityPointStructuresOutputEntity_StabilityPointStructuresCalculationEntity - ON StabilityPointStructuresOutputEntity (StabilityPointStructuresCalculationEntityId ASC) + ON StabilityPointStructuresOutputEntity (StabilityPointStructuresCalculationEntityId ASC) ; CREATE TRIGGER [TR_AfterDeleteStabilityPointStructuresOutputEntity_RemoveGeneralResultFaultTreeIllustrationPointEntity] - AFTER DELETE - ON StabilityPointStructuresOutputEntity + AFTER +DELETE +ON StabilityPointStructuresOutputEntity FOR EACH ROW BEGIN - DELETE - FROM GeneralResultFaultTreeIllustrationPointEntity - WHERE OLD.GeneralResultFaultTreeIllustrationPointEntityId IS NOT NULL - AND GeneralResultFaultTreeIllustrationPointEntityId IS OLD.GeneralResultFaultTreeIllustrationPointEntityId; +DELETE +FROM GeneralResultFaultTreeIllustrationPointEntity +WHERE OLD.GeneralResultFaultTreeIllustrationPointEntityId IS NOT NULL + AND GeneralResultFaultTreeIllustrationPointEntityId IS OLD.GeneralResultFaultTreeIllustrationPointEntityId; END; ; CREATE INDEX IXFK_StabilityStoneCoverFailureMechanismMetaEntity_FailureMechanismEntity - ON StabilityStoneCoverFailureMechanismMetaEntity (FailureMechanismEntityId ASC) + ON StabilityStoneCoverFailureMechanismMetaEntity (FailureMechanismEntityId ASC) ; CREATE INDEX IXFK_StabilityStoneCoverWaveConditionsCalculationEntity_CalculationGroupEntity - ON StabilityStoneCoverWaveConditionsCalculationEntity (CalculationGroupEntityId ASC) + ON StabilityStoneCoverWaveConditionsCalculationEntity (CalculationGroupEntityId ASC) ; CREATE INDEX IXFK_StabilityStoneCoverWaveConditionsCalculationEntity_ForeshoreProfileEntity - ON StabilityStoneCoverWaveConditionsCalculationEntity (ForeshoreProfileEntityId ASC) + ON StabilityStoneCoverWaveConditionsCalculationEntity (ForeshoreProfileEntityId ASC) ; CREATE INDEX IXFK_StabilityStoneCoverWaveConditionsCalculationEntity_HydraulicLocationCalculationForTargetProbabilityCollectionEntity - ON StabilityStoneCoverWaveConditionsCalculationEntity (HydraulicLocationCalculationForTargetProbabilityCollectionEntityId ASC) + ON StabilityStoneCoverWaveConditionsCalculationEntity (HydraulicLocationCalculationForTargetProbabilityCollectionEntityId + ASC) ; CREATE INDEX IXFK_StabilityStoneCoverWaveConditionsCalculationEntity_HydraulicLocationEntity - ON StabilityStoneCoverWaveConditionsCalculationEntity (HydraulicLocationEntityId ASC) + ON StabilityStoneCoverWaveConditionsCalculationEntity (HydraulicLocationEntityId ASC) ; CREATE INDEX IXFK_StabilityStoneCoverWaveConditionsOutputEntity_StabilityStoneCoverWaveConditionsCalculationEntity - ON StabilityStoneCoverWaveConditionsOutputEntity (StabilityStoneCoverWaveConditionsCalculationEntityId ASC) + ON StabilityStoneCoverWaveConditionsOutputEntity (StabilityStoneCoverWaveConditionsCalculationEntityId ASC) ; CREATE INDEX IXFK_SubMechanismIllustrationPointStochast_SubMechanismIllustrationPointEntity - ON SubMechanismIllustrationPointStochastEntity (SubMechanismIllustrationPointEntityId ASC) + ON SubMechanismIllustrationPointStochastEntity (SubMechanismIllustrationPointEntityId ASC) ; CREATE INDEX IXFK_TopLevelFaultTreeIllustrationPointEntity_FaultTreeIllustrationPointEntity - ON TopLevelFaultTreeIllustrationPointEntity (FaultTreeIllustrationPointEntityId ASC) + ON TopLevelFaultTreeIllustrationPointEntity (FaultTreeIllustrationPointEntityId ASC) ; CREATE INDEX IXFK_TopLevelFaultTreeIllustrationPointEntity_GeneralResultFaultTreeIllustrationPointEntity - ON TopLevelFaultTreeIllustrationPointEntity (GeneralResultFaultTreeIllustrationPointEntityId ASC) + ON TopLevelFaultTreeIllustrationPointEntity (GeneralResultFaultTreeIllustrationPointEntityId ASC) ; CREATE TRIGGER [TR_AfterDeleteTopLevelFaultTreeIllustrationPointEntity_RemoveFaultTreeIllustrationPointEntity] - AFTER DELETE - ON TopLevelFaultTreeIllustrationPointEntity + AFTER +DELETE +ON TopLevelFaultTreeIllustrationPointEntity FOR EACH ROW BEGIN - DELETE - FROM FaultTreeIllustrationPointEntity - WHERE OLD.FaultTreeIllustrationPointEntityId IS NOT NULL - AND FaultTreeIllustrationPointEntityId IS OLD.FaultTreeIllustrationPointEntityId; +DELETE +FROM FaultTreeIllustrationPointEntity +WHERE OLD.FaultTreeIllustrationPointEntityId IS NOT NULL + AND FaultTreeIllustrationPointEntityId IS OLD.FaultTreeIllustrationPointEntityId; END; ; CREATE INDEX IXFK_TopLevelSubMechanismIllustrationPointEntity_GeneralResultSubMechanismIllustrationPointEntity - ON TopLevelSubMechanismIllustrationPointEntity (GeneralResultSubMechanismIllustrationPointEntityId ASC) + ON TopLevelSubMechanismIllustrationPointEntity (GeneralResultSubMechanismIllustrationPointEntityId ASC) ; CREATE INDEX IXFK_TopLevelSubMechanismIllustrationPointEntity_SubMechanismIllustrationPointEntity - ON TopLevelSubMechanismIllustrationPointEntity (SubMechanismIllustrationPointEntityId ASC) + ON TopLevelSubMechanismIllustrationPointEntity (SubMechanismIllustrationPointEntityId ASC) ; CREATE TRIGGER [TR_AfterDeleteTopLevelSubMechanismIllustrationPointEntity_RemoveSubMechanismIllustrationPointEntity] - AFTER DELETE - ON TopLevelSubMechanismIllustrationPointEntity + AFTER +DELETE +ON TopLevelSubMechanismIllustrationPointEntity FOR EACH ROW BEGIN - DELETE - FROM SubMechanismIllustrationPointEntity - WHERE OLD.SubMechanismIllustrationPointEntityId IS NOT NULL - AND SubMechanismIllustrationPointEntityId IS OLD.SubMechanismIllustrationPointEntityId; +DELETE +FROM SubMechanismIllustrationPointEntity +WHERE OLD.SubMechanismIllustrationPointEntityId IS NOT NULL + AND SubMechanismIllustrationPointEntityId IS OLD.SubMechanismIllustrationPointEntityId; END; ; CREATE INDEX IXFK_WaveImpactAsphaltCoverWaveConditionsCalculationEntity_CalculationGroupEntity - ON WaveImpactAsphaltCoverWaveConditionsCalculationEntity (CalculationGroupEntityId ASC) + ON WaveImpactAsphaltCoverWaveConditionsCalculationEntity (CalculationGroupEntityId ASC) ; CREATE INDEX IXFK_WaveImpactAsphaltCoverWaveConditionsCalculationEntity_ForeshoreProfileEntity - ON WaveImpactAsphaltCoverWaveConditionsCalculationEntity (ForeshoreProfileEntityId ASC) + ON WaveImpactAsphaltCoverWaveConditionsCalculationEntity (ForeshoreProfileEntityId ASC) ; CREATE INDEX IXFK_WaveImpactAsphaltCoverWaveConditionsCalculationEntity_HydraulicLocationCalculationForTargetProbabilityCollectionEntity - ON WaveImpactAsphaltCoverWaveConditionsCalculationEntity (HydraulicLocationCalculationForTargetProbabilityCollectionEntityId ASC) + ON WaveImpactAsphaltCoverWaveConditionsCalculationEntity (HydraulicLocationCalculationForTargetProbabilityCollectionEntityId + ASC) ; CREATE INDEX IXFK_WaveImpactAsphaltCoverWaveConditionsCalculationEntity_HydraulicLocationEntity - ON WaveImpactAsphaltCoverWaveConditionsCalculationEntity (HydraulicLocationEntityId ASC) + ON WaveImpactAsphaltCoverWaveConditionsCalculationEntity (HydraulicLocationEntityId ASC) ; CREATE INDEX IXFK_WaveImpactAsphaltCoverWaveConditionsOutputEntity_WaveImpactAsphaltCoverWaveConditionsCalculationEntity - ON WaveImpactAsphaltCoverWaveConditionsOutputEntity (WaveImpactAsphaltCoverWaveConditionsCalculationEntityId ASC) + ON WaveImpactAsphaltCoverWaveConditionsOutputEntity (WaveImpactAsphaltCoverWaveConditionsCalculationEntityId ASC) ;