Index: Application/Ringtoets/src/Application.Ringtoets.Storage/Application.Ringtoets.Storage.csproj =================================================================== diff -u -rba2f4f4e1c7a194fbe370fe3beee83326e454e5d -r37652d7a208ab210033b48025d8d768d409086a8 --- Application/Ringtoets/src/Application.Ringtoets.Storage/Application.Ringtoets.Storage.csproj (.../Application.Ringtoets.Storage.csproj) (revision ba2f4f4e1c7a194fbe370fe3beee83326e454e5d) +++ Application/Ringtoets/src/Application.Ringtoets.Storage/Application.Ringtoets.Storage.csproj (.../Application.Ringtoets.Storage.csproj) (revision 37652d7a208ab210033b48025d8d768d409086a8) @@ -120,18 +120,12 @@ RingtoetsEntities.tt - - RingtoetsEntities.tt - RingtoetsEntities.tt RingtoetsEntities.tt - - RingtoetsEntities.tt - RingtoetsEntities.tt @@ -144,63 +138,33 @@ RingtoetsEntities.tt - - RingtoetsEntities.tt - RingtoetsEntities.tt - - RingtoetsEntities.tt - RingtoetsEntities.tt - - RingtoetsEntities.tt - RingtoetsEntities.tt - - RingtoetsEntities.tt - RingtoetsEntities.tt - - RingtoetsEntities.tt - RingtoetsEntities.tt - - RingtoetsEntities.tt - - - RingtoetsEntities.tt - RingtoetsEntities.tt RingtoetsEntities.tt - - RingtoetsEntities.tt - RingtoetsEntities.tt - - RingtoetsEntities.tt - RingtoetsEntities.tt - - RingtoetsEntities.tt - RingtoetsEntities.tt @@ -219,15 +183,9 @@ RingtoetsEntities.tt - - RingtoetsEntities.tt - RingtoetsEntities.tt - - RingtoetsEntities.tt - RingtoetsEntities.tt @@ -240,9 +198,6 @@ RingtoetsEntities.tt - - RingtoetsEntities.tt - RingtoetsEntities.tt @@ -255,15 +210,9 @@ RingtoetsEntities.tt - - RingtoetsEntities.tt - RingtoetsEntities.tt - - RingtoetsEntities.tt - RingtoetsEntities.tt @@ -273,24 +222,15 @@ RingtoetsEntities.tt - - RingtoetsEntities.tt - RingtoetsEntities.tt RingtoetsEntities.tt - - RingtoetsEntities.tt - RingtoetsEntities.tt - - RingtoetsEntities.tt - RingtoetsEntities.tt Index: Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/CalculationGroupEntity.cs =================================================================== diff -u -r21d94a2cc5a3a916d02a441f80414455b80d85dc -r37652d7a208ab210033b48025d8d768d409086a8 --- Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/CalculationGroupEntity.cs (.../CalculationGroupEntity.cs) (revision 21d94a2cc5a3a916d02a441f80414455b80d85dc) +++ Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/CalculationGroupEntity.cs (.../CalculationGroupEntity.cs) (revision 37652d7a208ab210033b48025d8d768d409086a8) @@ -40,8 +40,6 @@ { this.CalculationGroupEntity1 = new HashSet(); this.FailureMechanismEntities = new HashSet(); - this.GrassCoverErosionInwardsCalculationEntities = new HashSet(); - this.HeightStructuresCalculationEntities = new HashSet(); this.PipingCalculationEntities = new HashSet(); } @@ -57,10 +55,6 @@ [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")] public virtual ICollection FailureMechanismEntities { get; set; } [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")] - public virtual ICollection GrassCoverErosionInwardsCalculationEntities { get; set; } - [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")] - public virtual ICollection HeightStructuresCalculationEntities { get; set; } - [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")] public virtual ICollection PipingCalculationEntities { get; set; } } } Fisheye: Tag 37652d7a208ab210033b48025d8d768d409086a8 refers to a dead (removed) revision in file `Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/ClosingStructureFailureMechanismMetaEntity.cs'. Fisheye: No comparison available. Pass `N' to diff? Index: Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql =================================================================== diff -u -r8130cde70fa4a5ef16789bad2a8b64175d77d9a2 -r37652d7a208ab210033b48025d8d768d409086a8 --- Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 8130cde70fa4a5ef16789bad2a8b64175d77d9a2) +++ Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 37652d7a208ab210033b48025d8d768d409086a8) @@ -1,6 +1,6 @@ /* ---------------------------------------------------- */ /* Generated by Enterprise Architect Version 12.0 */ -/* Created On : 12-jul-2016 15:59:10 */ +/* Created On : 13-jul-2016 12:00:00 */ /* DBMS : SQLite */ /* ---------------------------------------------------- */ @@ -9,186 +9,126 @@ DROP TABLE IF EXISTS 'VersionEntity' ; -DROP TABLE IF EXISTS 'WaveImpactAsphaltCoverSectionResultEntity' +DROP TABLE IF EXISTS 'PipingFailureMechanismMetaEntity' ; DROP TABLE IF EXISTS 'ProjectEntity' ; -DROP TABLE IF EXISTS 'WaterPressureAsphaltCoverSectionResultEntity' -; - DROP TABLE IF EXISTS 'AssessmentSectionEntity' ; -DROP TABLE IF EXISTS 'FailureMechanismEntity' -; - DROP TABLE IF EXISTS 'FailureMechanismSectionEntity' ; -DROP TABLE IF EXISTS 'ClosingStructureFailureMechanismMetaEntity' +DROP TABLE IF EXISTS 'FailureMechanismEntity' ; -DROP TABLE IF EXISTS 'TechnicalInnovationSectionResultEntity' -; - DROP TABLE IF EXISTS 'FailureMechanismSectionPointEntity' ; -DROP TABLE IF EXISTS 'TechnicalInnovationFailureMechanismMetaEntity' -; - DROP TABLE IF EXISTS 'CalculationGroupEntity' ; DROP TABLE IF EXISTS 'HydraulicLocationEntity' ; -DROP TABLE IF EXISTS 'GrassCoverErosionInwardsFailureMechanismMetaEntity' -; - DROP TABLE IF EXISTS 'PipingCalculationEntity' ; -DROP TABLE IF EXISTS 'GrassCoverSlipOffInwardsFailureMechanismMetaEntity' +DROP TABLE IF EXISTS 'GrassCoverErosionInwardsFailureMechanismMetaEntity' ; -DROP TABLE IF EXISTS 'StrengthStabilityPointConstructionSectionResultEntity' -; - -DROP TABLE IF EXISTS 'GrassCoverErosionInwardsCalculationEntity' -; - -DROP TABLE IF EXISTS 'GrassCoverErosionOutwardsFailureMechanismMetaEntity' -; - DROP TABLE IF EXISTS 'ReferenceLinePointEntity' ; -DROP TABLE IF EXISTS 'StrengthStabilityPointConstructionFailureMechanismMetaEntity' +DROP TABLE IF EXISTS 'SoilProfileEntity' ; -DROP TABLE IF EXISTS 'StrengthStabilityLengthwiseConstructionSectionResultEntity' -; - DROP TABLE IF EXISTS 'SoilLayerEntity' ; -DROP TABLE IF EXISTS 'SoilProfileEntity' -; - -DROP TABLE IF EXISTS 'GrassCoverErosionInwardsRoughnessProfileSectionEntity' -; - -DROP TABLE IF EXISTS 'StrengthStabilityLengthwiseConstructionFailureMechanismMetaEntity' -; - DROP TABLE IF EXISTS 'StochasticSoilProfileEntity' ; DROP TABLE IF EXISTS 'StochasticSoilModelEntity' ; -DROP TABLE IF EXISTS 'StochasticSoilModelSegmentPointEntity' -; - DROP TABLE IF EXISTS 'SurfaceLineEntity' ; DROP TABLE IF EXISTS 'SurfaceLinePointEntity' ; -DROP TABLE IF EXISTS 'StabilityStoneCoverSectionResultEntity' +DROP TABLE IF EXISTS 'PipingCalculationOutputEntity' ; -DROP TABLE IF EXISTS 'StabilityStoneCoverFailureMechanismMetaEntity' +DROP TABLE IF EXISTS 'StochasticSoilModelSegmentPointEntity' ; -DROP TABLE IF EXISTS 'ProbabilisticOutputEntity' +DROP TABLE IF EXISTS 'CharacteristicPointEntity' ; -DROP TABLE IF EXISTS 'PipingStructureSectionResultEntity' -; - -DROP TABLE IF EXISTS 'PipingStructureFailureMechanismMetaEntity' -; - DROP TABLE IF EXISTS 'PipingSemiProbabilisticOutputEntity' ; DROP TABLE IF EXISTS 'PipingSectionResultEntity' ; -DROP TABLE IF EXISTS 'PipingFailureMechanismMetaEntity' +DROP TABLE IF EXISTS 'GrassCoverErosionInwardsSectionResultEntity' ; -DROP TABLE IF EXISTS 'PipingCalculationOutputEntity' +DROP TABLE IF EXISTS 'HeightStructuresSectionResultEntity' ; -DROP TABLE IF EXISTS 'MicrostabilitySectionResultEntity' +DROP TABLE IF EXISTS 'StrengthStabilityLengthwiseConstructionSectionResultEntity' ; -DROP TABLE IF EXISTS 'MicrostabilityFailureMechanismMetaEntity' +DROP TABLE IF EXISTS 'TechnicalInnovationSectionResultEntity' ; -DROP TABLE IF EXISTS 'MacrostabilityOutwardsSectionResultEntity' +DROP TABLE IF EXISTS 'WaterPressureAsphaltCoverSectionResultEntity' ; -DROP TABLE IF EXISTS 'MacrostabilityOutwardsFailureMechanismMetaEntity' +DROP TABLE IF EXISTS 'ClosingStructureSectionResultEntity' ; -DROP TABLE IF EXISTS 'MacrostabilityInwardsSectionResultEntity' +DROP TABLE IF EXISTS 'GrassCoverErosionOutwardsSectionResultEntity' ; -DROP TABLE IF EXISTS 'MacrostabilityInwardsFailureMechanismMetaEntity' +DROP TABLE IF EXISTS 'GrassCoverSlipOffInwardsSectionResultEntity' ; -DROP TABLE IF EXISTS 'HeightStructuresSectionResultEntity' +DROP TABLE IF EXISTS 'GrassCoverSlipOffOutwardsSectionResultEntity' ; -DROP TABLE IF EXISTS 'HeightStructuresFailureMechanismMetaEntity' +DROP TABLE IF EXISTS 'MacrostabilityInwardsSectionResultEntity' ; -DROP TABLE IF EXISTS 'WaterPressureAsphaltCoverFailureMechanismMetaEntity' +DROP TABLE IF EXISTS 'MacrostabilityOutwardsSectionResultEntity' ; -DROP TABLE IF EXISTS 'HeightStructuresCalculationEntity' +DROP TABLE IF EXISTS 'WaveImpactAsphaltCoverSectionResultEntity' ; -DROP TABLE IF EXISTS 'WaveImpactAsphaltCoverFailureMechanismMetaEntity' +DROP TABLE IF EXISTS 'MicrostabilitySectionResultEntity' ; -DROP TABLE IF EXISTS 'GrassCoverSlipOffOutwardsSectionResultEntity' +DROP TABLE IF EXISTS 'PipingStructureSectionResultEntity' ; -DROP TABLE IF EXISTS 'GrassCoverSlipOffOutwardsFailureMechanismMetaEntity' +DROP TABLE IF EXISTS 'DuneErosionSectionResultEntity' ; -DROP TABLE IF EXISTS 'GrassCoverSlipOffInwardsSectionResultEntity' +DROP TABLE IF EXISTS 'StabilityStoneCoverSectionResultEntity' ; -DROP TABLE IF EXISTS 'GrassCoverErosionOutwardsSectionResultEntity' +DROP TABLE IF EXISTS 'StrengthStabilityPointConstructionSectionResultEntity' ; -DROP TABLE IF EXISTS 'GrassCoverErosionInwardsSectionResultEntity' -; - -DROP TABLE IF EXISTS 'DuneErosionSectionResultEntity' -; - -DROP TABLE IF EXISTS 'DuneErosionFailureMechanismMetaEntity' -; - DROP TABLE IF EXISTS 'DikeProfileEntity' ; -DROP TABLE IF EXISTS 'ClosingStructureSectionResultEntity' -; - -DROP TABLE IF EXISTS 'CharacteristicPointEntity' -; - /* Create Tables with Primary and Foreign Keys, Check and Unique Constraints */ CREATE TABLE 'VersionEntity' @@ -200,14 +140,12 @@ ) ; -CREATE TABLE 'WaveImpactAsphaltCoverSectionResultEntity' +CREATE TABLE 'PipingFailureMechanismMetaEntity' ( - 'WaveImpactAsphaltCoverSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismSectionEntityId' INTEGER NOT NULL, - 'LayerOne' TINYINT (1) NOT NULL, -- true or false - 'LayerTwoA' NUMERIC, - 'LayerThree' NUMERIC, - CONSTRAINT 'FK_WaveImpactAsphaltCoverSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade + '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 ) ; @@ -218,16 +156,6 @@ ) ; -CREATE TABLE 'WaterPressureAsphaltCoverSectionResultEntity' -( - 'WaterPressureAsphaltCoverSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismSectionEntityId' INTEGER NOT NULL, - 'LayerOne' TINYINT (1) NOT NULL, -- true or false - 'LayerThree' NUMERIC, - CONSTRAINT 'FK_WaterPressureAsphaltCoverSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade -) -; - CREATE TABLE 'AssessmentSectionEntity' ( 'AssessmentSectionEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -243,6 +171,15 @@ ) ; +CREATE TABLE 'FailureMechanismSectionEntity' +( + 'FailureMechanismSectionEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'FailureMechanismEntityId' INTEGER NOT NULL, + 'Name' VARCHAR (260) NOT NULL, + CONSTRAINT 'FK_FailureMechanismSectionEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade +) +; + CREATE TABLE 'FailureMechanismEntity' ( 'FailureMechanismEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -257,33 +194,6 @@ ) ; -CREATE TABLE 'FailureMechanismSectionEntity' -( - 'FailureMechanismSectionEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismEntityId' INTEGER NOT NULL, - 'Name' VARCHAR (260) NOT NULL, - CONSTRAINT 'FK_FailureMechanismSectionEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade -) -; - -CREATE TABLE 'ClosingStructureFailureMechanismMetaEntity' -( - 'ClosingStructureFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismEntityId' INTEGER, - CONSTRAINT 'FK_ClosingStructureFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade -) -; - -CREATE TABLE 'TechnicalInnovationSectionResultEntity' -( - 'TechnicalInnovationSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismSectionEntityId' INTEGER NOT NULL, - 'LayerOne' TINYINT (1) NOT NULL, -- true or false - 'LayerThree' NUMERIC, - CONSTRAINT 'FK_TechnicalInnovationSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade -) -; - CREATE TABLE 'FailureMechanismSectionPointEntity' ( 'FailureMechanismSectionPointEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -295,14 +205,6 @@ ) ; -CREATE TABLE 'TechnicalInnovationFailureMechanismMetaEntity' -( - 'TechnicalInnovationFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismEntityId' INTEGER, - CONSTRAINT 'FK_TechnicalInnovationFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade -) -; - CREATE TABLE 'CalculationGroupEntity' ( 'CalculationGroupEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -327,15 +229,6 @@ ) ; -CREATE TABLE 'GrassCoverErosionInwardsFailureMechanismMetaEntity' -( - 'GrassCoverErosionInwardsFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismEntityId' INTEGER NOT NULL, - 'N' INT (4) NOT NULL, - CONSTRAINT 'FK_GrassCoverErosionInwardsFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade -) -; - CREATE TABLE 'PipingCalculationEntity' ( 'PipingCalculationEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -372,55 +265,15 @@ ) ; -CREATE TABLE 'GrassCoverSlipOffInwardsFailureMechanismMetaEntity' +CREATE TABLE 'GrassCoverErosionInwardsFailureMechanismMetaEntity' ( - 'GrassCoverSlipOffInwardsFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismEntityId' INTEGER, - CONSTRAINT 'FK_GrassCoverSlipOffInwardsFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade + 'GrassCoverErosionInwardsFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'FailureMechanismEntityId' INTEGER NOT NULL, + 'N' INT (4) NOT NULL, + CONSTRAINT 'FK_GrassCoverErosionInwardsFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade ) ; -CREATE TABLE 'StrengthStabilityPointConstructionSectionResultEntity' -( - 'StrengthStabilityPointConstructionSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismSectionEntityId' INTEGER NOT NULL, - 'LayerTwoA' NUMERIC, - 'LayerThree' NUMERIC, - CONSTRAINT 'FK_StrengthStabilityPointConstructionSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade -) -; - -CREATE TABLE 'GrassCoverErosionInwardsCalculationEntity' -( - 'GrassCoverErosionInwardsCalculationEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'CalculationGroupEntityId' INTEGER NOT NULL, - 'HydraulicLocationEntityId' INTEGER, - 'ProbabilisticOutputEntityId' INTEGER, - 'Order' INT (4) NOT NULL, - 'Name' VARCHAR (260), - 'Comments' TEXT, - 'Orientation' NUMERIC NOT NULL, - 'CriticalFlowRateMean' NUMERIC NOT NULL, - 'CriticalFlowRateStandardDeviation' NUMERIC NOT NULL, - 'UseForeshore' TINYINT (1) NOT NULL, - 'DikeHeight' NUMERIC NOT NULL, - 'UseBreakWater' TINYINT (1) NOT NULL, - 'BreakWaterType' SMALLINT NOT NULL, - 'BreakWaterHeight' NUMERIC NOT NULL, - CONSTRAINT 'FK_GrassCoverErosionInwardsCalculationEntity_CalculationGroupEntity' FOREIGN KEY ('CalculationGroupEntityId') REFERENCES 'CalculationGroupEntity' ('CalculationGroupEntityId') ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT 'FK_GrassCoverErosionInwardsCalculationEntity_HydraulicLocationEntity' FOREIGN KEY ('HydraulicLocationEntityId') REFERENCES 'HydraulicLocationEntity' ('HydraulicLocationEntityId') ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT 'FK_GrassCoverErosionInwardsCalculationEntity_ProbabilisticOutputEntity' FOREIGN KEY ('ProbabilisticOutputEntityId') REFERENCES 'ProbabilisticOutputEntity' ('ProbabilisticOutputEntityId') ON DELETE Set Null ON UPDATE Set Null -) -; - -CREATE TABLE 'GrassCoverErosionOutwardsFailureMechanismMetaEntity' -( - 'GrassCoverErosionOutwardsFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismEntityId' INTEGER, - CONSTRAINT 'FK_GrassCoverErosionOutwardsFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade -) -; - CREATE TABLE 'ReferenceLinePointEntity' ( 'ReferenceLinePointEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -432,68 +285,32 @@ ) ; -CREATE TABLE 'StrengthStabilityPointConstructionFailureMechanismMetaEntity' +CREATE TABLE 'SoilProfileEntity' ( - 'StrengthStabilityPointConstructionFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismEntityId' INTEGER, - CONSTRAINT 'FK_StrengthStabilityPointConstructionFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade + 'SoilProfileEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'Bottom' NUMERIC NOT NULL, + 'Name' TEXT ) ; -CREATE TABLE 'StrengthStabilityLengthwiseConstructionSectionResultEntity' -( - 'StrengthStabilityLengthwiseConstructionSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismSectionEntityId' INTEGER NOT NULL, - 'LayerOne' TINYINT (1) NOT NULL, -- true or false - 'LayerThree' NUMERIC, - CONSTRAINT 'FK_StrengthStabilityLengthwiseConstructionSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade -) -; - CREATE TABLE 'SoilLayerEntity' ( 'SoilLayerEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'SoilProfileEntityId' INTEGER NOT NULL, - 'Top' NUMERIC NOT NULL, + 'Top' REAL NOT NULL, 'IsAquifer' TINYINT (1) NOT NULL, -- true or false 'Color' INTEGER NOT NULL, -- ARGB value of Color. 'MaterialName' TEXT NOT NULL, - 'AbovePhreaticLevel' NUMERIC, - 'BelowPhreaticLevel' NUMERIC, - 'DryUnitWeight' NUMERIC, + 'BelowPhreaticLevelMean' REAL, + 'BelowPhreaticLevelDeviation' REAL, + 'DiameterD70Mean' REAL, + 'DiameterD70Deviation' REAL, + 'PermeabilityMean' REAL, + 'PermeabilityDeviation' REAL, CONSTRAINT 'FK_SoilLayerEntity_SoilProfileEntity' FOREIGN KEY ('SoilProfileEntityId') REFERENCES 'SoilProfileEntity' ('SoilProfileEntityId') ON DELETE Cascade ON UPDATE Cascade ) ; -CREATE TABLE 'SoilProfileEntity' -( - 'SoilProfileEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'Bottom' NUMERIC NOT NULL, - 'Name' TEXT -) -; - -CREATE TABLE 'GrassCoverErosionInwardsRoughnessProfileSectionEntity' -( - 'GrassCoverErosionInwardsRoughnessProfileSectionEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'GrassCoverErosionInwardsCalculationEntityId' INTEGER NOT NULL, - 'StartPointX' NUMERIC NOT NULL, - 'StartPointY' INTEGER NOT NULL, - 'EndPointX' NUMERIC NOT NULL, - 'EndPointY' NUMERIC NOT NULL, - 'Roughness' NUMERIC NOT NULL, - CONSTRAINT 'FK_GrassCoverErosionInwardsRoughnessProfileSectionEntity_GrassCoverErosionInwardsCalculationEntity' FOREIGN KEY ('GrassCoverErosionInwardsCalculationEntityId') REFERENCES 'GrassCoverErosionInwardsCalculationEntity' ('GrassCoverErosionInwardsCalculationEntityId') ON DELETE Cascade ON UPDATE Cascade -) -; - -CREATE TABLE 'StrengthStabilityLengthwiseConstructionFailureMechanismMetaEntity' -( - 'StrengthStabilityLengthwiseConstructionFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismEntityId' INTEGER, - CONSTRAINT 'FK_StrengthStabilityLengthwiseConstructionFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade -) -; - CREATE TABLE 'StochasticSoilProfileEntity' ( 'StochasticSoilProfileEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -515,17 +332,6 @@ ) ; -CREATE TABLE 'StochasticSoilModelSegmentPointEntity' -( - 'StochasticSoilModelSegmentPointEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'StochasticSoilModelEntityId' INTEGER NOT NULL, - 'X' NUMERIC NOT NULL, - 'Y' NUMERIC NOT NULL, - 'Order' INT (4) NOT NULL, - CONSTRAINT 'FK_StochasticSoilModelSegmentPointEntity_StochasticSoilModelEntity' FOREIGN KEY ('StochasticSoilModelEntityId') REFERENCES 'StochasticSoilModelEntity' ('StochasticSoilModelEntityId') ON DELETE No Action ON UPDATE No Action -) -; - CREATE TABLE 'SurfaceLineEntity' ( 'SurfaceLineEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -549,54 +355,38 @@ ) ; -CREATE TABLE 'StabilityStoneCoverSectionResultEntity' +CREATE TABLE 'PipingCalculationOutputEntity' ( - 'StabilityStoneCoverSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismSectionEntityId' INTEGER NOT NULL, - 'LayerTwoA' TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated 2 = Failed 3 = Succesful - 'LayerThree' NUMERIC, - CONSTRAINT 'FK_StabilityStoneCoverSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade + 'PipingCalculationOutputEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'HeaveFactorOfSafety' NUMERIC, + 'HeaveZValue' NUMERIC, + 'UpliftFactorOfSafety' NUMERIC, + 'UpliftZValue' NUMERIC, + 'SellmeijerFactorOfSafety' NUMERIC, + 'SellmeijerZValue' NUMERIC ) ; -CREATE TABLE 'StabilityStoneCoverFailureMechanismMetaEntity' +CREATE TABLE 'StochasticSoilModelSegmentPointEntity' ( - 'StabilityStoneCoverFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismEntityId' INTEGER, - CONSTRAINT 'FK_StabilityStoneCoverFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade + 'StochasticSoilModelSegmentPointEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'StochasticSoilModelEntityId' INTEGER NOT NULL, + 'X' NUMERIC NOT NULL, + 'Y' NUMERIC NOT NULL, + 'Order' INT (4) NOT NULL, + CONSTRAINT 'FK_StochasticSoilModelSegmentPointEntity_StochasticSoilModelEntity' FOREIGN KEY ('StochasticSoilModelEntityId') REFERENCES 'StochasticSoilModelEntity' ('StochasticSoilModelEntityId') ON DELETE No Action ON UPDATE No Action ) ; -CREATE TABLE 'ProbabilisticOutputEntity' +CREATE TABLE 'CharacteristicPointEntity' ( - 'ProbabilisticOutputEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'RequiredProbability' NUMERIC, - 'RequiredReliability' NUMERIC, - 'Probability' NUMERIC, - 'Reliability' NUMERIC, - 'FactorOfSafety' NUMERIC + '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 'PipingStructureSectionResultEntity' -( - 'PipingStructureSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismSectionEntityId' INTEGER NOT NULL, - 'LayerOne' TINYINT (1) NOT NULL, -- true or false - 'LayerTwoA' TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated 2 = Failed 3 = Succesful - 'LayerThree' NUMERIC, - CONSTRAINT 'FK_PipingStructureSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade -) -; - -CREATE TABLE 'PipingStructureFailureMechanismMetaEntity' -( - 'PipingStructureFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismEntityId' INTEGER, - CONSTRAINT 'FK_PipingStructureFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade -) -; - CREATE TABLE 'PipingSemiProbabilisticOutputEntity' ( 'PipingSemiProbabilisticOutputEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -627,218 +417,182 @@ ) ; -CREATE TABLE 'PipingFailureMechanismMetaEntity' +CREATE TABLE 'GrassCoverErosionInwardsSectionResultEntity' ( - '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 + 'GrassCoverErosionInwardsSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'FailureMechanismSectionEntityId' INTEGER NOT NULL, + 'LayerOne' TINYINT (1) NOT NULL, -- true or false + 'LayerThree' NUMERIC, + CONSTRAINT 'FK_GrassCoverErosionInwardsSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade ) ; -CREATE TABLE 'PipingCalculationOutputEntity' +CREATE TABLE 'HeightStructuresSectionResultEntity' ( - 'PipingCalculationOutputEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'HeaveFactorOfSafety' NUMERIC, - 'HeaveZValue' NUMERIC, - 'UpliftFactorOfSafety' NUMERIC, - 'UpliftZValue' NUMERIC, - 'SellmeijerFactorOfSafety' NUMERIC, - 'SellmeijerZValue' NUMERIC + 'HeightStructuresSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'FailureMechanismSectionEntityId' INTEGER NOT NULL, + 'LayerOne' TINYINT (1) NOT NULL, -- true or false + 'LayerThree' NUMERIC, + CONSTRAINT 'FK_HeightStructuresSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade ) ; -CREATE TABLE 'MicrostabilitySectionResultEntity' +CREATE TABLE 'StrengthStabilityLengthwiseConstructionSectionResultEntity' ( - 'MicrostabilitySectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'StrengthStabilityLengthwiseConstructionSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismSectionEntityId' INTEGER NOT NULL, 'LayerOne' TINYINT (1) NOT NULL, -- true or false - 'LayerTwoA' TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated 2 = Failed 3 = Succesful 'LayerThree' NUMERIC, - CONSTRAINT 'FK_MicrostabilitySectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade + CONSTRAINT 'FK_StrengthStabilityLengthwiseConstructionSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade ) ; -CREATE TABLE 'MicrostabilityFailureMechanismMetaEntity' +CREATE TABLE 'TechnicalInnovationSectionResultEntity' ( - 'MicrostabilityFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismEntityId' INTEGER, - CONSTRAINT 'FK_MicrostabilityFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade + 'TechnicalInnovationSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'FailureMechanismSectionEntityId' INTEGER NOT NULL, + 'LayerOne' TINYINT (1) NOT NULL, -- true or false + 'LayerThree' NUMERIC, + CONSTRAINT 'FK_TechnicalInnovationSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade ) ; -CREATE TABLE 'MacrostabilityOutwardsSectionResultEntity' +CREATE TABLE 'WaterPressureAsphaltCoverSectionResultEntity' ( - 'MacrostabilityOutwardsSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'WaterPressureAsphaltCoverSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismSectionEntityId' INTEGER NOT NULL, 'LayerOne' TINYINT (1) NOT NULL, -- true or false - 'LayerTwoA' NUMERIC, 'LayerThree' NUMERIC, - CONSTRAINT 'FK_MacrostabilityOutwardsSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade + CONSTRAINT 'FK_WaterPressureAsphaltCoverSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade ) ; -CREATE TABLE 'MacrostabilityOutwardsFailureMechanismMetaEntity' +CREATE TABLE 'ClosingStructureSectionResultEntity' ( - 'MacrostabilityOutwardsFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismEntityId' INTEGER, - CONSTRAINT 'FK_MacrostabilityOutwardsFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade -) -; - -CREATE TABLE 'MacrostabilityInwardsSectionResultEntity' -( - 'MacrostabilityInwardsSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'ClosingStructureSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismSectionEntityId' INTEGER NOT NULL, 'LayerOne' TINYINT (1) NOT NULL, -- true or false 'LayerTwoA' NUMERIC, 'LayerThree' NUMERIC, - CONSTRAINT 'FK_MacrostabilityInwardsSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade + CONSTRAINT 'FK_ClosingStructureSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade ) ; -CREATE TABLE 'MacrostabilityInwardsFailureMechanismMetaEntity' +CREATE TABLE 'GrassCoverErosionOutwardsSectionResultEntity' ( - 'MacrostabilityInwardsFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismEntityId' INTEGER, - CONSTRAINT 'FK_MacrostabilityInwardsFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade + 'GrassCoverErosionOutwardsSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'FailureMechanismSectionEntityId' INTEGER NOT NULL, + 'LayerOne' TINYINT (1) NOT NULL, -- true or false + 'LayerTwoA' TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated 2 = Failed 3 = Succesful + 'LayerThree' NUMERIC, + CONSTRAINT 'FK_GrassCoverErosionOutwardsSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade ) ; -CREATE TABLE 'HeightStructuresSectionResultEntity' +CREATE TABLE 'GrassCoverSlipOffInwardsSectionResultEntity' ( - 'HeightStructuresSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'GrassCoverSlipOffInwardsSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismSectionEntityId' INTEGER NOT NULL, 'LayerOne' TINYINT (1) NOT NULL, -- true or false + 'LayerTwoA' TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated 2 = Failed 3 = Succesful 'LayerThree' NUMERIC, - CONSTRAINT 'FK_HeightStructuresSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade + CONSTRAINT 'FK_GrassCoverSlipOffInwardsSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade ) ; -CREATE TABLE 'HeightStructuresFailureMechanismMetaEntity' +CREATE TABLE 'GrassCoverSlipOffOutwardsSectionResultEntity' ( - 'HeightStructuresFailureMechanismMetaEntity' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismEntityId' INTEGER, - 'N' NUMERIC, - CONSTRAINT 'FK_HeightStructuresFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade + 'GrassCoverSlipOffOutwardsSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'FailureMechanismSectionEntityId' INTEGER NOT NULL, + 'LayerOne' TINYINT (1) NOT NULL, -- true or false + 'LayerTwoA' TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated 2 = Failed 3 = Succesful + 'LayerThree' NUMERIC, + CONSTRAINT 'FK_GrassCoverSlipOffOutwardsSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade ) ; -CREATE TABLE 'WaterPressureAsphaltCoverFailureMechanismMetaEntity' +CREATE TABLE 'MacrostabilityInwardsSectionResultEntity' ( - 'WaterPressureAsphaltCoverFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismEntityId' INTEGER, - CONSTRAINT 'FK_WaterPressureAsphaltCoverFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade + 'MacrostabilityInwardsSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'FailureMechanismSectionEntityId' INTEGER NOT NULL, + 'LayerOne' TINYINT (1) NOT NULL, -- true or false + 'LayerTwoA' NUMERIC, + 'LayerThree' NUMERIC, + CONSTRAINT 'FK_MacrostabilityInwardsSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade ) ; -CREATE TABLE 'HeightStructuresCalculationEntity' +CREATE TABLE 'MacrostabilityOutwardsSectionResultEntity' ( - 'HeightStructuresCalculationEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'CalculationGroupEntityId' INTEGER NOT NULL, - 'HydraulicLocationEntityId' INTEGER, - 'ProbabilisticOutputEntityId' INTEGER, - 'Order' INT (4) NOT NULL, - 'Name' VARCHAR (260), - 'Comments' TEXT, - 'ModelFactorOvertoppingSuperCriticalFlowMean' NUMERIC NOT NULL, - 'DeviationOfTheWaveDirection' NUMERIC NOT NULL, - 'StormDurationMean' NUMERIC NOT NULL, - 'StormDurationVariation' NUMERIC NOT NULL, - 'LevelOfCrestOfStructureMean' NUMERIC NOT NULL, - 'LevelOfCrestOfStructureStandardDeviation' NUMERIC NOT NULL, - 'OrientationOfTheNormalOfTheStructure' NUMERIC NOT NULL, - 'AllowableIncreaseOfLevelForStorageMean' NUMERIC NOT NULL, - 'AllowableIncreaseOfLevelForStorageStandardDeviation' NUMERIC NOT NULL, - 'StorageStructureAreaMean' NUMERIC NOT NULL, - 'StorageStructureAreaVariation' NUMERIC NOT NULL, - 'FlowWidthAtBottomProtectionMean' NUMERIC NOT NULL, - 'FlowWidthAtBottomProtectionStandardDeviation' NUMERIC NOT NULL, - 'CriticalOvertoppingDischargeMean' NUMERIC NOT NULL, - 'CriticalOvertoppingDischargeVariation' NUMERIC NOT NULL, - 'FailureProbabilityOfStructureGivenErosion' NUMERIC NOT NULL, - 'WidthOfFlowAperturesMean' NUMERIC NOT NULL, - 'WidthOfFlowAperturesStandardDeviation' NUMERIC NOT NULL, - CONSTRAINT 'FK_HeightStructuresCalculationEntity_CalculationGroupEntity' FOREIGN KEY ('CalculationGroupEntityId') REFERENCES 'CalculationGroupEntity' ('CalculationGroupEntityId') ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT 'FK_HeightStructuresCalculationEntity_HydraulicLocationEntity' FOREIGN KEY ('HydraulicLocationEntityId') REFERENCES 'HydraulicLocationEntity' ('HydraulicLocationEntityId') ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT 'FK_HeightStructuresCalculationEntity_ProbabilisticOutputEntity' FOREIGN KEY ('ProbabilisticOutputEntityId') REFERENCES 'ProbabilisticOutputEntity' ('ProbabilisticOutputEntityId') ON DELETE Set Null ON UPDATE Set Null + 'MacrostabilityOutwardsSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'FailureMechanismSectionEntityId' INTEGER NOT NULL, + 'LayerOne' TINYINT (1) NOT NULL, -- true or false + 'LayerTwoA' NUMERIC, + 'LayerThree' NUMERIC, + CONSTRAINT 'FK_MacrostabilityOutwardsSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade ) ; -CREATE TABLE 'WaveImpactAsphaltCoverFailureMechanismMetaEntity' +CREATE TABLE 'WaveImpactAsphaltCoverSectionResultEntity' ( - 'WaveImpactAsphaltCoverFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismEntityId' INTEGER, - CONSTRAINT 'FK_WaveImpactAsphaltCoverFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade -) -; - -CREATE TABLE 'GrassCoverSlipOffOutwardsSectionResultEntity' -( - 'GrassCoverSlipOffOutwardsSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'WaveImpactAsphaltCoverSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismSectionEntityId' INTEGER NOT NULL, 'LayerOne' TINYINT (1) NOT NULL, -- true or false - 'LayerTwoA' TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated 2 = Failed 3 = Succesful + 'LayerTwoA' NUMERIC, 'LayerThree' NUMERIC, - CONSTRAINT 'FK_GrassCoverSlipOffOutwardsSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade + CONSTRAINT 'FK_WaveImpactAsphaltCoverSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade ) ; -CREATE TABLE 'GrassCoverSlipOffOutwardsFailureMechanismMetaEntity' +CREATE TABLE 'MicrostabilitySectionResultEntity' ( - 'GrassCoverSlipOffOutwardsFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismEntityId' INTEGER, - CONSTRAINT 'FK_GrassCoverSlipOffOutwardsFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade -) -; - -CREATE TABLE 'GrassCoverSlipOffInwardsSectionResultEntity' -( - 'GrassCoverSlipOffInwardsSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'MicrostabilitySectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismSectionEntityId' INTEGER NOT NULL, 'LayerOne' TINYINT (1) NOT NULL, -- true or false 'LayerTwoA' TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated 2 = Failed 3 = Succesful 'LayerThree' NUMERIC, - CONSTRAINT 'FK_GrassCoverSlipOffInwardsSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade + CONSTRAINT 'FK_MicrostabilitySectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade ) ; -CREATE TABLE 'GrassCoverErosionOutwardsSectionResultEntity' +CREATE TABLE 'PipingStructureSectionResultEntity' ( - 'GrassCoverErosionOutwardsSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'PipingStructureSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismSectionEntityId' INTEGER NOT NULL, 'LayerOne' TINYINT (1) NOT NULL, -- true or false 'LayerTwoA' TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated 2 = Failed 3 = Succesful 'LayerThree' NUMERIC, - CONSTRAINT 'FK_GrassCoverErosionOutwardsSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade + CONSTRAINT 'FK_PipingStructureSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade ) ; -CREATE TABLE 'GrassCoverErosionInwardsSectionResultEntity' +CREATE TABLE 'DuneErosionSectionResultEntity' ( - 'GrassCoverErosionInwardsSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'DuneErosionSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismSectionEntityId' INTEGER NOT NULL, - 'LayerOne' TINYINT (1) NOT NULL, -- true or false + 'LayerTwoA' TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated 2 = Failed 3 = Succesful 'LayerThree' NUMERIC, - CONSTRAINT 'FK_GrassCoverErosionInwardsSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade + CONSTRAINT 'FK_DuneErosionSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade ) ; -CREATE TABLE 'DuneErosionSectionResultEntity' +CREATE TABLE 'StabilityStoneCoverSectionResultEntity' ( - 'DuneErosionSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'StabilityStoneCoverSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismSectionEntityId' INTEGER NOT NULL, 'LayerTwoA' TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated 2 = Failed 3 = Succesful 'LayerThree' NUMERIC, - CONSTRAINT 'FK_DuneErosionSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade + CONSTRAINT 'FK_StabilityStoneCoverSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade ) ; -CREATE TABLE 'DuneErosionFailureMechanismMetaEntity' +CREATE TABLE 'StrengthStabilityPointConstructionSectionResultEntity' ( - 'DuneErosionFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismEntityId' INTEGER, - CONSTRAINT 'FK_DuneErosionFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade + 'StrengthStabilityPointConstructionSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'FailureMechanismSectionEntityId' INTEGER NOT NULL, + 'LayerTwoA' NUMERIC, + 'LayerThree' NUMERIC, + CONSTRAINT 'FK_StrengthStabilityPointConstructionSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade ) ; @@ -853,44 +607,26 @@ 'ForeShoreData' BLOB NOT NULL, 'DikeGeometryData' BLOB NOT NULL, 'DikeHeight' REAL NOT NULL, + 'X' REAL NOT NULL, + 'Y' REAL NOT NULL, CONSTRAINT 'FK_DikeProfileEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade ) ; -CREATE TABLE 'ClosingStructureSectionResultEntity' -( - 'ClosingStructureSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismSectionEntityId' INTEGER NOT NULL, - 'LayerOne' TINYINT (1) NOT NULL, -- true or false - 'LayerTwoA' NUMERIC, - 'LayerThree' NUMERIC, - CONSTRAINT 'FK_ClosingStructureSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade -) -; - -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_WaveImpactAsphaltCoverSectionResultEntity_FailureMechanismSectionEntity' - ON 'WaveImpactAsphaltCoverSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) +CREATE INDEX 'IXFK_PipingFailureMechanismMetaEntity_FailureMechanismEntity' + ON 'PipingFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) ; -CREATE INDEX 'IXFK_WaterPressureAsphaltCoverSectionResultEntity_FailureMechanismSectionEntity' - ON 'WaterPressureAsphaltCoverSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) -; - CREATE INDEX 'IXFK_AssessmentSectionEntity_ProjectEntity' ON 'AssessmentSectionEntity' ('ProjectEntityId' ASC) ; +CREATE INDEX 'IXFK_FailureMechanismSectionEntity_FailureMechanismEntity' + ON 'FailureMechanismSectionEntity' ('FailureMechanismEntityId' ASC) +; + CREATE INDEX 'IXFK_FailureMechanismEntity_AssessmentSectionEntity' ON 'FailureMechanismEntity' ('AssessmentSectionEntityId' ASC) ; @@ -899,26 +635,10 @@ ON 'FailureMechanismEntity' ('CalculationGroupEntityId' ASC) ; -CREATE INDEX 'IXFK_FailureMechanismSectionEntity_FailureMechanismEntity' - ON 'FailureMechanismSectionEntity' ('FailureMechanismEntityId' ASC) -; - -CREATE INDEX 'IXFK_ClosingStructureFailureMechanismMetaEntity_FailureMechanismEntity' - ON 'ClosingStructureFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) -; - -CREATE INDEX 'IXFK_TechnicalInnovationSectionResultEntity_FailureMechanismSectionEntity' - ON 'TechnicalInnovationSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) -; - CREATE INDEX 'IXFK_FailureMechanismSectionPointEntity_FailureMechanismSectionEntity' ON 'FailureMechanismSectionPointEntity' ('FailureMechanismSectionEntityId' ASC) ; -CREATE INDEX 'IXFK_TechnicalInnovationFailureMechanismMetaEntity_FailureMechanismEntity' - ON 'TechnicalInnovationFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) -; - CREATE INDEX 'IXFK_CalculationGroupEntity_CalculationGroupEntity' ON 'CalculationGroupEntity' ('ParentCalculationGroupEntityId' ASC) ; @@ -927,10 +647,6 @@ ON 'HydraulicLocationEntity' ('AssessmentSectionEntityId' ASC) ; -CREATE INDEX 'IXFK_GrassCoverErosionInwardsFailureMechanismMetaEntity_FailureMechanismEntity' - ON 'GrassCoverErosionInwardsFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) -; - CREATE INDEX 'IXFK_PipingCalculationEntity_PipingCalculationOutputEntity' ON 'PipingCalculationEntity' ('PipingCalculationOutputEntityId' ASC) ; @@ -955,50 +671,14 @@ ON 'PipingCalculationEntity' ('CalculationGroupEntityId' ASC) ; -CREATE INDEX 'IXFK_GrassCoverSlipOffInwardsFailureMechanismMetaEntity_FailureMechanismEntity' - ON 'GrassCoverSlipOffInwardsFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) +CREATE INDEX 'IXFK_GrassCoverErosionInwardsFailureMechanismMetaEntity_FailureMechanismEntity' + ON 'GrassCoverErosionInwardsFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) ; -CREATE INDEX 'IXFK_StrengthStabilityPointConstructionSectionResultEntity_FailureMechanismSectionEntity' - ON 'StrengthStabilityPointConstructionSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) -; - -CREATE INDEX 'IXFK_GrassCoverErosionInwardsCalculationEntity_CalculationGroupEntity' - ON 'GrassCoverErosionInwardsCalculationEntity' ('CalculationGroupEntityId' ASC) -; - -CREATE INDEX 'IXFK_GrassCoverErosionInwardsCalculationEntity_HydraulicLocationEntity' - ON 'GrassCoverErosionInwardsCalculationEntity' ('HydraulicLocationEntityId' ASC) -; - -CREATE INDEX 'IXFK_GrassCoverErosionInwardsCalculationEntity_ProbabilisticOutputEntity' - ON 'GrassCoverErosionInwardsCalculationEntity' ('ProbabilisticOutputEntityId' ASC) -; - -CREATE INDEX 'IXFK_GrassCoverErosionOutwardsFailureMechanismMetaEntity_FailureMechanismEntity' - ON 'GrassCoverErosionOutwardsFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) -; - CREATE INDEX 'IXFK_ReferenceLinePointEntity_AssessmentSectionEntity' ON 'ReferenceLinePointEntity' ('AssessmentSectionEntityId' ASC) ; -CREATE INDEX 'IXFK_StrengthStabilityPointConstructionFailureMechanismMetaEntity_FailureMechanismEntity' - ON 'StrengthStabilityPointConstructionFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) -; - -CREATE INDEX 'IXFK_StrengthStabilityLengthwiseConstructionSectionResultEntity_FailureMechanismSectionEntity' - ON 'StrengthStabilityLengthwiseConstructionSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) -; - -CREATE INDEX 'IXFK_GrassCoverErosionInwardsRoughnessProfileSectionEntity_GrassCoverErosionInwardsCalculationEntity' - ON 'GrassCoverErosionInwardsRoughnessProfileSectionEntity' ('GrassCoverErosionInwardsCalculationEntityId' ASC) -; - -CREATE INDEX 'IXFK_StrengthStabilityLengthwiseConstructionFailureMechanismMetaEntity_FailureMechanismEntity' - ON 'StrengthStabilityLengthwiseConstructionFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) -; - CREATE INDEX 'IXFK_StochasticSoilProfileEntity_SoilProfileEntity' ON 'StochasticSoilProfileEntity' ('SoilProfileEntityId' ASC) ; @@ -1019,118 +699,82 @@ ON 'SurfaceLinePointEntity' ('SurfaceLineEntityId' ASC) ; -CREATE INDEX 'IXFK_StabilityStoneCoverSectionResultEntity_FailureMechanismSectionEntity' - ON 'StabilityStoneCoverSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) +CREATE INDEX 'IXFK_CharacteristicPointEntity_SurfaceLinePointEntity' + ON 'CharacteristicPointEntity' ('SurfaceLinePointEntityId' ASC) ; -CREATE INDEX 'IXFK_StabilityStoneCoverFailureMechanismMetaEntity_FailureMechanismEntity' - ON 'StabilityStoneCoverFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) -; - -CREATE INDEX 'IXFK_PipingStructureSectionResultEntity_FailureMechanismSectionEntity' - ON 'PipingStructureSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) -; - -CREATE INDEX 'IXFK_PipingStructureFailureMechanismMetaEntity_FailureMechanismEntity' - ON 'PipingStructureFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) -; - CREATE INDEX 'IXFK_PipingSectionResultEntity_FailureMechanismSectionEntity' ON 'PipingSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) ; -CREATE INDEX 'IXFK_PipingFailureMechanismMetaEntity_FailureMechanismEntity' - ON 'PipingFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) +CREATE INDEX 'IXFK_GrassCoverErosionInwardsSectionResultEntity_FailureMechanismSectionEntity' + ON 'GrassCoverErosionInwardsSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) ; -CREATE INDEX 'IXFK_MicrostabilitySectionResultEntity_FailureMechanismSectionEntity' - ON 'MicrostabilitySectionResultEntity' ('FailureMechanismSectionEntityId' ASC) -; - -CREATE INDEX 'IXFK_MicrostabilityFailureMechanismMetaEntity_FailureMechanismEntity' - ON 'MicrostabilityFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) -; - -CREATE INDEX 'IXFK_MacrostabilityOutwardsSectionResultEntity_FailureMechanismSectionEntity' - ON 'MacrostabilityOutwardsSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) -; - -CREATE INDEX 'IXFK_MacrostabilityOutwardsFailureMechanismMetaEntity_FailureMechanismEntity' - ON 'MacrostabilityOutwardsFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) -; - -CREATE INDEX 'IXFK_MacrostabilityInwardsSectionResultEntity_FailureMechanismSectionEntity' - ON 'MacrostabilityInwardsSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) -; - -CREATE INDEX 'IXFK_MacrostabilityInwardsFailureMechanismMetaEntity_FailureMechanismEntity' - ON 'MacrostabilityInwardsFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) -; - CREATE INDEX 'IXFK_HeightStructuresSectionResultEntity_FailureMechanismSectionEntity' ON 'HeightStructuresSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) ; -CREATE INDEX 'IXFK_HeightStructuresFailureMechanismMetaEntity_FailureMechanismEntity' - ON 'HeightStructuresFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) +CREATE INDEX 'IXFK_StrengthStabilityLengthwiseConstructionSectionResultEntity_FailureMechanismSectionEntity' + ON 'StrengthStabilityLengthwiseConstructionSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) ; -CREATE INDEX 'IXFK_WaterPressureAsphaltCoverFailureMechanismMetaEntity_FailureMechanismEntity' - ON 'WaterPressureAsphaltCoverFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) +CREATE INDEX 'IXFK_TechnicalInnovationSectionResultEntity_FailureMechanismSectionEntity' + ON 'TechnicalInnovationSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) ; -CREATE INDEX 'IXFK_HeightStructuresCalculationEntity_CalculationGroupEntity' - ON 'HeightStructuresCalculationEntity' ('CalculationGroupEntityId' ASC) +CREATE INDEX 'IXFK_WaterPressureAsphaltCoverSectionResultEntity_FailureMechanismSectionEntity' + ON 'WaterPressureAsphaltCoverSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) ; -CREATE INDEX 'IXFK_HeightStructuresCalculationEntity_HydraulicLocationEntity' - ON 'HeightStructuresCalculationEntity' ('HydraulicLocationEntityId' ASC) +CREATE INDEX 'IXFK_ClosingStructureSectionResultEntity_FailureMechanismSectionEntity' + ON 'ClosingStructureSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) ; -CREATE INDEX 'IXFK_HeightStructuresCalculationEntity_ProbabilisticOutputEntity' - ON 'HeightStructuresCalculationEntity' ('ProbabilisticOutputEntityId' ASC) +CREATE INDEX 'IXFK_GrassCoverErosionOutwardsSectionResultEntity_FailureMechanismSectionEntity' + ON 'GrassCoverErosionOutwardsSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) ; -CREATE INDEX 'IXFK_WaveImpactAsphaltCoverFailureMechanismMetaEntity_FailureMechanismEntity' - ON 'WaveImpactAsphaltCoverFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) +CREATE INDEX 'IXFK_GrassCoverSlipOffInwardsSectionResultEntity_FailureMechanismSectionEntity' + ON 'GrassCoverSlipOffInwardsSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) ; CREATE INDEX 'IXFK_GrassCoverSlipOffOutwardsSectionResultEntity_FailureMechanismSectionEntity' ON 'GrassCoverSlipOffOutwardsSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) ; -CREATE INDEX 'IXFK_GrassCoverSlipOffOutwardsFailureMechanismMetaEntity_FailureMechanismEntity' - ON 'GrassCoverSlipOffOutwardsFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) +CREATE INDEX 'IXFK_MacrostabilityInwardsSectionResultEntity_FailureMechanismSectionEntity' + ON 'MacrostabilityInwardsSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) ; -CREATE INDEX 'IXFK_GrassCoverSlipOffInwardsSectionResultEntity_FailureMechanismSectionEntity' - ON 'GrassCoverSlipOffInwardsSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) +CREATE INDEX 'IXFK_MacrostabilityOutwardsSectionResultEntity_FailureMechanismSectionEntity' + ON 'MacrostabilityOutwardsSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) ; -CREATE INDEX 'IXFK_GrassCoverErosionOutwardsSectionResultEntity_FailureMechanismSectionEntity' - ON 'GrassCoverErosionOutwardsSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) +CREATE INDEX 'IXFK_WaveImpactAsphaltCoverSectionResultEntity_FailureMechanismSectionEntity' + ON 'WaveImpactAsphaltCoverSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) ; -CREATE INDEX 'IXFK_GrassCoverErosionInwardsSectionResultEntity_FailureMechanismSectionEntity' - ON 'GrassCoverErosionInwardsSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) +CREATE INDEX 'IXFK_MicrostabilitySectionResultEntity_FailureMechanismSectionEntity' + ON 'MicrostabilitySectionResultEntity' ('FailureMechanismSectionEntityId' ASC) ; +CREATE INDEX 'IXFK_PipingStructureSectionResultEntity_FailureMechanismSectionEntity' + ON 'PipingStructureSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) +; + CREATE INDEX 'IXFK_DuneErosionSectionResultEntity_FailureMechanismSectionEntity' ON 'DuneErosionSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) ; -CREATE INDEX 'IXFK_DuneErosionFailureMechanismMetaEntity_FailureMechanismEntity' - ON 'DuneErosionFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) +CREATE INDEX 'IXFK_StabilityStoneCoverSectionResultEntity_FailureMechanismSectionEntity' + ON 'StabilityStoneCoverSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) ; +CREATE INDEX 'IXFK_StrengthStabilityPointConstructionSectionResultEntity_FailureMechanismSectionEntity' + ON 'StrengthStabilityPointConstructionSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) +; + CREATE INDEX 'IXFK_DikeProfileEntity_FailureMechanismEntity' ON 'DikeProfileEntity' ('FailureMechanismEntityId' ASC) ; - -CREATE INDEX 'IXFK_ClosingStructureSectionResultEntity_FailureMechanismSectionEntity' - ON 'ClosingStructureSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) -; - -CREATE INDEX 'IXFK_CharacteristicPointEntity_SurfaceLinePointEntity' - ON 'CharacteristicPointEntity' ('SurfaceLinePointEntityId' ASC) -; Index: Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DikeProfileEntity.cs =================================================================== diff -u -r8130cde70fa4a5ef16789bad2a8b64175d77d9a2 -r37652d7a208ab210033b48025d8d768d409086a8 --- Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DikeProfileEntity.cs (.../DikeProfileEntity.cs) (revision 8130cde70fa4a5ef16789bad2a8b64175d77d9a2) +++ Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DikeProfileEntity.cs (.../DikeProfileEntity.cs) (revision 37652d7a208ab210033b48025d8d768d409086a8) @@ -44,6 +44,8 @@ public byte[] ForeShoreData { get; set; } public byte[] DikeGeometryData { get; set; } public double DikeHeight { get; set; } + public double X { get; set; } + public double Y { get; set; } public virtual FailureMechanismEntity FailureMechanismEntity { get; set; } } Fisheye: Tag 37652d7a208ab210033b48025d8d768d409086a8 refers to a dead (removed) revision in file `Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DuneErosionFailureMechanismMetaEntity.cs'. Fisheye: No comparison available. Pass `N' to diff? Index: Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/FailureMechanismEntity.cs =================================================================== diff -u -r8130cde70fa4a5ef16789bad2a8b64175d77d9a2 -r37652d7a208ab210033b48025d8d768d409086a8 --- Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/FailureMechanismEntity.cs (.../FailureMechanismEntity.cs) (revision 8130cde70fa4a5ef16789bad2a8b64175d77d9a2) +++ Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/FailureMechanismEntity.cs (.../FailureMechanismEntity.cs) (revision 37652d7a208ab210033b48025d8d768d409086a8) @@ -38,28 +38,12 @@ [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2214:DoNotCallOverridableMethodsInConstructors")] public FailureMechanismEntity() { - this.ClosingStructureFailureMechanismMetaEntities = new HashSet(); this.DikeProfileEntities = new HashSet(); - this.DuneErosionFailureMechanismMetaEntities = new HashSet(); this.FailureMechanismSectionEntities = new HashSet(); this.GrassCoverErosionInwardsFailureMechanismMetaEntities = new HashSet(); - this.GrassCoverErosionOutwardsFailureMechanismMetaEntities = new HashSet(); - this.GrassCoverSlipOffInwardsFailureMechanismMetaEntities = new HashSet(); - this.GrassCoverSlipOffOutwardsFailureMechanismMetaEntities = new HashSet(); - this.HeightStructuresFailureMechanismMetaEntities = new HashSet(); - this.MacrostabilityInwardsFailureMechanismMetaEntities = new HashSet(); - this.MacrostabilityOutwardsFailureMechanismMetaEntities = new HashSet(); - this.MicrostabilityFailureMechanismMetaEntities = new HashSet(); this.PipingFailureMechanismMetaEntities = new HashSet(); - this.PipingStructureFailureMechanismMetaEntities = new HashSet(); - this.StabilityStoneCoverFailureMechanismMetaEntities = new HashSet(); this.StochasticSoilModelEntities = new HashSet(); - this.StrengthStabilityLengthwiseConstructionFailureMechanismMetaEntities = new HashSet(); - this.StrengthStabilityPointConstructionFailureMechanismMetaEntities = new HashSet(); this.SurfaceLineEntities = new HashSet(); - this.TechnicalInnovationFailureMechanismMetaEntities = new HashSet(); - this.WaterPressureAsphaltCoverFailureMechanismMetaEntities = new HashSet(); - this.WaveImpactAsphaltCoverFailureMechanismMetaEntities = new HashSet(); } public long FailureMechanismEntityId { get; set; } @@ -72,48 +56,16 @@ public virtual AssessmentSectionEntity AssessmentSectionEntity { get; set; } public virtual CalculationGroupEntity CalculationGroupEntity { get; set; } [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")] - public virtual ICollection ClosingStructureFailureMechanismMetaEntities { get; set; } - [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")] public virtual ICollection DikeProfileEntities { get; set; } [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")] - public virtual ICollection DuneErosionFailureMechanismMetaEntities { get; set; } - [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")] public virtual ICollection FailureMechanismSectionEntities { get; set; } [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")] public virtual ICollection GrassCoverErosionInwardsFailureMechanismMetaEntities { get; set; } [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")] - public virtual ICollection GrassCoverErosionOutwardsFailureMechanismMetaEntities { get; set; } - [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")] - public virtual ICollection GrassCoverSlipOffInwardsFailureMechanismMetaEntities { get; set; } - [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")] - public virtual ICollection GrassCoverSlipOffOutwardsFailureMechanismMetaEntities { get; set; } - [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")] - public virtual ICollection HeightStructuresFailureMechanismMetaEntities { get; set; } - [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")] - public virtual ICollection MacrostabilityInwardsFailureMechanismMetaEntities { get; set; } - [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")] - public virtual ICollection MacrostabilityOutwardsFailureMechanismMetaEntities { get; set; } - [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")] - public virtual ICollection MicrostabilityFailureMechanismMetaEntities { get; set; } - [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")] public virtual ICollection PipingFailureMechanismMetaEntities { get; set; } [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")] - public virtual ICollection PipingStructureFailureMechanismMetaEntities { get; set; } - [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")] - public virtual ICollection StabilityStoneCoverFailureMechanismMetaEntities { get; set; } - [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")] public virtual ICollection StochasticSoilModelEntities { get; set; } [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")] - public virtual ICollection StrengthStabilityLengthwiseConstructionFailureMechanismMetaEntities { get; set; } - [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")] - public virtual ICollection StrengthStabilityPointConstructionFailureMechanismMetaEntities { get; set; } - [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")] public virtual ICollection SurfaceLineEntities { get; set; } - [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")] - public virtual ICollection TechnicalInnovationFailureMechanismMetaEntities { get; set; } - [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")] - public virtual ICollection WaterPressureAsphaltCoverFailureMechanismMetaEntities { get; set; } - [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")] - public virtual ICollection WaveImpactAsphaltCoverFailureMechanismMetaEntities { get; set; } } } Fisheye: Tag 37652d7a208ab210033b48025d8d768d409086a8 refers to a dead (removed) revision in file `Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/GrassCoverErosionInwardsCalculationEntity.cs'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag 37652d7a208ab210033b48025d8d768d409086a8 refers to a dead (removed) revision in file `Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/GrassCoverErosionInwardsRoughnessProfileSectionEntity.cs'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag 37652d7a208ab210033b48025d8d768d409086a8 refers to a dead (removed) revision in file `Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/GrassCoverErosionOutwardsFailureMechanismMetaEntity.cs'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag 37652d7a208ab210033b48025d8d768d409086a8 refers to a dead (removed) revision in file `Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/GrassCoverSlipOffInwardsFailureMechanismMetaEntity.cs'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag 37652d7a208ab210033b48025d8d768d409086a8 refers to a dead (removed) revision in file `Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/GrassCoverSlipOffOutwardsFailureMechanismMetaEntity.cs'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag 37652d7a208ab210033b48025d8d768d409086a8 refers to a dead (removed) revision in file `Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/HeightStructuresCalculationEntity.cs'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag 37652d7a208ab210033b48025d8d768d409086a8 refers to a dead (removed) revision in file `Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/HeightStructuresFailureMechanismMetaEntity.cs'. Fisheye: No comparison available. Pass `N' to diff? Index: Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/HydraulicLocationEntity.cs =================================================================== diff -u -r21d94a2cc5a3a916d02a441f80414455b80d85dc -r37652d7a208ab210033b48025d8d768d409086a8 --- Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/HydraulicLocationEntity.cs (.../HydraulicLocationEntity.cs) (revision 21d94a2cc5a3a916d02a441f80414455b80d85dc) +++ Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/HydraulicLocationEntity.cs (.../HydraulicLocationEntity.cs) (revision 37652d7a208ab210033b48025d8d768d409086a8) @@ -38,8 +38,6 @@ [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2214:DoNotCallOverridableMethodsInConstructors")] public HydraulicLocationEntity() { - this.GrassCoverErosionInwardsCalculationEntities = new HashSet(); - this.HeightStructuresCalculationEntities = new HashSet(); this.PipingCalculationEntities = new HashSet(); } @@ -53,10 +51,6 @@ public virtual AssessmentSectionEntity AssessmentSectionEntity { get; set; } [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")] - public virtual ICollection GrassCoverErosionInwardsCalculationEntities { get; set; } - [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")] - public virtual ICollection HeightStructuresCalculationEntities { get; set; } - [System.Diagnostics.CodeAnalysis.SuppressMessage("Microsoft.Usage", "CA2227:CollectionPropertiesShouldBeReadOnly")] public virtual ICollection PipingCalculationEntities { get; set; } } } Fisheye: Tag 37652d7a208ab210033b48025d8d768d409086a8 refers to a dead (removed) revision in file `Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/MacrostabilityInwardsFailureMechanismMetaEntity.cs'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag 37652d7a208ab210033b48025d8d768d409086a8 refers to a dead (removed) revision in file `Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/MacrostabilityOutwardsFailureMechanismMetaEntity.cs'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag 37652d7a208ab210033b48025d8d768d409086a8 refers to a dead (removed) revision in file `Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/MicrostabilityFailureMechanismMetaEntity.cs'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag 37652d7a208ab210033b48025d8d768d409086a8 refers to a dead (removed) revision in file `Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/PipingStructureFailureMechanismMetaEntity.cs'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag 37652d7a208ab210033b48025d8d768d409086a8 refers to a dead (removed) revision in file `Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/ProbabilisticOutputEntity.cs'. Fisheye: No comparison available. Pass `N' to diff? Index: Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/RingtoetsEntities.Context.cs =================================================================== diff -u -r8130cde70fa4a5ef16789bad2a8b64175d77d9a2 -r37652d7a208ab210033b48025d8d768d409086a8 --- Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/RingtoetsEntities.Context.cs (.../RingtoetsEntities.Context.cs) (revision 8130cde70fa4a5ef16789bad2a8b64175d77d9a2) +++ Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/RingtoetsEntities.Context.cs (.../RingtoetsEntities.Context.cs) (revision 37652d7a208ab210033b48025d8d768d409086a8) @@ -55,63 +55,43 @@ public virtual DbSet AssessmentSectionEntities { get; set; } public virtual DbSet CalculationGroupEntities { get; set; } public virtual DbSet CharacteristicPointEntities { get; set; } - public virtual DbSet ClosingStructureFailureMechanismMetaEntities { get; set; } public virtual DbSet ClosingStructureSectionResultEntities { get; set; } public virtual DbSet DikeProfileEntities { get; set; } - public virtual DbSet DuneErosionFailureMechanismMetaEntities { get; set; } public virtual DbSet DuneErosionSectionResultEntities { get; set; } public virtual DbSet FailureMechanismEntities { get; set; } public virtual DbSet FailureMechanismSectionEntities { get; set; } public virtual DbSet FailureMechanismSectionPointEntities { get; set; } - public virtual DbSet GrassCoverErosionInwardsCalculationEntities { get; set; } public virtual DbSet GrassCoverErosionInwardsFailureMechanismMetaEntities { get; set; } - public virtual DbSet GrassCoverErosionInwardsRoughnessProfileSectionEntities { get; set; } public virtual DbSet GrassCoverErosionInwardsSectionResultEntities { get; set; } - public virtual DbSet GrassCoverErosionOutwardsFailureMechanismMetaEntities { get; set; } public virtual DbSet GrassCoverErosionOutwardsSectionResultEntities { get; set; } - public virtual DbSet GrassCoverSlipOffInwardsFailureMechanismMetaEntities { get; set; } public virtual DbSet GrassCoverSlipOffInwardsSectionResultEntities { get; set; } - public virtual DbSet GrassCoverSlipOffOutwardsFailureMechanismMetaEntities { get; set; } public virtual DbSet GrassCoverSlipOffOutwardsSectionResultEntities { get; set; } - public virtual DbSet HeightStructuresCalculationEntities { get; set; } - public virtual DbSet HeightStructuresFailureMechanismMetaEntities { get; set; } public virtual DbSet HeightStructuresSectionResultEntities { get; set; } public virtual DbSet HydraulicLocationEntities { get; set; } - public virtual DbSet MacrostabilityInwardsFailureMechanismMetaEntities { get; set; } public virtual DbSet MacrostabilityInwardsSectionResultEntities { get; set; } - public virtual DbSet MacrostabilityOutwardsFailureMechanismMetaEntities { get; set; } public virtual DbSet MacrostabilityOutwardsSectionResultEntities { get; set; } - public virtual DbSet MicrostabilityFailureMechanismMetaEntities { get; set; } public virtual DbSet MicrostabilitySectionResultEntities { get; set; } public virtual DbSet PipingCalculationEntities { get; set; } public virtual DbSet PipingCalculationOutputEntities { get; set; } public virtual DbSet PipingFailureMechanismMetaEntities { get; set; } public virtual DbSet PipingSectionResultEntities { get; set; } public virtual DbSet PipingSemiProbabilisticOutputEntities { get; set; } - public virtual DbSet PipingStructureFailureMechanismMetaEntities { get; set; } public virtual DbSet PipingStructureSectionResultEntities { get; set; } - public virtual DbSet ProbabilisticOutputEntities { get; set; } public virtual DbSet ProjectEntities { get; set; } public virtual DbSet ReferenceLinePointEntities { get; set; } public virtual DbSet SoilLayerEntities { get; set; } public virtual DbSet SoilProfileEntities { get; set; } - public virtual DbSet StabilityStoneCoverFailureMechanismMetaEntities { get; set; } public virtual DbSet StabilityStoneCoverSectionResultEntities { get; set; } public virtual DbSet StochasticSoilModelEntities { get; set; } public virtual DbSet StochasticSoilModelSegmentPointEntities { get; set; } public virtual DbSet StochasticSoilProfileEntities { get; set; } - public virtual DbSet StrengthStabilityLengthwiseConstructionFailureMechanismMetaEntities { get; set; } public virtual DbSet StrengthStabilityLengthwiseConstructionSectionResultEntities { get; set; } - public virtual DbSet StrengthStabilityPointConstructionFailureMechanismMetaEntities { get; set; } public virtual DbSet StrengthStabilityPointConstructionSectionResultEntities { get; set; } public virtual DbSet SurfaceLineEntities { get; set; } public virtual DbSet SurfaceLinePointEntities { get; set; } - public virtual DbSet TechnicalInnovationFailureMechanismMetaEntities { get; set; } public virtual DbSet TechnicalInnovationSectionResultEntities { get; set; } public virtual DbSet VersionEntities { get; set; } - public virtual DbSet WaterPressureAsphaltCoverFailureMechanismMetaEntities { get; set; } public virtual DbSet WaterPressureAsphaltCoverSectionResultEntities { get; set; } - public virtual DbSet WaveImpactAsphaltCoverFailureMechanismMetaEntities { get; set; } public virtual DbSet WaveImpactAsphaltCoverSectionResultEntities { get; set; } } } Index: Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/RingtoetsEntities.edmx =================================================================== diff -u -r8130cde70fa4a5ef16789bad2a8b64175d77d9a2 -r37652d7a208ab210033b48025d8d768d409086a8 --- Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/RingtoetsEntities.edmx (.../RingtoetsEntities.edmx) (revision 8130cde70fa4a5ef16789bad2a8b64175d77d9a2) +++ Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/RingtoetsEntities.edmx (.../RingtoetsEntities.edmx) (revision 37652d7a208ab210033b48025d8d768d409086a8) @@ -37,13 +37,6 @@ - - - - - - - @@ -67,14 +60,9 @@ + + - - - - - - - @@ -113,26 +101,6 @@ - - - - - - - - - - - - - - - - - - - - @@ -141,18 +109,6 @@ - - - - - - - - - - - - @@ -162,13 +118,6 @@ - - - - - - - @@ -179,13 +128,6 @@ - - - - - - - @@ -196,13 +138,6 @@ - - - - - - - @@ -213,44 +148,6 @@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - @@ -272,13 +169,6 @@ - - - - - - - @@ -289,13 +179,6 @@ - - - - - - - @@ -306,13 +189,6 @@ - - - - - - - @@ -402,13 +278,6 @@ - - - - - - - @@ -419,17 +288,6 @@ - - - - - - - - - - - @@ -453,13 +311,16 @@ - + - - - + + + + + + @@ -469,13 +330,6 @@ - - - - - - - @@ -513,13 +367,6 @@ - - - - - - - @@ -529,13 +376,6 @@ - - - - - - - @@ -566,13 +406,6 @@ - - - - - - - @@ -591,13 +424,6 @@ - - - - - - - @@ -607,13 +433,6 @@ - - - - - - - @@ -660,18 +479,6 @@ - - - - - - - - - - - - @@ -696,18 +503,6 @@ - - - - - - - - - - - - @@ -768,42 +563,6 @@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - @@ -816,18 +575,6 @@ - - - - - - - - - - - - @@ -840,18 +587,6 @@ - - - - - - - - - - - - @@ -864,18 +599,6 @@ - - - - - - - - - - - - @@ -888,18 +611,6 @@ - - - - - - - - - - - - @@ -912,54 +623,6 @@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - @@ -984,18 +647,6 @@ - - - - - - - - - - - - @@ -1008,18 +659,6 @@ - - - - - - - - - - - - @@ -1032,18 +671,6 @@ - - - - - - - - - - - - @@ -1152,18 +779,6 @@ - - - - - - - - - - - - @@ -1200,18 +815,6 @@ - - - - - - - - - - - - @@ -1272,18 +875,6 @@ - - - - - - - - - - - - @@ -1296,18 +887,6 @@ - - - - - - - - - - - - @@ -1344,18 +923,6 @@ - - - - - - - - - - - - @@ -1368,18 +935,6 @@ - - - - - - - - - - - - @@ -1392,18 +947,6 @@ - - - - - - - - - - - - @@ -1420,63 +963,43 @@ - - - - - - - - - - - - - - - - - - - - @@ -1490,10 +1013,6 @@ - - - - @@ -1502,10 +1021,6 @@ - - - - @@ -1526,70 +1041,26 @@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - @@ -1598,26 +1069,14 @@ - - - - - - - - - - - - @@ -1654,10 +1113,6 @@ - - - - @@ -1670,10 +1125,6 @@ - - - - @@ -1694,18 +1145,10 @@ - - - - - - - - @@ -1718,26 +1161,14 @@ - - - - - - - - - - - - @@ -1751,63 +1182,43 @@ - - - - - - - - - - - - - - - - - - - - @@ -1833,14 +1244,6 @@ - - - - - - - - @@ -1849,10 +1252,6 @@ - - - - @@ -1861,10 +1260,6 @@ - - - - @@ -1877,74 +1272,18 @@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - @@ -2013,26 +1352,6 @@ - - - - - - - - - - - - - - - - - - - - @@ -2104,8 +1423,6 @@ - - @@ -2117,14 +1434,6 @@ - - - - - - - - @@ -2149,16 +1458,10 @@ + + - - - - - - - - @@ -2181,28 +1484,12 @@ - - - - - - - - - - - - - - - - @@ -2243,30 +1530,6 @@ - - - - - - - - - - - - - - - - - - - - - - - - @@ -2276,19 +1539,6 @@ - - - - - - - - - - - - - @@ -2299,14 +1549,6 @@ - - - - - - - - @@ -2318,14 +1560,6 @@ - - - - - - - - @@ -2337,14 +1571,6 @@ - - - - - - - - @@ -2356,48 +1582,6 @@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - @@ -2420,18 +1604,8 @@ - - - - - - - - - - @@ -2443,14 +1617,6 @@ - - - - - - - - @@ -2462,14 +1628,6 @@ - - - - - - - - @@ -2570,14 +1728,6 @@ - - - - - - - - @@ -2589,19 +1739,6 @@ - - - - - - - - - - - - - @@ -2627,13 +1764,16 @@ - + - - - + + + + + + @@ -2646,14 +1786,6 @@ - - - - - - - - @@ -2699,14 +1831,6 @@ - - - - - - - - @@ -2717,14 +1841,6 @@ - - - - - - - - @@ -2761,14 +1877,6 @@ - - - - - - - - @@ -2788,14 +1896,6 @@ - - - - - - - - @@ -2806,14 +1906,6 @@ - - - - - - - - @@ -2897,30 +1989,6 @@ - - - - - - - - - - - - - - - - - - - - - - - - @@ -2945,18 +2013,6 @@ - - - - - - - - - - - - @@ -2981,18 +2037,6 @@ - - - - - - - - - - - - @@ -3029,90 +2073,6 @@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - @@ -3125,30 +2085,6 @@ - - - - - - - - - - - - - - - - - - - - - - - - @@ -3161,30 +2097,6 @@ - - - - - - - - - - - - - - - - - - - - - - - - @@ -3197,42 +2109,6 @@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - @@ -3437,66 +2313,6 @@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - @@ -3658,14 +2474,6 @@ - - - - - - - - @@ -3680,6 +2488,8 @@ + + @@ -3692,14 +2502,6 @@ - - - - - - - - @@ -3742,27 +2544,6 @@ - - - - - - - - - - - - - - - - - - - - - @@ -3772,19 +2553,6 @@ - - - - - - - - - - - - - @@ -3795,14 +2563,6 @@ - - - - - - - - @@ -3814,14 +2574,6 @@ - - - - - - - - @@ -3833,14 +2585,6 @@ - - - - - - - - @@ -3852,46 +2596,6 @@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - @@ -3915,14 +2619,6 @@ - - - - - - - - @@ -3934,14 +2630,6 @@ - - - - - - - - @@ -3953,14 +2641,6 @@ - - - - - - - - @@ -4056,14 +2736,6 @@ - - - - - - - - @@ -4075,18 +2747,6 @@ - - - - - - - - - - - - @@ -4109,9 +2769,12 @@ - - - + + + + + + @@ -4130,14 +2793,6 @@ - - - - - - - - @@ -4179,14 +2834,6 @@ - - - - - - - - @@ -4197,14 +2844,6 @@ - - - - - - - - @@ -4238,14 +2877,6 @@ - - - - - - - - @@ -4266,14 +2897,6 @@ - - - - - - - - @@ -4284,14 +2907,6 @@ - - - - - - - - Index: Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/RingtoetsEntities.edmx.diagram =================================================================== diff -u -r8130cde70fa4a5ef16789bad2a8b64175d77d9a2 -r37652d7a208ab210033b48025d8d768d409086a8 --- Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/RingtoetsEntities.edmx.diagram (.../RingtoetsEntities.edmx.diagram) (revision 8130cde70fa4a5ef16789bad2a8b64175d77d9a2) +++ Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/RingtoetsEntities.edmx.diagram (.../RingtoetsEntities.edmx.diagram) (revision 37652d7a208ab210033b48025d8d768d409086a8) @@ -5,101 +5,63 @@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + - - - - + + - - - - - - - - - - - - - - - - - - @@ -117,11 +79,6 @@ - - - - - Index: Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/SoilLayerEntity.cs =================================================================== diff -u -r8ed108b83f575f6cb7dc1b89224606894a4bcb7a -r37652d7a208ab210033b48025d8d768d409086a8 --- Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/SoilLayerEntity.cs (.../SoilLayerEntity.cs) (revision 8ed108b83f575f6cb7dc1b89224606894a4bcb7a) +++ Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/SoilLayerEntity.cs (.../SoilLayerEntity.cs) (revision 37652d7a208ab210033b48025d8d768d409086a8) @@ -37,13 +37,16 @@ { public long SoilLayerEntityId { get; set; } public long SoilProfileEntityId { get; set; } - public decimal Top { get; set; } + public double Top { get; set; } public byte IsAquifer { get; set; } public long Color { get; set; } public string MaterialName { get; set; } - public Nullable AbovePhreaticLevel { get; set; } - public Nullable BelowPhreaticLevel { get; set; } - public Nullable DryUnitWeight { get; set; } + public Nullable BelowPhreaticLevelMean { get; set; } + public Nullable BelowPhreaticLevelDeviation { get; set; } + public Nullable DiameterD70Mean { get; set; } + public Nullable DiameterD70Deviation { get; set; } + public Nullable PermeabilityMean { get; set; } + public Nullable PermeabilityDeviation { get; set; } public virtual SoilProfileEntity SoilProfileEntity { get; set; } } Fisheye: Tag 37652d7a208ab210033b48025d8d768d409086a8 refers to a dead (removed) revision in file `Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/StabilityStoneCoverFailureMechanismMetaEntity.cs'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag 37652d7a208ab210033b48025d8d768d409086a8 refers to a dead (removed) revision in file `Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/StrengthStabilityLengthwiseConstructionFailureMechanismMetaEntity.cs'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag 37652d7a208ab210033b48025d8d768d409086a8 refers to a dead (removed) revision in file `Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/StrengthStabilityPointConstructionFailureMechanismMetaEntity.cs'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag 37652d7a208ab210033b48025d8d768d409086a8 refers to a dead (removed) revision in file `Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/TechnicalInnovationFailureMechanismMetaEntity.cs'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag 37652d7a208ab210033b48025d8d768d409086a8 refers to a dead (removed) revision in file `Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/WaterPressureAsphaltCoverFailureMechanismMetaEntity.cs'. Fisheye: No comparison available. Pass `N' to diff? Fisheye: Tag 37652d7a208ab210033b48025d8d768d409086a8 refers to a dead (removed) revision in file `Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/WaveImpactAsphaltCoverFailureMechanismMetaEntity.cs'. Fisheye: No comparison available. Pass `N' to diff?