Index: Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/RingtoetsEntities.edmx
===================================================================
diff -u -r0145176179f872562b3a0408860ffc7187aecb1b -re69abddf5b9c6634b764df231d4e1b290c9e0fb5
--- Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/RingtoetsEntities.edmx	(.../RingtoetsEntities.edmx)	(revision 0145176179f872562b3a0408860ffc7187aecb1b)
+++ Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/RingtoetsEntities.edmx	(.../RingtoetsEntities.edmx)	(revision e69abddf5b9c6634b764df231d4e1b290c9e0fb5)
@@ -4,7 +4,7 @@
   <edmx:Runtime>
     <!-- SSDL content -->
     <edmx:StorageModels>
-    <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">
+    <Schema Namespace="RingtoetsEntitiesModel.Store" Provider="System.Data.SQLite.EF6" ProviderManifestToken="data source=D:\Branch_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" />
@@ -104,6 +104,7 @@
           <Property Name="SaturatedVolumicWeightOfCoverageLayerShift" Type="decimal" Precision="53" Scale="0" Nullable="false" />
           <Property Name="RelevantForScenario" Type="tinyint" Nullable="false" />
           <Property Name="ScenarioContribution" Type="decimal" Precision="53" Scale="0" Nullable="false" />
+          <Property Name="PipingSemiProbabilisticOutputEntityId" Type="integer" />
         </EntityType>
         <EntityType Name="PipingCalculationOutputEntity">
           <Key>
@@ -126,6 +127,27 @@
           <Property Name="FailureMechanismEntityId" Type="integer" />
           <Property Name="A" Type="decimal" Precision="53" Scale="0" Nullable="false" />
         </EntityType>
+        <EntityType Name="PipingSemiProbabilisticOutputEntity">
+          <Key>
+            <PropertyRef Name="PipingSemiProbabilisticOutputEntityId" />
+          </Key>
+          <Property Name="PipingSemiProbabilisticOutputEntityId" Type="integer" StoreGeneratedPattern="Identity" Nullable="false" />
+          <Property Name="PipingCalculationEntityId" Type="integer" />
+          <Property Name="UpliftFactorOfSafety" Type="decimal" Precision="53" Scale="0" />
+          <Property Name="UpliftReliability" Type="decimal" Precision="53" Scale="0" />
+          <Property Name="UpliftProbability" Type="decimal" Precision="53" Scale="0" />
+          <Property Name="HeaveFactorOfSafety" Type="decimal" Precision="53" Scale="0" />
+          <Property Name="HeaveReliability" Type="decimal" Precision="53" Scale="0" />
+          <Property Name="HeaveProbability" Type="decimal" Precision="53" Scale="0" />
+          <Property Name="SellmeijerFactorOfSafety" Type="decimal" Precision="53" Scale="0" />
+          <Property Name="SellmeijerReliability" Type="decimal" Precision="53" Scale="0" />
+          <Property Name="SellmeijerProbability" Type="decimal" Precision="53" Scale="0" />
+          <Property Name="RequiredProbability" Type="decimal" Precision="53" Scale="0" />
+          <Property Name="RequiredReliability" Type="decimal" Precision="53" Scale="0" />
+          <Property Name="PipingProbability" Type="decimal" Precision="53" Scale="0" />
+          <Property Name="PipingReliability" Type="decimal" Precision="53" Scale="0" />
+          <Property Name="PipingFactorOfSafety" Type="decimal" Precision="53" Scale="0" />
+        </EntityType>
         <EntityType Name="ProjectEntity">
           <Key>
             <PropertyRef Name="ProjectEntityId" />
@@ -386,6 +408,18 @@
             </Dependent>
           </ReferentialConstraint>
         </Association>
