Index: build/DatabaseStructure.sql
===================================================================
diff -u -rda20aa39ad6745f935850875567cc20ffc91e936 -r18acfd1d6bc45059138f0c2f29c2ff7dae79cde1
--- build/DatabaseStructure.sql	(.../DatabaseStructure.sql)	(revision da20aa39ad6745f935850875567cc20ffc91e936)
+++ build/DatabaseStructure.sql	(.../DatabaseStructure.sql)	(revision 18acfd1d6bc45059138f0c2f29c2ff7dae79cde1)
@@ -1,6 +1,6 @@
 /* ---------------------------------------------------- */
 /*  Generated by Enterprise Architect Version 14.1 		*/
-/*  Created On : 28-sep-2021 09:27:57 				*/
+/*  Created On : 28-okt-2021 08:02:27 				*/
 /*  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'
@@ -102,6 +102,9 @@
 DROP TABLE IF EXISTS 'DuneLocationEntity'
 ;
 
+DROP TABLE IF EXISTS 'FailureMechanismFailureMechanismSectionEntity'
+;
+
 DROP TABLE IF EXISTS 'FaultTreeIllustrationPointEntity'
 ;
 
@@ -258,6 +261,12 @@
 DROP TABLE IF EXISTS 'SemiProbabilisticPipingCalculationOutputEntity'
 ;
 
+DROP TABLE IF EXISTS 'SpecificFailurePathEntity'
+;
+
+DROP TABLE IF EXISTS 'SpecificFailurePathFailureMechanismSectionEntity'
+;
+
 DROP TABLE IF EXISTS 'StabilityPointStructureEntity'
 ;
 
@@ -379,10 +388,9 @@
 CREATE TABLE 'FailureMechanismSectionEntity'
 (
 	'FailureMechanismSectionEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
-	'FailureMechanismEntityId' INTEGER NOT NULL,
 	'Name' VARCHAR (260) NOT NULL,
 	'FailureMechanismSectionPointXml' TEXT NOT NULL,
-	CONSTRAINT 'FK_FailureMechanismSectionEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade
+	CONSTRAINT 'FK_FailureMechanismSectionEntity_FailureMechanismEntity' FOREIGN KEY () REFERENCES  () ON DELETE Cascade ON UPDATE Cascade
 )
 ;
 
@@ -420,16 +428,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 'SemiProbabilisticPipingCalculationEntity'
 (
 	'SemiProbabilisticPipingCalculationEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
@@ -457,6 +455,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 'GrassCoverErosionInwardsCalculationEntity'
 (
 	'GrassCoverErosionInwardsCalculationEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
@@ -831,6 +839,16 @@
 )
 ;
 
+CREATE TABLE 'FailureMechanismFailureMechanismSectionEntity'
+(
+	'FailureMechanismEntityId' INTEGER NOT NULL,
+	'FailureMechanismSectionEntityId' INTEGER NOT NULL,
+	CONSTRAINT 'PK_FailureMechanismFailureMechanismSectionEntity' PRIMARY KEY ('FailureMechanismSectionEntityId','FailureMechanismEntityId'),
+	CONSTRAINT 'FK_FailureMechanismFailureMechanismSectionEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade,
+	CONSTRAINT 'FK_FailureMechanismFailureMechanismSectionEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade
+)
+;
+
 CREATE TABLE 'FaultTreeIllustrationPointEntity'
 (
 	'FaultTreeIllustrationPointEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
@@ -1692,6 +1710,29 @@
 )
 ;
 
+CREATE TABLE 'SpecificFailurePathEntity'
+(
+	'SpecificFailurePathEntityId' INTEGER NOT NULL PRIMARY KEY,
+	'AssessmentSectionEntityId' INTEGER NOT NULL,
+	'IsRelevant' TINYINT (1) NOT NULL,
+	'FailureMechanismSectionCollectionSourcePath' TEXT NULL,
+	'InputComments' TEXT NULL,
+	'OutputComments' TEXT NULL,
+	'NotRelevantComments' TEXT NULL,
+	CONSTRAINT 'FK_SpecificFailurePathEntity_AssessmentSectionEntity' FOREIGN KEY ('AssessmentSectionEntityId') REFERENCES 'AssessmentSectionEntity' ('AssessmentSectionEntityId') ON DELETE No Action ON UPDATE No Action
+)
+;
+
+CREATE TABLE 'SpecificFailurePathFailureMechanismSectionEntity'
+(
+	'SpecificFailurePathEntityId' INTEGER NOT NULL,
+	'FailureMechanismSectionEntityId' INTEGER NOT NULL,
+	CONSTRAINT 'PK_SpecificFailurePathFailureMechanismSectionEntity' PRIMARY KEY ('SpecificFailurePathEntityId','FailureMechanismSectionEntityId'),
+	CONSTRAINT 'FK_SpecificFailurePathFailureMechanismSectionEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade,
+	CONSTRAINT 'FK_SpecificFailurePathFailureMechanismSectionEntity_SpecificFailurePathEntity' FOREIGN KEY ('SpecificFailurePathEntityId') REFERENCES 'SpecificFailurePathEntity' ('SpecificFailurePathEntityId') ON DELETE Cascade ON UPDATE Cascade
+)
+;
+
 CREATE TABLE 'StabilityPointStructureEntity'
 (
 	'StabilityPointStructureEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
@@ -2133,7 +2174,7 @@
 ;
 
 CREATE INDEX 'IXFK_FailureMechanismSectionEntity_FailureMechanismEntity'
- ON 'FailureMechanismSectionEntity' ('FailureMechanismEntityId' ASC)
+ ON 'FailureMechanismSectionEntity' ()
 ;
 
 CREATE INDEX 'IXFK_ClosingStructuresFailureMechanismMetaEntity_FailureMechanismEntity'
@@ -2148,10 +2189,6 @@
  ON 'HydraulicLocationEntity' ('AssessmentSectionEntityId' ASC)
 ;
 
-CREATE INDEX 'IXFK_GrassCoverErosionInwardsFailureMechanismMetaEntity_FailureMechanismEntity'
- ON 'GrassCoverErosionInwardsFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC)
-;
-
 CREATE INDEX 'IXFK_SemiProbabilisticPipingCalculationEntity_PipingStochasticSoilProfileEntity'
  ON 'SemiProbabilisticPipingCalculationEntity' ('PipingStochasticSoilProfileEntityId' ASC)
 ;
@@ -2168,6 +2205,10 @@
  ON 'SemiProbabilisticPipingCalculationEntity' ('CalculationGroupEntityId' ASC)
 ;
 
+CREATE INDEX 'IXFK_GrassCoverErosionInwardsFailureMechanismMetaEntity_FailureMechanismEntity'
+ ON 'GrassCoverErosionInwardsFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC)
+;
+
 CREATE INDEX 'IXFK_GrassCoverErosionInwardsCalculationEntity_CalculationGroupEntity'
  ON 'GrassCoverErosionInwardsCalculationEntity' ('CalculationGroupEntityId' ASC)
 ;
@@ -2287,6 +2328,25 @@
  ON 'DuneLocationEntity' ('FailureMechanismEntityId' ASC)
 ;
 
+CREATE INDEX 'IXFK_FailureMechanismFailureMechanismSectionEntity_FailureMechanismEntity'
+ ON 'FailureMechanismFailureMechanismSectionEntity' ('FailureMechanismEntityId' ASC)
+;
+
+CREATE INDEX 'IXFK_FailureMechanismFailureMechanismSectionEntity_FailureMechanismSectionEntity'
+ ON 'FailureMechanismFailureMechanismSectionEntity' ('FailureMechanismSectionEntityId' ASC)
+;
+CREATE TRIGGER [TR_AfterDeleteFailureMechanismEntity_RemoveFailureMechanismSectionEntityId]
+	AFTER DELETE
+	ON FailureMechanismEntity
+	FOR EACH ROW
+BEGIN
+	DELETE 
+	FROM FailureMechanismSectionEntity
+	WHERE OLD.FailureMechanismSectionEntityId IS NOT NULL 
+	AND FailureMechanismSectionEntityId IS OLD.FailureMechanismSectionEntityId;
+END; 
+;
+
 CREATE INDEX 'IXFK_FaultTreeIllustrationPoint_FaultTreeIllustrationPoint'
  ON 'FaultTreeIllustrationPointEntity' ('ParentFaultTreeIllustrationPointEntityId' ASC)
 ;
@@ -2731,6 +2791,21 @@
  ON 'SemiProbabilisticPipingCalculationOutputEntity' ('SemiProbabilisticPipingCalculationEntityId' ASC)
 ;
 
+CREATE INDEX 'IXFK_SpecificFailurePathFailureMechanismSectionEntity_FailureMechanismSectionEntity'
+ ON 'SpecificFailurePathFailureMechanismSectionEntity' ('FailureMechanismSectionEntityId' ASC)
+;
+CREATE TRIGGER [TR_AfterDeleteSpecificFailurePathEntity_RemoveFailureMechanismSectionEntityId]
+	AFTER DELETE
+	ON SpecificFailurePathEntity
+	FOR EACH ROW
+BEGIN
+	DELETE 
+	FROM FailureMechanismSectionEntity
+	WHERE OLD.FailureMechanismSectionEntityId IS NOT NULL 
+	AND FailureMechanismSectionEntityId IS OLD.FailureMechanismSectionEntityId;
+END; 
+;
+
 CREATE INDEX 'IXFK_StabilityPointStructureEntity_FailureMechanismEntity'
  ON 'StabilityPointStructureEntity' ('FailureMechanismEntityId' ASC)
 ;
Index: design/DatabaseDesign.eap
===================================================================
diff -u -rda20aa39ad6745f935850875567cc20ffc91e936 -r18acfd1d6bc45059138f0c2f29c2ff7dae79cde1
Binary files differ