Index: build/DatabaseStructure.sql
===================================================================
diff -u -rc9c2f50266a38f2eda8566eafe019d18b63f3f03 -r414c120db349ede430237adbde098ee258a5c3dd
--- build/DatabaseStructure.sql	(.../DatabaseStructure.sql)	(revision c9c2f50266a38f2eda8566eafe019d18b63f3f03)
+++ build/DatabaseStructure.sql	(.../DatabaseStructure.sql)	(revision 414c120db349ede430237adbde098ee258a5c3dd)
@@ -1,6 +1,6 @@
 /* ---------------------------------------------------- */
 /*  Generated by Enterprise Architect Version 14.1 		*/
-/*  Created On : 24-nov-2021 08:16:09 				*/
+/*  Created On : 01-dec-2021 09:09:30 				*/
 /*  DBMS       : SQLite 								*/
 /* ---------------------------------------------------- */
 
@@ -30,10 +30,10 @@
 DROP TABLE IF EXISTS 'HydraulicLocationEntity'
 ;
 
-DROP TABLE IF EXISTS 'SemiProbabilisticPipingCalculationEntity'
+DROP TABLE IF EXISTS 'GrassCoverErosionInwardsFailureMechanismMetaEntity'
 ;
 
-DROP TABLE IF EXISTS 'GrassCoverErosionInwardsFailureMechanismMetaEntity'
+DROP TABLE IF EXISTS 'SemiProbabilisticPipingCalculationEntity'
 ;
 
 DROP TABLE IF EXISTS 'GrassCoverErosionInwardsCalculationEntity'
@@ -42,15 +42,18 @@
 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 'PipingScenarioConfigurationPerFailureMechanismSectionEntity'
+;
+
 DROP TABLE IF EXISTS 'StochasticSoilModelEntity'
 ;
 
@@ -427,6 +430,16 @@
 )
 ;
 
+CREATE TABLE 'GrassCoverErosionInwardsFailureMechanismMetaEntity'
+(
+	'GrassCoverErosionInwardsFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
+	'FailureMechanismEntityId' INTEGER NOT NULL,
+	'N' REAL NOT NULL,
+	'DikeProfileCollectionSourcePath' TEXT NULL,
+	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,
@@ -454,16 +467,6 @@
 )
 ;
 
-CREATE TABLE 'GrassCoverErosionInwardsFailureMechanismMetaEntity'
-(
-	'GrassCoverErosionInwardsFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
-	'FailureMechanismEntityId' INTEGER NOT NULL,
-	'N' REAL NOT NULL,
-	'DikeProfileCollectionSourcePath' TEXT NULL,
-	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,
@@ -506,15 +509,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,
@@ -535,6 +529,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,
@@ -547,6 +550,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,
@@ -1603,6 +1615,7 @@
 	'WaterVolumetricWeight' REAL NOT NULL,
 	'StochasticSoilModelCollectionSourcePath' TEXT NULL,
 	'SurfaceLineCollectionSourcePath' TEXT NULL,
+	'PipingScenarioConfigurationType' TINYINT (1) NOT NULL,	-- Enum:  SemiProbabilistic = 1 Probabilistic = 2 PerFailureMechanismSection = 3
 	CONSTRAINT 'FK_PipingFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade
 )
 ;
@@ -2186,6 +2199,10 @@
  ON 'HydraulicLocationEntity' ('AssessmentSectionEntityId' ASC)
 ;
 
+CREATE INDEX 'IXFK_GrassCoverErosionInwardsFailureMechanismMetaEntity_FailureMechanismEntity'
+ ON 'GrassCoverErosionInwardsFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC)
+;
+
 CREATE INDEX 'IXFK_SemiProbabilisticPipingCalculationEntity_PipingStochasticSoilProfileEntity'
  ON 'SemiProbabilisticPipingCalculationEntity' ('PipingStochasticSoilProfileEntityId' ASC)
 ;
@@ -2202,10 +2219,6 @@
  ON 'SemiProbabilisticPipingCalculationEntity' ('CalculationGroupEntityId' ASC)
 ;
 
-CREATE INDEX 'IXFK_GrassCoverErosionInwardsFailureMechanismMetaEntity_FailureMechanismEntity'
- ON 'GrassCoverErosionInwardsFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC)
-;
-
 CREATE INDEX 'IXFK_GrassCoverErosionInwardsCalculationEntity_CalculationGroupEntity'
  ON 'GrassCoverErosionInwardsCalculationEntity' ('CalculationGroupEntityId' ASC)
 ;
@@ -2230,6 +2243,10 @@
  ON 'PipingStochasticSoilProfileEntity' ('StochasticSoilModelEntityId' ASC)
 ;
 
+CREATE INDEX 'IXFK_PipingScenarioConfigurationPerFailureMechanismSectionEntity_FailureMechanismSectionEntity'
+ ON 'PipingScenarioConfigurationPerFailureMechanismSectionEntity' ('FailureMechanismSectionEntityId' ASC)
+;
+
 CREATE INDEX 'IXFK_StochasticSoilModelEntity_FailureMechanismEntity'
  ON 'StochasticSoilModelEntity' ('FailureMechanismEntityId' ASC)
 ;
@@ -2333,14 +2350,14 @@
  ON 'FailureMechanismFailureMechanismSectionEntity' ('FailureMechanismSectionEntityId' ASC)
 ;
 CREATE TRIGGER [TR_AfterDeleteFailureMechanismFailureMechanismSectionEntity_RemoveFailureMechanismSectionEntityId]
-    AFTER DELETE
-    ON FailureMechanismFailureMechanismSectionEntity
-    FOR EACH ROW
+	AFTER DELETE
+	ON FailureMechanismFailureMechanismSectionEntity
+	FOR EACH ROW
 BEGIN
-    DELETE
-    FROM FailureMechanismSectionEntity
-    WHERE OLD.FailureMechanismSectionEntityId IS NOT NULL
-      AND FailureMechanismSectionEntityId IS OLD.FailureMechanismSectionEntityId;
+	DELETE 
+	FROM FailureMechanismSectionEntity
+	WHERE OLD.FailureMechanismSectionEntityId IS NOT NULL 
+	AND FailureMechanismSectionEntityId IS OLD.FailureMechanismSectionEntityId;
 END; 
 ;
 
@@ -2800,14 +2817,14 @@
  ON 'SpecificFailurePathFailureMechanismSectionEntity' ('SpecificFailurePathEntityId' ASC)
 ;
 CREATE TRIGGER [TR_AfterDeleteSpecificFailurePathFailureMechanismSectionEntity_RemoveFailureMechanismSectionEntityId]
-    AFTER DELETE
-    ON SpecificFailurePathFailureMechanismSectionEntity
-    FOR EACH ROW
+	AFTER DELETE
+	ON SpecificFailurePathFailureMechanismSectionEntity
+	FOR EACH ROW
 BEGIN
-    DELETE
-    FROM FailureMechanismSectionEntity
-    WHERE OLD.FailureMechanismSectionEntityId IS NOT NULL
-      AND FailureMechanismSectionEntityId IS OLD.FailureMechanismSectionEntityId;
+	DELETE 
+	FROM FailureMechanismSectionEntity
+	WHERE OLD.FailureMechanismSectionEntityId IS NOT NULL 
+	AND FailureMechanismSectionEntityId IS OLD.FailureMechanismSectionEntityId;
 END; 
 ;
 
