Index: Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/RingtoetsEntities.edmx
===================================================================
diff -u -rea14c73fc9ac706d48a5af7125bb570a5d07dd28 -r0145176179f872562b3a0408860ffc7187aecb1b
--- Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/RingtoetsEntities.edmx	(.../RingtoetsEntities.edmx)	(revision ea14c73fc9ac706d48a5af7125bb570a5d07dd28)
+++ Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/RingtoetsEntities.edmx	(.../RingtoetsEntities.edmx)	(revision 0145176179f872562b3a0408860ffc7187aecb1b)
@@ -4,7 +4,7 @@
   <edmx:Runtime>
     <!-- SSDL content -->
     <edmx:StorageModels>
-    <Schema Namespace="RingtoetsEntitiesModel.Store" Provider="System.Data.SQLite.EF6" ProviderManifestToken="data source=D:\Projects\WTI\trunk\Application\Ringtoets\src\Application.Ringtoets.Storage\Ringtoets.rtd" Alias="Self" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" xmlns:customannotation="http://schemas.microsoft.com/ado/2013/11/edm/customannotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm/ssdl">
+    <Schema Namespace="RingtoetsEntitiesModel.Store" Provider="System.Data.SQLite.EF6" ProviderManifestToken="data source=D:\Clean_WTI2017\Application\Ringtoets\src\Application.Ringtoets.Storage\Ringtoets.rtd" Alias="Self" xmlns:store="http://schemas.microsoft.com/ado/2007/12/edm/EntityStoreSchemaGenerator" xmlns:customannotation="http://schemas.microsoft.com/ado/2013/11/edm/customannotation" xmlns="http://schemas.microsoft.com/ado/2009/11/edm/ssdl">
         <EntityType Name="AssessmentSectionEntity">
           <Key>
             <PropertyRef Name="AssessmentSectionEntityId" />
@@ -45,6 +45,7 @@
           <Property Name="CalculationGroupEntityId" Type="integer" />
           <Property Name="FailureMechanismType" Type="smallint" Nullable="false" />
           <Property Name="IsRelevant" Type="tinyint" Nullable="false" />
+          <Property Name="Comments" Type="nvarchar" MaxLength="2147483647" />
         </EntityType>
         <EntityType Name="FailureMechanismSectionEntity">
           <Key>
@@ -104,6 +105,19 @@
           <Property Name="RelevantForScenario" Type="tinyint" Nullable="false" />
           <Property Name="ScenarioContribution" Type="decimal" Precision="53" Scale="0" Nullable="false" />
         </EntityType>
+        <EntityType Name="PipingCalculationOutputEntity">
+          <Key>
+            <PropertyRef Name="PipingCalculationOutputEntityId" />
+          </Key>
+          <Property Name="PipingCalculationOutputEntityId" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" />
+          <Property Name="PipingCalculationEntityId" Type="integer" Nullable="false" />
+          <Property Name="HeaveFactorOfSafety" Type="decimal" Precision="53" Scale="0" />
+          <Property Name="HeaveZValue" Type="decimal" Precision="53" Scale="0" />
+          <Property Name="UpliftFactorOfSafety" Type="decimal" Precision="53" Scale="0" />
+          <Property Name="UpliftZValue" Type="decimal" Precision="53" Scale="0" />
+          <Property Name="SellmeijerFactorOfSafety" Type="decimal" Precision="53" Scale="0" />
+          <Property Name="SellmeijerZValue" Type="decimal" Precision="53" Scale="0" />
+        </EntityType>
         <EntityType Name="PipingFailureMechanismMetaEntity">
           <Key>
             <PropertyRef Name="PipingFailureMechanismMetaEntityId" />
@@ -348,6 +362,18 @@
             </Dependent>
           </ReferentialConstraint>
         </Association>
+        <Association Name="FK_PipingCalculationOutputEntity_0_0">
+          <End Role="PipingCalculationEntity" Type="Self.PipingCalculationEntity" Multiplicity="1" />
+          <End Role="PipingCalculationOutputEntity" Type="Self.PipingCalculationOutputEntity" Multiplicity="*" />
+          <ReferentialConstraint>
+            <Principal Role="PipingCalculationEntity">
+              <PropertyRef Name="PipingCalculationEntityId" />
+            </Principal>
+            <Dependent Role="PipingCalculationOutputEntity">
+              <PropertyRef Name="PipingCalculationEntityId" />
+            </Dependent>
+          </ReferentialConstraint>
+        </Association>
         <Association Name="FK_PipingFailureMechanismMetaEntity_0_0">
           <End Role="FailureMechanismEntity" Type="Self.FailureMechanismEntity" Multiplicity="0..1" />
           <End Role="PipingFailureMechanismMetaEntity" Type="Self.PipingFailureMechanismMetaEntity" Multiplicity="*" />
@@ -465,6 +491,7 @@
           <EntitySet Name="FailureMechanismSectionPointEntity" EntityType="Self.FailureMechanismSectionPointEntity" store:Type="Tables" />
           <EntitySet Name="HydraulicLocationEntity" EntityType="Self.HydraulicLocationEntity" store:Type="Tables" />
           <EntitySet Name="PipingCalculationEntity" EntityType="Self.PipingCalculationEntity" store:Type="Tables" />
+          <EntitySet Name="PipingCalculationOutputEntity" EntityType="Self.PipingCalculationOutputEntity" store:Type="Tables" />
           <EntitySet Name="PipingFailureMechanismMetaEntity" EntityType="Self.PipingFailureMechanismMetaEntity" store:Type="Tables" />
           <EntitySet Name="ProjectEntity" EntityType="Self.ProjectEntity" store:Type="Tables" />
           <EntitySet Name="ReferenceLinePointEntity" EntityType="Self.ReferenceLinePointEntity" store:Type="Tables" />
@@ -524,6 +551,10 @@
             <End Role="CalculationGroupEntity" EntitySet="CalculationGroupEntity" />
             <End Role="PipingCalculationEntity" EntitySet="PipingCalculationEntity" />
           </AssociationSet>
+          <AssociationSet Name="FK_PipingCalculationOutputEntity_0_0" Association="Self.FK_PipingCalculationOutputEntity_0_0">
+            <End Role="PipingCalculationEntity" EntitySet="PipingCalculationEntity" />
+            <End Role="PipingCalculationOutputEntity" EntitySet="PipingCalculationOutputEntity" />
+          </AssociationSet>
           <AssociationSet Name="FK_PipingFailureMechanismMetaEntity_0_0" Association="Self.FK_PipingFailureMechanismMetaEntity_0_0">
             <End Role="FailureMechanismEntity" EntitySet="FailureMechanismEntity" />
             <End Role="PipingFailureMechanismMetaEntity" EntitySet="PipingFailureMechanismMetaEntity" />
@@ -574,6 +605,7 @@
           <EntitySet Name="FailureMechanismSectionPointEntities" EntityType="RingtoetsEntitiesModel.FailureMechanismSectionPointEntity" />
           <EntitySet Name="HydraulicLocationEntities" EntityType="RingtoetsEntitiesModel.HydraulicLocationEntity" />
           <EntitySet Name="PipingCalculationEntities" EntityType="RingtoetsEntitiesModel.PipingCalculationEntity" />
+          <EntitySet Name="PipingCalculationOutputEntities" EntityType="RingtoetsEntitiesModel.PipingCalculationOutputEntity" />
           <EntitySet Name="PipingFailureMechanismMetaEntities" EntityType="RingtoetsEntitiesModel.PipingFailureMechanismMetaEntity" />
           <EntitySet Name="ProjectEntities" EntityType="RingtoetsEntitiesModel.ProjectEntity" />
           <EntitySet Name="ReferenceLinePointEntities" EntityType="RingtoetsEntitiesModel.ReferenceLinePointEntity" />
