Index: Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql
===================================================================
diff -u -rea14c73fc9ac706d48a5af7125bb570a5d07dd28 -r0145176179f872562b3a0408860ffc7187aecb1b
--- Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql	(.../DatabaseStructure.sql)	(revision ea14c73fc9ac706d48a5af7125bb570a5d07dd28)
+++ Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql	(.../DatabaseStructure.sql)	(revision 0145176179f872562b3a0408860ffc7187aecb1b)
@@ -1,20 +1,20 @@
 /* ---------------------------------------------------- */
 /*  Generated by Enterprise Architect Version 12.0 		*/
-/*  Created On : 06-Jun-2016 09:07:52 				*/
+/*  Created On : 08-jun-2016 11:12:19 				*/
 /*  DBMS       : SQLite 								*/
 /* ---------------------------------------------------- */
 
 /* Drop Tables */
 
+DROP TABLE IF EXISTS 'PipingFailureMechanismMetaEntity'
+;
+
 DROP TABLE IF EXISTS 'VersionEntity'
 ;
 
 DROP TABLE IF EXISTS 'ProjectEntity'
 ;
 
-DROP TABLE IF EXISTS 'CharacteristicPointEntity'
-;
-
 DROP TABLE IF EXISTS 'AssessmentSectionEntity'
 ;
 
@@ -57,14 +57,26 @@
 DROP TABLE IF EXISTS 'SurfaceLinePointEntity'
 ;
 
-DROP TABLE IF EXISTS 'PipingFailureMechanismMetaEntity'
+DROP TABLE IF EXISTS 'PipingCalculationOutputEntity'
 ;
 
 DROP TABLE IF EXISTS 'StochasticSoilModelSegmentPointEntity'
 ;
 
+DROP TABLE IF EXISTS 'CharacteristicPointEntity'
+;
+
 /* Create Tables with Primary and Foreign Keys, Check and Unique Constraints */
 
+CREATE TABLE 'PipingFailureMechanismMetaEntity'
+(
+	'PipingFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
+	'FailureMechanismEntityId' INTEGER,
+	'A' NUMERIC NOT NULL,
+	CONSTRAINT 'FK_PipingFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade
+)
+;
+
 CREATE TABLE 'VersionEntity'
 (
 	'VersionId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
@@ -81,15 +93,6 @@
 )
 ;
 
-CREATE TABLE 'CharacteristicPointEntity'
-(
-	'CharacteristicPointEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
-	'CharacteristicPointType' SMALLINT NOT NULL, -- Enum: 1 = DikeToeAtRiver 2 = DikeToeAtPolder 3 = DitchDikeSide 4 = BottomDitchDikeSide 5 = BottomDitchPolderSide 6 = DitchPolderSide
-	'SurfaceLinePointEntityId' INTEGER NOT NULL,
-	CONSTRAINT 'FK_CharacteristicPointEntity_SurfaceLinePointEntity' FOREIGN KEY ('SurfaceLinePointEntityId') REFERENCES 'SurfaceLinePointEntity' ('SurfaceLinePointEntityId') ON DELETE No Action ON UPDATE No Action
-)
-;
-
 CREATE TABLE 'AssessmentSectionEntity'
 (
 	'AssessmentSectionEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
@@ -120,6 +123,7 @@
 	'CalculationGroupEntityId' INTEGER,
 	'FailureMechanismType' SMALLINT NOT NULL, -- Enumerator for different failure mechanism types (piping, macrostability, dunes, etc)  1 = Piping 2 = Macrostabiliteit binnenwaarts 3= Golfklappen op asfaltbekleding 4= Grasbekleding erosie buitentalud 5 = Grasbekleding afschuiven buitentalud 6 = Grasbekleding erosie kruin en binnentalud 7 = Stabiliteit steenzetting 8 = Duinafslag 9 = Hoogte kunstwerk 10 = Betrouwbaarheid sluiten kunstwerk 11 = Piping bij kunstwerk 12 = Sterkte en stabiliteit puntconstructires 13 = Macrostabiliteit buitenwaarts 14 = Microstabiliteit 15 = Wateroverdruk bij asfaltbekleding 16 = Grasbekleding afschuiven binnentalud 17 = Sterkte en stabiliteit langsconstructires 18 = Technische innovaties
 	'IsRelevant' TINYINT (1) NOT NULL, -- true or false
+	'Comments' TEXT,
 	CONSTRAINT 'FK_FailureMechanismEntity_AssessmentSectionEntity' FOREIGN KEY ('AssessmentSectionEntityId') REFERENCES 'AssessmentSectionEntity' ('AssessmentSectionEntityId') ON DELETE Cascade ON UPDATE Cascade,
 	CONSTRAINT 'FK_FailureMechanismEntity_CalculationGroupEntity' FOREIGN KEY ('CalculationGroupEntityId') REFERENCES 'CalculationGroupEntity' ('CalculationGroupEntityId') ON DELETE Cascade ON UPDATE Cascade,
 	CONSTRAINT 'UI_AssessmentSectionEntityId_FailureMechanismType' UNIQUE ('AssessmentSectionEntityId','FailureMechanismType')
@@ -266,12 +270,17 @@
 )
 ;
 
