Index: build/DatabaseStructure.sql =================================================================== diff -u -r8637a8fdd0d72fdc9be39b6a9a77fee5dbeff9fa -rce544879a32ded8effb7cde058d221b1eeeb638e --- build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 8637a8fdd0d72fdc9be39b6a9a77fee5dbeff9fa) +++ build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision ce544879a32ded8effb7cde058d221b1eeeb638e) @@ -1,6 +1,6 @@ /* ---------------------------------------------------- */ /* Generated by Enterprise Architect Version 14.1 */ -/* Created On : 22-jan-2021 11:40:21 */ +/* Created On : 28-jan-2021 07:41:26 */ /* DBMS : SQLite */ /* ---------------------------------------------------- */ @@ -456,7 +456,7 @@ 'DampingFactorExitMean' REAL NULL, 'DampingFactorExitStandardDeviation' REAL NULL, 'RelevantForScenario' TINYINT (1) NOT NULL, -- true or false - 'ScenarioContribution' REAL NULL, + 'ScenarioContribution' REAL NOT NULL, 'AssessmentLevel' REAL NULL, 'UseAssessmentLevelManualInput' TINYINT (1) NOT NULL, -- true or false CONSTRAINT 'FK_SemiProbabilisticPipingCalculationEntity_CalculationGroupEntity' FOREIGN KEY ('CalculationGroupEntityId') REFERENCES 'CalculationGroupEntity' ('CalculationGroupEntityId') ON DELETE Cascade ON UPDATE Cascade, @@ -489,7 +489,7 @@ 'ShouldOvertoppingRateIllustrationPointsBeCalculated' TINYINT (1) NOT NULL, -- true or false 'ShouldOvertoppingOutputIllustrationPointsBeCalculated' TINYINT (1) NOT NULL, -- true or false 'RelevantForScenario' TINYINT (1) NOT NULL, -- true or false - 'ScenarioContribution' REAL NULL, + 'ScenarioContribution' REAL NOT NULL, CONSTRAINT 'FK_GrassCoverErosionInwardsCalculationEntity_CalculationGroupEntity' FOREIGN KEY ('CalculationGroupEntityId') REFERENCES 'CalculationGroupEntity' ('CalculationGroupEntityId') ON DELETE Cascade ON UPDATE Cascade, CONSTRAINT 'FK_GrassCoverErosionInwardsCalculationEntity_DikeProfileEntity' FOREIGN KEY ('DikeProfileEntityId') REFERENCES 'DikeProfileEntity' ('DikeProfileEntityId') ON DELETE Set Null ON UPDATE Cascade, CONSTRAINT 'FK_GrassCoverErosionInwardsCalculationEntity_HydraulicLocationEntity' FOREIGN KEY ('HydraulicLocationEntityId') REFERENCES 'HydraulicLocationEntity' ('HydraulicLocationEntityId') ON DELETE Set Null ON UPDATE Cascade @@ -722,7 +722,7 @@ 'FactorStormDurationOpenStructure' REAL NULL, 'ShouldIllustrationPointsBeCalculated' TINYINT (1) NOT NULL, -- true or false 'RelevantForScenario' TINYINT (1) NOT NULL, - 'ScenarioContribution' REAL NULL, + 'ScenarioContribution' REAL NOT NULL, CONSTRAINT 'FK_ClosingStructuresCalculationEntity_CalculationGroupEntity' FOREIGN KEY ('CalculationGroupEntityId') REFERENCES 'CalculationGroupEntity' ('CalculationGroupEntityId') ON DELETE Cascade ON UPDATE Cascade, CONSTRAINT 'FK_ClosingStructuresCalculationEntity_ClosingStructureEntity' FOREIGN KEY ('ClosingStructureEntityId') REFERENCES 'ClosingStructureEntity' ('ClosingStructureEntityId') ON DELETE Set Null ON UPDATE Cascade, CONSTRAINT 'FK_ClosingStructuresCalculationEntity_ForeshoreProfileEntity' FOREIGN KEY ('ForeshoreProfileEntityId') REFERENCES 'ForeshoreProfileEntity' ('ForeshoreProfileEntityId') ON DELETE Set Null ON UPDATE Cascade, @@ -1163,7 +1163,7 @@ 'BreakWaterHeight' REAL NULL, 'ShouldIllustrationPointsBeCalculated' TINYINT (1) NOT NULL, -- true or false 'RelevantForScenario' TINYINT (1) NOT NULL, - 'ScenarioContribution' REAL NULL, + 'ScenarioContribution' REAL NOT NULL, CONSTRAINT 'FK_HeightStructuresCalculationEntity_CalculationGroupEntity' FOREIGN KEY ('CalculationGroupEntityId') REFERENCES 'CalculationGroupEntity' ('CalculationGroupEntityId') ON DELETE Cascade ON UPDATE Cascade, CONSTRAINT 'FK_HeightStructuresCalculationEntity_ForeshoreProfileEntity' FOREIGN KEY ('ForeshoreProfileEntityId') REFERENCES 'ForeshoreProfileEntity' ('ForeshoreProfileEntityId') ON DELETE Set Null ON UPDATE Cascade, CONSTRAINT 'FK_HeightStructuresCalculationEntity_HeightStructureEntity' FOREIGN KEY ('HeightStructureEntityId') REFERENCES 'HeightStructureEntity' ('HeightStructureEntityId') ON DELETE Set Null ON UPDATE Cascade, @@ -1285,7 +1285,7 @@ 'Name' VARCHAR (260) NULL, 'Comment' TEXT NULL, 'RelevantForScenario' TINYINT (1) NOT NULL, -- true or false - 'ScenarioContribution' REAL NULL, + 'ScenarioContribution' REAL NOT NULL, 'AssessmentLevel' REAL NULL, 'UseAssessmentLevelManualInput' TINYINT (1) NOT NULL, -- true or false 'SlipPlaneMinimumDepth' REAL NULL, @@ -1816,7 +1816,7 @@ 'FailureProbabilityStructureWithErosion' REAL NOT NULL, 'ShouldIllustrationPointsBeCalculated' TINYINT (1) NOT NULL, -- true or false 'RelevantForScenario' TINYINT (1) NOT NULL, - 'ScenarioContribution' REAL NULL, + 'ScenarioContribution' REAL NOT NULL, CONSTRAINT 'FK_StabilityPointStructuresCalculationEntity_CalculationGroupEntity' FOREIGN KEY ('CalculationGroupEntityId') REFERENCES 'CalculationGroupEntity' ('CalculationGroupEntityId') ON DELETE Cascade ON UPDATE Cascade, CONSTRAINT 'FK_StabilityPointStructuresCalculationEntity_ForeshoreProfileEntity' FOREIGN KEY ('ForeshoreProfileEntityId') REFERENCES 'ForeshoreProfileEntity' ('ForeshoreProfileEntityId') ON DELETE Set Null ON UPDATE Cascade, CONSTRAINT 'FK_StabilityPointStructuresCalculationEntity_HydraulicLocationEntity' FOREIGN KEY ('HydraulicLocationEntityId') REFERENCES 'HydraulicLocationEntity' ('HydraulicLocationEntityId') ON DELETE Set Null ON UPDATE Cascade, Index: design/DatabaseDesign.eap =================================================================== diff -u -r30cde0b2e7da2733918e76f289da2f9ba63fea56 -rce544879a32ded8effb7cde058d221b1eeeb638e Binary files differ