Index: build/DatabaseStructure.sql =================================================================== diff -u -r94ec35ab65218a3c84d83b195ddecc03de3f4810 -ra1dcf62580103884decb3156d5116a913ed15293 --- build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 94ec35ab65218a3c84d83b195ddecc03de3f4810) +++ build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision a1dcf62580103884decb3156d5116a913ed15293) @@ -1,6 +1,6 @@ /* ---------------------------------------------------- */ -/* Generated by Enterprise Architect Version 15.2 */ -/* Created On : 03-mrt-2022 10:32:48 */ +/* Generated by Enterprise Architect Version 14.1 */ +/* Created On : 30-mrt-2022 10:40:57 */ /* DBMS : SQLite */ /* ---------------------------------------------------- */ @@ -273,10 +273,10 @@ DROP TABLE IF EXISTS 'SemiProbabilisticPipingCalculationOutputEntity' ; -DROP TABLE IF EXISTS 'SpecificFailurePathEntity' +DROP TABLE IF EXISTS 'SpecificFailureMechanismEntity' ; -DROP TABLE IF EXISTS 'SpecificFailurePathFailureMechanismSectionEntity' +DROP TABLE IF EXISTS 'SpecificFailureMechanismFailureMechanismSectionEntity' ; DROP TABLE IF EXISTS 'StabilityPointStructureEntity' @@ -393,8 +393,8 @@ 'InAssemblyOutputComments' TEXT NULL, 'NotInAssemblyComments' TEXT NULL, 'CalculationsInputComments' TEXT NULL, - 'FailurePathAssemblyProbabilityResultType' TINYINT (1) NOT NULL, -- Enum: Automatic = 1, Manual = 2 - 'ManualFailurePathAssemblyProbability' REAL NULL, + 'FailureMechanismAssemblyResultProbabilityResultType' TINYINT (1) NOT NULL, -- Enum: Automatic = 1, Manual = 2 + 'FailureMechanismAssemblyResultManualFailureMechanismAssemblyProbability' REAL NULL, CONSTRAINT 'FK_FailureMechanismEntity_AssessmentSectionEntity' FOREIGN KEY ('AssessmentSectionEntityId') REFERENCES 'AssessmentSectionEntity' ('AssessmentSectionEntityId') ON DELETE Cascade ON UPDATE Cascade, CONSTRAINT 'FK_FailureMechanismEntity_CalculationGroupEntity' FOREIGN KEY ('CalculationGroupEntityId') REFERENCES 'CalculationGroupEntity' ('CalculationGroupEntityId') ON DELETE Cascade ON UPDATE Cascade, CONSTRAINT 'UI_AssessmentSectionEntityId_FailureMechanismType' UNIQUE ('AssessmentSectionEntityId','FailureMechanismType') @@ -1764,9 +1764,9 @@ ) ; -CREATE TABLE 'SpecificFailurePathEntity' +CREATE TABLE 'SpecificFailureMechanismEntity' ( - 'SpecificFailurePathEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'SpecificFailureMechanismEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'AssessmentSectionEntityId' INTEGER NOT NULL, 'Name' VARCHAR (260) NULL, 'Code' VARCHAR (260) NULL, @@ -1777,20 +1777,20 @@ 'InAssemblyOutputComments' TEXT NULL, 'NotInAssemblyComments' TEXT NULL, 'N' REAL NOT NULL, - 'FailurePathAssemblyProbabilityResultType' TINYINT (1) NOT NULL, -- Enum: Automatic = 1, Manual = 2 - 'ManualFailurePathAssemblyProbability' REAL NULL, + 'FailureMechanismAssemblyResultProbabilityResultType' TINYINT (1) NOT NULL, -- Enum: Automatic = 1, Manual = 2 + 'FailureMechanismAssemblyResultManualFailureMechanismAssemblyProbability' REAL NULL, 'ApplyLengthEffectInSection' TINYINT (1) NOT NULL, - CONSTRAINT 'FK_SpecificFailurePathEntity_AssessmentSectionEntity' FOREIGN KEY ('AssessmentSectionEntityId') REFERENCES 'AssessmentSectionEntity' ('AssessmentSectionEntityId') ON DELETE Cascade ON UPDATE Cascade + CONSTRAINT 'FK_SpecificFailureMechanismEntity_AssessmentSectionEntity' FOREIGN KEY ('AssessmentSectionEntityId') REFERENCES 'AssessmentSectionEntity' ('AssessmentSectionEntityId') ON DELETE Cascade ON UPDATE Cascade ) ; -CREATE TABLE 'SpecificFailurePathFailureMechanismSectionEntity' +CREATE TABLE 'SpecificFailureMechanismFailureMechanismSectionEntity' ( - 'SpecificFailurePathEntityId' INTEGER NOT NULL, + 'SpecificFailureMechanismEntityId' INTEGER NOT NULL, 'FailureMechanismSectionEntityId' INTEGER NOT NULL, - CONSTRAINT 'PK_SpecificFailurePathFailureMechanismSectionEntity' PRIMARY KEY ('SpecificFailurePathEntityId','FailureMechanismSectionEntityId'), - CONSTRAINT 'FK_SpecificFailurePathFailureMechanismSectionEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT 'FK_SpecificFailurePathFailureMechanismSectionEntity_SpecificFailurePathEntity' FOREIGN KEY ('SpecificFailurePathEntityId') REFERENCES 'SpecificFailurePathEntity' ('SpecificFailurePathEntityId') ON DELETE Cascade ON UPDATE Cascade + CONSTRAINT 'PK_SpecificFailureMechanismFailureMechanismSectionEntity' PRIMARY KEY ('SpecificFailureMechanismEntityId','FailureMechanismSectionEntityId'), + CONSTRAINT 'FK_SpecificFailureMechanismFailureMechanismSectionEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT 'FK_SpecificFailureMechanismFailureMechanismSectionEntity_SpecificFailureMechanismEntity' FOREIGN KEY ('SpecificFailureMechanismEntityId') REFERENCES 'SpecificFailureMechanismEntity' ('SpecificFailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade ) ; @@ -2839,20 +2839,20 @@ ON 'SemiProbabilisticPipingCalculationOutputEntity' ('SemiProbabilisticPipingCalculationEntityId' ASC) ; -CREATE INDEX 'IXFK_SpecificFailurePathEntity_AssessmentSectionEntity' - ON 'SpecificFailurePathEntity' ('AssessmentSectionEntityId' ASC) +CREATE INDEX 'IXFK_SpecificFailureMechanismEntity_AssessmentSectionEntity' + ON 'SpecificFailureMechanismEntity' ('AssessmentSectionEntityId' ASC) ; -CREATE INDEX 'IXFK_SpecificFailurePathFailureMechanismSectionEntity_FailureMechanismSectionEntity' - ON 'SpecificFailurePathFailureMechanismSectionEntity' ('FailureMechanismSectionEntityId' ASC) +CREATE INDEX 'IXFK_SpecificFailureMechanismFailureMechanismSectionEntity_FailureMechanismSectionEntity' + ON 'SpecificFailureMechanismFailureMechanismSectionEntity' ('FailureMechanismSectionEntityId' ASC) ; -CREATE INDEX 'IXFK_SpecificFailurePathFailureMechanismSectionEntity_SpecificFailurePathEntity' - ON 'SpecificFailurePathFailureMechanismSectionEntity' ('SpecificFailurePathEntityId' ASC) +CREATE INDEX 'IXFK_SpecificFailureMechanismFailureMechanismSectionEntity_SpecificFailureMechanismEntity' + ON 'SpecificFailureMechanismFailureMechanismSectionEntity' ('SpecificFailureMechanismEntityId' ASC) ; -CREATE TRIGGER [TR_AfterDeleteSpecificFailurePathFailureMechanismSectionEntity_RemoveFailureMechanismSectionEntityId] +CREATE TRIGGER [TR_AfterDeleteSpecificFailureMechanismFailureMechanismSectionEntity_RemoveFailureMechanismSectionEntityId] AFTER DELETE - ON SpecificFailurePathFailureMechanismSectionEntity + ON SpecificFailureMechanismFailureMechanismSectionEntity FOR EACH ROW BEGIN DELETE