Index: Application/Ringtoets/src/Application.Ringtoets.Storage/Application.Ringtoets.Storage.csproj
===================================================================
diff -u -rfcfc245c8179a835256ae3d5fd84f35f9b8ec8aa -rdb6506035368f043c476a528c324f1a093759fca
--- Application/Ringtoets/src/Application.Ringtoets.Storage/Application.Ringtoets.Storage.csproj (.../Application.Ringtoets.Storage.csproj) (revision fcfc245c8179a835256ae3d5fd84f35f9b8ec8aa)
+++ Application/Ringtoets/src/Application.Ringtoets.Storage/Application.Ringtoets.Storage.csproj (.../Application.Ringtoets.Storage.csproj) (revision db6506035368f043c476a528c324f1a093759fca)
@@ -94,6 +94,9 @@
RingtoetsEntities.tt
+
+ RingtoetsEntities.tt
+
RingtoetsEntities.tt
Index: Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/ClosingStructuresCalculationEntity.cs
===================================================================
diff -u -rac7fcdda3d4fc6f28d2d466055769ff03f7580fd -rdb6506035368f043c476a528c324f1a093759fca
--- Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/ClosingStructuresCalculationEntity.cs (.../ClosingStructuresCalculationEntity.cs) (revision ac7fcdda3d4fc6f28d2d466055769ff03f7580fd)
+++ Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/ClosingStructuresCalculationEntity.cs (.../ClosingStructuresCalculationEntity.cs) (revision db6506035368f043c476a528c324f1a093759fca)
@@ -35,6 +35,12 @@
public partial class ClosingStructuresCalculationEntity
{
+ [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2214:DoNotCallOverridableMethodsInConstructors")]
+ public ClosingStructuresCalculationEntity()
+ {
+ this.ClosingStructuresOutputEntities = new HashSet();
+ }
+
public long ClosingStructuresCalculationEntityId { get; set; }
public long CalculationGroupEntityId { get; set; }
public Nullable ForeshoreProfileEntityId { get; set; }
@@ -83,5 +89,7 @@
public virtual ClosingStructureEntity ClosingStructureEntity { get; set; }
public virtual HydraulicLocationEntity HydraulicLocationEntity { get; set; }
public virtual ForeshoreProfileEntity ForeshoreProfileEntity { get; set; }
+ [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")]
+ public virtual ICollection ClosingStructuresOutputEntities { get; set; }
}
}
Index: Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/ClosingStructuresOutputEntity.cs
===================================================================
diff -u
--- Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/ClosingStructuresOutputEntity.cs (revision 0)
+++ Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/ClosingStructuresOutputEntity.cs (revision db6506035368f043c476a528c324f1a093759fca)
@@ -0,0 +1,48 @@
+// Copyright (C) Stichting Deltares 2016. All rights reserved.
+//
+// This file is part of Ringtoets.
+//
+// Ringtoets is free software: you can redistribute it and/or modify
+// it under the terms of the GNU General Public License as published by
+// the Free Software Foundation, either version 3 of the License, or
+// (at your option) any later version.
+//
+// This program is distributed in the hope that it will be useful,
+// but WITHOUT ANY WARRANTY; without even the implied warranty of
+// MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+// GNU General Public License for more details.
+//
+// You should have received a copy of the GNU General Public License
+// along with this program. If not, see .
+//
+// All names, logos, and references to "Deltares" are registered trademarks of
+// Stichting Deltares and remain full property of Stichting Deltares at all times.
+// All rights reserved.
+
+//------------------------------------------------------------------------------
+//
+// This code was generated from a template.
+//
+// Manual changes to this file may cause unexpected behavior in your application.
+// Manual changes to this file will be overwritten if the code is regenerated.
+//
+//------------------------------------------------------------------------------
+
+namespace Application.Ringtoets.Storage.DbContext
+{
+ using System;
+ using System.Collections.Generic;
+
+ public partial class ClosingStructuresOutputEntity
+ {
+ public long ClosingStructuresOutputEntityId { get; set; }
+ public long ClosingStructuresCalculationEntityId { get; set; }
+ public Nullable RequiredProbability { get; set; }
+ public Nullable RequiredReliability { get; set; }
+ public Nullable Probability { get; set; }
+ public Nullable Reliability { get; set; }
+ public Nullable FactorOfSafety { get; set; }
+
+ public virtual ClosingStructuresCalculationEntity ClosingStructuresCalculationEntity { get; set; }
+ }
+}
Index: Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql
===================================================================
diff -u -rfcfc245c8179a835256ae3d5fd84f35f9b8ec8aa -rdb6506035368f043c476a528c324f1a093759fca
--- Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision fcfc245c8179a835256ae3d5fd84f35f9b8ec8aa)
+++ Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision db6506035368f043c476a528c324f1a093759fca)
@@ -1,6 +1,6 @@
/* ---------------------------------------------------- */
/* Generated by Enterprise Architect Version 12.0 */
-/* Created On : 28-okt-2016 15:45:26 */
+/* Created On : 31-Oct-2016 8:01:41 AM */
/* DBMS : SQLite */
/* ---------------------------------------------------- */
@@ -9,13 +9,13 @@
DROP TABLE IF EXISTS 'VersionEntity'
;
-DROP TABLE IF EXISTS 'PipingFailureMechanismMetaEntity'
+DROP TABLE IF EXISTS 'StabilityPointStructuresCalculationEntity'
;
DROP TABLE IF EXISTS 'ProjectEntity'
;
-DROP TABLE IF EXISTS 'StabilityPointStructuresFailureMechanismMetaEntity'
+DROP TABLE IF EXISTS 'PipingFailureMechanismMetaEntity'
;
DROP TABLE IF EXISTS 'AssessmentSectionEntity'
@@ -27,12 +27,15 @@
DROP TABLE IF EXISTS 'FailureMechanismEntity'
;
-DROP TABLE IF EXISTS 'HeightStructuresFailureMechanismMetaEntity'
+DROP TABLE IF EXISTS 'StabilityPointStructuresFailureMechanismMetaEntity'
;
DROP TABLE IF EXISTS 'ClosingStructureFailureMechanismMetaEntity'
;
+DROP TABLE IF EXISTS 'HeightStructuresFailureMechanismMetaEntity'
+;
+
DROP TABLE IF EXISTS 'CalculationGroupEntity'
;
@@ -174,10 +177,10 @@
DROP TABLE IF EXISTS 'ClosingStructuresCalculationEntity'
;
-DROP TABLE IF EXISTS 'StabilityPointStructureEntity'
+DROP TABLE IF EXISTS 'ClosingStructuresOutputEntity'
;
-DROP TABLE IF EXISTS 'StabilityPointStructuresCalculationEntity'
+DROP TABLE IF EXISTS 'StabilityPointStructureEntity'
;
/* Create Tables with Primary and Foreign Keys, Check and Unique Constraints */
@@ -191,12 +194,75 @@
)
;
-CREATE TABLE 'PipingFailureMechanismMetaEntity'
+CREATE TABLE 'StabilityPointStructuresCalculationEntity'
(
- 'PipingFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
- 'FailureMechanismEntityId' INTEGER NOT NULL,
- 'A' REAL NOT NULL,
- CONSTRAINT 'FK_PipingFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade
+ 'StabilityPointStructuresCalculationEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
+ 'CalculationGroupEntityId' INTEGER NOT NULL,
+ 'ForeshoreProfileEntityId' INTEGER,
+ 'HydraulicLocationEntityId' INTEGER,
+ 'StabilityPointStructureEntityId' INTEGER,
+ 'Order' INT (4) NOT NULL,
+ 'Name' VARCHAR (260),
+ 'Comments' TEXT,
+ 'UseBreakWater' TINYINT (1),
+ 'BreakWaterType' SMALLINT NOT NULL,
+ 'BreakWaterHeight' REAL,
+ 'UseForeshore' TINYINT (1) NOT NULL,
+ 'StructureNormalOrientation' REAL,
+ 'StorageStructureAreaMean' REAL,
+ 'StorageStructureAreaCoefficientOfVariation' REAL,
+ 'AllowedLevelIncreaseStorageMean' REAL,
+ 'AllowedLevelIncreaseStorageStandardDeviation' REAL,
+ 'WidthFlowAperturesMean' REAL,
+ 'WidthFlowAperturesCoefficientOfVariation' REAL,
+ 'InsideWaterLevelMean' REAL,
+ 'InsideWaterLevelStandardDeviation' REAL,
+ 'ThresholdHeightOpenWeirMean' REAL,
+ 'ThresholdHeightOpenWeirStandardDeviation' REAL,
+ 'CriticalOvertoppingDischargeMean' REAL,
+ 'CriticalOvertoppingDischargeCoefficientOfVariation' REAL,
+ 'FlowWidthAtBottomProtectionMean' REAL,
+ 'FlowWidthAtBottomProtectionStandardDeviation' REAL,
+ 'ConstructiveStrengthLinearLoadModelMean' REAL,
+ 'ConstructiveStrengthLinearLoadModelCoefficientOfVariation' REAL,
+ 'ConstructiveStrengthQuadraticLoadModelMean' REAL,
+ 'ConstructiveStrengthQuadraticLoadModelCoefficientOfVariation' REAL,
+ 'BankWidthMean' REAL,
+ 'BankWidthStandardDeviation' REAL,
+ 'InsideWaterLevelFailureConstructionMean' REAL,
+ 'InsideWaterLevelFailureConstructionStandardDeviation' REAL,
+ 'EvaluationLevel' REAL,
+ 'LevelCrestStructureMean' REAL,
+ 'LevelCrestStructureStandardDeviation' REAL,
+ 'VerticalDistance' REAL,
+ 'FailureProbabilityRepairClosure' REAL NOT NULL,
+ 'FailureCollisionEnergyMean' REAL,
+ 'FailureCollisionEnergyCoefficientOfVariation' REAL,
+ 'ShipMassMean' REAL,
+ 'ShipMassCoefficientOfVariation' REAL,
+ 'ShipVelocityMean' REAL,
+ 'ShipVelocityCoefficientOfVariation' REAL,
+ 'LevellingCount' INT (4) NOT NULL,
+ 'ProbabilityCollisionSecondaryStructure' REAL NOT NULL,
+ 'FlowVelocityStructureClosableMean' REAL,
+ 'FlowVelocityStructureClosableStandardDeviation' REAL,
+ 'StabilityLinearLoadModelMean' REAL,
+ 'StabilityLinearLoadModelCoefficientOfVariation' REAL,
+ 'StabilityQuadraticLoadModelMean' REAL,
+ 'StabilityQuadraticLoadModelCoefficientOfVariation' REAL,
+ 'AreaFlowAperturesMean' REAL,
+ 'AreaFlowAperturesStandardDeviation' REAL,
+ 'InflowModelType' TINYINT (1) NOT NULL,
+ 'LoadSchematizationType' TINYINT (1) NOT NULL,
+ 'VolumicWeightWater' REAL,
+ 'StormDurationMean' REAL,
+ 'ModelFactorSuperCriticalFlowMean' REAL,
+ 'FactorStormDurationOpenStructure' REAL,
+ 'DrainCoefficientMean' REAL,
+ CONSTRAINT 'FK_StabilityPointStructuresCalculationEntity_CalculationGroupEntity' FOREIGN KEY ('CalculationGroupEntityId') REFERENCES 'CalculationGroupEntity' ('CalculationGroupEntityId') ON DELETE Cascade ON UPDATE Cascade,
+ CONSTRAINT 'FK_StabilityPointStructuresCalculationEntity_ForeshoreProfileEntity' FOREIGN KEY ('ForeshoreProfileEntityId') REFERENCES 'ForeshoreProfileEntity' ('ForeshoreProfileEntityId') ON DELETE Set Null ON UPDATE Set Null,
+ CONSTRAINT 'FK_StabilityPointStructuresCalculationEntity_HydraulicLocationEntity' FOREIGN KEY ('HydraulicLocationEntityId') REFERENCES 'HydraulicLocationEntity' ('HydraulicLocationEntityId') ON DELETE Set Null ON UPDATE Cascade,
+ CONSTRAINT 'FK_StabilityPointStructuresCalculationEntity_StabilityPointStructureEntity' FOREIGN KEY ('StabilityPointStructureEntityId') REFERENCES 'StabilityPointStructureEntity' ('StabilityPointStructureEntityId') ON DELETE Set Null ON UPDATE Set Null
)
;
@@ -207,12 +273,12 @@
)
;
-CREATE TABLE 'StabilityPointStructuresFailureMechanismMetaEntity'
+CREATE TABLE 'PipingFailureMechanismMetaEntity'
(
- 'StrengthStabilityPointConstructionFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
+ 'PipingFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
'FailureMechanismEntityId' INTEGER NOT NULL,
- 'N' INT (4) NOT NULL,
- CONSTRAINT 'FK_StrengthStabilityPointConstructionFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade
+ 'A' REAL NOT NULL,
+ CONSTRAINT 'FK_PipingFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade
)
;
@@ -257,12 +323,12 @@
)
;
-CREATE TABLE 'HeightStructuresFailureMechanismMetaEntity'
+CREATE TABLE 'StabilityPointStructuresFailureMechanismMetaEntity'
(
- 'HeightStructuresFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
+ 'StrengthStabilityPointConstructionFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
'FailureMechanismEntityId' INTEGER NOT NULL,
'N' INT (4) NOT NULL,
- CONSTRAINT 'FK_HeightStructuresFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade
+ CONSTRAINT 'FK_StrengthStabilityPointConstructionFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade
)
;
@@ -275,6 +341,15 @@
)
;
+CREATE TABLE 'HeightStructuresFailureMechanismMetaEntity'
+(
+ 'HeightStructuresFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
+ 'FailureMechanismEntityId' INTEGER NOT NULL,
+ 'N' INT (4) NOT NULL,
+ CONSTRAINT 'FK_HeightStructuresFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade
+)
+;
+
CREATE TABLE 'CalculationGroupEntity'
(
'CalculationGroupEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
@@ -1037,6 +1112,20 @@
)
;
+CREATE TABLE 'ClosingStructuresOutputEntity'
+(
+ 'ClosingStructuresOutputEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
+ 'ClosingStructuresCalculationEntityId' INTEGER NOT NULL,
+ 'RequiredProbability' REAL,
+ 'RequiredReliability' REAL,
+ 'Probability' REAL,
+ 'Reliability' REAL,
+ 'FactorOfSafety' REAL,
+ CONSTRAINT 'FK_ClosingStructuresOutputEntity_ClosingStructuresCalculationEntity' FOREIGN KEY ('ClosingStructuresCalculationEntityId') REFERENCES 'ClosingStructuresCalculationEntity' ('ClosingStructuresCalculationEntityId') ON DELETE Cascade ON UPDATE Cascade,
+ CONSTRAINT 'U_ClosingStructuresCalculationEntity' UNIQUE ('ClosingStructuresCalculationEntityId')
+)
+;
+
CREATE TABLE 'StabilityPointStructureEntity'
(
'StabilityPointStructureEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
@@ -1095,88 +1184,28 @@
)
;
-CREATE TABLE 'StabilityPointStructuresCalculationEntity'
-(
- 'StabilityPointStructuresCalculationEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
- 'CalculationGroupEntityId' INTEGER NOT NULL,
- 'ForeshoreProfileEntityId' INTEGER,
- 'HydraulicLocationEntityId' INTEGER,
- 'StabilityPointStructureEntityId' INTEGER,
- 'Order' INT (4) NOT NULL,
- 'Name' VARCHAR (260),
- 'Comments' TEXT,
- 'UseBreakWater' TINYINT (1),
- 'BreakWaterType' SMALLINT NOT NULL,
- 'BreakWaterHeight' REAL,
- 'UseForeshore' TINYINT (1) NOT NULL,
- 'StructureNormalOrientation' REAL,
- 'StorageStructureAreaMean' REAL,
- 'StorageStructureAreaCoefficientOfVariation' REAL,
- 'AllowedLevelIncreaseStorageMean' REAL,
- 'AllowedLevelIncreaseStorageStandardDeviation' REAL,
- 'WidthFlowAperturesMean' REAL,
- 'WidthFlowAperturesCoefficientOfVariation' REAL,
- 'InsideWaterLevelMean' REAL,
- 'InsideWaterLevelStandardDeviation' REAL,
- 'ThresholdHeightOpenWeirMean' REAL,
- 'ThresholdHeightOpenWeirStandardDeviation' REAL,
- 'CriticalOvertoppingDischargeMean' REAL,
- 'CriticalOvertoppingDischargeCoefficientOfVariation' REAL,
- 'FlowWidthAtBottomProtectionMean' REAL,
- 'FlowWidthAtBottomProtectionStandardDeviation' REAL,
- 'ConstructiveStrengthLinearLoadModelMean' REAL,
- 'ConstructiveStrengthLinearLoadModelCoefficientOfVariation' REAL,
- 'ConstructiveStrengthQuadraticLoadModelMean' REAL,
- 'ConstructiveStrengthQuadraticLoadModelCoefficientOfVariation' REAL,
- 'BankWidthMean' REAL,
- 'BankWidthStandardDeviation' REAL,
- 'InsideWaterLevelFailureConstructionMean' REAL,
- 'InsideWaterLevelFailureConstructionStandardDeviation' REAL,
- 'EvaluationLevel' REAL,
- 'LevelCrestStructureMean' REAL,
- 'LevelCrestStructureStandardDeviation' REAL,
- 'VerticalDistance' REAL,
- 'FailureProbabilityRepairClosure' REAL NOT NULL,
- 'FailureCollisionEnergyMean' REAL,
- 'FailureCollisionEnergyCoefficientOfVariation' REAL,
- 'ShipMassMean' REAL,
- 'ShipMassCoefficientOfVariation' REAL,
- 'ShipVelocityMean' REAL,
- 'ShipVelocityCoefficientOfVariation' REAL,
- 'LevellingCount' INT (4) NOT NULL,
- 'ProbabilityCollisionSecondaryStructure' REAL NOT NULL,
- 'FlowVelocityStructureClosableMean' REAL,
- 'FlowVelocityStructureClosableStandardDeviation' REAL,
- 'StabilityLinearLoadModelMean' REAL,
- 'StabilityLinearLoadModelCoefficientOfVariation' REAL,
- 'StabilityQuadraticLoadModelMean' REAL,
- 'StabilityQuadraticLoadModelCoefficientOfVariation' REAL,
- 'AreaFlowAperturesMean' REAL,
- 'AreaFlowAperturesStandardDeviation' REAL,
- 'InflowModelType' TINYINT (1) NOT NULL,
- 'LoadSchematizationType' TINYINT (1) NOT NULL,
- 'VolumicWeightWater' REAL,
- 'StormDurationMean' REAL,
- 'ModelFactorSuperCriticalFlowMean' REAL,
- 'FactorStormDurationOpenStructure' REAL,
- 'DrainCoefficientMean' REAL,
- CONSTRAINT 'FK_StabilityPointStructuresCalculationEntity_CalculationGroupEntity' FOREIGN KEY ('CalculationGroupEntityId') REFERENCES 'CalculationGroupEntity' ('CalculationGroupEntityId') ON DELETE Cascade ON UPDATE Cascade,
- CONSTRAINT 'FK_StabilityPointStructuresCalculationEntity_ForeshoreProfileEntity' FOREIGN KEY ('ForeshoreProfileEntityId') REFERENCES 'ForeshoreProfileEntity' ('ForeshoreProfileEntityId') ON DELETE Set Null ON UPDATE Set Null,
- CONSTRAINT 'FK_StabilityPointStructuresCalculationEntity_HydraulicLocationEntity' FOREIGN KEY ('HydraulicLocationEntityId') REFERENCES 'HydraulicLocationEntity' ('HydraulicLocationEntityId') ON DELETE Set Null ON UPDATE Cascade,
- CONSTRAINT 'FK_StabilityPointStructuresCalculationEntity_StabilityPointStructureEntity' FOREIGN KEY ('StabilityPointStructureEntityId') REFERENCES 'StabilityPointStructureEntity' ('StabilityPointStructureEntityId') ON DELETE Set Null ON UPDATE Set Null
-)
+/* Create Indexes and Triggers */
+
+CREATE INDEX 'IXFK_StabilityPointStructuresCalculationEntity_CalculationGroupEntity'
+ ON 'StabilityPointStructuresCalculationEntity' ('CalculationGroupEntityId' ASC)
;
-/* Create Indexes and Triggers */
+CREATE INDEX 'IXFK_StabilityPointStructuresCalculationEntity_ForeshoreProfileEntity'
+ ON 'StabilityPointStructuresCalculationEntity' ('ForeshoreProfileEntityId' ASC)
+;
-CREATE INDEX 'IXFK_PipingFailureMechanismMetaEntity_FailureMechanismEntity'
- ON 'PipingFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC)
+CREATE INDEX 'IXFK_StabilityPointStructuresCalculationEntity_HydraulicLocationEntity'
+ ON 'StabilityPointStructuresCalculationEntity' ('HydraulicLocationEntityId' ASC)
;
-CREATE INDEX 'IXFK_StrengthStabilityPointConstructionFailureMechanismMetaEntity_FailureMechanismEntity'
- ON 'StabilityPointStructuresFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC)
+CREATE INDEX 'IXFK_StabilityPointStructuresCalculationEntity_StabilityPointStructureEntity'
+ ON 'StabilityPointStructuresCalculationEntity' ('StabilityPointStructureEntityId' ASC)
;
+CREATE INDEX 'IXFK_PipingFailureMechanismMetaEntity_FailureMechanismEntity'
+ ON 'PipingFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC)
+;
+
CREATE INDEX 'IXFK_AssessmentSectionEntity_ProjectEntity'
ON 'AssessmentSectionEntity' ('ProjectEntityId' ASC)
;
@@ -1193,14 +1222,18 @@
ON 'FailureMechanismEntity' ('CalculationGroupEntityId' ASC)
;
-CREATE INDEX 'IXFK_HeightStructuresFailureMechanismMetaEntity_FailureMechanismEntity'
- ON 'HeightStructuresFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC)
+CREATE INDEX 'IXFK_StrengthStabilityPointConstructionFailureMechanismMetaEntity_FailureMechanismEntity'
+ ON 'StabilityPointStructuresFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC)
;
CREATE INDEX 'IXFK_ClosingStructureFailureMechanismMetaEntity_FailureMechanismEntity'
ON 'ClosingStructureFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC)
;
+CREATE INDEX 'IXFK_HeightStructuresFailureMechanismMetaEntity_FailureMechanismEntity'
+ ON 'HeightStructuresFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC)
+;
+
CREATE INDEX 'IXFK_CalculationGroupEntity_CalculationGroupEntity'
ON 'CalculationGroupEntity' ('ParentCalculationGroupEntityId' ASC)
;
@@ -1461,22 +1494,10 @@
ON 'ClosingStructuresCalculationEntity' ('HydraulicLocationEntityId' ASC)
;
+CREATE INDEX 'IXFK_ClosingStructuresOutputEntity_ClosingStructuresCalculationEntity'
+ ON 'ClosingStructuresOutputEntity' ('ClosingStructuresCalculationEntityId' ASC)
+;
+
CREATE INDEX 'IXFK_StabilityPointStructureEntity_FailureMechanismEntity'
ON 'StabilityPointStructureEntity' ('FailureMechanismEntityId' ASC)
;
-
-CREATE INDEX 'IXFK_StabilityPointStructuresCalculationEntity_CalculationGroupEntity'
- ON 'StabilityPointStructuresCalculationEntity' ('CalculationGroupEntityId' ASC)
-;
-
-CREATE INDEX 'IXFK_StabilityPointStructuresCalculationEntity_ForeshoreProfileEntity'
- ON 'StabilityPointStructuresCalculationEntity' ('ForeshoreProfileEntityId' ASC)
-;
-
-CREATE INDEX 'IXFK_StabilityPointStructuresCalculationEntity_HydraulicLocationEntity'
- ON 'StabilityPointStructuresCalculationEntity' ('HydraulicLocationEntityId' ASC)
-;
-
-CREATE INDEX 'IXFK_StabilityPointStructuresCalculationEntity_StabilityPointStructureEntity'
- ON 'StabilityPointStructuresCalculationEntity' ('StabilityPointStructureEntityId' ASC)
-;
Index: Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/RingtoetsEntities.Context.cs
===================================================================
diff -u -rfcfc245c8179a835256ae3d5fd84f35f9b8ec8aa -rdb6506035368f043c476a528c324f1a093759fca
--- Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/RingtoetsEntities.Context.cs (.../RingtoetsEntities.Context.cs) (revision fcfc245c8179a835256ae3d5fd84f35f9b8ec8aa)
+++ Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/RingtoetsEntities.Context.cs (.../RingtoetsEntities.Context.cs) (revision db6506035368f043c476a528c324f1a093759fca)
@@ -58,6 +58,7 @@
public virtual DbSet ClosingStructureEntities { get; set; }
public virtual DbSet ClosingStructureFailureMechanismMetaEntities { get; set; }
public virtual DbSet ClosingStructuresCalculationEntities { get; set; }
+ public virtual DbSet ClosingStructuresOutputEntities { get; set; }
public virtual DbSet ClosingStructuresSectionResultEntities { get; set; }
public virtual DbSet DikeProfileEntities { get; set; }
public virtual DbSet DuneErosionSectionResultEntities { get; set; }
Index: Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/RingtoetsEntities.Designer.cs
===================================================================
diff -u -rfcfc245c8179a835256ae3d5fd84f35f9b8ec8aa -rdb6506035368f043c476a528c324f1a093759fca
--- Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/RingtoetsEntities.Designer.cs (.../RingtoetsEntities.Designer.cs) (revision fcfc245c8179a835256ae3d5fd84f35f9b8ec8aa)
+++ Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/RingtoetsEntities.Designer.cs (.../RingtoetsEntities.Designer.cs) (revision db6506035368f043c476a528c324f1a093759fca)
@@ -1,4 +1,4 @@
-// T4 code generation is enabled for model 'D:\Clean_WTI2017\Application\Ringtoets\src\Application.Ringtoets.Storage\DbContext\RingtoetsEntities.edmx'.
+// T4 code generation is enabled for model 'D:\Projects\WTI\trunk\Application\Ringtoets\src\Application.Ringtoets.Storage\DbContext\RingtoetsEntities.edmx'.
// To enable legacy code generation, change the value of the 'Code Generation Strategy' designer
// property to 'Legacy ObjectContext'. This property is available in the Properties Window when the model
// is open in the designer.
Index: Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/RingtoetsEntities.edmx
===================================================================
diff -u -rfcfc245c8179a835256ae3d5fd84f35f9b8ec8aa -rdb6506035368f043c476a528c324f1a093759fca
--- Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/RingtoetsEntities.edmx (.../RingtoetsEntities.edmx) (revision fcfc245c8179a835256ae3d5fd84f35f9b8ec8aa)
+++ Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/RingtoetsEntities.edmx (.../RingtoetsEntities.edmx) (revision db6506035368f043c476a528c324f1a093759fca)
@@ -4,7 +4,7 @@
-
+
@@ -133,6 +133,18 @@
+
+
+
+
+
+
+
+
+
+
+
+
@@ -1014,6 +1026,18 @@
+
+
+
+
+
+
+
+
+
+
+
+
@@ -1861,6 +1885,7 @@
+
@@ -1949,6 +1974,10 @@
+
+
+
+
@@ -2241,6 +2270,7 @@
+
@@ -2369,6 +2399,10 @@
+
+
+
+
@@ -2759,7 +2793,21 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -3897,6 +3945,18 @@
+
+
+
+
+
+
+
+
+
+
+
+
@@ -4757,6 +4817,19 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
Index: Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/RingtoetsEntities.edmx.diagram
===================================================================
diff -u -rfcfc245c8179a835256ae3d5fd84f35f9b8ec8aa -rdb6506035368f043c476a528c324f1a093759fca
--- Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/RingtoetsEntities.edmx.diagram (.../RingtoetsEntities.edmx.diagram) (revision fcfc245c8179a835256ae3d5fd84f35f9b8ec8aa)
+++ Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/RingtoetsEntities.edmx.diagram (.../RingtoetsEntities.edmx.diagram) (revision db6506035368f043c476a528c324f1a093759fca)
@@ -118,64 +118,66 @@
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -195,6 +197,7 @@
+
@@ -651,6 +654,142 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
=======