@@ -649,6 +681,10 @@
             <End Role="StochasticSoilProfileEntity" EntitySet="StochasticSoilProfileEntities" />
             <End Role="PipingCalculationEntity" EntitySet="PipingCalculationEntities" />
           </AssociationSet>
+          <AssociationSet Name="FK_PipingCalculationOutputEntity_0_0" Association="RingtoetsEntitiesModel.FK_PipingCalculationOutputEntity_0_0">
+            <End Role="PipingCalculationEntity" EntitySet="PipingCalculationEntities" />
+            <End Role="PipingCalculationOutputEntity" EntitySet="PipingCalculationOutputEntities" />
+          </AssociationSet>
           <AssociationSet Name="FK_SoilLayerEntity_0_0" Association="RingtoetsEntitiesModel.FK_SoilLayerEntity_0_0">
             <End Role="SoilProfileEntity" EntitySet="SoilProfileEntities" />
             <End Role="SoilLayerEntity" EntitySet="SoilLayerEntities" />
@@ -719,6 +755,7 @@
           <Property Name="CalculationGroupEntityId" Type="Int64" />
           <Property Name="FailureMechanismType" Type="Int16" Nullable="false" />
           <Property Name="IsRelevant" Type="Byte" Nullable="false" />
+          <Property Name="Comments" Type="String" MaxLength="2147483647" FixedLength="false" Unicode="true" />
           <NavigationProperty Name="AssessmentSectionEntity" Relationship="RingtoetsEntitiesModel.FK_FailureMechanismEntity_1_0" FromRole="FailureMechanismEntity" ToRole="AssessmentSectionEntity" />
           <NavigationProperty Name="CalculationGroupEntity" Relationship="RingtoetsEntitiesModel.FK_FailureMechanismEntity_0_0" FromRole="FailureMechanismEntity" ToRole="CalculationGroupEntity" />
           <NavigationProperty Name="FailureMechanismSectionEntities" Relationship="RingtoetsEntitiesModel.FK_FailureMechanismSectionEntity_0_0" FromRole="FailureMechanismEntity" ToRole="FailureMechanismSectionEntity" />
@@ -792,7 +829,22 @@
           <NavigationProperty Name="HydraulicLocationEntity" Relationship="RingtoetsEntitiesModel.FK_PipingCalculationEntity_2_0" FromRole="PipingCalculationEntity" ToRole="HydraulicLocationEntity" />
           <NavigationProperty Name="SurfaceLineEntity" Relationship="RingtoetsEntitiesModel.FK_PipingCalculationEntity_0_0" FromRole="PipingCalculationEntity" ToRole="SurfaceLineEntity" />
           <NavigationProperty Name="StochasticSoilProfileEntity" Relationship="RingtoetsEntitiesModel.FK_PipingCalculationEntity_1_0" FromRole="PipingCalculationEntity" ToRole="StochasticSoilProfileEntity" />
+          <NavigationProperty Name="PipingCalculationOutputEntities" Relationship="RingtoetsEntitiesModel.FK_PipingCalculationOutputEntity_0_0" FromRole="PipingCalculationEntity" ToRole="PipingCalculationOutputEntity" />
         </EntityType>
+        <EntityType Name="PipingCalculationOutputEntity">
+          <Key>
+            <PropertyRef Name="PipingCalculationOutputEntityId" />
+          </Key>
+          <Property Name="PipingCalculationOutputEntityId" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
+          <Property Name="PipingCalculationEntityId" Type="Int64" Nullable="false" />
+          <Property Name="HeaveFactorOfSafety" Type="Decimal" Precision="53" Scale="0" />
+          <Property Name="HeaveZValue" Type="Decimal" Precision="53" Scale="0" />
+          <Property Name="UpliftFactorOfSafety" Type="Decimal" Precision="53" Scale="0" />
+          <Property Name="UpliftZValue" Type="Decimal" Precision="53" Scale="0" />
+          <Property Name="SellmeijerFactorOfSafety" Type="Decimal" Precision="53" Scale="0" />
+          <Property Name="SellmeijerZValue" Type="Decimal" Precision="53" Scale="0" />
+          <NavigationProperty Name="PipingCalculationEntity" Relationship="RingtoetsEntitiesModel.FK_PipingCalculationOutputEntity_0_0" FromRole="PipingCalculationOutputEntity" ToRole="PipingCalculationEntity" />
+        </EntityType>
         <EntityType Name="PipingFailureMechanismMetaEntity">
           <Key>
             <PropertyRef Name="PipingFailureMechanismMetaEntityId" />