-CREATE TABLE 'PipingFailureMechanismMetaEntity'
+CREATE TABLE 'PipingCalculationOutputEntity'
 (
-	'PipingFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
-	'FailureMechanismEntityId' INTEGER,
-	'A' NUMERIC NOT NULL,
-	CONSTRAINT 'FK_PipingFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade
+	'PipingCalculationOutputEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
+	'PipingCalculationEntityId' INTEGER NOT NULL,
+	'HeaveFactorOfSafety' NUMERIC,
+	'HeaveZValue' NUMERIC,
+	'UpliftFactorOfSafety' NUMERIC,
+	'UpliftZValue' NUMERIC,
+	'SellmeijerFactorOfSafety' NUMERIC,
+	'SellmeijerZValue' NUMERIC,
+	CONSTRAINT 'FK_PipingCalculationOutputEntity_PipingCalculationEntity' FOREIGN KEY ('PipingCalculationEntityId') REFERENCES 'PipingCalculationEntity' ('PipingCalculationEntityId') ON DELETE No Action ON UPDATE No Action
 )
 ;
 
@@ -286,10 +295,19 @@
 )
 ;
 
+CREATE TABLE 'CharacteristicPointEntity'
+(
+	'CharacteristicPointEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
+	'CharacteristicPointType' SMALLINT NOT NULL, -- Enum: 1 = DikeToeAtRiver 2 = DikeToeAtPolder 3 = DitchDikeSide 4 = BottomDitchDikeSide 5 = BottomDitchPolderSide 6 = DitchPolderSide
+	'SurfaceLinePointEntityId' INTEGER NOT NULL,
+	CONSTRAINT 'FK_CharacteristicPointEntity_SurfaceLinePointEntity' FOREIGN KEY ('SurfaceLinePointEntityId') REFERENCES 'SurfaceLinePointEntity' ('SurfaceLinePointEntityId') ON DELETE No Action ON UPDATE No Action
+)
+;
+
 /* Create Indexes and Triggers */
 
-CREATE INDEX 'IXFK_CharacteristicPointEntity_SurfaceLinePointEntity'
- ON 'CharacteristicPointEntity' ('SurfaceLinePointEntityId' ASC)
+CREATE INDEX 'IXFK_PipingFailureMechanismMetaEntity_FailureMechanismEntity'
+ ON 'PipingFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC)
 ;
 
 CREATE INDEX 'IXFK_AssessmentSectionEntity_ProjectEntity'
@@ -360,6 +378,10 @@
  ON 'SurfaceLinePointEntity' ('SurfaceLineEntityId' ASC)
 ;
 
-CREATE INDEX 'IXFK_PipingFailureMechanismMetaEntity_FailureMechanismEntity'
- ON 'PipingFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC)
+CREATE INDEX 'IXFK_PipingCalculationOutputEntity_PipingCalculationEntity'
+ ON 'PipingCalculationOutputEntity' ('PipingCalculationEntityId' ASC)
 ;
+
+CREATE INDEX 'IXFK_CharacteristicPointEntity_SurfaceLinePointEntity'
+ ON 'CharacteristicPointEntity' ('SurfaceLinePointEntityId' ASC)
+;
