Index: build/DatabaseStructure.sql =================================================================== diff -u -r18c6c780b4873d934cb8e5177b32b3c69cd4d07e -r4cd5871728c5940e0f08b0bcbf08954e46f45fae --- build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 18c6c780b4873d934cb8e5177b32b3c69cd4d07e) +++ build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 4cd5871728c5940e0f08b0bcbf08954e46f45fae) @@ -1,6 +1,6 @@ /* ---------------------------------------------------- */ /* Generated by Enterprise Architect Version 15.2 */ -/* Created On : 28-jan-2022 09:04:33 */ +/* Created On : 07-feb-2022 08:34:50 */ /* DBMS : SQLite */ /* ---------------------------------------------------- */ @@ -768,7 +768,7 @@ 'IsRelevant' TINYINT (1) NOT NULL, -- true or false 'InitialFailureMechanismResultType' TINYINT (1) NOT NULL, -- Enum: Adopt = 1 Manual = 2 NoFailureProbability = 3 'ManualInitialFailureMechanismResultSectionProbability' REAL NULL, - 'FurtherAnalysisNeeded' TINYINT (1) NOT NULL, -- true or false + 'FurtherAnalysisType' TINYINT (1) NOT NULL, -- Enum: NotNecessary = 1 Necessary = 2 Executed = 3 'RefinedSectionProbability' REAL NULL, CONSTRAINT 'FK_ClosingStructuresSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade ) @@ -811,7 +811,7 @@ 'IsRelevant' TINYINT (1) NOT NULL, -- true or false 'InitialFailureMechanismResultType' TINYINT (1) NOT NULL, -- Enum: Manual = 1 NoFailureProbability = 2 'ManualInitialFailureMechanismResultSectionProbability' REAL NULL, - 'FurtherAnalysisNeeded' TINYINT (1) NOT NULL, -- true or false + 'FurtherAnalysisType' TINYINT (1) NOT NULL, -- Enum: NotNecessary = 1 Necessary = 2 Executed = 3 'RefinedSectionProbability' REAL NULL, CONSTRAINT 'FK_DuneErosionSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade ) @@ -1024,7 +1024,7 @@ 'InitialFailureMechanismResultType' 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 + 'FurtherAnalysisType' TINYINT (1) NOT NULL, -- Enum: NotNecessary = 1 Necessary = 2 Executed = 3 'ProbabilityRefinementType' TINYINT (1) NOT NULL, -- Enum: Profile = 1 Section = 2 Both = 3 'RefinedProfileProbability' REAL NULL, 'RefinedSectionProbability' REAL NULL, @@ -1040,7 +1040,7 @@ 'InitialFailureMechanismResultType' TINYINT (1) NOT NULL, -- Enum: Manual = 1 NoFailureProbability = 2 'ManualInitialFailureMechanismResultSectionProbability' REAL NULL, 'ManualInitialFailureMechanismResultProfileProbability' REAL NULL, - 'FurtherAnalysisNeeded' TINYINT (1) NOT NULL, -- true or false + 'FurtherAnalysisType' TINYINT (1) NOT NULL, -- Enum: NotNecessary = 1 Necessary = 2 Executed = 3 'RefinedSectionProbability' REAL NULL, 'RefinedProfileProbability' REAL NULL, CONSTRAINT 'FK_GrassCoverErosionOutwardsSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade @@ -1104,7 +1104,7 @@ 'InitialFailureMechanismResultType' TINYINT (1) NOT NULL, -- Enum: Manual = 1 NoFailureProbability = 2 'ManualInitialFailureMechanismResultSectionProbability' REAL NULL, 'ManualInitialFailureMechanismResultProfileProbability' REAL NULL, - 'FurtherAnalysisNeeded' TINYINT (1) NOT NULL, -- true or false + 'FurtherAnalysisType' TINYINT (1) NOT NULL, -- Enum: NotNecessary = 1 Necessary = 2 Executed = 3 'RefinedSectionProbability' REAL NULL, 'RefinedProfileProbability' REAL NULL, CONSTRAINT 'FK_GrassCoverSlipOffInwardsSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade @@ -1129,7 +1129,7 @@ 'InitialFailureMechanismResultType' TINYINT (1) NOT NULL, -- Enum: Manual = 1 NoFailureProbability = 2 'ManualInitialFailureMechanismResultSectionProbability' REAL NULL, 'ManualInitialFailureMechanismResultProfileProbability' REAL NULL, - 'FurtherAnalysisNeeded' TINYINT (1) NOT NULL, -- true or false + 'FurtherAnalysisType' TINYINT (1) NOT NULL, -- Enum: NotNecessary = 1 Necessary = 2 Executed = 3 'RefinedSectionProbability' REAL NULL, 'RefinedProfileProbability' REAL NULL, CONSTRAINT 'FK_GrassCoverSlipOffOutwardsSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade @@ -1235,7 +1235,7 @@ 'IsRelevant' TINYINT (1) NOT NULL, -- true or false 'InitialFailureMechanismResultType' TINYINT (1) NOT NULL, -- Enum: Adopt = 1 Manual = 2 NoFailureProbability = 3 'ManualInitialFailureMechanismResultSectionProbability' REAL NULL, - 'FurtherAnalysisNeeded' TINYINT (1) NOT NULL, -- true or false + 'FurtherAnalysisType' TINYINT (1) NOT NULL, -- Enum: NotNecessary = 1 Necessary = 2 Executed = 3 'RefinedSectionProbability' REAL NULL, CONSTRAINT 'FK_HeightStructuresSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade ) @@ -1496,7 +1496,7 @@ '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 + 'FurtherAnalysisType' TINYINT (1) NOT NULL, -- Enum: NotNecessary = 1 Necessary = 2 Executed = 3 'ProbabilityRefinementType' TINYINT (1) NOT NULL, -- Enum: Profile = 1 Section = 2 Both = 3 'RefinedSectionProbability' REAL NULL, 'RefinedProfileProbability' REAL NULL, @@ -1623,7 +1623,7 @@ 'InitialFailureMechanismResultType' TINYINT (1) NOT NULL, -- Enum: Manual = 1 NoFailureProbability = 2 'ManualInitialFailureMechanismResultSectionProbability' REAL NULL, 'ManualInitialFailureMechanismResultProfileProbability' REAL NULL, - 'FurtherAnalysisNeeded' TINYINT (1) NOT NULL, -- true or false + 'FurtherAnalysisType' TINYINT (1) NOT NULL, -- Enum: NotNecessary = 1 Necessary = 2 Executed = 3 'RefinedSectionProbability' REAL NULL, 'RefinedProfileProbability' REAL NULL, CONSTRAINT 'FK_MicrostabilitySectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade @@ -1651,7 +1651,7 @@ '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 + 'FurtherAnalysisType' TINYINT (1) NOT NULL, -- Enum: NotNecessary = 1 Necessary = 2 Executed = 3 'ProbabilityRefinementType' TINYINT (1) NOT NULL, -- Enum: Profile = 1, Section = 2, Both = 3 'RefinedSectionProbability' REAL NULL, 'RefinedProfileProbability' REAL NULL, @@ -1675,7 +1675,7 @@ 'IsRelevant' TINYINT (1) NOT NULL, -- true or false 'InitialFailureMechanismResultType' TINYINT (1) NOT NULL, -- Enum: Manual = 1, NoFailureProbability = 2 'ManualInitialFailureMechanismResultSectionProbability' REAL NULL, - 'FurtherAnalysisNeeded' TINYINT (1) NOT NULL, -- true or false + 'FurtherAnalysisType' TINYINT (1) NOT NULL, -- Enum: NotNecessary = 1 Necessary = 2 Executed = 3 'RefinedSectionProbability' REAL NULL, CONSTRAINT 'FK_PipingStructureSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade ) @@ -1938,7 +1938,7 @@ 'IsRelevant' TINYINT (1) NOT NULL, -- true or false 'InitialFailureMechanismResultType' TINYINT (1) NOT NULL, -- Enum: Adopt = 1 Manual = 2 NoFailureProbability = 3 'ManualInitialFailureMechanismResultSectionProbability' REAL NULL, - 'FurtherAnalysisNeeded' TINYINT (1) NOT NULL, -- true or false + 'FurtherAnalysisType' TINYINT (1) NOT NULL, -- Enum: NotNecessary = 1 Necessary = 2 Executed = 3 'RefinedSectionProbability' REAL NULL, CONSTRAINT 'FK_StabilityPointStructuresSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade ) @@ -1963,7 +1963,7 @@ 'InitialFailureMechanismResultType' TINYINT (1) NOT NULL, -- Enum: Manual = 1 NoFailureProbability = 2 'ManualInitialFailureMechanismResultSectionProbability' REAL NULL, 'ManualInitialFailureMechanismResultProfileProbability' REAL NULL, - 'FurtherAnalysisNeeded' TINYINT (1) NOT NULL, -- true or false + 'FurtherAnalysisType' TINYINT (1) NOT NULL, -- Enum: NotNecessary = 1 Necessary = 2 Executed = 3 'RefinedSectionProbability' REAL NULL, 'RefinedProfileProbability' REAL NULL, CONSTRAINT 'FK_StabilityStoneCoverSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade @@ -2088,7 +2088,7 @@ 'InitialFailureMechanismResultType' TINYINT (1) NOT NULL, -- Enum: Manual = 1 NoFailureProbability = 2 'ManualInitialFailureMechanismResultSectionProbability' REAL NULL, 'ManualInitialFailureMechanismResultProfileProbability' REAL NULL, - 'FurtherAnalysisNeeded' TINYINT (1) NOT NULL, -- true or false + 'FurtherAnalysisType' TINYINT (1) NOT NULL, -- Enum: NotNecessary = 1 Necessary = 2 Executed = 3 'RefinedSectionProbability' REAL NULL, 'RefinedProfileProbability' REAL NULL, CONSTRAINT 'FK_WaterPressureAsphaltCoverSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade @@ -2103,7 +2103,7 @@ 'InitialFailureMechanismResultType' TINYINT (1) NOT NULL, -- Enum: Manual = 1 NoFailureProbability = 2 'ManualInitialFailureMechanismResultSectionProbability' REAL NULL, 'ManualInitialFailureMechanismResultProfileProbability' REAL NULL, - 'FurtherAnalysisNeeded' TINYINT (1) NOT NULL, -- true or false + 'FurtherAnalysisType' TINYINT (1) NOT NULL, -- Enum: NotNecessary = 1 Necessary = 2 Executed = 3 'RefinedSectionProbability' REAL NULL, 'RefinedProfileProbability' REAL NULL, CONSTRAINT 'FK_WaveImpactAsphaltCoverSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade