Index: build/DatabaseStructure.sql =================================================================== diff -u -r6ff3b2dc5571db2ffd5421d79aa8d51fb3d61d96 -rab476765c312648a1f578d1b0ddfc854b3e8bbaf --- build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 6ff3b2dc5571db2ffd5421d79aa8d51fb3d61d96) +++ build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision ab476765c312648a1f578d1b0ddfc854b3e8bbaf) @@ -1,6 +1,6 @@ /* ---------------------------------------------------- */ /* Generated by Enterprise Architect Version 14.1 */ -/* Created On : 15-dec-2021 10:19:33 */ +/* Created On : 16-dec-2021 13:06:29 */ /* DBMS : SQLite */ /* ---------------------------------------------------- */ @@ -483,6 +483,7 @@ 'FailureMechanismEntityId' INTEGER NOT NULL, 'N' REAL NOT NULL, 'DikeProfileCollectionSourcePath' TEXT NULL, + 'ApplyLengthEffectInSection' TINYINT (1) NOT NULL, CONSTRAINT 'FK_GrassCoverErosionInwardsFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade ) ; @@ -524,6 +525,7 @@ 'GrassCoverSlipOffInwardsFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismEntityId' INTEGER NOT NULL, 'N' REAL NOT NULL, + 'ApplyLengthEffectInSection' TINYINT (1) NOT NULL, CONSTRAINT 'FK_GrassCoverSlipOffInwardsFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade ) ; @@ -534,6 +536,7 @@ 'FailureMechanismEntityId' INTEGER NOT NULL, 'N' REAL NOT NULL, 'ForeshoreProfileCollectionSourcePath' TEXT NULL, + 'ApplyLengthEffectInSection' TINYINT (1) NOT NULL, CONSTRAINT 'FK_GrassCoverErosionOutwardsFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade ) ; @@ -631,6 +634,7 @@ 'WaterPressureAsphaltCoverFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismEntityId' INTEGER NOT NULL, 'N' REAL NOT NULL, + 'ApplyLengthEffectInSection' TINYINT (1) NOT NULL, CONSTRAINT 'FK_WaterPressureAsphaltCoverFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade ) ; @@ -641,6 +645,7 @@ 'FailureMechanismEntityId' INTEGER NOT NULL, 'ForeshoreProfileCollectionSourcePath' TEXT NULL, 'DeltaL' REAL NOT NULL, + 'ApplyLengthEffectInSection' TINYINT (1) NOT NULL, CONSTRAINT 'FK_WaveImpactAsphaltCoverFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade ) ; @@ -1132,6 +1137,7 @@ 'GrassCoverSlipOffOutwardsFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismEntityId' INTEGER NOT NULL, 'N' REAL NOT NULL, + 'ApplyLengthEffectInSection' TINYINT (1) NOT NULL, CONSTRAINT 'FK_GrassCoverSlipOffOutwardsFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade ) ; @@ -1622,6 +1628,7 @@ 'MacroStabilityOutwardsFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismEntityId' INTEGER NOT NULL, 'A' REAL NOT NULL, + 'ApplyLengthEffectInSection' TINYINT (1) NOT NULL, CONSTRAINT 'FK_MacroStabilityOutwardsFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade ) ; @@ -1646,6 +1653,7 @@ 'MicrostabilityFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismEntityId' INTEGER NOT NULL, 'N' REAL NOT NULL, + 'ApplyLengthEffectInSection' TINYINT (1) NOT NULL, CONSTRAINT 'FK_MicrostabilityFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade ) ; @@ -1793,6 +1801,7 @@ 'N' REAL NOT NULL, 'FailurePathAssemblyProbabilityResultType' TINYINT (1) NOT NULL, -- Enum: Automatic = 1, Manual = 2 'ManualFailurePathAssemblyProbability' REAL NULL, + 'ApplyLengthEffectInSection' TINYINT (1) NOT NULL, CONSTRAINT 'FK_SpecificFailurePathEntity_AssessmentSectionEntity' FOREIGN KEY ('AssessmentSectionEntityId') REFERENCES 'AssessmentSectionEntity' ('AssessmentSectionEntityId') ON DELETE Cascade ON UPDATE Cascade ) ; @@ -1983,6 +1992,7 @@ 'FailureMechanismEntityId' INTEGER NOT NULL, 'ForeshoreProfileCollectionSourcePath' TEXT NULL, 'N' REAL NOT NULL, + 'ApplyLengthEffectInSection' TINYINT (1) NOT NULL, CONSTRAINT 'FK_StabilityStoneCoverFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade ) ; @@ -2112,6 +2122,7 @@ 'TechnicalInnovationFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismEntityId' INTEGER NOT NULL, 'N' REAL NOT NULL, + 'ApplyLengthEffectInSection' TINYINT (1) NOT NULL, CONSTRAINT 'FK_TechnicalInnovationFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade ) ;