Index: Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql =================================================================== diff -u -r1e9309149f9387c4e8b10f6c5f429797220b0ef8 -ra294987551b0b2d8a27b6e1bc6235b0e2351b6f4 --- Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 1e9309149f9387c4e8b10f6c5f429797220b0ef8) +++ Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision a294987551b0b2d8a27b6e1bc6235b0e2351b6f4) @@ -1,6 +1,6 @@ /* ---------------------------------------------------- */ /* Generated by Enterprise Architect Version 12.0 */ -/* Created On : 22-jul-2016 14:15:50 */ +/* Created On : 26-jul-2016 11:17:27 */ /* DBMS : SQLite */ /* ---------------------------------------------------- */ @@ -153,7 +153,7 @@ ( 'PipingFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismEntityId' INTEGER, - 'A' NUMERIC NOT NULL, + 'A' REAL NOT NULL, CONSTRAINT 'FK_PipingFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade ) ; @@ -207,8 +207,8 @@ ( 'FailureMechanismSectionPointEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismSectionEntityId' INTEGER NOT NULL, - 'X' NUMERIC NOT NULL, - 'Y' NUMERIC NOT NULL, + 'X' REAL, + 'Y' REAL, 'Order' INT (4) NOT NULL, CONSTRAINT 'FK_FailureMechanismSectionPointEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade ) @@ -231,8 +231,8 @@ 'AssessmentSectionEntityId' INTEGER NOT NULL, 'LocationId' INTEGER NOT NULL, 'Name' VARCHAR (260) NOT NULL, - 'LocationX' NUMERIC NOT NULL, - 'LocationY' NUMERIC NOT NULL, + 'LocationX' REAL, + 'LocationY' REAL, 'DesignWaterLevel' REAL, CONSTRAINT 'FK_HydraulicLocationEntity_AssessmentSectionEntity' FOREIGN KEY ('AssessmentSectionEntityId') REFERENCES 'AssessmentSectionEntity' ('AssessmentSectionEntityId') ON DELETE Cascade ON UPDATE Cascade ) @@ -250,21 +250,21 @@ 'Order' INT (4) NOT NULL, 'Name' VARCHAR (260), 'Comments' TEXT, - 'EntryPointL' NUMERIC, - 'ExitPointL' NUMERIC, - 'PhreaticLevelExitMean' NUMERIC NOT NULL, - 'PhreaticLevelExitStandardDeviation' NUMERIC NOT NULL, - 'Diameter70Mean' NUMERIC NOT NULL, - 'Diameter70StandardDeviation' NUMERIC NOT NULL, - 'DarcyPermeabilityMean' NUMERIC NOT NULL, - 'DarcyPermeabilityStandardDeviation' NUMERIC NOT NULL, - 'DampingFactorExitMean' NUMERIC NOT NULL, - 'DampingFactorExitStandardDeviation' NUMERIC NOT NULL, - 'SaturatedVolumicWeightOfCoverageLayerMean' NUMERIC NOT NULL, - 'SaturatedVolumicWeightOfCoverageLayerStandardDeviation' NUMERIC NOT NULL, - 'SaturatedVolumicWeightOfCoverageLayerShift' NUMERIC NOT NULL, + 'EntryPointL' REAL, + 'ExitPointL' REAL, + 'PhreaticLevelExitMean' REAL, + 'PhreaticLevelExitStandardDeviation' REAL, + 'Diameter70Mean' REAL, + 'Diameter70StandardDeviation' REAL, + 'DarcyPermeabilityMean' REAL, + 'DarcyPermeabilityStandardDeviation' REAL, + 'DampingFactorExitMean' REAL, + 'DampingFactorExitStandardDeviation' REAL, + 'SaturatedVolumicWeightOfCoverageLayerMean' REAL, + 'SaturatedVolumicWeightOfCoverageLayerStandardDeviation' REAL, + 'SaturatedVolumicWeightOfCoverageLayerShift' REAL, 'RelevantForScenario' TINYINT (1) NOT NULL, - 'ScenarioContribution' NUMERIC NOT NULL, + 'ScenarioContribution' REAL, CONSTRAINT 'FK_PipingCalculationEntity_CalculationGroupEntity' FOREIGN KEY ('CalculationGroupEntityId') REFERENCES 'CalculationGroupEntity' ('CalculationGroupEntityId') ON DELETE No Action ON UPDATE No Action, CONSTRAINT 'FK_PipingCalculationEntity_HydraulicLocationEntity' FOREIGN KEY ('HydraulicLocationEntityId') REFERENCES 'HydraulicLocationEntity' ('HydraulicLocationEntityId') ON DELETE No Action ON UPDATE No Action, CONSTRAINT 'FK_PipingCalculationEntity_PipingCalculationOutputEntity' FOREIGN KEY ('PipingCalculationOutputEntityId') REFERENCES 'PipingCalculationOutputEntity' ('PipingCalculationOutputEntityId') ON DELETE Cascade ON UPDATE Cascade, @@ -313,8 +313,8 @@ ( 'ReferenceLinePointEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'AssessmentSectionEntityId' INTEGER NOT NULL, - 'X' NUMERIC NOT NULL, - 'Y' NUMERIC NOT NULL, + 'X' REAL, + 'Y' REAL, 'Order' INT (4) NOT NULL, CONSTRAINT 'FK_ReferenceLinePointEntity_AssessmentSectionEntity' FOREIGN KEY ('AssessmentSectionEntityId') REFERENCES 'AssessmentSectionEntity' ('AssessmentSectionEntityId') ON DELETE Cascade ON UPDATE Cascade ) @@ -324,7 +324,7 @@ ( 'SoilLayerEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'SoilProfileEntityId' INTEGER NOT NULL, - 'Top' REAL NOT NULL, + 'Top' REAL, 'IsAquifer' TINYINT (1) NOT NULL, -- true or false 'Color' INTEGER NOT NULL, -- ARGB value of Color. 'MaterialName' TEXT NOT NULL, @@ -342,7 +342,7 @@ CREATE TABLE 'SoilProfileEntity' ( 'SoilProfileEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'Bottom' NUMERIC NOT NULL, + 'Bottom' REAL, 'Name' TEXT ) ; @@ -352,7 +352,7 @@ 'StochasticSoilProfileEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'SoilProfileEntityId' INTEGER NOT NULL, 'StochasticSoilModelEntityId' INTEGER NOT NULL, - 'Probability' NUMERIC NOT NULL, + 'Probability' REAL, CONSTRAINT 'FK_StochasticSoilProfileEntity_SoilProfileEntity' FOREIGN KEY ('SoilProfileEntityId') REFERENCES 'SoilProfileEntity' ('SoilProfileEntityId') ON DELETE Cascade ON UPDATE Cascade, CONSTRAINT 'FK_StochasticSoilProfileEntity_StochasticSoilModelEntity' FOREIGN KEY ('StochasticSoilModelEntityId') REFERENCES 'StochasticSoilModelEntity' ('StochasticSoilModelEntityId') ON DELETE Cascade ON UPDATE Cascade ) @@ -373,8 +373,8 @@ 'SurfaceLineEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismEntityId' INTEGER NOT NULL, 'Name' VARCHAR (260), - 'ReferenceLineIntersectionX' NUMERIC NOT NULL, - 'ReferenceLineIntersectionY' NUMERIC NOT NULL, + 'ReferenceLineIntersectionX' REAL, + 'ReferenceLineIntersectionY' REAL, CONSTRAINT 'FK_SurfaceLineEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE No Action ON UPDATE No Action ) ; @@ -383,32 +383,32 @@ ( 'SurfaceLinePointEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'SurfaceLineEntityId' INTEGER NOT NULL, - 'X' NUMERIC NOT NULL, - 'Y' NUMERIC NOT NULL, + 'X' REAL, + 'Y' REAL, 'Order' INT (4) NOT NULL, - 'Z' NUMERIC NOT NULL, + 'Z' REAL, CONSTRAINT 'FK_SurfaceLinePointEntity_SurfaceLineEntity' FOREIGN KEY ('SurfaceLineEntityId') REFERENCES 'SurfaceLineEntity' ('SurfaceLineEntityId') ON DELETE No Action ON UPDATE No Action ) ; CREATE TABLE 'PipingCalculationOutputEntity' ( 'PipingCalculationOutputEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'HeaveFactorOfSafety' NUMERIC, - 'HeaveZValue' NUMERIC, - 'UpliftFactorOfSafety' NUMERIC, - 'UpliftZValue' NUMERIC, - 'SellmeijerFactorOfSafety' NUMERIC, - 'SellmeijerZValue' NUMERIC + 'HeaveFactorOfSafety' REAL, + 'HeaveZValue' REAL, + 'UpliftFactorOfSafety' REAL, + 'UpliftZValue' REAL, + 'SellmeijerFactorOfSafety' REAL, + 'SellmeijerZValue' REAL ) ; CREATE TABLE 'StochasticSoilModelSegmentPointEntity' ( 'StochasticSoilModelSegmentPointEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'StochasticSoilModelEntityId' INTEGER NOT NULL, - 'X' NUMERIC NOT NULL, - 'Y' NUMERIC NOT NULL, + 'X' REAL, + 'Y' REAL, 'Order' INT (4) NOT NULL, CONSTRAINT 'FK_StochasticSoilModelSegmentPointEntity_StochasticSoilModelEntity' FOREIGN KEY ('StochasticSoilModelEntityId') REFERENCES 'StochasticSoilModelEntity' ('StochasticSoilModelEntityId') ON DELETE No Action ON UPDATE No Action ) @@ -437,20 +437,20 @@ CREATE TABLE 'PipingSemiProbabilisticOutputEntity' ( 'PipingSemiProbabilisticOutputEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'UpliftFactorOfSafety' NUMERIC, - 'UpliftReliability' NUMERIC, - 'UpliftProbability' NUMERIC, - 'HeaveFactorOfSafety' NUMERIC, - 'HeaveReliability' NUMERIC, - 'HeaveProbability' NUMERIC, - 'SellmeijerFactorOfSafety' NUMERIC, - 'SellmeijerReliability' NUMERIC, - 'SellmeijerProbability' NUMERIC, - 'RequiredProbability' NUMERIC, - 'RequiredReliability' NUMERIC, - 'PipingProbability' NUMERIC, - 'PipingReliability' NUMERIC, - 'PipingFactorOfSafety' NUMERIC + 'UpliftFactorOfSafety' REAL, + 'UpliftReliability' REAL, + 'UpliftProbability' REAL, + 'HeaveFactorOfSafety' REAL, + 'HeaveReliability' REAL, + 'HeaveProbability' REAL, + 'SellmeijerFactorOfSafety' REAL, + 'SellmeijerReliability' REAL, + 'SellmeijerProbability' REAL, + 'RequiredProbability' REAL, + 'RequiredReliability' REAL, + 'PipingProbability' REAL, + 'PipingReliability' REAL, + 'PipingFactorOfSafety' REAL ) ; @@ -459,7 +459,7 @@ 'PipingSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismSectionEntityId' INTEGER NOT NULL, 'LayerOne' TINYINT (1) NOT NULL, -- true or false - 'LayerThree' NUMERIC, + 'LayerThree' REAL, CONSTRAINT 'FK_PipingSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade ) ; @@ -470,7 +470,7 @@ 'FailureMechanismSectionEntityId' INTEGER NOT NULL, 'GrassCoverErosionInwardsCalculationEntityId' INTEGER, 'LayerOne' TINYINT (1) NOT NULL, -- true or false - 'LayerThree' NUMERIC, + 'LayerThree' REAL, CONSTRAINT 'FK_GrassCoverErosionInwardsSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade, CONSTRAINT 'FK_GrassCoverErosionInwardsSectionResultEntity_GrassCoverErosionInwardsCalculationEntity' FOREIGN KEY ('GrassCoverErosionInwardsCalculationEntityId') REFERENCES 'GrassCoverErosionInwardsCalculationEntity' ('GrassCoverErosionInwardsCalculationEntityId') ON DELETE Set Null ON UPDATE Cascade ) @@ -481,7 +481,7 @@ 'HeightStructuresSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismSectionEntityId' INTEGER NOT NULL, 'LayerOne' TINYINT (1) NOT NULL, -- true or false - 'LayerThree' NUMERIC, + 'LayerThree' REAL, CONSTRAINT 'FK_HeightStructuresSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade ) ; @@ -491,7 +491,7 @@ 'StrengthStabilityLengthwiseConstructionSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismSectionEntityId' INTEGER NOT NULL, 'LayerOne' TINYINT (1) NOT NULL, -- true or false - 'LayerThree' NUMERIC, + 'LayerThree' REAL, CONSTRAINT 'FK_StrengthStabilityLengthwiseConstructionSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade ) ; @@ -501,7 +501,7 @@ 'TechnicalInnovationSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismSectionEntityId' INTEGER NOT NULL, 'LayerOne' TINYINT (1) NOT NULL, -- true or false - 'LayerThree' NUMERIC, + 'LayerThree' REAL, CONSTRAINT 'FK_TechnicalInnovationSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade ) ; @@ -511,7 +511,7 @@ 'WaterPressureAsphaltCoverSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismSectionEntityId' INTEGER NOT NULL, 'LayerOne' TINYINT (1) NOT NULL, -- true or false - 'LayerThree' NUMERIC, + 'LayerThree' REAL, CONSTRAINT 'FK_WaterPressureAsphaltCoverSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade ) ; @@ -521,8 +521,8 @@ 'ClosingStructureSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismSectionEntityId' INTEGER NOT NULL, 'LayerOne' TINYINT (1) NOT NULL, -- true or false - 'LayerTwoA' NUMERIC, - 'LayerThree' NUMERIC, + 'LayerTwoA' REAL, + 'LayerThree' REAL, CONSTRAINT 'FK_ClosingStructureSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade ) ; @@ -533,7 +533,7 @@ '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, + 'LayerThree' REAL, CONSTRAINT 'FK_GrassCoverErosionOutwardsSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade ) ; @@ -544,7 +544,7 @@ '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, + 'LayerThree' REAL, CONSTRAINT 'FK_GrassCoverSlipOffInwardsSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade ) ; @@ -555,7 +555,7 @@ '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, + 'LayerThree' REAL, CONSTRAINT 'FK_GrassCoverSlipOffOutwardsSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade ) ; @@ -565,8 +565,8 @@ 'MacrostabilityInwardsSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismSectionEntityId' INTEGER NOT NULL, 'LayerOne' TINYINT (1) NOT NULL, -- true or false - 'LayerTwoA' NUMERIC, - 'LayerThree' NUMERIC, + 'LayerTwoA' REAL, + 'LayerThree' REAL, CONSTRAINT 'FK_MacrostabilityInwardsSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade ) ; @@ -576,8 +576,8 @@ 'MacrostabilityOutwardsSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismSectionEntityId' INTEGER NOT NULL, 'LayerOne' TINYINT (1) NOT NULL, -- true or false - 'LayerTwoA' NUMERIC, - 'LayerThree' NUMERIC, + 'LayerTwoA' REAL, + 'LayerThree' REAL, CONSTRAINT 'FK_MacrostabilityOutwardsSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade ) ; @@ -587,8 +587,8 @@ 'WaveImpactAsphaltCoverSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismSectionEntityId' INTEGER NOT NULL, 'LayerOne' TINYINT (1) NOT NULL, -- true or false - 'LayerTwoA' NUMERIC, - 'LayerThree' NUMERIC, + 'LayerTwoA' REAL, + 'LayerThree' REAL, CONSTRAINT 'FK_WaveImpactAsphaltCoverSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade ) ; @@ -599,7 +599,7 @@ '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, + 'LayerThree' REAL, CONSTRAINT 'FK_MicrostabilitySectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade ) ; @@ -610,7 +610,7 @@ '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, + 'LayerThree' REAL, CONSTRAINT 'FK_PipingStructureSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade ) ; @@ -620,7 +620,7 @@ 'DuneErosionSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismSectionEntityId' INTEGER NOT NULL, 'LayerTwoA' TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated 2 = Failed 3 = Succesful - 'LayerThree' NUMERIC, + 'LayerThree' REAL, CONSTRAINT 'FK_DuneErosionSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade ) ; @@ -630,7 +630,7 @@ '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, + 'LayerThree' REAL, CONSTRAINT 'FK_StabilityStoneCoverSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade ) ; @@ -639,8 +639,8 @@ ( 'StrengthStabilityPointConstructionSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismSectionEntityId' INTEGER NOT NULL, - 'LayerTwoA' NUMERIC, - 'LayerThree' NUMERIC, + 'LayerTwoA' REAL, + 'LayerThree' REAL, CONSTRAINT 'FK_StrengthStabilityPointConstructionSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade ) ; @@ -650,15 +650,15 @@ 'DikeProfileEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismEntityId' INTEGER NOT NULL, 'Name' VARCHAR (260) NOT NULL, - 'Orientation' REAL NOT NULL, + 'Orientation' REAL, 'BreakWaterType' TINYINT (1), -- Enum: 1 = Wall 2 = Caisson 3 = Dam 'BreakWaterHeight' REAL, 'ForeShoreData' BLOB NOT NULL, 'DikeGeometryData' BLOB NOT NULL, - 'DikeHeight' REAL NOT NULL, - 'X' REAL NOT NULL, - 'Y' REAL NOT NULL, - 'X0' REAL NOT NULL, + 'DikeHeight' REAL, + 'X' REAL, + 'Y' REAL, + 'X0' REAL, CONSTRAINT 'FK_DikeProfileEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade ) ;