Index: build/DatabaseStructure.sql
===================================================================
diff -u -ra9d3845a8234336d1e882f64922c9c98aa10ac9c -r965bee866811ec47b665e1c3bdcd4fa017f2d7dc
--- build/DatabaseStructure.sql	(.../DatabaseStructure.sql)	(revision a9d3845a8234336d1e882f64922c9c98aa10ac9c)
+++ build/DatabaseStructure.sql	(.../DatabaseStructure.sql)	(revision 965bee866811ec47b665e1c3bdcd4fa017f2d7dc)
@@ -1,6 +1,6 @@
 /* ---------------------------------------------------- */
 /*  Generated by Enterprise Architect Version 16.1 		*/
-/*  Created On : 06-mei-2024 14:04:02 				*/
+/*  Created On : 13-mei-2024 11:28:56 				*/
 /*  DBMS       : SQLite 								*/
 /* ---------------------------------------------------- */
 
@@ -30,10 +30,10 @@
 DROP TABLE IF EXISTS HydraulicLocationEntity
 ;
 
-DROP TABLE IF EXISTS GrassCoverErosionInwardsFailureMechanismMetaEntity
+DROP TABLE IF EXISTS SemiProbabilisticPipingCalculationEntity
 ;
 
-DROP TABLE IF EXISTS SemiProbabilisticPipingCalculationEntity
+DROP TABLE IF EXISTS GrassCoverErosionInwardsFailureMechanismMetaEntity
 ;
 
 DROP TABLE IF EXISTS GrassCoverErosionInwardsCalculationEntity
@@ -51,10 +51,10 @@
 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
@@ -69,9 +69,6 @@
 DROP TABLE IF EXISTS AdoptableFailureMechanismSectionResultEntity
 ;
 
-DROP TABLE IF EXISTS AdoptableWithProfileProbabilityFailureMechanismSectionResultEntity
-;
-
 DROP TABLE IF EXISTS BackgroundDataEntity
 ;
 
@@ -222,9 +219,6 @@
 DROP TABLE IF EXISTS NonAdoptableFailureMechanismSectionResultEntity
 ;
 
-DROP TABLE IF EXISTS NonAdoptableWithProfileProbabilityFailureMechanismSectionResultEntity
-;
-
 DROP TABLE IF EXISTS PipingFailureMechanismMetaEntity
 ;
 
@@ -387,15 +381,6 @@
 )
 ;
 
-CREATE TABLE GrassCoverErosionInwardsFailureMechanismMetaEntity
-(
-	GrassCoverErosionInwardsFailureMechanismMetaEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
-	FailureMechanismEntityId INTEGER NOT NULL,
-	DikeProfileCollectionSourcePath TEXT NULL COLLATE NOCASE,
-	CONSTRAINT FK_GrassCoverErosionInwardsFailureMechanismMetaEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade
-)
-;
-
 CREATE TABLE SemiProbabilisticPipingCalculationEntity
 (
 	SemiProbabilisticPipingCalculationEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
@@ -423,6 +408,15 @@
 )
 ;
 
+CREATE TABLE GrassCoverErosionInwardsFailureMechanismMetaEntity
+(
+	GrassCoverErosionInwardsFailureMechanismMetaEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
+	FailureMechanismEntityId INTEGER NOT NULL,
+	DikeProfileCollectionSourcePath TEXT NULL COLLATE NOCASE,
+	CONSTRAINT FK_GrassCoverErosionInwardsFailureMechanismMetaEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade
+)
+;
+
 CREATE TABLE GrassCoverErosionInwardsCalculationEntity
 (
 	GrassCoverErosionInwardsCalculationEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
@@ -505,6 +499,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,
@@ -517,15 +520,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,
@@ -574,22 +568,6 @@
 )
 ;
 
-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,
@@ -1457,21 +1435,6 @@
 )
 ;
 
