Index: build/DatabaseStructure.sql
===================================================================
diff -u -r5f1494bfb21170f1f94689d32c969372482cfe5e -r94ec35ab65218a3c84d83b195ddecc03de3f4810
--- build/DatabaseStructure.sql	(.../DatabaseStructure.sql)	(revision 5f1494bfb21170f1f94689d32c969372482cfe5e)
+++ build/DatabaseStructure.sql	(.../DatabaseStructure.sql)	(revision 94ec35ab65218a3c84d83b195ddecc03de3f4810)
@@ -1,6 +1,6 @@
 /* ---------------------------------------------------- */
 /*  Generated by Enterprise Architect Version 15.2 		*/
-/*  Created On : 10-feb-2022 14:38:41 				*/
+/*  Created On : 03-mrt-2022 10:32:48 				*/
 /*  DBMS       : SQLite 								*/
 /* ---------------------------------------------------- */
 
@@ -15,10 +15,10 @@
 DROP TABLE IF EXISTS 'AssessmentSectionEntity'
 ;
 
-DROP TABLE IF EXISTS 'FailureMechanismEntity'
+DROP TABLE IF EXISTS 'FailureMechanismSectionEntity'
 ;
 
-DROP TABLE IF EXISTS 'FailureMechanismSectionEntity'
+DROP TABLE IF EXISTS 'FailureMechanismEntity'
 ;
 
 DROP TABLE IF EXISTS 'ClosingStructuresFailureMechanismMetaEntity'
@@ -54,10 +54,10 @@
 DROP TABLE IF EXISTS 'PipingStochasticSoilProfileEntity'
 ;
 
-DROP TABLE IF EXISTS 'PipingScenarioConfigurationPerFailureMechanismSectionEntity'
+DROP TABLE IF EXISTS 'StochasticSoilModelEntity'
 ;
 
-DROP TABLE IF EXISTS 'StochasticSoilModelEntity'
+DROP TABLE IF EXISTS 'PipingScenarioConfigurationPerFailureMechanismSectionEntity'
 ;
 
 DROP TABLE IF EXISTS 'SurfaceLineEntity'
@@ -249,6 +249,9 @@
 DROP TABLE IF EXISTS 'MicrostabilitySectionResultEntity'
 ;
 
+DROP TABLE IF EXISTS 'NonAdoptableWithProfileProbabilityFailureMechanismSectionResultEntity'
+;
+
 DROP TABLE IF EXISTS 'PipingFailureMechanismMetaEntity'
 ;
 
@@ -370,6 +373,14 @@
 )
 ;
 
+CREATE TABLE 'FailureMechanismSectionEntity'
+(
+	'FailureMechanismSectionEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
+	'Name' VARCHAR (260) NOT NULL,
+	'FailureMechanismSectionPointXml' TEXT NOT NULL
+)
+;
+
 CREATE TABLE 'FailureMechanismEntity'
 (
 	'FailureMechanismEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
@@ -390,14 +401,6 @@
 )
 ;
 
-CREATE TABLE 'FailureMechanismSectionEntity'
-(
-	'FailureMechanismSectionEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
-	'Name' VARCHAR (260) NOT NULL,
-	'FailureMechanismSectionPointXml' TEXT NOT NULL
-)
-;
-
 CREATE TABLE 'ClosingStructuresFailureMechanismMetaEntity'
 (
 	'ClosingStructuresFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
@@ -564,15 +567,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,
@@ -585,6 +579,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,
@@ -1630,6 +1633,21 @@
 )
 ;
 
+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,
@@ -2251,14 +2269,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)
 ;
@@ -2761,6 +2779,10 @@
  ON 'MicrostabilitySectionResultEntity' ('FailureMechanismSectionEntityId' ASC)
 ;
 
+CREATE INDEX 'IXFK_NonAdoptableWithProfileProbabilityFailureMechanismSectionResultEntity_FailureMechanismSectionEntity'
+ ON 'NonAdoptableWithProfileProbabilityFailureMechanismSectionResultEntity' ('FailureMechanismSectionEntityId' ASC)
+;
+
 CREATE INDEX 'IXFK_PipingFailureMechanismMetaEntity_FailureMechanismEntity'
  ON 'PipingFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC)
 ;
