Index: build/DatabaseStructure.sql =================================================================== diff -u -rff2de18b562746dc26d3bb8be226d934bd2498dd -r0d7ddbb2bb0435d0f4ca2eb1883e0189874bbc67 --- build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision ff2de18b562746dc26d3bb8be226d934bd2498dd) +++ build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 0d7ddbb2bb0435d0f4ca2eb1883e0189874bbc67) @@ -1,6 +1,6 @@ /* ---------------------------------------------------- */ /* Generated by Enterprise Architect Version 15.2 */ -/* Created On : 26-jan-2022 15:59:02 */ +/* Created On : 27-jan-2022 10:04:08 */ /* DBMS : SQLite */ /* ---------------------------------------------------- */ @@ -1118,11 +1118,13 @@ ( 'GrassCoverSlipOffInwardsSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismSectionEntityId' INTEGER NOT NULL, - 'SimpleAssessmentResult' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed, 2 = Sufficient, 3 = NoVerdict - 'DetailedAssessmentResult' TINYINT (1) NOT NULL, -- Enum: 1 = None, 2 = Sufficient, 3 = Insufficient, 4 = NotAssessed - 'TailorMadeAssessmentResult' TINYINT (1) NOT NULL, -- Enum: 1 = None, 2 = ProbabilityNegligible, 3 = Sufficient, 4 = Insufficient, 5 = NotAssessed - 'UseManualAssembly' TINYINT (1) NOT NULL, -- true or false - 'ManualAssemblyCategoryGroup' TINYINT (1) NOT NULL, -- Enum: 1 = None, 2 = NotApplicable, 3 = Iv, 4 = IIv, 5 = Vv, 6 = VIIv + 'IsRelevant' TINYINT (1) NOT NULL, -- true or false + 'InitialFailureMechanismResultType' TINYINT (1) NOT NULL, -- Enum: Manual = 1 NoFailureProbability = 2 + 'ManualInitialFailureMechanismResultSectionProbability' REAL NULL, + 'ManualInitialFailureMechanismResultProfileProbability' REAL NULL, + 'FurtherAnalysisNeeded' TINYINT (1) NOT NULL, -- true or false + 'RefinedSectionProbability' REAL NULL, + 'RefinedProfileProbability' REAL NULL, CONSTRAINT 'FK_GrassCoverSlipOffInwardsSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade ) ;