+        <Association Name="FK_PipingSemiProbabilisticOutputEntity_0_0">
+          <End Role="PipingCalculationEntity" Type="Self.PipingCalculationEntity" Multiplicity="0..1" />
+          <End Role="PipingSemiProbabilisticOutputEntity" Type="Self.PipingSemiProbabilisticOutputEntity" Multiplicity="*" />
+          <ReferentialConstraint>
+            <Principal Role="PipingCalculationEntity">
+              <PropertyRef Name="PipingCalculationEntityId" />
+            </Principal>
+            <Dependent Role="PipingSemiProbabilisticOutputEntity">
+              <PropertyRef Name="PipingCalculationEntityId" />
+            </Dependent>
+          </ReferentialConstraint>
+        </Association>
         <Association Name="FK_ReferenceLinePointEntity_0_0">
           <End Role="AssessmentSectionEntity" Type="Self.AssessmentSectionEntity" Multiplicity="1" />
           <End Role="ReferenceLinePointEntity" Type="Self.ReferenceLinePointEntity" Multiplicity="*" />
@@ -493,6 +527,7 @@
           <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="PipingSemiProbabilisticOutputEntity" EntityType="Self.PipingSemiProbabilisticOutputEntity" store:Type="Tables" />
           <EntitySet Name="ProjectEntity" EntityType="Self.ProjectEntity" store:Type="Tables" />
           <EntitySet Name="ReferenceLinePointEntity" EntityType="Self.ReferenceLinePointEntity" store:Type="Tables" />
           <EntitySet Name="SoilLayerEntity" EntityType="Self.SoilLayerEntity" store:Type="Tables" />
@@ -559,6 +594,10 @@
             <End Role="FailureMechanismEntity" EntitySet="FailureMechanismEntity" />
             <End Role="PipingFailureMechanismMetaEntity" EntitySet="PipingFailureMechanismMetaEntity" />
           </AssociationSet>
+          <AssociationSet Name="FK_PipingSemiProbabilisticOutputEntity_0_0" Association="Self.FK_PipingSemiProbabilisticOutputEntity_0_0">
+            <End Role="PipingCalculationEntity" EntitySet="PipingCalculationEntity" />
+            <End Role="PipingSemiProbabilisticOutputEntity" EntitySet="PipingSemiProbabilisticOutputEntity" />
+          </AssociationSet>
           <AssociationSet Name="FK_ReferenceLinePointEntity_0_0" Association="Self.FK_ReferenceLinePointEntity_0_0">
             <End Role="AssessmentSectionEntity" EntitySet="AssessmentSectionEntity" />
             <End Role="ReferenceLinePointEntity" EntitySet="ReferenceLinePointEntity" />
@@ -607,6 +646,7 @@
           <EntitySet Name="PipingCalculationEntities" EntityType="RingtoetsEntitiesModel.PipingCalculationEntity" />
           <EntitySet Name="PipingCalculationOutputEntities" EntityType="RingtoetsEntitiesModel.PipingCalculationOutputEntity" />
           <EntitySet Name="PipingFailureMechanismMetaEntities" EntityType="RingtoetsEntitiesModel.PipingFailureMechanismMetaEntity" />
+          <EntitySet Name="PipingSemiProbabilisticOutputEntities" EntityType="RingtoetsEntitiesModel.PipingSemiProbabilisticOutputEntity" />
           <EntitySet Name="ProjectEntities" EntityType="RingtoetsEntitiesModel.ProjectEntity" />
           <EntitySet Name="ReferenceLinePointEntities" EntityType="RingtoetsEntitiesModel.ReferenceLinePointEntity" />
           <EntitySet Name="SoilLayerEntities" EntityType="RingtoetsEntitiesModel.SoilLayerEntity" />
@@ -685,6 +725,10 @@
             <End Role="PipingCalculationEntity" EntitySet="PipingCalculationEntities" />
             <End Role="PipingCalculationOutputEntity" EntitySet="PipingCalculationOutputEntities" />
           </AssociationSet>
+          <AssociationSet Name="FK_PipingSemiProbabilisticOutputEntity_0_0" Association="RingtoetsEntitiesModel.FK_PipingSemiProbabilisticOutputEntity_0_0">
+            <End Role="PipingCalculationEntity" EntitySet="PipingCalculationEntities" />
+            <End Role="PipingSemiProbabilisticOutputEntity" EntitySet="PipingSemiProbabilisticOutputEntities" />
+          </AssociationSet>
           <AssociationSet Name="FK_SoilLayerEntity_0_0" Association="RingtoetsEntitiesModel.FK_SoilLayerEntity_0_0">
             <End Role="SoilProfileEntity" EntitySet="SoilProfileEntities" />
             <End Role="SoilLayerEntity" EntitySet="SoilLayerEntities" />
