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 @@ + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + =======