Index: build/DatabaseStructure.sql =================================================================== diff -u -r414c120db349ede430237adbde098ee258a5c3dd -rfd7ce422aead24dfcd13a041f9b0364754802306 --- build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 414c120db349ede430237adbde098ee258a5c3dd) +++ build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision fd7ce422aead24dfcd13a041f9b0364754802306) @@ -1,6 +1,6 @@ /* ---------------------------------------------------- */ /* Generated by Enterprise Architect Version 14.1 */ -/* Created On : 01-dec-2021 09:09:30 */ +/* Created On : 06-dec-2021 15:02:06 */ /* DBMS : SQLite */ /* ---------------------------------------------------- */ @@ -1624,12 +1624,14 @@ ( 'PipingSectionResultEntityId' 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 NoFailureProbablity = 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_PipingSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade ) ;