Index: Riskeer/Migration/src/Riskeer.Migration.Core/EmbeddedResources/DatabaseStructure23.2.sql =================================================================== diff -u -r72411ebf630ffe7af9359bb5640ef8684a4a56c9 -r6b5c3c001432a4b60ddc645fc8c3527c169b17dd --- Riskeer/Migration/src/Riskeer.Migration.Core/EmbeddedResources/DatabaseStructure23.2.sql (.../DatabaseStructure23.2.sql) (revision 72411ebf630ffe7af9359bb5640ef8684a4a56c9) +++ Riskeer/Migration/src/Riskeer.Migration.Core/EmbeddedResources/DatabaseStructure23.2.sql (.../DatabaseStructure23.2.sql) (revision 6b5c3c001432a4b60ddc645fc8c3527c169b17dd) @@ -1,6 +1,6 @@ /* ---------------------------------------------------- */ /* Generated by Enterprise Architect Version 16.1 */ -/* Created On : 15-mrt-2024 09:25:09 */ +/* Created On : 25-apr-2024 10:27:39 */ /* DBMS : SQLite */ /* ---------------------------------------------------- */ @@ -15,10 +15,10 @@ DROP TABLE IF EXISTS AssessmentSectionEntity ; -DROP TABLE IF EXISTS FailureMechanismSectionEntity +DROP TABLE IF EXISTS FailureMechanismEntity ; -DROP TABLE IF EXISTS FailureMechanismEntity +DROP TABLE IF EXISTS FailureMechanismSectionEntity ; DROP TABLE IF EXISTS ClosingStructuresFailureMechanismMetaEntity @@ -39,36 +39,30 @@ DROP TABLE IF EXISTS GrassCoverErosionInwardsCalculationEntity ; -DROP TABLE IF EXISTS GrassCoverSlipOffInwardsFailureMechanismMetaEntity +DROP TABLE IF EXISTS GrassCoverErosionOutwardsFailureMechanismMetaEntity ; -DROP TABLE IF EXISTS GrassCoverErosionOutwardsFailureMechanismMetaEntity +DROP TABLE IF EXISTS PipingSoilProfileEntity ; DROP TABLE IF EXISTS PipingSoilLayerEntity ; -DROP TABLE IF EXISTS PipingSoilProfileEntity +DROP TABLE IF EXISTS PipingStochasticSoilProfileEntity ; -DROP TABLE IF EXISTS PipingStochasticSoilProfileEntity +DROP TABLE IF EXISTS StochasticSoilModelEntity ; DROP TABLE IF EXISTS PipingScenarioConfigurationPerFailureMechanismSectionEntity ; -DROP TABLE IF EXISTS StochasticSoilModelEntity -; - DROP TABLE IF EXISTS SurfaceLineEntity ; DROP TABLE IF EXISTS PipingCharacteristicPointEntity ; -DROP TABLE IF EXISTS WaterPressureAsphaltCoverFailureMechanismMetaEntity -; - DROP TABLE IF EXISTS WaveImpactAsphaltCoverFailureMechanismMetaEntity ; @@ -153,9 +147,6 @@ DROP TABLE IF EXISTS GrassCoverErosionOutwardsWaveConditionsOutputEntity ; -DROP TABLE IF EXISTS GrassCoverSlipOffOutwardsFailureMechanismMetaEntity -; - DROP TABLE IF EXISTS HeightStructureEntity ; @@ -228,9 +219,6 @@ DROP TABLE IF EXISTS MacroStabilityInwardsStochasticSoilProfileEntity ; -DROP TABLE IF EXISTS MicrostabilityFailureMechanismMetaEntity -; - DROP TABLE IF EXISTS NonAdoptableFailureMechanismSectionResultEntity ; @@ -240,9 +228,6 @@ DROP TABLE IF EXISTS PipingFailureMechanismMetaEntity ; -DROP TABLE IF EXISTS PipingStructureFailureMechanismMetaEntity -; - DROP TABLE IF EXISTS ProbabilisticPipingCalculationEntity ; @@ -341,14 +326,6 @@ ) ; -CREATE TABLE FailureMechanismSectionEntity -( - FailureMechanismSectionEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - Name VARCHAR (260) NOT NULL, - FailureMechanismSectionPointXml TEXT NOT NULL COLLATE NOCASE -) -; - CREATE TABLE FailureMechanismEntity ( FailureMechanismEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -369,11 +346,18 @@ ) ; +CREATE TABLE FailureMechanismSectionEntity +( + FailureMechanismSectionEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + Name VARCHAR (260) NOT NULL, + FailureMechanismSectionPointXml TEXT NOT NULL COLLATE NOCASE +) +; + CREATE TABLE ClosingStructuresFailureMechanismMetaEntity ( ClosingStructuresFailureMechanismMetaEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, FailureMechanismEntityId INTEGER NOT NULL, - N2A INT (4) NOT NULL, ClosingStructureCollectionSourcePath TEXT NULL COLLATE NOCASE, ForeshoreProfileCollectionSourcePath TEXT NULL COLLATE NOCASE, CONSTRAINT FK_ClosingStructuresFailureMechanismMetaEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade @@ -407,9 +391,7 @@ ( GrassCoverErosionInwardsFailureMechanismMetaEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, FailureMechanismEntityId INTEGER NOT NULL, - N REAL NOT NULL, DikeProfileCollectionSourcePath TEXT NULL COLLATE NOCASE, - ApplyLengthEffectInSection TINYINT (1) NOT NULL, CONSTRAINT FK_GrassCoverErosionInwardsFailureMechanismMetaEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; @@ -473,27 +455,24 @@ ) ; -CREATE TABLE GrassCoverSlipOffInwardsFailureMechanismMetaEntity -( - GrassCoverSlipOffInwardsFailureMechanismMetaEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - FailureMechanismEntityId INTEGER NOT NULL, - N REAL NOT NULL, - ApplyLengthEffectInSection TINYINT (1) NOT NULL, - CONSTRAINT FK_GrassCoverSlipOffInwardsFailureMechanismMetaEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade -) -; - CREATE TABLE GrassCoverErosionOutwardsFailureMechanismMetaEntity ( GrassCoverErosionOutwardsFailureMechanismMetaEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, FailureMechanismEntityId INTEGER NOT NULL, - N REAL NOT NULL, ForeshoreProfileCollectionSourcePath TEXT NULL COLLATE NOCASE, - ApplyLengthEffectInSection TINYINT (1) NOT NULL, CONSTRAINT FK_GrassCoverErosionOutwardsFailureMechanismMetaEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; +CREATE TABLE PipingSoilProfileEntity +( + PipingSoilProfileEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + Bottom REAL NULL, + Name TEXT NOT NULL COLLATE NOCASE, + SourceType TINYINT (1) NOT NULL -- Enum: 1 = SoilProfile1D, 2 = SoilProfile2D +) +; + CREATE TABLE PipingSoilLayerEntity ( PipingSoilLayerEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -514,15 +493,6 @@ ) ; -CREATE TABLE PipingSoilProfileEntity -( - PipingSoilProfileEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - Bottom REAL NULL, - Name TEXT NOT NULL COLLATE NOCASE, - SourceType TINYINT (1) NOT NULL -- Enum: 1 = SoilProfile1D, 2 = SoilProfile2D -) -; - CREATE TABLE PipingStochasticSoilProfileEntity ( PipingStochasticSoilProfileEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -535,15 +505,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 StochasticSoilModelEntity ( StochasticSoilModelEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -556,6 +517,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 SurfaceLineEntity ( SurfaceLineEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -582,23 +552,11 @@ ) ; -CREATE TABLE WaterPressureAsphaltCoverFailureMechanismMetaEntity -( - WaterPressureAsphaltCoverFailureMechanismMetaEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - FailureMechanismEntityId INTEGER NOT NULL, - N REAL NOT NULL, - ApplyLengthEffectInSection TINYINT (1) NOT NULL, - CONSTRAINT FK_WaterPressureAsphaltCoverFailureMechanismMetaEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade -) -; - CREATE TABLE WaveImpactAsphaltCoverFailureMechanismMetaEntity ( WaveImpactAsphaltCoverFailureMechanismMetaEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, FailureMechanismEntityId INTEGER NOT NULL, ForeshoreProfileCollectionSourcePath TEXT NULL COLLATE NOCASE, - DeltaL REAL NOT NULL, - ApplyLengthEffectInSection TINYINT (1) NOT NULL, CONSTRAINT FK_WaveImpactAsphaltCoverFailureMechanismMetaEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; @@ -786,7 +744,6 @@ ( 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 ) ; @@ -1039,16 +996,6 @@ ) ; -CREATE TABLE GrassCoverSlipOffOutwardsFailureMechanismMetaEntity -( - GrassCoverSlipOffOutwardsFailureMechanismMetaEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - FailureMechanismEntityId INTEGER NOT NULL, - N REAL NOT NULL, - ApplyLengthEffectInSection TINYINT (1) NOT NULL, - CONSTRAINT FK_GrassCoverSlipOffOutwardsFailureMechanismMetaEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade -) -; - CREATE TABLE HeightStructureEntity ( HeightStructureEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -1122,7 +1069,6 @@ ( HeightStructuresFailureMechanismMetaEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, FailureMechanismEntityId INTEGER NOT NULL, - N REAL NOT NULL, HeightStructureCollectionSourcePath TEXT NULL COLLATE NOCASE, ForeshoreProfileCollectionSourcePath TEXT NULL COLLATE NOCASE, CONSTRAINT FK_HeightStructuresFailureMechanismMetaEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade @@ -1498,16 +1444,6 @@ ) ; -CREATE TABLE MicrostabilityFailureMechanismMetaEntity -( - MicrostabilityFailureMechanismMetaEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - FailureMechanismEntityId INTEGER NOT NULL, - N REAL NOT NULL, - ApplyLengthEffectInSection TINYINT (1) NOT NULL, - CONSTRAINT FK_MicrostabilityFailureMechanismMetaEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade -) -; - CREATE TABLE NonAdoptableFailureMechanismSectionResultEntity ( NonAdoptableFailureMechanismSectionResultEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -1549,15 +1485,6 @@ ) ; -CREATE TABLE PipingStructureFailureMechanismMetaEntity -( - PipingStructureFailureMechanismMetaEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - FailureMechanismEntityId INTEGER NOT NULL, - N REAL NOT NULL, - CONSTRAINT FK_PipingStructureFailureMechanismMetaEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade -) -; - CREATE TABLE ProbabilisticPipingCalculationEntity ( ProbabilisticPipingCalculationEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -1790,7 +1717,6 @@ ( StabilityPointStructuresFailureMechanismMetaEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, FailureMechanismEntityId INTEGER NOT NULL, - N REAL NOT NULL, ForeshoreProfileCollectionSourcePath TEXT NULL COLLATE NOCASE, StabilityPointStructureCollectionSourcePath TEXT NULL COLLATE NOCASE, CONSTRAINT FK_StrengthStabilityPointConstructionFailureMechanismMetaEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade @@ -1814,8 +1740,6 @@ StabilityStoneCoverFailureMechanismMetaEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, FailureMechanismEntityId INTEGER NOT NULL, ForeshoreProfileCollectionSourcePath TEXT NULL COLLATE NOCASE, - N REAL NOT NULL, - ApplyLengthEffectInSection TINYINT (1) NOT NULL, CONSTRAINT FK_StabilityStoneCoverFailureMechanismMetaEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; @@ -2054,10 +1978,6 @@ ON GrassCoverErosionInwardsCalculationEntity (HydraulicLocationEntityId ASC) ; -CREATE INDEX IXFK_GrassCoverSlipOffInwardsFailureMechanismMetaEntity_FailureMechanismEntity - ON GrassCoverSlipOffInwardsFailureMechanismMetaEntity (FailureMechanismEntityId ASC) -; - CREATE INDEX IXFK_GrassCoverErosionOutwardsFailureMechanismMetaEntity_FailureMechanismEntity ON GrassCoverErosionOutwardsFailureMechanismMetaEntity (FailureMechanismEntityId ASC) ; @@ -2070,14 +1990,14 @@ ON PipingStochasticSoilProfileEntity (StochasticSoilModelEntityId ASC) ; -CREATE INDEX IXFK_PipingScenarioConfigurationPerFailureMechanismSectionEntity_FailureMechanismSectionEntity - ON PipingScenarioConfigurationPerFailureMechanismSectionEntity (FailureMechanismSectionEntityId ASC) -; - CREATE INDEX IXFK_StochasticSoilModelEntity_FailureMechanismEntity ON StochasticSoilModelEntity (FailureMechanismEntityId ASC) ; +CREATE INDEX IXFK_PipingScenarioConfigurationPerFailureMechanismSectionEntity_FailureMechanismSectionEntity + ON PipingScenarioConfigurationPerFailureMechanismSectionEntity (FailureMechanismSectionEntityId ASC) +; + CREATE INDEX IXFK_SurfaceLineEntity_FailureMechanismEntity ON SurfaceLineEntity (FailureMechanismEntityId ASC) ; @@ -2086,10 +2006,6 @@ ON PipingCharacteristicPointEntity (SurfaceLineEntityId ASC) ; -CREATE INDEX IXFK_WaterPressureAsphaltCoverFailureMechanismMetaEntity_FailureMechanismEntity - ON WaterPressureAsphaltCoverFailureMechanismMetaEntity (FailureMechanismEntityId ASC) -; - CREATE INDEX IXFK_WaveImpactAsphaltCoverFailureMechanismMetaEntity_FailureMechanismEntity ON WaveImpactAsphaltCoverFailureMechanismMetaEntity (FailureMechanismEntityId ASC) ; @@ -2357,10 +2273,6 @@ ON GrassCoverErosionOutwardsWaveConditionsOutputEntity (GrassCoverErosionOutwardsWaveConditionsCalculationEntityId ASC) ; -CREATE INDEX IXFK_GrassCoverSlipOffOutwardsFailureMechanismMetaEntity_FailureMechanismEntity - ON GrassCoverSlipOffOutwardsFailureMechanismMetaEntity (FailureMechanismEntityId ASC) -; - CREATE INDEX IXFK_HeightStructure_FailureMechanismEntity ON HeightStructureEntity (FailureMechanismEntityId ASC) ; @@ -2556,10 +2468,6 @@ END; ; -CREATE INDEX IXFK_MicrostabilityFailureMechanismMetaEntity_FailureMechanismEntity - ON MicrostabilityFailureMechanismMetaEntity (FailureMechanismEntityId ASC) -; - CREATE INDEX IXFK_NonAdoptableFailureMechanismSectionResultEntity_FailureMechanismSectionEntity ON NonAdoptableFailureMechanismSectionResultEntity (FailureMechanismSectionEntityId ASC) ; @@ -2572,10 +2480,6 @@ ON PipingFailureMechanismMetaEntity (FailureMechanismEntityId ASC) ; -CREATE INDEX IXFK_PipingStructureFailureMechanismMetaEntity_FailureMechanismEntity - ON PipingStructureFailureMechanismMetaEntity (FailureMechanismEntityId ASC) -; - CREATE INDEX IXFK_ProbabilisticPipingCalculationEntity_CalculationGroupEntity ON ProbabilisticPipingCalculationEntity (CalculationGroupEntityId ASC) ; Index: build/DatabaseStructure.sql =================================================================== diff -u -r72411ebf630ffe7af9359bb5640ef8684a4a56c9 -r6b5c3c001432a4b60ddc645fc8c3527c169b17dd --- build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 72411ebf630ffe7af9359bb5640ef8684a4a56c9) +++ build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 6b5c3c001432a4b60ddc645fc8c3527c169b17dd) @@ -1,6 +1,6 @@ /* ---------------------------------------------------- */ /* Generated by Enterprise Architect Version 16.1 */ -/* Created On : 15-mrt-2024 09:25:09 */ +/* Created On : 25-apr-2024 10:27:39 */ /* DBMS : SQLite */ /* ---------------------------------------------------- */ @@ -15,10 +15,10 @@ DROP TABLE IF EXISTS AssessmentSectionEntity ; -DROP TABLE IF EXISTS FailureMechanismSectionEntity +DROP TABLE IF EXISTS FailureMechanismEntity ; -DROP TABLE IF EXISTS FailureMechanismEntity +DROP TABLE IF EXISTS FailureMechanismSectionEntity ; DROP TABLE IF EXISTS ClosingStructuresFailureMechanismMetaEntity @@ -39,36 +39,30 @@ DROP TABLE IF EXISTS GrassCoverErosionInwardsCalculationEntity ; -DROP TABLE IF EXISTS GrassCoverSlipOffInwardsFailureMechanismMetaEntity +DROP TABLE IF EXISTS GrassCoverErosionOutwardsFailureMechanismMetaEntity ; -DROP TABLE IF EXISTS GrassCoverErosionOutwardsFailureMechanismMetaEntity +DROP TABLE IF EXISTS PipingSoilProfileEntity ; DROP TABLE IF EXISTS PipingSoilLayerEntity ; -DROP TABLE IF EXISTS PipingSoilProfileEntity +DROP TABLE IF EXISTS PipingStochasticSoilProfileEntity ; -DROP TABLE IF EXISTS PipingStochasticSoilProfileEntity +DROP TABLE IF EXISTS StochasticSoilModelEntity ; DROP TABLE IF EXISTS PipingScenarioConfigurationPerFailureMechanismSectionEntity ; -DROP TABLE IF EXISTS StochasticSoilModelEntity -; - DROP TABLE IF EXISTS SurfaceLineEntity ; DROP TABLE IF EXISTS PipingCharacteristicPointEntity ; -DROP TABLE IF EXISTS WaterPressureAsphaltCoverFailureMechanismMetaEntity -; - DROP TABLE IF EXISTS WaveImpactAsphaltCoverFailureMechanismMetaEntity ; @@ -153,9 +147,6 @@ DROP TABLE IF EXISTS GrassCoverErosionOutwardsWaveConditionsOutputEntity ; -DROP TABLE IF EXISTS GrassCoverSlipOffOutwardsFailureMechanismMetaEntity -; - DROP TABLE IF EXISTS HeightStructureEntity ; @@ -228,9 +219,6 @@ DROP TABLE IF EXISTS MacroStabilityInwardsStochasticSoilProfileEntity ; -DROP TABLE IF EXISTS MicrostabilityFailureMechanismMetaEntity -; - DROP TABLE IF EXISTS NonAdoptableFailureMechanismSectionResultEntity ; @@ -240,9 +228,6 @@ DROP TABLE IF EXISTS PipingFailureMechanismMetaEntity ; -DROP TABLE IF EXISTS PipingStructureFailureMechanismMetaEntity -; - DROP TABLE IF EXISTS ProbabilisticPipingCalculationEntity ; @@ -341,14 +326,6 @@ ) ; -CREATE TABLE FailureMechanismSectionEntity -( - FailureMechanismSectionEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - Name VARCHAR (260) NOT NULL, - FailureMechanismSectionPointXml TEXT NOT NULL COLLATE NOCASE -) -; - CREATE TABLE FailureMechanismEntity ( FailureMechanismEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -369,11 +346,18 @@ ) ; +CREATE TABLE FailureMechanismSectionEntity +( + FailureMechanismSectionEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + Name VARCHAR (260) NOT NULL, + FailureMechanismSectionPointXml TEXT NOT NULL COLLATE NOCASE +) +; + CREATE TABLE ClosingStructuresFailureMechanismMetaEntity ( ClosingStructuresFailureMechanismMetaEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, FailureMechanismEntityId INTEGER NOT NULL, - N2A INT (4) NOT NULL, ClosingStructureCollectionSourcePath TEXT NULL COLLATE NOCASE, ForeshoreProfileCollectionSourcePath TEXT NULL COLLATE NOCASE, CONSTRAINT FK_ClosingStructuresFailureMechanismMetaEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade @@ -407,9 +391,7 @@ ( GrassCoverErosionInwardsFailureMechanismMetaEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, FailureMechanismEntityId INTEGER NOT NULL, - N REAL NOT NULL, DikeProfileCollectionSourcePath TEXT NULL COLLATE NOCASE, - ApplyLengthEffectInSection TINYINT (1) NOT NULL, CONSTRAINT FK_GrassCoverErosionInwardsFailureMechanismMetaEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; @@ -473,27 +455,24 @@ ) ; -CREATE TABLE GrassCoverSlipOffInwardsFailureMechanismMetaEntity -( - GrassCoverSlipOffInwardsFailureMechanismMetaEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - FailureMechanismEntityId INTEGER NOT NULL, - N REAL NOT NULL, - ApplyLengthEffectInSection TINYINT (1) NOT NULL, - CONSTRAINT FK_GrassCoverSlipOffInwardsFailureMechanismMetaEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade -) -; - CREATE TABLE GrassCoverErosionOutwardsFailureMechanismMetaEntity ( GrassCoverErosionOutwardsFailureMechanismMetaEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, FailureMechanismEntityId INTEGER NOT NULL, - N REAL NOT NULL, ForeshoreProfileCollectionSourcePath TEXT NULL COLLATE NOCASE, - ApplyLengthEffectInSection TINYINT (1) NOT NULL, CONSTRAINT FK_GrassCoverErosionOutwardsFailureMechanismMetaEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; +CREATE TABLE PipingSoilProfileEntity +( + PipingSoilProfileEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + Bottom REAL NULL, + Name TEXT NOT NULL COLLATE NOCASE, + SourceType TINYINT (1) NOT NULL -- Enum: 1 = SoilProfile1D, 2 = SoilProfile2D +) +; + CREATE TABLE PipingSoilLayerEntity ( PipingSoilLayerEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -514,15 +493,6 @@ ) ; -CREATE TABLE PipingSoilProfileEntity -( - PipingSoilProfileEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - Bottom REAL NULL, - Name TEXT NOT NULL COLLATE NOCASE, - SourceType TINYINT (1) NOT NULL -- Enum: 1 = SoilProfile1D, 2 = SoilProfile2D -) -; - CREATE TABLE PipingStochasticSoilProfileEntity ( PipingStochasticSoilProfileEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -535,15 +505,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 StochasticSoilModelEntity ( StochasticSoilModelEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -556,6 +517,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 SurfaceLineEntity ( SurfaceLineEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -582,23 +552,11 @@ ) ; -CREATE TABLE WaterPressureAsphaltCoverFailureMechanismMetaEntity -( - WaterPressureAsphaltCoverFailureMechanismMetaEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - FailureMechanismEntityId INTEGER NOT NULL, - N REAL NOT NULL, - ApplyLengthEffectInSection TINYINT (1) NOT NULL, - CONSTRAINT FK_WaterPressureAsphaltCoverFailureMechanismMetaEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade -) -; - CREATE TABLE WaveImpactAsphaltCoverFailureMechanismMetaEntity ( WaveImpactAsphaltCoverFailureMechanismMetaEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, FailureMechanismEntityId INTEGER NOT NULL, ForeshoreProfileCollectionSourcePath TEXT NULL COLLATE NOCASE, - DeltaL REAL NOT NULL, - ApplyLengthEffectInSection TINYINT (1) NOT NULL, CONSTRAINT FK_WaveImpactAsphaltCoverFailureMechanismMetaEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; @@ -786,7 +744,6 @@ ( 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 ) ; @@ -1039,16 +996,6 @@ ) ; -CREATE TABLE GrassCoverSlipOffOutwardsFailureMechanismMetaEntity -( - GrassCoverSlipOffOutwardsFailureMechanismMetaEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - FailureMechanismEntityId INTEGER NOT NULL, - N REAL NOT NULL, - ApplyLengthEffectInSection TINYINT (1) NOT NULL, - CONSTRAINT FK_GrassCoverSlipOffOutwardsFailureMechanismMetaEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade -) -; - CREATE TABLE HeightStructureEntity ( HeightStructureEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -1122,7 +1069,6 @@ ( HeightStructuresFailureMechanismMetaEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, FailureMechanismEntityId INTEGER NOT NULL, - N REAL NOT NULL, HeightStructureCollectionSourcePath TEXT NULL COLLATE NOCASE, ForeshoreProfileCollectionSourcePath TEXT NULL COLLATE NOCASE, CONSTRAINT FK_HeightStructuresFailureMechanismMetaEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade @@ -1498,16 +1444,6 @@ ) ; -CREATE TABLE MicrostabilityFailureMechanismMetaEntity -( - MicrostabilityFailureMechanismMetaEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - FailureMechanismEntityId INTEGER NOT NULL, - N REAL NOT NULL, - ApplyLengthEffectInSection TINYINT (1) NOT NULL, - CONSTRAINT FK_MicrostabilityFailureMechanismMetaEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade -) -; - CREATE TABLE NonAdoptableFailureMechanismSectionResultEntity ( NonAdoptableFailureMechanismSectionResultEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -1549,15 +1485,6 @@ ) ; -CREATE TABLE PipingStructureFailureMechanismMetaEntity -( - PipingStructureFailureMechanismMetaEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - FailureMechanismEntityId INTEGER NOT NULL, - N REAL NOT NULL, - CONSTRAINT FK_PipingStructureFailureMechanismMetaEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade -) -; - CREATE TABLE ProbabilisticPipingCalculationEntity ( ProbabilisticPipingCalculationEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -1790,7 +1717,6 @@ ( StabilityPointStructuresFailureMechanismMetaEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, FailureMechanismEntityId INTEGER NOT NULL, - N REAL NOT NULL, ForeshoreProfileCollectionSourcePath TEXT NULL COLLATE NOCASE, StabilityPointStructureCollectionSourcePath TEXT NULL COLLATE NOCASE, CONSTRAINT FK_StrengthStabilityPointConstructionFailureMechanismMetaEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade @@ -1814,8 +1740,6 @@ StabilityStoneCoverFailureMechanismMetaEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, FailureMechanismEntityId INTEGER NOT NULL, ForeshoreProfileCollectionSourcePath TEXT NULL COLLATE NOCASE, - N REAL NOT NULL, - ApplyLengthEffectInSection TINYINT (1) NOT NULL, CONSTRAINT FK_StabilityStoneCoverFailureMechanismMetaEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; @@ -2054,10 +1978,6 @@ ON GrassCoverErosionInwardsCalculationEntity (HydraulicLocationEntityId ASC) ; -CREATE INDEX IXFK_GrassCoverSlipOffInwardsFailureMechanismMetaEntity_FailureMechanismEntity - ON GrassCoverSlipOffInwardsFailureMechanismMetaEntity (FailureMechanismEntityId ASC) -; - CREATE INDEX IXFK_GrassCoverErosionOutwardsFailureMechanismMetaEntity_FailureMechanismEntity ON GrassCoverErosionOutwardsFailureMechanismMetaEntity (FailureMechanismEntityId ASC) ; @@ -2070,14 +1990,14 @@ ON PipingStochasticSoilProfileEntity (StochasticSoilModelEntityId ASC) ; -CREATE INDEX IXFK_PipingScenarioConfigurationPerFailureMechanismSectionEntity_FailureMechanismSectionEntity - ON PipingScenarioConfigurationPerFailureMechanismSectionEntity (FailureMechanismSectionEntityId ASC) -; - CREATE INDEX IXFK_StochasticSoilModelEntity_FailureMechanismEntity ON StochasticSoilModelEntity (FailureMechanismEntityId ASC) ; +CREATE INDEX IXFK_PipingScenarioConfigurationPerFailureMechanismSectionEntity_FailureMechanismSectionEntity + ON PipingScenarioConfigurationPerFailureMechanismSectionEntity (FailureMechanismSectionEntityId ASC) +; + CREATE INDEX IXFK_SurfaceLineEntity_FailureMechanismEntity ON SurfaceLineEntity (FailureMechanismEntityId ASC) ; @@ -2086,10 +2006,6 @@ ON PipingCharacteristicPointEntity (SurfaceLineEntityId ASC) ; -CREATE INDEX IXFK_WaterPressureAsphaltCoverFailureMechanismMetaEntity_FailureMechanismEntity - ON WaterPressureAsphaltCoverFailureMechanismMetaEntity (FailureMechanismEntityId ASC) -; - CREATE INDEX IXFK_WaveImpactAsphaltCoverFailureMechanismMetaEntity_FailureMechanismEntity ON WaveImpactAsphaltCoverFailureMechanismMetaEntity (FailureMechanismEntityId ASC) ; @@ -2357,10 +2273,6 @@ ON GrassCoverErosionOutwardsWaveConditionsOutputEntity (GrassCoverErosionOutwardsWaveConditionsCalculationEntityId ASC) ; -CREATE INDEX IXFK_GrassCoverSlipOffOutwardsFailureMechanismMetaEntity_FailureMechanismEntity - ON GrassCoverSlipOffOutwardsFailureMechanismMetaEntity (FailureMechanismEntityId ASC) -; - CREATE INDEX IXFK_HeightStructure_FailureMechanismEntity ON HeightStructureEntity (FailureMechanismEntityId ASC) ; @@ -2556,10 +2468,6 @@ END; ; -CREATE INDEX IXFK_MicrostabilityFailureMechanismMetaEntity_FailureMechanismEntity - ON MicrostabilityFailureMechanismMetaEntity (FailureMechanismEntityId ASC) -; - CREATE INDEX IXFK_NonAdoptableFailureMechanismSectionResultEntity_FailureMechanismSectionEntity ON NonAdoptableFailureMechanismSectionResultEntity (FailureMechanismSectionEntityId ASC) ; @@ -2572,10 +2480,6 @@ ON PipingFailureMechanismMetaEntity (FailureMechanismEntityId ASC) ; -CREATE INDEX IXFK_PipingStructureFailureMechanismMetaEntity_FailureMechanismEntity - ON PipingStructureFailureMechanismMetaEntity (FailureMechanismEntityId ASC) -; - CREATE INDEX IXFK_ProbabilisticPipingCalculationEntity_CalculationGroupEntity ON ProbabilisticPipingCalculationEntity (CalculationGroupEntityId ASC) ; Index: design/DatabaseDesign.eap =================================================================== diff -u -r72411ebf630ffe7af9359bb5640ef8684a4a56c9 -r6b5c3c001432a4b60ddc645fc8c3527c169b17dd Binary files differ