Index: build/DatabaseStructure.sql =================================================================== diff -u -r02e296ce079d79f5df8fe647edfa02c56884be90 -r059f4aa6af451069da64495b17f9277959cc00a8 --- build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 02e296ce079d79f5df8fe647edfa02c56884be90) +++ build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 059f4aa6af451069da64495b17f9277959cc00a8) @@ -1,6 +1,6 @@ /* ---------------------------------------------------- */ /* Generated by Enterprise Architect Version 14.1 */ -/* Created On : 06-jul-2020 08:26:23 */ +/* Created On : 09-jul-2020 08:39:14 */ /* DBMS : SQLite */ /* ---------------------------------------------------- */ @@ -1155,6 +1155,8 @@ 'BreakWaterType' TINYINT (1) NOT NULL, -- Enum: 1 = Wall, 2 = Caisson, 3 = Dam 'BreakWaterHeight' REAL NULL, 'ShouldIllustrationPointsBeCalculated' TINYINT (1) NOT NULL, -- true or false + 'RelevantForScenario' TINYINT (1) NOT NULL, + 'ScenarioContribution' REAL 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, @@ -1189,15 +1191,13 @@ ( 'HeightStructuresSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismSectionEntityId' INTEGER NOT NULL, - 'HeightStructuresCalculationEntityId' INTEGER NULL, 'SimpleAssessmentResult' TINYINT (1) NOT NULL, -- Enum: 1 = None, 2 = NotApplicable, 3 = ProbabilityNegligible 4 = AssessFurther 'DetailedAssessmentResult' TINYINT (1) NOT NULL, -- Enum: 1 = Probability 2 = NotAssessed 'TailorMadeAssessmentResult' TINYINT (1) NOT NULL, -- Enum: 1 = None 2 = ProbabilityNegligible 3 = Probability 4 = NotAssessed 'TailorMadeAssessmentProbability' REAL NULL, 'UseManualAssembly' TINYINT (1) NOT NULL, -- true or false 'ManualAssemblyProbability' REAL NULL, - CONSTRAINT 'FK_HeightStructuresSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT 'FK_HeightStructuresSectionResultEntity_HeightStructuresCalculationEntity' FOREIGN KEY ('HeightStructuresCalculationEntityId') REFERENCES 'HeightStructuresCalculationEntity' ('HeightStructuresCalculationEntityId') ON DELETE Set Null ON UPDATE Cascade + CONSTRAINT 'FK_HeightStructuresSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade ) ; @@ -2545,10 +2545,6 @@ ON 'HeightStructuresSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) ; -CREATE INDEX 'IXFK_HeightStructuresSectionResultEntity_HeightStructuresCalculationEntity' - ON 'HeightStructuresSectionResultEntity' ('HeightStructuresCalculationEntityId' ASC) -; - CREATE INDEX 'IXFK_HydraulicBoundaryDatabaseEntity_AssessmentSectionEntity' ON 'HydraulicBoundaryDatabaseEntity' ('AssessmentSectionEntityId' ASC) ; Index: design/DatabaseDesign.eap =================================================================== diff -u -r02e296ce079d79f5df8fe647edfa02c56884be90 -r059f4aa6af451069da64495b17f9277959cc00a8 Binary files differ