Index: build/DatabaseStructure.sql =================================================================== diff -u -rcbe0f46c3f469b6cd35d696c1973061dc97fa334 -r9c42e1da04df136bcc1c819bd5c32b9a23528304 --- build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision cbe0f46c3f469b6cd35d696c1973061dc97fa334) +++ build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 9c42e1da04df136bcc1c819bd5c32b9a23528304) @@ -1,6 +1,6 @@ /* ---------------------------------------------------- */ /* Generated by Enterprise Architect Version 14.1 */ -/* Created On : 31-mrt-2022 14:02:52 */ +/* Created On : 05-apr-2022 09:30:38 */ /* DBMS : SQLite */ /* ---------------------------------------------------- */ @@ -36,28 +36,28 @@ DROP TABLE IF EXISTS 'SemiProbabilisticPipingCalculationEntity' ; -DROP TABLE IF EXISTS 'GrassCoverSlipOffInwardsFailureMechanismMetaEntity' +DROP TABLE IF EXISTS 'GrassCoverErosionInwardsCalculationEntity' ; -DROP TABLE IF EXISTS 'GrassCoverErosionInwardsCalculationEntity' +DROP TABLE IF EXISTS 'GrassCoverSlipOffInwardsFailureMechanismMetaEntity' ; DROP TABLE IF EXISTS 'GrassCoverErosionOutwardsFailureMechanismMetaEntity' ; -DROP TABLE IF EXISTS 'PipingSoilProfileEntity' +DROP TABLE IF EXISTS 'PipingSoilLayerEntity' ; -DROP TABLE IF EXISTS 'PipingSoilLayerEntity' +DROP TABLE IF EXISTS 'PipingSoilProfileEntity' ; DROP TABLE IF EXISTS 'PipingStochasticSoilProfileEntity' ; -DROP TABLE IF EXISTS 'StochasticSoilModelEntity' +DROP TABLE IF EXISTS 'PipingScenarioConfigurationPerFailureMechanismSectionEntity' ; -DROP TABLE IF EXISTS 'PipingScenarioConfigurationPerFailureMechanismSectionEntity' +DROP TABLE IF EXISTS 'StochasticSoilModelEntity' ; DROP TABLE IF EXISTS 'SurfaceLineEntity' @@ -72,6 +72,12 @@ DROP TABLE IF EXISTS 'WaveImpactAsphaltCoverFailureMechanismMetaEntity' ; +DROP TABLE IF EXISTS 'AdoptableFailureMechanismSectionResultEntity' +; + +DROP TABLE IF EXISTS 'AdoptableWithProfileProbabilityFailureMechanismSectionResultEntity' +; + DROP TABLE IF EXISTS 'BackgroundDataEntity' ; @@ -87,18 +93,12 @@ DROP TABLE IF EXISTS 'ClosingStructuresOutputEntity' ; -DROP TABLE IF EXISTS 'ClosingStructuresSectionResultEntity' -; - DROP TABLE IF EXISTS 'DikeProfileEntity' ; DROP TABLE IF EXISTS 'DuneErosionFailureMechanismMetaEntity' ; -DROP TABLE IF EXISTS 'DuneErosionSectionResultEntity' -; - DROP TABLE IF EXISTS 'DuneLocationCalculationEntity' ; @@ -147,27 +147,15 @@ DROP TABLE IF EXISTS 'GrassCoverErosionInwardsOvertoppingRateOutputEntity' ; -DROP TABLE IF EXISTS 'GrassCoverErosionInwardsSectionResultEntity' -; - -DROP TABLE IF EXISTS 'GrassCoverErosionOutwardsSectionResultEntity' -; - DROP TABLE IF EXISTS 'GrassCoverErosionOutwardsWaveConditionsCalculationEntity' ; DROP TABLE IF EXISTS 'GrassCoverErosionOutwardsWaveConditionsOutputEntity' ; -DROP TABLE IF EXISTS 'GrassCoverSlipOffInwardsSectionResultEntity' -; - DROP TABLE IF EXISTS 'GrassCoverSlipOffOutwardsFailureMechanismMetaEntity' ; -DROP TABLE IF EXISTS 'GrassCoverSlipOffOutwardsSectionResultEntity' -; - DROP TABLE IF EXISTS 'HeightStructureEntity' ; @@ -180,9 +168,6 @@ DROP TABLE IF EXISTS 'HeightStructuresOutputEntity' ; -DROP TABLE IF EXISTS 'HeightStructuresSectionResultEntity' -; - DROP TABLE IF EXISTS 'HydraulicBoundaryDatabaseEntity' ; @@ -222,9 +207,6 @@ DROP TABLE IF EXISTS 'MacroStabilityInwardsPreconsolidationStressEntity' ; -DROP TABLE IF EXISTS 'MacroStabilityInwardsSectionResultEntity' -; - DROP TABLE IF EXISTS 'MacroStabilityInwardsSoilLayerOneDEntity' ; @@ -246,7 +228,7 @@ DROP TABLE IF EXISTS 'MicrostabilityFailureMechanismMetaEntity' ; -DROP TABLE IF EXISTS 'MicrostabilitySectionResultEntity' +DROP TABLE IF EXISTS 'NonAdoptableFailureMechanismSectionResultEntity' ; DROP TABLE IF EXISTS 'NonAdoptableWithProfileProbabilityFailureMechanismSectionResultEntity' @@ -255,15 +237,9 @@ DROP TABLE IF EXISTS 'PipingFailureMechanismMetaEntity' ; -DROP TABLE IF EXISTS 'PipingSectionResultEntity' -; - DROP TABLE IF EXISTS 'PipingStructureFailureMechanismMetaEntity' ; -DROP TABLE IF EXISTS 'PipingStructureSectionResultEntity' -; - DROP TABLE IF EXISTS 'ProbabilisticPipingCalculationEntity' ; @@ -291,15 +267,9 @@ DROP TABLE IF EXISTS 'StabilityPointStructuresOutputEntity' ; -DROP TABLE IF EXISTS 'StabilityPointStructuresSectionResultEntity' -; - DROP TABLE IF EXISTS 'StabilityStoneCoverFailureMechanismMetaEntity' ; -DROP TABLE IF EXISTS 'StabilityStoneCoverSectionResultEntity' -; - DROP TABLE IF EXISTS 'StabilityStoneCoverWaveConditionsCalculationEntity' ; @@ -321,12 +291,6 @@ DROP TABLE IF EXISTS 'TopLevelSubMechanismIllustrationPointEntity' ; -DROP TABLE IF EXISTS 'WaterPressureAsphaltCoverSectionResultEntity' -; - -DROP TABLE IF EXISTS 'WaveImpactAsphaltCoverSectionResultEntity' -; - DROP TABLE IF EXISTS 'WaveImpactAsphaltCoverWaveConditionsCalculationEntity' ; @@ -473,16 +437,6 @@ ) ; -CREATE TABLE 'GrassCoverSlipOffInwardsFailureMechanismMetaEntity' -( - 'GrassCoverSlipOffInwardsFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismEntityId' INTEGER NOT NULL, - 'N' REAL NOT NULL, - 'ApplyLengthEffectInSection' TINYINT (1) NOT NULL, - CONSTRAINT 'FK_GrassCoverSlipOffInwardsFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade -) -; - CREATE TABLE 'GrassCoverErosionInwardsCalculationEntity' ( 'GrassCoverErosionInwardsCalculationEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -515,6 +469,16 @@ ) ; +CREATE TABLE 'GrassCoverSlipOffInwardsFailureMechanismMetaEntity' +( + 'GrassCoverSlipOffInwardsFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'FailureMechanismEntityId' INTEGER NOT NULL, + 'N' REAL NOT NULL, + 'ApplyLengthEffectInSection' TINYINT (1) NOT NULL, + CONSTRAINT 'FK_GrassCoverSlipOffInwardsFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade +) +; + CREATE TABLE 'GrassCoverErosionOutwardsFailureMechanismMetaEntity' ( 'GrassCoverErosionOutwardsFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -526,15 +490,6 @@ ) ; -CREATE TABLE 'PipingSoilProfileEntity' -( - 'PipingSoilProfileEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'Bottom' REAL NULL, - 'Name' TEXT NOT NULL, - 'SourceType' TINYINT (1) NOT NULL -- Enum: 1 = SoilProfile1D, 2 = SoilProfile2D -) -; - CREATE TABLE 'PipingSoilLayerEntity' ( 'PipingSoilLayerEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -555,6 +510,15 @@ ) ; +CREATE TABLE 'PipingSoilProfileEntity' +( + 'PipingSoilProfileEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'Bottom' REAL NULL, + 'Name' TEXT NOT NULL, + 'SourceType' TINYINT (1) NOT NULL -- Enum: 1 = SoilProfile1D, 2 = SoilProfile2D +) +; + CREATE TABLE 'PipingStochasticSoilProfileEntity' ( 'PipingStochasticSoilProfileEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -567,6 +531,15 @@ ) ; +CREATE TABLE 'PipingScenarioConfigurationPerFailureMechanismSectionEntity' +( + 'PipingScenarioConfigurationPerFailureMechanismSectionEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'FailureMechanismSectionEntityId' INTEGER NOT NULL, + 'PipingScenarioConfigurationPerFailureMechanismSectionType' TINYINT (1) NOT NULL, -- Enum: SemiProbabilistic = 1 Probabilistic = 2 + CONSTRAINT 'FK_PipingScenarioConfigurationPerFailureMechanismSectionEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade +) +; + CREATE TABLE 'StochasticSoilModelEntity' ( 'StochasticSoilModelEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -579,15 +552,6 @@ ) ; -CREATE TABLE 'PipingScenarioConfigurationPerFailureMechanismSectionEntity' -( - 'PipingScenarioConfigurationPerFailureMechanismSectionEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismSectionEntityId' INTEGER NOT NULL, - 'PipingScenarioConfigurationPerFailureMechanismSectionType' TINYINT (1) NOT NULL, -- Enum: SemiProbabilistic = 1 Probabilistic = 2 - CONSTRAINT 'FK_PipingScenarioConfigurationPerFailureMechanismSectionEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade -) -; - CREATE TABLE 'SurfaceLineEntity' ( 'SurfaceLineEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -635,6 +599,35 @@ ) ; +CREATE TABLE 'AdoptableFailureMechanismSectionResultEntity' +( + 'AdoptableFailureMechanismSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'FailureMechanismSectionEntityId' INTEGER NOT NULL, + 'IsRelevant' TINYINT (1) NOT NULL, -- true or false + 'InitialFailureMechanismResultType' TINYINT (1) NOT NULL, -- Enum: Adopt = 1 Manual = 2 NoFailureProbability = 3 + 'ManualInitialFailureMechanismResultSectionProbability' REAL NULL, + 'FurtherAnalysisType' TINYINT (1) NOT NULL, -- Enum: NotNecessary = 1 Necessary = 2 Executed = 3 + 'RefinedSectionProbability' REAL NULL, + CONSTRAINT 'FK_AdoptableFailureMechanismSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade +) +; + +CREATE TABLE 'AdoptableWithProfileProbabilityFailureMechanismSectionResultEntity' +( + 'AdoptableWithProfileProbabilityFailureMechanismSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'FailureMechanismSectionEntityId' INTEGER NOT NULL, + 'IsRelevant' TINYINT (1) NOT NULL, -- true or false + 'InitialFailureMechanismResultType' TINYINT (1) NOT NULL, -- Enum: Adopt = 1 Manual = 2 NoFailureProbability = 3 + 'ManualInitialFailureMechanismResultSectionProbability' REAL NULL, + 'ManualInitialFailureMechanismResultProfileProbability' REAL NULL, + 'FurtherAnalysisType' TINYINT (1) NOT NULL, -- Enum: NotNecessary = 1 Necessary = 2 Executed = 3 + 'ProbabilityRefinementType' TINYINT (1) NOT NULL, -- Enum: Profile = 1 Section = 2 Both = 3 + 'RefinedSectionProbability' REAL NULL, + 'RefinedProfileProbability' REAL NULL, + CONSTRAINT 'FK_AdoptableWithProfileProbabilityFailureMechanismSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade +) +; + CREATE TABLE 'BackgroundDataEntity' ( 'BackgroundDataEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -764,19 +757,6 @@ ) ; -CREATE TABLE 'ClosingStructuresSectionResultEntity' -( - 'ClosingStructuresSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismSectionEntityId' INTEGER NOT NULL, - 'IsRelevant' TINYINT (1) NOT NULL, -- true or false - 'InitialFailureMechanismResultType' TINYINT (1) NOT NULL, -- Enum: Adopt = 1 Manual = 2 NoFailureProbability = 3 - 'ManualInitialFailureMechanismResultSectionProbability' REAL NULL, - 'FurtherAnalysisType' TINYINT (1) NOT NULL, -- Enum: NotNecessary = 1 Necessary = 2 Executed = 3 - 'RefinedSectionProbability' REAL NULL, - CONSTRAINT 'FK_ClosingStructuresSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade -) -; - CREATE TABLE 'DikeProfileEntity' ( 'DikeProfileEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -807,19 +787,6 @@ ) ; -CREATE TABLE 'DuneErosionSectionResultEntity' -( - 'DuneErosionSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismSectionEntityId' INTEGER NOT NULL, - 'IsRelevant' TINYINT (1) NOT NULL, -- true or false - 'InitialFailureMechanismResultType' TINYINT (1) NOT NULL, -- Enum: Manual = 1 NoFailureProbability = 2 - 'ManualInitialFailureMechanismResultSectionProbability' REAL NULL, - 'FurtherAnalysisType' TINYINT (1) NOT NULL, -- Enum: NotNecessary = 1 Necessary = 2 Executed = 3 - 'RefinedSectionProbability' REAL NULL, - CONSTRAINT 'FK_DuneErosionSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade -) -; - CREATE TABLE 'DuneLocationCalculationEntity' ( 'DuneLocationCalculationEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -1019,37 +986,6 @@ ) ; -CREATE TABLE 'GrassCoverErosionInwardsSectionResultEntity' -( - 'GrassCoverErosionInwardsSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismSectionEntityId' INTEGER NOT NULL, - 'IsRelevant' TINYINT (1) NOT NULL, -- true or false - 'InitialFailureMechanismResultType' TINYINT (1) NOT NULL, -- Enum: Adopt = 1 Manual = 2 NoFailureProbability = 3 - 'ManualInitialFailureMechanismResultProfileProbability' REAL NULL, - 'ManualInitialFailureMechanismResultSectionProbability' REAL NULL, - 'FurtherAnalysisType' TINYINT (1) NOT NULL, -- Enum: NotNecessary = 1 Necessary = 2 Executed = 3 - 'ProbabilityRefinementType' TINYINT (1) NOT NULL, -- Enum: Profile = 1 Section = 2 Both = 3 - 'RefinedProfileProbability' REAL NULL, - 'RefinedSectionProbability' REAL NULL, - CONSTRAINT 'FK_GrassCoverErosionInwardsSectionResultEntity_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, - 'IsRelevant' TINYINT (1) NOT NULL, -- true or false - 'InitialFailureMechanismResultType' TINYINT (1) NOT NULL, -- Enum: Manual = 1 NoFailureProbability = 2 - 'ManualInitialFailureMechanismResultSectionProbability' REAL NULL, - 'ManualInitialFailureMechanismResultProfileProbability' REAL NULL, - 'FurtherAnalysisType' TINYINT (1) NOT NULL, -- Enum: NotNecessary = 1 Necessary = 2 Executed = 3 - 'RefinedSectionProbability' REAL NULL, - 'RefinedProfileProbability' REAL NULL, - CONSTRAINT 'FK_GrassCoverErosionOutwardsSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade -) -; - CREATE TABLE 'GrassCoverErosionOutwardsWaveConditionsCalculationEntity' ( 'GrassCoverErosionOutwardsWaveConditionsCalculationEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -1099,21 +1035,6 @@ ) ; -CREATE TABLE 'GrassCoverSlipOffInwardsSectionResultEntity' -( - 'GrassCoverSlipOffInwardsSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismSectionEntityId' INTEGER NOT NULL, - 'IsRelevant' TINYINT (1) NOT NULL, -- true or false - 'InitialFailureMechanismResultType' TINYINT (1) NOT NULL, -- Enum: Manual = 1 NoFailureProbability = 2 - 'ManualInitialFailureMechanismResultSectionProbability' REAL NULL, - 'ManualInitialFailureMechanismResultProfileProbability' REAL NULL, - 'FurtherAnalysisType' TINYINT (1) NOT NULL, -- Enum: NotNecessary = 1 Necessary = 2 Executed = 3 - 'RefinedSectionProbability' REAL NULL, - 'RefinedProfileProbability' REAL NULL, - CONSTRAINT 'FK_GrassCoverSlipOffInwardsSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade -) -; - CREATE TABLE 'GrassCoverSlipOffOutwardsFailureMechanismMetaEntity' ( 'GrassCoverSlipOffOutwardsFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -1124,21 +1045,6 @@ ) ; -CREATE TABLE 'GrassCoverSlipOffOutwardsSectionResultEntity' -( - 'GrassCoverSlipOffOutwardsSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismSectionEntityId' INTEGER NOT NULL, - 'IsRelevant' TINYINT (1) NOT NULL, -- true or false - 'InitialFailureMechanismResultType' TINYINT (1) NOT NULL, -- Enum: Manual = 1 NoFailureProbability = 2 - 'ManualInitialFailureMechanismResultSectionProbability' REAL NULL, - 'ManualInitialFailureMechanismResultProfileProbability' REAL NULL, - 'FurtherAnalysisType' TINYINT (1) NOT NULL, -- Enum: NotNecessary = 1 Necessary = 2 Executed = 3 - 'RefinedSectionProbability' REAL NULL, - 'RefinedProfileProbability' REAL NULL, - CONSTRAINT 'FK_GrassCoverSlipOffOutwardsSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade -) -; - CREATE TABLE 'HeightStructureEntity' ( 'HeightStructureEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -1231,19 +1137,6 @@ ) ; -CREATE TABLE 'HeightStructuresSectionResultEntity' -( - 'HeightStructuresSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismSectionEntityId' INTEGER NOT NULL, - 'IsRelevant' TINYINT (1) NOT NULL, -- true or false - 'InitialFailureMechanismResultType' TINYINT (1) NOT NULL, -- Enum: Adopt = 1 Manual = 2 NoFailureProbability = 3 - 'ManualInitialFailureMechanismResultSectionProbability' REAL NULL, - 'FurtherAnalysisType' TINYINT (1) NOT NULL, -- Enum: NotNecessary = 1 Necessary = 2 Executed = 3 - 'RefinedSectionProbability' REAL NULL, - CONSTRAINT 'FK_HeightStructuresSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade -) -; - CREATE TABLE 'HydraulicBoundaryDatabaseEntity' ( 'HydraulicBoundaryDatabaseEntity' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -1491,22 +1384,6 @@ ) ; -CREATE TABLE 'MacroStabilityInwardsSectionResultEntity' -( - 'MacroStabilityInwardsSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismSectionEntityId' INTEGER NOT NULL, - 'IsRelevant' TINYINT (1) NOT NULL, -- true or false - 'InitialFailureMechanismResultType' TINYINT (1) NOT NULL, -- Enum: Adopt = 1 Manual = 2 NoFailureProbability = 3 - 'ManualInitialFailureMechanismResultSectionProbability' REAL NULL, - 'ManualInitialFailureMechanismResultProfileProbability' REAL NULL, - 'FurtherAnalysisType' TINYINT (1) NOT NULL, -- Enum: NotNecessary = 1 Necessary = 2 Executed = 3 - 'ProbabilityRefinementType' TINYINT (1) NOT NULL, -- Enum: Profile = 1 Section = 2 Both = 3 - 'RefinedSectionProbability' REAL NULL, - 'RefinedProfileProbability' REAL NULL, - CONSTRAINT 'FK_MacroStabilityInwardsSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade -) -; - CREATE TABLE 'MacroStabilityInwardsSoilLayerOneDEntity' ( 'MacroStabilityInwardsSoilLayerOneDEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -1618,18 +1495,16 @@ ) ; -CREATE TABLE 'MicrostabilitySectionResultEntity' +CREATE TABLE 'NonAdoptableFailureMechanismSectionResultEntity' ( - 'MicrostabilitySectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'NonAdoptableFailureMechanismSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismSectionEntityId' INTEGER NOT NULL, 'IsRelevant' TINYINT (1) NOT NULL, -- true or false - 'InitialFailureMechanismResultType' TINYINT (1) NOT NULL, -- Enum: Manual = 1 NoFailureProbability = 2 + 'InitialFailureMechanismResultType' TINYINT (1) NOT NULL, -- Enum: Manual = 1, NoFailureProbability = 2 'ManualInitialFailureMechanismResultSectionProbability' REAL NULL, - 'ManualInitialFailureMechanismResultProfileProbability' REAL NULL, 'FurtherAnalysisType' TINYINT (1) NOT NULL, -- Enum: NotNecessary = 1 Necessary = 2 Executed = 3 'RefinedSectionProbability' REAL NULL, - 'RefinedProfileProbability' REAL NULL, - CONSTRAINT 'FK_MicrostabilitySectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade + CONSTRAINT 'FK_NonAdoptableFailureMechanismSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade ) ; @@ -1661,22 +1536,6 @@ ) ; -CREATE TABLE 'PipingSectionResultEntity' -( - 'PipingSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismSectionEntityId' INTEGER NOT NULL, - 'IsRelevant' TINYINT (1) NOT NULL, -- true or false - 'InitialFailureMechanismResultType' TINYINT (1) NOT NULL, -- Enum: Adopt = 1 Manual = 2 NoFailureProbablity = 3 - 'ManualInitialFailureMechanismResultSectionProbability' REAL NULL, - 'ManualInitialFailureMechanismResultProfileProbability' REAL NULL, - 'FurtherAnalysisType' TINYINT (1) NOT NULL, -- Enum: NotNecessary = 1 Necessary = 2 Executed = 3 - 'ProbabilityRefinementType' TINYINT (1) NOT NULL, -- Enum: Profile = 1, Section = 2, Both = 3 - 'RefinedSectionProbability' REAL NULL, - 'RefinedProfileProbability' REAL NULL, - CONSTRAINT 'FK_PipingSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade -) -; - CREATE TABLE 'PipingStructureFailureMechanismMetaEntity' ( 'PipingStructureFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -1686,19 +1545,6 @@ ) ; -CREATE TABLE 'PipingStructureSectionResultEntity' -( - 'PipingStructureSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismSectionEntityId' INTEGER NOT NULL, - 'IsRelevant' TINYINT (1) NOT NULL, -- true or false - 'InitialFailureMechanismResultType' TINYINT (1) NOT NULL, -- Enum: Manual = 1, NoFailureProbability = 2 - 'ManualInitialFailureMechanismResultSectionProbability' REAL NULL, - 'FurtherAnalysisType' TINYINT (1) NOT NULL, -- Enum: NotNecessary = 1 Necessary = 2 Executed = 3 - 'RefinedSectionProbability' REAL NULL, - CONSTRAINT 'FK_PipingStructureSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade -) -; - CREATE TABLE 'ProbabilisticPipingCalculationEntity' ( 'ProbabilisticPipingCalculationEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -1950,19 +1796,6 @@ ) ; -CREATE TABLE 'StabilityPointStructuresSectionResultEntity' -( - 'StabilityPointStructuresSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismSectionEntityId' INTEGER NOT NULL, - 'IsRelevant' TINYINT (1) NOT NULL, -- true or false - 'InitialFailureMechanismResultType' TINYINT (1) NOT NULL, -- Enum: Adopt = 1 Manual = 2 NoFailureProbability = 3 - 'ManualInitialFailureMechanismResultSectionProbability' REAL NULL, - 'FurtherAnalysisType' TINYINT (1) NOT NULL, -- Enum: NotNecessary = 1 Necessary = 2 Executed = 3 - 'RefinedSectionProbability' REAL NULL, - CONSTRAINT 'FK_StabilityPointStructuresSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade -) -; - CREATE TABLE 'StabilityStoneCoverFailureMechanismMetaEntity' ( 'StabilityStoneCoverFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -1974,21 +1807,6 @@ ) ; -CREATE TABLE 'StabilityStoneCoverSectionResultEntity' -( - 'StabilityStoneCoverSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismSectionEntityId' INTEGER NOT NULL, - 'IsRelevant' TINYINT (1) NOT NULL, -- true or false - 'InitialFailureMechanismResultType' TINYINT (1) NOT NULL, -- Enum: Manual = 1 NoFailureProbability = 2 - 'ManualInitialFailureMechanismResultSectionProbability' REAL NULL, - 'ManualInitialFailureMechanismResultProfileProbability' REAL NULL, - 'FurtherAnalysisType' TINYINT (1) NOT NULL, -- Enum: NotNecessary = 1 Necessary = 2 Executed = 3 - 'RefinedSectionProbability' REAL NULL, - 'RefinedProfileProbability' REAL NULL, - CONSTRAINT 'FK_StabilityStoneCoverSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade -) -; - CREATE TABLE 'StabilityStoneCoverWaveConditionsCalculationEntity' ( 'StabilityStoneCoverWaveConditionsCalculationEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -2099,36 +1917,6 @@ ) ; -CREATE TABLE 'WaterPressureAsphaltCoverSectionResultEntity' -( - 'WaterPressureAsphaltCoverSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismSectionEntityId' INTEGER NOT NULL, - 'IsRelevant' TINYINT (1) NOT NULL, -- true or false - 'InitialFailureMechanismResultType' TINYINT (1) NOT NULL, -- Enum: Manual = 1 NoFailureProbability = 2 - 'ManualInitialFailureMechanismResultSectionProbability' REAL NULL, - 'ManualInitialFailureMechanismResultProfileProbability' REAL NULL, - 'FurtherAnalysisType' TINYINT (1) NOT NULL, -- Enum: NotNecessary = 1 Necessary = 2 Executed = 3 - 'RefinedSectionProbability' REAL NULL, - 'RefinedProfileProbability' REAL NULL, - CONSTRAINT 'FK_WaterPressureAsphaltCoverSectionResultEntity_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, - 'IsRelevant' TINYINT (1) NOT NULL, -- true or false - 'InitialFailureMechanismResultType' TINYINT (1) NOT NULL, -- Enum: Manual = 1 NoFailureProbability = 2 - 'ManualInitialFailureMechanismResultSectionProbability' REAL NULL, - 'ManualInitialFailureMechanismResultProfileProbability' REAL NULL, - 'FurtherAnalysisType' TINYINT (1) NOT NULL, -- Enum: NotNecessary = 1 Necessary = 2 Executed = 3 - 'RefinedSectionProbability' REAL NULL, - 'RefinedProfileProbability' REAL NULL, - CONSTRAINT 'FK_WaveImpactAsphaltCoverSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade -) -; - CREATE TABLE 'WaveImpactAsphaltCoverWaveConditionsCalculationEntity' ( 'WaveImpactAsphaltCoverWaveConditionsCalculationEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -2241,10 +2029,6 @@ ON 'SemiProbabilisticPipingCalculationEntity' ('CalculationGroupEntityId' ASC) ; -CREATE INDEX 'IXFK_GrassCoverSlipOffInwardsFailureMechanismMetaEntity_FailureMechanismEntity' - ON 'GrassCoverSlipOffInwardsFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) -; - CREATE INDEX 'IXFK_GrassCoverErosionInwardsCalculationEntity_CalculationGroupEntity' ON 'GrassCoverErosionInwardsCalculationEntity' ('CalculationGroupEntityId' ASC) ; @@ -2257,6 +2041,10 @@ ON 'GrassCoverErosionInwardsCalculationEntity' ('HydraulicLocationEntityId' ASC) ; +CREATE INDEX 'IXFK_GrassCoverSlipOffInwardsFailureMechanismMetaEntity_FailureMechanismEntity' + ON 'GrassCoverSlipOffInwardsFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) +; + CREATE INDEX 'IXFK_GrassCoverErosionOutwardsFailureMechanismMetaEntity_FailureMechanismEntity' ON 'GrassCoverErosionOutwardsFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) ; @@ -2269,14 +2057,14 @@ ON 'PipingStochasticSoilProfileEntity' ('StochasticSoilModelEntityId' ASC) ; -CREATE INDEX 'IXFK_StochasticSoilModelEntity_FailureMechanismEntity' - ON 'StochasticSoilModelEntity' ('FailureMechanismEntityId' ASC) -; - CREATE INDEX 'IXFK_PipingScenarioConfigurationPerFailureMechanismSectionEntity_FailureMechanismSectionEntity' ON 'PipingScenarioConfigurationPerFailureMechanismSectionEntity' ('FailureMechanismSectionEntityId' ASC) ; +CREATE INDEX 'IXFK_StochasticSoilModelEntity_FailureMechanismEntity' + ON 'StochasticSoilModelEntity' ('FailureMechanismEntityId' ASC) +; + CREATE INDEX 'IXFK_SurfaceLineEntity_FailureMechanismEntity' ON 'SurfaceLineEntity' ('FailureMechanismEntityId' ASC) ; @@ -2293,6 +2081,14 @@ ON 'WaveImpactAsphaltCoverFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) ; +CREATE INDEX 'IXFK_AdoptableFailureMechanismSectionResultEntity_FailureMechanismSectionEntity' + ON 'AdoptableFailureMechanismSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) +; + +CREATE INDEX 'IXFK_AdoptableWithProfileProbabilityFailureMechanismSectionResultEntity_FailureMechanismSectionEntity' + ON 'AdoptableWithProfileProbabilityFailureMechanismSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) +; + CREATE INDEX 'IXFK_BackgroundDataEntity_AssessmentSectionEntity' ON 'BackgroundDataEntity' ('AssessmentSectionEntityId' ASC) ; @@ -2336,10 +2132,6 @@ END; ; -CREATE INDEX 'IXFK_ClosingStructuresSectionResultEntity_FailureMechanismSectionEntity' - ON 'ClosingStructuresSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) -; - CREATE INDEX 'IXFK_DikeProfileEntity_FailureMechanismEntity' ON 'DikeProfileEntity' ('FailureMechanismEntityId' ASC) ; @@ -2348,10 +2140,6 @@ ON 'DuneErosionFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) ; -CREATE INDEX 'IXFK_DuneErosionSectionResultEntity_FailureMechanismSectionEntity' - ON 'DuneErosionSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) -; - CREATE INDEX 'IXFK_DuneLocationCalculationEntity_DuneLocationCalculationCollectionEntity' ON 'DuneLocationCalculationEntity' ('DuneLocationCalculationForTargetProbabilityCollectionEntityId' ASC) ; @@ -2532,14 +2320,6 @@ END; ; -CREATE INDEX 'IXFK_GrassCoverErosionInwardsSectionResultEntity_FailureMechanismSectionEntity' - ON 'GrassCoverErosionInwardsSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) -; - -CREATE INDEX 'IXFK_GrassCoverErosionOutwardsSectionResultEntity_FailureMechanismSectionEntity' - ON 'GrassCoverErosionOutwardsSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) -; - CREATE INDEX 'IXFK_GrassCoverErosionOutwardsWaveConditionsCalculationEntity_CalculationGroupEntity' ON 'GrassCoverErosionOutwardsWaveConditionsCalculationEntity' ('CalculationGroupEntityId' ASC) ; @@ -2560,18 +2340,10 @@ ON 'GrassCoverErosionOutwardsWaveConditionsOutputEntity' ('GrassCoverErosionOutwardsWaveConditionsCalculationEntityId' ASC) ; -CREATE INDEX 'IXFK_GrassCoverSlipOffInwardsSectionResultEntity_FailureMechanismSectionEntity' - ON 'GrassCoverSlipOffInwardsSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) -; - CREATE INDEX 'IXFK_GrassCoverSlipOffOutwardsFailureMechanismMetaEntity_FailureMechanismEntity' ON 'GrassCoverSlipOffOutwardsFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) ; -CREATE INDEX 'IXFK_GrassCoverSlipOffOutwardsSectionResultEntity_FailureMechanismSectionEntity' - ON 'GrassCoverSlipOffOutwardsSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) -; - CREATE INDEX 'IXFK_HeightStructure_FailureMechanismEntity' ON 'HeightStructureEntity' ('FailureMechanismEntityId' ASC) ; @@ -2611,10 +2383,6 @@ END; ; -CREATE INDEX 'IXFK_HeightStructuresSectionResultEntity_FailureMechanismSectionEntity' - ON 'HeightStructuresSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) -; - CREATE INDEX 'IXFK_HydraulicBoundaryDatabaseEntity_AssessmentSectionEntity' ON 'HydraulicBoundaryDatabaseEntity' ('AssessmentSectionEntityId' ASC) ; @@ -2712,10 +2480,6 @@ ON 'MacroStabilityInwardsFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) ; -CREATE INDEX 'IXFK_MacroStabilityInwardsSectionResultEntity_FailureMechanismSectionEntity' - ON 'MacroStabilityInwardsSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) -; - CREATE INDEX 'IXFK_MacroStabilityInwardsSoilLayerOneDEntity_MacroStabilityInwardsSoilProfileOneDEntity' ON 'MacroStabilityInwardsSoilLayerOneDEntity' ('MacroStabilityInwardsSoilProfileOneDEntityId' ASC) ; @@ -2775,8 +2539,8 @@ ON 'MicrostabilityFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) ; -CREATE INDEX 'IXFK_MicrostabilitySectionResultEntity_FailureMechanismSectionEntity' - ON 'MicrostabilitySectionResultEntity' ('FailureMechanismSectionEntityId' ASC) +CREATE INDEX 'IXFK_NonAdoptableFailureMechanismSectionResultEntity_FailureMechanismSectionEntity' + ON 'NonAdoptableFailureMechanismSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) ; CREATE INDEX 'IXFK_NonAdoptableWithProfileProbabilityFailureMechanismSectionResultEntity_FailureMechanismSectionEntity' @@ -2787,18 +2551,10 @@ ON 'PipingFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) ; -CREATE INDEX 'IXFK_PipingSectionResultEntity_FailureMechanismSectionEntity' - ON 'PipingSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) -; - CREATE INDEX 'IXFK_PipingStructureFailureMechanismMetaEntity_FailureMechanismEntity' ON 'PipingStructureFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) ; -CREATE INDEX 'IXFK_PipingStructureSectionResultEntity_FailureMechanismSectionEntity' - ON 'PipingStructureSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) -; - CREATE INDEX 'IXFK_ProbabilisticPipingCalculationEntity_CalculationGroupEntity' ON 'ProbabilisticPipingCalculationEntity' ('CalculationGroupEntityId' ASC) ; @@ -2901,18 +2657,10 @@ END; ; -CREATE INDEX 'IXFK_StabilityPointStructuresSectionResultEntity_FailureMechanismSectionEntity' - ON 'StabilityPointStructuresSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) -; - CREATE INDEX 'IXFK_StabilityStoneCoverFailureMechanismMetaEntity_FailureMechanismEntity' ON 'StabilityStoneCoverFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) ; -CREATE INDEX 'IXFK_StabilityStoneCoverSectionResultEntity_FailureMechanismSectionEntity' - ON 'StabilityStoneCoverSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) -; - CREATE INDEX 'IXFK_StabilityStoneCoverWaveConditionsCalculationEntity_CalculationGroupEntity' ON 'StabilityStoneCoverWaveConditionsCalculationEntity' ('CalculationGroupEntityId' ASC) ; @@ -2975,14 +2723,6 @@ END; ; -CREATE INDEX 'IXFK_WaterPressureAsphaltCoverSectionResultEntity_FailureMechanismSectionEntity' - ON 'WaterPressureAsphaltCoverSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) -; - -CREATE INDEX 'IXFK_WaveImpactAsphaltCoverSectionResultEntity_FailureMechanismSectionEntity' - ON 'WaveImpactAsphaltCoverSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) -; - CREATE INDEX 'IXFK_WaveImpactAsphaltCoverWaveConditionsCalculationEntity_CalculationGroupEntity' ON 'WaveImpactAsphaltCoverWaveConditionsCalculationEntity' ('CalculationGroupEntityId' ASC) ;