Index: build/DatabaseStructure.sql
===================================================================
diff -u -r76c9d94054e44b9f5f4eca91b7a93884d9f9388e -r5647c6ea6c3045771f187cebda61954810a47e75
--- build/DatabaseStructure.sql	(.../DatabaseStructure.sql)	(revision 76c9d94054e44b9f5f4eca91b7a93884d9f9388e)
+++ build/DatabaseStructure.sql	(.../DatabaseStructure.sql)	(revision 5647c6ea6c3045771f187cebda61954810a47e75)
@@ -1,6 +1,6 @@
 /* ---------------------------------------------------- */
 /*  Generated by Enterprise Architect Version 14.1 		*/
-/*  Created On : 15-sep-2021 15:59:54 				*/
+/*  Created On : 22-sep-2021 14:58:58 				*/
 /*  DBMS       : SQLite 								*/
 /* ---------------------------------------------------- */
 
@@ -90,10 +90,10 @@
 DROP TABLE IF EXISTS 'DuneErosionSectionResultEntity'
 ;
 
-DROP TABLE IF EXISTS 'DuneLocationCalculationCollectionEntity'
+DROP TABLE IF EXISTS 'DuneLocationCalculationEntity'
 ;
 
-DROP TABLE IF EXISTS 'DuneLocationCalculationEntity'
+DROP TABLE IF EXISTS 'DuneLocationCalculationForTargetProbabilityCollectionEntity'
 ;
 
 DROP TABLE IF EXISTS 'DuneLocationCalculationOutputEntity'
@@ -756,17 +756,7 @@
 (
 	'DuneErosionFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
 	'FailureMechanismEntityId' INTEGER NOT NULL,
-	'DuneLocationCalculationCollectionEntity1Id' INTEGER NOT NULL,	-- Represents the calculations for the failure mechanism specific factorized signaling norm
-	'DuneLocationCalculationCollectionEntity2Id' INTEGER NOT NULL,	-- Represents the calculations for the failure mechanism specific signaling norm
-	'DuneLocationCalculationCollectionEntity3Id' INTEGER NOT NULL,	-- Represents the calculations for the failure mechanism specific lower limit norm
-	'DuneLocationCalculationCollectionEntity4Id' INTEGER NOT NULL,	-- Represents the calculations for the lower limit norm
-	'DuneLocationCalculationCollectionEntity5Id' INTEGER NOT NULL,	-- Represents the calculations for the factorized lower limit norm
 	'N' REAL NOT NULL,
-	CONSTRAINT 'FK_DuneErosionFailureMechanismMetaEntity_DuneLocationCalculationCollectionEntity1' FOREIGN KEY ('DuneLocationCalculationCollectionEntity1Id') REFERENCES 'DuneLocationCalculationCollectionEntity' ('DuneLocationCalculationCollectionEntityId') ON DELETE No Action ON UPDATE Cascade,
-	CONSTRAINT 'FK_DuneErosionFailureMechanismMetaEntity_DuneLocationCalculationCollectionEntity2' FOREIGN KEY ('DuneLocationCalculationCollectionEntity2Id') REFERENCES 'DuneLocationCalculationCollectionEntity' ('DuneLocationCalculationCollectionEntityId') ON DELETE No Action ON UPDATE Cascade,
-	CONSTRAINT 'FK_DuneErosionFailureMechanismMetaEntity_DuneLocationCalculationCollectionEntity3' FOREIGN KEY ('DuneLocationCalculationCollectionEntity3Id') REFERENCES 'DuneLocationCalculationCollectionEntity' ('DuneLocationCalculationCollectionEntityId') ON DELETE No Action ON UPDATE Cascade,
-	CONSTRAINT 'FK_DuneErosionFailureMechanismMetaEntity_DuneLocationCalculationCollectionEntity4' FOREIGN KEY ('DuneLocationCalculationCollectionEntity4Id') REFERENCES 'DuneLocationCalculationCollectionEntity' ('DuneLocationCalculationCollectionEntityId') ON DELETE No Action ON UPDATE Cascade,
-	CONSTRAINT 'FK_DuneErosionFailureMechanismMetaEntity_DuneLocationCalculationCollectionEntity5' FOREIGN KEY ('DuneLocationCalculationCollectionEntity5Id') REFERENCES 'DuneLocationCalculationCollectionEntity' ('DuneLocationCalculationCollectionEntityId') ON DELETE No Action ON UPDATE Cascade,
 	CONSTRAINT 'FK_DuneErosionFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade
 )
 ;
@@ -788,19 +778,23 @@
 )
 ;
 
-CREATE TABLE 'DuneLocationCalculationCollectionEntity'
+CREATE TABLE 'DuneLocationCalculationEntity'
 (
-	'DuneLocationCalculationCollectionEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT
+	'DuneLocationCalculationEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
+	'DuneLocationEntityId' INTEGER NOT NULL,
+	'DuneLocationCalculationForTargetProbabilityCollectionEntityId' INTEGER NOT NULL,
+	CONSTRAINT 'FK_DuneLocationCalculationEntity_DuneLocationCalculationCollectionEntity' FOREIGN KEY ('DuneLocationCalculationForTargetProbabilityCollectionEntityId') REFERENCES 'DuneLocationCalculationForTargetProbabilityCollectionEntity' ('DuneLocationCalculationCollectionEntityId') ON DELETE Cascade ON UPDATE Cascade,
+	CONSTRAINT 'FK_DuneLocationCalculationEntity_DuneLocationEntity' FOREIGN KEY ('DuneLocationEntityId') REFERENCES 'DuneLocationEntity' ('DuneLocationEntityId') ON DELETE Cascade ON UPDATE Cascade
 )
 ;
 
-CREATE TABLE 'DuneLocationCalculationEntity'
+CREATE TABLE 'DuneLocationCalculationForTargetProbabilityCollectionEntity'
 (
-	'DuneLocationCalculationEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
-	'DuneLocationEntityId' INTEGER NULL,
-	'DuneLocationCalculationCollectionEntityId' INTEGER NULL,
-	CONSTRAINT 'FK_DuneLocationCalculationEntity_DuneLocationCalculationCollectionEntity' FOREIGN KEY ('DuneLocationCalculationCollectionEntityId') REFERENCES 'DuneLocationCalculationCollectionEntity' ('DuneLocationCalculationCollectionEntityId') ON DELETE Cascade ON UPDATE Cascade,
-	CONSTRAINT 'FK_DuneLocationCalculationEntity_DuneLocationEntity' FOREIGN KEY ('DuneLocationEntityId') REFERENCES 'DuneLocationEntity' ('DuneLocationEntityId') ON DELETE Cascade ON UPDATE Cascade
+	'DuneLocationCalculationCollectionEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
+	'DuneErosionFailureMechanismMetaEntityId' INTEGER NOT NULL,
+	'Order' INT (4) NOT NULL,
+	'TargetProbability' REAL NOT NULL,
+	CONSTRAINT 'FK_DuneLocationCalculationForTargetProbabilityCollectionEntity_DuneErosionFailureMechanismMetaEntity' FOREIGN KEY ('DuneErosionFailureMechanismMetaEntityId') REFERENCES 'DuneErosionFailureMechanismMetaEntity' ('DuneErosionFailureMechanismMetaEntityId') ON DELETE No Action ON UPDATE No Action
 )
 ;
 
@@ -2259,56 +2253,26 @@
  ON 'DikeProfileEntity' ('FailureMechanismEntityId' ASC)
 ;
 
