Index: build/DatabaseStructure.sql =================================================================== diff -u -ra1dcf62580103884decb3156d5116a913ed15293 -rcbe0f46c3f469b6cd35d696c1973061dc97fa334 --- build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision a1dcf62580103884decb3156d5116a913ed15293) +++ build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision cbe0f46c3f469b6cd35d696c1973061dc97fa334) @@ -1,6 +1,6 @@ /* ---------------------------------------------------- */ /* Generated by Enterprise Architect Version 14.1 */ -/* Created On : 30-mrt-2022 10:40:57 */ +/* Created On : 31-mrt-2022 14:02:52 */ /* DBMS : SQLite */ /* ---------------------------------------------------- */ @@ -355,14 +355,14 @@ ( 'AssessmentSectionEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'ProjectEntityId' INTEGER NOT NULL, - 'HydraulicLocationCalculationCollectionEntity1Id' INTEGER NOT NULL, -- Represents the design water level signaling norm - 'HydraulicLocationCalculationCollectionEntity2Id' INTEGER NOT NULL, -- Represents the design water level lower limit norm + 'HydraulicLocationCalculationCollectionEntity1Id' INTEGER NOT NULL, -- Represents the water level signal flooding probability + 'HydraulicLocationCalculationCollectionEntity2Id' INTEGER NOT NULL, -- Represents the water level maximum allowable flooding probability 'Id' TEXT NULL, 'Name' VARCHAR (260) NULL, 'Comments' TEXT NULL, - 'LowerLimitNorm' REAL NOT NULL, - 'SignalingNorm' REAL NOT NULL, - 'NormativeNormType' TINYINT (1) NOT NULL, -- EnumType: 1 = LowerLimit, 2 = Signaling + 'MaximumAllowableFloodingProbability' REAL NOT NULL, + 'SignalFloodingProbability' REAL NOT NULL, + 'NormativeProbabilityType' TINYINT (1) NOT NULL, -- EnumType: 1 = MaximumAllowableFloodingProbability, 2 = SignalFloodingProbability 'Composition' TINYINT (1) NOT NULL, -- Enum: 1 = Dike, 2 = Dune, 3 = DikeAndDune 'ReferenceLinePointXml' TEXT NULL, CONSTRAINT 'FK_AssessmentSectionEntity_HydraulicLocationCalculationCollectionEntity1' FOREIGN KEY ('HydraulicLocationCalculationCollectionEntity1Id') REFERENCES 'HydraulicLocationCalculationCollectionEntity' ('HydraulicLocationCalculationCollectionEntityId') ON DELETE No Action ON UPDATE Cascade, @@ -1071,7 +1071,7 @@ 'LowerBoundaryWaterLevels' REAL NULL, 'StepSize' TINYINT (1) NOT NULL, -- Enum: 1 = 0.5, 2 = 1.0, 3 = 2.0 'CalculationType' TINYINT (1) NOT NULL, -- Enum: 1 = WaveRunUp 2 = WaveImpact 3 = WaveRunUpAndWaveImpact 4 = WaveImpactWithWaveDirection 5 = WaveRunUpAndWaveImpactWithWaveDirection 6 = All - 'WaterLevelType' TINYINT (1) NOT NULL, -- Enum: 1 = None, 2 = LowerLimit, 3 = Signaling, 4 = UserDefinedTargetProbability + 'WaterLevelType' TINYINT (1) NOT NULL, -- Enum: 1 = None, 2 = MaximumAllowableFloodingProbability, 3 = SignalFloodingProbability, 4 = UserDefinedTargetProbability CONSTRAINT 'FK_GrassCoverErosionOutwardsWaveConditionsCalculationEntity_CalculationGroupEntity' FOREIGN KEY ('CalculationGroupEntityId') REFERENCES 'CalculationGroupEntity' ('CalculationGroupEntityId') ON DELETE Cascade ON UPDATE Cascade, CONSTRAINT 'FK_GrassCoverErosionOutwardsWaveConditionsCalculationEntity_ForeshoreProfileEntity' FOREIGN KEY ('ForeshoreProfileEntityId') REFERENCES 'ForeshoreProfileEntity' ('ForeshoreProfileEntityId') ON DELETE Set Null ON UPDATE Cascade, CONSTRAINT 'FK_GrassCoverErosionOutwardsWaveConditionsCalculationEntity_HydraulicLocationCalculationForTargetProbabilityCollectionEntity' FOREIGN KEY ('HydraulicLocationCalculationForTargetProbabilityCollectionEntityId') REFERENCES 'HydraulicLocationCalculationForTargetProbabilityCollectionEntity' ('HydraulicLocationCalculationForTargetProbabilityCollectionEntityId') ON DELETE Set Null ON UPDATE Cascade, @@ -2010,7 +2010,7 @@ 'LowerBoundaryWaterLevels' REAL NULL, 'StepSize' TINYINT (1) NOT NULL, -- Enum: 1 = 0.5, 2 = 1.0, 3 = 2.0 'CalculationType' TINYINT (1) NOT NULL, -- Enum: 1 = Blocks, 2 = Columns, 3 = Both - 'WaterLevelType' TINYINT (1) NOT NULL, -- Enum: 1 = None, 2 = LowerLimit, 3 = Signaling, 4 = UserDefinedTargetProbability + 'WaterLevelType' TINYINT (1) NOT NULL, -- Enum: 1 = None, 2 = MaximumAllowableFloodingProbability, 3 = SignalFloodingProbability, 4 = UserDefinedTargetProbability CONSTRAINT 'FK_StabilityStoneCoverWaveConditionsCalculationEntity_CalculationGroupEntity' FOREIGN KEY ('CalculationGroupEntityId') REFERENCES 'CalculationGroupEntity' ('CalculationGroupEntityId') ON DELETE Cascade ON UPDATE Cascade, CONSTRAINT 'FK_StabilityStoneCoverWaveConditionsCalculationEntity_ForeshoreProfileEntity' FOREIGN KEY ('ForeshoreProfileEntityId') REFERENCES 'ForeshoreProfileEntity' ('ForeshoreProfileEntityId') ON DELETE Set Null ON UPDATE Cascade, CONSTRAINT 'FK_StabilityStoneCoverWaveConditionsCalculationEntity_HydraulicLocationCalculationForTargetProbabilityCollectionEntity' FOREIGN KEY ('HydraulicLocationCalculationForTargetProbabilityCollectionEntityId') REFERENCES 'HydraulicLocationCalculationForTargetProbabilityCollectionEntity' ('HydraulicLocationCalculationForTargetProbabilityCollectionEntityId') ON DELETE Set Null ON UPDATE Cascade, @@ -2149,7 +2149,7 @@ 'UpperBoundaryWaterLevels' REAL NULL, 'LowerBoundaryWaterLevels' REAL NULL, 'StepSize' TINYINT (1) NOT NULL, -- Enum: 1 = 0.5, 2 = 1.0, 3 = 2.0 - 'WaterLevelType' TINYINT (1) NOT NULL, -- Enum: 1 = None, 2 = LowerLimit, 3 = Signaling, 4 = UserDefinedTargetProbability + 'WaterLevelType' TINYINT (1) NOT NULL, -- Enum: 1 = None, 2 = MaximumAllowableFloodingProbability, 3 = SignalFloodingProbability, 4 = UserDefinedTargetProbability CONSTRAINT 'FK_WaveImpactAsphaltCoverWaveConditionsCalculationEntity_CalculationGroupEntity' FOREIGN KEY ('CalculationGroupEntityId') REFERENCES 'CalculationGroupEntity' ('CalculationGroupEntityId') ON DELETE Cascade ON UPDATE Cascade, CONSTRAINT 'FK_WaveImpactAsphaltCoverWaveConditionsCalculationEntity_ForeshoreProfileEntity' FOREIGN KEY ('ForeshoreProfileEntityId') REFERENCES 'ForeshoreProfileEntity' ('ForeshoreProfileEntityId') ON DELETE Set Null ON UPDATE Cascade, CONSTRAINT 'FK_WaveImpactAsphaltCoverWaveConditionsCalculationEntity_HydraulicLocationCalculationForTargetProbabilityCollectionEntity' FOREIGN KEY ('HydraulicLocationCalculationForTargetProbabilityCollectionEntityId') REFERENCES 'HydraulicLocationCalculationForTargetProbabilityCollectionEntity' ('HydraulicLocationCalculationForTargetProbabilityCollectionEntityId') ON DELETE Set Null ON UPDATE Cascade,