Index: build/DatabaseStructure.sql =================================================================== diff -u -r8ab6d93230040b6691059970f774b302c9d73503 -rf052ef206d5b3f183a9a2a98c27ea5653fac038b --- build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 8ab6d93230040b6691059970f774b302c9d73503) +++ build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision f052ef206d5b3f183a9a2a98c27ea5653fac038b) @@ -1,6 +1,6 @@ /* ---------------------------------------------------- */ -/* Generated by Enterprise Architect Version 15.2 */ -/* Created On : 12-jan-2022 14:52:07 */ +/* Generated by Enterprise Architect Version 14.1 */ +/* Created On : 14-jan-2022 11:44:50 */ /* DBMS : SQLite */ /* ---------------------------------------------------- */ @@ -784,7 +784,7 @@ 'ClosingStructuresSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismSectionEntityId' INTEGER NOT NULL, 'IsRelevant' TINYINT (1) NOT NULL, -- true or false - 'InitialFailureMechanismResultType' TINYINT (1) NOT NULL, -- Enum: Adopt = 1 Manual = 2 NoFailureProbability = 3 + 'InitialAdoptableFailureMechanismResultType' TINYINT (1) NOT NULL, -- Enum: Adopt = 1 Manual = 2 NoFailureProbability = 3 'ManualInitialFailureMechanismResultSectionProbability' REAL NULL, 'FurtherAnalysisNeeded' TINYINT (1) NOT NULL, -- true or false 'RefinedSectionProbability' REAL NULL, @@ -1042,12 +1042,14 @@ ( 'GrassCoverErosionInwardsSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismSectionEntityId' INTEGER NOT NULL, - 'SimpleAssessmentResult' TINYINT (1) NOT NULL, -- Enum: 1 = None, 2 = NotApplicable, 3 = Applicable - '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, + 'IsRelevant' TINYINT (1) NOT NULL, -- true or false + 'InitialAdoptableFailureMechanismResultType' TINYINT (1) NOT NULL, -- Enum: Adopt = 1 Manual = 2 NoFailureProbability = 3 + 'ManualInitialFailureMechanismResultProfileProbability' REAL NULL, + 'ManualInitialFailureMechanismResultSectionProbability' REAL NULL, + 'FurtherAnalysisNeeded' TINYINT (1) NOT NULL, -- true or false + 'ProbabilityRefinementType' TINYINT (1) NOT NULL, -- Enum: Profile = 1 Section = 2 Both = 3 + 'RefinedProfileProbability' REAL NULL, + 'RefinedSectionProbability' REAL NULL, CONSTRAINT 'FK_GrassCoverErosionInwardsSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade ) ; @@ -1251,7 +1253,7 @@ 'HeightStructuresSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismSectionEntityId' INTEGER NOT NULL, 'IsRelevant' TINYINT (1) NOT NULL, -- true or false - 'InitialFailureMechanismResultType' TINYINT (1) NOT NULL, -- Enum: Adopt = 1 Manual = 2 NoFailureProbability = 3 + 'InitialAdoptableFailureMechanismResultType' TINYINT (1) NOT NULL, -- Enum: Adopt = 1 Manual = 2 NoFailureProbability = 3 'ManualInitialFailureMechanismResultSectionProbability' REAL NULL, 'FurtherAnalysisNeeded' TINYINT (1) NOT NULL, -- true or false 'RefinedSectionProbability' REAL NULL, @@ -1511,7 +1513,7 @@ 'MacroStabilityInwardsSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismSectionEntityId' INTEGER NOT NULL, 'IsRelevant' TINYINT (1) NOT NULL, -- true or false - 'InitialFailureMechanismResultType' TINYINT (1) NOT NULL, -- Enum: Adopt = 1 Manual = 2 NoFailureProbability = 3 + 'InitialAdoptableFailureMechanismResultType' TINYINT (1) NOT NULL, -- Enum: Adopt = 1 Manual = 2 NoFailureProbability = 3 'ManualInitialFailureMechanismResultSectionProbability' REAL NULL, 'ManualInitialFailureMechanismResultProfileProbability' REAL NULL, 'FurtherAnalysisNeeded' TINYINT (1) NOT NULL, -- true or false @@ -1689,7 +1691,7 @@ 'PipingSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismSectionEntityId' INTEGER NOT NULL, 'IsRelevant' TINYINT (1) NOT NULL, -- true or false - 'InitialFailureMechanismResultType' TINYINT (1) NOT NULL, -- Enum: Adopt = 1 Manual = 2 NoFailureProbablity = 3 + 'InitialAdoptableFailureMechanismResultType' TINYINT (1) NOT NULL, -- Enum: Adopt = 1 Manual = 2 NoFailureProbablity = 3 'ManualInitialFailureMechanismResultSectionProbability' REAL NULL, 'ManualInitialFailureMechanismResultProfileProbability' REAL NULL, 'FurtherAnalysisNeeded' TINYINT (1) NOT NULL, -- true or false