-CREATE TABLE NonAdoptableWithProfileProbabilityFailureMechanismSectionResultEntity
-(
-	NonAdoptableWithProfileProbabilityFailureMechanismSectionResultEntity INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
-	FailureMechanismSectionEntityId INTEGER NULL,
-	IsRelevant TINYINT (1) NOT NULL,	-- true or false
-	InitialFailureMechanismResultType TINYINT (1) NOT NULL,	-- Enum: Manual = 1 NoFailureProbability = 2
-	ManualInitialFailureMechanismResultSectionProbability REAL NULL,
-	ManualInitialFailureMechanismResultProfileProbability REAL NULL,
-	FurtherAnalysisType TINYINT (1) NOT NULL,	-- Enum: NotNecessary = 1 Necessary = 2 Executed = 3
-	RefinedSectionProbability REAL NULL,
-	RefinedProfileProbability REAL NULL,
-	CONSTRAINT FK_NonAdoptableWithProfileProbabilityFailureMechanismSectionResultEntity_FailureMechanismSectionEntity FOREIGN KEY (FailureMechanismSectionEntityId) REFERENCES FailureMechanismSectionEntity (FailureMechanismSectionEntityId) ON DELETE Cascade ON UPDATE Cascade
-)
-;
-
 CREATE TABLE PipingFailureMechanismMetaEntity
 (
 	PipingFailureMechanismMetaEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
@@ -1944,10 +1907,6 @@
  ON HydraulicLocationEntity (HydraulicBoundaryDatabaseEntityId ASC)
 ;
 
-CREATE INDEX IXFK_GrassCoverErosionInwardsFailureMechanismMetaEntity_FailureMechanismEntity
- ON GrassCoverErosionInwardsFailureMechanismMetaEntity (FailureMechanismEntityId ASC)
-;
-
 CREATE INDEX IXFK_SemiProbabilisticPipingCalculationEntity_PipingStochasticSoilProfileEntity
  ON SemiProbabilisticPipingCalculationEntity (PipingStochasticSoilProfileEntityId ASC)
 ;
@@ -1964,6 +1923,10 @@
  ON SemiProbabilisticPipingCalculationEntity (CalculationGroupEntityId ASC)
 ;
 
+CREATE INDEX IXFK_GrassCoverErosionInwardsFailureMechanismMetaEntity_FailureMechanismEntity
+ ON GrassCoverErosionInwardsFailureMechanismMetaEntity (FailureMechanismEntityId ASC)
+;
+
 CREATE INDEX IXFK_GrassCoverErosionInwardsCalculationEntity_CalculationGroupEntity
  ON GrassCoverErosionInwardsCalculationEntity (CalculationGroupEntityId ASC)
 ;
@@ -1988,14 +1951,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)
 ;
@@ -2012,10 +1975,6 @@
  ON AdoptableFailureMechanismSectionResultEntity (FailureMechanismSectionEntityId ASC)
 ;
 
-CREATE INDEX IXFK_AdoptableWithProfileProbabilityFailureMechanismSectionResultEntity_FailureMechanismSectionEntity
- ON AdoptableWithProfileProbabilityFailureMechanismSectionResultEntity (FailureMechanismSectionEntityId ASC)
-;
-
 CREATE INDEX IXFK_BackgroundDataEntity_AssessmentSectionEntity
  ON BackgroundDataEntity (AssessmentSectionEntityId ASC)
 ;
@@ -2470,10 +2429,6 @@
  ON NonAdoptableFailureMechanismSectionResultEntity (FailureMechanismSectionEntityId ASC)
 ;
 
-CREATE INDEX IXFK_NonAdoptableWithProfileProbabilityFailureMechanismSectionResultEntity_FailureMechanismSectionEntity
- ON NonAdoptableWithProfileProbabilityFailureMechanismSectionResultEntity (FailureMechanismSectionEntityId ASC)
-;
-
 CREATE INDEX IXFK_PipingFailureMechanismMetaEntity_FailureMechanismEntity
  ON PipingFailureMechanismMetaEntity (FailureMechanismEntityId ASC)
 ;
