/* ---------------------------------------------------- */ /* Generated by Enterprise Architect Version 16.1 */ /* Created On : 12-mei-2023 15:15:12 */ /* DBMS : SQLite */ /* ---------------------------------------------------- */ /* Drop Tables */ DROP TABLE IF EXISTS VersionEntity ; DROP TABLE IF EXISTS ProjectEntity ; DROP TABLE IF EXISTS AssessmentSectionEntity ; DROP TABLE IF EXISTS FailureMechanismSectionEntity ; DROP TABLE IF EXISTS FailureMechanismEntity ; DROP TABLE IF EXISTS ClosingStructuresFailureMechanismMetaEntity ; DROP TABLE IF EXISTS CalculationGroupEntity ; DROP TABLE IF EXISTS HydraulicLocationEntity ; DROP TABLE IF EXISTS GrassCoverErosionInwardsFailureMechanismMetaEntity ; DROP TABLE IF EXISTS SemiProbabilisticPipingCalculationEntity ; DROP TABLE IF EXISTS GrassCoverErosionInwardsCalculationEntity ; DROP TABLE IF EXISTS GrassCoverSlipOffInwardsFailureMechanismMetaEntity ; DROP TABLE IF EXISTS GrassCoverErosionOutwardsFailureMechanismMetaEntity ; DROP TABLE IF EXISTS PipingSoilLayerEntity ; DROP TABLE IF EXISTS PipingSoilProfileEntity ; DROP TABLE IF EXISTS PipingStochasticSoilProfileEntity ; DROP TABLE IF EXISTS PipingScenarioConfigurationPerFailureMechanismSectionEntity ; DROP TABLE IF EXISTS StochasticSoilModelEntity ; DROP TABLE IF EXISTS SurfaceLineEntity ; DROP TABLE IF EXISTS PipingCharacteristicPointEntity ; DROP TABLE IF EXISTS WaterPressureAsphaltCoverFailureMechanismMetaEntity ; DROP TABLE IF EXISTS WaveImpactAsphaltCoverFailureMechanismMetaEntity ; DROP TABLE IF EXISTS AdoptableFailureMechanismSectionResultEntity ; DROP TABLE IF EXISTS AdoptableWithProfileProbabilityFailureMechanismSectionResultEntity ; DROP TABLE IF EXISTS BackgroundDataEntity ; DROP TABLE IF EXISTS BackgroundDataMetaEntity ; DROP TABLE IF EXISTS ClosingStructureEntity ; DROP TABLE IF EXISTS ClosingStructuresCalculationEntity ; DROP TABLE IF EXISTS ClosingStructuresOutputEntity ; DROP TABLE IF EXISTS DikeProfileEntity ; DROP TABLE IF EXISTS DuneErosionFailureMechanismMetaEntity ; DROP TABLE IF EXISTS DuneLocationCalculationEntity ; DROP TABLE IF EXISTS DuneLocationCalculationForTargetProbabilityCollectionEntity ; DROP TABLE IF EXISTS DuneLocationCalculationOutputEntity ; DROP TABLE IF EXISTS DuneLocationEntity ; DROP TABLE IF EXISTS FailureMechanismFailureMechanismSectionEntity ; DROP TABLE IF EXISTS FaultTreeIllustrationPointEntity ; DROP TABLE IF EXISTS FaultTreeIllustrationPointStochastEntity ; DROP TABLE IF EXISTS FaultTreeSubmechanismIllustrationPointEntity ; DROP TABLE IF EXISTS ForeshoreProfileEntity ; DROP TABLE IF EXISTS GeneralResultFaultTreeIllustrationPointEntity ; DROP TABLE IF EXISTS GeneralResultFaultTreeIllustrationPointStochastEntity ; DROP TABLE IF EXISTS GeneralResultSubMechanismIllustrationPointEntity ; DROP TABLE IF EXISTS GeneralResultSubMechanismIllustrationPointStochastEntity ; DROP TABLE IF EXISTS GrassCoverErosionInwardsDikeHeightOutputEntity ; DROP TABLE IF EXISTS GrassCoverErosionInwardsOutputEntity ; DROP TABLE IF EXISTS GrassCoverErosionInwardsOvertoppingRateOutputEntity ; DROP TABLE IF EXISTS GrassCoverErosionOutwardsWaveConditionsCalculationEntity ; DROP TABLE IF EXISTS GrassCoverErosionOutwardsWaveConditionsOutputEntity ; DROP TABLE IF EXISTS GrassCoverSlipOffOutwardsFailureMechanismMetaEntity ; DROP TABLE IF EXISTS HeightStructureEntity ; DROP TABLE IF EXISTS HeightStructuresCalculationEntity ; DROP TABLE IF EXISTS HeightStructuresFailureMechanismMetaEntity ; DROP TABLE IF EXISTS HeightStructuresOutputEntity ; DROP TABLE IF EXISTS HydraulicBoundaryDatabaseEntity ; DROP TABLE IF EXISTS HydraulicBoundaryDataEntity ; DROP TABLE IF EXISTS HydraulicLocationCalculationCollectionEntity ; DROP TABLE IF EXISTS HydraulicLocationCalculationCollectionHydraulicLocationCalculationEntity ; DROP TABLE IF EXISTS HydraulicLocationCalculationEntity ; DROP TABLE IF EXISTS HydraulicLocationCalculationForTargetProbabilityCollectionEntity ; DROP TABLE IF EXISTS HydraulicLocationCalculationForTargetProbabilityCollectionHydraulicLocationCalculationEntity ; DROP TABLE IF EXISTS HydraulicLocationOutputEntity ; DROP TABLE IF EXISTS IllustrationPointResultEntity ; DROP TABLE IF EXISTS MacroStabilityInwardsCalculationEntity ; DROP TABLE IF EXISTS MacroStabilityInwardsCalculationOutputEntity ; DROP TABLE IF EXISTS MacroStabilityInwardsCharacteristicPointEntity ; DROP TABLE IF EXISTS MacroStabilityInwardsFailureMechanismMetaEntity ; DROP TABLE IF EXISTS MacroStabilityInwardsPreconsolidationStressEntity ; DROP TABLE IF EXISTS MacroStabilityInwardsSoilLayerOneDEntity ; DROP TABLE IF EXISTS MacroStabilityInwardsSoilLayerTwoDEntity ; DROP TABLE IF EXISTS MacroStabilityInwardsSoilProfileOneDEntity ; DROP TABLE IF EXISTS MacroStabilityInwardsSoilProfileTwoDEntity ; DROP TABLE IF EXISTS MacroStabilityInwardsSoilProfileTwoDSoilLayerTwoDEntity ; DROP TABLE IF EXISTS MacroStabilityInwardsStochasticSoilProfileEntity ; DROP TABLE IF EXISTS MicrostabilityFailureMechanismMetaEntity ; DROP TABLE IF EXISTS NonAdoptableFailureMechanismSectionResultEntity ; DROP TABLE IF EXISTS NonAdoptableWithProfileProbabilityFailureMechanismSectionResultEntity ; DROP TABLE IF EXISTS PipingFailureMechanismMetaEntity ; DROP TABLE IF EXISTS PipingStructureFailureMechanismMetaEntity ; DROP TABLE IF EXISTS ProbabilisticPipingCalculationEntity ; DROP TABLE IF EXISTS ProbabilisticPipingCalculationOutputEntity ; DROP TABLE IF EXISTS SemiProbabilisticPipingCalculationOutputEntity ; DROP TABLE IF EXISTS SpecificFailureMechanismEntity ; DROP TABLE IF EXISTS SpecificFailureMechanismFailureMechanismSectionEntity ; DROP TABLE IF EXISTS StabilityPointStructureEntity ; DROP TABLE IF EXISTS StabilityPointStructuresCalculationEntity ; DROP TABLE IF EXISTS StabilityPointStructuresFailureMechanismMetaEntity ; DROP TABLE IF EXISTS StabilityPointStructuresOutputEntity ; DROP TABLE IF EXISTS StabilityStoneCoverFailureMechanismMetaEntity ; DROP TABLE IF EXISTS StabilityStoneCoverWaveConditionsCalculationEntity ; DROP TABLE IF EXISTS StabilityStoneCoverWaveConditionsOutputEntity ; DROP TABLE IF EXISTS StochastEntity ; DROP TABLE IF EXISTS SubMechanismIllustrationPointEntity ; DROP TABLE IF EXISTS SubMechanismIllustrationPointStochastEntity ; DROP TABLE IF EXISTS TopLevelFaultTreeIllustrationPointEntity ; DROP TABLE IF EXISTS TopLevelSubMechanismIllustrationPointEntity ; DROP TABLE IF EXISTS WaveImpactAsphaltCoverWaveConditionsCalculationEntity ; DROP TABLE IF EXISTS WaveImpactAsphaltCoverWaveConditionsOutputEntity ; /* Create Tables with Primary and Foreign Keys, Check and Unique Constraints */ CREATE TABLE VersionEntity ( 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 ) ; 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) ) ; CREATE TABLE FailureMechanismSectionEntity ( 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, AutomaticIndependentSections = 2, AutomaticWorstSectionOrProfile = 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 ) ; 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 ) ; 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 ) ; 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 ) ; 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 ) ; 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 ) ; 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 ) ; 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 ) ; 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 ) ; 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 ) ; 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 ) ; 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 ) ; 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) ) ; 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) ) ; 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 ) ; 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 ) ; 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 ) ; 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 ) ; 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 ) ; 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 ) ; 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') ) ; 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) ) ; 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 ) ; 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) ) ; 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) ) ; 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 ) ; 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 ) ; 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 ) ; 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 ) ; 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 ) ; 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 ) ; 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 ) ; 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 ) ; 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 ) ; 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) ) ; CREATE TABLE GeneralResultFaultTreeIllustrationPointEntity ( 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 ) ; CREATE TABLE GeneralResultSubMechanismIllustrationPointEntity ( 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 ) ; 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) ) ; 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) ) ; 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) ) ; 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 ) ; 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 ) ; 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 ) ; 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) ) ; 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 ) ; 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 ) ; 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) ) ; 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 ) ; 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 ) ; CREATE TABLE HydraulicLocationCalculationCollectionEntity ( 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 ) ; 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 ) ; 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 ) ; 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 ) ; 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 ) ; 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 ) ; 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 ) ; 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 ) ; 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 ) ; 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 ) ; 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 ) ; 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 ) ; 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 ) ; CREATE TABLE MacroStabilityInwardsSoilProfileOneDEntity ( 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 ) ; 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 ) ; 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 ) ; 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 ) ; 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 ) ; 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 ) ; 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 ) ; 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 ) ; 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 ) ; 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) ) ; 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) ) ; 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, AutomaticIndependentSections = 2, AutomaticWorstSectionOrProfile = 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 ) ; 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) ) ; 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 ) ; 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 ) ; 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) ) ; 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 ) ; 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 ) ; 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 ) ; 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 ) ; 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 ) ; 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 ) ; 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 ) ; 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 ) ; 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 ) ; 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 ) ; /* Create Indexes and Triggers */ CREATE INDEX IXFK_AssessmentSectionEntity_HydraulicLocationCalculationCollectionEntity1 ON AssessmentSectionEntity (HydraulicLocationCalculationCollectionEntity1Id ASC) ; CREATE INDEX IXFK_AssessmentSectionEntity_HydraulicLocationCalculationCollectionEntity2 ON AssessmentSectionEntity (HydraulicLocationCalculationCollectionEntity2Id ASC) ; CREATE INDEX IXFK_AssessmentSectionEntity_ProjectEntity ON AssessmentSectionEntity (ProjectEntityId ASC) ; CREATE TRIGGER [TR_AfterDeleteAssessmentSectionEntity_RemoveHydraulicLocationCalculationCollectionEntities] AFTER DELETE ON AssessmentSectionEntity FOR EACH ROW BEGIN DELETE FROM HydraulicLocationCalculationCollectionEntity WHERE HydraulicLocationCalculationCollectionEntityId IS OLD.HydraulicLocationCalculationCollectionEntity1Id OR HydraulicLocationCalculationCollectionEntityId IS OLD.HydraulicLocationCalculationCollectionEntity2Id; END; ; CREATE INDEX IXFK_FailureMechanismEntity_AssessmentSectionEntity ON FailureMechanismEntity (AssessmentSectionEntityId ASC) ; CREATE INDEX IXFK_FailureMechanismEntity_CalculationGroupEntity ON FailureMechanismEntity (CalculationGroupEntityId ASC) ; CREATE INDEX IXFK_ClosingStructuresFailureMechanismMetaEntity_FailureMechanismEntity ON ClosingStructuresFailureMechanismMetaEntity (FailureMechanismEntityId ASC) ; CREATE INDEX IXFK_CalculationGroupEntity_CalculationGroupEntity ON CalculationGroupEntity (ParentCalculationGroupEntityId ASC) ; CREATE INDEX IXFK_HydraulicLocationEntity_HydraulicBoundaryDatabaseEntity ON HydraulicLocationEntity (HydraulicBoundaryDatabaseEntityId ASC) ; CREATE INDEX IXFK_GrassCoverErosionInwardsFailureMechanismMetaEntity_FailureMechanismEntity ON GrassCoverErosionInwardsFailureMechanismMetaEntity (FailureMechanismEntityId ASC) ; CREATE INDEX IXFK_SemiProbabilisticPipingCalculationEntity_PipingStochasticSoilProfileEntity ON SemiProbabilisticPipingCalculationEntity (PipingStochasticSoilProfileEntityId ASC) ; CREATE INDEX IXFK_SemiProbabilisticPipingCalculationEntity_SurfaceLineEntity ON SemiProbabilisticPipingCalculationEntity (SurfaceLineEntityId ASC) ; CREATE INDEX IXFK_SemiProbabilisticPipingCalculationEntity_HydraulicLocationEntity ON SemiProbabilisticPipingCalculationEntity (HydraulicLocationEntityId ASC) ; CREATE INDEX IXFK_SemiProbabilisticPipingCalculationEntity_CalculationGroupEntity ON SemiProbabilisticPipingCalculationEntity (CalculationGroupEntityId ASC) ; CREATE INDEX IXFK_GrassCoverErosionInwardsCalculationEntity_CalculationGroupEntity ON GrassCoverErosionInwardsCalculationEntity (CalculationGroupEntityId ASC) ; CREATE INDEX IXFK_GrassCoverErosionInwardsCalculationEntity_DikeProfileEntity ON GrassCoverErosionInwardsCalculationEntity (DikeProfileEntityId ASC) ; CREATE INDEX IXFK_GrassCoverErosionInwardsCalculationEntity_HydraulicLocationEntity ON GrassCoverErosionInwardsCalculationEntity (HydraulicLocationEntityId ASC) ; CREATE INDEX IXFK_GrassCoverSlipOffInwardsFailureMechanismMetaEntity_FailureMechanismEntity ON GrassCoverSlipOffInwardsFailureMechanismMetaEntity (FailureMechanismEntityId ASC) ; CREATE INDEX IXFK_GrassCoverErosionOutwardsFailureMechanismMetaEntity_FailureMechanismEntity ON GrassCoverErosionOutwardsFailureMechanismMetaEntity (FailureMechanismEntityId ASC) ; CREATE INDEX IXFK_PipingStochasticSoilProfileEntity_SoilProfileEntity ON PipingStochasticSoilProfileEntity (PipingSoilProfileEntityId ASC) ; CREATE INDEX IXFK_PipingStochasticSoilProfileEntity_StochasticSoilModelEntity ON PipingStochasticSoilProfileEntity (StochasticSoilModelEntityId ASC) ; CREATE INDEX IXFK_PipingScenarioConfigurationPerFailureMechanismSectionEntity_FailureMechanismSectionEntity ON PipingScenarioConfigurationPerFailureMechanismSectionEntity (FailureMechanismSectionEntityId ASC) ; CREATE INDEX IXFK_StochasticSoilModelEntity_FailureMechanismEntity ON StochasticSoilModelEntity (FailureMechanismEntityId ASC) ; CREATE INDEX IXFK_SurfaceLineEntity_FailureMechanismEntity ON SurfaceLineEntity (FailureMechanismEntityId ASC) ; CREATE INDEX IXFK_SurfaceLinePointEntity_SurfaceLineEntity ON PipingCharacteristicPointEntity (SurfaceLineEntityId ASC) ; CREATE INDEX IXFK_WaterPressureAsphaltCoverFailureMechanismMetaEntity_FailureMechanismEntity ON WaterPressureAsphaltCoverFailureMechanismMetaEntity (FailureMechanismEntityId ASC) ; CREATE INDEX IXFK_WaveImpactAsphaltCoverFailureMechanismMetaEntity_FailureMechanismEntity ON WaveImpactAsphaltCoverFailureMechanismMetaEntity (FailureMechanismEntityId ASC) ; CREATE INDEX IXFK_AdoptableFailureMechanismSectionResultEntity_FailureMechanismSectionEntity ON AdoptableFailureMechanismSectionResultEntity (FailureMechanismSectionEntityId ASC) ; CREATE INDEX IXFK_AdoptableWithProfileProbabilityFailureMechanismSectionResultEntity_FailureMechanismSectionEntity ON AdoptableWithProfileProbabilityFailureMechanismSectionResultEntity (FailureMechanismSectionEntityId ASC) ; CREATE INDEX IXFK_BackgroundDataEntity_AssessmentSectionEntity ON BackgroundDataEntity (AssessmentSectionEntityId ASC) ; CREATE INDEX IXFK_BackgroundDataMetaEntity_BackgroundDataEntity ON BackgroundDataMetaEntity (BackgroundDataEntityId ASC) ; CREATE INDEX IXFK_ClosingStructureEntity_FailureMechanismEntity ON ClosingStructureEntity (FailureMechanismEntityId ASC) ; CREATE INDEX IXFK_ClosingStructuresCalculationEntity_CalculationGroupEntity ON ClosingStructuresCalculationEntity (CalculationGroupEntityId ASC) ; CREATE INDEX IXFK_ClosingStructuresCalculationEntity_ClosingStructureEntity ON ClosingStructuresCalculationEntity (ClosingStructureEntityId ASC) ; CREATE INDEX IXFK_ClosingStructuresCalculationEntity_ForeshoreProfileEntity ON ClosingStructuresCalculationEntity (ForeshoreProfileEntityId ASC) ; CREATE INDEX IXFK_ClosingStructuresCalculationEntity_HydraulicLocationEntity ON ClosingStructuresCalculationEntity (HydraulicLocationEntityId ASC) ; CREATE INDEX IXFK_ClosingStructuresOutputEntity_ClosingStructuresCalculationEntity ON ClosingStructuresOutputEntity (ClosingStructuresCalculationEntityId ASC) ; CREATE TRIGGER [TR_AfterDeleteClosingStructuresOutputEntity_RemoveGeneralResultFaultTreeIllustrationPointEntity] AFTER DELETE ON ClosingStructuresOutputEntity FOR EACH ROW BEGIN DELETE FROM GeneralResultFaultTreeIllustrationPointEntity WHERE OLD.GeneralResultFaultTreeIllustrationPointEntityId IS NOT NULL AND GeneralResultFaultTreeIllustrationPointEntityId IS OLD.GeneralResultFaultTreeIllustrationPointEntityId; END; ; CREATE INDEX IXFK_DikeProfileEntity_FailureMechanismEntity ON DikeProfileEntity (FailureMechanismEntityId ASC) ; CREATE INDEX IXFK_DuneErosionFailureMechanismMetaEntity_FailureMechanismEntity ON DuneErosionFailureMechanismMetaEntity (FailureMechanismEntityId ASC) ; CREATE INDEX IXFK_DuneLocationCalculationEntity_DuneLocationCalculationCollectionEntity ON DuneLocationCalculationEntity (DuneLocationCalculationForTargetProbabilityCollectionEntityId ASC) ; CREATE INDEX IXFK_DuneLocationCalculationEntity_DuneLocationEntity ON DuneLocationCalculationEntity (DuneLocationEntityId ASC) ; CREATE INDEX IXFK_DuneLocationCalculationForTargetProbabilityCollectionEntity_DuneErosionFailureMechanismMetaEntity ON DuneLocationCalculationForTargetProbabilityCollectionEntity (DuneErosionFailureMechanismMetaEntityId ASC) ; CREATE INDEX IXFK_DuneLocationCalculationOutputEntity_DuneLocationCalculationEntity ON DuneLocationCalculationOutputEntity (DuneLocationCalculationEntityId ASC) ; CREATE INDEX IXFK_DuneLocationEntity_FailureMechanismEntity ON DuneLocationEntity (FailureMechanismEntityId ASC) ; CREATE INDEX IXFK_DuneLocationEntity_HydraulicLocationEntity ON DuneLocationEntity (HydraulicLocationEntityId ASC) ; CREATE INDEX IXFK_FailureMechanismFailureMechanismSectionEntity_FailureMechanismEntity ON FailureMechanismFailureMechanismSectionEntity (FailureMechanismEntityId ASC) ; CREATE INDEX IXFK_FailureMechanismFailureMechanismSectionEntity_FailureMechanismSectionEntity ON FailureMechanismFailureMechanismSectionEntity (FailureMechanismSectionEntityId ASC) ; CREATE TRIGGER [TR_AfterDeleteFailureMechanismFailureMechanismSectionEntity_RemoveFailureMechanismSectionEntityId] AFTER DELETE ON FailureMechanismFailureMechanismSectionEntity FOR EACH ROW BEGIN DELETE FROM FailureMechanismSectionEntity WHERE OLD.FailureMechanismSectionEntityId IS NOT NULL AND FailureMechanismSectionEntityId IS OLD.FailureMechanismSectionEntityId; END; ; CREATE INDEX IXFK_FaultTreeIllustrationPoint_FaultTreeIllustrationPoint ON FaultTreeIllustrationPointEntity (ParentFaultTreeIllustrationPointEntityId ASC) ; CREATE INDEX IXFK_FaultTreeIllustrationPointStochastEntity_FaultTreeIllustrationPoint ON FaultTreeIllustrationPointStochastEntity (FaultTreeIllustrationPointEntityId ASC) ; CREATE INDEX IXFK_FaultTreeIllustrationPointStochastEntity_StochastEntity ON FaultTreeIllustrationPointStochastEntity (StochastEntityId ASC) ; CREATE TRIGGER [TR_AfterDeleteFaultTreeIllustrationPointStochastEntity_RemoveStochastEntity] AFTER DELETE ON FaultTreeIllustrationPointStochastEntity FOR EACH ROW BEGIN DELETE FROM StochastEntity WHERE OLD.StochastEntityId IS NOT NULL AND StochastEntityId IS OLD.StochastEntityId; END; ; CREATE INDEX IXFK_FaultTreeIllustrationPointEntity_FaultTreeIllustrationPointEntity ON FaultTreeSubmechanismIllustrationPointEntity (FaultTreeIllustrationPointEntityId ASC) ; CREATE INDEX IXFK_FaultTreeIllustrationPointEntity_SubMechanismIllustrationPointEntity ON FaultTreeSubmechanismIllustrationPointEntity (SubMechanismIllustrationPointEntityId ASC) ; CREATE TRIGGER [TR_AfterDeleteFaultTreeSubmechanismIllustrationPointEntity_RemoveSubmechanismIllustrationPointEntity] AFTER DELETE ON FaultTreeSubmechanismIllustrationPointEntity FOR EACH ROW BEGIN DELETE FROM SubmechanismIllustrationPointEntity WHERE OLD.SubmechanismIllustrationPointEntityId IS NOT NULL AND SubmechanismIllustrationPointEntityId IS OLD.SubmechanismIllustrationPointEntityId; END; ; CREATE INDEX IXFK_ForeshoreProfileEntity_FailureMechanismEntity ON ForeshoreProfileEntity (FailureMechanismEntityId ASC) ; CREATE INDEX IXFK_GeneralResultFaultTreeIllustrationPointStochastEntity_GeneralResultFaultTreeIllustrationPointEntity ON GeneralResultFaultTreeIllustrationPointStochastEntity (GeneralResultFaultTreeIllustrationPointEntityId ASC) ; CREATE INDEX IXFK_GeneralResultFaultTreeIllustrationPointStochastEntity_StochastEntity ON GeneralResultFaultTreeIllustrationPointStochastEntity (StochastEntityId ASC) ; CREATE TRIGGER [TR_AfterDeleteGeneralResultFaultTreeIllustrationPointStochastEntity_RemoveStochastEntity] AFTER DELETE ON GeneralResultFaultTreeIllustrationPointStochastEntity FOR EACH ROW BEGIN DELETE FROM StochastEntity WHERE OLD.StochastEntityId IS NOT NULL AND StochastEntityId IS OLD.StochastEntityId; END; ; CREATE INDEX IXFK_GeneralResultSubMechanismIllustrationPointStochastEntity_GeneralResultSubMechanismIllustrationPointEntity ON GeneralResultSubMechanismIllustrationPointStochastEntity (GeneralResultSubMechanismIllustrationPointEntityId ASC) ; CREATE INDEX IXFK_GeneralResultSubMechanismIllustrationPointStochastEntity_StochastEntity ON GeneralResultSubMechanismIllustrationPointStochastEntity (StochastEntityId ASC) ; CREATE TRIGGER [TR_AfterDeleteGeneralResultSubMechanismIllustrationPointStochastEntity_RemoveStochastEntity] AFTER DELETE ON GeneralResultSubMechanismIllustrationPointStochastEntity FOR EACH ROW BEGIN DELETE FROM StochastEntity WHERE OLD.StochastEntityId IS NOT NULL AND StochastEntityId IS OLD.StochastEntityId; END; ; CREATE INDEX IXFK_GrassCoverErosionInwardsDikeHeightOutputEntity_GeneralResultFaultTreeIllustrationPointEntity ON GrassCoverErosionInwardsDikeHeightOutputEntity (GeneralResultFaultTreeIllustrationPointEntityId ASC) ; CREATE INDEX IXFK_GrassCoverErosionInwardsDikeHeightOutputEntity_GrassCoverErosionInwardsOutputEntity ON GrassCoverErosionInwardsDikeHeightOutputEntity (GrassCoverErosionInwardsOutputEntityId ASC) ; CREATE TRIGGER [TR_AfterDeleteGrassCoverErosionInwardsDikeHeightOutputEntity_RemoveGeneralResultFaultTreeIllustrationPointEntity] AFTER DELETE ON GrassCoverErosionInwardsDikeHeightOutputEntity FOR EACH ROW BEGIN DELETE FROM GeneralResultFaultTreeIllustrationPointEntity WHERE OLD.GeneralResultFaultTreeIllustrationPointEntityId IS NOT NULL AND GeneralResultFaultTreeIllustrationPointEntityId IS OLD.GeneralResultFaultTreeIllustrationPointEntityId; END; ; CREATE INDEX IXFK_GrassCoverErosionInwardsOutputEntity_GeneralResultFaultTreeIllustrationPointEntity ON GrassCoverErosionInwardsOutputEntity (GeneralResultFaultTreeIllustrationPointEntityId ASC) ; CREATE INDEX IXFK_GrassCoverErosionInwardsOutputEntity_GrassCoverErosionInwardsCalculationEntity ON GrassCoverErosionInwardsOutputEntity (GrassCoverErosionInwardsCalculationEntityId ASC) ; CREATE TRIGGER [TR_AfterDeleteGrassCoverErosionInwardsOutputEntity_RemoveGeneralResultFaultTreeIllustrationPointEntity] AFTER DELETE ON GrassCoverErosionInwardsOutputEntity FOR EACH ROW BEGIN DELETE FROM GeneralResultFaultTreeIllustrationPointEntity WHERE OLD.GeneralResultFaultTreeIllustrationPointEntityId IS NOT NULL AND GeneralResultFaultTreeIllustrationPointEntityId IS OLD.GeneralResultFaultTreeIllustrationPointEntityId; END; ; CREATE INDEX IXFK_GrassCoverErosionInwardsOvertoppingRateOutputEntity_GeneralResultFaultTreeIllustrationPointEntity ON GrassCoverErosionInwardsOvertoppingRateOutputEntity (GeneralResultFaultTreeIllustrationPointEntityId ASC) ; CREATE INDEX IXFK_GrassCoverErosionInwardsOvertoppingRateOutputEntity_GrassCoverErosionInwardsOutputEntity ON GrassCoverErosionInwardsOvertoppingRateOutputEntity (GrassCoverErosionInwardsOutputEntityId ASC) ; CREATE TRIGGER [TR_AfterDeleteGrassCoverErosionInwardsOvertoppingRateOutputEntity_RemoveGeneralResultFaultTreeIllustrationPointEntity] AFTER DELETE ON GrassCoverErosionInwardsOvertoppingRateOutputEntity FOR EACH ROW BEGIN DELETE FROM GeneralResultFaultTreeIllustrationPointEntity WHERE OLD.GeneralResultFaultTreeIllustrationPointEntityId IS NOT NULL AND GeneralResultFaultTreeIllustrationPointEntityId IS OLD.GeneralResultFaultTreeIllustrationPointEntityId; END; ; CREATE INDEX IXFK_GrassCoverErosionOutwardsWaveConditionsCalculationEntity_CalculationGroupEntity ON GrassCoverErosionOutwardsWaveConditionsCalculationEntity (CalculationGroupEntityId ASC) ; CREATE INDEX IXFK_GrassCoverErosionOutwardsWaveConditionsCalculationEntity_ForeshoreProfileEntity ON GrassCoverErosionOutwardsWaveConditionsCalculationEntity (ForeshoreProfileEntityId ASC) ; CREATE INDEX IXFK_GrassCoverErosionOutwardsWaveConditionsCalculationEntity_HydraulicLocationCalculationForTargetProbabilityCollectionEntity ON GrassCoverErosionOutwardsWaveConditionsCalculationEntity (HydraulicLocationCalculationForTargetProbabilityCollectionEntityId ASC) ; CREATE INDEX IXFK_GrassCoverErosionOutwardsWaveConditionsCalculationEntity_HydraulicLocationEntity ON GrassCoverErosionOutwardsWaveConditionsCalculationEntity (HydraulicLocationEntityId ASC) ; CREATE INDEX IXFK_GrassCoverErosionOutwardsWaveConditionsOutputEntity_GrassCoverErosionOutwardsWaveConditionsCalculationEntity ON GrassCoverErosionOutwardsWaveConditionsOutputEntity (GrassCoverErosionOutwardsWaveConditionsCalculationEntityId ASC) ; CREATE INDEX IXFK_GrassCoverSlipOffOutwardsFailureMechanismMetaEntity_FailureMechanismEntity ON GrassCoverSlipOffOutwardsFailureMechanismMetaEntity (FailureMechanismEntityId ASC) ; CREATE INDEX IXFK_HeightStructure_FailureMechanismEntity ON HeightStructureEntity (FailureMechanismEntityId ASC) ; CREATE INDEX IXFK_HeightStructuresCalculationEntity_CalculationGroupEntity ON HeightStructuresCalculationEntity (CalculationGroupEntityId ASC) ; CREATE INDEX IXFK_HeightStructuresCalculationEntity_ForeshoreProfileEntity ON HeightStructuresCalculationEntity (ForeshoreProfileEntityId ASC) ; CREATE INDEX IXFK_HeightStructuresCalculationEntity_HeightStructureEntity ON HeightStructuresCalculationEntity (HeightStructureEntityId ASC) ; CREATE INDEX IXFK_HeightStructuresCalculationEntity_HydraulicLocationEntity ON HeightStructuresCalculationEntity (HydraulicLocationEntityId ASC) ; CREATE INDEX IXFK_HeightStructuresFailureMechanismMetaEntity_FailureMechanismEntity ON HeightStructuresFailureMechanismMetaEntity (FailureMechanismEntityId ASC) ; CREATE INDEX IXFK_HeightStructuresOutputEntity_HeightStructuresCalculationEntity ON HeightStructuresOutputEntity (HeightStructuresCalculationEntityId ASC) ; CREATE TRIGGER [TR_AfterDeleteHeightStructuresOutputEntity_RemoveGeneralResultFaultTreeIllustrationPointEntity] AFTER DELETE ON HeightStructuresOutputEntity FOR EACH ROW BEGIN DELETE FROM GeneralResultFaultTreeIllustrationPointEntity WHERE OLD.GeneralResultFaultTreeIllustrationPointEntityId IS NOT NULL AND GeneralResultFaultTreeIllustrationPointEntityId IS OLD.GeneralResultFaultTreeIllustrationPointEntityId; END; ; CREATE INDEX IXFK_HydraulicBoundaryDatabaseEntity_HydraulicBoundaryDataEntity ON HydraulicBoundaryDatabaseEntity (HydraulicBoundaryDataEntityId ASC) ; CREATE INDEX IXFK_HydraulicBoundaryDatabaseEntity_AssessmentSectionEntity ON HydraulicBoundaryDataEntity (AssessmentSectionEntityId ASC) ; CREATE INDEX IXFK_HydraulicLocationCalculationCollectionHydraulicLocationCalculationEntity_HydraulicLocationCalculationCollectionEntity ON HydraulicLocationCalculationCollectionHydraulicLocationCalculationEntity (HydraulicLocationCalculationCollectionEntityId ASC) ; CREATE INDEX IXFK_HydraulicLocationCalculationCollectionHydraulicLocationCalculationEntity_HydraulicLocationCalculationEntity ON HydraulicLocationCalculationCollectionHydraulicLocationCalculationEntity (HydraulicLocationCalculationEntityId ASC) ; CREATE TRIGGER [TR_AfterDeleteHydraulicLocationCalculationCollectionHydraulicLocationCalculationEntity_RemoveHydraulicLocationCalculationEntity] AFTER DELETE ON HydraulicLocationCalculationCollectionHydraulicLocationCalculationEntity FOR EACH ROW BEGIN DELETE FROM HydraulicLocationCalculationEntity WHERE OLD.HydraulicLocationCalculationEntityId IS NOT NULL AND HydraulicLocationCalculationEntityId IS OLD.HydraulicLocationCalculationEntityId; END; ; CREATE INDEX IXFK_HydraulicLocationCalculationEntity_HydraulicLocationEntity ON HydraulicLocationCalculationEntity (HydraulicLocationEntityId ASC) ; CREATE INDEX IXFK_HydraulicBoundaryLocationCalculationsForTargetProbabilityEntity_AssessmentSectionEntity ON HydraulicLocationCalculationForTargetProbabilityCollectionEntity (AssessmentSectionEntityId ASC) ; CREATE INDEX IXFK_HydraulicBoundaryLocationCalculationsForTargetProbabilityHydraulicLocationCalculationEntity_HydraulicBoundaryLocationCalculationsForTargetProbabilityEntity ON HydraulicLocationCalculationForTargetProbabilityCollectionHydraulicLocationCalculationEntity (HydraulicLocationCalculationForTargetProbabilityCollectionEntityId ASC) ; CREATE INDEX IXFK_HydraulicBoundaryLocationCalculationsForTargetProbabilityHydraulicLocationCalculationEntity_HydraulicLocationCalculationEntity ON HydraulicLocationCalculationForTargetProbabilityCollectionHydraulicLocationCalculationEntity (HydraulicLocationCalculationEntityId ASC) ; CREATE TRIGGER [TR_AfterDeleteHydraulicLocationCalculationForTargetProbabilityCollectionHydraulicLocationCalculationEntity_RemoveHydraulicLocationCalculationEntity] AFTER DELETE ON HydraulicLocationCalculationForTargetProbabilityCollectionHydraulicLocationCalculationEntity FOR EACH ROW BEGIN DELETE FROM HydraulicLocationCalculationEntity WHERE OLD.HydraulicLocationCalculationEntityId IS NOT NULL AND HydraulicLocationCalculationEntityId IS OLD.HydraulicLocationCalculationEntityId; END; ; CREATE INDEX IXFK_HydraulicLocationOutputEntity_GeneralResultSubMechanismIllustrationPointEntity ON HydraulicLocationOutputEntity (GeneralResultSubMechanismIllustrationPointEntityId ASC) ; CREATE INDEX IXFK_HydraulicLocationOutputEntity_HydraulicLocationCalculationEntity ON HydraulicLocationOutputEntity (HydraulicLocationCalculationEntityId ASC) ; CREATE TRIGGER [TR_AfterDeleteHydraulicLocationOutputEntity_RemoveGeneralResultSubMechanismIllustrationPointEntity] AFTER DELETE ON HydraulicLocationOutputEntity FOR EACH ROW BEGIN DELETE FROM GeneralResultSubMechanismIllustrationPointEntity WHERE OLD.GeneralResultSubMechanismIllustrationPointEntityId IS NOT NULL AND GeneralResultSubMechanismIllustrationPointEntityId IS OLD.GeneralResultSubMechanismIllustrationPointEntityId; END; ; CREATE INDEX IXFK_IllustrationPointResultEntity_SubMechanismIllustrationPointEntity ON IllustrationPointResultEntity (SubMechanismIllustrationPointEntityId ASC) ; CREATE INDEX IXFK_MacroStabilityInwardsCalculationEntity_CalculationGroupEntity ON MacroStabilityInwardsCalculationEntity (CalculationGroupEntityId ASC) ; CREATE INDEX IXFK_MacroStabilityInwardsCalculationEntity_HydraulicLocationEntity ON MacroStabilityInwardsCalculationEntity (HydraulicLocationEntityId ASC) ; CREATE INDEX IXFK_MacroStabilityInwardsCalculationEntity_MacroStabilityInwardsStochasticSoilProfileEntity ON MacroStabilityInwardsCalculationEntity (MacroStabilityInwardsStochasticSoilProfileEntityId ASC) ; CREATE INDEX IXFK_MacroStabilityInwardsCalculationOutput_MacroStabilityInwardsCalculationEntity ON MacroStabilityInwardsCalculationOutputEntity (MacroStabilityInwardsCalculationEntityId ASC) ; CREATE INDEX IXFK_MacroStabilityCharacteristicPointEntity_SurfaceLineEntity ON MacroStabilityInwardsCharacteristicPointEntity (SurfaceLineEntityId ASC) ; CREATE INDEX IXFK_MacroStabilityInwardsFailureMechanismMetaEntity_FailureMechanismEntity ON MacroStabilityInwardsFailureMechanismMetaEntity (FailureMechanismEntityId ASC) ; CREATE INDEX IXFK_MacroStabilityInwardsSoilLayerOneDEntity_MacroStabilityInwardsSoilProfileOneDEntity ON MacroStabilityInwardsSoilLayerOneDEntity (MacroStabilityInwardsSoilProfileOneDEntityId ASC) ; CREATE TRIGGER [TR_AfterDeleteMacroStabilityInwardsSoilProfileTwoDEntity_MacroStabilityInwardsSoilLayerTwoDEntity] AFTER DELETE ON MacroStabilityInwardsSoilProfileTwoDEntity FOR EACH ROW BEGIN DELETE FROM MacroStabilityInwardsSoilLayerTwoDEntity WHERE OLD.MacroStabilityInwardsSoilLayerTwoDEntity IS NOT NULL AND MacroStabilityInwardsSoilLayerTwoDEntity IS OLD.MacroStabilityInwardsSoilLayerTwoDEntity; END; ; CREATE INDEX IXFK_MacroStabilityInwardsStochasticSoilProfileEntity_StochasticSoilModelEntity 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; END; ; CREATE TRIGGER [TR_BeforeUpdateMacroStabilityInwardsStochasticSoilProfileEntity_MustHaveOneDOrTwoD] 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; END; ; CREATE INDEX IXFK_MicrostabilityFailureMechanismMetaEntity_FailureMechanismEntity ON MicrostabilityFailureMechanismMetaEntity (FailureMechanismEntityId ASC) ; CREATE INDEX IXFK_NonAdoptableFailureMechanismSectionResultEntity_FailureMechanismSectionEntity ON NonAdoptableFailureMechanismSectionResultEntity (FailureMechanismSectionEntityId ASC) ; CREATE INDEX IXFK_NonAdoptableWithProfileProbabilityFailureMechanismSectionResultEntity_FailureMechanismSectionEntity ON NonAdoptableWithProfileProbabilityFailureMechanismSectionResultEntity (FailureMechanismSectionEntityId ASC) ; CREATE INDEX IXFK_PipingFailureMechanismMetaEntity_FailureMechanismEntity ON PipingFailureMechanismMetaEntity (FailureMechanismEntityId ASC) ; CREATE INDEX IXFK_PipingStructureFailureMechanismMetaEntity_FailureMechanismEntity ON PipingStructureFailureMechanismMetaEntity (FailureMechanismEntityId ASC) ; CREATE INDEX IXFK_ProbabilisticPipingCalculationEntity_CalculationGroupEntity ON ProbabilisticPipingCalculationEntity (CalculationGroupEntityId ASC) ; CREATE INDEX IXFK_ProbabilisticPipingCalculationEntity_HydraulicLocationEntity ON ProbabilisticPipingCalculationEntity (HydraulicLocationEntityId ASC) ; CREATE INDEX IXFK_ProbabilisticPipingCalculationEntity_PipingStochasticSoilProfileEntity ON ProbabilisticPipingCalculationEntity (PipingStochasticSoilProfileEntityId ASC) ; CREATE INDEX IXFK_ProbabilisticPipingCalculationEntity_SurfaceLineEntity ON ProbabilisticPipingCalculationEntity (SurfaceLineEntityId ASC) ; CREATE INDEX IXFK_ProbabilisticPipingCalculationOutputEntity_ProbabilisticPipingCalculationEntity ON ProbabilisticPipingCalculationOutputEntity (ProbabilisticPipingCalculationEntityId ASC) ; CREATE INDEX IXFK_ProbabilisticPipingCalculationOutputEntity_Profile_GeneralResultFaultTreeIllustrationPointEntity ON ProbabilisticPipingCalculationOutputEntity (ProfileSpecificGeneralResultFaultTreeIllustrationPointEntityId ASC) ; CREATE INDEX IXFK_ProbabilisticPipingCalculationOutputEntity_Profile_GeneralResultSubMechanismIllustrationPointEntity ON ProbabilisticPipingCalculationOutputEntity (ProfileSpecificGeneralResultSubMechanismIllustrationPointEntityId ASC) ; CREATE INDEX IXFK_ProbabilisticPipingCalculationOutputEntity_Section_GeneralResultFaultTreeIllustrationPointEntity ON ProbabilisticPipingCalculationOutputEntity (ProfileSpecificGeneralResultFaultTreeIllustrationPointEntityId ASC) ; CREATE INDEX IXFK_ProbabilisticPipingCalculationOutputEntity_Section_GeneralResultSubMechanismIllustrationPointEntity ON ProbabilisticPipingCalculationOutputEntity (SectionSpecificGeneralResultSubMechanismIllustrationPointEntityId ASC) ; CREATE INDEX IXFK_SemiProbabilisticPipingCalculationOutputEntity_SemiProbabilisticPipingCalculationEntity ON SemiProbabilisticPipingCalculationOutputEntity (SemiProbabilisticPipingCalculationEntityId ASC) ; CREATE INDEX IXFK_SpecificFailureMechanismEntity_AssessmentSectionEntity ON SpecificFailureMechanismEntity (AssessmentSectionEntityId ASC) ; CREATE INDEX IXFK_SpecificFailureMechanismFailureMechanismSectionEntity_FailureMechanismSectionEntity ON SpecificFailureMechanismFailureMechanismSectionEntity (FailureMechanismSectionEntityId ASC) ; CREATE INDEX IXFK_SpecificFailureMechanismFailureMechanismSectionEntity_SpecificFailureMechanismEntity ON SpecificFailureMechanismFailureMechanismSectionEntity (SpecificFailureMechanismEntityId ASC) ; CREATE TRIGGER [TR_AfterDeleteSpecificFailureMechanismFailureMechanismSectionEntity_RemoveFailureMechanismSectionEntityId] AFTER DELETE ON SpecificFailureMechanismFailureMechanismSectionEntity FOR EACH ROW BEGIN DELETE FROM FailureMechanismSectionEntity WHERE OLD.FailureMechanismSectionEntityId IS NOT NULL AND FailureMechanismSectionEntityId IS OLD.FailureMechanismSectionEntityId; END; ; CREATE INDEX IXFK_StabilityPointStructureEntity_FailureMechanismEntity ON StabilityPointStructureEntity (FailureMechanismEntityId ASC) ; CREATE INDEX IXFK_StabilityPointStructuresCalculationEntity_CalculationGroupEntity ON StabilityPointStructuresCalculationEntity (CalculationGroupEntityId ASC) ; CREATE INDEX IXFK_StabilityPointStructuresCalculationEntity_ForeshoreProfileEntity ON StabilityPointStructuresCalculationEntity (ForeshoreProfileEntityId ASC) ; CREATE INDEX IXFK_StabilityPointStructuresCalculationEntity_HydraulicLocationEntity ON StabilityPointStructuresCalculationEntity (HydraulicLocationEntityId ASC) ; CREATE INDEX IXFK_StabilityPointStructuresCalculationEntity_StabilityPointStructureEntity ON StabilityPointStructuresCalculationEntity (StabilityPointStructureEntityId ASC) ; CREATE INDEX IXFK_StrengthStabilityPointConstructionFailureMechanismMetaEntity_FailureMechanismEntity ON StabilityPointStructuresFailureMechanismMetaEntity (FailureMechanismEntityId ASC) ; CREATE INDEX IXFK_StabilityPointStructuresOutputEntity_StabilityPointStructuresCalculationEntity ON StabilityPointStructuresOutputEntity (StabilityPointStructuresCalculationEntityId ASC) ; CREATE TRIGGER [TR_AfterDeleteStabilityPointStructuresOutputEntity_RemoveGeneralResultFaultTreeIllustrationPointEntity] AFTER DELETE ON StabilityPointStructuresOutputEntity FOR EACH ROW BEGIN DELETE FROM GeneralResultFaultTreeIllustrationPointEntity WHERE OLD.GeneralResultFaultTreeIllustrationPointEntityId IS NOT NULL AND GeneralResultFaultTreeIllustrationPointEntityId IS OLD.GeneralResultFaultTreeIllustrationPointEntityId; END; ; CREATE INDEX IXFK_StabilityStoneCoverFailureMechanismMetaEntity_FailureMechanismEntity ON StabilityStoneCoverFailureMechanismMetaEntity (FailureMechanismEntityId ASC) ; CREATE INDEX IXFK_StabilityStoneCoverWaveConditionsCalculationEntity_CalculationGroupEntity ON StabilityStoneCoverWaveConditionsCalculationEntity (CalculationGroupEntityId ASC) ; CREATE INDEX IXFK_StabilityStoneCoverWaveConditionsCalculationEntity_ForeshoreProfileEntity ON StabilityStoneCoverWaveConditionsCalculationEntity (ForeshoreProfileEntityId ASC) ; CREATE INDEX IXFK_StabilityStoneCoverWaveConditionsCalculationEntity_HydraulicLocationCalculationForTargetProbabilityCollectionEntity ON StabilityStoneCoverWaveConditionsCalculationEntity (HydraulicLocationCalculationForTargetProbabilityCollectionEntityId ASC) ; CREATE INDEX IXFK_StabilityStoneCoverWaveConditionsCalculationEntity_HydraulicLocationEntity ON StabilityStoneCoverWaveConditionsCalculationEntity (HydraulicLocationEntityId ASC) ; CREATE INDEX IXFK_StabilityStoneCoverWaveConditionsOutputEntity_StabilityStoneCoverWaveConditionsCalculationEntity ON StabilityStoneCoverWaveConditionsOutputEntity (StabilityStoneCoverWaveConditionsCalculationEntityId ASC) ; CREATE INDEX IXFK_SubMechanismIllustrationPointStochast_SubMechanismIllustrationPointEntity ON SubMechanismIllustrationPointStochastEntity (SubMechanismIllustrationPointEntityId ASC) ; CREATE INDEX IXFK_TopLevelFaultTreeIllustrationPointEntity_FaultTreeIllustrationPointEntity ON TopLevelFaultTreeIllustrationPointEntity (FaultTreeIllustrationPointEntityId ASC) ; CREATE INDEX IXFK_TopLevelFaultTreeIllustrationPointEntity_GeneralResultFaultTreeIllustrationPointEntity ON TopLevelFaultTreeIllustrationPointEntity (GeneralResultFaultTreeIllustrationPointEntityId ASC) ; CREATE TRIGGER [TR_AfterDeleteTopLevelFaultTreeIllustrationPointEntity_RemoveFaultTreeIllustrationPointEntity] AFTER DELETE ON TopLevelFaultTreeIllustrationPointEntity FOR EACH ROW BEGIN DELETE FROM FaultTreeIllustrationPointEntity WHERE OLD.FaultTreeIllustrationPointEntityId IS NOT NULL AND FaultTreeIllustrationPointEntityId IS OLD.FaultTreeIllustrationPointEntityId; END; ; CREATE INDEX IXFK_TopLevelSubMechanismIllustrationPointEntity_GeneralResultSubMechanismIllustrationPointEntity ON TopLevelSubMechanismIllustrationPointEntity (GeneralResultSubMechanismIllustrationPointEntityId ASC) ; CREATE INDEX IXFK_TopLevelSubMechanismIllustrationPointEntity_SubMechanismIllustrationPointEntity ON TopLevelSubMechanismIllustrationPointEntity (SubMechanismIllustrationPointEntityId ASC) ; CREATE TRIGGER [TR_AfterDeleteTopLevelSubMechanismIllustrationPointEntity_RemoveSubMechanismIllustrationPointEntity] AFTER DELETE ON TopLevelSubMechanismIllustrationPointEntity FOR EACH ROW BEGIN DELETE FROM SubMechanismIllustrationPointEntity WHERE OLD.SubMechanismIllustrationPointEntityId IS NOT NULL AND SubMechanismIllustrationPointEntityId IS OLD.SubMechanismIllustrationPointEntityId; END; ; CREATE INDEX IXFK_WaveImpactAsphaltCoverWaveConditionsCalculationEntity_CalculationGroupEntity ON WaveImpactAsphaltCoverWaveConditionsCalculationEntity (CalculationGroupEntityId ASC) ; CREATE INDEX IXFK_WaveImpactAsphaltCoverWaveConditionsCalculationEntity_ForeshoreProfileEntity ON WaveImpactAsphaltCoverWaveConditionsCalculationEntity (ForeshoreProfileEntityId ASC) ; CREATE INDEX IXFK_WaveImpactAsphaltCoverWaveConditionsCalculationEntity_HydraulicLocationCalculationForTargetProbabilityCollectionEntity ON WaveImpactAsphaltCoverWaveConditionsCalculationEntity (HydraulicLocationCalculationForTargetProbabilityCollectionEntityId ASC) ; CREATE INDEX IXFK_WaveImpactAsphaltCoverWaveConditionsCalculationEntity_HydraulicLocationEntity ON WaveImpactAsphaltCoverWaveConditionsCalculationEntity (HydraulicLocationEntityId ASC) ; CREATE INDEX IXFK_WaveImpactAsphaltCoverWaveConditionsOutputEntity_WaveImpactAsphaltCoverWaveConditionsCalculationEntity ON WaveImpactAsphaltCoverWaveConditionsOutputEntity (WaveImpactAsphaltCoverWaveConditionsCalculationEntityId ASC) ;