Index: build/DatabaseStructure.sql =================================================================== diff -u -r71aaa7a4e1ff2efe276a2e8195641566530d6ffe -r08cb71c4aed1c349c20bb4f7ab38fdbf92bf8998 --- build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 71aaa7a4e1ff2efe276a2e8195641566530d6ffe) +++ build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 08cb71c4aed1c349c20bb4f7ab38fdbf92bf8998) @@ -1,6 +1,6 @@ /* ---------------------------------------------------- */ /* Generated by Enterprise Architect Version 12.0 */ -/* Created On : 04-Apr-2018 16:29:39 */ +/* Created On : 05-Apr-2018 16:03:04 */ /* DBMS : SQLite */ /* ---------------------------------------------------- */ @@ -790,8 +790,12 @@ ( 'PipingSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismSectionEntityId' INTEGER NOT NULL, - 'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed, 2 = Sufficient, 3 = NoVerdict - 'LayerThree' REAL, + '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 = ProbablityNegligible, 3 = Probability, 4 = NotAssessed + 'TailorMadeAssessmentProbability' REAL, + 'UseManualAssemblyProbability' TINYINT (1) NOT NULL, -- true or false + 'ManualAssemblyProbability' REAL, CONSTRAINT 'FK_PipingSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade ) ; @@ -911,8 +915,12 @@ ( 'MacroStabilityInwardsSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismSectionEntityId' INTEGER NOT NULL, - 'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed, 2 = Sufficient, 3 = NoVerdict - 'LayerThree' REAL, + '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, + 'UseManualAssemblyProbability' TINYINT (1) NOT NULL, -- true or false + 'ManualAssemblyProbability' REAL, CONSTRAINT 'FK_MacroStabilityInwardsSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade ) ;