Index: build/DatabaseStructure.sql =================================================================== diff -u -rab476765c312648a1f578d1b0ddfc854b3e8bbaf -ra993bb6e30e9953e2a1b7166155b4a8cb8986c66 --- build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision ab476765c312648a1f578d1b0ddfc854b3e8bbaf) +++ build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision a993bb6e30e9953e2a1b7166155b4a8cb8986c66) @@ -1,6 +1,6 @@ /* ---------------------------------------------------- */ /* Generated by Enterprise Architect Version 14.1 */ -/* Created On : 16-dec-2021 13:06:29 */ +/* Created On : 05-jan-2022 12:58:50 */ /* DBMS : SQLite */ /* ---------------------------------------------------- */ @@ -1512,12 +1512,14 @@ ( 'MacroStabilityInwardsSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismSectionEntityId' INTEGER NOT 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, + 'IsRelevant' TINYINT (1) NOT NULL, -- true or false + 'InitialFailureMechanismResultType' 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 + 'ProbabilityRefinementType' TINYINT (1) NOT NULL, -- Enum: Profile = 1 Section = 2 Both = 3 + 'RefinedSectionProbability' REAL NULL, + 'RefinedProfileProbability' REAL NULL, CONSTRAINT 'FK_MacroStabilityInwardsSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade ) ;