@@ -825,11 +869,13 @@
           <Property Name="SaturatedVolumicWeightOfCoverageLayerShift" Type="Decimal" Nullable="false" Precision="53" Scale="0" />
           <Property Name="RelevantForScenario" Type="Byte" Nullable="false" />
           <Property Name="ScenarioContribution" Type="Decimal" Nullable="false" Precision="53" Scale="0" />
+          <Property Name="PipingSemiProbabilisticOutputEntityId" Type="Int64" />
           <NavigationProperty Name="CalculationGroupEntity" Relationship="RingtoetsEntitiesModel.FK_PipingCalculationEntity_3_0" FromRole="PipingCalculationEntity" ToRole="CalculationGroupEntity" />
           <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" />
+          <NavigationProperty Name="PipingSemiProbabilisticOutputEntities" Relationship="RingtoetsEntitiesModel.FK_PipingSemiProbabilisticOutputEntity_0_0" FromRole="PipingCalculationEntity" ToRole="PipingSemiProbabilisticOutputEntity" />
         </EntityType>
         <EntityType Name="PipingCalculationOutputEntity">
           <Key>
@@ -854,6 +900,28 @@
           <Property Name="A" Type="Decimal" Nullable="false" Precision="53" Scale="0" />
           <NavigationProperty Name="FailureMechanismEntity" Relationship="RingtoetsEntitiesModel.FK_PipingFailureMechanismMetaEntity_0_0" FromRole="PipingFailureMechanismMetaEntity" ToRole="FailureMechanismEntity" />
         </EntityType>
+        <EntityType Name="PipingSemiProbabilisticOutputEntity">
+          <Key>
+            <PropertyRef Name="PipingSemiProbabilisticOutputEntityId" />
+          </Key>
+          <Property Name="PipingSemiProbabilisticOutputEntityId" Type="Int64" Nullable="false" annotation:StoreGeneratedPattern="Identity" />
+          <Property Name="PipingCalculationEntityId" Type="Int64" />
+          <Property Name="UpliftFactorOfSafety" Type="Decimal" Precision="53" Scale="0" />
+          <Property Name="UpliftReliability" Type="Decimal" Precision="53" Scale="0" />
+          <Property Name="UpliftProbability" Type="Decimal" Precision="53" Scale="0" />
+          <Property Name="HeaveFactorOfSafety" Type="Decimal" Precision="53" Scale="0" />
+          <Property Name="HeaveReliability" Type="Decimal" Precision="53" Scale="0" />
+          <Property Name="HeaveProbability" Type="Decimal" Precision="53" Scale="0" />
+          <Property Name="SellmeijerFactorOfSafety" Type="Decimal" Precision="53" Scale="0" />
+          <Property Name="SellmeijerReliability" Type="Decimal" Precision="53" Scale="0" />
+          <Property Name="SellmeijerProbability" Type="Decimal" Precision="53" Scale="0" />
+          <Property Name="RequiredProbability" Type="Decimal" Precision="53" Scale="0" />
+          <Property Name="RequiredReliability" Type="Decimal" Precision="53" Scale="0" />
+          <Property Name="PipingProbability" Type="Decimal" Precision="53" Scale="0" />
+          <Property Name="PipingReliability" Type="Decimal" Precision="53" Scale="0" />
+          <Property Name="PipingFactorOfSafety" Type="Decimal" Precision="53" Scale="0" />
+          <NavigationProperty Name="PipingCalculationEntity" Relationship="RingtoetsEntitiesModel.FK_PipingSemiProbabilisticOutputEntity_0_0" FromRole="PipingSemiProbabilisticOutputEntity" ToRole="PipingCalculationEntity" />
+        </EntityType>
         <EntityType Name="ProjectEntity">
           <Key>
             <PropertyRef Name="ProjectEntityId" />
