Index: build/DatabaseStructure.sql
===================================================================
diff -u -rbe91c0e5332a0409f28d69975a5e2a2006ffcbb9 -rc4b7db13195eb0c844c04291222669c4683f6b8a
--- build/DatabaseStructure.sql	(.../DatabaseStructure.sql)	(revision be91c0e5332a0409f28d69975a5e2a2006ffcbb9)
+++ build/DatabaseStructure.sql	(.../DatabaseStructure.sql)	(revision c4b7db13195eb0c844c04291222669c4683f6b8a)
@@ -1,6 +1,6 @@
 /* ---------------------------------------------------- */
 /*  Generated by Enterprise Architect Version 15.2 		*/
-/*  Created On : 10-mrt-2023 08:55:58 				*/
+/*  Created On : 11-apr-2023 10:27:28 				*/
 /*  DBMS       : SQLite 								*/
 /* ---------------------------------------------------- */
 
@@ -829,17 +829,16 @@
 CREATE TABLE 'DuneLocationEntity'
 (
 	'DuneLocationEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
+	'HydraulicLocationEntityId' INTEGER NOT NULL,
 	'FailureMechanismEntityId' INTEGER NOT NULL,
-	'LocationId' INTEGER NOT NULL,
 	'Name' VARCHAR (260) NOT NULL,
-	'LocationX' REAL NULL,
-	'LocationY' REAL NULL,
 	'CoastalAreaId' INT (4) NOT NULL,
 	'Offset' REAL NULL,
 	'Orientation' REAL NULL,
 	'D50' REAL NULL,
 	'Order' INT (4) NOT NULL,
-	CONSTRAINT 'FK_DuneLocationEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade
+	CONSTRAINT 'FK_DuneLocationEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade,
+	CONSTRAINT 'FK_DuneLocationEntity_HydraulicLocationEntity' FOREIGN KEY ('HydraulicLocationEntityId') REFERENCES 'HydraulicLocationEntity' ('HydraulicLocationEntityId') ON DELETE Cascade ON UPDATE Cascade
 )
 ;
 
@@ -2172,6 +2171,10 @@
  ON 'DuneLocationEntity' ('FailureMechanismEntityId' ASC)
 ;
 
+CREATE INDEX 'IXFK_DuneLocationEntity_HydraulicLocationEntity'
+ ON 'DuneLocationEntity' ('HydraulicLocationEntityId' ASC)
+;
+
 CREATE INDEX 'IXFK_FailureMechanismFailureMechanismSectionEntity_FailureMechanismEntity'
  ON 'FailureMechanismFailureMechanismSectionEntity' ('FailureMechanismEntityId' ASC)
 ;