Index: Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql
===================================================================
diff -u -re570ba372fafe1802a4caae2ef9410b64457198b -r3b154768800db81f1cf35b68248bcc53f417c90a
--- Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql	(.../DatabaseStructure.sql)	(revision e570ba372fafe1802a4caae2ef9410b64457198b)
+++ Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql	(.../DatabaseStructure.sql)	(revision 3b154768800db81f1cf35b68248bcc53f417c90a)
@@ -1,6 +1,6 @@
 /* ---------------------------------------------------- */
 /*  Generated by Enterprise Architect Version 12.0 		*/
-/*  Created On : 21-okt-2016 14:43:18 				*/
+/*  Created On : 25-Oct-2016 8:28:00 AM 				*/
 /*  DBMS       : SQLite 								*/
 /* ---------------------------------------------------- */
 
@@ -162,6 +162,9 @@
 DROP TABLE IF EXISTS 'HeightStructureEntity'
 ;
 
+DROP TABLE IF EXISTS 'HeightStructuresCalculationEntity'
+;
+
 /* Create Tables with Primary and Foreign Keys, Check and Unique Constraints */
 
 CREATE TABLE 'VersionEntity'
@@ -875,6 +878,42 @@
 )
 ;
 
+CREATE TABLE 'HeightStructuresCalculationEntity'
+(
+	'HeightStructuresCalculationEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
+	'CalculationGroupEntityId' INTEGER NOT NULL,
+	'HydraulicLocationEntityId' INTEGER,
+	'HeightStructureEntityId' INTEGER,
+	'ForeshoreProfileEntityId' INTEGER,
+	'HydraulicBoundaryLocationEntityId' INTEGER,
+	'Order' INT (4) NOT NULL,
+	'Name' VARCHAR (260),
+	'Comments' TEXT,
+	'ModelFactorSuperCriticalFlowMean' REAL,
+	'VariationCoefficientLogNormalDistributionMean' REAL,
+	'StructureNormalOrientation' REAL,
+	'AllowedLevelIncreaseStorageMean' REAL,
+	'AllowedLevelIncreaseStorageStandardDeviation' REAL,
+	'StorageStructureAreaMean' REAL,
+	'StorageStructureAreaCoefficientOfVariation' REAL,
+	'FlowWidthAtBottomProtectionMean' REAL,
+	'FlowWidthAtBottomProtectionCoefficientOfVariation' REAL,
+	'CriticalOvertoppingDischargeMean' REAL,
+	'CriticalOvertoppingDischargeCoefficientOfVariation' REAL,
+	'FailureProbabilityStructureWithErosion' REAL,
+	'WidthFlowAperturesMean' REAL,
+	'WidthFlowAperturesCoefficientOfVariation' REAL,
+	'UseBreakWater' TINYINT (1) NOT NULL,
+	'UseForeshore' TINYINT (1) NOT NULL,
+	'BreakWaterType' SMALLINT NOT NULL, -- Enum: 1 = Wall 2 = Caisson 3 = Dam
+	'BreakWaterHeight' REAL,
+	CONSTRAINT 'FK_HeightStructuresCalculationEntity_CalculationGroupEntity' FOREIGN KEY ('CalculationGroupEntityId') REFERENCES 'CalculationGroupEntity' ('CalculationGroupEntityId') ON DELETE No Action ON UPDATE No Action,
+	CONSTRAINT 'FK_HeightStructuresCalculationEntity_ForeshoreProfileEntity' FOREIGN KEY ('ForeshoreProfileEntityId') REFERENCES 'ForeshoreProfileEntity' ('ForeshoreProfileEntityId') ON DELETE Set Null ON UPDATE Set Null,
+	CONSTRAINT 'FK_HeightStructuresCalculationEntity_HeightStructureEntity' FOREIGN KEY ('HeightStructureEntityId') REFERENCES 'HeightStructureEntity' ('HeightStructureEntityId') ON DELETE No Action ON UPDATE No Action,
+	CONSTRAINT 'FK_HeightStructuresCalculationEntity_HydraulicLocationEntity' FOREIGN KEY ('HydraulicLocationEntityId') REFERENCES 'HydraulicLocationEntity' ('HydraulicLocationEntityId') ON DELETE No Action ON UPDATE No Action
+)
+;
+
 /* Create Indexes and Triggers */
 
 CREATE INDEX 'IXFK_PipingFailureMechanismMetaEntity_FailureMechanismEntity'
@@ -1124,3 +1163,19 @@
 CREATE INDEX 'IXFK_HeightStructure_FailureMechanismEntity'
  ON 'HeightStructureEntity' ('FailureMechanismEntityId' ASC)
 ;
+
+CREATE INDEX 'IXFK_HeightStructuresCalculationEntity_CalculationGroupEntity'
+ ON 'HeightStructuresCalculationEntity' ('CalculationGroupEntityId' ASC)
+;
+
+CREATE INDEX 'IXFK_HeightStructuresCalculationEntity_ForeshoreProfileEntity'
+ ON 'HeightStructuresCalculationEntity' ('ForeshoreProfileEntityId' ASC)
+;
+
+CREATE INDEX 'IXFK_HeightStructuresCalculationEntity_HeightStructureEntity'
+ ON 'HeightStructuresCalculationEntity' ('HeightStructureEntityId' ASC)
+;
+
+CREATE INDEX 'IXFK_HeightStructuresCalculationEntity_HydraulicLocationEntity'
+ ON 'HeightStructuresCalculationEntity' ('HydraulicLocationEntityId' ASC)
+;