@@ -1167,6 +1235,18 @@
             </Dependent>
           </ReferentialConstraint>
         </Association>
+        <Association Name="FK_PipingSemiProbabilisticOutputEntity_0_0">
+          <End Type="RingtoetsEntitiesModel.PipingCalculationEntity" Role="PipingCalculationEntity" Multiplicity="0..1" />
+          <End Type="RingtoetsEntitiesModel.PipingSemiProbabilisticOutputEntity" Role="PipingSemiProbabilisticOutputEntity" Multiplicity="*" />
+          <ReferentialConstraint>
+            <Principal Role="PipingCalculationEntity">
+              <PropertyRef Name="PipingCalculationEntityId" />
+            </Principal>
+            <Dependent Role="PipingSemiProbabilisticOutputEntity">
+              <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="*" />
@@ -1315,6 +1395,7 @@
           <EntitySetMapping Name="PipingCalculationEntities">
             <EntityTypeMapping TypeName="RingtoetsEntitiesModel.PipingCalculationEntity">
               <MappingFragment StoreEntitySet="PipingCalculationEntity">
+                <ScalarProperty Name="PipingSemiProbabilisticOutputEntityId" ColumnName="PipingSemiProbabilisticOutputEntityId" />
                 <ScalarProperty Name="ScenarioContribution" ColumnName="ScenarioContribution" />
                 <ScalarProperty Name="RelevantForScenario" ColumnName="RelevantForScenario" />
                 <ScalarProperty Name="SaturatedVolumicWeightOfCoverageLayerShift" ColumnName="SaturatedVolumicWeightOfCoverageLayerShift" />
@@ -1364,6 +1445,28 @@
               </MappingFragment>
             </EntityTypeMapping>
           </EntitySetMapping>
+          <EntitySetMapping Name="PipingSemiProbabilisticOutputEntities">
+            <EntityTypeMapping TypeName="RingtoetsEntitiesModel.PipingSemiProbabilisticOutputEntity">
+              <MappingFragment StoreEntitySet="PipingSemiProbabilisticOutputEntity">
+                <ScalarProperty Name="PipingFactorOfSafety" ColumnName="PipingFactorOfSafety" />
+                <ScalarProperty Name="PipingReliability" ColumnName="PipingReliability" />
+                <ScalarProperty Name="PipingProbability" ColumnName="PipingProbability" />
+                <ScalarProperty Name="RequiredReliability" ColumnName="RequiredReliability" />
+                <ScalarProperty Name="RequiredProbability" ColumnName="RequiredProbability" />
+                <ScalarProperty Name="SellmeijerProbability" ColumnName="SellmeijerProbability" />
+                <ScalarProperty Name="SellmeijerReliability" ColumnName="SellmeijerReliability" />
+                <ScalarProperty Name="SellmeijerFactorOfSafety" ColumnName="SellmeijerFactorOfSafety" />
+                <ScalarProperty Name="HeaveProbability" ColumnName="HeaveProbability" />
+                <ScalarProperty Name="HeaveReliability" ColumnName="HeaveReliability" />
+                <ScalarProperty Name="HeaveFactorOfSafety" ColumnName="HeaveFactorOfSafety" />
+                <ScalarProperty Name="UpliftProbability" ColumnName="UpliftProbability" />
+                <ScalarProperty Name="UpliftReliability" ColumnName="UpliftReliability" />
+                <ScalarProperty Name="UpliftFactorOfSafety" ColumnName="UpliftFactorOfSafety" />
+                <ScalarProperty Name="PipingCalculationEntityId" ColumnName="PipingCalculationEntityId" />
+                <ScalarProperty Name="PipingSemiProbabilisticOutputEntityId" ColumnName="PipingSemiProbabilisticOutputEntityId" />
+              </MappingFragment>
+            </EntityTypeMapping>
+          </EntitySetMapping>
           <EntitySetMapping Name="ProjectEntities">
             <EntityTypeMapping TypeName="RingtoetsEntitiesModel.ProjectEntity">
               <MappingFragment StoreEntitySet="ProjectEntity">