@@ -1103,6 +1155,18 @@
             </Dependent>
           </ReferentialConstraint>
         </Association>
+        <Association Name="FK_PipingCalculationOutputEntity_0_0">
+          <End Type="RingtoetsEntitiesModel.PipingCalculationEntity" Role="PipingCalculationEntity" Multiplicity="1" />
+          <End Type="RingtoetsEntitiesModel.PipingCalculationOutputEntity" Role="PipingCalculationOutputEntity" Multiplicity="*" />
+          <ReferentialConstraint>
+            <Principal Role="PipingCalculationEntity">
+              <PropertyRef Name="PipingCalculationEntityId" />
+            </Principal>
+            <Dependent Role="PipingCalculationOutputEntity">
+              <PropertyRef Name="PipingCalculationEntityId" />
+            </Dependent>
+          </ReferentialConstraint>
+        </Association>
         <Association Name="FK_SoilLayerEntity_0_0">
           <End Type="RingtoetsEntitiesModel.SoilProfileEntity" Role="SoilProfileEntity" Multiplicity="1" />
           <End Type="RingtoetsEntitiesModel.SoilLayerEntity" Role="SoilLayerEntity" Multiplicity="*" />
@@ -1206,6 +1270,7 @@
           <EntitySetMapping Name="FailureMechanismEntities">
             <EntityTypeMapping TypeName="RingtoetsEntitiesModel.FailureMechanismEntity">
               <MappingFragment StoreEntitySet="FailureMechanismEntity">
+                <ScalarProperty Name="Comments" ColumnName="Comments" />
                 <ScalarProperty Name="IsRelevant" ColumnName="IsRelevant" />
                 <ScalarProperty Name="FailureMechanismType" ColumnName="FailureMechanismType" />
                 <ScalarProperty Name="CalculationGroupEntityId" ColumnName="CalculationGroupEntityId" />
@@ -1276,6 +1341,20 @@
               </MappingFragment>
             </EntityTypeMapping>
           </EntitySetMapping>
+          <EntitySetMapping Name="PipingCalculationOutputEntities">
+            <EntityTypeMapping TypeName="RingtoetsEntitiesModel.PipingCalculationOutputEntity">
+              <MappingFragment StoreEntitySet="PipingCalculationOutputEntity">
+                <ScalarProperty Name="SellmeijerZValue" ColumnName="SellmeijerZValue" />
+                <ScalarProperty Name="SellmeijerFactorOfSafety" ColumnName="SellmeijerFactorOfSafety" />
+                <ScalarProperty Name="UpliftZValue" ColumnName="UpliftZValue" />
+                <ScalarProperty Name="UpliftFactorOfSafety" ColumnName="UpliftFactorOfSafety" />
+                <ScalarProperty Name="HeaveZValue" ColumnName="HeaveZValue" />
+                <ScalarProperty Name="HeaveFactorOfSafety" ColumnName="HeaveFactorOfSafety" />
+                <ScalarProperty Name="PipingCalculationEntityId" ColumnName="PipingCalculationEntityId" />
+                <ScalarProperty Name="PipingCalculationOutputEntityId" ColumnName="PipingCalculationOutputEntityId" />
+              </MappingFragment>
+            </EntityTypeMapping>
+          </EntitySetMapping>
           <EntitySetMapping Name="PipingFailureMechanismMetaEntities">
             <EntityTypeMapping TypeName="RingtoetsEntitiesModel.PipingFailureMechanismMetaEntity">
               <MappingFragment StoreEntitySet="PipingFailureMechanismMetaEntity">