Index: Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql
===================================================================
diff -u -r6e9bf03d69ca0ec95a023b658b55a4bbc0b8ad5f -r6059a4af5c28390c79efa4e808e28cc93eeddac1
--- Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql	(.../DatabaseStructure.sql)	(revision 6e9bf03d69ca0ec95a023b658b55a4bbc0b8ad5f)
+++ Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql	(.../DatabaseStructure.sql)	(revision 6059a4af5c28390c79efa4e808e28cc93eeddac1)
@@ -1,6 +1,6 @@
 /* ---------------------------------------------------- */
 /*  Generated by Enterprise Architect Version 12.0 		*/
-/*  Created On : 31-mei-2016 11:18:28 				*/
+/*  Created On : 31-mei-2016 14:13:08 				*/
 /*  DBMS       : SQLite 								*/
 /* ---------------------------------------------------- */
 
@@ -33,6 +33,9 @@
 DROP TABLE IF EXISTS 'HydraulicLocationEntity'
 ;
 
+DROP TABLE IF EXISTS 'PipingCalculationEntity'
+;
+
 DROP TABLE IF EXISTS 'ReferenceLinePointEntity'
 ;
 
@@ -79,7 +82,8 @@
 (
 	'AssessmentSectionEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
 	'ProjectEntityId' INTEGER NOT NULL,
-	'Name' VARCHAR (260) NOT NULL,
+	'Name' VARCHAR (260),
+	'Comments' TEXT,
 	'Norm' INT (4) NOT NULL,
 	'Order' INT (4) NOT NULL,
 	'HydraulicDatabaseVersion' TEXT,
@@ -106,7 +110,7 @@
 (
 	'FailureMechanismSectionEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
 	'FailureMechanismEntityId' INTEGER NOT NULL,
-	'Name' VARCHAR (255) NOT NULL,
+	'Name' VARCHAR (260) NOT NULL,
 	CONSTRAINT 'FK_FailureMechanismSectionEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade
 )
 ;
@@ -137,7 +141,7 @@
 (
 	'CalculationGroupEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
 	'ParentCalculationGroupEntityId' INTEGER,
-	'Name' VARCHAR (255) NOT NULL,
+	'Name' VARCHAR (260),
 	'IsEditable' TINYINT (1) NOT NULL, -- true or false
 	'Order' INT (4) NOT NULL,
 	CONSTRAINT 'FK_CalculationGroupEntity_CalculationGroupEntity' FOREIGN KEY ('ParentCalculationGroupEntityId') REFERENCES 'CalculationGroupEntity' ('CalculationGroupEntityId') ON DELETE Cascade ON UPDATE Cascade
@@ -157,6 +161,38 @@
 )
 ;
 
+CREATE TABLE 'PipingCalculationEntity'
+(
+	'PipingCalculationEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
+	'CalculationGroupEntityId' INTEGER NOT NULL,
+	'SurfaceLineEntityId' INTEGER,
+	'StochasticSoilProfileEntityId' INTEGER,
+	'HydraulicLocationEntityId' INTEGER,
+	'Order' INT (4) NOT NULL,
+	'Name' VARCHAR (260),
+	'Comments' TEXT,
+	'EntryPointL' NUMERIC,
+	'ExitPointL' NUMERIC,
+	'PhreaticLevelExitMean' NUMERIC NOT NULL,
+	'PhreaticLevelExitStandardDeviation' NUMERIC NOT NULL,
+	'Diameter70Mean' NUMERIC NOT NULL,
+	'Diameter70StandardDeviation' NUMERIC NOT NULL,
+	'DarcyPermeabilityMean' NUMERIC NOT NULL,
+	'DarcyPermeabilityStandardDeviation' NUMERIC NOT NULL,
+	'DampingFactorExitMean' NUMERIC NOT NULL,
+	'DampingFactorExitStandardDeviation' NUMERIC NOT NULL,
+	'SaturatedVolumicWeightOfCoverageLayerMean' NUMERIC NOT NULL,
+	'SaturatedVolumicWeightOfCoverageLayerStandardDeviation' NUMERIC NOT NULL,
+	'SaturatedVolumicWeightOfCoverageLayerShift' NUMERIC NOT NULL,
+	'RelevantForScenario' TINYINT (1) NOT NULL,
+	'ScenarioContribution' NUMERIC NOT NULL,
+	CONSTRAINT 'FK_PipingCalculationEntity_CalculationGroupEntity' FOREIGN KEY ('CalculationGroupEntityId') REFERENCES 'CalculationGroupEntity' ('CalculationGroupEntityId') ON DELETE No Action ON UPDATE No Action,
+	CONSTRAINT 'FK_PipingCalculationEntity_HydraulicLocationEntity' FOREIGN KEY ('HydraulicLocationEntityId') REFERENCES 'HydraulicLocationEntity' ('HydraulicLocationEntityId') ON DELETE No Action ON UPDATE No Action,
+	CONSTRAINT 'FK_PipingCalculationEntity_StochasticSoilProfileEntity' FOREIGN KEY ('StochasticSoilProfileEntityId') REFERENCES 'StochasticSoilProfileEntity' ('StochasticSoilProfileEntityId') ON DELETE No Action ON UPDATE No Action,
+	CONSTRAINT 'FK_PipingCalculationEntity_SurfaceLineEntity' FOREIGN KEY ('SurfaceLineEntityId') REFERENCES 'SurfaceLineEntity' ('SurfaceLineEntityId') ON DELETE No Action ON UPDATE No Action
+)
+;
+
 CREATE TABLE 'ReferenceLinePointEntity'
 (
 	'ReferenceLinePointEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
@@ -182,7 +218,7 @@
 (
 	'SoilProfileEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
 	'Bottom' NUMERIC NOT NULL,
-	'Name' TEXT NOT NULL
+	'Name' TEXT
 )
 ;
 
@@ -201,8 +237,8 @@
 (
 	'StochasticSoilModelEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
 	'FailureMechanismEntityId' INTEGER NOT NULL,
-	'Name' TEXT NOT NULL,
-	'SegmentName' TEXT NOT NULL,
+	'Name' TEXT,
+	'SegmentName' TEXT,
 	CONSTRAINT 'FK_StochasticSoilModelEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade
 )
 ;
@@ -211,7 +247,7 @@
 (
 	'SurfaceLineEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
 	'FailureMechanismEntityId' INTEGER NOT NULL,
-	'Name' VARCHAR (255) NOT NULL,
+	'Name' VARCHAR (260),
 	'ReferenceLineIntersectionX' NUMERIC NOT NULL,
 	'ReferenceLineIntersectionY' NUMERIC NOT NULL,
 	CONSTRAINT 'FK_SurfaceLineEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE No Action ON UPDATE No Action
@@ -269,6 +305,22 @@
  ON 'HydraulicLocationEntity' ('AssessmentSectionEntityId' ASC)
 ;
 
+CREATE INDEX 'IXFK_PipingCalculationEntity_StochasticSoilProfileEntity'
+ ON 'PipingCalculationEntity' ('StochasticSoilProfileEntityId' ASC)
+;
+
+CREATE INDEX 'IXFK_PipingCalculationEntity_SurfaceLineEntity'
+ ON 'PipingCalculationEntity' ('SurfaceLineEntityId' ASC)
+;
+
+CREATE INDEX 'IXFK_PipingCalculationEntity_HydraulicLocationEntity'
+ ON 'PipingCalculationEntity' ('HydraulicLocationEntityId' ASC)
+;
+
+CREATE INDEX 'IXFK_PipingCalculationEntity_CalculationGroupEntity'
+ ON 'PipingCalculationEntity' ('CalculationGroupEntityId' ASC)
+;
+
 CREATE INDEX 'IXFK_ReferenceLinePointEntity_AssessmentSectionEntity'
  ON 'ReferenceLinePointEntity' ('AssessmentSectionEntityId' ASC)
 ;