-CREATE INDEX 'IXFK_DuneErosionFailureMechanismMetaEntity_DuneLocationCalculationCollectionEntity1'
- ON 'DuneErosionFailureMechanismMetaEntity' ('DuneLocationCalculationCollectionEntity1Id' ASC)
-;
-
-CREATE INDEX 'IXFK_DuneErosionFailureMechanismMetaEntity_DuneLocationCalculationCollectionEntity2'
- ON 'DuneErosionFailureMechanismMetaEntity' ('DuneLocationCalculationCollectionEntity2Id' ASC)
-;
-
-CREATE INDEX 'IXFK_DuneErosionFailureMechanismMetaEntity_DuneLocationCalculationCollectionEntity3'
- ON 'DuneErosionFailureMechanismMetaEntity' ('DuneLocationCalculationCollectionEntity3Id' ASC)
-;
-
-CREATE INDEX 'IXFK_DuneErosionFailureMechanismMetaEntity_DuneLocationCalculationCollectionEntity4'
- ON 'DuneErosionFailureMechanismMetaEntity' ('DuneLocationCalculationCollectionEntity4Id' ASC)
-;
-
-CREATE INDEX 'IXFK_DuneErosionFailureMechanismMetaEntity_DuneLocationCalculationCollectionEntity5'
- ON 'DuneErosionFailureMechanismMetaEntity' ('DuneLocationCalculationCollectionEntity5Id' ASC)
-;
-
 CREATE INDEX 'IXFK_DuneErosionFailureMechanismMetaEntity_FailureMechanismEntity'
  ON 'DuneErosionFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC)
 ;
-CREATE TRIGGER [TR_AfterDeleteDuneErosionFailureMechanismMetaEntity_RemoveDuneLocationCalculationCollectionEntities]
-	AFTER DELETE
-	ON DuneErosionFailureMechanismMetaEntity
-	FOR EACH ROW
-BEGIN
-	DELETE 
-	FROM DuneLocationCalculationCollectionEntity
-	WHERE DuneLocationCalculationCollectionEntityId IS OLD.DuneLocationCalculationCollectionEntity1Id
-	OR DuneLocationCalculationCollectionEntityId IS OLD.DuneLocationCalculationCollectionEntity2Id
-	OR DuneLocationCalculationCollectionEntityId IS OLD.DuneLocationCalculationCollectionEntity3Id
-	OR DuneLocationCalculationCollectionEntityId IS OLD.DuneLocationCalculationCollectionEntity4Id
-	OR DuneLocationCalculationCollectionEntityId IS OLD.DuneLocationCalculationCollectionEntity5Id;
-END; 
-;
 
 CREATE INDEX 'IXFK_DuneErosionSectionResultEntity_FailureMechanismSectionEntity'
  ON 'DuneErosionSectionResultEntity' ('FailureMechanismSectionEntityId' ASC)
 ;
 
 CREATE INDEX 'IXFK_DuneLocationCalculationEntity_DuneLocationCalculationCollectionEntity'
- ON 'DuneLocationCalculationEntity' ('DuneLocationCalculationCollectionEntityId' ASC)
+ ON 'DuneLocationCalculationEntity' ('DuneLocationCalculationForTargetProbabilityCollectionEntityId' ASC)
 ;
 
 CREATE INDEX 'IXFK_DuneLocationCalculationEntity_DuneLocationEntity'
  ON 'DuneLocationCalculationEntity' ('DuneLocationEntityId' ASC)
 ;
 
+CREATE INDEX 'IXFK_DuneLocationCalculationForTargetProbabilityCollectionEntity_DuneErosionFailureMechanismMetaEntity'
+ ON 'DuneLocationCalculationForTargetProbabilityCollectionEntity' ('DuneErosionFailureMechanismMetaEntityId' ASC)
+;
+
 CREATE INDEX 'IXFK_DuneLocationCalculationOutputEntity_DuneLocationCalculationEntity'
  ON 'DuneLocationCalculationOutputEntity' ('DuneLocationCalculationEntityId' ASC)
 ;
Index: design/DatabaseDesign.eap
===================================================================
diff -u -r76c9d94054e44b9f5f4eca91b7a93884d9f9388e -r5647c6ea6c3045771f187cebda61954810a47e75
Binary files differ