Index: build/DatabaseStructure.sql =================================================================== diff -u -r965bee866811ec47b665e1c3bdcd4fa017f2d7dc -rf71c2df965b0227efc953a0c3eca4692fcf3ba84 --- build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 965bee866811ec47b665e1c3bdcd4fa017f2d7dc) +++ build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision f71c2df965b0227efc953a0c3eca4692fcf3ba84) @@ -1,6 +1,6 @@ /* ---------------------------------------------------- */ /* Generated by Enterprise Architect Version 16.1 */ -/* Created On : 13-mei-2024 11:28:56 */ +/* Created On : 13-jun-2024 11:23:36 */ /* DBMS : SQLite */ /* ---------------------------------------------------- */ @@ -51,10 +51,10 @@ DROP TABLE IF EXISTS PipingStochasticSoilProfileEntity ; -DROP TABLE IF EXISTS PipingScenarioConfigurationPerFailureMechanismSectionEntity +DROP TABLE IF EXISTS StochasticSoilModelEntity ; -DROP TABLE IF EXISTS StochasticSoilModelEntity +DROP TABLE IF EXISTS PipingFailureMechanismSectionConfigurationEntity ; DROP TABLE IF EXISTS SurfaceLineEntity @@ -195,6 +195,9 @@ DROP TABLE IF EXISTS MacroStabilityInwardsFailureMechanismMetaEntity ; +DROP TABLE IF EXISTS MacroStabilityInwardsFailureMechanismSectionConfigurationEntity +; + DROP TABLE IF EXISTS MacroStabilityInwardsPreconsolidationStressEntity ; @@ -499,15 +502,6 @@ ) ; -CREATE TABLE PipingScenarioConfigurationPerFailureMechanismSectionEntity -( - PipingScenarioConfigurationPerFailureMechanismSectionEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - FailureMechanismSectionEntityId INTEGER NOT NULL, - PipingScenarioConfigurationPerFailureMechanismSectionType TINYINT (1) NOT NULL, -- Enum: SemiProbabilistic = 1 Probabilistic = 2 - CONSTRAINT FK_PipingScenarioConfigurationPerFailureMechanismSectionEntity_FailureMechanismSectionEntity FOREIGN KEY (FailureMechanismSectionEntityId) REFERENCES FailureMechanismSectionEntity (FailureMechanismSectionEntityId) ON DELETE Cascade ON UPDATE Cascade -) -; - CREATE TABLE StochasticSoilModelEntity ( StochasticSoilModelEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -520,6 +514,16 @@ ) ; +CREATE TABLE PipingFailureMechanismSectionConfigurationEntity +( + PipingFailureMechanismSectionConfigurationEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + FailureMechanismSectionEntityId INTEGER NOT NULL, + PipingScenarioConfigurationPerFailureMechanismSectionType TINYINT (1) NOT NULL, -- Enum: SemiProbabilistic = 1 Probabilistic = 2 + A REAL NOT NULL, + CONSTRAINT FK_PipingFailureMechanismSectionConfigurationEntity_FailureMechanismSectionEntity FOREIGN KEY (FailureMechanismSectionEntityId) REFERENCES FailureMechanismSectionEntity (FailureMechanismSectionEntityId) ON DELETE Cascade ON UPDATE Cascade +) +; + CREATE TABLE SurfaceLineEntity ( SurfaceLineEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -1301,13 +1305,21 @@ ( MacroStabilityInwardsFailureMechanismMetaEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, FailureMechanismEntityId INTEGER NOT NULL, - A REAL NOT NULL, StochasticSoilModelCollectionSourcePath TEXT NULL COLLATE NOCASE, SurfaceLineCollectionSourcePath TEXT NULL COLLATE NOCASE, CONSTRAINT FK_MacroStabilityInwardsFailureMechanismMetaEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; +CREATE TABLE MacroStabilityInwardsFailureMechanismSectionConfigurationEntity +( + MacroStabilityInwardsFailureMechanismSectionConfigurationEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + FailureMechanismSectionEntityId INTEGER NULL, + A REAL NOT NULL, + CONSTRAINT FK_MacroStabilityInwardsFailureMechanismSectionConfigurationEntity_FailureMechanismSectionEntity FOREIGN KEY (FailureMechanismSectionEntityId) REFERENCES FailureMechanismSectionEntity (FailureMechanismSectionEntityId) ON DELETE Cascade ON UPDATE Cascade +) +; + CREATE TABLE MacroStabilityInwardsPreconsolidationStressEntity ( MacroStabilityInwardsPreconsolidationStressEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -1439,7 +1451,6 @@ ( PipingFailureMechanismMetaEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, FailureMechanismEntityId INTEGER NOT NULL, - A REAL NOT NULL, WaterVolumetricWeight REAL NOT NULL, StochasticSoilModelCollectionSourcePath TEXT NULL COLLATE NOCASE, SurfaceLineCollectionSourcePath TEXT NULL COLLATE NOCASE, @@ -1951,14 +1962,14 @@ ON PipingStochasticSoilProfileEntity (StochasticSoilModelEntityId ASC) ; -CREATE INDEX IXFK_PipingScenarioConfigurationPerFailureMechanismSectionEntity_FailureMechanismSectionEntity - ON PipingScenarioConfigurationPerFailureMechanismSectionEntity (FailureMechanismSectionEntityId ASC) -; - CREATE INDEX IXFK_StochasticSoilModelEntity_FailureMechanismEntity ON StochasticSoilModelEntity (FailureMechanismEntityId ASC) ; +CREATE INDEX IXFK_PipingFailureMechanismSectionConfigurationEntity_FailureMechanismSectionEntity + ON PipingFailureMechanismSectionConfigurationEntity (FailureMechanismSectionEntityId ASC) +; + CREATE INDEX IXFK_SurfaceLineEntity_FailureMechanismEntity ON SurfaceLineEntity (FailureMechanismEntityId ASC) ; @@ -2370,6 +2381,10 @@ ON MacroStabilityInwardsFailureMechanismMetaEntity (FailureMechanismEntityId ASC) ; +CREATE INDEX IXFK_MacroStabilityInwardsFailureMechanismSectionConfigurationEntity_FailureMechanismSectionEntity + ON MacroStabilityInwardsFailureMechanismSectionConfigurationEntity (FailureMechanismSectionEntityId ASC) +; + CREATE INDEX IXFK_MacroStabilityInwardsSoilLayerOneDEntity_MacroStabilityInwardsSoilProfileOneDEntity ON MacroStabilityInwardsSoilLayerOneDEntity (MacroStabilityInwardsSoilProfileOneDEntityId ASC) ;