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)
 ;
