Index: Application/Ringtoets/src/Application.Ringtoets.Migration.Core/EmbeddedResources/DatabaseStructure18.1.sql =================================================================== diff -u -r4d6b107a57f8108b102fb711569d1d33a3023389 -rc43e60dc31027ef84a70ecc2c252e028dd8888c5 --- Application/Ringtoets/src/Application.Ringtoets.Migration.Core/EmbeddedResources/DatabaseStructure18.1.sql (.../DatabaseStructure18.1.sql) (revision 4d6b107a57f8108b102fb711569d1d33a3023389) +++ Application/Ringtoets/src/Application.Ringtoets.Migration.Core/EmbeddedResources/DatabaseStructure18.1.sql (.../DatabaseStructure18.1.sql) (revision c43e60dc31027ef84a70ecc2c252e028dd8888c5) @@ -1,6 +1,6 @@ /* ---------------------------------------------------- */ /* Generated by Enterprise Architect Version 12.0 */ -/* Created On : 24-jan-2018 10:25:03 */ +/* Created On : 25-Jan-2018 14:43:24 */ /* DBMS : SQLite */ /* ---------------------------------------------------- */ @@ -522,36 +522,36 @@ ( 'HydraulicLocationEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'AssessmentSectionEntityId' INTEGER NOT NULL, - 'HydraulicLocationCalculationEntity_DesignWaterLevelCalculationOneId' INTEGER NOT NULL, - 'HydraulicLocationCalculationEntity_DesignWaterLevelCalculationTwoId' INTEGER NOT NULL, - 'HydraulicLocationCalculationEntity_DesignWaterLevelCalculationThreeId' INTEGER NOT NULL, - 'HydraulicLocationCalculationEntity_DesignWaterLevelCalculationFourId' INTEGER NOT NULL, - 'HydraulicLocationCalculationEntity_WaveHeightCalculationOneId' INTEGER NOT NULL, - 'HydraulicLocationCalculationEntity_WaveHeightCalculationTwoId' INTEGER NOT NULL, - 'HydraulicLocationCalculationEntity_WaveHeightCalculationThreeId' INTEGER NOT NULL, - 'HydraulicLocationCalculationEntity_WaveHeightCalculationFourId' INTEGER NOT NULL, + 'HydraulicLocationCalculationEntity1Id' INTEGER NOT NULL, + 'HydraulicLocationCalculationEntity2Id' INTEGER NOT NULL, + 'HydraulicLocationCalculationEntity3Id' INTEGER NOT NULL, + 'HydraulicLocationCalculationEntity4Id' INTEGER NOT NULL, + 'HydraulicLocationCalculationEntity5Id' INTEGER NOT NULL, + 'HydraulicLocationCalculationEntity6Id' INTEGER NOT NULL, + 'HydraulicLocationCalculationEntity7Id' INTEGER NOT NULL, + 'HydraulicLocationCalculationEntity8Id' INTEGER NOT NULL, 'LocationId' INTEGER NOT NULL, 'Name' VARCHAR (260) NOT NULL, 'LocationX' REAL, 'LocationY' REAL, 'Order' INT (4) NOT NULL, CONSTRAINT 'FK_HydraulicLocationEntity_AssessmentSectionEntity' FOREIGN KEY ('AssessmentSectionEntityId') REFERENCES 'AssessmentSectionEntity' ('AssessmentSectionEntityId') ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT 'FK_HydraulicLocationEntity_HydraulicLocationCalculationEntity_DesignWaterLevelCalculationFour' FOREIGN KEY ('HydraulicLocationCalculationEntity_DesignWaterLevelCalculationFourId') REFERENCES 'HydraulicLocationCalculationEntity' ('HydraulicLocationCalculationEntityId') ON DELETE No Action ON UPDATE Cascade, - CONSTRAINT 'FK_HydraulicLocationEntity_HydraulicLocationCalculationEntity_DesignWaterLevelCalculationOne' FOREIGN KEY ('HydraulicLocationCalculationEntity_DesignWaterLevelCalculationOneId') REFERENCES 'HydraulicLocationCalculationEntity' ('HydraulicLocationCalculationEntityId') ON DELETE No Action ON UPDATE Cascade, - CONSTRAINT 'FK_HydraulicLocationEntity_HydraulicLocationCalculationEntity_DesignWaterLevelCalculationThree' FOREIGN KEY ('HydraulicLocationCalculationEntity_DesignWaterLevelCalculationThreeId') REFERENCES 'HydraulicLocationCalculationEntity' ('HydraulicLocationCalculationEntityId') ON DELETE No Action ON UPDATE Cascade, - CONSTRAINT 'FK_HydraulicLocationEntity_HydraulicLocationCalculationEntity_DesignWaterLevelCalculationTwo' FOREIGN KEY ('HydraulicLocationCalculationEntity_DesignWaterLevelCalculationTwoId') REFERENCES 'HydraulicLocationCalculationEntity' ('HydraulicLocationCalculationEntityId') ON DELETE No Action ON UPDATE Cascade, - CONSTRAINT 'FK_HydraulicLocationEntity_HydraulicLocationCalculationEntity_WaveHeightCalculationFour' FOREIGN KEY ('HydraulicLocationCalculationEntity_WaveHeightCalculationFourId') REFERENCES 'HydraulicLocationCalculationEntity' ('HydraulicLocationCalculationEntityId') ON DELETE No Action ON UPDATE Cascade, - CONSTRAINT 'FK_HydraulicLocationEntity_HydraulicLocationCalculationEntity_WaveHeightCalculationOne' FOREIGN KEY ('HydraulicLocationCalculationEntity_WaveHeightCalculationOneId') REFERENCES 'HydraulicLocationCalculationEntity' ('HydraulicLocationCalculationEntityId') ON DELETE No Action ON UPDATE Cascade, - CONSTRAINT 'FK_HydraulicLocationEntity_HydraulicLocationCalculationEntity_WaveHeightCalculationThree' FOREIGN KEY ('HydraulicLocationCalculationEntity_WaveHeightCalculationThreeId') REFERENCES 'HydraulicLocationCalculationEntity' ('HydraulicLocationCalculationEntityId') ON DELETE No Action ON UPDATE Cascade, - CONSTRAINT 'FK_HydraulicLocationEntity_HydraulicLocationCalculationEntity_WaveHeightCalculationTwo' FOREIGN KEY ('HydraulicLocationCalculationEntity_WaveHeightCalculationTwoId') REFERENCES 'HydraulicLocationCalculationEntity' ('HydraulicLocationCalculationEntityId') ON DELETE No Action ON UPDATE Cascade, - CONSTRAINT 'U_HydraulicLocationCalculationEntity_DesignWaterLevelCalculationOneId' UNIQUE ('HydraulicLocationCalculationEntity_DesignWaterLevelCalculationOneId'), - CONSTRAINT 'U_HydraulicLocationCalculationEntity_DesignWaterLevelCalculationTwoId' UNIQUE ('HydraulicLocationCalculationEntity_DesignWaterLevelCalculationTwoId'), - CONSTRAINT 'U_HydraulicLocationCalculationEntity_DesignWaterLevelCalculationThreeId' UNIQUE ('HydraulicLocationCalculationEntity_DesignWaterLevelCalculationThreeId'), - CONSTRAINT 'U_HydraulicLocationCalculationEntity_DesignWaterLevelCalculationFourId' UNIQUE ('HydraulicLocationCalculationEntity_DesignWaterLevelCalculationFourId'), - CONSTRAINT 'U_HydraulicLocationCalculationEntity_WaveHeightCalculationOneId' UNIQUE ('HydraulicLocationCalculationEntity_WaveHeightCalculationOneId'), - CONSTRAINT 'U_HydraulicLocationCalculationEntity_WaveHeightCalculationTwoId' UNIQUE ('HydraulicLocationCalculationEntity_WaveHeightCalculationTwoId'), - CONSTRAINT 'U_HydraulicLocationCalculationEntity_WaveHeightCalculationThreeId' UNIQUE ('HydraulicLocationCalculationEntity_WaveHeightCalculationThreeId'), - CONSTRAINT 'U_HydraulicLocationCalculationEntity_WaveHeightCalculationFourId' UNIQUE ('HydraulicLocationCalculationEntity_WaveHeightCalculationFourId') + CONSTRAINT 'FK_HydraulicLocationEntity_HydraulicLocationCalculationEntity1' FOREIGN KEY ('HydraulicLocationCalculationEntity1Id') REFERENCES 'HydraulicLocationCalculationEntity' ('HydraulicLocationCalculationEntityId') ON DELETE No Action ON UPDATE Cascade, + CONSTRAINT 'FK_HydraulicLocationEntity_HydraulicLocationCalculationEntity2' FOREIGN KEY ('HydraulicLocationCalculationEntity2Id') REFERENCES 'HydraulicLocationCalculationEntity' ('HydraulicLocationCalculationEntityId') ON DELETE No Action ON UPDATE Cascade, + CONSTRAINT 'FK_HydraulicLocationEntity_HydraulicLocationCalculationEntity3' FOREIGN KEY ('HydraulicLocationCalculationEntity3Id') REFERENCES 'HydraulicLocationCalculationEntity' ('HydraulicLocationCalculationEntityId') ON DELETE No Action ON UPDATE Cascade, + CONSTRAINT 'FK_HydraulicLocationEntity_HydraulicLocationCalculationEntity4' FOREIGN KEY ('HydraulicLocationCalculationEntity4Id') REFERENCES 'HydraulicLocationCalculationEntity' ('HydraulicLocationCalculationEntityId') ON DELETE No Action ON UPDATE Cascade, + CONSTRAINT 'FK_HydraulicLocationEntity_HydraulicLocationCalculationEntity5' FOREIGN KEY ('HydraulicLocationCalculationEntity5Id') REFERENCES 'HydraulicLocationCalculationEntity' ('HydraulicLocationCalculationEntityId') ON DELETE No Action ON UPDATE Cascade, + CONSTRAINT 'FK_HydraulicLocationEntity_HydraulicLocationCalculationEntity6' FOREIGN KEY ('HydraulicLocationCalculationEntity6Id') REFERENCES 'HydraulicLocationCalculationEntity' ('HydraulicLocationCalculationEntityId') ON DELETE No Action ON UPDATE Cascade, + CONSTRAINT 'FK_HydraulicLocationEntity_HydraulicLocationCalculationEntity7' FOREIGN KEY ('HydraulicLocationCalculationEntity7Id') REFERENCES 'HydraulicLocationCalculationEntity' ('HydraulicLocationCalculationEntityId') ON DELETE No Action ON UPDATE Cascade, + CONSTRAINT 'FK_HydraulicLocationEntity_HydraulicLocationCalculationEntity8' FOREIGN KEY ('HydraulicLocationCalculationEntity8Id') REFERENCES 'HydraulicLocationCalculationEntity' ('HydraulicLocationCalculationEntityId') ON DELETE No Action ON UPDATE Cascade, + CONSTRAINT 'U_HydraulicLocationCalculationEntity_HydraulicLocationCalculation2Id' UNIQUE ('HydraulicLocationCalculationEntity2Id'), + CONSTRAINT 'U_HydraulicLocationCalculationEntity_HydraulicLocationCalculation4Id' UNIQUE ('HydraulicLocationCalculationEntity4Id'), + CONSTRAINT 'U_HydraulicLocationCalculationEntity_HydraulicLocationCalculation3Id' UNIQUE ('HydraulicLocationCalculationEntity3Id'), + CONSTRAINT 'U_HydraulicLocationCalculationEntity_HydraulicLocationCalculation1Id' UNIQUE ('HydraulicLocationCalculationEntity1Id'), + CONSTRAINT 'U_HydraulicLocationCalculationEntity_HydraulicLocationCalculation6Id' UNIQUE ('HydraulicLocationCalculationEntity6Id'), + CONSTRAINT 'U_HydraulicLocationCalculationEntity_HydraulicLocationCalculation8Id' UNIQUE ('HydraulicLocationCalculationEntity8Id'), + CONSTRAINT 'U_HydraulicLocationCalculationEntity_HydraulicLocationCalculation7Id' UNIQUE ('HydraulicLocationCalculationEntity7Id'), + CONSTRAINT 'U_HydraulicLocationCalculationEntity_HydraulicLocationCalculation5Id' UNIQUE ('HydraulicLocationCalculationEntity5Id') ) ; @@ -2052,36 +2052,36 @@ ON 'HydraulicLocationEntity' ('AssessmentSectionEntityId' ASC) ; -CREATE INDEX 'IXFK_HydraulicLocationEntity_HydraulicLocationCalculationEntity_DesignWaterLevelCalculationFour' - ON 'HydraulicLocationEntity' ('HydraulicLocationCalculationEntity_DesignWaterLevelCalculationFourId' ASC) +CREATE INDEX 'IXFK_HydraulicLocationEntity_HydraulicLocationCalculationEntity' + ON 'HydraulicLocationEntity' ('HydraulicLocationCalculationEntity1Id' ASC) ; -CREATE INDEX 'IXFK_HydraulicLocationEntity_HydraulicLocationCalculationEntity_DesignWaterLevelCalculationOne' - ON 'HydraulicLocationEntity' ('HydraulicLocationCalculationEntity_DesignWaterLevelCalculationOneId' ASC) +CREATE INDEX 'IXFK_HydraulicLocationEntity_HydraulicLocationCalculationEntity_02' + ON 'HydraulicLocationEntity' ('HydraulicLocationCalculationEntity2Id' ASC) ; -CREATE INDEX 'IXFK_HydraulicLocationEntity_HydraulicLocationCalculationEntity_DesignWaterLevelCalculationThree' - ON 'HydraulicLocationEntity' ('HydraulicLocationCalculationEntity_DesignWaterLevelCalculationThreeId' ASC) +CREATE INDEX 'IXFK_HydraulicLocationEntity_HydraulicLocationCalculationEntity_03' + ON 'HydraulicLocationEntity' ('HydraulicLocationCalculationEntity3Id' ASC) ; -CREATE INDEX 'IXFK_HydraulicLocationEntity_HydraulicLocationCalculationEntity_DesignWaterLevelCalculationTwo' - ON 'HydraulicLocationEntity' ('HydraulicLocationCalculationEntity_DesignWaterLevelCalculationTwoId' ASC) +CREATE INDEX 'IXFK_HydraulicLocationEntity_HydraulicLocationCalculationEntity_04' + ON 'HydraulicLocationEntity' ('HydraulicLocationCalculationEntity4Id' ASC) ; -CREATE INDEX 'IXFK_HydraulicLocationEntity_HydraulicLocationCalculationEntity_WaveHeightCalculationFour' - ON 'HydraulicLocationEntity' ('HydraulicLocationCalculationEntity_WaveHeightCalculationFourId' ASC) +CREATE INDEX 'IXFK_HydraulicLocationEntity_HydraulicLocationCalculationEntity_05' + ON 'HydraulicLocationEntity' ('HydraulicLocationCalculationEntity5Id' ASC) ; -CREATE INDEX 'IXFK_HydraulicLocationEntity_HydraulicLocationCalculationEntity_WaveHeightCalculationOne' - ON 'HydraulicLocationEntity' ('HydraulicLocationCalculationEntity_WaveHeightCalculationOneId' ASC) +CREATE INDEX 'IXFK_HydraulicLocationEntity_HydraulicLocationCalculationEntity_06' + ON 'HydraulicLocationEntity' ('HydraulicLocationCalculationEntity6Id' ASC) ; -CREATE INDEX 'IXFK_HydraulicLocationEntity_HydraulicLocationCalculationEntity_WaveHeightCalculationThree' - ON 'HydraulicLocationEntity' ('HydraulicLocationCalculationEntity_WaveHeightCalculationThreeId' ASC) +CREATE INDEX 'IXFK_HydraulicLocationEntity_HydraulicLocationCalculationEntity_07' + ON 'HydraulicLocationEntity' ('HydraulicLocationCalculationEntity7Id' ASC) ; -CREATE INDEX 'IXFK_HydraulicLocationEntity_HydraulicLocationCalculationEntity_WaveHeightCalculationTwo' - ON 'HydraulicLocationEntity' ('HydraulicLocationCalculationEntity_WaveHeightCalculationTwoId' ASC) +CREATE INDEX 'IXFK_HydraulicLocationEntity_HydraulicLocationCalculationEntity_08' + ON 'HydraulicLocationEntity' ('HydraulicLocationCalculationEntity8Id' ASC) ; CREATE TRIGGER [TR_AfterDeleteHydraulicLocationEntity_RemoveHydraulicLocationCalculationEntity_DesignWaterLevelCalculationOne] AFTER DELETE Index: Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/HydraulicLocationEntity.cs =================================================================== diff -u -r33b1979ea5681dcaef595262bbe14e5c274fdfc2 -rc43e60dc31027ef84a70ecc2c252e028dd8888c5 --- Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/HydraulicLocationEntity.cs (.../HydraulicLocationEntity.cs) (revision 33b1979ea5681dcaef595262bbe14e5c274fdfc2) +++ Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/HydraulicLocationEntity.cs (.../HydraulicLocationEntity.cs) (revision c43e60dc31027ef84a70ecc2c252e028dd8888c5) @@ -50,14 +50,14 @@ public long HydraulicLocationEntityId { get; set; } public long AssessmentSectionEntityId { get; set; } - public long HydraulicLocationCalculationEntity_DesignWaterLevelCalculationOneId { get; set; } - public long HydraulicLocationCalculationEntity_DesignWaterLevelCalculationTwoId { get; set; } - public long HydraulicLocationCalculationEntity_DesignWaterLevelCalculationThreeId { get; set; } - public long HydraulicLocationCalculationEntity_DesignWaterLevelCalculationFourId { get; set; } - public long HydraulicLocationCalculationEntity_WaveHeightCalculationOneId { get; set; } - public long HydraulicLocationCalculationEntity_WaveHeightCalculationTwoId { get; set; } - public long HydraulicLocationCalculationEntity_WaveHeightCalculationThreeId { get; set; } - public long HydraulicLocationCalculationEntity_WaveHeightCalculationFourId { get; set; } + public long HydraulicLocationCalculationEntity1Id { get; set; } + public long HydraulicLocationCalculationEntity2Id { get; set; } + public long HydraulicLocationCalculationEntity3Id { get; set; } + public long HydraulicLocationCalculationEntity4Id { get; set; } + public long HydraulicLocationCalculationEntity5Id { get; set; } + public long HydraulicLocationCalculationEntity6Id { get; set; } + public long HydraulicLocationCalculationEntity7Id { get; set; } + public long HydraulicLocationCalculationEntity8Id { get; set; } public long LocationId { get; set; } public string Name { get; set; } public double? LocationX { get; set; } Index: Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/RingtoetsEntities.edmx =================================================================== diff -u -r4cca71f53fc5dad480ea2c47a4596d3f89785764 -rc43e60dc31027ef84a70ecc2c252e028dd8888c5 --- Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/RingtoetsEntities.edmx (.../RingtoetsEntities.edmx) (revision 4cca71f53fc5dad480ea2c47a4596d3f89785764) +++ Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/RingtoetsEntities.edmx (.../RingtoetsEntities.edmx) (revision c43e60dc31027ef84a70ecc2c252e028dd8888c5) @@ -648,14 +648,14 @@ - - - - - - - - + + + + + + + + @@ -2306,7 +2306,7 @@ - + @@ -2318,7 +2318,7 @@ - + @@ -2330,7 +2330,7 @@ - + @@ -2342,7 +2342,7 @@ - + @@ -2354,7 +2354,7 @@ - + @@ -2366,7 +2366,7 @@ - + @@ -2378,7 +2378,7 @@ - + @@ -2390,7 +2390,7 @@ - + @@ -5294,14 +5294,14 @@ - - - - - - - - + + + + + + + + @@ -7360,7 +7360,7 @@ - + @@ -7372,7 +7372,7 @@ - + @@ -7384,7 +7384,7 @@ - + @@ -7396,7 +7396,7 @@ - + @@ -7408,7 +7408,7 @@ - + @@ -7420,7 +7420,7 @@ - + @@ -7432,7 +7432,7 @@ - + @@ -7444,7 +7444,7 @@ - + @@ -8524,14 +8524,14 @@ - - - - - - - - + + + + + + + + Index: Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/RingtoetsEntities.edmx.diagram =================================================================== diff -u -r4cca71f53fc5dad480ea2c47a4596d3f89785764 -rc43e60dc31027ef84a70ecc2c252e028dd8888c5 --- Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/RingtoetsEntities.edmx.diagram (.../RingtoetsEntities.edmx.diagram) (revision 4cca71f53fc5dad480ea2c47a4596d3f89785764) +++ Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/RingtoetsEntities.edmx.diagram (.../RingtoetsEntities.edmx.diagram) (revision c43e60dc31027ef84a70ecc2c252e028dd8888c5) @@ -4,100 +4,100 @@ - + - - - - - - - - - - + + + + + + + + + + - - - - - - - - - - - - - - - - - - - - - - - - + + + + + + + + + + + + + + + + + + + + + + + + - - + + - - - - - - - - - - - - - - - - - - - - - - - - + + + + + + + + + + + + + + + + + + + + + + + + - - - - - - - - - - - - + + + + + + + + + + + + - - - - + + + + - - - - - + + + + + Index: Application/Ringtoets/src/Application.Ringtoets.Storage/Ringtoets.rtd =================================================================== diff -u -r4cca71f53fc5dad480ea2c47a4596d3f89785764 -rc43e60dc31027ef84a70ecc2c252e028dd8888c5 Binary files differ Index: Application/Ringtoets/test/Application.Ringtoets.Storage.Test/RingtoetsDatabaseCreatorTest.cs =================================================================== diff -u -r0641053e020a1478f793ee17e753df60af26171f -rc43e60dc31027ef84a70ecc2c252e028dd8888c5 --- Application/Ringtoets/test/Application.Ringtoets.Storage.Test/RingtoetsDatabaseCreatorTest.cs (.../RingtoetsDatabaseCreatorTest.cs) (revision 0641053e020a1478f793ee17e753df60af26171f) +++ Application/Ringtoets/test/Application.Ringtoets.Storage.Test/RingtoetsDatabaseCreatorTest.cs (.../RingtoetsDatabaseCreatorTest.cs) (revision c43e60dc31027ef84a70ecc2c252e028dd8888c5) @@ -28,7 +28,7 @@ namespace Application.Ringtoets.Storage.Test { [TestFixture] - [Explicit("Creates a new Ringtoets.rtd file in the root of the Application.Ringtoets.Storage")] +// [Explicit("Creates a new Ringtoets.rtd file in the root of the Application.Ringtoets.Storage")] public class RingtoetsDatabaseCreatorTest { /// Index: build/DatabaseStructure.sql =================================================================== diff -u -r4d6b107a57f8108b102fb711569d1d33a3023389 -rc43e60dc31027ef84a70ecc2c252e028dd8888c5 --- build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 4d6b107a57f8108b102fb711569d1d33a3023389) +++ build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision c43e60dc31027ef84a70ecc2c252e028dd8888c5) @@ -1,1985 +1,1985 @@ -/* ---------------------------------------------------- */ -/* Generated by Enterprise Architect Version 12.0 */ -/* Created On : 24-jan-2018 10:25:03 */ -/* DBMS : SQLite */ -/* ---------------------------------------------------- */ - -/* Drop Tables */ - -DROP TABLE IF EXISTS 'VersionEntity' -; - -DROP TABLE IF EXISTS 'GrassCoverErosionInwardsDikeHeightOutputEntity' -; - -DROP TABLE IF EXISTS 'ProjectEntity' -; - -DROP TABLE IF EXISTS 'MacroStabilityInwardsFailureMechanismMetaEntity' -; - -DROP TABLE IF EXISTS 'AssessmentSectionEntity' -; - -DROP TABLE IF EXISTS 'FailureMechanismSectionEntity' -; - -DROP TABLE IF EXISTS 'StabilityPointStructuresCalculationEntity' -; - -DROP TABLE IF EXISTS 'FailureMechanismEntity' -; - -DROP TABLE IF EXISTS 'PipingFailureMechanismMetaEntity' -; - -DROP TABLE IF EXISTS 'ClosingStructuresFailureMechanismMetaEntity' -; - -DROP TABLE IF EXISTS 'StabilityStoneCoverFailureMechanismMetaEntity' -; - -DROP TABLE IF EXISTS 'CalculationGroupEntity' -; - -DROP TABLE IF EXISTS 'StabilityPointStructuresFailureMechanismMetaEntity' -; - -DROP TABLE IF EXISTS 'HydraulicLocationEntity' -; - -DROP TABLE IF EXISTS 'PipingCalculationEntity' -; - -DROP TABLE IF EXISTS 'GrassCoverErosionInwardsFailureMechanismMetaEntity' -; - -DROP TABLE IF EXISTS 'DuneErosionFailureMechanismMetaEntity' -; - -DROP TABLE IF EXISTS 'GrassCoverErosionInwardsCalculationEntity' -; - -DROP TABLE IF EXISTS 'HeightStructuresFailureMechanismMetaEntity' -; - -DROP TABLE IF EXISTS 'GrassCoverErosionOutwardsFailureMechanismMetaEntity' -; - -DROP TABLE IF EXISTS 'PipingSoilLayerEntity' -; - -DROP TABLE IF EXISTS 'PipingSoilProfileEntity' -; - -DROP TABLE IF EXISTS 'PipingStochasticSoilProfileEntity' -; - -DROP TABLE IF EXISTS 'StochasticSoilModelEntity' -; - -DROP TABLE IF EXISTS 'SurfaceLineEntity' -; - -DROP TABLE IF EXISTS 'PipingCharacteristicPointEntity' -; - -DROP TABLE IF EXISTS 'PipingCalculationOutputEntity' -; - -DROP TABLE IF EXISTS 'PipingSemiProbabilisticOutputEntity' -; - -DROP TABLE IF EXISTS 'PipingSectionResultEntity' -; - -DROP TABLE IF EXISTS 'GrassCoverErosionInwardsSectionResultEntity' -; - -DROP TABLE IF EXISTS 'HeightStructuresSectionResultEntity' -; - -DROP TABLE IF EXISTS 'StrengthStabilityLengthwiseConstructionSectionResultEntity' -; - -DROP TABLE IF EXISTS 'TechnicalInnovationSectionResultEntity' -; - -DROP TABLE IF EXISTS 'WaterPressureAsphaltCoverSectionResultEntity' -; - -DROP TABLE IF EXISTS 'ClosingStructuresSectionResultEntity' -; - -DROP TABLE IF EXISTS 'GrassCoverErosionOutwardsSectionResultEntity' -; - -DROP TABLE IF EXISTS 'GrassCoverSlipOffInwardsSectionResultEntity' -; - -DROP TABLE IF EXISTS 'GrassCoverSlipOffOutwardsSectionResultEntity' -; - -DROP TABLE IF EXISTS 'MacroStabilityInwardsSectionResultEntity' -; - -DROP TABLE IF EXISTS 'MacrostabilityOutwardsSectionResultEntity' -; - -DROP TABLE IF EXISTS 'WaveImpactAsphaltCoverSectionResultEntity' -; - -DROP TABLE IF EXISTS 'WaveImpactAsphaltCoverFailureMechanismMetaEntity' -; - -DROP TABLE IF EXISTS 'MicrostabilitySectionResultEntity' -; - -DROP TABLE IF EXISTS 'PipingStructureSectionResultEntity' -; - -DROP TABLE IF EXISTS 'DuneErosionSectionResultEntity' -; - -DROP TABLE IF EXISTS 'StabilityStoneCoverSectionResultEntity' -; - -DROP TABLE IF EXISTS 'StabilityPointStructuresSectionResultEntity' -; - -DROP TABLE IF EXISTS 'DikeProfileEntity' -; - -DROP TABLE IF EXISTS 'GrassCoverErosionInwardsOutputEntity' -; - -DROP TABLE IF EXISTS 'ForeshoreProfileEntity' -; - -DROP TABLE IF EXISTS 'StabilityStoneCoverWaveConditionsCalculationEntity' -; - -DROP TABLE IF EXISTS 'StabilityStoneCoverWaveConditionsOutputEntity' -; - -DROP TABLE IF EXISTS 'WaveImpactAsphaltCoverWaveConditionsCalculationEntity' -; - -DROP TABLE IF EXISTS 'WaveImpactAsphaltCoverWaveConditionsOutputEntity' -; - -DROP TABLE IF EXISTS 'GrassCoverErosionOutwardsWaveConditionsCalculationEntity' -; - -DROP TABLE IF EXISTS 'GrassCoverErosionOutwardsHydraulicLocationEntity' -; - -DROP TABLE IF EXISTS 'GrassCoverErosionOutwardsWaveConditionsOutputEntity' -; - -DROP TABLE IF EXISTS 'HeightStructuresOutputEntity' -; - -DROP TABLE IF EXISTS 'HeightStructureEntity' -; - -DROP TABLE IF EXISTS 'HeightStructuresCalculationEntity' -; - -DROP TABLE IF EXISTS 'ClosingStructureEntity' -; - -DROP TABLE IF EXISTS 'ClosingStructuresCalculationEntity' -; - -DROP TABLE IF EXISTS 'ClosingStructuresOutputEntity' -; - -DROP TABLE IF EXISTS 'StabilityPointStructureEntity' -; - -DROP TABLE IF EXISTS 'StabilityPointStructuresOutputEntity' -; - -DROP TABLE IF EXISTS 'HydraulicLocationOutputEntity' -; - -DROP TABLE IF EXISTS 'GrassCoverErosionOutwardsHydraulicLocationOutputEntity' -; - -DROP TABLE IF EXISTS 'DuneLocationEntity' -; - -DROP TABLE IF EXISTS 'DuneLocationOutputEntity' -; - -DROP TABLE IF EXISTS 'BackgroundDataEntity' -; - -DROP TABLE IF EXISTS 'BackgroundDataMetaEntity' -; - -DROP TABLE IF EXISTS 'GrassCoverErosionInwardsOvertoppingRateOutputEntity' -; - -DROP TABLE IF EXISTS 'GeneralResultSubMechanismIllustrationPointEntity' -; - -DROP TABLE IF EXISTS 'SubMechanismIllustrationPointEntity' -; - -DROP TABLE IF EXISTS 'IllustrationPointResultEntity' -; - -DROP TABLE IF EXISTS 'StochastEntity' -; - -DROP TABLE IF EXISTS 'GeneralResultSubMechanismIllustrationPointStochastEntity' -; - -DROP TABLE IF EXISTS 'GeneralResultFaultTreeIllustrationPointEntity' -; - -DROP TABLE IF EXISTS 'FaultTreeIllustrationPointEntity' -; - -DROP TABLE IF EXISTS 'FaultTreeIllustrationPointStochastEntity' -; - -DROP TABLE IF EXISTS 'GeneralResultFaultTreeIllustrationPointStochastEntity' -; - -DROP TABLE IF EXISTS 'TopLevelSubMechanismIllustrationPointEntity' -; - -DROP TABLE IF EXISTS 'TopLevelFaultTreeIllustrationPointEntity' -; - -DROP TABLE IF EXISTS 'SubMechanismIllustrationPointStochastEntity' -; - -DROP TABLE IF EXISTS 'FaultTreeSubmechanismIllustrationPointEntity' -; - -DROP TABLE IF EXISTS 'MacroStabilityInwardsCalculationEntity' -; - -DROP TABLE IF EXISTS 'MacroStabilityInwardsCalculationOutputEntity' -; - -DROP TABLE IF EXISTS 'MacroStabilityInwardsCharacteristicPointEntity' -; - -DROP TABLE IF EXISTS 'MacroStabilityInwardsSoilLayerOneDEntity' -; - -DROP TABLE IF EXISTS 'MacroStabilityInwardsSoilProfileOneDEntity' -; - -DROP TABLE IF EXISTS 'MacroStabilityInwardsSoilLayerTwoDEntity' -; - -DROP TABLE IF EXISTS 'MacroStabilityInwardsSoilProfileTwoDEntity' -; - -DROP TABLE IF EXISTS 'MacroStabilityInwardsStochasticSoilProfileEntity' -; - -DROP TABLE IF EXISTS 'MacroStabilityInwardsPreconsolidationStressEntity' -; - -DROP TABLE IF EXISTS 'MacroStabilityInwardsSemiProbabilisticOutputEntity' -; - -DROP TABLE IF EXISTS 'MacroStabilityInwardsSoilProfileTwoDSoilLayerTwoDEntity' -; - -DROP TABLE IF EXISTS 'HydraRingPreprocessorEntity' -; - -DROP TABLE IF EXISTS 'HydraulicLocationCalculationEntity' -; - -/* 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 'GrassCoverErosionInwardsDikeHeightOutputEntity' -( - 'GrassCoverErosionInwardsDikeHeightOutputEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'GrassCoverErosionInwardsOutputEntityId' INTEGER NOT NULL, - 'GeneralResultFaultTreeIllustrationPointEntityId' INTEGER, - 'DikeHeight' REAL, - 'TargetProbability' REAL, - 'TargetReliability' REAL, - 'CalculatedProbability' REAL, - 'CalculatedReliability' REAL, - '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 'ProjectEntity' -( - 'ProjectEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'Description' VARCHAR (260) -) -; - -CREATE TABLE 'MacroStabilityInwardsFailureMechanismMetaEntity' -( - 'MacroStabilityInwardsFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismEntityId' INTEGER NOT NULL, - 'A' REAL NOT NULL, - 'StochasticSoilModelCollectionSourcePath' TEXT, - 'SurfaceLineCollectionSourcePath' TEXT, - CONSTRAINT 'FK_MacroStabilityInwardsFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade -) -; - -CREATE TABLE 'AssessmentSectionEntity' -( - 'AssessmentSectionEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'ProjectEntityId' INTEGER NOT NULL, - 'Id' TEXT, - 'Name' VARCHAR (260), - 'Comments' TEXT, - 'LowerLimitNorm' REAL NOT NULL, - 'SignalingNorm' REAL NOT NULL, - 'NormativeNormType' TINYINT (1) NOT NULL, -- EnumType: 1 = LowerLimit, 2 = Signaling - 'HydraulicDatabaseVersion' TEXT, - 'HydraulicDatabaseLocation' TEXT, - 'Composition' TINYINT (1) NOT NULL, -- Enum: 1 = Dike, 2 = Dune, 3 = DikeAndDune - 'ReferenceLinePointXml' TEXT, - 'Order' INT (4) NOT NULL, - CONSTRAINT 'FK_AssessmentSectionEntity_ProjectEntity' FOREIGN KEY ('ProjectEntityId') REFERENCES 'ProjectEntity' ('ProjectEntityId') ON DELETE Cascade ON UPDATE Cascade -) -; - -CREATE TABLE 'FailureMechanismSectionEntity' -( - 'FailureMechanismSectionEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismEntityId' INTEGER NOT NULL, - 'Name' VARCHAR (260) NOT NULL, - 'FailureMechanismSectionPointXml' TEXT NOT NULL, - CONSTRAINT 'FK_FailureMechanismSectionEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade -) -; - -CREATE TABLE 'StabilityPointStructuresCalculationEntity' -( - 'StabilityPointStructuresCalculationEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'CalculationGroupEntityId' INTEGER NOT NULL, - 'ForeshoreProfileEntityId' INTEGER, - 'HydraulicLocationEntityId' INTEGER, - 'StabilityPointStructureEntityId' INTEGER, - 'Order' INT (4) NOT NULL, - 'Name' VARCHAR (260), - 'Comments' TEXT, - 'UseBreakWater' TINYINT (1) NOT NULL, -- true or false - 'BreakWaterType' TINYINT (1) NOT NULL, -- Enum: 1 = Wall, 2 = Caisson, 3 = Dam - 'BreakWaterHeight' REAL, - 'UseForeshore' TINYINT (1) NOT NULL, -- true or false - 'StructureNormalOrientation' REAL, - 'StorageStructureAreaMean' REAL, - 'StorageStructureAreaCoefficientOfVariation' REAL, - 'AllowedLevelIncreaseStorageMean' REAL, - 'AllowedLevelIncreaseStorageStandardDeviation' REAL, - 'WidthFlowAperturesMean' REAL, - 'WidthFlowAperturesStandardDeviation' REAL, - 'InsideWaterLevelMean' REAL, - 'InsideWaterLevelStandardDeviation' REAL, - 'ThresholdHeightOpenWeirMean' REAL, - 'ThresholdHeightOpenWeirStandardDeviation' REAL, - 'CriticalOvertoppingDischargeMean' REAL, - 'CriticalOvertoppingDischargeCoefficientOfVariation' REAL, - 'FlowWidthAtBottomProtectionMean' REAL, - 'FlowWidthAtBottomProtectionStandardDeviation' REAL, - 'ConstructiveStrengthLinearLoadModelMean' REAL, - 'ConstructiveStrengthLinearLoadModelCoefficientOfVariation' REAL, - 'ConstructiveStrengthQuadraticLoadModelMean' REAL, - 'ConstructiveStrengthQuadraticLoadModelCoefficientOfVariation' REAL, - 'BankWidthMean' REAL, - 'BankWidthStandardDeviation' REAL, - 'InsideWaterLevelFailureConstructionMean' REAL, - 'InsideWaterLevelFailureConstructionStandardDeviation' REAL, - 'EvaluationLevel' REAL, - 'LevelCrestStructureMean' REAL, - 'LevelCrestStructureStandardDeviation' REAL, - 'VerticalDistance' REAL, - 'FailureProbabilityRepairClosure' REAL NOT NULL, - 'FailureCollisionEnergyMean' REAL, - 'FailureCollisionEnergyCoefficientOfVariation' REAL, - 'ShipMassMean' REAL, - 'ShipMassCoefficientOfVariation' REAL, - 'ShipVelocityMean' REAL, - 'ShipVelocityCoefficientOfVariation' REAL, - 'LevellingCount' INT (4) NOT NULL, - 'ProbabilityCollisionSecondaryStructure' REAL NOT NULL, - 'FlowVelocityStructureClosableMean' REAL, - 'StabilityLinearLoadModelMean' REAL, - 'StabilityLinearLoadModelCoefficientOfVariation' REAL, - 'StabilityQuadraticLoadModelMean' REAL, - 'StabilityQuadraticLoadModelCoefficientOfVariation' REAL, - 'AreaFlowAperturesMean' REAL, - 'AreaFlowAperturesStandardDeviation' REAL, - 'InflowModelType' TINYINT (1) NOT NULL, -- Enum: 1 = VerticalWall, 2 = LowSill, 3 = FloodedCulvert - 'LoadSchematizationType' TINYINT (1) NOT NULL, -- Enum: 1 = Linear, 2 = Quadratic - 'VolumicWeightWater' REAL, - 'StormDurationMean' REAL, - 'ModelFactorSuperCriticalFlowMean' REAL, - 'FactorStormDurationOpenStructure' REAL, - 'DrainCoefficientMean' REAL, - 'FailureProbabilityStructureWithErosion' REAL NOT NULL, - 'ShouldIllustrationPointsBeCalculated' TINYINT (1) NOT NULL, -- true or false - 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 'FailureMechanismEntity' -( - 'FailureMechanismEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'AssessmentSectionEntityId' INTEGER NOT NULL, - 'CalculationGroupEntityId' INTEGER, - '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 = Macrostabiliteit buitenwaarts, 14 = Microstabiliteit, 15 = Wateroverdruk bij asfaltbekleding, 16 = Grasbekleding afschuiven binnentalud, 17 = Sterkte en stabiliteit langsconstructires, 18 = Technische innovaties - 'IsRelevant' TINYINT (1) NOT NULL, -- true or false - 'InputComments' TEXT, - 'OutputComments' TEXT, - 'NotRelevantComments' TEXT, - 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 'PipingFailureMechanismMetaEntity' -( - 'PipingFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismEntityId' INTEGER NOT NULL, - 'A' REAL NOT NULL, - 'WaterVolumetricWeight' REAL NOT NULL, - 'StochasticSoilModelCollectionSourcePath' TEXT, - 'SurfaceLineCollectionSourcePath' TEXT, - CONSTRAINT 'FK_PipingFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade -) -; - -CREATE TABLE 'ClosingStructuresFailureMechanismMetaEntity' -( - 'ClosingStructuresFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismEntityId' INTEGER NOT NULL, - 'N2A' INT (4) NOT NULL, - 'ClosingStructureCollectionSourcePath' TEXT, - 'ForeshoreProfileCollectionSourcePath' TEXT, - CONSTRAINT 'FK_ClosingStructuresFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade -) -; - -CREATE TABLE 'StabilityStoneCoverFailureMechanismMetaEntity' -( - 'StabilityStoneCoverFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismEntityId' INTEGER NOT NULL, - 'ForeshoreProfileCollectionSourcePath' TEXT, - 'N' REAL NOT NULL, - CONSTRAINT 'FK_StabilityStoneCoverFailureMechanismMetaEntity_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, - 'Name' VARCHAR (260), - 'Order' INT (4) NOT NULL, - CONSTRAINT 'FK_CalculationGroupEntity_CalculationGroupEntity' FOREIGN KEY ('ParentCalculationGroupEntityId') REFERENCES 'CalculationGroupEntity' ('CalculationGroupEntityId') ON DELETE Cascade ON UPDATE Cascade -) -; - -CREATE TABLE 'StabilityPointStructuresFailureMechanismMetaEntity' -( - 'StabilityPointStructuresFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismEntityId' INTEGER NOT NULL, - 'N' INT (4) NOT NULL, - 'ForeshoreProfileCollectionSourcePath' TEXT, - 'StabilityPointStructureCollectionSourcePath' TEXT, - CONSTRAINT 'FK_StrengthStabilityPointConstructionFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade -) -; - -CREATE TABLE 'HydraulicLocationEntity' -( - 'HydraulicLocationEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'AssessmentSectionEntityId' INTEGER NOT NULL, - 'HydraulicLocationCalculationEntity_DesignWaterLevelCalculationOneId' INTEGER NOT NULL, - 'HydraulicLocationCalculationEntity_DesignWaterLevelCalculationTwoId' INTEGER NOT NULL, - 'HydraulicLocationCalculationEntity_DesignWaterLevelCalculationThreeId' INTEGER NOT NULL, - 'HydraulicLocationCalculationEntity_DesignWaterLevelCalculationFourId' INTEGER NOT NULL, - 'HydraulicLocationCalculationEntity_WaveHeightCalculationOneId' INTEGER NOT NULL, - 'HydraulicLocationCalculationEntity_WaveHeightCalculationTwoId' INTEGER NOT NULL, - 'HydraulicLocationCalculationEntity_WaveHeightCalculationThreeId' INTEGER NOT NULL, - 'HydraulicLocationCalculationEntity_WaveHeightCalculationFourId' INTEGER NOT NULL, - 'LocationId' INTEGER NOT NULL, - 'Name' VARCHAR (260) NOT NULL, - 'LocationX' REAL, - 'LocationY' REAL, - 'Order' INT (4) NOT NULL, - CONSTRAINT 'FK_HydraulicLocationEntity_AssessmentSectionEntity' FOREIGN KEY ('AssessmentSectionEntityId') REFERENCES 'AssessmentSectionEntity' ('AssessmentSectionEntityId') ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT 'FK_HydraulicLocationEntity_HydraulicLocationCalculationEntity_DesignWaterLevelCalculationFour' FOREIGN KEY ('HydraulicLocationCalculationEntity_DesignWaterLevelCalculationFourId') REFERENCES 'HydraulicLocationCalculationEntity' ('HydraulicLocationCalculationEntityId') ON DELETE No Action ON UPDATE Cascade, - CONSTRAINT 'FK_HydraulicLocationEntity_HydraulicLocationCalculationEntity_DesignWaterLevelCalculationOne' FOREIGN KEY ('HydraulicLocationCalculationEntity_DesignWaterLevelCalculationOneId') REFERENCES 'HydraulicLocationCalculationEntity' ('HydraulicLocationCalculationEntityId') ON DELETE No Action ON UPDATE Cascade, - CONSTRAINT 'FK_HydraulicLocationEntity_HydraulicLocationCalculationEntity_DesignWaterLevelCalculationThree' FOREIGN KEY ('HydraulicLocationCalculationEntity_DesignWaterLevelCalculationThreeId') REFERENCES 'HydraulicLocationCalculationEntity' ('HydraulicLocationCalculationEntityId') ON DELETE No Action ON UPDATE Cascade, - CONSTRAINT 'FK_HydraulicLocationEntity_HydraulicLocationCalculationEntity_DesignWaterLevelCalculationTwo' FOREIGN KEY ('HydraulicLocationCalculationEntity_DesignWaterLevelCalculationTwoId') REFERENCES 'HydraulicLocationCalculationEntity' ('HydraulicLocationCalculationEntityId') ON DELETE No Action ON UPDATE Cascade, - CONSTRAINT 'FK_HydraulicLocationEntity_HydraulicLocationCalculationEntity_WaveHeightCalculationFour' FOREIGN KEY ('HydraulicLocationCalculationEntity_WaveHeightCalculationFourId') REFERENCES 'HydraulicLocationCalculationEntity' ('HydraulicLocationCalculationEntityId') ON DELETE No Action ON UPDATE Cascade, - CONSTRAINT 'FK_HydraulicLocationEntity_HydraulicLocationCalculationEntity_WaveHeightCalculationOne' FOREIGN KEY ('HydraulicLocationCalculationEntity_WaveHeightCalculationOneId') REFERENCES 'HydraulicLocationCalculationEntity' ('HydraulicLocationCalculationEntityId') ON DELETE No Action ON UPDATE Cascade, - CONSTRAINT 'FK_HydraulicLocationEntity_HydraulicLocationCalculationEntity_WaveHeightCalculationThree' FOREIGN KEY ('HydraulicLocationCalculationEntity_WaveHeightCalculationThreeId') REFERENCES 'HydraulicLocationCalculationEntity' ('HydraulicLocationCalculationEntityId') ON DELETE No Action ON UPDATE Cascade, - CONSTRAINT 'FK_HydraulicLocationEntity_HydraulicLocationCalculationEntity_WaveHeightCalculationTwo' FOREIGN KEY ('HydraulicLocationCalculationEntity_WaveHeightCalculationTwoId') REFERENCES 'HydraulicLocationCalculationEntity' ('HydraulicLocationCalculationEntityId') ON DELETE No Action ON UPDATE Cascade, - CONSTRAINT 'U_HydraulicLocationCalculationEntity_DesignWaterLevelCalculationOneId' UNIQUE ('HydraulicLocationCalculationEntity_DesignWaterLevelCalculationOneId'), - CONSTRAINT 'U_HydraulicLocationCalculationEntity_DesignWaterLevelCalculationTwoId' UNIQUE ('HydraulicLocationCalculationEntity_DesignWaterLevelCalculationTwoId'), - CONSTRAINT 'U_HydraulicLocationCalculationEntity_DesignWaterLevelCalculationThreeId' UNIQUE ('HydraulicLocationCalculationEntity_DesignWaterLevelCalculationThreeId'), - CONSTRAINT 'U_HydraulicLocationCalculationEntity_DesignWaterLevelCalculationFourId' UNIQUE ('HydraulicLocationCalculationEntity_DesignWaterLevelCalculationFourId'), - CONSTRAINT 'U_HydraulicLocationCalculationEntity_WaveHeightCalculationOneId' UNIQUE ('HydraulicLocationCalculationEntity_WaveHeightCalculationOneId'), - CONSTRAINT 'U_HydraulicLocationCalculationEntity_WaveHeightCalculationTwoId' UNIQUE ('HydraulicLocationCalculationEntity_WaveHeightCalculationTwoId'), - CONSTRAINT 'U_HydraulicLocationCalculationEntity_WaveHeightCalculationThreeId' UNIQUE ('HydraulicLocationCalculationEntity_WaveHeightCalculationThreeId'), - CONSTRAINT 'U_HydraulicLocationCalculationEntity_WaveHeightCalculationFourId' UNIQUE ('HydraulicLocationCalculationEntity_WaveHeightCalculationFourId') -) -; - -CREATE TABLE 'PipingCalculationEntity' -( - 'PipingCalculationEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'CalculationGroupEntityId' INTEGER NOT NULL, - 'SurfaceLineEntityId' INTEGER, - 'PipingStochasticSoilProfileEntityId' INTEGER, - 'HydraulicLocationEntityId' INTEGER, - 'Order' INT (4) NOT NULL, - 'Name' VARCHAR (260), - 'Comments' TEXT, - 'EntryPointL' REAL, - 'ExitPointL' REAL, - 'PhreaticLevelExitMean' REAL, - 'PhreaticLevelExitStandardDeviation' REAL, - 'DampingFactorExitMean' REAL, - 'DampingFactorExitStandardDeviation' REAL, - 'RelevantForScenario' TINYINT (1) NOT NULL, -- true or false - 'ScenarioContribution' REAL, - 'AssessmentLevel' REAL, - 'UseAssessmentLevelManualInput' TINYINT (1) NOT NULL, -- true or false - CONSTRAINT 'FK_PipingCalculationEntity_CalculationGroupEntity' FOREIGN KEY ('CalculationGroupEntityId') REFERENCES 'CalculationGroupEntity' ('CalculationGroupEntityId') ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT 'FK_PipingCalculationEntity_HydraulicLocationEntity' FOREIGN KEY ('HydraulicLocationEntityId') REFERENCES 'HydraulicLocationEntity' ('HydraulicLocationEntityId') ON DELETE Set Null ON UPDATE Cascade, - CONSTRAINT 'FK_PipingCalculationEntity_PipingStochasticSoilProfileEntity' FOREIGN KEY ('PipingStochasticSoilProfileEntityId') REFERENCES 'PipingStochasticSoilProfileEntity' ('PipingStochasticSoilProfileEntityId') ON DELETE Set Null ON UPDATE Cascade, - CONSTRAINT 'FK_PipingCalculationEntity_SurfaceLineEntity' FOREIGN KEY ('SurfaceLineEntityId') REFERENCES 'SurfaceLineEntity' ('SurfaceLineEntityId') ON DELETE Set Null ON UPDATE Cascade -) -; - -CREATE TABLE 'GrassCoverErosionInwardsFailureMechanismMetaEntity' -( - 'GrassCoverErosionInwardsFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismEntityId' INTEGER NOT NULL, - 'N' INT (4) NOT NULL, - 'DikeProfileCollectionSourcePath' TEXT, - CONSTRAINT 'FK_GrassCoverErosionInwardsFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade -) -; - -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 'GrassCoverErosionInwardsCalculationEntity' -( - 'GrassCoverErosionInwardsCalculationEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'CalculationGroupEntityId' INTEGER NOT NULL, - 'HydraulicLocationEntityId' INTEGER, - 'DikeProfileEntityId' INTEGER, - 'Order' INT (4) NOT NULL, - 'Name' VARCHAR (260), - 'Comments' TEXT, - 'Orientation' REAL, - 'CriticalFlowRateMean' REAL, - 'CriticalFlowRateStandardDeviation' REAL, - 'UseForeshore' TINYINT (1) NOT NULL, -- true or false - 'DikeHeightCalculationType' TINYINT (1) NOT NULL, -- Enum: 1 = NoCalculation, 2 = CalculateByAssessmentSectionNorm, 3 = CalculateByProfileSpecificRequiredProbability - 'DikeHeight' REAL, - 'UseBreakWater' TINYINT (1) NOT NULL, -- true or false - 'BreakWaterType' TINYINT (1) NOT NULL, -- Enum: 1 = Wall, 2 = Caisson, 3 = Dam - 'BreakWaterHeight' REAL, - 'OvertoppingRateCalculationType' TINYINT (1) NOT NULL, -- Enum: 1 = NoCalculation, 2 = CalculateByAssessmentSectionNorm, 3 = CalculateByProfileSpecificRequiredProbability - 'ShouldDikeHeightIllustrationPointsBeCalculated' TINYINT (1) NOT NULL, -- true or false - 'ShouldOvertoppingRateIllustrationPointsBeCalculated' TINYINT (1) NOT NULL, -- true or false - 'ShouldOvertoppingOutputIllustrationPointsBeCalculated' TINYINT (1) NOT NULL, -- true or false - 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 'HeightStructuresFailureMechanismMetaEntity' -( - 'HeightStructuresFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismEntityId' INTEGER NOT NULL, - 'N' INT (4) NOT NULL, - 'HeightStructureCollectionSourcePath' TEXT, - 'ForeshoreProfileCollectionSourcePath' TEXT, - CONSTRAINT 'FK_HeightStructuresFailureMechanismMetaEntity_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' INT (4) NOT NULL, - 'ForeshoreProfileCollectionSourcePath' TEXT, - 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, - 'IsAquifer' TINYINT (1) NOT NULL, -- true or false - 'Color' INTEGER, -- ARGB value of Color. - 'MaterialName' TEXT NOT NULL, - 'BelowPhreaticLevelMean' REAL, - 'BelowPhreaticLevelDeviation' REAL, - 'BelowPhreaticLevelShift' REAL, - 'DiameterD70Mean' REAL, - 'DiameterD70CoefficientOfVariation' REAL, - 'PermeabilityMean' REAL, - 'PermeabilityCoefficientOfVariation' REAL, - '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, - 'Name' TEXT NOT NULL, - '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 'StochasticSoilModelEntity' -( - 'StochasticSoilModelEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismEntityId' INTEGER NOT NULL, - 'Name' TEXT NOT NULL, - 'StochasticSoilModelSegmentPointXml' TEXT NOT NULL, - '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, - 'ReferenceLineIntersectionY' REAL, - 'PointsXml' TEXT NOT NULL, - '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, - 'Y' REAL, - 'Z' REAL, - CONSTRAINT 'FK_SurfaceLinePointEntity_SurfaceLineEntity' FOREIGN KEY ('SurfaceLineEntityId') REFERENCES 'SurfaceLineEntity' ('SurfaceLineEntityId') ON DELETE Cascade ON UPDATE Cascade -) -; - -CREATE TABLE 'PipingCalculationOutputEntity' -( - 'PipingCalculationOutputEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'PipingCalculationEntityId' INTEGER NOT NULL, - 'Order' INT (4) NOT NULL, - 'HeaveFactorOfSafety' REAL, - 'HeaveZValue' REAL, - 'UpliftFactorOfSafety' REAL, - 'UpliftZValue' REAL, - 'SellmeijerFactorOfSafety' REAL, - 'SellmeijerZValue' REAL, - 'UpliftEffectiveStress' REAL, - 'HeaveGradient' REAL, - 'SellmeijerCreepCoefficient' REAL, - 'SellmeijerCriticalFall' REAL, - 'SellmeijerReducedFall' REAL, - CONSTRAINT 'FK_PipingCalculationOutputEntity_PipingCalculationEntity' FOREIGN KEY ('PipingCalculationEntityId') REFERENCES 'PipingCalculationEntity' ('PipingCalculationEntityId') ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT 'U_PipingCalculationEntity' UNIQUE ('PipingCalculationEntityId') -) -; - -CREATE TABLE 'PipingSemiProbabilisticOutputEntity' -( - 'PipingSemiProbabilisticOutputEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'PipingCalculationEntityId' INTEGER NOT NULL, - 'Order' INT (4) NOT NULL, - 'UpliftFactorOfSafety' REAL, - 'UpliftReliability' REAL, - 'UpliftProbability' REAL, - 'HeaveFactorOfSafety' REAL, - 'HeaveReliability' REAL, - 'HeaveProbability' REAL, - 'SellmeijerFactorOfSafety' REAL, - 'SellmeijerReliability' REAL, - 'SellmeijerProbability' REAL, - 'RequiredProbability' REAL, - 'RequiredReliability' REAL, - 'PipingProbability' REAL, - 'PipingReliability' REAL, - 'PipingFactorOfSafety' REAL, - CONSTRAINT 'FK_PipingSemiProbabilisticOutputEntity_PipingCalculationEntity' FOREIGN KEY ('PipingCalculationEntityId') REFERENCES 'PipingCalculationEntity' ('PipingCalculationEntityId') ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT 'U_PipingCalculationEntity' UNIQUE ('PipingCalculationEntityId') -) -; - -CREATE TABLE 'PipingSectionResultEntity' -( - 'PipingSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismSectionEntityId' INTEGER NOT NULL, - 'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed, 2 = Sufficient, 3 = NoVerdict - 'LayerThree' REAL, - CONSTRAINT 'FK_PipingSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade -) -; - -CREATE TABLE 'GrassCoverErosionInwardsSectionResultEntity' -( - 'GrassCoverErosionInwardsSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismSectionEntityId' INTEGER NOT NULL, - 'GrassCoverErosionInwardsCalculationEntityId' INTEGER, - 'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed, 2 = Sufficient, 3 = NoVerdict - 'LayerThree' REAL, - CONSTRAINT 'FK_GrassCoverErosionInwardsSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT 'FK_GrassCoverErosionInwardsSectionResultEntity_GrassCoverErosionInwardsCalculationEntity' FOREIGN KEY ('GrassCoverErosionInwardsCalculationEntityId') REFERENCES 'GrassCoverErosionInwardsCalculationEntity' ('GrassCoverErosionInwardsCalculationEntityId') ON DELETE Set Null ON UPDATE Cascade -) -; - -CREATE TABLE 'HeightStructuresSectionResultEntity' -( - 'HeightStructuresSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismSectionEntityId' INTEGER NOT NULL, - 'HeightStructuresCalculationEntityId' INTEGER, - 'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed, 2 = Sufficient, 3 = NoVerdict - 'LayerThree' REAL, - CONSTRAINT 'FK_HeightStructuresSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT 'FK_HeightStructuresSectionResultEntity_HeightStructuresCalculationEntity' FOREIGN KEY ('HeightStructuresCalculationEntityId') REFERENCES 'HeightStructuresCalculationEntity' ('HeightStructuresCalculationEntityId') ON DELETE Set Null ON UPDATE Cascade -) -; - -CREATE TABLE 'StrengthStabilityLengthwiseConstructionSectionResultEntity' -( - 'StrengthStabilityLengthwiseConstructionSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismSectionEntityId' INTEGER NOT NULL, - 'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed, 2 = Sufficient, 3 = NoVerdict - 'LayerThree' REAL, - CONSTRAINT 'FK_StrengthStabilityLengthwiseConstructionSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade -) -; - -CREATE TABLE 'TechnicalInnovationSectionResultEntity' -( - 'TechnicalInnovationSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismSectionEntityId' INTEGER NOT NULL, - 'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed, 2 = Sufficient, 3 = NoVerdict - 'LayerThree' REAL, - CONSTRAINT 'FK_TechnicalInnovationSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade -) -; - -CREATE TABLE 'WaterPressureAsphaltCoverSectionResultEntity' -( - 'WaterPressureAsphaltCoverSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismSectionEntityId' INTEGER NOT NULL, - 'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed, 2 = Sufficient, 3 = NoVerdict - 'LayerThree' REAL, - CONSTRAINT 'FK_WaterPressureAsphaltCoverSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade -) -; - -CREATE TABLE 'ClosingStructuresSectionResultEntity' -( - 'ClosingStructuresSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismSectionEntityId' INTEGER NOT NULL, - 'ClosingStructuresCalculationEntityId' INTEGER, - 'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed, 2 = Sufficient, 3 = NoVerdict - 'LayerThree' REAL, - CONSTRAINT 'FK_ClosingStructuresSectionResultEntity_ClosingStructuresCalculationEntity' FOREIGN KEY ('ClosingStructuresCalculationEntityId') REFERENCES 'ClosingStructuresCalculationEntity' ('ClosingStructuresCalculationEntityId') ON DELETE Set Null ON UPDATE Cascade, - CONSTRAINT 'FK_ClosingStructuresSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade -) -; - -CREATE TABLE 'GrassCoverErosionOutwardsSectionResultEntity' -( - 'GrassCoverErosionOutwardsSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismSectionEntityId' INTEGER NOT NULL, - 'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed, 2 = Sufficient, 3 = NoVerdict - 'LayerTwoA' TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated, 2 = Failed, 3 = Successful - 'LayerThree' REAL, - CONSTRAINT 'FK_GrassCoverErosionOutwardsSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade -) -; - -CREATE TABLE 'GrassCoverSlipOffInwardsSectionResultEntity' -( - 'GrassCoverSlipOffInwardsSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismSectionEntityId' INTEGER NOT NULL, - 'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed, 2 = Sufficient, 3 = NoVerdict - 'LayerTwoA' TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated, 2 = Failed, 3 = Successful - 'LayerThree' REAL, - CONSTRAINT 'FK_GrassCoverSlipOffInwardsSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade -) -; - -CREATE TABLE 'GrassCoverSlipOffOutwardsSectionResultEntity' -( - 'GrassCoverSlipOffOutwardsSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismSectionEntityId' INTEGER NOT NULL, - 'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed, 2 = Sufficient, 3 = NoVerdict - 'LayerTwoA' TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated, 2 = Failed, 3 = Successful - 'LayerThree' REAL, - CONSTRAINT 'FK_GrassCoverSlipOffOutwardsSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade -) -; - -CREATE TABLE 'MacroStabilityInwardsSectionResultEntity' -( - 'MacroStabilityInwardsSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismSectionEntityId' INTEGER NOT NULL, - 'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed, 2 = Sufficient, 3 = NoVerdict - 'LayerThree' REAL, - CONSTRAINT 'FK_MacroStabilityInwardsSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade -) -; - -CREATE TABLE 'MacrostabilityOutwardsSectionResultEntity' -( - 'MacrostabilityOutwardsSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismSectionEntityId' INTEGER NOT NULL, - 'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed, 2 = Sufficient, 3 = NoVerdict - 'LayerTwoA' REAL, - 'LayerThree' REAL, - CONSTRAINT 'FK_MacrostabilityOutwardsSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade -) -; - -CREATE TABLE 'WaveImpactAsphaltCoverSectionResultEntity' -( - 'WaveImpactAsphaltCoverSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismSectionEntityId' INTEGER NOT NULL, - 'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed, 2 = Sufficient, 3 = NoVerdict - 'LayerTwoA' TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated, 2 = Failed, 3 = Successful - 'LayerThree' REAL, - CONSTRAINT 'FK_WaveImpactAsphaltCoverSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade -) -; - -CREATE TABLE 'WaveImpactAsphaltCoverFailureMechanismMetaEntity' -( - 'WaveImpactAsphaltCoverFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismEntityId' INTEGER NOT NULL, - 'ForeshoreProfileCollectionSourcePath' TEXT, - CONSTRAINT 'FK_WaveImpactAsphaltCoverFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade -) -; - -CREATE TABLE 'MicrostabilitySectionResultEntity' -( - 'MicrostabilitySectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismSectionEntityId' INTEGER NOT NULL, - 'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed, 2 = Sufficient, 3 = NoVerdict - 'LayerTwoA' TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated, 2 = Failed, 3 = Successful - 'LayerThree' REAL, - CONSTRAINT 'FK_MicrostabilitySectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade -) -; - -CREATE TABLE 'PipingStructureSectionResultEntity' -( - 'PipingStructureSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismSectionEntityId' INTEGER NOT NULL, - 'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed, 2 = Sufficient, 3 = NoVerdict - 'LayerTwoA' TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated, 2 = Failed, 3 = Successful - 'LayerThree' REAL, - CONSTRAINT 'FK_PipingStructureSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade -) -; - -CREATE TABLE 'DuneErosionSectionResultEntity' -( - 'DuneErosionSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismSectionEntityId' INTEGER NOT NULL, - 'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed, 2 = Sufficient, 3 = NoVerdict - 'LayerTwoA' TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated, 2 = Failed, 3 = Successful - 'LayerThree' REAL, - CONSTRAINT 'FK_DuneErosionSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade -) -; - -CREATE TABLE 'StabilityStoneCoverSectionResultEntity' -( - 'StabilityStoneCoverSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismSectionEntityId' INTEGER NOT NULL, - 'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed, 2 = Sufficient, 3 = NoVerdict - 'LayerTwoA' TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated, 2 = Failed, 3 = Successful - 'LayerThree' REAL, - CONSTRAINT 'FK_StabilityStoneCoverSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade -) -; - -CREATE TABLE 'StabilityPointStructuresSectionResultEntity' -( - 'StabilityPointStructuresSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismSectionEntityId' INTEGER NOT NULL, - 'StabilityPointStructuresCalculationEntityId' INTEGER, - 'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed, 2 = Sufficient, 3 = NoVerdict - 'LayerThree' REAL, - CONSTRAINT 'FK_StabilityPointStructuresSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT 'FK_StabilityPointStructuresSectionResultEntity_StabilityPointStructuresCalculationEntity' FOREIGN KEY ('StabilityPointStructuresCalculationEntityId') REFERENCES 'StabilityPointStructuresCalculationEntity' ('StabilityPointStructuresCalculationEntityId') ON DELETE Set Null ON UPDATE Cascade -) -; - -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, - 'BreakWaterType' TINYINT (1), -- Enum: 1 = Wall 2 = Caisson 3 = Dam - 'BreakWaterHeight' REAL, - 'ForeshoreXml' TEXT NOT NULL, - 'DikeGeometryXml' TEXT NOT NULL, - 'DikeHeight' REAL, - 'X' REAL, - 'Y' REAL, - 'X0' REAL, - '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 'GrassCoverErosionInwardsOutputEntity' -( - 'GrassCoverErosionInwardsOutputEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'GrassCoverErosionInwardsCalculationEntityId' INTEGER NOT NULL, - 'GeneralResultFaultTreeIllustrationPointEntityId' INTEGER, - 'Order' INT (4) NOT NULL, - 'IsOvertoppingDominant' TINYINT (1) NOT NULL, -- true or false - 'WaveHeight' REAL, - 'RequiredProbability' REAL, - 'RequiredReliability' REAL, - 'Probability' REAL, - 'Reliability' REAL, - 'FactorOfSafety' REAL, - 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 'ForeshoreProfileEntity' -( - 'ForeshoreProfileEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismEntityId' INTEGER NOT NULL, - 'Id' VARCHAR (260) NOT NULL, - 'Name' VARCHAR (260) NOT NULL, - 'Orientation' REAL, - 'BreakWaterType' TINYINT (1), -- Enum: 1 = Wall, 2 = Caisson, 3 = Dam - 'BreakWaterHeight' REAL, - 'GeometryXml' TEXT NOT NULL, - 'X' REAL, - 'Y' REAL, - 'X0' REAL, - '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 'StabilityStoneCoverWaveConditionsCalculationEntity' -( - 'StabilityStoneCoverWaveConditionsCalculationEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'CalculationGroupEntityId' INTEGER NOT NULL, - 'ForeshoreProfileEntityId' INTEGER, - 'HydraulicLocationEntityId' INTEGER, - 'Order' INT (4) NOT NULL, - 'Name' VARCHAR (260), - 'Comments' TEXT, - 'UseBreakWater' TINYINT (1) NOT NULL, -- true or false - 'BreakWaterType' TINYINT (1) NOT NULL, -- Enum: 1 = Wall, 2 = Caisson, 3 = Dam - 'BreakWaterHeight' REAL, - 'UseForeshore' TINYINT (1) NOT NULL, -- true or false - 'Orientation' REAL, - 'UpperBoundaryRevetment' REAL, - 'LowerBoundaryRevetment' REAL, - 'UpperBoundaryWaterLevels' REAL, - 'LowerBoundaryWaterLevels' REAL, - 'StepSize' TINYINT (1) NOT NULL, -- Enum: 1 = 0.5, 2 = 1.0, 3 = 2.0 - 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_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, - 'WaveHeight' REAL, - 'WavePeakPeriod' REAL, - 'WaveAngle' REAL, - 'WaveDirection' REAL, - 'TargetProbability' REAL, - 'TargetReliability' REAL, - 'CalculatedProbability' REAL, - 'CalculatedReliability' REAL, - '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 'WaveImpactAsphaltCoverWaveConditionsCalculationEntity' -( - 'WaveImpactAsphaltCoverWaveConditionsCalculationEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'CalculationGroupEntityId' INTEGER NOT NULL, - 'ForeshoreProfileEntityId' INTEGER, - 'HydraulicLocationEntityId' INTEGER, - 'Order' INT (4) NOT NULL, - 'Name' VARCHAR (260), - 'Comments' TEXT, - 'UseBreakWater' TINYINT (1) NOT NULL, -- true or false - 'BreakWaterType' TINYINT (1) NOT NULL, -- Enum: 1 = Wall, 2 = Caisson, 3 = Dam - 'BreakWaterHeight' REAL, - 'UseForeshore' TINYINT (1) NOT NULL, -- true or false - 'Orientation' REAL, - 'UpperBoundaryRevetment' REAL, - 'LowerBoundaryRevetment' REAL, - 'UpperBoundaryWaterLevels' REAL, - 'LowerBoundaryWaterLevels' REAL, - 'StepSize' TINYINT (1) NOT NULL, -- Enum: 1 = 0.5, 2 = 1.0, 3 = 2.0 - 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_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, - 'WaveHeight' REAL, - 'WavePeakPeriod' REAL, - 'WaveAngle' REAL, - 'WaveDirection' REAL, - 'TargetProbability' REAL, - 'TargetReliability' REAL, - 'CalculatedProbability' REAL, - 'CalculatedReliability' REAL, - '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 TABLE 'GrassCoverErosionOutwardsWaveConditionsCalculationEntity' -( - 'GrassCoverErosionOutwardsWaveConditionsCalculationEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'CalculationGroupEntityId' INTEGER NOT NULL, - 'ForeshoreProfileEntityId' INTEGER, - 'GrassCoverErosionOutwardsHydraulicLocationEntityId' INTEGER, - 'Order' INT (4) NOT NULL, - 'Name' VARCHAR (260), - 'Comments' TEXT, - 'UseBreakWater' TINYINT (1) NOT NULL, -- true or false - 'BreakWaterType' TINYINT (1) NOT NULL, -- Enum: 1 = Wall, 2 = Caisson, 3 = Dam - 'BreakWaterHeight' REAL, - 'UseForeshore' TINYINT (1) NOT NULL, -- true or false - 'Orientation' REAL, - 'UpperBoundaryRevetment' REAL, - 'LowerBoundaryRevetment' REAL, - 'UpperBoundaryWaterLevels' REAL, - 'LowerBoundaryWaterLevels' REAL, - 'StepSize' TINYINT (1) NOT NULL, -- Enum: 1 = 0.5, 2 = 1.0, 3 = 2.0 - 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_GrassCoverErosionOutwardsHydraulicLocationEntity' FOREIGN KEY ('GrassCoverErosionOutwardsHydraulicLocationEntityId') REFERENCES 'GrassCoverErosionOutwardsHydraulicLocationEntity' ('GrassCoverErosionOutwardsHydraulicLocationEntityId') ON DELETE Set Null ON UPDATE Cascade -) -; - -CREATE TABLE 'GrassCoverErosionOutwardsHydraulicLocationEntity' -( - 'GrassCoverErosionOutwardsHydraulicLocationEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismEntityId' INTEGER NOT NULL, - 'LocationId' INTEGER NOT NULL, - 'Name' VARCHAR (260) NOT NULL, - 'LocationX' REAL, - 'LocationY' REAL, - 'ShouldWaveHeightIllustrationPointsBeCalculated' TINYINT (1) NOT NULL, -- true or false - 'ShouldDesignWaterLevelIllustrationPointsBeCalculated' TINYINT (1) NOT NULL, -- true or false - 'Order' INT (4) NOT NULL, - CONSTRAINT 'FK_GrassCoverErosionOutwardsHydraulicLocationEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade -) -; - -CREATE TABLE 'GrassCoverErosionOutwardsWaveConditionsOutputEntity' -( - 'GrassCoverErosionOutwardsWaveConditionsOutputEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'GrassCoverErosionOutwardsWaveConditionsCalculationEntityId' INTEGER NOT NULL, - 'Order' INT (4) NOT NULL, - 'WaterLevel' REAL, - 'WaveHeight' REAL, - 'WavePeakPeriod' REAL, - 'WaveAngle' REAL, - 'WaveDirection' REAL, - 'TargetProbability' REAL, - 'TargetReliability' REAL, - 'CalculatedProbability' REAL, - 'CalculatedReliability' REAL, - '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 'HeightStructuresOutputEntity' -( - 'HeightStructuresOutputEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'HeightStructuresCalculationEntityId' INTEGER NOT NULL, - 'GeneralResultFaultTreeIllustrationPointEntityId' INTEGER, - 'RequiredProbability' REAL, - 'RequiredReliability' REAL, - 'Probability' REAL, - 'Reliability' REAL, - 'FactorOfSafety' REAL, - 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 '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, - 'Y' REAL, - 'StructureNormalOrientation' REAL, - 'LevelCrestStructureMean' REAL, - 'LevelCrestStructureStandardDeviation' REAL, - 'FlowWidthAtBottomProtectionMean' REAL, - 'FlowWidthAtBottomProtectionStandardDeviation' REAL, - 'CriticalOvertoppingDischargeMean' REAL, - 'CriticalOvertoppingDischargeCoefficientOfVariation' REAL, - 'WidthFlowAperturesMean' REAL, - 'WidthFlowAperturesStandardDeviation' REAL, - 'FailureProbabilityStructureWithErosion' REAL, - 'StorageStructureAreaMean' REAL, - 'StorageStructureAreaCoefficientOfVariation' REAL, - 'AllowedLevelIncreaseStorageMean' REAL, - 'AllowedLevelIncreaseStorageStandardDeviation' REAL, - 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, - 'HeightStructureEntityId' INTEGER, - 'ForeshoreProfileEntityId' INTEGER, - 'Order' INT (4) NOT NULL, - 'Name' VARCHAR (260), - 'Comments' TEXT, - 'ModelFactorSuperCriticalFlowMean' REAL, - 'StructureNormalOrientation' REAL, - 'AllowedLevelIncreaseStorageMean' REAL, - 'AllowedLevelIncreaseStorageStandardDeviation' REAL, - 'StorageStructureAreaMean' REAL, - 'StorageStructureAreaCoefficientOfVariation' REAL, - 'FlowWidthAtBottomProtectionMean' REAL, - 'FlowWidthAtBottomProtectionStandardDeviation' REAL, - 'CriticalOvertoppingDischargeMean' REAL, - 'CriticalOvertoppingDischargeCoefficientOfVariation' REAL, - 'FailureProbabilityStructureWithErosion' REAL NOT NULL, - 'WidthFlowAperturesMean' REAL, - 'WidthFlowAperturesStandardDeviation' REAL, - 'StormDurationMean' REAL, - 'LevelCrestStructureMean' REAL, - 'LevelCrestStructureStandardDeviation' REAL, - 'DeviationWaveDirection' REAL, - '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, - 'ShouldIllustrationPointsBeCalculated' TINYINT (1) NOT NULL, -- true or false - 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 '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, - 'Y' REAL, - 'StructureNormalOrientation' REAL, - 'StorageStructureAreaMean' REAL, - 'StorageStructureAreaCoefficientOfVariation' REAL, - 'AllowedLevelIncreaseStorageMean' REAL, - 'AllowedLevelIncreaseStorageStandardDeviation' REAL, - 'WidthFlowAperturesMean' REAL, - 'WidthFlowAperturesStandardDeviation' REAL, - 'LevelCrestStructureNotClosingMean' REAL, - 'LevelCrestStructureNotClosingStandardDeviation' REAL, - 'InsideWaterLevelMean' REAL, - 'InsideWaterLevelStandardDeviation' REAL, - 'ThresholdHeightOpenWeirMean' REAL, - 'ThresholdHeightOpenWeirStandardDeviation' REAL, - 'AreaFlowAperturesMean' REAL, - 'AreaFlowAperturesStandardDeviation' REAL, - 'CriticalOvertoppingDischargeMean' REAL, - 'CriticalOvertoppingDischargeCoefficientOfVariation' REAL, - 'FlowWidthAtBottomProtectionMean' REAL, - 'FlowWidthAtBottomProtectionStandardDeviation' REAL, - 'ProbabilityOrFrequencyOpenStructureBeforeFlooding' REAL, - 'FailureProbabilityOpenStructure' REAL, - 'IdenticalApertures' INT (4) NOT NULL, - 'FailureProbabilityReparation' REAL, - '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, - 'HydraulicLocationEntityId' INTEGER, - 'ClosingStructureEntityId' INTEGER, - 'Order' INT (4) NOT NULL, - 'Name' VARCHAR (255), - 'Comments' TEXT, - 'UseBreakWater' TINYINT (1) NOT NULL, -- true or false - 'BreakWaterType' TINYINT (1) NOT NULL, -- Enum: 1 = Wall, 2 = Caisson, 3 = Dam - 'BreakWaterHeight' REAL, - 'UseForeshore' TINYINT (1) NOT NULL, -- true or false - 'Orientation' REAL, - 'StructureNormalOrientation' REAL, - 'StorageStructureAreaMean' REAL, - 'StorageStructureAreaCoefficientOfVariation' REAL, - 'AllowedLevelIncreaseStorageMean' REAL, - 'AllowedLevelIncreaseStorageStandardDeviation' REAL, - 'WidthFlowAperturesMean' REAL, - 'WidthFlowAperturesStandardDeviation' REAL, - 'LevelCrestStructureNotClosingMean' REAL, - 'LevelCrestStructureNotClosingStandardDeviation' REAL, - 'InsideWaterLevelMean' REAL, - 'InsideWaterLevelStandardDeviation' REAL, - 'ThresholdHeightOpenWeirMean' REAL, - 'ThresholdHeightOpenWeirStandardDeviation' REAL, - 'AreaFlowAperturesMean' REAL, - 'AreaFlowAperturesStandardDeviation' REAL, - 'CriticalOvertoppingDischargeMean' REAL, - 'CriticalOvertoppingDischargeCoefficientOfVariation' REAL, - 'FlowWidthAtBottomProtectionMean' REAL, - 'FlowWidthAtBottomProtectionStandardDeviation' REAL, - 'ProbabilityOrFrequencyOpenStructureBeforeFlooding' 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, - 'DrainCoefficientMean' REAL, - 'ModelFactorSuperCriticalFlowMean' REAL, - 'StormDurationMean' REAL, - 'FactorStormDurationOpenStructure' REAL, - 'ShouldIllustrationPointsBeCalculated' TINYINT (1) NOT NULL, -- true or false - 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, - 'RequiredProbability' REAL, - 'RequiredReliability' REAL, - 'Probability' REAL, - 'Reliability' REAL, - 'FactorOfSafety' REAL, - 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 '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, - 'Y' REAL, - 'StructureNormalOrientation' REAL, - 'StorageStructureAreaMean' REAL, - 'StorageStructureAreaCoefficientOfVariation' REAL, - 'AllowedLevelIncreaseStorageMean' REAL, - 'AllowedLevelIncreaseStorageStandardDeviation' REAL, - 'WidthFlowAperturesMean' REAL, - 'WidthFlowAperturesStandardDeviation' REAL, - 'InsideWaterLevelMean' REAL, - 'InsideWaterLevelStandardDeviation' REAL, - 'ThresholdHeightOpenWeirMean' REAL, - 'ThresholdHeightOpenWeirStandardDeviation' REAL, - 'CriticalOvertoppingDischargeMean' REAL, - 'CriticalOvertoppingDischargeCoefficientOfVariation' REAL, - 'FlowWidthAtBottomProtectionMean' REAL, - 'FlowWidthAtBottomProtectionStandardDeviation' REAL, - 'ConstructiveStrengthLinearLoadModelMean' REAL, - 'ConstructiveStrengthLinearLoadModelCoefficientOfVariation' REAL, - 'ConstructiveStrengthQuadraticLoadModelMean' REAL, - 'ConstructiveStrengthQuadraticLoadModelCoefficientOfVariation' REAL, - 'BankWidthMean' REAL, - 'BankWidthStandardDeviation' REAL, - 'InsideWaterLevelFailureConstructionMean' REAL, - 'InsideWaterLevelFailureConstructionStandardDeviation' REAL, - 'EvaluationLevel' REAL, - 'LevelCrestStructureMean' REAL, - 'LevelCrestStructureStandardDeviation' REAL, - 'VerticalDistance' REAL, - 'FailureProbabilityRepairClosure' REAL, - 'FailureCollisionEnergyMean' REAL, - 'FailureCollisionEnergyCoefficientOfVariation' REAL, - 'ShipMassMean' REAL, - 'ShipMassCoefficientOfVariation' REAL, - 'ShipVelocityMean' REAL, - 'ShipVelocityCoefficientOfVariation' REAL, - 'LevellingCount' INT (4) NOT NULL, - 'ProbabilityCollisionSecondaryStructure' REAL, - 'FlowVelocityStructureClosableMean' REAL, - 'StabilityLinearLoadModelMean' REAL, - 'StabilityLinearLoadModelCoefficientOfVariation' REAL, - 'StabilityQuadraticLoadModelMean' REAL, - 'StabilityQuadraticLoadModelCoefficientOfVariation' REAL, - 'AreaFlowAperturesMean' REAL, - 'AreaFlowAperturesStandardDeviation' REAL, - '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 'StabilityPointStructuresOutputEntity' -( - 'StabilityPointStructuresOutputEntity' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'StabilityPointStructuresCalculationEntityId' INTEGER NOT NULL, - 'GeneralResultFaultTreeIllustrationPointEntityId' INTEGER, - 'RequiredProbability' REAL, - 'RequiredReliability' REAL, - 'Probability' REAL, - 'Reliability' REAL, - 'FactorOfSafety' REAL, - 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 'HydraulicLocationOutputEntity' -( - 'HydraulicLocationEntityOutputId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'HydraulicLocationCalculationEntityId' INTEGER, - 'GeneralResultSubMechanismIllustrationPointEntityId' INTEGER, - 'Result' REAL, - 'TargetProbability' REAL, - 'TargetReliability' REAL, - 'CalculatedProbability' REAL, - 'CalculatedReliability' REAL, - '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 'GrassCoverErosionOutwardsHydraulicLocationOutputEntity' -( - 'GrassCoverErosionOutwardsHydraulicLocationOutputEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'GrassCoverErosionOutwardsHydraulicLocationEntityId' INTEGER NOT NULL, - 'GeneralResultSubMechanismIllustrationPointEntityId' INTEGER, - 'HydraulicLocationOutputType' TINYINT (1) NOT NULL, -- Enum: 1 = DesignWaterLevel, 2 = WaveHeight - 'Result' REAL, - 'TargetProbability' REAL, - 'TargetReliability' REAL, - 'CalculatedProbability' REAL, - 'CalculatedReliability' REAL, - 'CalculationConvergence' TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated, 2 = CalculatedNotConverged, 3 = CalculatedConverged - CONSTRAINT 'FK_GrassCoverErosionOutwardsHydraulicLocationOutputEntity_GeneralResultSubMechanismIllustrationPointEntity' FOREIGN KEY ('GeneralResultSubMechanismIllustrationPointEntityId') REFERENCES 'GeneralResultSubMechanismIllustrationPointEntity' ('GeneralResultSubMechanismIllustrationPointEntityId') ON DELETE Set Null ON UPDATE Cascade, - CONSTRAINT 'FK_GrassCoverErosionOutwardsHydraulicLocationOutputEntity_GrassCoverErosionOutwardsHydraulicLocationEntity' FOREIGN KEY ('GrassCoverErosionOutwardsHydraulicLocationEntityId') REFERENCES 'GrassCoverErosionOutwardsHydraulicLocationEntity' ('GrassCoverErosionOutwardsHydraulicLocationEntityId') ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT 'U_HydraulicLocationOutputType' UNIQUE ('GrassCoverErosionOutwardsHydraulicLocationEntityId','HydraulicLocationOutputType') -) -; - -CREATE TABLE 'DuneLocationEntity' -( - 'DuneLocationEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismEntityId' INTEGER NOT NULL, - 'LocationId' INTEGER NOT NULL, - 'Name' VARCHAR (260) NOT NULL, - 'LocationX' REAL, - 'LocationY' REAL, - 'CoastalAreaId' INT (4) NOT NULL, - 'Offset' REAL, - 'Orientation' REAL, - 'D50' REAL, - 'Order' INT (4) NOT NULL, - CONSTRAINT 'FK_DuneLocationEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade -) -; - -CREATE TABLE 'DuneLocationOutputEntity' -( - 'DuneLocationOutputEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'DuneLocationEntityId' INTEGER NOT NULL, - 'WaterLevel' REAL, - 'WaveHeight' REAL, - 'WavePeriod' REAL, - 'TargetProbability' REAL, - 'TargetReliability' REAL, - 'CalculatedProbability' REAL, - 'CalculatedReliability' REAL, - 'CalculationConvergence' TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated, 2 = CalculatedNotConverged, 3 = CalculatedConverged - CONSTRAINT 'FK_DuneLocationOutputEntity_DuneLocationEntity' FOREIGN KEY ('DuneLocationEntityId') REFERENCES 'DuneLocationEntity' ('DuneLocationEntityId') ON DELETE Cascade ON UPDATE Cascade -) -; - -CREATE TABLE 'BackgroundDataEntity' -( - 'BackgroundDataEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'AssessmentSectionEntityId' INTEGER NOT NULL, - 'Name' TEXT NOT NULL, - '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, - 'Value' TEXT NOT NULL, - 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 'GrassCoverErosionInwardsOvertoppingRateOutputEntity' -( - 'GrassCoverErosionInwardsOvertoppingRateOutputEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'GrassCoverErosionInwardsOutputEntityId' INTEGER NOT NULL, - 'GeneralResultFaultTreeIllustrationPointEntityId' INTEGER, - 'OvertoppingRate' REAL, - 'TargetProbability' REAL, - 'TargetReliability' REAL, - 'CalculatedProbability' REAL, - 'CalculatedReliability' REAL, - '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 'GeneralResultSubMechanismIllustrationPointEntity' -( - 'GeneralResultSubMechanismIllustrationPointEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'GoverningWindDirectionName' TEXT NOT NULL, - 'GoverningWindDirectionAngle' REAL NOT NULL -) -; - -CREATE TABLE 'SubMechanismIllustrationPointEntity' -( - 'SubMechanismIllustrationPointEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'Name' TEXT NOT NULL, - 'Beta' REAL NOT NULL, - 'Order' INT (4) NOT NULL -) -; - -CREATE TABLE 'IllustrationPointResultEntity' -( - 'IllustrationPointResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'SubMechanismIllustrationPointEntityId' INTEGER NOT NULL, - 'Description' TEXT NOT NULL, - '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 'StochastEntity' -( - 'StochastEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'Name' TEXT NOT NULL, - 'Duration' REAL NOT NULL, - 'Alpha' REAL NOT NULL, - 'Order' INT (4) 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 'GeneralResultFaultTreeIllustrationPointEntity' -( - 'GeneralResultFaultTreeIllustrationPointEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'GoverningWindDirectionName' TEXT NOT NULL, - 'GoverningWindDirectionAngle' REAL NOT NULL -) -; - -CREATE TABLE 'FaultTreeIllustrationPointEntity' -( - 'FaultTreeIllustrationPointEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'ParentFaultTreeIllustrationPointEntityId' INTEGER, - 'Name' TEXT NOT NULL, - '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 '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 'TopLevelSubMechanismIllustrationPointEntity' -( - 'TopLevelSubMechanismIllustrationPointEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'GeneralResultSubMechanismIllustrationPointEntityId' INTEGER NOT NULL, - 'SubMechanismIllustrationPointEntityId' INTEGER NOT NULL, - 'ClosingSituation' TEXT NOT NULL, - 'WindDirectionName' TEXT NOT NULL, - '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 'TopLevelFaultTreeIllustrationPointEntity' -( - 'TopLevelFaultTreeIllustrationPointEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FaultTreeIllustrationPointEntityId' INTEGER NOT NULL, - 'GeneralResultFaultTreeIllustrationPointEntityId' INTEGER NOT NULL, - 'ClosingSituation' TEXT NOT NULL, - 'WindDirectionName' TEXT NOT NULL, - '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 'SubMechanismIllustrationPointStochastEntity' -( - 'SubMechanismIllustrationPointStochastEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'SubMechanismIllustrationPointEntityId' INTEGER NOT NULL, - 'Name' TEXT NOT NULL, - '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 '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 'MacroStabilityInwardsCalculationEntity' -( - 'MacroStabilityInwardsCalculationEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'CalculationGroupEntityId' INTEGER NOT NULL, - 'SurfaceLineEntityId' INTEGER, - 'MacroStabilityInwardsStochasticSoilProfileEntityId' INTEGER, - 'HydraulicLocationEntityId' INTEGER, - 'Order' INT (4) NOT NULL, - 'Name' VARCHAR (260), - 'Comment' TEXT, - 'RelevantForScenario' TINYINT (1) NOT NULL, -- true or false - 'ScenarioContribution' REAL, - 'AssessmentLevel' REAL, - 'UseAssessmentLevelManualInput' TINYINT (1) NOT NULL, -- true or false - 'SlipPlaneMinimumDepth' REAL, - 'SlipPlaneMinimumLength' REAL, - 'MaximumSliceWidth' REAL, - '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, - 'TangentLineZBottom' REAL, - 'TangentLineNumber' INT (4) NOT NULL, - 'LeftGridXLeft' REAL, - 'LeftGridXRight' REAL, - 'LeftGridNrOfHorizontalPoints' INT (4) NOT NULL, - 'LeftGridZTop' REAL, - 'LeftGridZBottom' REAL, - 'LeftGridNrOfVerticalPoints' INT (4) NOT NULL, - 'RightGridXLeft' REAL, - 'RightGridXRight' REAL, - 'RightGridNrOfHorizontalPoints' INT (4) NOT NULL, - 'RightGridZTop' REAL, - 'RightGridZBottom' REAL, - 'RightGridNrOfVerticalPoints' INT (4) NOT NULL, - 'DikeSoilScenario' TINYINT (1) NOT NULL, -- Enumtype: 1 = ClayDikeOnClay, 2 = SandDikeOnClay, 3 = ClayDikeOnSand, 4 = SandDikeOnSand - 'WaterLevelRiverAverage' REAL, - 'DrainageConstructionPresent' TINYINT (1) NOT NULL, -- true or false - 'DrainageConstructionCoordinateX' REAL, - 'DrainageConstructionCoordinateZ' REAL, - 'MinimumLevelPhreaticLineAtDikeTopRiver' REAL, - 'MinimumLevelPhreaticLineAtDikeTopPolder' REAL, - 'AdjustPhreaticLine3And4ForUplift' TINYINT (1) NOT NULL, -- true or false - 'LeakageLengthOutwardsPhreaticLine3' REAL, - 'LeakageLengthInwardsPhreaticLine3' REAL, - 'LeakageLengthOutwardsPhreaticLine4' REAL, - 'LeakageLengthInwardsPhreaticLine4' REAL, - 'PiezometricHeadPhreaticLine2Outwards' REAL, - 'PiezometricHeadPhreaticLine2Inwards' REAL, - 'LocationInputExtremeWaterLevelPolder' REAL, - 'LocationInputExtremeUseDefaultOffsets' TINYINT (1) NOT NULL, -- true or false - 'LocationInputExtremePhreaticLineOffsetBelowDikeTopAtRiver' REAL, - 'LocationInputExtremePhreaticLineOffsetBelowDikeTopAtPolder' REAL, - 'LocationInputExtremePhreaticLineOffsetBelowShoulderBaseInside' REAL, - 'LocationInputExtremePhreaticLineOffsetDikeToeAtPolder' REAL, - 'LocationInputExtremePenetrationLength' REAL, - 'LocationInputDailyWaterLevelPolder' REAL, - 'LocationInputDailyUseDefaultOffsets' TINYINT (1) NOT NULL, -- true or false - 'LocationInputDailyPhreaticLineOffsetBelowDikeTopAtRiver' REAL, - 'LocationInputDailyPhreaticLineOffsetBelowDikeTopAtPolder' REAL, - 'LocationInputDailyPhreaticLineOffsetBelowShoulderBaseInside' REAL, - 'LocationInputDailyPhreaticLineOffsetDikeToeAtPolder' REAL, - 'CreateZones' TINYINT (1) NOT NULL, -- true or false - 'ZoningBoundariesDeterminationType' TINYINT (1) NOT NULL, -- Enumtype: 1 = Automatic 2 = Manual - 'ZoneBoundaryLeft' REAL, - 'ZoneBoundaryRight' REAL, - 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, - 'ZValue' REAL, - 'ForbiddenZonesXEntryMin' REAL, - 'ForbiddenZonesXEntryMax' REAL, - 'SlidingCurveLeftSlidingCircleCenterX' REAL, - 'SlidingCurveLeftSlidingCircleCenterY' REAL, - 'SlidingCurveLeftSlidingCircleRadius' REAL, - 'SlidingCurveLeftSlidingCircleIsActive' TINYINT (1) NOT NULL, -- true or false - 'SlidingCurveLeftSlidingCircleNonIteratedForce' REAL, - 'SlidingCurveLeftSlidingCircleIteratedForce' REAL, - 'SlidingCurveLeftSlidingCircleDrivingMoment' REAL, - 'SlidingCurveLeftSlidingCircleResistingMoment' REAL, - 'SlidingCurveRightSlidingCircleCenterX' REAL, - 'SlidingCurveRightSlidingCircleCenterY' REAL, - 'SlidingCurveRightSlidingCircleRadius' REAL, - 'SlidingCurveRightSlidingCircleIsActive' TINYINT (1) NOT NULL, -- true or false - 'SlidingCurveRightSlidingCircleNonIteratedForce' REAL, - 'SlidingCurveRightSlidingCircleIteratedForce' REAL, - 'SlidingCurveRightSlidingCircleDrivingMoment' REAL, - 'SlidingCurveRightSlidingCircleResistingMoment' REAL, - 'SlidingCurveNonIteratedHorizontalForce' REAL, - 'SlidingCurveIteratedHorizontalForce' REAL, - 'SlidingCurveSliceXML' TEXT NOT NULL, -- XML representation of MacroStabilityInwardsSlice - 'SlipPlaneLeftGridXLeft' REAL, - 'SlipPlaneLeftGridXRight' REAL, - 'SlipPlaneLeftGridNrOfHorizontalPoints' INT (4) NOT NULL, - 'SlipPlaneLeftGridZTop' REAL, - 'SlipPlaneLeftGridZBottom' REAL, - 'SlipPlaneLeftGridNrOfVerticalPoints' INT (4) NOT NULL, - 'SlipPlaneRightGridXLeft' REAL, - 'SlipPlaneRightGridXRight' REAL, - 'SlipPlaneRightGridNrOfHorizontalPoints' INT (4) NOT NULL, - 'SlipPlaneRightGridZTop' REAL, - 'SlipPlaneRightGridZBottom' REAL, - 'SlipPlaneRightGridNrOfVerticalPoints' INT (4) NOT NULL, - 'SlipPlaneTangentLinesXml' TEXT NOT NULL, -- 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, - 'Y' REAL, - 'Z' REAL, - CONSTRAINT 'FK_MacroStabilityInwardsCharacteristicPointEntity_SurfaceLineEntity' FOREIGN KEY ('SurfaceLineEntityId') REFERENCES 'SurfaceLineEntity' ('SurfaceLineEntityId') ON DELETE Cascade ON UPDATE Cascade -) -; - -CREATE TABLE 'MacroStabilityInwardsSoilLayerOneDEntity' -( - 'MacroStabilityInwardsSoilLayerOneDEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'MacroStabilityInwardsSoilProfileOneDEntityId' INTEGER NOT NULL, - 'Top' REAL, - 'IsAquifer' TINYINT (1) NOT NULL, -- true or false - 'Color' INTEGER, -- ARGB value of Color. - 'MaterialName' TEXT NOT NULL, - 'ShearStrengthModel' TINYINT (1) NOT NULL, -- Enumtype: 1 = SuCalculated, 2 = CPhi, 3 = CPhiOrSuCalculated - 'UsePop' TINYINT (1) NOT NULL, -- true of false - 'AbovePhreaticLevelMean' REAL, - 'AbovePhreaticLevelCoefficientOfVariation' REAL, - 'AbovePhreaticLevelShift' REAL, - 'BelowPhreaticLevelMean' REAL, - 'BelowPhreaticLevelCoefficientOfVariation' REAL, - 'BelowPhreaticLevelShift' REAL, - 'CohesionMean' REAL, - 'CohesionCoefficientOfVariation' REAL, - 'FrictionAngleMean' REAL, - 'FrictionAngleCoefficientOfVariation' REAL, - 'ShearStrengthRatioMean' REAL, - 'ShearStrengthRatioCoefficientOfVariation' REAL, - 'StrengthIncreaseExponentMean' REAL, - 'StrengthIncreaseExponentCoefficientOfVariation' REAL, - 'PopMean' REAL, - 'PopCoefficientOfVariation' REAL, - 'Order' INT (4) NOT NULL, - CONSTRAINT 'FK_MacroStabilityInwardsSoilLayerOneDEntity_MacroStabilityInwardsSoilProfileOneDEntity' FOREIGN KEY ('MacroStabilityInwardsSoilProfileOneDEntityId') REFERENCES 'MacroStabilityInwardsSoilProfileOneDEntity' ('MacroStabilityInwardsSoilProfileOneDEntityId') ON DELETE Cascade ON UPDATE Cascade -) -; - -CREATE TABLE 'MacroStabilityInwardsSoilProfileOneDEntity' -( - 'MacroStabilityInwardsSoilProfileOneDEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'Name' TEXT NOT NULL, - 'Bottom' REAL -) -; - -CREATE TABLE 'MacroStabilityInwardsSoilLayerTwoDEntity' -( - 'MacroStabilityInwardsSoilLayerTwoDEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'ParentMacroStabilityInwardsSoilLayerTwoDEntityId' INTEGER, - 'IsAquifer' TINYINT (1) NOT NULL, -- true or false - 'Color' INTEGER, -- ARGB value of Color. - 'MaterialName' TEXT NOT NULL, - 'ShearStrengthModel' TINYINT (1) NOT NULL, -- Enumtype: 1 = SuCalculated, 2 = CPhi, 3 = CPhiOrSuCalculated - 'UsePop' TINYINT (1) NOT NULL, -- true of false - 'AbovePhreaticLevelMean' REAL, - 'AbovePhreaticLevelCoefficientOfVariation' REAL, - 'AbovePhreaticLevelShift' REAL, - 'BelowPhreaticLevelMean' REAL, - 'BelowPhreaticLevelCoefficientOfVariation' REAL, - 'BelowPhreaticLevelShift' REAL, - 'CohesionMean' REAL, - 'CohesionCoefficientOfVariation' REAL, - 'FrictionAngleMean' REAL, - 'FrictionAngleCoefficientOfVariation' REAL, - 'ShearStrengthRatioMean' REAL, - 'ShearStrengthRatioCoefficientOfVariation' REAL, - 'StrengthIncreaseExponentMean' REAL, - 'StrengthIncreaseExponentCoefficientOfVariation' REAL, - 'PopMean' REAL, - 'PopCoefficientOfVariation' REAL, - 'OuterRingXml' TEXT NOT NULL, - 'Order' INT (4) NOT NULL, - CONSTRAINT 'FK_MacroStabilityInwardsSoilLayerTwoDEntity_MacroStabilityInwardsSoilLayerTwoDEntity' FOREIGN KEY ('ParentMacroStabilityInwardsSoilLayerTwoDEntityId') REFERENCES 'MacroStabilityInwardsSoilLayerTwoDEntity' ('MacroStabilityInwardsSoilLayerTwoDEntityId') ON DELETE Cascade ON UPDATE Cascade -) -; - -CREATE TABLE 'MacroStabilityInwardsSoilProfileTwoDEntity' -( - 'MacroStabilityInwardsSoilProfileTwoDEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'Name' TEXT NOT NULL -) -; - -CREATE TABLE 'MacroStabilityInwardsStochasticSoilProfileEntity' -( - 'MacroStabilityInwardsStochasticSoilProfileEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'StochasticSoilModelEntityId' INTEGER NOT NULL, - 'MacroStabilityInwardsSoilProfileOneDEntityId' INTEGER, - 'MacroStabilityInwardsSoilProfileTwoDEntityId' INTEGER, - '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 'MacroStabilityInwardsPreconsolidationStressEntity' -( - 'MacroStabilityInwardsPreconsolidationStressEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'MacroStabilityInwardsSoilProfileTwoDEntityId' INTEGER NOT NULL, - 'CoordinateX' REAL NOT NULL, - 'CoordinateZ' REAL NOT NULL, - 'PreconsolidationStressMean' REAL, - 'PreconsolidationStressCoefficientOfVariation' REAL, - 'Order' INT (4) NOT NULL, - CONSTRAINT 'FK_MacroStabilityInwardsPreconsolidationStressEntity_MacroStabilityInwardsSoilProfileTwoDEntity' FOREIGN KEY ('MacroStabilityInwardsSoilProfileTwoDEntityId') REFERENCES 'MacroStabilityInwardsSoilProfileTwoDEntity' ('MacroStabilityInwardsSoilProfileTwoDEntityId') ON DELETE Cascade ON UPDATE Cascade -) -; - -CREATE TABLE 'MacroStabilityInwardsSemiProbabilisticOutputEntity' -( - 'MacroStabilityInwardsSemiProbabilisticOutputEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'MacroStabilityInwardsCalculationEntityId' INTEGER NOT NULL, - 'FactorOfStability' REAL, - 'RequiredProbability' REAL, - 'RequiredReliability' REAL, - 'MacroStabilityInwardsProbability' REAL, - 'MacroStabilityInwardsReliability' REAL, - 'MacroStabilityInwardsFactorOfSafety' REAL, - CONSTRAINT 'FK_MacroStabilityInwardsSemiProbabilisticOutputEntity_MacroStabilityInwardsCalculationEntity' FOREIGN KEY ('MacroStabilityInwardsCalculationEntityId') REFERENCES 'MacroStabilityInwardsCalculationEntity' ('MacroStabilityInwardsCalculationEntityId') ON DELETE Cascade ON UPDATE Cascade -) -; - -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 'HydraRingPreprocessorEntity' -( - 'HydraRingPreprocessorEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'AssessmentSectionEntityId' INTEGER NOT NULL, - 'UsePreprocessor' TINYINT (1) NOT NULL, - 'PreprocessorDirectory' TEXT NOT NULL, - CONSTRAINT 'FK_HydraRingPreprocessorEntity_AssessmentSectionEntity' FOREIGN KEY ('AssessmentSectionEntityId') REFERENCES 'AssessmentSectionEntity' ('AssessmentSectionEntityId') ON DELETE Cascade ON UPDATE Cascade -) -; - -CREATE TABLE 'HydraulicLocationCalculationEntity' -( - 'HydraulicLocationCalculationEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'ShouldIllustrationPointsBeCalculated' TINYINT (1) NOT NULL -- True or false -) -; - -/* Create Indexes and Triggers */ - -CREATE INDEX 'IXFK_GrassCoverErosionInwardsDikeHeightOutputEntity_GeneralResultFaultTreeIllustrationPointEntity' - ON 'GrassCoverErosionInwardsDikeHeightOutputEntity' ('GeneralResultFaultTreeIllustrationPointEntityId' ASC) -; - -CREATE INDEX 'IXFK_GrassCoverErosionInwardsDikeHeightOutputEntity_GrassCoverErosionInwardsOutputEntity' - ON 'GrassCoverErosionInwardsDikeHeightOutputEntity' ('GrassCoverErosionInwardsOutputEntityId' ASC) -; +/* ---------------------------------------------------- */ +/* Generated by Enterprise Architect Version 12.0 */ +/* Created On : 25-Jan-2018 14:43:24 */ +/* DBMS : SQLite */ +/* ---------------------------------------------------- */ + +/* Drop Tables */ + +DROP TABLE IF EXISTS 'VersionEntity' +; + +DROP TABLE IF EXISTS 'GrassCoverErosionInwardsDikeHeightOutputEntity' +; + +DROP TABLE IF EXISTS 'ProjectEntity' +; + +DROP TABLE IF EXISTS 'MacroStabilityInwardsFailureMechanismMetaEntity' +; + +DROP TABLE IF EXISTS 'AssessmentSectionEntity' +; + +DROP TABLE IF EXISTS 'FailureMechanismSectionEntity' +; + +DROP TABLE IF EXISTS 'StabilityPointStructuresCalculationEntity' +; + +DROP TABLE IF EXISTS 'FailureMechanismEntity' +; + +DROP TABLE IF EXISTS 'PipingFailureMechanismMetaEntity' +; + +DROP TABLE IF EXISTS 'ClosingStructuresFailureMechanismMetaEntity' +; + +DROP TABLE IF EXISTS 'StabilityStoneCoverFailureMechanismMetaEntity' +; + +DROP TABLE IF EXISTS 'CalculationGroupEntity' +; + +DROP TABLE IF EXISTS 'StabilityPointStructuresFailureMechanismMetaEntity' +; + +DROP TABLE IF EXISTS 'HydraulicLocationEntity' +; + +DROP TABLE IF EXISTS 'PipingCalculationEntity' +; + +DROP TABLE IF EXISTS 'GrassCoverErosionInwardsFailureMechanismMetaEntity' +; + +DROP TABLE IF EXISTS 'DuneErosionFailureMechanismMetaEntity' +; + +DROP TABLE IF EXISTS 'GrassCoverErosionInwardsCalculationEntity' +; + +DROP TABLE IF EXISTS 'HeightStructuresFailureMechanismMetaEntity' +; + +DROP TABLE IF EXISTS 'GrassCoverErosionOutwardsFailureMechanismMetaEntity' +; + +DROP TABLE IF EXISTS 'PipingSoilLayerEntity' +; + +DROP TABLE IF EXISTS 'PipingSoilProfileEntity' +; + +DROP TABLE IF EXISTS 'PipingStochasticSoilProfileEntity' +; + +DROP TABLE IF EXISTS 'StochasticSoilModelEntity' +; + +DROP TABLE IF EXISTS 'SurfaceLineEntity' +; + +DROP TABLE IF EXISTS 'PipingCharacteristicPointEntity' +; + +DROP TABLE IF EXISTS 'PipingCalculationOutputEntity' +; + +DROP TABLE IF EXISTS 'PipingSemiProbabilisticOutputEntity' +; + +DROP TABLE IF EXISTS 'PipingSectionResultEntity' +; + +DROP TABLE IF EXISTS 'GrassCoverErosionInwardsSectionResultEntity' +; + +DROP TABLE IF EXISTS 'HeightStructuresSectionResultEntity' +; + +DROP TABLE IF EXISTS 'StrengthStabilityLengthwiseConstructionSectionResultEntity' +; + +DROP TABLE IF EXISTS 'TechnicalInnovationSectionResultEntity' +; + +DROP TABLE IF EXISTS 'WaterPressureAsphaltCoverSectionResultEntity' +; + +DROP TABLE IF EXISTS 'ClosingStructuresSectionResultEntity' +; + +DROP TABLE IF EXISTS 'GrassCoverErosionOutwardsSectionResultEntity' +; + +DROP TABLE IF EXISTS 'GrassCoverSlipOffInwardsSectionResultEntity' +; + +DROP TABLE IF EXISTS 'GrassCoverSlipOffOutwardsSectionResultEntity' +; + +DROP TABLE IF EXISTS 'MacroStabilityInwardsSectionResultEntity' +; + +DROP TABLE IF EXISTS 'MacrostabilityOutwardsSectionResultEntity' +; + +DROP TABLE IF EXISTS 'WaveImpactAsphaltCoverSectionResultEntity' +; + +DROP TABLE IF EXISTS 'WaveImpactAsphaltCoverFailureMechanismMetaEntity' +; + +DROP TABLE IF EXISTS 'MicrostabilitySectionResultEntity' +; + +DROP TABLE IF EXISTS 'PipingStructureSectionResultEntity' +; + +DROP TABLE IF EXISTS 'DuneErosionSectionResultEntity' +; + +DROP TABLE IF EXISTS 'StabilityStoneCoverSectionResultEntity' +; + +DROP TABLE IF EXISTS 'StabilityPointStructuresSectionResultEntity' +; + +DROP TABLE IF EXISTS 'DikeProfileEntity' +; + +DROP TABLE IF EXISTS 'GrassCoverErosionInwardsOutputEntity' +; + +DROP TABLE IF EXISTS 'ForeshoreProfileEntity' +; + +DROP TABLE IF EXISTS 'StabilityStoneCoverWaveConditionsCalculationEntity' +; + +DROP TABLE IF EXISTS 'StabilityStoneCoverWaveConditionsOutputEntity' +; + +DROP TABLE IF EXISTS 'WaveImpactAsphaltCoverWaveConditionsCalculationEntity' +; + +DROP TABLE IF EXISTS 'WaveImpactAsphaltCoverWaveConditionsOutputEntity' +; + +DROP TABLE IF EXISTS 'GrassCoverErosionOutwardsWaveConditionsCalculationEntity' +; + +DROP TABLE IF EXISTS 'GrassCoverErosionOutwardsHydraulicLocationEntity' +; + +DROP TABLE IF EXISTS 'GrassCoverErosionOutwardsWaveConditionsOutputEntity' +; + +DROP TABLE IF EXISTS 'HeightStructuresOutputEntity' +; + +DROP TABLE IF EXISTS 'HeightStructureEntity' +; + +DROP TABLE IF EXISTS 'HeightStructuresCalculationEntity' +; + +DROP TABLE IF EXISTS 'ClosingStructureEntity' +; + +DROP TABLE IF EXISTS 'ClosingStructuresCalculationEntity' +; + +DROP TABLE IF EXISTS 'ClosingStructuresOutputEntity' +; + +DROP TABLE IF EXISTS 'StabilityPointStructureEntity' +; + +DROP TABLE IF EXISTS 'StabilityPointStructuresOutputEntity' +; + +DROP TABLE IF EXISTS 'HydraulicLocationOutputEntity' +; + +DROP TABLE IF EXISTS 'GrassCoverErosionOutwardsHydraulicLocationOutputEntity' +; + +DROP TABLE IF EXISTS 'DuneLocationEntity' +; + +DROP TABLE IF EXISTS 'DuneLocationOutputEntity' +; + +DROP TABLE IF EXISTS 'BackgroundDataEntity' +; + +DROP TABLE IF EXISTS 'BackgroundDataMetaEntity' +; + +DROP TABLE IF EXISTS 'GrassCoverErosionInwardsOvertoppingRateOutputEntity' +; + +DROP TABLE IF EXISTS 'GeneralResultSubMechanismIllustrationPointEntity' +; + +DROP TABLE IF EXISTS 'SubMechanismIllustrationPointEntity' +; + +DROP TABLE IF EXISTS 'IllustrationPointResultEntity' +; + +DROP TABLE IF EXISTS 'StochastEntity' +; + +DROP TABLE IF EXISTS 'GeneralResultSubMechanismIllustrationPointStochastEntity' +; + +DROP TABLE IF EXISTS 'GeneralResultFaultTreeIllustrationPointEntity' +; + +DROP TABLE IF EXISTS 'FaultTreeIllustrationPointEntity' +; + +DROP TABLE IF EXISTS 'FaultTreeIllustrationPointStochastEntity' +; + +DROP TABLE IF EXISTS 'GeneralResultFaultTreeIllustrationPointStochastEntity' +; + +DROP TABLE IF EXISTS 'TopLevelSubMechanismIllustrationPointEntity' +; + +DROP TABLE IF EXISTS 'TopLevelFaultTreeIllustrationPointEntity' +; + +DROP TABLE IF EXISTS 'SubMechanismIllustrationPointStochastEntity' +; + +DROP TABLE IF EXISTS 'FaultTreeSubmechanismIllustrationPointEntity' +; + +DROP TABLE IF EXISTS 'MacroStabilityInwardsCalculationEntity' +; + +DROP TABLE IF EXISTS 'MacroStabilityInwardsCalculationOutputEntity' +; + +DROP TABLE IF EXISTS 'MacroStabilityInwardsCharacteristicPointEntity' +; + +DROP TABLE IF EXISTS 'MacroStabilityInwardsSoilLayerOneDEntity' +; + +DROP TABLE IF EXISTS 'MacroStabilityInwardsSoilProfileOneDEntity' +; + +DROP TABLE IF EXISTS 'MacroStabilityInwardsSoilLayerTwoDEntity' +; + +DROP TABLE IF EXISTS 'MacroStabilityInwardsSoilProfileTwoDEntity' +; + +DROP TABLE IF EXISTS 'MacroStabilityInwardsStochasticSoilProfileEntity' +; + +DROP TABLE IF EXISTS 'MacroStabilityInwardsPreconsolidationStressEntity' +; + +DROP TABLE IF EXISTS 'MacroStabilityInwardsSemiProbabilisticOutputEntity' +; + +DROP TABLE IF EXISTS 'MacroStabilityInwardsSoilProfileTwoDSoilLayerTwoDEntity' +; + +DROP TABLE IF EXISTS 'HydraRingPreprocessorEntity' +; + +DROP TABLE IF EXISTS 'HydraulicLocationCalculationEntity' +; + +/* 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 'GrassCoverErosionInwardsDikeHeightOutputEntity' +( + 'GrassCoverErosionInwardsDikeHeightOutputEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'GrassCoverErosionInwardsOutputEntityId' INTEGER NOT NULL, + 'GeneralResultFaultTreeIllustrationPointEntityId' INTEGER, + 'DikeHeight' REAL, + 'TargetProbability' REAL, + 'TargetReliability' REAL, + 'CalculatedProbability' REAL, + 'CalculatedReliability' REAL, + '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 'ProjectEntity' +( + 'ProjectEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'Description' VARCHAR (260) +) +; + +CREATE TABLE 'MacroStabilityInwardsFailureMechanismMetaEntity' +( + 'MacroStabilityInwardsFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'FailureMechanismEntityId' INTEGER NOT NULL, + 'A' REAL NOT NULL, + 'StochasticSoilModelCollectionSourcePath' TEXT, + 'SurfaceLineCollectionSourcePath' TEXT, + CONSTRAINT 'FK_MacroStabilityInwardsFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade +) +; + +CREATE TABLE 'AssessmentSectionEntity' +( + 'AssessmentSectionEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'ProjectEntityId' INTEGER NOT NULL, + 'Id' TEXT, + 'Name' VARCHAR (260), + 'Comments' TEXT, + 'LowerLimitNorm' REAL NOT NULL, + 'SignalingNorm' REAL NOT NULL, + 'NormativeNormType' TINYINT (1) NOT NULL, -- EnumType: 1 = LowerLimit, 2 = Signaling + 'HydraulicDatabaseVersion' TEXT, + 'HydraulicDatabaseLocation' TEXT, + 'Composition' TINYINT (1) NOT NULL, -- Enum: 1 = Dike, 2 = Dune, 3 = DikeAndDune + 'ReferenceLinePointXml' TEXT, + 'Order' INT (4) NOT NULL, + CONSTRAINT 'FK_AssessmentSectionEntity_ProjectEntity' FOREIGN KEY ('ProjectEntityId') REFERENCES 'ProjectEntity' ('ProjectEntityId') ON DELETE Cascade ON UPDATE Cascade +) +; + +CREATE TABLE 'FailureMechanismSectionEntity' +( + 'FailureMechanismSectionEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'FailureMechanismEntityId' INTEGER NOT NULL, + 'Name' VARCHAR (260) NOT NULL, + 'FailureMechanismSectionPointXml' TEXT NOT NULL, + CONSTRAINT 'FK_FailureMechanismSectionEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade +) +; + +CREATE TABLE 'StabilityPointStructuresCalculationEntity' +( + 'StabilityPointStructuresCalculationEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'CalculationGroupEntityId' INTEGER NOT NULL, + 'ForeshoreProfileEntityId' INTEGER, + 'HydraulicLocationEntityId' INTEGER, + 'StabilityPointStructureEntityId' INTEGER, + 'Order' INT (4) NOT NULL, + 'Name' VARCHAR (260), + 'Comments' TEXT, + 'UseBreakWater' TINYINT (1) NOT NULL, -- true or false + 'BreakWaterType' TINYINT (1) NOT NULL, -- Enum: 1 = Wall, 2 = Caisson, 3 = Dam + 'BreakWaterHeight' REAL, + 'UseForeshore' TINYINT (1) NOT NULL, -- true or false + 'StructureNormalOrientation' REAL, + 'StorageStructureAreaMean' REAL, + 'StorageStructureAreaCoefficientOfVariation' REAL, + 'AllowedLevelIncreaseStorageMean' REAL, + 'AllowedLevelIncreaseStorageStandardDeviation' REAL, + 'WidthFlowAperturesMean' REAL, + 'WidthFlowAperturesStandardDeviation' REAL, + 'InsideWaterLevelMean' REAL, + 'InsideWaterLevelStandardDeviation' REAL, + 'ThresholdHeightOpenWeirMean' REAL, + 'ThresholdHeightOpenWeirStandardDeviation' REAL, + 'CriticalOvertoppingDischargeMean' REAL, + 'CriticalOvertoppingDischargeCoefficientOfVariation' REAL, + 'FlowWidthAtBottomProtectionMean' REAL, + 'FlowWidthAtBottomProtectionStandardDeviation' REAL, + 'ConstructiveStrengthLinearLoadModelMean' REAL, + 'ConstructiveStrengthLinearLoadModelCoefficientOfVariation' REAL, + 'ConstructiveStrengthQuadraticLoadModelMean' REAL, + 'ConstructiveStrengthQuadraticLoadModelCoefficientOfVariation' REAL, + 'BankWidthMean' REAL, + 'BankWidthStandardDeviation' REAL, + 'InsideWaterLevelFailureConstructionMean' REAL, + 'InsideWaterLevelFailureConstructionStandardDeviation' REAL, + 'EvaluationLevel' REAL, + 'LevelCrestStructureMean' REAL, + 'LevelCrestStructureStandardDeviation' REAL, + 'VerticalDistance' REAL, + 'FailureProbabilityRepairClosure' REAL NOT NULL, + 'FailureCollisionEnergyMean' REAL, + 'FailureCollisionEnergyCoefficientOfVariation' REAL, + 'ShipMassMean' REAL, + 'ShipMassCoefficientOfVariation' REAL, + 'ShipVelocityMean' REAL, + 'ShipVelocityCoefficientOfVariation' REAL, + 'LevellingCount' INT (4) NOT NULL, + 'ProbabilityCollisionSecondaryStructure' REAL NOT NULL, + 'FlowVelocityStructureClosableMean' REAL, + 'StabilityLinearLoadModelMean' REAL, + 'StabilityLinearLoadModelCoefficientOfVariation' REAL, + 'StabilityQuadraticLoadModelMean' REAL, + 'StabilityQuadraticLoadModelCoefficientOfVariation' REAL, + 'AreaFlowAperturesMean' REAL, + 'AreaFlowAperturesStandardDeviation' REAL, + 'InflowModelType' TINYINT (1) NOT NULL, -- Enum: 1 = VerticalWall, 2 = LowSill, 3 = FloodedCulvert + 'LoadSchematizationType' TINYINT (1) NOT NULL, -- Enum: 1 = Linear, 2 = Quadratic + 'VolumicWeightWater' REAL, + 'StormDurationMean' REAL, + 'ModelFactorSuperCriticalFlowMean' REAL, + 'FactorStormDurationOpenStructure' REAL, + 'DrainCoefficientMean' REAL, + 'FailureProbabilityStructureWithErosion' REAL NOT NULL, + 'ShouldIllustrationPointsBeCalculated' TINYINT (1) NOT NULL, -- true or false + 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 'FailureMechanismEntity' +( + 'FailureMechanismEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'AssessmentSectionEntityId' INTEGER NOT NULL, + 'CalculationGroupEntityId' INTEGER, + '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 = Macrostabiliteit buitenwaarts, 14 = Microstabiliteit, 15 = Wateroverdruk bij asfaltbekleding, 16 = Grasbekleding afschuiven binnentalud, 17 = Sterkte en stabiliteit langsconstructires, 18 = Technische innovaties + 'IsRelevant' TINYINT (1) NOT NULL, -- true or false + 'InputComments' TEXT, + 'OutputComments' TEXT, + 'NotRelevantComments' TEXT, + 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 'PipingFailureMechanismMetaEntity' +( + 'PipingFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'FailureMechanismEntityId' INTEGER NOT NULL, + 'A' REAL NOT NULL, + 'WaterVolumetricWeight' REAL NOT NULL, + 'StochasticSoilModelCollectionSourcePath' TEXT, + 'SurfaceLineCollectionSourcePath' TEXT, + CONSTRAINT 'FK_PipingFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade +) +; + +CREATE TABLE 'ClosingStructuresFailureMechanismMetaEntity' +( + 'ClosingStructuresFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'FailureMechanismEntityId' INTEGER NOT NULL, + 'N2A' INT (4) NOT NULL, + 'ClosingStructureCollectionSourcePath' TEXT, + 'ForeshoreProfileCollectionSourcePath' TEXT, + CONSTRAINT 'FK_ClosingStructuresFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade +) +; + +CREATE TABLE 'StabilityStoneCoverFailureMechanismMetaEntity' +( + 'StabilityStoneCoverFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'FailureMechanismEntityId' INTEGER NOT NULL, + 'ForeshoreProfileCollectionSourcePath' TEXT, + 'N' REAL NOT NULL, + CONSTRAINT 'FK_StabilityStoneCoverFailureMechanismMetaEntity_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, + 'Name' VARCHAR (260), + 'Order' INT (4) NOT NULL, + CONSTRAINT 'FK_CalculationGroupEntity_CalculationGroupEntity' FOREIGN KEY ('ParentCalculationGroupEntityId') REFERENCES 'CalculationGroupEntity' ('CalculationGroupEntityId') ON DELETE Cascade ON UPDATE Cascade +) +; + +CREATE TABLE 'StabilityPointStructuresFailureMechanismMetaEntity' +( + 'StabilityPointStructuresFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'FailureMechanismEntityId' INTEGER NOT NULL, + 'N' INT (4) NOT NULL, + 'ForeshoreProfileCollectionSourcePath' TEXT, + 'StabilityPointStructureCollectionSourcePath' TEXT, + CONSTRAINT 'FK_StrengthStabilityPointConstructionFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade +) +; + +CREATE TABLE 'HydraulicLocationEntity' +( + 'HydraulicLocationEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'AssessmentSectionEntityId' INTEGER NOT NULL, + 'HydraulicLocationCalculationEntity1Id' INTEGER NOT NULL, + 'HydraulicLocationCalculationEntity2Id' INTEGER NOT NULL, + 'HydraulicLocationCalculationEntity3Id' INTEGER NOT NULL, + 'HydraulicLocationCalculationEntity4Id' INTEGER NOT NULL, + 'HydraulicLocationCalculationEntity5Id' INTEGER NOT NULL, + 'HydraulicLocationCalculationEntity6Id' INTEGER NOT NULL, + 'HydraulicLocationCalculationEntity7Id' INTEGER NOT NULL, + 'HydraulicLocationCalculationEntity8Id' INTEGER NOT NULL, + 'LocationId' INTEGER NOT NULL, + 'Name' VARCHAR (260) NOT NULL, + 'LocationX' REAL, + 'LocationY' REAL, + 'Order' INT (4) NOT NULL, + CONSTRAINT 'FK_HydraulicLocationEntity_AssessmentSectionEntity' FOREIGN KEY ('AssessmentSectionEntityId') REFERENCES 'AssessmentSectionEntity' ('AssessmentSectionEntityId') ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT 'FK_HydraulicLocationEntity_HydraulicLocationCalculationEntity1' FOREIGN KEY ('HydraulicLocationCalculationEntity1Id') REFERENCES 'HydraulicLocationCalculationEntity' ('HydraulicLocationCalculationEntityId') ON DELETE No Action ON UPDATE Cascade, + CONSTRAINT 'FK_HydraulicLocationEntity_HydraulicLocationCalculationEntity2' FOREIGN KEY ('HydraulicLocationCalculationEntity2Id') REFERENCES 'HydraulicLocationCalculationEntity' ('HydraulicLocationCalculationEntityId') ON DELETE No Action ON UPDATE Cascade, + CONSTRAINT 'FK_HydraulicLocationEntity_HydraulicLocationCalculationEntity3' FOREIGN KEY ('HydraulicLocationCalculationEntity3Id') REFERENCES 'HydraulicLocationCalculationEntity' ('HydraulicLocationCalculationEntityId') ON DELETE No Action ON UPDATE Cascade, + CONSTRAINT 'FK_HydraulicLocationEntity_HydraulicLocationCalculationEntity4' FOREIGN KEY ('HydraulicLocationCalculationEntity4Id') REFERENCES 'HydraulicLocationCalculationEntity' ('HydraulicLocationCalculationEntityId') ON DELETE No Action ON UPDATE Cascade, + CONSTRAINT 'FK_HydraulicLocationEntity_HydraulicLocationCalculationEntity5' FOREIGN KEY ('HydraulicLocationCalculationEntity5Id') REFERENCES 'HydraulicLocationCalculationEntity' ('HydraulicLocationCalculationEntityId') ON DELETE No Action ON UPDATE Cascade, + CONSTRAINT 'FK_HydraulicLocationEntity_HydraulicLocationCalculationEntity6' FOREIGN KEY ('HydraulicLocationCalculationEntity6Id') REFERENCES 'HydraulicLocationCalculationEntity' ('HydraulicLocationCalculationEntityId') ON DELETE No Action ON UPDATE Cascade, + CONSTRAINT 'FK_HydraulicLocationEntity_HydraulicLocationCalculationEntity7' FOREIGN KEY ('HydraulicLocationCalculationEntity7Id') REFERENCES 'HydraulicLocationCalculationEntity' ('HydraulicLocationCalculationEntityId') ON DELETE No Action ON UPDATE Cascade, + CONSTRAINT 'FK_HydraulicLocationEntity_HydraulicLocationCalculationEntity8' FOREIGN KEY ('HydraulicLocationCalculationEntity8Id') REFERENCES 'HydraulicLocationCalculationEntity' ('HydraulicLocationCalculationEntityId') ON DELETE No Action ON UPDATE Cascade, + CONSTRAINT 'U_HydraulicLocationCalculationEntity_HydraulicLocationCalculation2Id' UNIQUE ('HydraulicLocationCalculationEntity2Id'), + CONSTRAINT 'U_HydraulicLocationCalculationEntity_HydraulicLocationCalculation4Id' UNIQUE ('HydraulicLocationCalculationEntity4Id'), + CONSTRAINT 'U_HydraulicLocationCalculationEntity_HydraulicLocationCalculation3Id' UNIQUE ('HydraulicLocationCalculationEntity3Id'), + CONSTRAINT 'U_HydraulicLocationCalculationEntity_HydraulicLocationCalculation1Id' UNIQUE ('HydraulicLocationCalculationEntity1Id'), + CONSTRAINT 'U_HydraulicLocationCalculationEntity_HydraulicLocationCalculation6Id' UNIQUE ('HydraulicLocationCalculationEntity6Id'), + CONSTRAINT 'U_HydraulicLocationCalculationEntity_HydraulicLocationCalculation8Id' UNIQUE ('HydraulicLocationCalculationEntity8Id'), + CONSTRAINT 'U_HydraulicLocationCalculationEntity_HydraulicLocationCalculation7Id' UNIQUE ('HydraulicLocationCalculationEntity7Id'), + CONSTRAINT 'U_HydraulicLocationCalculationEntity_HydraulicLocationCalculation5Id' UNIQUE ('HydraulicLocationCalculationEntity5Id') +) +; + +CREATE TABLE 'PipingCalculationEntity' +( + 'PipingCalculationEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'CalculationGroupEntityId' INTEGER NOT NULL, + 'SurfaceLineEntityId' INTEGER, + 'PipingStochasticSoilProfileEntityId' INTEGER, + 'HydraulicLocationEntityId' INTEGER, + 'Order' INT (4) NOT NULL, + 'Name' VARCHAR (260), + 'Comments' TEXT, + 'EntryPointL' REAL, + 'ExitPointL' REAL, + 'PhreaticLevelExitMean' REAL, + 'PhreaticLevelExitStandardDeviation' REAL, + 'DampingFactorExitMean' REAL, + 'DampingFactorExitStandardDeviation' REAL, + 'RelevantForScenario' TINYINT (1) NOT NULL, -- true or false + 'ScenarioContribution' REAL, + 'AssessmentLevel' REAL, + 'UseAssessmentLevelManualInput' TINYINT (1) NOT NULL, -- true or false + CONSTRAINT 'FK_PipingCalculationEntity_CalculationGroupEntity' FOREIGN KEY ('CalculationGroupEntityId') REFERENCES 'CalculationGroupEntity' ('CalculationGroupEntityId') ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT 'FK_PipingCalculationEntity_HydraulicLocationEntity' FOREIGN KEY ('HydraulicLocationEntityId') REFERENCES 'HydraulicLocationEntity' ('HydraulicLocationEntityId') ON DELETE Set Null ON UPDATE Cascade, + CONSTRAINT 'FK_PipingCalculationEntity_PipingStochasticSoilProfileEntity' FOREIGN KEY ('PipingStochasticSoilProfileEntityId') REFERENCES 'PipingStochasticSoilProfileEntity' ('PipingStochasticSoilProfileEntityId') ON DELETE Set Null ON UPDATE Cascade, + CONSTRAINT 'FK_PipingCalculationEntity_SurfaceLineEntity' FOREIGN KEY ('SurfaceLineEntityId') REFERENCES 'SurfaceLineEntity' ('SurfaceLineEntityId') ON DELETE Set Null ON UPDATE Cascade +) +; + +CREATE TABLE 'GrassCoverErosionInwardsFailureMechanismMetaEntity' +( + 'GrassCoverErosionInwardsFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'FailureMechanismEntityId' INTEGER NOT NULL, + 'N' INT (4) NOT NULL, + 'DikeProfileCollectionSourcePath' TEXT, + CONSTRAINT 'FK_GrassCoverErosionInwardsFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade +) +; + +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 'GrassCoverErosionInwardsCalculationEntity' +( + 'GrassCoverErosionInwardsCalculationEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'CalculationGroupEntityId' INTEGER NOT NULL, + 'HydraulicLocationEntityId' INTEGER, + 'DikeProfileEntityId' INTEGER, + 'Order' INT (4) NOT NULL, + 'Name' VARCHAR (260), + 'Comments' TEXT, + 'Orientation' REAL, + 'CriticalFlowRateMean' REAL, + 'CriticalFlowRateStandardDeviation' REAL, + 'UseForeshore' TINYINT (1) NOT NULL, -- true or false + 'DikeHeightCalculationType' TINYINT (1) NOT NULL, -- Enum: 1 = NoCalculation, 2 = CalculateByAssessmentSectionNorm, 3 = CalculateByProfileSpecificRequiredProbability + 'DikeHeight' REAL, + 'UseBreakWater' TINYINT (1) NOT NULL, -- true or false + 'BreakWaterType' TINYINT (1) NOT NULL, -- Enum: 1 = Wall, 2 = Caisson, 3 = Dam + 'BreakWaterHeight' REAL, + 'OvertoppingRateCalculationType' TINYINT (1) NOT NULL, -- Enum: 1 = NoCalculation, 2 = CalculateByAssessmentSectionNorm, 3 = CalculateByProfileSpecificRequiredProbability + 'ShouldDikeHeightIllustrationPointsBeCalculated' TINYINT (1) NOT NULL, -- true or false + 'ShouldOvertoppingRateIllustrationPointsBeCalculated' TINYINT (1) NOT NULL, -- true or false + 'ShouldOvertoppingOutputIllustrationPointsBeCalculated' TINYINT (1) NOT NULL, -- true or false + 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 'HeightStructuresFailureMechanismMetaEntity' +( + 'HeightStructuresFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'FailureMechanismEntityId' INTEGER NOT NULL, + 'N' INT (4) NOT NULL, + 'HeightStructureCollectionSourcePath' TEXT, + 'ForeshoreProfileCollectionSourcePath' TEXT, + CONSTRAINT 'FK_HeightStructuresFailureMechanismMetaEntity_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' INT (4) NOT NULL, + 'ForeshoreProfileCollectionSourcePath' TEXT, + 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, + 'IsAquifer' TINYINT (1) NOT NULL, -- true or false + 'Color' INTEGER, -- ARGB value of Color. + 'MaterialName' TEXT NOT NULL, + 'BelowPhreaticLevelMean' REAL, + 'BelowPhreaticLevelDeviation' REAL, + 'BelowPhreaticLevelShift' REAL, + 'DiameterD70Mean' REAL, + 'DiameterD70CoefficientOfVariation' REAL, + 'PermeabilityMean' REAL, + 'PermeabilityCoefficientOfVariation' REAL, + '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, + 'Name' TEXT NOT NULL, + '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 'StochasticSoilModelEntity' +( + 'StochasticSoilModelEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'FailureMechanismEntityId' INTEGER NOT NULL, + 'Name' TEXT NOT NULL, + 'StochasticSoilModelSegmentPointXml' TEXT NOT NULL, + '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, + 'ReferenceLineIntersectionY' REAL, + 'PointsXml' TEXT NOT NULL, + '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, + 'Y' REAL, + 'Z' REAL, + CONSTRAINT 'FK_SurfaceLinePointEntity_SurfaceLineEntity' FOREIGN KEY ('SurfaceLineEntityId') REFERENCES 'SurfaceLineEntity' ('SurfaceLineEntityId') ON DELETE Cascade ON UPDATE Cascade +) +; + +CREATE TABLE 'PipingCalculationOutputEntity' +( + 'PipingCalculationOutputEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'PipingCalculationEntityId' INTEGER NOT NULL, + 'Order' INT (4) NOT NULL, + 'HeaveFactorOfSafety' REAL, + 'HeaveZValue' REAL, + 'UpliftFactorOfSafety' REAL, + 'UpliftZValue' REAL, + 'SellmeijerFactorOfSafety' REAL, + 'SellmeijerZValue' REAL, + 'UpliftEffectiveStress' REAL, + 'HeaveGradient' REAL, + 'SellmeijerCreepCoefficient' REAL, + 'SellmeijerCriticalFall' REAL, + 'SellmeijerReducedFall' REAL, + CONSTRAINT 'FK_PipingCalculationOutputEntity_PipingCalculationEntity' FOREIGN KEY ('PipingCalculationEntityId') REFERENCES 'PipingCalculationEntity' ('PipingCalculationEntityId') ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT 'U_PipingCalculationEntity' UNIQUE ('PipingCalculationEntityId') +) +; + +CREATE TABLE 'PipingSemiProbabilisticOutputEntity' +( + 'PipingSemiProbabilisticOutputEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'PipingCalculationEntityId' INTEGER NOT NULL, + 'Order' INT (4) NOT NULL, + 'UpliftFactorOfSafety' REAL, + 'UpliftReliability' REAL, + 'UpliftProbability' REAL, + 'HeaveFactorOfSafety' REAL, + 'HeaveReliability' REAL, + 'HeaveProbability' REAL, + 'SellmeijerFactorOfSafety' REAL, + 'SellmeijerReliability' REAL, + 'SellmeijerProbability' REAL, + 'RequiredProbability' REAL, + 'RequiredReliability' REAL, + 'PipingProbability' REAL, + 'PipingReliability' REAL, + 'PipingFactorOfSafety' REAL, + CONSTRAINT 'FK_PipingSemiProbabilisticOutputEntity_PipingCalculationEntity' FOREIGN KEY ('PipingCalculationEntityId') REFERENCES 'PipingCalculationEntity' ('PipingCalculationEntityId') ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT 'U_PipingCalculationEntity' UNIQUE ('PipingCalculationEntityId') +) +; + +CREATE TABLE 'PipingSectionResultEntity' +( + 'PipingSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'FailureMechanismSectionEntityId' INTEGER NOT NULL, + 'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed, 2 = Sufficient, 3 = NoVerdict + 'LayerThree' REAL, + CONSTRAINT 'FK_PipingSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade +) +; + +CREATE TABLE 'GrassCoverErosionInwardsSectionResultEntity' +( + 'GrassCoverErosionInwardsSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'FailureMechanismSectionEntityId' INTEGER NOT NULL, + 'GrassCoverErosionInwardsCalculationEntityId' INTEGER, + 'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed, 2 = Sufficient, 3 = NoVerdict + 'LayerThree' REAL, + CONSTRAINT 'FK_GrassCoverErosionInwardsSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT 'FK_GrassCoverErosionInwardsSectionResultEntity_GrassCoverErosionInwardsCalculationEntity' FOREIGN KEY ('GrassCoverErosionInwardsCalculationEntityId') REFERENCES 'GrassCoverErosionInwardsCalculationEntity' ('GrassCoverErosionInwardsCalculationEntityId') ON DELETE Set Null ON UPDATE Cascade +) +; + +CREATE TABLE 'HeightStructuresSectionResultEntity' +( + 'HeightStructuresSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'FailureMechanismSectionEntityId' INTEGER NOT NULL, + 'HeightStructuresCalculationEntityId' INTEGER, + 'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed, 2 = Sufficient, 3 = NoVerdict + 'LayerThree' REAL, + CONSTRAINT 'FK_HeightStructuresSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT 'FK_HeightStructuresSectionResultEntity_HeightStructuresCalculationEntity' FOREIGN KEY ('HeightStructuresCalculationEntityId') REFERENCES 'HeightStructuresCalculationEntity' ('HeightStructuresCalculationEntityId') ON DELETE Set Null ON UPDATE Cascade +) +; + +CREATE TABLE 'StrengthStabilityLengthwiseConstructionSectionResultEntity' +( + 'StrengthStabilityLengthwiseConstructionSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'FailureMechanismSectionEntityId' INTEGER NOT NULL, + 'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed, 2 = Sufficient, 3 = NoVerdict + 'LayerThree' REAL, + CONSTRAINT 'FK_StrengthStabilityLengthwiseConstructionSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade +) +; + +CREATE TABLE 'TechnicalInnovationSectionResultEntity' +( + 'TechnicalInnovationSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'FailureMechanismSectionEntityId' INTEGER NOT NULL, + 'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed, 2 = Sufficient, 3 = NoVerdict + 'LayerThree' REAL, + CONSTRAINT 'FK_TechnicalInnovationSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade +) +; + +CREATE TABLE 'WaterPressureAsphaltCoverSectionResultEntity' +( + 'WaterPressureAsphaltCoverSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'FailureMechanismSectionEntityId' INTEGER NOT NULL, + 'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed, 2 = Sufficient, 3 = NoVerdict + 'LayerThree' REAL, + CONSTRAINT 'FK_WaterPressureAsphaltCoverSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade +) +; + +CREATE TABLE 'ClosingStructuresSectionResultEntity' +( + 'ClosingStructuresSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'FailureMechanismSectionEntityId' INTEGER NOT NULL, + 'ClosingStructuresCalculationEntityId' INTEGER, + 'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed, 2 = Sufficient, 3 = NoVerdict + 'LayerThree' REAL, + CONSTRAINT 'FK_ClosingStructuresSectionResultEntity_ClosingStructuresCalculationEntity' FOREIGN KEY ('ClosingStructuresCalculationEntityId') REFERENCES 'ClosingStructuresCalculationEntity' ('ClosingStructuresCalculationEntityId') ON DELETE Set Null ON UPDATE Cascade, + CONSTRAINT 'FK_ClosingStructuresSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade +) +; + +CREATE TABLE 'GrassCoverErosionOutwardsSectionResultEntity' +( + 'GrassCoverErosionOutwardsSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'FailureMechanismSectionEntityId' INTEGER NOT NULL, + 'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed, 2 = Sufficient, 3 = NoVerdict + 'LayerTwoA' TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated, 2 = Failed, 3 = Successful + 'LayerThree' REAL, + CONSTRAINT 'FK_GrassCoverErosionOutwardsSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade +) +; + +CREATE TABLE 'GrassCoverSlipOffInwardsSectionResultEntity' +( + 'GrassCoverSlipOffInwardsSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'FailureMechanismSectionEntityId' INTEGER NOT NULL, + 'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed, 2 = Sufficient, 3 = NoVerdict + 'LayerTwoA' TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated, 2 = Failed, 3 = Successful + 'LayerThree' REAL, + CONSTRAINT 'FK_GrassCoverSlipOffInwardsSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade +) +; + +CREATE TABLE 'GrassCoverSlipOffOutwardsSectionResultEntity' +( + 'GrassCoverSlipOffOutwardsSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'FailureMechanismSectionEntityId' INTEGER NOT NULL, + 'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed, 2 = Sufficient, 3 = NoVerdict + 'LayerTwoA' TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated, 2 = Failed, 3 = Successful + 'LayerThree' REAL, + CONSTRAINT 'FK_GrassCoverSlipOffOutwardsSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade +) +; + +CREATE TABLE 'MacroStabilityInwardsSectionResultEntity' +( + 'MacroStabilityInwardsSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'FailureMechanismSectionEntityId' INTEGER NOT NULL, + 'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed, 2 = Sufficient, 3 = NoVerdict + 'LayerThree' REAL, + CONSTRAINT 'FK_MacroStabilityInwardsSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade +) +; + +CREATE TABLE 'MacrostabilityOutwardsSectionResultEntity' +( + 'MacrostabilityOutwardsSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'FailureMechanismSectionEntityId' INTEGER NOT NULL, + 'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed, 2 = Sufficient, 3 = NoVerdict + 'LayerTwoA' REAL, + 'LayerThree' REAL, + CONSTRAINT 'FK_MacrostabilityOutwardsSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade +) +; + +CREATE TABLE 'WaveImpactAsphaltCoverSectionResultEntity' +( + 'WaveImpactAsphaltCoverSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'FailureMechanismSectionEntityId' INTEGER NOT NULL, + 'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed, 2 = Sufficient, 3 = NoVerdict + 'LayerTwoA' TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated, 2 = Failed, 3 = Successful + 'LayerThree' REAL, + CONSTRAINT 'FK_WaveImpactAsphaltCoverSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade +) +; + +CREATE TABLE 'WaveImpactAsphaltCoverFailureMechanismMetaEntity' +( + 'WaveImpactAsphaltCoverFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'FailureMechanismEntityId' INTEGER NOT NULL, + 'ForeshoreProfileCollectionSourcePath' TEXT, + CONSTRAINT 'FK_WaveImpactAsphaltCoverFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade +) +; + +CREATE TABLE 'MicrostabilitySectionResultEntity' +( + 'MicrostabilitySectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'FailureMechanismSectionEntityId' INTEGER NOT NULL, + 'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed, 2 = Sufficient, 3 = NoVerdict + 'LayerTwoA' TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated, 2 = Failed, 3 = Successful + 'LayerThree' REAL, + CONSTRAINT 'FK_MicrostabilitySectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade +) +; + +CREATE TABLE 'PipingStructureSectionResultEntity' +( + 'PipingStructureSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'FailureMechanismSectionEntityId' INTEGER NOT NULL, + 'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed, 2 = Sufficient, 3 = NoVerdict + 'LayerTwoA' TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated, 2 = Failed, 3 = Successful + 'LayerThree' REAL, + CONSTRAINT 'FK_PipingStructureSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade +) +; + +CREATE TABLE 'DuneErosionSectionResultEntity' +( + 'DuneErosionSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'FailureMechanismSectionEntityId' INTEGER NOT NULL, + 'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed, 2 = Sufficient, 3 = NoVerdict + 'LayerTwoA' TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated, 2 = Failed, 3 = Successful + 'LayerThree' REAL, + CONSTRAINT 'FK_DuneErosionSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade +) +; + +CREATE TABLE 'StabilityStoneCoverSectionResultEntity' +( + 'StabilityStoneCoverSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'FailureMechanismSectionEntityId' INTEGER NOT NULL, + 'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed, 2 = Sufficient, 3 = NoVerdict + 'LayerTwoA' TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated, 2 = Failed, 3 = Successful + 'LayerThree' REAL, + CONSTRAINT 'FK_StabilityStoneCoverSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade +) +; + +CREATE TABLE 'StabilityPointStructuresSectionResultEntity' +( + 'StabilityPointStructuresSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'FailureMechanismSectionEntityId' INTEGER NOT NULL, + 'StabilityPointStructuresCalculationEntityId' INTEGER, + 'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed, 2 = Sufficient, 3 = NoVerdict + 'LayerThree' REAL, + CONSTRAINT 'FK_StabilityPointStructuresSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT 'FK_StabilityPointStructuresSectionResultEntity_StabilityPointStructuresCalculationEntity' FOREIGN KEY ('StabilityPointStructuresCalculationEntityId') REFERENCES 'StabilityPointStructuresCalculationEntity' ('StabilityPointStructuresCalculationEntityId') ON DELETE Set Null ON UPDATE Cascade +) +; + +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, + 'BreakWaterType' TINYINT (1), -- Enum: 1 = Wall 2 = Caisson 3 = Dam + 'BreakWaterHeight' REAL, + 'ForeshoreXml' TEXT NOT NULL, + 'DikeGeometryXml' TEXT NOT NULL, + 'DikeHeight' REAL, + 'X' REAL, + 'Y' REAL, + 'X0' REAL, + '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 'GrassCoverErosionInwardsOutputEntity' +( + 'GrassCoverErosionInwardsOutputEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'GrassCoverErosionInwardsCalculationEntityId' INTEGER NOT NULL, + 'GeneralResultFaultTreeIllustrationPointEntityId' INTEGER, + 'Order' INT (4) NOT NULL, + 'IsOvertoppingDominant' TINYINT (1) NOT NULL, -- true or false + 'WaveHeight' REAL, + 'RequiredProbability' REAL, + 'RequiredReliability' REAL, + 'Probability' REAL, + 'Reliability' REAL, + 'FactorOfSafety' REAL, + 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 'ForeshoreProfileEntity' +( + 'ForeshoreProfileEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'FailureMechanismEntityId' INTEGER NOT NULL, + 'Id' VARCHAR (260) NOT NULL, + 'Name' VARCHAR (260) NOT NULL, + 'Orientation' REAL, + 'BreakWaterType' TINYINT (1), -- Enum: 1 = Wall, 2 = Caisson, 3 = Dam + 'BreakWaterHeight' REAL, + 'GeometryXml' TEXT NOT NULL, + 'X' REAL, + 'Y' REAL, + 'X0' REAL, + '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 'StabilityStoneCoverWaveConditionsCalculationEntity' +( + 'StabilityStoneCoverWaveConditionsCalculationEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'CalculationGroupEntityId' INTEGER NOT NULL, + 'ForeshoreProfileEntityId' INTEGER, + 'HydraulicLocationEntityId' INTEGER, + 'Order' INT (4) NOT NULL, + 'Name' VARCHAR (260), + 'Comments' TEXT, + 'UseBreakWater' TINYINT (1) NOT NULL, -- true or false + 'BreakWaterType' TINYINT (1) NOT NULL, -- Enum: 1 = Wall, 2 = Caisson, 3 = Dam + 'BreakWaterHeight' REAL, + 'UseForeshore' TINYINT (1) NOT NULL, -- true or false + 'Orientation' REAL, + 'UpperBoundaryRevetment' REAL, + 'LowerBoundaryRevetment' REAL, + 'UpperBoundaryWaterLevels' REAL, + 'LowerBoundaryWaterLevels' REAL, + 'StepSize' TINYINT (1) NOT NULL, -- Enum: 1 = 0.5, 2 = 1.0, 3 = 2.0 + 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_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, + 'WaveHeight' REAL, + 'WavePeakPeriod' REAL, + 'WaveAngle' REAL, + 'WaveDirection' REAL, + 'TargetProbability' REAL, + 'TargetReliability' REAL, + 'CalculatedProbability' REAL, + 'CalculatedReliability' REAL, + '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 'WaveImpactAsphaltCoverWaveConditionsCalculationEntity' +( + 'WaveImpactAsphaltCoverWaveConditionsCalculationEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'CalculationGroupEntityId' INTEGER NOT NULL, + 'ForeshoreProfileEntityId' INTEGER, + 'HydraulicLocationEntityId' INTEGER, + 'Order' INT (4) NOT NULL, + 'Name' VARCHAR (260), + 'Comments' TEXT, + 'UseBreakWater' TINYINT (1) NOT NULL, -- true or false + 'BreakWaterType' TINYINT (1) NOT NULL, -- Enum: 1 = Wall, 2 = Caisson, 3 = Dam + 'BreakWaterHeight' REAL, + 'UseForeshore' TINYINT (1) NOT NULL, -- true or false + 'Orientation' REAL, + 'UpperBoundaryRevetment' REAL, + 'LowerBoundaryRevetment' REAL, + 'UpperBoundaryWaterLevels' REAL, + 'LowerBoundaryWaterLevels' REAL, + 'StepSize' TINYINT (1) NOT NULL, -- Enum: 1 = 0.5, 2 = 1.0, 3 = 2.0 + 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_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, + 'WaveHeight' REAL, + 'WavePeakPeriod' REAL, + 'WaveAngle' REAL, + 'WaveDirection' REAL, + 'TargetProbability' REAL, + 'TargetReliability' REAL, + 'CalculatedProbability' REAL, + 'CalculatedReliability' REAL, + '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 TABLE 'GrassCoverErosionOutwardsWaveConditionsCalculationEntity' +( + 'GrassCoverErosionOutwardsWaveConditionsCalculationEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'CalculationGroupEntityId' INTEGER NOT NULL, + 'ForeshoreProfileEntityId' INTEGER, + 'GrassCoverErosionOutwardsHydraulicLocationEntityId' INTEGER, + 'Order' INT (4) NOT NULL, + 'Name' VARCHAR (260), + 'Comments' TEXT, + 'UseBreakWater' TINYINT (1) NOT NULL, -- true or false + 'BreakWaterType' TINYINT (1) NOT NULL, -- Enum: 1 = Wall, 2 = Caisson, 3 = Dam + 'BreakWaterHeight' REAL, + 'UseForeshore' TINYINT (1) NOT NULL, -- true or false + 'Orientation' REAL, + 'UpperBoundaryRevetment' REAL, + 'LowerBoundaryRevetment' REAL, + 'UpperBoundaryWaterLevels' REAL, + 'LowerBoundaryWaterLevels' REAL, + 'StepSize' TINYINT (1) NOT NULL, -- Enum: 1 = 0.5, 2 = 1.0, 3 = 2.0 + 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_GrassCoverErosionOutwardsHydraulicLocationEntity' FOREIGN KEY ('GrassCoverErosionOutwardsHydraulicLocationEntityId') REFERENCES 'GrassCoverErosionOutwardsHydraulicLocationEntity' ('GrassCoverErosionOutwardsHydraulicLocationEntityId') ON DELETE Set Null ON UPDATE Cascade +) +; + +CREATE TABLE 'GrassCoverErosionOutwardsHydraulicLocationEntity' +( + 'GrassCoverErosionOutwardsHydraulicLocationEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'FailureMechanismEntityId' INTEGER NOT NULL, + 'LocationId' INTEGER NOT NULL, + 'Name' VARCHAR (260) NOT NULL, + 'LocationX' REAL, + 'LocationY' REAL, + 'ShouldWaveHeightIllustrationPointsBeCalculated' TINYINT (1) NOT NULL, -- true or false + 'ShouldDesignWaterLevelIllustrationPointsBeCalculated' TINYINT (1) NOT NULL, -- true or false + 'Order' INT (4) NOT NULL, + CONSTRAINT 'FK_GrassCoverErosionOutwardsHydraulicLocationEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade +) +; + +CREATE TABLE 'GrassCoverErosionOutwardsWaveConditionsOutputEntity' +( + 'GrassCoverErosionOutwardsWaveConditionsOutputEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'GrassCoverErosionOutwardsWaveConditionsCalculationEntityId' INTEGER NOT NULL, + 'Order' INT (4) NOT NULL, + 'WaterLevel' REAL, + 'WaveHeight' REAL, + 'WavePeakPeriod' REAL, + 'WaveAngle' REAL, + 'WaveDirection' REAL, + 'TargetProbability' REAL, + 'TargetReliability' REAL, + 'CalculatedProbability' REAL, + 'CalculatedReliability' REAL, + '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 'HeightStructuresOutputEntity' +( + 'HeightStructuresOutputEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'HeightStructuresCalculationEntityId' INTEGER NOT NULL, + 'GeneralResultFaultTreeIllustrationPointEntityId' INTEGER, + 'RequiredProbability' REAL, + 'RequiredReliability' REAL, + 'Probability' REAL, + 'Reliability' REAL, + 'FactorOfSafety' REAL, + 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 '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, + 'Y' REAL, + 'StructureNormalOrientation' REAL, + 'LevelCrestStructureMean' REAL, + 'LevelCrestStructureStandardDeviation' REAL, + 'FlowWidthAtBottomProtectionMean' REAL, + 'FlowWidthAtBottomProtectionStandardDeviation' REAL, + 'CriticalOvertoppingDischargeMean' REAL, + 'CriticalOvertoppingDischargeCoefficientOfVariation' REAL, + 'WidthFlowAperturesMean' REAL, + 'WidthFlowAperturesStandardDeviation' REAL, + 'FailureProbabilityStructureWithErosion' REAL, + 'StorageStructureAreaMean' REAL, + 'StorageStructureAreaCoefficientOfVariation' REAL, + 'AllowedLevelIncreaseStorageMean' REAL, + 'AllowedLevelIncreaseStorageStandardDeviation' REAL, + 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, + 'HeightStructureEntityId' INTEGER, + 'ForeshoreProfileEntityId' INTEGER, + 'Order' INT (4) NOT NULL, + 'Name' VARCHAR (260), + 'Comments' TEXT, + 'ModelFactorSuperCriticalFlowMean' REAL, + 'StructureNormalOrientation' REAL, + 'AllowedLevelIncreaseStorageMean' REAL, + 'AllowedLevelIncreaseStorageStandardDeviation' REAL, + 'StorageStructureAreaMean' REAL, + 'StorageStructureAreaCoefficientOfVariation' REAL, + 'FlowWidthAtBottomProtectionMean' REAL, + 'FlowWidthAtBottomProtectionStandardDeviation' REAL, + 'CriticalOvertoppingDischargeMean' REAL, + 'CriticalOvertoppingDischargeCoefficientOfVariation' REAL, + 'FailureProbabilityStructureWithErosion' REAL NOT NULL, + 'WidthFlowAperturesMean' REAL, + 'WidthFlowAperturesStandardDeviation' REAL, + 'StormDurationMean' REAL, + 'LevelCrestStructureMean' REAL, + 'LevelCrestStructureStandardDeviation' REAL, + 'DeviationWaveDirection' REAL, + '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, + 'ShouldIllustrationPointsBeCalculated' TINYINT (1) NOT NULL, -- true or false + 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 '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, + 'Y' REAL, + 'StructureNormalOrientation' REAL, + 'StorageStructureAreaMean' REAL, + 'StorageStructureAreaCoefficientOfVariation' REAL, + 'AllowedLevelIncreaseStorageMean' REAL, + 'AllowedLevelIncreaseStorageStandardDeviation' REAL, + 'WidthFlowAperturesMean' REAL, + 'WidthFlowAperturesStandardDeviation' REAL, + 'LevelCrestStructureNotClosingMean' REAL, + 'LevelCrestStructureNotClosingStandardDeviation' REAL, + 'InsideWaterLevelMean' REAL, + 'InsideWaterLevelStandardDeviation' REAL, + 'ThresholdHeightOpenWeirMean' REAL, + 'ThresholdHeightOpenWeirStandardDeviation' REAL, + 'AreaFlowAperturesMean' REAL, + 'AreaFlowAperturesStandardDeviation' REAL, + 'CriticalOvertoppingDischargeMean' REAL, + 'CriticalOvertoppingDischargeCoefficientOfVariation' REAL, + 'FlowWidthAtBottomProtectionMean' REAL, + 'FlowWidthAtBottomProtectionStandardDeviation' REAL, + 'ProbabilityOrFrequencyOpenStructureBeforeFlooding' REAL, + 'FailureProbabilityOpenStructure' REAL, + 'IdenticalApertures' INT (4) NOT NULL, + 'FailureProbabilityReparation' REAL, + '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, + 'HydraulicLocationEntityId' INTEGER, + 'ClosingStructureEntityId' INTEGER, + 'Order' INT (4) NOT NULL, + 'Name' VARCHAR (255), + 'Comments' TEXT, + 'UseBreakWater' TINYINT (1) NOT NULL, -- true or false + 'BreakWaterType' TINYINT (1) NOT NULL, -- Enum: 1 = Wall, 2 = Caisson, 3 = Dam + 'BreakWaterHeight' REAL, + 'UseForeshore' TINYINT (1) NOT NULL, -- true or false + 'Orientation' REAL, + 'StructureNormalOrientation' REAL, + 'StorageStructureAreaMean' REAL, + 'StorageStructureAreaCoefficientOfVariation' REAL, + 'AllowedLevelIncreaseStorageMean' REAL, + 'AllowedLevelIncreaseStorageStandardDeviation' REAL, + 'WidthFlowAperturesMean' REAL, + 'WidthFlowAperturesStandardDeviation' REAL, + 'LevelCrestStructureNotClosingMean' REAL, + 'LevelCrestStructureNotClosingStandardDeviation' REAL, + 'InsideWaterLevelMean' REAL, + 'InsideWaterLevelStandardDeviation' REAL, + 'ThresholdHeightOpenWeirMean' REAL, + 'ThresholdHeightOpenWeirStandardDeviation' REAL, + 'AreaFlowAperturesMean' REAL, + 'AreaFlowAperturesStandardDeviation' REAL, + 'CriticalOvertoppingDischargeMean' REAL, + 'CriticalOvertoppingDischargeCoefficientOfVariation' REAL, + 'FlowWidthAtBottomProtectionMean' REAL, + 'FlowWidthAtBottomProtectionStandardDeviation' REAL, + 'ProbabilityOrFrequencyOpenStructureBeforeFlooding' 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, + 'DrainCoefficientMean' REAL, + 'ModelFactorSuperCriticalFlowMean' REAL, + 'StormDurationMean' REAL, + 'FactorStormDurationOpenStructure' REAL, + 'ShouldIllustrationPointsBeCalculated' TINYINT (1) NOT NULL, -- true or false + 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, + 'RequiredProbability' REAL, + 'RequiredReliability' REAL, + 'Probability' REAL, + 'Reliability' REAL, + 'FactorOfSafety' REAL, + 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 '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, + 'Y' REAL, + 'StructureNormalOrientation' REAL, + 'StorageStructureAreaMean' REAL, + 'StorageStructureAreaCoefficientOfVariation' REAL, + 'AllowedLevelIncreaseStorageMean' REAL, + 'AllowedLevelIncreaseStorageStandardDeviation' REAL, + 'WidthFlowAperturesMean' REAL, + 'WidthFlowAperturesStandardDeviation' REAL, + 'InsideWaterLevelMean' REAL, + 'InsideWaterLevelStandardDeviation' REAL, + 'ThresholdHeightOpenWeirMean' REAL, + 'ThresholdHeightOpenWeirStandardDeviation' REAL, + 'CriticalOvertoppingDischargeMean' REAL, + 'CriticalOvertoppingDischargeCoefficientOfVariation' REAL, + 'FlowWidthAtBottomProtectionMean' REAL, + 'FlowWidthAtBottomProtectionStandardDeviation' REAL, + 'ConstructiveStrengthLinearLoadModelMean' REAL, + 'ConstructiveStrengthLinearLoadModelCoefficientOfVariation' REAL, + 'ConstructiveStrengthQuadraticLoadModelMean' REAL, + 'ConstructiveStrengthQuadraticLoadModelCoefficientOfVariation' REAL, + 'BankWidthMean' REAL, + 'BankWidthStandardDeviation' REAL, + 'InsideWaterLevelFailureConstructionMean' REAL, + 'InsideWaterLevelFailureConstructionStandardDeviation' REAL, + 'EvaluationLevel' REAL, + 'LevelCrestStructureMean' REAL, + 'LevelCrestStructureStandardDeviation' REAL, + 'VerticalDistance' REAL, + 'FailureProbabilityRepairClosure' REAL, + 'FailureCollisionEnergyMean' REAL, + 'FailureCollisionEnergyCoefficientOfVariation' REAL, + 'ShipMassMean' REAL, + 'ShipMassCoefficientOfVariation' REAL, + 'ShipVelocityMean' REAL, + 'ShipVelocityCoefficientOfVariation' REAL, + 'LevellingCount' INT (4) NOT NULL, + 'ProbabilityCollisionSecondaryStructure' REAL, + 'FlowVelocityStructureClosableMean' REAL, + 'StabilityLinearLoadModelMean' REAL, + 'StabilityLinearLoadModelCoefficientOfVariation' REAL, + 'StabilityQuadraticLoadModelMean' REAL, + 'StabilityQuadraticLoadModelCoefficientOfVariation' REAL, + 'AreaFlowAperturesMean' REAL, + 'AreaFlowAperturesStandardDeviation' REAL, + '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 'StabilityPointStructuresOutputEntity' +( + 'StabilityPointStructuresOutputEntity' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'StabilityPointStructuresCalculationEntityId' INTEGER NOT NULL, + 'GeneralResultFaultTreeIllustrationPointEntityId' INTEGER, + 'RequiredProbability' REAL, + 'RequiredReliability' REAL, + 'Probability' REAL, + 'Reliability' REAL, + 'FactorOfSafety' REAL, + 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 'HydraulicLocationOutputEntity' +( + 'HydraulicLocationEntityOutputId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'HydraulicLocationCalculationEntityId' INTEGER, + 'GeneralResultSubMechanismIllustrationPointEntityId' INTEGER, + 'Result' REAL, + 'TargetProbability' REAL, + 'TargetReliability' REAL, + 'CalculatedProbability' REAL, + 'CalculatedReliability' REAL, + '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 'GrassCoverErosionOutwardsHydraulicLocationOutputEntity' +( + 'GrassCoverErosionOutwardsHydraulicLocationOutputEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'GrassCoverErosionOutwardsHydraulicLocationEntityId' INTEGER NOT NULL, + 'GeneralResultSubMechanismIllustrationPointEntityId' INTEGER, + 'HydraulicLocationOutputType' TINYINT (1) NOT NULL, -- Enum: 1 = DesignWaterLevel, 2 = WaveHeight + 'Result' REAL, + 'TargetProbability' REAL, + 'TargetReliability' REAL, + 'CalculatedProbability' REAL, + 'CalculatedReliability' REAL, + 'CalculationConvergence' TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated, 2 = CalculatedNotConverged, 3 = CalculatedConverged + CONSTRAINT 'FK_GrassCoverErosionOutwardsHydraulicLocationOutputEntity_GeneralResultSubMechanismIllustrationPointEntity' FOREIGN KEY ('GeneralResultSubMechanismIllustrationPointEntityId') REFERENCES 'GeneralResultSubMechanismIllustrationPointEntity' ('GeneralResultSubMechanismIllustrationPointEntityId') ON DELETE Set Null ON UPDATE Cascade, + CONSTRAINT 'FK_GrassCoverErosionOutwardsHydraulicLocationOutputEntity_GrassCoverErosionOutwardsHydraulicLocationEntity' FOREIGN KEY ('GrassCoverErosionOutwardsHydraulicLocationEntityId') REFERENCES 'GrassCoverErosionOutwardsHydraulicLocationEntity' ('GrassCoverErosionOutwardsHydraulicLocationEntityId') ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT 'U_HydraulicLocationOutputType' UNIQUE ('GrassCoverErosionOutwardsHydraulicLocationEntityId','HydraulicLocationOutputType') +) +; + +CREATE TABLE 'DuneLocationEntity' +( + 'DuneLocationEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'FailureMechanismEntityId' INTEGER NOT NULL, + 'LocationId' INTEGER NOT NULL, + 'Name' VARCHAR (260) NOT NULL, + 'LocationX' REAL, + 'LocationY' REAL, + 'CoastalAreaId' INT (4) NOT NULL, + 'Offset' REAL, + 'Orientation' REAL, + 'D50' REAL, + 'Order' INT (4) NOT NULL, + CONSTRAINT 'FK_DuneLocationEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade +) +; + +CREATE TABLE 'DuneLocationOutputEntity' +( + 'DuneLocationOutputEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'DuneLocationEntityId' INTEGER NOT NULL, + 'WaterLevel' REAL, + 'WaveHeight' REAL, + 'WavePeriod' REAL, + 'TargetProbability' REAL, + 'TargetReliability' REAL, + 'CalculatedProbability' REAL, + 'CalculatedReliability' REAL, + 'CalculationConvergence' TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated, 2 = CalculatedNotConverged, 3 = CalculatedConverged + CONSTRAINT 'FK_DuneLocationOutputEntity_DuneLocationEntity' FOREIGN KEY ('DuneLocationEntityId') REFERENCES 'DuneLocationEntity' ('DuneLocationEntityId') ON DELETE Cascade ON UPDATE Cascade +) +; + +CREATE TABLE 'BackgroundDataEntity' +( + 'BackgroundDataEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'AssessmentSectionEntityId' INTEGER NOT NULL, + 'Name' TEXT NOT NULL, + '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, + 'Value' TEXT NOT NULL, + 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 'GrassCoverErosionInwardsOvertoppingRateOutputEntity' +( + 'GrassCoverErosionInwardsOvertoppingRateOutputEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'GrassCoverErosionInwardsOutputEntityId' INTEGER NOT NULL, + 'GeneralResultFaultTreeIllustrationPointEntityId' INTEGER, + 'OvertoppingRate' REAL, + 'TargetProbability' REAL, + 'TargetReliability' REAL, + 'CalculatedProbability' REAL, + 'CalculatedReliability' REAL, + '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 'GeneralResultSubMechanismIllustrationPointEntity' +( + 'GeneralResultSubMechanismIllustrationPointEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'GoverningWindDirectionName' TEXT NOT NULL, + 'GoverningWindDirectionAngle' REAL NOT NULL +) +; + +CREATE TABLE 'SubMechanismIllustrationPointEntity' +( + 'SubMechanismIllustrationPointEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'Name' TEXT NOT NULL, + 'Beta' REAL NOT NULL, + 'Order' INT (4) NOT NULL +) +; + +CREATE TABLE 'IllustrationPointResultEntity' +( + 'IllustrationPointResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'SubMechanismIllustrationPointEntityId' INTEGER NOT NULL, + 'Description' TEXT NOT NULL, + '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 'StochastEntity' +( + 'StochastEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'Name' TEXT NOT NULL, + 'Duration' REAL NOT NULL, + 'Alpha' REAL NOT NULL, + 'Order' INT (4) 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 'GeneralResultFaultTreeIllustrationPointEntity' +( + 'GeneralResultFaultTreeIllustrationPointEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'GoverningWindDirectionName' TEXT NOT NULL, + 'GoverningWindDirectionAngle' REAL NOT NULL +) +; + +CREATE TABLE 'FaultTreeIllustrationPointEntity' +( + 'FaultTreeIllustrationPointEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'ParentFaultTreeIllustrationPointEntityId' INTEGER, + 'Name' TEXT NOT NULL, + '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 '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 'TopLevelSubMechanismIllustrationPointEntity' +( + 'TopLevelSubMechanismIllustrationPointEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'GeneralResultSubMechanismIllustrationPointEntityId' INTEGER NOT NULL, + 'SubMechanismIllustrationPointEntityId' INTEGER NOT NULL, + 'ClosingSituation' TEXT NOT NULL, + 'WindDirectionName' TEXT NOT NULL, + '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 'TopLevelFaultTreeIllustrationPointEntity' +( + 'TopLevelFaultTreeIllustrationPointEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'FaultTreeIllustrationPointEntityId' INTEGER NOT NULL, + 'GeneralResultFaultTreeIllustrationPointEntityId' INTEGER NOT NULL, + 'ClosingSituation' TEXT NOT NULL, + 'WindDirectionName' TEXT NOT NULL, + '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 'SubMechanismIllustrationPointStochastEntity' +( + 'SubMechanismIllustrationPointStochastEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'SubMechanismIllustrationPointEntityId' INTEGER NOT NULL, + 'Name' TEXT NOT NULL, + '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 '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 'MacroStabilityInwardsCalculationEntity' +( + 'MacroStabilityInwardsCalculationEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'CalculationGroupEntityId' INTEGER NOT NULL, + 'SurfaceLineEntityId' INTEGER, + 'MacroStabilityInwardsStochasticSoilProfileEntityId' INTEGER, + 'HydraulicLocationEntityId' INTEGER, + 'Order' INT (4) NOT NULL, + 'Name' VARCHAR (260), + 'Comment' TEXT, + 'RelevantForScenario' TINYINT (1) NOT NULL, -- true or false + 'ScenarioContribution' REAL, + 'AssessmentLevel' REAL, + 'UseAssessmentLevelManualInput' TINYINT (1) NOT NULL, -- true or false + 'SlipPlaneMinimumDepth' REAL, + 'SlipPlaneMinimumLength' REAL, + 'MaximumSliceWidth' REAL, + '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, + 'TangentLineZBottom' REAL, + 'TangentLineNumber' INT (4) NOT NULL, + 'LeftGridXLeft' REAL, + 'LeftGridXRight' REAL, + 'LeftGridNrOfHorizontalPoints' INT (4) NOT NULL, + 'LeftGridZTop' REAL, + 'LeftGridZBottom' REAL, + 'LeftGridNrOfVerticalPoints' INT (4) NOT NULL, + 'RightGridXLeft' REAL, + 'RightGridXRight' REAL, + 'RightGridNrOfHorizontalPoints' INT (4) NOT NULL, + 'RightGridZTop' REAL, + 'RightGridZBottom' REAL, + 'RightGridNrOfVerticalPoints' INT (4) NOT NULL, + 'DikeSoilScenario' TINYINT (1) NOT NULL, -- Enumtype: 1 = ClayDikeOnClay, 2 = SandDikeOnClay, 3 = ClayDikeOnSand, 4 = SandDikeOnSand + 'WaterLevelRiverAverage' REAL, + 'DrainageConstructionPresent' TINYINT (1) NOT NULL, -- true or false + 'DrainageConstructionCoordinateX' REAL, + 'DrainageConstructionCoordinateZ' REAL, + 'MinimumLevelPhreaticLineAtDikeTopRiver' REAL, + 'MinimumLevelPhreaticLineAtDikeTopPolder' REAL, + 'AdjustPhreaticLine3And4ForUplift' TINYINT (1) NOT NULL, -- true or false + 'LeakageLengthOutwardsPhreaticLine3' REAL, + 'LeakageLengthInwardsPhreaticLine3' REAL, + 'LeakageLengthOutwardsPhreaticLine4' REAL, + 'LeakageLengthInwardsPhreaticLine4' REAL, + 'PiezometricHeadPhreaticLine2Outwards' REAL, + 'PiezometricHeadPhreaticLine2Inwards' REAL, + 'LocationInputExtremeWaterLevelPolder' REAL, + 'LocationInputExtremeUseDefaultOffsets' TINYINT (1) NOT NULL, -- true or false + 'LocationInputExtremePhreaticLineOffsetBelowDikeTopAtRiver' REAL, + 'LocationInputExtremePhreaticLineOffsetBelowDikeTopAtPolder' REAL, + 'LocationInputExtremePhreaticLineOffsetBelowShoulderBaseInside' REAL, + 'LocationInputExtremePhreaticLineOffsetDikeToeAtPolder' REAL, + 'LocationInputExtremePenetrationLength' REAL, + 'LocationInputDailyWaterLevelPolder' REAL, + 'LocationInputDailyUseDefaultOffsets' TINYINT (1) NOT NULL, -- true or false + 'LocationInputDailyPhreaticLineOffsetBelowDikeTopAtRiver' REAL, + 'LocationInputDailyPhreaticLineOffsetBelowDikeTopAtPolder' REAL, + 'LocationInputDailyPhreaticLineOffsetBelowShoulderBaseInside' REAL, + 'LocationInputDailyPhreaticLineOffsetDikeToeAtPolder' REAL, + 'CreateZones' TINYINT (1) NOT NULL, -- true or false + 'ZoningBoundariesDeterminationType' TINYINT (1) NOT NULL, -- Enumtype: 1 = Automatic 2 = Manual + 'ZoneBoundaryLeft' REAL, + 'ZoneBoundaryRight' REAL, + 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, + 'ZValue' REAL, + 'ForbiddenZonesXEntryMin' REAL, + 'ForbiddenZonesXEntryMax' REAL, + 'SlidingCurveLeftSlidingCircleCenterX' REAL, + 'SlidingCurveLeftSlidingCircleCenterY' REAL, + 'SlidingCurveLeftSlidingCircleRadius' REAL, + 'SlidingCurveLeftSlidingCircleIsActive' TINYINT (1) NOT NULL, -- true or false + 'SlidingCurveLeftSlidingCircleNonIteratedForce' REAL, + 'SlidingCurveLeftSlidingCircleIteratedForce' REAL, + 'SlidingCurveLeftSlidingCircleDrivingMoment' REAL, + 'SlidingCurveLeftSlidingCircleResistingMoment' REAL, + 'SlidingCurveRightSlidingCircleCenterX' REAL, + 'SlidingCurveRightSlidingCircleCenterY' REAL, + 'SlidingCurveRightSlidingCircleRadius' REAL, + 'SlidingCurveRightSlidingCircleIsActive' TINYINT (1) NOT NULL, -- true or false + 'SlidingCurveRightSlidingCircleNonIteratedForce' REAL, + 'SlidingCurveRightSlidingCircleIteratedForce' REAL, + 'SlidingCurveRightSlidingCircleDrivingMoment' REAL, + 'SlidingCurveRightSlidingCircleResistingMoment' REAL, + 'SlidingCurveNonIteratedHorizontalForce' REAL, + 'SlidingCurveIteratedHorizontalForce' REAL, + 'SlidingCurveSliceXML' TEXT NOT NULL, -- XML representation of MacroStabilityInwardsSlice + 'SlipPlaneLeftGridXLeft' REAL, + 'SlipPlaneLeftGridXRight' REAL, + 'SlipPlaneLeftGridNrOfHorizontalPoints' INT (4) NOT NULL, + 'SlipPlaneLeftGridZTop' REAL, + 'SlipPlaneLeftGridZBottom' REAL, + 'SlipPlaneLeftGridNrOfVerticalPoints' INT (4) NOT NULL, + 'SlipPlaneRightGridXLeft' REAL, + 'SlipPlaneRightGridXRight' REAL, + 'SlipPlaneRightGridNrOfHorizontalPoints' INT (4) NOT NULL, + 'SlipPlaneRightGridZTop' REAL, + 'SlipPlaneRightGridZBottom' REAL, + 'SlipPlaneRightGridNrOfVerticalPoints' INT (4) NOT NULL, + 'SlipPlaneTangentLinesXml' TEXT NOT NULL, -- 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, + 'Y' REAL, + 'Z' REAL, + CONSTRAINT 'FK_MacroStabilityInwardsCharacteristicPointEntity_SurfaceLineEntity' FOREIGN KEY ('SurfaceLineEntityId') REFERENCES 'SurfaceLineEntity' ('SurfaceLineEntityId') ON DELETE Cascade ON UPDATE Cascade +) +; + +CREATE TABLE 'MacroStabilityInwardsSoilLayerOneDEntity' +( + 'MacroStabilityInwardsSoilLayerOneDEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'MacroStabilityInwardsSoilProfileOneDEntityId' INTEGER NOT NULL, + 'Top' REAL, + 'IsAquifer' TINYINT (1) NOT NULL, -- true or false + 'Color' INTEGER, -- ARGB value of Color. + 'MaterialName' TEXT NOT NULL, + 'ShearStrengthModel' TINYINT (1) NOT NULL, -- Enumtype: 1 = SuCalculated, 2 = CPhi, 3 = CPhiOrSuCalculated + 'UsePop' TINYINT (1) NOT NULL, -- true of false + 'AbovePhreaticLevelMean' REAL, + 'AbovePhreaticLevelCoefficientOfVariation' REAL, + 'AbovePhreaticLevelShift' REAL, + 'BelowPhreaticLevelMean' REAL, + 'BelowPhreaticLevelCoefficientOfVariation' REAL, + 'BelowPhreaticLevelShift' REAL, + 'CohesionMean' REAL, + 'CohesionCoefficientOfVariation' REAL, + 'FrictionAngleMean' REAL, + 'FrictionAngleCoefficientOfVariation' REAL, + 'ShearStrengthRatioMean' REAL, + 'ShearStrengthRatioCoefficientOfVariation' REAL, + 'StrengthIncreaseExponentMean' REAL, + 'StrengthIncreaseExponentCoefficientOfVariation' REAL, + 'PopMean' REAL, + 'PopCoefficientOfVariation' REAL, + 'Order' INT (4) NOT NULL, + CONSTRAINT 'FK_MacroStabilityInwardsSoilLayerOneDEntity_MacroStabilityInwardsSoilProfileOneDEntity' FOREIGN KEY ('MacroStabilityInwardsSoilProfileOneDEntityId') REFERENCES 'MacroStabilityInwardsSoilProfileOneDEntity' ('MacroStabilityInwardsSoilProfileOneDEntityId') ON DELETE Cascade ON UPDATE Cascade +) +; + +CREATE TABLE 'MacroStabilityInwardsSoilProfileOneDEntity' +( + 'MacroStabilityInwardsSoilProfileOneDEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'Name' TEXT NOT NULL, + 'Bottom' REAL +) +; + +CREATE TABLE 'MacroStabilityInwardsSoilLayerTwoDEntity' +( + 'MacroStabilityInwardsSoilLayerTwoDEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'ParentMacroStabilityInwardsSoilLayerTwoDEntityId' INTEGER, + 'IsAquifer' TINYINT (1) NOT NULL, -- true or false + 'Color' INTEGER, -- ARGB value of Color. + 'MaterialName' TEXT NOT NULL, + 'ShearStrengthModel' TINYINT (1) NOT NULL, -- Enumtype: 1 = SuCalculated, 2 = CPhi, 3 = CPhiOrSuCalculated + 'UsePop' TINYINT (1) NOT NULL, -- true of false + 'AbovePhreaticLevelMean' REAL, + 'AbovePhreaticLevelCoefficientOfVariation' REAL, + 'AbovePhreaticLevelShift' REAL, + 'BelowPhreaticLevelMean' REAL, + 'BelowPhreaticLevelCoefficientOfVariation' REAL, + 'BelowPhreaticLevelShift' REAL, + 'CohesionMean' REAL, + 'CohesionCoefficientOfVariation' REAL, + 'FrictionAngleMean' REAL, + 'FrictionAngleCoefficientOfVariation' REAL, + 'ShearStrengthRatioMean' REAL, + 'ShearStrengthRatioCoefficientOfVariation' REAL, + 'StrengthIncreaseExponentMean' REAL, + 'StrengthIncreaseExponentCoefficientOfVariation' REAL, + 'PopMean' REAL, + 'PopCoefficientOfVariation' REAL, + 'OuterRingXml' TEXT NOT NULL, + 'Order' INT (4) NOT NULL, + CONSTRAINT 'FK_MacroStabilityInwardsSoilLayerTwoDEntity_MacroStabilityInwardsSoilLayerTwoDEntity' FOREIGN KEY ('ParentMacroStabilityInwardsSoilLayerTwoDEntityId') REFERENCES 'MacroStabilityInwardsSoilLayerTwoDEntity' ('MacroStabilityInwardsSoilLayerTwoDEntityId') ON DELETE Cascade ON UPDATE Cascade +) +; + +CREATE TABLE 'MacroStabilityInwardsSoilProfileTwoDEntity' +( + 'MacroStabilityInwardsSoilProfileTwoDEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'Name' TEXT NOT NULL +) +; + +CREATE TABLE 'MacroStabilityInwardsStochasticSoilProfileEntity' +( + 'MacroStabilityInwardsStochasticSoilProfileEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'StochasticSoilModelEntityId' INTEGER NOT NULL, + 'MacroStabilityInwardsSoilProfileOneDEntityId' INTEGER, + 'MacroStabilityInwardsSoilProfileTwoDEntityId' INTEGER, + '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 'MacroStabilityInwardsPreconsolidationStressEntity' +( + 'MacroStabilityInwardsPreconsolidationStressEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'MacroStabilityInwardsSoilProfileTwoDEntityId' INTEGER NOT NULL, + 'CoordinateX' REAL NOT NULL, + 'CoordinateZ' REAL NOT NULL, + 'PreconsolidationStressMean' REAL, + 'PreconsolidationStressCoefficientOfVariation' REAL, + 'Order' INT (4) NOT NULL, + CONSTRAINT 'FK_MacroStabilityInwardsPreconsolidationStressEntity_MacroStabilityInwardsSoilProfileTwoDEntity' FOREIGN KEY ('MacroStabilityInwardsSoilProfileTwoDEntityId') REFERENCES 'MacroStabilityInwardsSoilProfileTwoDEntity' ('MacroStabilityInwardsSoilProfileTwoDEntityId') ON DELETE Cascade ON UPDATE Cascade +) +; + +CREATE TABLE 'MacroStabilityInwardsSemiProbabilisticOutputEntity' +( + 'MacroStabilityInwardsSemiProbabilisticOutputEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'MacroStabilityInwardsCalculationEntityId' INTEGER NOT NULL, + 'FactorOfStability' REAL, + 'RequiredProbability' REAL, + 'RequiredReliability' REAL, + 'MacroStabilityInwardsProbability' REAL, + 'MacroStabilityInwardsReliability' REAL, + 'MacroStabilityInwardsFactorOfSafety' REAL, + CONSTRAINT 'FK_MacroStabilityInwardsSemiProbabilisticOutputEntity_MacroStabilityInwardsCalculationEntity' FOREIGN KEY ('MacroStabilityInwardsCalculationEntityId') REFERENCES 'MacroStabilityInwardsCalculationEntity' ('MacroStabilityInwardsCalculationEntityId') ON DELETE Cascade ON UPDATE Cascade +) +; + +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 'HydraRingPreprocessorEntity' +( + 'HydraRingPreprocessorEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'AssessmentSectionEntityId' INTEGER NOT NULL, + 'UsePreprocessor' TINYINT (1) NOT NULL, + 'PreprocessorDirectory' TEXT NOT NULL, + CONSTRAINT 'FK_HydraRingPreprocessorEntity_AssessmentSectionEntity' FOREIGN KEY ('AssessmentSectionEntityId') REFERENCES 'AssessmentSectionEntity' ('AssessmentSectionEntityId') ON DELETE Cascade ON UPDATE Cascade +) +; + +CREATE TABLE 'HydraulicLocationCalculationEntity' +( + 'HydraulicLocationCalculationEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'ShouldIllustrationPointsBeCalculated' TINYINT (1) NOT NULL -- True or false +) +; + +/* Create Indexes and Triggers */ + +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 @@ -1989,100 +1989,100 @@ FROM GeneralResultFaultTreeIllustrationPointEntity WHERE OLD.GeneralResultFaultTreeIllustrationPointEntityId IS NOT NULL AND GeneralResultFaultTreeIllustrationPointEntityId IS OLD.GeneralResultFaultTreeIllustrationPointEntityId; -END; -; - -CREATE INDEX 'IXFK_MacroStabilityInwardsFailureMechanismMetaEntity_FailureMechanismEntity' - ON 'MacroStabilityInwardsFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) -; - -CREATE INDEX 'IXFK_AssessmentSectionEntity_ProjectEntity' - ON 'AssessmentSectionEntity' ('ProjectEntityId' ASC) -; - -CREATE INDEX 'IXFK_FailureMechanismSectionEntity_FailureMechanismEntity' - ON 'FailureMechanismSectionEntity' ('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_FailureMechanismEntity_AssessmentSectionEntity' - ON 'FailureMechanismEntity' ('AssessmentSectionEntityId' ASC) -; - -CREATE INDEX 'IXFK_FailureMechanismEntity_CalculationGroupEntity' - ON 'FailureMechanismEntity' ('CalculationGroupEntityId' ASC) -; - -CREATE INDEX 'IXFK_PipingFailureMechanismMetaEntity_FailureMechanismEntity' - ON 'PipingFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) -; - -CREATE INDEX 'IXFK_ClosingStructuresFailureMechanismMetaEntity_FailureMechanismEntity' - ON 'ClosingStructuresFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) -; - -CREATE INDEX 'IXFK_StabilityStoneCoverFailureMechanismMetaEntity_FailureMechanismEntity' - ON 'StabilityStoneCoverFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) -; - -CREATE INDEX 'IXFK_CalculationGroupEntity_CalculationGroupEntity' - ON 'CalculationGroupEntity' ('ParentCalculationGroupEntityId' ASC) -; - -CREATE INDEX 'IXFK_StrengthStabilityPointConstructionFailureMechanismMetaEntity_FailureMechanismEntity' - ON 'StabilityPointStructuresFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) -; - -CREATE INDEX 'IXFK_HydraulicLocationEntity_AssessmentSectionEntity' - ON 'HydraulicLocationEntity' ('AssessmentSectionEntityId' ASC) -; - -CREATE INDEX 'IXFK_HydraulicLocationEntity_HydraulicLocationCalculationEntity_DesignWaterLevelCalculationFour' - ON 'HydraulicLocationEntity' ('HydraulicLocationCalculationEntity_DesignWaterLevelCalculationFourId' ASC) -; - -CREATE INDEX 'IXFK_HydraulicLocationEntity_HydraulicLocationCalculationEntity_DesignWaterLevelCalculationOne' - ON 'HydraulicLocationEntity' ('HydraulicLocationCalculationEntity_DesignWaterLevelCalculationOneId' ASC) -; - -CREATE INDEX 'IXFK_HydraulicLocationEntity_HydraulicLocationCalculationEntity_DesignWaterLevelCalculationThree' - ON 'HydraulicLocationEntity' ('HydraulicLocationCalculationEntity_DesignWaterLevelCalculationThreeId' ASC) -; - -CREATE INDEX 'IXFK_HydraulicLocationEntity_HydraulicLocationCalculationEntity_DesignWaterLevelCalculationTwo' - ON 'HydraulicLocationEntity' ('HydraulicLocationCalculationEntity_DesignWaterLevelCalculationTwoId' ASC) -; - -CREATE INDEX 'IXFK_HydraulicLocationEntity_HydraulicLocationCalculationEntity_WaveHeightCalculationFour' - ON 'HydraulicLocationEntity' ('HydraulicLocationCalculationEntity_WaveHeightCalculationFourId' ASC) -; - -CREATE INDEX 'IXFK_HydraulicLocationEntity_HydraulicLocationCalculationEntity_WaveHeightCalculationOne' - ON 'HydraulicLocationEntity' ('HydraulicLocationCalculationEntity_WaveHeightCalculationOneId' ASC) -; - -CREATE INDEX 'IXFK_HydraulicLocationEntity_HydraulicLocationCalculationEntity_WaveHeightCalculationThree' - ON 'HydraulicLocationEntity' ('HydraulicLocationCalculationEntity_WaveHeightCalculationThreeId' ASC) -; - -CREATE INDEX 'IXFK_HydraulicLocationEntity_HydraulicLocationCalculationEntity_WaveHeightCalculationTwo' - ON 'HydraulicLocationEntity' ('HydraulicLocationCalculationEntity_WaveHeightCalculationTwoId' ASC) -; +END; +; + +CREATE INDEX 'IXFK_MacroStabilityInwardsFailureMechanismMetaEntity_FailureMechanismEntity' + ON 'MacroStabilityInwardsFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) +; + +CREATE INDEX 'IXFK_AssessmentSectionEntity_ProjectEntity' + ON 'AssessmentSectionEntity' ('ProjectEntityId' ASC) +; + +CREATE INDEX 'IXFK_FailureMechanismSectionEntity_FailureMechanismEntity' + ON 'FailureMechanismSectionEntity' ('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_FailureMechanismEntity_AssessmentSectionEntity' + ON 'FailureMechanismEntity' ('AssessmentSectionEntityId' ASC) +; + +CREATE INDEX 'IXFK_FailureMechanismEntity_CalculationGroupEntity' + ON 'FailureMechanismEntity' ('CalculationGroupEntityId' ASC) +; + +CREATE INDEX 'IXFK_PipingFailureMechanismMetaEntity_FailureMechanismEntity' + ON 'PipingFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) +; + +CREATE INDEX 'IXFK_ClosingStructuresFailureMechanismMetaEntity_FailureMechanismEntity' + ON 'ClosingStructuresFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) +; + +CREATE INDEX 'IXFK_StabilityStoneCoverFailureMechanismMetaEntity_FailureMechanismEntity' + ON 'StabilityStoneCoverFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) +; + +CREATE INDEX 'IXFK_CalculationGroupEntity_CalculationGroupEntity' + ON 'CalculationGroupEntity' ('ParentCalculationGroupEntityId' ASC) +; + +CREATE INDEX 'IXFK_StrengthStabilityPointConstructionFailureMechanismMetaEntity_FailureMechanismEntity' + ON 'StabilityPointStructuresFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) +; + +CREATE INDEX 'IXFK_HydraulicLocationEntity_AssessmentSectionEntity' + ON 'HydraulicLocationEntity' ('AssessmentSectionEntityId' ASC) +; + +CREATE INDEX 'IXFK_HydraulicLocationEntity_HydraulicLocationCalculationEntity' + ON 'HydraulicLocationEntity' ('HydraulicLocationCalculationEntity1Id' ASC) +; + +CREATE INDEX 'IXFK_HydraulicLocationEntity_HydraulicLocationCalculationEntity_02' + ON 'HydraulicLocationEntity' ('HydraulicLocationCalculationEntity2Id' ASC) +; + +CREATE INDEX 'IXFK_HydraulicLocationEntity_HydraulicLocationCalculationEntity_03' + ON 'HydraulicLocationEntity' ('HydraulicLocationCalculationEntity3Id' ASC) +; + +CREATE INDEX 'IXFK_HydraulicLocationEntity_HydraulicLocationCalculationEntity_04' + ON 'HydraulicLocationEntity' ('HydraulicLocationCalculationEntity4Id' ASC) +; + +CREATE INDEX 'IXFK_HydraulicLocationEntity_HydraulicLocationCalculationEntity_05' + ON 'HydraulicLocationEntity' ('HydraulicLocationCalculationEntity5Id' ASC) +; + +CREATE INDEX 'IXFK_HydraulicLocationEntity_HydraulicLocationCalculationEntity_06' + ON 'HydraulicLocationEntity' ('HydraulicLocationCalculationEntity6Id' ASC) +; + +CREATE INDEX 'IXFK_HydraulicLocationEntity_HydraulicLocationCalculationEntity_07' + ON 'HydraulicLocationEntity' ('HydraulicLocationCalculationEntity7Id' ASC) +; + +CREATE INDEX 'IXFK_HydraulicLocationEntity_HydraulicLocationCalculationEntity_08' + ON 'HydraulicLocationEntity' ('HydraulicLocationCalculationEntity8Id' ASC) +; CREATE TRIGGER [TR_AfterDeleteHydraulicLocationEntity_RemoveHydraulicLocationCalculationEntity_DesignWaterLevelCalculationOne] AFTER DELETE ON HydraulicLocationEntity @@ -2092,9 +2092,9 @@ FROM HydraulicLocationCalculationEntity WHERE OLD.HydraulicLocationDesignWaterLevelCalculationOneEntityId IS NOT NULL AND HydraulicLocationDesignWaterLevelCalculationOneEntityId IS OLD.HydraulicLocationDesignWaterLevelCalculationOneEntityId; -END; -; - +END; +; + CREATE TRIGGER [TR_AfterDeleteHydraulicLocationEntity_RemoveHydraulicLocationCalculationEntity_DesignWaterLevelCalculationTwo] AFTER DELETE ON HydraulicLocationEntity @@ -2104,9 +2104,9 @@ FROM HydraulicLocationCalculationEntity WHERE OLD.HydraulicLocationDesignWaterLevelCalculationTwoEntityId IS NOT NULL AND HydraulicLocationDesignWaterLevelCalculationTwoEntityId IS OLD.HydraulicLocationDesignWaterLevelCalculationTwoEntityId; -END; -; - +END; +; + CREATE TRIGGER [TR_AfterDeleteHydraulicLocationEntity_RemoveHydraulicLocationCalculationEntity_DesignWaterLevelCalculationThree] AFTER DELETE ON HydraulicLocationEntity @@ -2116,9 +2116,9 @@ FROM HydraulicLocationCalculationEntity WHERE OLD.HydraulicLocationDesignWaterLevelCalculationThreeEntityId IS NOT NULL AND HydraulicLocationDesignWaterLevelCalculationThreeEntityId IS OLD.HydraulicLocationDesignWaterLevelCalculationThreeEntityId; -END; -; - +END; +; + CREATE TRIGGER [TR_AfterDeleteHydraulicLocationEntity_RemoveHydraulicLocationCalculationEntity_DesignWaterLevelCalculationFour] AFTER DELETE ON HydraulicLocationEntity @@ -2128,9 +2128,9 @@ FROM HydraulicLocationCalculationEntity WHERE OLD.HydraulicLocationDesignWaterLevelCalculationFourEntityId IS NOT NULL AND HydraulicLocationDesignWaterLevelCalculationFourEntityId IS OLD.HydraulicLocationDesignWaterLevelCalculationFourEntityId; -END; -; - +END; +; + CREATE TRIGGER [TR_AfterDeleteHydraulicLocationEntity_RemoveHydraulicLocationCalculationEntity_WaveHeightCalculationOne] AFTER DELETE ON HydraulicLocationEntity @@ -2140,9 +2140,9 @@ FROM HydraulicLocationCalculationEntity WHERE OLD.HydraulicLocationWaveHeightCalculationOneEntityId IS NOT NULL AND HydraulicLocationWaveHeightCalculationOneEntityId IS OLD.HydraulicLocationWaveHeightCalculationOneEntityId; -END; -; - +END; +; + CREATE TRIGGER [TR_AfterDeleteHydraulicLocationEntity_RemoveHydraulicLocationCalculationEntity_WaveHeightCalculationTwo] AFTER DELETE ON HydraulicLocationEntity @@ -2152,9 +2152,9 @@ FROM HydraulicLocationCalculationEntity WHERE OLD.HydraulicLocationWaveHeightCalculationTwoEntityId IS NOT NULL AND HydraulicLocationWaveHeightCalculationTwoEntityId IS OLD.HydraulicLocationWaveHeightCalculationTwoEntityId; -END; -; - +END; +; + CREATE TRIGGER [TR_AfterDeleteHydraulicLocationEntity_RemoveHydraulicLocationCalculationEntity_WaveHeightCalculationThree] AFTER DELETE ON HydraulicLocationEntity @@ -2164,9 +2164,9 @@ FROM HydraulicLocationCalculationEntity WHERE OLD.HydraulicLocationWaveHeightCalculationThreeEntityId IS NOT NULL AND HydraulicLocationWaveHeightCalculationThreeEntityId IS OLD.HydraulicLocationWaveHeightCalculationThreeEntityId; -END; -; - +END; +; + CREATE TRIGGER [TR_AfterDeleteHydraulicLocationEntity_RemoveHydraulicLocationCalculationEntity_WaveHeightCalculationFour] AFTER DELETE ON HydraulicLocationEntity @@ -2176,184 +2176,184 @@ FROM HydraulicLocationCalculationEntity WHERE OLD.HydraulicLocationWaveHeightCalculationFourEntityId IS NOT NULL AND HydraulicLocationWaveHeightCalculationFourEntityId IS OLD.HydraulicLocationWaveHeightCalculationFourEntityId; -END; -; - -CREATE INDEX 'IXFK_PipingCalculationEntity_PipingStochasticSoilProfileEntity' - ON 'PipingCalculationEntity' ('PipingStochasticSoilProfileEntityId' ASC) -; - -CREATE INDEX 'IXFK_PipingCalculationEntity_SurfaceLineEntity' - ON 'PipingCalculationEntity' ('SurfaceLineEntityId' ASC) -; - -CREATE INDEX 'IXFK_PipingCalculationEntity_HydraulicLocationEntity' - ON 'PipingCalculationEntity' ('HydraulicLocationEntityId' ASC) -; - -CREATE INDEX 'IXFK_PipingCalculationEntity_CalculationGroupEntity' - ON 'PipingCalculationEntity' ('CalculationGroupEntityId' ASC) -; - -CREATE INDEX 'IXFK_GrassCoverErosionInwardsFailureMechanismMetaEntity_FailureMechanismEntity' - ON 'GrassCoverErosionInwardsFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) -; - -CREATE INDEX 'IXFK_DuneErosionFailureMechanismMetaEntity_FailureMechanismEntity' - ON 'DuneErosionFailureMechanismMetaEntity' ('FailureMechanismEntityId' 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_HeightStructuresFailureMechanismMetaEntity_FailureMechanismEntity' - ON 'HeightStructuresFailureMechanismMetaEntity' ('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_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_PipingCalculationOutputEntity_PipingCalculationEntity' - ON 'PipingCalculationOutputEntity' ('PipingCalculationEntityId' ASC) -; - -CREATE INDEX 'IXFK_PipingSemiProbabilisticOutputEntity_PipingCalculationEntity' - ON 'PipingSemiProbabilisticOutputEntity' ('PipingCalculationEntityId' ASC) -; - -CREATE INDEX 'IXFK_PipingSectionResultEntity_FailureMechanismSectionEntity' - ON 'PipingSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) -; - -CREATE INDEX 'IXFK_GrassCoverErosionInwardsSectionResultEntity_FailureMechanismSectionEntity' - ON 'GrassCoverErosionInwardsSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) -; - -CREATE INDEX 'IXFK_GrassCoverErosionInwardsSectionResultEntity_GrassCoverErosionInwardsCalculationEntity' - ON 'GrassCoverErosionInwardsSectionResultEntity' ('GrassCoverErosionInwardsCalculationEntityId' ASC) -; - -CREATE INDEX 'IXFK_HeightStructuresSectionResultEntity_FailureMechanismSectionEntity' - ON 'HeightStructuresSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) -; - -CREATE INDEX 'IXFK_HeightStructuresSectionResultEntity_HeightStructuresCalculationEntity' - ON 'HeightStructuresSectionResultEntity' ('HeightStructuresCalculationEntityId' ASC) -; - -CREATE INDEX 'IXFK_StrengthStabilityLengthwiseConstructionSectionResultEntity_FailureMechanismSectionEntity' - ON 'StrengthStabilityLengthwiseConstructionSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) -; - -CREATE INDEX 'IXFK_TechnicalInnovationSectionResultEntity_FailureMechanismSectionEntity' - ON 'TechnicalInnovationSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) -; - -CREATE INDEX 'IXFK_WaterPressureAsphaltCoverSectionResultEntity_FailureMechanismSectionEntity' - ON 'WaterPressureAsphaltCoverSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) -; - -CREATE INDEX 'IXFK_ClosingStructuresSectionResultEntity_ClosingStructuresCalculationEntity' - ON 'ClosingStructuresSectionResultEntity' ('ClosingStructuresCalculationEntityId' ASC) -; - -CREATE INDEX 'IXFK_ClosingStructuresSectionResultEntity_FailureMechanismSectionEntity' - ON 'ClosingStructuresSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) -; - -CREATE INDEX 'IXFK_GrassCoverErosionOutwardsSectionResultEntity_FailureMechanismSectionEntity' - ON 'GrassCoverErosionOutwardsSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) -; - -CREATE INDEX 'IXFK_GrassCoverSlipOffInwardsSectionResultEntity_FailureMechanismSectionEntity' - ON 'GrassCoverSlipOffInwardsSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) -; - -CREATE INDEX 'IXFK_GrassCoverSlipOffOutwardsSectionResultEntity_FailureMechanismSectionEntity' - ON 'GrassCoverSlipOffOutwardsSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) -; - -CREATE INDEX 'IXFK_MacroStabilityInwardsSectionResultEntity_FailureMechanismSectionEntity' - ON 'MacroStabilityInwardsSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) -; - -CREATE INDEX 'IXFK_MacrostabilityOutwardsSectionResultEntity_FailureMechanismSectionEntity' - ON 'MacrostabilityOutwardsSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) -; - -CREATE INDEX 'IXFK_WaveImpactAsphaltCoverSectionResultEntity_FailureMechanismSectionEntity' - ON 'WaveImpactAsphaltCoverSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) -; - -CREATE INDEX 'IXFK_WaveImpactAsphaltCoverFailureMechanismMetaEntity_FailureMechanismEntity' - ON 'WaveImpactAsphaltCoverFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) -; - -CREATE INDEX 'IXFK_MicrostabilitySectionResultEntity_FailureMechanismSectionEntity' - ON 'MicrostabilitySectionResultEntity' ('FailureMechanismSectionEntityId' ASC) -; - -CREATE INDEX 'IXFK_PipingStructureSectionResultEntity_FailureMechanismSectionEntity' - ON 'PipingStructureSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) -; - -CREATE INDEX 'IXFK_DuneErosionSectionResultEntity_FailureMechanismSectionEntity' - ON 'DuneErosionSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) -; - -CREATE INDEX 'IXFK_StabilityStoneCoverSectionResultEntity_FailureMechanismSectionEntity' - ON 'StabilityStoneCoverSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) -; - -CREATE INDEX 'IXFK_StabilityPointStructuresSectionResultEntity_FailureMechanismSectionEntity' - ON 'StabilityPointStructuresSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) -; - -CREATE INDEX 'IXFK_StabilityPointStructuresSectionResultEntity_StabilityPointStructuresCalculationEntity' - ON 'StabilityPointStructuresSectionResultEntity' ('StabilityPointStructuresCalculationEntityId' ASC) -; - -CREATE INDEX 'IXFK_DikeProfileEntity_FailureMechanismEntity' - ON 'DikeProfileEntity' ('FailureMechanismEntityId' ASC) -; - -CREATE INDEX 'IXFK_GrassCoverErosionInwardsOutputEntity_GeneralResultFaultTreeIllustrationPointEntity' - ON 'GrassCoverErosionInwardsOutputEntity' ('GeneralResultFaultTreeIllustrationPointEntityId' ASC) -; - -CREATE INDEX 'IXFK_GrassCoverErosionInwardsOutputEntity_GrassCoverErosionInwardsCalculationEntity' - ON 'GrassCoverErosionInwardsOutputEntity' ('GrassCoverErosionInwardsCalculationEntityId' ASC) -; +END; +; + +CREATE INDEX 'IXFK_PipingCalculationEntity_PipingStochasticSoilProfileEntity' + ON 'PipingCalculationEntity' ('PipingStochasticSoilProfileEntityId' ASC) +; + +CREATE INDEX 'IXFK_PipingCalculationEntity_SurfaceLineEntity' + ON 'PipingCalculationEntity' ('SurfaceLineEntityId' ASC) +; + +CREATE INDEX 'IXFK_PipingCalculationEntity_HydraulicLocationEntity' + ON 'PipingCalculationEntity' ('HydraulicLocationEntityId' ASC) +; + +CREATE INDEX 'IXFK_PipingCalculationEntity_CalculationGroupEntity' + ON 'PipingCalculationEntity' ('CalculationGroupEntityId' ASC) +; + +CREATE INDEX 'IXFK_GrassCoverErosionInwardsFailureMechanismMetaEntity_FailureMechanismEntity' + ON 'GrassCoverErosionInwardsFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) +; + +CREATE INDEX 'IXFK_DuneErosionFailureMechanismMetaEntity_FailureMechanismEntity' + ON 'DuneErosionFailureMechanismMetaEntity' ('FailureMechanismEntityId' 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_HeightStructuresFailureMechanismMetaEntity_FailureMechanismEntity' + ON 'HeightStructuresFailureMechanismMetaEntity' ('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_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_PipingCalculationOutputEntity_PipingCalculationEntity' + ON 'PipingCalculationOutputEntity' ('PipingCalculationEntityId' ASC) +; + +CREATE INDEX 'IXFK_PipingSemiProbabilisticOutputEntity_PipingCalculationEntity' + ON 'PipingSemiProbabilisticOutputEntity' ('PipingCalculationEntityId' ASC) +; + +CREATE INDEX 'IXFK_PipingSectionResultEntity_FailureMechanismSectionEntity' + ON 'PipingSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) +; + +CREATE INDEX 'IXFK_GrassCoverErosionInwardsSectionResultEntity_FailureMechanismSectionEntity' + ON 'GrassCoverErosionInwardsSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) +; + +CREATE INDEX 'IXFK_GrassCoverErosionInwardsSectionResultEntity_GrassCoverErosionInwardsCalculationEntity' + ON 'GrassCoverErosionInwardsSectionResultEntity' ('GrassCoverErosionInwardsCalculationEntityId' ASC) +; + +CREATE INDEX 'IXFK_HeightStructuresSectionResultEntity_FailureMechanismSectionEntity' + ON 'HeightStructuresSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) +; + +CREATE INDEX 'IXFK_HeightStructuresSectionResultEntity_HeightStructuresCalculationEntity' + ON 'HeightStructuresSectionResultEntity' ('HeightStructuresCalculationEntityId' ASC) +; + +CREATE INDEX 'IXFK_StrengthStabilityLengthwiseConstructionSectionResultEntity_FailureMechanismSectionEntity' + ON 'StrengthStabilityLengthwiseConstructionSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) +; + +CREATE INDEX 'IXFK_TechnicalInnovationSectionResultEntity_FailureMechanismSectionEntity' + ON 'TechnicalInnovationSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) +; + +CREATE INDEX 'IXFK_WaterPressureAsphaltCoverSectionResultEntity_FailureMechanismSectionEntity' + ON 'WaterPressureAsphaltCoverSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) +; + +CREATE INDEX 'IXFK_ClosingStructuresSectionResultEntity_ClosingStructuresCalculationEntity' + ON 'ClosingStructuresSectionResultEntity' ('ClosingStructuresCalculationEntityId' ASC) +; + +CREATE INDEX 'IXFK_ClosingStructuresSectionResultEntity_FailureMechanismSectionEntity' + ON 'ClosingStructuresSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) +; + +CREATE INDEX 'IXFK_GrassCoverErosionOutwardsSectionResultEntity_FailureMechanismSectionEntity' + ON 'GrassCoverErosionOutwardsSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) +; + +CREATE INDEX 'IXFK_GrassCoverSlipOffInwardsSectionResultEntity_FailureMechanismSectionEntity' + ON 'GrassCoverSlipOffInwardsSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) +; + +CREATE INDEX 'IXFK_GrassCoverSlipOffOutwardsSectionResultEntity_FailureMechanismSectionEntity' + ON 'GrassCoverSlipOffOutwardsSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) +; + +CREATE INDEX 'IXFK_MacroStabilityInwardsSectionResultEntity_FailureMechanismSectionEntity' + ON 'MacroStabilityInwardsSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) +; + +CREATE INDEX 'IXFK_MacrostabilityOutwardsSectionResultEntity_FailureMechanismSectionEntity' + ON 'MacrostabilityOutwardsSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) +; + +CREATE INDEX 'IXFK_WaveImpactAsphaltCoverSectionResultEntity_FailureMechanismSectionEntity' + ON 'WaveImpactAsphaltCoverSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) +; + +CREATE INDEX 'IXFK_WaveImpactAsphaltCoverFailureMechanismMetaEntity_FailureMechanismEntity' + ON 'WaveImpactAsphaltCoverFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) +; + +CREATE INDEX 'IXFK_MicrostabilitySectionResultEntity_FailureMechanismSectionEntity' + ON 'MicrostabilitySectionResultEntity' ('FailureMechanismSectionEntityId' ASC) +; + +CREATE INDEX 'IXFK_PipingStructureSectionResultEntity_FailureMechanismSectionEntity' + ON 'PipingStructureSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) +; + +CREATE INDEX 'IXFK_DuneErosionSectionResultEntity_FailureMechanismSectionEntity' + ON 'DuneErosionSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) +; + +CREATE INDEX 'IXFK_StabilityStoneCoverSectionResultEntity_FailureMechanismSectionEntity' + ON 'StabilityStoneCoverSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) +; + +CREATE INDEX 'IXFK_StabilityPointStructuresSectionResultEntity_FailureMechanismSectionEntity' + ON 'StabilityPointStructuresSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) +; + +CREATE INDEX 'IXFK_StabilityPointStructuresSectionResultEntity_StabilityPointStructuresCalculationEntity' + ON 'StabilityPointStructuresSectionResultEntity' ('StabilityPointStructuresCalculationEntityId' ASC) +; + +CREATE INDEX 'IXFK_DikeProfileEntity_FailureMechanismEntity' + ON 'DikeProfileEntity' ('FailureMechanismEntityId' ASC) +; + +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 @@ -2363,68 +2363,68 @@ FROM GeneralResultFaultTreeIllustrationPointEntity WHERE OLD.GeneralResultFaultTreeIllustrationPointEntityId IS NOT NULL AND GeneralResultFaultTreeIllustrationPointEntityId IS OLD.GeneralResultFaultTreeIllustrationPointEntityId; -END; -; - -CREATE INDEX 'IXFK_ForeshoreProfileEntity_FailureMechanismEntity' - ON 'ForeshoreProfileEntity' ('FailureMechanismEntityId' ASC) -; - -CREATE INDEX 'IXFK_StabilityStoneCoverWaveConditionsCalculationEntity_CalculationGroupEntity' - ON 'StabilityStoneCoverWaveConditionsCalculationEntity' ('CalculationGroupEntityId' ASC) -; - -CREATE INDEX 'IXFK_StabilityStoneCoverWaveConditionsCalculationEntity_ForeshoreProfileEntity' - ON 'StabilityStoneCoverWaveConditionsCalculationEntity' ('ForeshoreProfileEntityId' ASC) -; - -CREATE INDEX 'IXFK_StabilityStoneCoverWaveConditionsCalculationEntity_HydraulicLocationEntity' - ON 'StabilityStoneCoverWaveConditionsCalculationEntity' ('HydraulicLocationEntityId' ASC) -; - -CREATE INDEX 'IXFK_StabilityStoneCoverWaveConditionsOutputEntity_StabilityStoneCoverWaveConditionsCalculationEntity' - ON 'StabilityStoneCoverWaveConditionsOutputEntity' ('StabilityStoneCoverWaveConditionsCalculationEntityId' ASC) -; - -CREATE INDEX 'IXFK_WaveImpactAsphaltCoverWaveConditionsCalculationEntity_CalculationGroupEntity' - ON 'WaveImpactAsphaltCoverWaveConditionsCalculationEntity' ('CalculationGroupEntityId' ASC) -; - -CREATE INDEX 'IXFK_WaveImpactAsphaltCoverWaveConditionsCalculationEntity_ForeshoreProfileEntity' - ON 'WaveImpactAsphaltCoverWaveConditionsCalculationEntity' ('ForeshoreProfileEntityId' ASC) -; - -CREATE INDEX 'IXFK_WaveImpactAsphaltCoverWaveConditionsCalculationEntity_HydraulicLocationEntity' - ON 'WaveImpactAsphaltCoverWaveConditionsCalculationEntity' ('HydraulicLocationEntityId' ASC) -; - -CREATE INDEX 'IXFK_WaveImpactAsphaltCoverWaveConditionsOutputEntity_WaveImpactAsphaltCoverWaveConditionsCalculationEntity' - ON 'WaveImpactAsphaltCoverWaveConditionsOutputEntity' ('WaveImpactAsphaltCoverWaveConditionsCalculationEntityId' ASC) -; - -CREATE INDEX 'IXFK_GrassCoverErosionOutwardsWaveConditionsCalculationEntity_CalculationGroupEntity' - ON 'GrassCoverErosionOutwardsWaveConditionsCalculationEntity' ('CalculationGroupEntityId' ASC) -; - -CREATE INDEX 'IXFK_GrassCoverErosionOutwardsWaveConditionsCalculationEntity_ForeshoreProfileEntity' - ON 'GrassCoverErosionOutwardsWaveConditionsCalculationEntity' ('ForeshoreProfileEntityId' ASC) -; - -CREATE INDEX 'IXFK_GrassCoverErosionOutwardsWaveConditionsCalculationEntity_GrassCoverErosionOutwardsHydraulicLocationEntity' - ON 'GrassCoverErosionOutwardsWaveConditionsCalculationEntity' ('GrassCoverErosionOutwardsHydraulicLocationEntityId' ASC) -; - -CREATE INDEX 'IXFK_GrassCoverErosionOutwardsHydraulicLocationEntity_FailureMechanismEntity' - ON 'GrassCoverErosionOutwardsHydraulicLocationEntity' ('FailureMechanismEntityId' ASC) -; - -CREATE INDEX 'IXFK_GrassCoverErosionOutwardsWaveConditionsOutputEntity_GrassCoverErosionOutwardsWaveConditionsCalculationEntity' - ON 'GrassCoverErosionOutwardsWaveConditionsOutputEntity' ('GrassCoverErosionOutwardsWaveConditionsCalculationEntityId' ASC) -; - -CREATE INDEX 'IXFK_HeightStructuresOutputEntity_HeightStructuresCalculationEntity' - ON 'HeightStructuresOutputEntity' ('HeightStructuresCalculationEntityId' ASC) -; +END; +; + +CREATE INDEX 'IXFK_ForeshoreProfileEntity_FailureMechanismEntity' + ON 'ForeshoreProfileEntity' ('FailureMechanismEntityId' ASC) +; + +CREATE INDEX 'IXFK_StabilityStoneCoverWaveConditionsCalculationEntity_CalculationGroupEntity' + ON 'StabilityStoneCoverWaveConditionsCalculationEntity' ('CalculationGroupEntityId' ASC) +; + +CREATE INDEX 'IXFK_StabilityStoneCoverWaveConditionsCalculationEntity_ForeshoreProfileEntity' + ON 'StabilityStoneCoverWaveConditionsCalculationEntity' ('ForeshoreProfileEntityId' ASC) +; + +CREATE INDEX 'IXFK_StabilityStoneCoverWaveConditionsCalculationEntity_HydraulicLocationEntity' + ON 'StabilityStoneCoverWaveConditionsCalculationEntity' ('HydraulicLocationEntityId' ASC) +; + +CREATE INDEX 'IXFK_StabilityStoneCoverWaveConditionsOutputEntity_StabilityStoneCoverWaveConditionsCalculationEntity' + ON 'StabilityStoneCoverWaveConditionsOutputEntity' ('StabilityStoneCoverWaveConditionsCalculationEntityId' ASC) +; + +CREATE INDEX 'IXFK_WaveImpactAsphaltCoverWaveConditionsCalculationEntity_CalculationGroupEntity' + ON 'WaveImpactAsphaltCoverWaveConditionsCalculationEntity' ('CalculationGroupEntityId' ASC) +; + +CREATE INDEX 'IXFK_WaveImpactAsphaltCoverWaveConditionsCalculationEntity_ForeshoreProfileEntity' + ON 'WaveImpactAsphaltCoverWaveConditionsCalculationEntity' ('ForeshoreProfileEntityId' ASC) +; + +CREATE INDEX 'IXFK_WaveImpactAsphaltCoverWaveConditionsCalculationEntity_HydraulicLocationEntity' + ON 'WaveImpactAsphaltCoverWaveConditionsCalculationEntity' ('HydraulicLocationEntityId' ASC) +; + +CREATE INDEX 'IXFK_WaveImpactAsphaltCoverWaveConditionsOutputEntity_WaveImpactAsphaltCoverWaveConditionsCalculationEntity' + ON 'WaveImpactAsphaltCoverWaveConditionsOutputEntity' ('WaveImpactAsphaltCoverWaveConditionsCalculationEntityId' ASC) +; + +CREATE INDEX 'IXFK_GrassCoverErosionOutwardsWaveConditionsCalculationEntity_CalculationGroupEntity' + ON 'GrassCoverErosionOutwardsWaveConditionsCalculationEntity' ('CalculationGroupEntityId' ASC) +; + +CREATE INDEX 'IXFK_GrassCoverErosionOutwardsWaveConditionsCalculationEntity_ForeshoreProfileEntity' + ON 'GrassCoverErosionOutwardsWaveConditionsCalculationEntity' ('ForeshoreProfileEntityId' ASC) +; + +CREATE INDEX 'IXFK_GrassCoverErosionOutwardsWaveConditionsCalculationEntity_GrassCoverErosionOutwardsHydraulicLocationEntity' + ON 'GrassCoverErosionOutwardsWaveConditionsCalculationEntity' ('GrassCoverErosionOutwardsHydraulicLocationEntityId' ASC) +; + +CREATE INDEX 'IXFK_GrassCoverErosionOutwardsHydraulicLocationEntity_FailureMechanismEntity' + ON 'GrassCoverErosionOutwardsHydraulicLocationEntity' ('FailureMechanismEntityId' ASC) +; + +CREATE INDEX 'IXFK_GrassCoverErosionOutwardsWaveConditionsOutputEntity_GrassCoverErosionOutwardsWaveConditionsCalculationEntity' + ON 'GrassCoverErosionOutwardsWaveConditionsOutputEntity' ('GrassCoverErosionOutwardsWaveConditionsCalculationEntityId' ASC) +; + +CREATE INDEX 'IXFK_HeightStructuresOutputEntity_HeightStructuresCalculationEntity' + ON 'HeightStructuresOutputEntity' ('HeightStructuresCalculationEntityId' ASC) +; CREATE TRIGGER [TR_AfterDeleteHeightStructuresOutputEntity_RemoveGeneralResultFaultTreeIllustrationPointEntity] AFTER DELETE ON HeightStructuresOutputEntity @@ -2434,52 +2434,52 @@ FROM GeneralResultFaultTreeIllustrationPointEntity WHERE OLD.GeneralResultFaultTreeIllustrationPointEntityId IS NOT NULL AND GeneralResultFaultTreeIllustrationPointEntityId IS OLD.GeneralResultFaultTreeIllustrationPointEntityId; -END; -; - -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_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) -; +END; +; + +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_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 @@ -2489,16 +2489,16 @@ FROM GeneralResultFaultTreeIllustrationPointEntity WHERE OLD.GeneralResultFaultTreeIllustrationPointEntityId IS NOT NULL AND GeneralResultFaultTreeIllustrationPointEntityId IS OLD.GeneralResultFaultTreeIllustrationPointEntityId; -END; -; - -CREATE INDEX 'IXFK_StabilityPointStructureEntity_FailureMechanismEntity' - ON 'StabilityPointStructureEntity' ('FailureMechanismEntityId' ASC) -; - -CREATE INDEX 'IXFK_StabilityPointStructuresOutputEntity_StabilityPointStructuresCalculationEntity' - ON 'StabilityPointStructuresOutputEntity' ('StabilityPointStructuresCalculationEntityId' ASC) -; +END; +; + +CREATE INDEX 'IXFK_StabilityPointStructureEntity_FailureMechanismEntity' + ON 'StabilityPointStructureEntity' ('FailureMechanismEntityId' ASC) +; + +CREATE INDEX 'IXFK_StabilityPointStructuresOutputEntity_StabilityPointStructuresCalculationEntity' + ON 'StabilityPointStructuresOutputEntity' ('StabilityPointStructuresCalculationEntityId' ASC) +; CREATE TRIGGER [TR_AfterDeleteStabilityPointStructuresOutputEntity_RemoveGeneralResultFaultTreeIllustrationPointEntity] AFTER DELETE ON StabilityPointStructuresOutputEntity @@ -2508,16 +2508,16 @@ FROM GeneralResultFaultTreeIllustrationPointEntity WHERE OLD.GeneralResultFaultTreeIllustrationPointEntityId IS NOT NULL AND GeneralResultFaultTreeIllustrationPointEntityId IS OLD.GeneralResultFaultTreeIllustrationPointEntityId; -END; -; - -CREATE INDEX 'IXFK_HydraulicLocationOutputEntity_GeneralResultSubMechanismIllustrationPointEntity' - ON 'HydraulicLocationOutputEntity' ('GeneralResultSubMechanismIllustrationPointEntityId' ASC) -; - -CREATE INDEX 'IXFK_HydraulicLocationOutputEntity_HydraulicLocationCalculationEntity' - ON 'HydraulicLocationOutputEntity' ('HydraulicLocationCalculationEntityId' ASC) -; +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 @@ -2527,16 +2527,16 @@ FROM GeneralResultSubMechanismIllustrationPointEntity WHERE OLD.GeneralResultSubMechanismIllustrationPointEntityId IS NOT NULL AND GeneralResultSubMechanismIllustrationPointEntityId IS OLD.GeneralResultSubMechanismIllustrationPointEntityId; -END; -; - -CREATE INDEX 'IXFK_GrassCoverErosionOutwardsHydraulicLocationOutputEntity_GeneralResultSubMechanismIllustrationPointEntity' - ON 'GrassCoverErosionOutwardsHydraulicLocationOutputEntity' ('GeneralResultSubMechanismIllustrationPointEntityId' ASC) -; - -CREATE INDEX 'IXFK_GrassCoverErosionOutwardsHydraulicLocationOutputEntity_GrassCoverErosionOutwardsHydraulicLocationEntity' - ON 'GrassCoverErosionOutwardsHydraulicLocationOutputEntity' ('GrassCoverErosionOutwardsHydraulicLocationEntityId' ASC) -; +END; +; + +CREATE INDEX 'IXFK_GrassCoverErosionOutwardsHydraulicLocationOutputEntity_GeneralResultSubMechanismIllustrationPointEntity' + ON 'GrassCoverErosionOutwardsHydraulicLocationOutputEntity' ('GeneralResultSubMechanismIllustrationPointEntityId' ASC) +; + +CREATE INDEX 'IXFK_GrassCoverErosionOutwardsHydraulicLocationOutputEntity_GrassCoverErosionOutwardsHydraulicLocationEntity' + ON 'GrassCoverErosionOutwardsHydraulicLocationOutputEntity' ('GrassCoverErosionOutwardsHydraulicLocationEntityId' ASC) +; CREATE TRIGGER [TR_AfterDeleteGrassCoverErosionOutwardsHydraulicLocationOutputEntity_RemoveGeneralResultSubMechanismIllustrationPointEntity] AFTER DELETE ON GrassCoverErosionOutwardsHydraulicLocationOutputEntity @@ -2546,32 +2546,32 @@ FROM GeneralResultSubMechanismIllustrationPointEntity WHERE OLD.GeneralResultSubMechanismIllustrationPointEntityId IS NOT NULL AND GeneralResultSubMechanismIllustrationPointEntityId IS OLD.GeneralResultSubMechanismIllustrationPointEntityId; -END; -; - -CREATE INDEX 'IXFK_DuneLocationEntity_FailureMechanismEntity' - ON 'DuneLocationEntity' ('FailureMechanismEntityId' ASC) -; - -CREATE INDEX 'IXFK_DuneLocationOutputEntity_DuneLocationEntity' - ON 'DuneLocationOutputEntity' ('DuneLocationEntityId' ASC) -; - -CREATE INDEX 'IXFK_BackgroundDataEntity_AssessmentSectionEntity' - ON 'BackgroundDataEntity' ('AssessmentSectionEntityId' ASC) -; - -CREATE INDEX 'IXFK_BackgroundDataMetaEntity_BackgroundDataEntity' - ON 'BackgroundDataMetaEntity' ('BackgroundDataEntityId' ASC) -; - -CREATE INDEX 'IXFK_GrassCoverErosionInwardsOvertoppingRateOutputEntity_GeneralResultFaultTreeIllustrationPointEntity' - ON 'GrassCoverErosionInwardsOvertoppingRateOutputEntity' ('GeneralResultFaultTreeIllustrationPointEntityId' ASC) -; - -CREATE INDEX 'IXFK_GrassCoverErosionInwardsOvertoppingRateOutputEntity_GrassCoverErosionInwardsOutputEntity' - ON 'GrassCoverErosionInwardsOvertoppingRateOutputEntity' ('GrassCoverErosionInwardsOutputEntityId' ASC) -; +END; +; + +CREATE INDEX 'IXFK_DuneLocationEntity_FailureMechanismEntity' + ON 'DuneLocationEntity' ('FailureMechanismEntityId' ASC) +; + +CREATE INDEX 'IXFK_DuneLocationOutputEntity_DuneLocationEntity' + ON 'DuneLocationOutputEntity' ('DuneLocationEntityId' ASC) +; + +CREATE INDEX 'IXFK_BackgroundDataEntity_AssessmentSectionEntity' + ON 'BackgroundDataEntity' ('AssessmentSectionEntityId' ASC) +; + +CREATE INDEX 'IXFK_BackgroundDataMetaEntity_BackgroundDataEntity' + ON 'BackgroundDataMetaEntity' ('BackgroundDataEntityId' ASC) +; + +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 @@ -2581,20 +2581,20 @@ FROM GeneralResultFaultTreeIllustrationPointEntity WHERE OLD.GeneralResultFaultTreeIllustrationPointEntityId IS NOT NULL AND GeneralResultFaultTreeIllustrationPointEntityId IS OLD.GeneralResultFaultTreeIllustrationPointEntityId; -END; -; - -CREATE INDEX 'IXFK_IllustrationPointResultEntity_SubMechanismIllustrationPointEntity' - ON 'IllustrationPointResultEntity' ('SubMechanismIllustrationPointEntityId' ASC) -; - -CREATE INDEX 'IXFK_GeneralResultSubMechanismIllustrationPointStochastEntity_GeneralResultSubMechanismIllustrationPointEntity' - ON 'GeneralResultSubMechanismIllustrationPointStochastEntity' ('GeneralResultSubMechanismIllustrationPointEntityId' ASC) -; - -CREATE INDEX 'IXFK_GeneralResultSubMechanismIllustrationPointStochastEntity_StochastEntity' - ON 'GeneralResultSubMechanismIllustrationPointStochastEntity' ('StochastEntityId' ASC) -; +END; +; + +CREATE INDEX 'IXFK_IllustrationPointResultEntity_SubMechanismIllustrationPointEntity' + ON 'IllustrationPointResultEntity' ('SubMechanismIllustrationPointEntityId' ASC) +; + +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 @@ -2604,20 +2604,20 @@ FROM StochastEntity WHERE OLD.StochastEntityId IS NOT NULL AND StochastEntityId IS OLD.StochastEntityId; -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) -; +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 @@ -2627,16 +2627,16 @@ FROM StochastEntity WHERE OLD.StochastEntityId IS NOT NULL AND StochastEntityId IS OLD.StochastEntityId; -END; -; - -CREATE INDEX 'IXFK_GeneralResultFaultTreeIllustrationPointStochastEntity_GeneralResultFaultTreeIllustrationPointEntity' - ON 'GeneralResultFaultTreeIllustrationPointStochastEntity' ('GeneralResultFaultTreeIllustrationPointEntityId' ASC) -; - -CREATE INDEX 'IXFK_GeneralResultFaultTreeIllustrationPointStochastEntity_StochastEntity' - ON 'GeneralResultFaultTreeIllustrationPointStochastEntity' ('StochastEntityId' ASC) -; +END; +; + +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 @@ -2646,16 +2646,16 @@ FROM StochastEntity WHERE OLD.StochastEntityId IS NOT NULL AND StochastEntityId IS OLD.StochastEntityId; -END; -; - -CREATE INDEX 'IXFK_TopLevelSubMechanismIllustrationPointEntity_GeneralResultSubMechanismIllustrationPointEntity' - ON 'TopLevelSubMechanismIllustrationPointEntity' ('GeneralResultSubMechanismIllustrationPointEntityId' ASC) -; - -CREATE INDEX 'IXFK_TopLevelSubMechanismIllustrationPointEntity_SubMechanismIllustrationPointEntity' - ON 'TopLevelSubMechanismIllustrationPointEntity' ('SubMechanismIllustrationPointEntityId' ASC) -; +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 @@ -2665,16 +2665,16 @@ FROM SubMechanismIllustrationPointEntity WHERE OLD.SubMechanismIllustrationPointEntityId IS NOT NULL AND SubMechanismIllustrationPointEntityId IS OLD.SubMechanismIllustrationPointEntityId; -END; -; - -CREATE INDEX 'IXFK_TopLevelFaultTreeIllustrationPointEntity_FaultTreeIllustrationPointEntity' - ON 'TopLevelFaultTreeIllustrationPointEntity' ('FaultTreeIllustrationPointEntityId' ASC) -; - -CREATE INDEX 'IXFK_TopLevelFaultTreeIllustrationPointEntity_GeneralResultFaultTreeIllustrationPointEntity' - ON 'TopLevelFaultTreeIllustrationPointEntity' ('GeneralResultFaultTreeIllustrationPointEntityId' ASC) -; +END; +; + +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 @@ -2684,20 +2684,20 @@ FROM FaultTreeIllustrationPointEntity WHERE OLD.FaultTreeIllustrationPointEntityId IS NOT NULL AND FaultTreeIllustrationPointEntityId IS OLD.FaultTreeIllustrationPointEntityId; -END; -; - -CREATE INDEX 'IXFK_SubMechanismIllustrationPointStochast_SubMechanismIllustrationPointEntity' - ON 'SubMechanismIllustrationPointStochastEntity' ('SubMechanismIllustrationPointEntityId' ASC) -; - -CREATE INDEX 'IXFK_FaultTreeIllustrationPointEntity_FaultTreeIllustrationPointEntity' - ON 'FaultTreeSubmechanismIllustrationPointEntity' ('FaultTreeIllustrationPointEntityId' ASC) -; - -CREATE INDEX 'IXFK_FaultTreeIllustrationPointEntity_SubMechanismIllustrationPointEntity' - ON 'FaultTreeSubmechanismIllustrationPointEntity' ('SubMechanismIllustrationPointEntityId' ASC) -; +END; +; + +CREATE INDEX 'IXFK_SubMechanismIllustrationPointStochast_SubMechanismIllustrationPointEntity' + ON 'SubMechanismIllustrationPointStochastEntity' ('SubMechanismIllustrationPointEntityId' ASC) +; + +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 @@ -2707,36 +2707,36 @@ FROM SubmechanismIllustrationPointEntity WHERE OLD.SubmechanismIllustrationPointEntityId IS NOT NULL AND SubmechanismIllustrationPointEntityId IS OLD.SubmechanismIllustrationPointEntityId; -END; -; - -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_MacroStabilityInwardsSoilLayerOneDEntity_MacroStabilityInwardsSoilProfileOneDEntity' - ON 'MacroStabilityInwardsSoilLayerOneDEntity' ('MacroStabilityInwardsSoilProfileOneDEntityId' ASC) -; - -CREATE INDEX 'IXFK_MacroStabilityInwardsStochasticSoilProfileEntity_StochasticSoilModelEntity' - ON 'MacroStabilityInwardsStochasticSoilProfileEntity' ('StochasticSoilModelEntityId' ASC) -; +END; +; + +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_MacroStabilityInwardsSoilLayerOneDEntity_MacroStabilityInwardsSoilProfileOneDEntity' + ON 'MacroStabilityInwardsSoilLayerOneDEntity' ('MacroStabilityInwardsSoilProfileOneDEntityId' ASC) +; + +CREATE INDEX 'IXFK_MacroStabilityInwardsStochasticSoilProfileEntity_StochasticSoilModelEntity' + ON 'MacroStabilityInwardsStochasticSoilProfileEntity' ('StochasticSoilModelEntityId' ASC) +; CREATE TRIGGER [TR_BeforeInsertMacroStabilityInwardsStochasticSoilProfileEntity_MustHaveOneDOrTwoD] BEFORE INSERT ON MacroStabilityInwardsStochasticSoilProfileEntity @@ -2752,9 +2752,9 @@ ) THEN RAISE(FAIL, 'Either SoilProfile1D or SoilProfile2D must be set.') END; -END; -; - +END; +; + CREATE TRIGGER [TR_BeforeUpdateMacroStabilityInwardsStochasticSoilProfileEntity_MustHaveOneDOrTwoD] BEFORE UPDATE ON MacroStabilityInwardsStochasticSoilProfileEntity @@ -2770,9 +2770,9 @@ ) THEN RAISE(FAIL, 'Either SoilProfile1D or SoilProfile2D must be set.') END; -END; -; - +END; +; + CREATE TRIGGER [TR_AfterDeleteMacroStabilityInwardsSoilProfileTwoDEntity_MacroStabilityInwardsSoilLayerTwoDEntity] AFTER DELETE ON MacroStabilityInwardsSoilProfileTwoDEntity @@ -2782,9 +2782,9 @@ FROM MacroStabilityInwardsSoilLayerTwoDEntity WHERE OLD.MacroStabilityInwardsSoilLayerTwoDEntity IS NOT NULL AND MacroStabilityInwardsSoilLayerTwoDEntity IS OLD.MacroStabilityInwardsSoilLayerTwoDEntity; -END; -; - -CREATE INDEX 'IXFK_HydraRingPreprocessorEntity_AssessmentSectionEntity' - ON 'HydraRingPreprocessorEntity' ('AssessmentSectionEntityId' ASC) -; +END; +; + +CREATE INDEX 'IXFK_HydraRingPreprocessorEntity_AssessmentSectionEntity' + ON 'HydraRingPreprocessorEntity' ('AssessmentSectionEntityId' ASC) +; Index: design/DatabaseDesign.eap =================================================================== diff -u -r33b1979ea5681dcaef595262bbe14e5c274fdfc2 -rc43e60dc31027ef84a70ecc2c252e028dd8888c5 Binary files differ