Index: Riskeer/Migration/src/Riskeer.Migration.Core/EmbeddedResources/DatabaseStructure20.1.sql =================================================================== diff -u -rab70956b184642e2345539dc2cb996dabc81be19 -r56f8fcd91e346b2260acc9b8ccee3b5add2852c1 --- Riskeer/Migration/src/Riskeer.Migration.Core/EmbeddedResources/DatabaseStructure20.1.sql (.../DatabaseStructure20.1.sql) (revision ab70956b184642e2345539dc2cb996dabc81be19) +++ Riskeer/Migration/src/Riskeer.Migration.Core/EmbeddedResources/DatabaseStructure20.1.sql (.../DatabaseStructure20.1.sql) (revision 56f8fcd91e346b2260acc9b8ccee3b5add2852c1) @@ -1,6 +1,6 @@ /* ---------------------------------------------------- */ /* Generated by Enterprise Architect Version 14.1 */ -/* Created On : 05-aug-2020 08:38:49 */ +/* Created On : 03-nov-2020 11:25:55 */ /* DBMS : SQLite */ /* ---------------------------------------------------- */ @@ -33,7 +33,7 @@ DROP TABLE IF EXISTS 'GrassCoverErosionInwardsFailureMechanismMetaEntity' ; -DROP TABLE IF EXISTS 'PipingCalculationEntity' +DROP TABLE IF EXISTS 'SemiProbabilisticPipingCalculationEntity' ; DROP TABLE IF EXISTS 'GrassCoverErosionInwardsCalculationEntity' @@ -228,9 +228,6 @@ DROP TABLE IF EXISTS 'MicrostabilitySectionResultEntity' ; -DROP TABLE IF EXISTS 'PipingCalculationOutputEntity' -; - DROP TABLE IF EXISTS 'PipingFailureMechanismMetaEntity' ; @@ -243,6 +240,15 @@ DROP TABLE IF EXISTS 'PipingStructureSectionResultEntity' ; +DROP TABLE IF EXISTS 'ProbabilisticPipingCalculationEntity' +; + +DROP TABLE IF EXISTS 'ProbabilisticPipingCalculationOutput' +; + +DROP TABLE IF EXISTS 'SemiProbabilisticPipingCalculationOutputEntity' +; + DROP TABLE IF EXISTS 'StabilityPointStructureEntity' ; @@ -433,9 +439,9 @@ ) ; -CREATE TABLE 'PipingCalculationEntity' +CREATE TABLE 'SemiProbabilisticPipingCalculationEntity' ( - 'PipingCalculationEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'SemiProbabilisticPipingCalculationEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'CalculationGroupEntityId' INTEGER NOT NULL, 'SurfaceLineEntityId' INTEGER NULL, 'PipingStochasticSoilProfileEntityId' INTEGER NULL, @@ -455,8 +461,8 @@ 'UseAssessmentLevelManualInput' TINYINT (1) NOT NULL, -- true or false CONSTRAINT 'FK_PipingCalculationEntity_CalculationGroupEntity' FOREIGN KEY ('CalculationGroupEntityId') REFERENCES 'CalculationGroupEntity' ('CalculationGroupEntityId') ON DELETE Cascade ON UPDATE Cascade, CONSTRAINT 'FK_PipingCalculationEntity_HydraulicLocationEntity' FOREIGN KEY ('HydraulicLocationEntityId') REFERENCES 'HydraulicLocationEntity' ('HydraulicLocationEntityId') ON DELETE Set Null ON UPDATE Cascade, - CONSTRAINT 'FK_PipingCalculationEntity_PipingStochasticSoilProfileEntity' FOREIGN KEY ('PipingStochasticSoilProfileEntityId') REFERENCES 'PipingStochasticSoilProfileEntity' ('PipingStochasticSoilProfileEntityId') ON DELETE Set Null ON UPDATE Cascade, - CONSTRAINT 'FK_PipingCalculationEntity_SurfaceLineEntity' FOREIGN KEY ('SurfaceLineEntityId') REFERENCES 'SurfaceLineEntity' ('SurfaceLineEntityId') ON DELETE Set Null ON UPDATE Cascade + CONSTRAINT 'FK_SemiProbabilisticPipingCalculationEntity_PipingStochasticSoilProfileEntity' FOREIGN KEY ('PipingStochasticSoilProfileEntityId') REFERENCES 'PipingStochasticSoilProfileEntity' ('PipingStochasticSoilProfileEntityId') ON DELETE Set Null ON UPDATE Cascade, + CONSTRAINT 'FK_SemiProbabilisticPipingCalculationEntity_SurfaceLineEntity' FOREIGN KEY ('SurfaceLineEntityId') REFERENCES 'SurfaceLineEntity' ('SurfaceLineEntityId') ON DELETE Set Null ON UPDATE Cascade ) ; @@ -1570,24 +1576,6 @@ ) ; -CREATE TABLE 'PipingCalculationOutputEntity' -( - 'PipingCalculationOutputEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'PipingCalculationEntityId' INTEGER NOT NULL, - 'Order' INT (4) NOT NULL, - 'HeaveFactorOfSafety' REAL NULL, - 'UpliftFactorOfSafety' REAL NULL, - 'SellmeijerFactorOfSafety' REAL NULL, - 'UpliftEffectiveStress' REAL NULL, - 'HeaveGradient' REAL NULL, - 'SellmeijerCreepCoefficient' REAL NULL, - 'SellmeijerCriticalFall' REAL NULL, - 'SellmeijerReducedFall' REAL NULL, - CONSTRAINT 'FK_PipingCalculationOutputEntity_PipingCalculationEntity' FOREIGN KEY ('PipingCalculationEntityId') REFERENCES 'PipingCalculationEntity' ('PipingCalculationEntityId') ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT 'U_PipingCalculationEntity' UNIQUE ('PipingCalculationEntityId') -) -; - CREATE TABLE 'PipingFailureMechanismMetaEntity' ( 'PipingFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -1636,6 +1624,67 @@ ) ; +CREATE TABLE 'ProbabilisticPipingCalculationEntity' +( + 'ProbabilisticPipingCalculationEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'CalculationGroupEntityId' INTEGER NOT NULL, + 'SurfaceLineEntityId' INTEGER NULL, + 'PipingStochasticSoilProfileEntityId' INTEGER NULL, + 'HydraulicLocationEntityId' INTEGER NULL, + 'Order' INT (4) NOT NULL, + 'Name' VARCHAR (260) NULL, + 'Comments' TEXT NULL, + 'EntryPointL' REAL NULL, + 'ExitPointL' REAL NULL, + 'PhreaticLevelExitMean' REAL NULL, + 'PhreaticLevelExitStandardDeviation' REAL NULL, + 'DampingFactorExitMean' REAL NULL, + 'DampingFactorStandardDeviation' REAL NULL, + 'RelevantForScenario' TINYINT (1) NOT NULL, -- true or false + 'ScenarioContribution' REAL NULL, + 'ShouldProfileSpecificIllustrationPointsBeCalculated' TINYINT (1) NOT NULL, -- true or false + 'ShouldSectionSpecificIllustrationPointsBeCalculated' TINYINT (1) NOT NULL, -- true or false + CONSTRAINT 'FK_ProbabilisticPipingCalculationEntitiy_CalculationGroupEntity' FOREIGN KEY ('CalculationGroupEntityId') REFERENCES 'CalculationGroupEntity' ('CalculationGroupEntityId') ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT 'FK_ProbabilisticPipingCalculationEntitiy_HydraulicLocationEntity' FOREIGN KEY ('HydraulicLocationEntityId') REFERENCES 'HydraulicLocationEntity' ('HydraulicLocationEntityId') ON DELETE Set Null ON UPDATE Cascade, + CONSTRAINT 'FK_ProbabilisticPipingCalculationEntitiy_PipingStochasticSoilProfileEntity' FOREIGN KEY ('PipingStochasticSoilProfileEntityId') REFERENCES 'PipingStochasticSoilProfileEntity' ('PipingStochasticSoilProfileEntityId') ON DELETE Set Null ON UPDATE Cascade, + CONSTRAINT 'FK_ProbabilisticPipingCalculationEntitiy_SurfaceLineEntity' FOREIGN KEY ('SurfaceLineEntityId') REFERENCES 'SurfaceLineEntity' ('SurfaceLineEntityId') ON DELETE Set Null ON UPDATE Cascade +) +; + +CREATE TABLE 'ProbabilisticPipingCalculationOutput' +( + 'ProbabilisticPipingCalculationOutputEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'ProbabilisticPipingCalculationEntityId' INTEGER NOT NULL, + 'ProfileSpecificGeneralResultFaultTreeIllustrationPointEntityId' INTEGER NULL, + 'SectionSpecificGeneralResultFaultTreeIllustrationPointEntityId' INTEGER NULL, + 'Order' INT (4) NOT NULL, + 'ProfileSpecificReliability' REAL NULL, + 'SectionSpecificReliability' REAL NULL, + CONSTRAINT 'FK_ProbabilisticPipingCalculationOutput_ProbabilisticPipingCalculationEntitiy' FOREIGN KEY ('ProbabilisticPipingCalculationEntityId') REFERENCES 'ProbabilisticPipingCalculationEntity' ('ProbabilisticPipingCalculationEntityId') ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT 'FK_ProbabilisticPipingCalculationOutput_Profile_GeneralResultFaultTreeIllustrationPointEntity' FOREIGN KEY ('ProfileSpecificGeneralResultFaultTreeIllustrationPointEntityId') REFERENCES 'GeneralResultFaultTreeIllustrationPointEntity' ('GeneralResultFaultTreeIllustrationPointEntityId') ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT 'FK_ProbabilisticPipingCalculationOutput_Section_GeneralResultFaultTreeIllustrationPointEntity' FOREIGN KEY ('SectionSpecificGeneralResultFaultTreeIllustrationPointEntityId') REFERENCES 'GeneralResultFaultTreeIllustrationPointEntity' ('GeneralResultFaultTreeIllustrationPointEntityId') ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT 'U_ProbabilisticPipingCalculationEntity' UNIQUE ('ProbabilisticPipingCalculationEntityId') +) +; + +CREATE TABLE 'SemiProbabilisticPipingCalculationOutputEntity' +( + 'SemiProbabilisticPipingCalculationOutputEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'SemiProbabilisticPipingCalculationEntityId' INTEGER NOT NULL, + 'Order' INT (4) NOT NULL, + 'HeaveFactorOfSafety' REAL NULL, + 'UpliftFactorOfSafety' REAL NULL, + 'SellmeijerFactorOfSafety' REAL NULL, + 'UpliftEffectiveStress' REAL NULL, + 'HeaveGradient' REAL NULL, + 'SellmeijerCreepCoefficient' REAL NULL, + 'SellmeijerCriticalFall' REAL NULL, + 'SellmeijerReducedFall' REAL NULL, + CONSTRAINT 'FK_SemiProbabilisticPipingCalculationOutputEntity_SemiProbabilisticPipingCalculationEntity' FOREIGN KEY ('SemiProbabilisticPipingCalculationEntityId') REFERENCES 'SemiProbabilisticPipingCalculationEntity' ('SemiProbabilisticPipingCalculationEntityId') ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT 'U_SemiProbabilisticPipingCalculationEntity' UNIQUE ('SemiProbabilisticPipingCalculationEntityId') +) +; + CREATE TABLE 'StabilityPointStructureEntity' ( 'StabilityPointStructureEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -2120,20 +2169,20 @@ ON 'GrassCoverErosionInwardsFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) ; -CREATE INDEX 'IXFK_PipingCalculationEntity_PipingStochasticSoilProfileEntity' - ON 'PipingCalculationEntity' ('PipingStochasticSoilProfileEntityId' ASC) +CREATE INDEX 'IXFK_SemiProbabilisticPipingCalculationEntity_PipingStochasticSoilProfileEntity' + ON 'SemiProbabilisticPipingCalculationEntity' ('PipingStochasticSoilProfileEntityId' ASC) ; -CREATE INDEX 'IXFK_PipingCalculationEntity_SurfaceLineEntity' - ON 'PipingCalculationEntity' ('SurfaceLineEntityId' ASC) +CREATE INDEX 'IXFK_SemiProbabilisticPipingCalculationEntity_SurfaceLineEntity' + ON 'SemiProbabilisticPipingCalculationEntity' ('SurfaceLineEntityId' ASC) ; -CREATE INDEX 'IXFK_PipingCalculationEntity_HydraulicLocationEntity' - ON 'PipingCalculationEntity' ('HydraulicLocationEntityId' ASC) +CREATE INDEX 'IXFK_SemiProbabilisticPipingCalculationEntity_HydraulicLocationEntity' + ON 'SemiProbabilisticPipingCalculationEntity' ('HydraulicLocationEntityId' ASC) ; -CREATE INDEX 'IXFK_PipingCalculationEntity_CalculationGroupEntity' - ON 'PipingCalculationEntity' ('CalculationGroupEntityId' ASC) +CREATE INDEX 'IXFK_SemiProbabilisticPipingCalculationEntity_CalculationGroupEntity' + ON 'SemiProbabilisticPipingCalculationEntity' ('CalculationGroupEntityId' ASC) ; CREATE INDEX 'IXFK_GrassCoverErosionInwardsCalculationEntity_CalculationGroupEntity' @@ -2672,10 +2721,6 @@ ON 'MicrostabilitySectionResultEntity' ('FailureMechanismSectionEntityId' ASC) ; -CREATE INDEX 'IXFK_PipingCalculationOutputEntity_PipingCalculationEntity' - ON 'PipingCalculationOutputEntity' ('PipingCalculationEntityId' ASC) -; - CREATE INDEX 'IXFK_PipingFailureMechanismMetaEntity_FailureMechanismEntity' ON 'PipingFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) ; @@ -2692,6 +2737,38 @@ ON 'PipingStructureSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) ; +CREATE INDEX 'IXFK_ProbabilisticPipingCalculationEntitiy_CalculationGroupEntity' + ON 'ProbabilisticPipingCalculationEntity' ('CalculationGroupEntityId' ASC) +; + +CREATE INDEX 'IXFK_ProbabilisticPipingCalculationEntitiy_HydraulicLocationEntity' + ON 'ProbabilisticPipingCalculationEntity' ('HydraulicLocationEntityId' ASC) +; + +CREATE INDEX 'IXFK_ProbabilisticPipingCalculationEntitiy_PipingStochasticSoilProfileEntity' + ON 'ProbabilisticPipingCalculationEntity' ('PipingStochasticSoilProfileEntityId' ASC) +; + +CREATE INDEX 'IXFK_ProbabilisticPipingCalculationEntitiy_SurfaceLineEntity' + ON 'ProbabilisticPipingCalculationEntity' ('SurfaceLineEntityId' ASC) +; + +CREATE INDEX 'IXFK_ProbabilisticPipingCalculationOutput_ProbabilisticPipingCalculationEntitiy' + ON 'ProbabilisticPipingCalculationOutput' ('ProbabilisticPipingCalculationEntityId' ASC) +; + +CREATE INDEX 'IXFK_ProbabilisticPipingCalculationOutput_Profile_GeneralResultFaultTreeIllustrationPointEntity' + ON 'ProbabilisticPipingCalculationOutput' ('ProfileSpecificGeneralResultFaultTreeIllustrationPointEntityId' ASC) +; + +CREATE INDEX 'IXFK_ProbabilisticPipingCalculationOutput_Section_GeneralResultFaultTreeIllustrationPointEntity' + ON 'ProbabilisticPipingCalculationOutput' ('ProfileSpecificGeneralResultFaultTreeIllustrationPointEntityId' ASC) +; + +CREATE INDEX 'IXFK_SemiProbabilisticPipingCalculationOutputEntity_SemiProbabilisticPipingCalculationEntity' + ON 'SemiProbabilisticPipingCalculationOutputEntity' ('SemiProbabilisticPipingCalculationEntityId' ASC) +; + CREATE INDEX 'IXFK_StabilityPointStructureEntity_FailureMechanismEntity' ON 'StabilityPointStructureEntity' ('FailureMechanismEntityId' ASC) ; Index: build/DatabaseStructure.sql =================================================================== diff -u -r2c1f66c35b88e58c176a32db511cd631d36a2838 -r56f8fcd91e346b2260acc9b8ccee3b5add2852c1 --- build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 2c1f66c35b88e58c176a32db511cd631d36a2838) +++ build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 56f8fcd91e346b2260acc9b8ccee3b5add2852c1) @@ -1,6 +1,6 @@ /* ---------------------------------------------------- */ /* Generated by Enterprise Architect Version 14.1 */ -/* Created On : 05-aug-2020 08:38:49 */ +/* Created On : 03-nov-2020 11:25:55 */ /* DBMS : SQLite */ /* ---------------------------------------------------- */ @@ -33,7 +33,7 @@ DROP TABLE IF EXISTS 'GrassCoverErosionInwardsFailureMechanismMetaEntity' ; -DROP TABLE IF EXISTS 'PipingCalculationEntity' +DROP TABLE IF EXISTS 'SemiProbabilisticPipingCalculationEntity' ; DROP TABLE IF EXISTS 'GrassCoverErosionInwardsCalculationEntity' @@ -228,9 +228,6 @@ DROP TABLE IF EXISTS 'MicrostabilitySectionResultEntity' ; -DROP TABLE IF EXISTS 'PipingCalculationOutputEntity' -; - DROP TABLE IF EXISTS 'PipingFailureMechanismMetaEntity' ; @@ -243,6 +240,15 @@ DROP TABLE IF EXISTS 'PipingStructureSectionResultEntity' ; +DROP TABLE IF EXISTS 'ProbabilisticPipingCalculationEntity' +; + +DROP TABLE IF EXISTS 'ProbabilisticPipingCalculationOutput' +; + +DROP TABLE IF EXISTS 'SemiProbabilisticPipingCalculationOutputEntity' +; + DROP TABLE IF EXISTS 'StabilityPointStructureEntity' ; @@ -433,9 +439,9 @@ ) ; -CREATE TABLE 'PipingCalculationEntity' +CREATE TABLE 'SemiProbabilisticPipingCalculationEntity' ( - 'PipingCalculationEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'SemiProbabilisticPipingCalculationEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'CalculationGroupEntityId' INTEGER NOT NULL, 'SurfaceLineEntityId' INTEGER NULL, 'PipingStochasticSoilProfileEntityId' INTEGER NULL, @@ -455,8 +461,8 @@ 'UseAssessmentLevelManualInput' TINYINT (1) NOT NULL, -- true or false CONSTRAINT 'FK_PipingCalculationEntity_CalculationGroupEntity' FOREIGN KEY ('CalculationGroupEntityId') REFERENCES 'CalculationGroupEntity' ('CalculationGroupEntityId') ON DELETE Cascade ON UPDATE Cascade, CONSTRAINT 'FK_PipingCalculationEntity_HydraulicLocationEntity' FOREIGN KEY ('HydraulicLocationEntityId') REFERENCES 'HydraulicLocationEntity' ('HydraulicLocationEntityId') ON DELETE Set Null ON UPDATE Cascade, - CONSTRAINT 'FK_PipingCalculationEntity_PipingStochasticSoilProfileEntity' FOREIGN KEY ('PipingStochasticSoilProfileEntityId') REFERENCES 'PipingStochasticSoilProfileEntity' ('PipingStochasticSoilProfileEntityId') ON DELETE Set Null ON UPDATE Cascade, - CONSTRAINT 'FK_PipingCalculationEntity_SurfaceLineEntity' FOREIGN KEY ('SurfaceLineEntityId') REFERENCES 'SurfaceLineEntity' ('SurfaceLineEntityId') ON DELETE Set Null ON UPDATE Cascade + CONSTRAINT 'FK_SemiProbabilisticPipingCalculationEntity_PipingStochasticSoilProfileEntity' FOREIGN KEY ('PipingStochasticSoilProfileEntityId') REFERENCES 'PipingStochasticSoilProfileEntity' ('PipingStochasticSoilProfileEntityId') ON DELETE Set Null ON UPDATE Cascade, + CONSTRAINT 'FK_SemiProbabilisticPipingCalculationEntity_SurfaceLineEntity' FOREIGN KEY ('SurfaceLineEntityId') REFERENCES 'SurfaceLineEntity' ('SurfaceLineEntityId') ON DELETE Set Null ON UPDATE Cascade ) ; @@ -1570,24 +1576,6 @@ ) ; -CREATE TABLE 'PipingCalculationOutputEntity' -( - 'PipingCalculationOutputEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'PipingCalculationEntityId' INTEGER NOT NULL, - 'Order' INT (4) NOT NULL, - 'HeaveFactorOfSafety' REAL NULL, - 'UpliftFactorOfSafety' REAL NULL, - 'SellmeijerFactorOfSafety' REAL NULL, - 'UpliftEffectiveStress' REAL NULL, - 'HeaveGradient' REAL NULL, - 'SellmeijerCreepCoefficient' REAL NULL, - 'SellmeijerCriticalFall' REAL NULL, - 'SellmeijerReducedFall' REAL NULL, - CONSTRAINT 'FK_PipingCalculationOutputEntity_PipingCalculationEntity' FOREIGN KEY ('PipingCalculationEntityId') REFERENCES 'PipingCalculationEntity' ('PipingCalculationEntityId') ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT 'U_PipingCalculationEntity' UNIQUE ('PipingCalculationEntityId') -) -; - CREATE TABLE 'PipingFailureMechanismMetaEntity' ( 'PipingFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -1636,6 +1624,67 @@ ) ; +CREATE TABLE 'ProbabilisticPipingCalculationEntity' +( + 'ProbabilisticPipingCalculationEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'CalculationGroupEntityId' INTEGER NOT NULL, + 'SurfaceLineEntityId' INTEGER NULL, + 'PipingStochasticSoilProfileEntityId' INTEGER NULL, + 'HydraulicLocationEntityId' INTEGER NULL, + 'Order' INT (4) NOT NULL, + 'Name' VARCHAR (260) NULL, + 'Comments' TEXT NULL, + 'EntryPointL' REAL NULL, + 'ExitPointL' REAL NULL, + 'PhreaticLevelExitMean' REAL NULL, + 'PhreaticLevelExitStandardDeviation' REAL NULL, + 'DampingFactorExitMean' REAL NULL, + 'DampingFactorStandardDeviation' REAL NULL, + 'RelevantForScenario' TINYINT (1) NOT NULL, -- true or false + 'ScenarioContribution' REAL NULL, + 'ShouldProfileSpecificIllustrationPointsBeCalculated' TINYINT (1) NOT NULL, -- true or false + 'ShouldSectionSpecificIllustrationPointsBeCalculated' TINYINT (1) NOT NULL, -- true or false + CONSTRAINT 'FK_ProbabilisticPipingCalculationEntitiy_CalculationGroupEntity' FOREIGN KEY ('CalculationGroupEntityId') REFERENCES 'CalculationGroupEntity' ('CalculationGroupEntityId') ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT 'FK_ProbabilisticPipingCalculationEntitiy_HydraulicLocationEntity' FOREIGN KEY ('HydraulicLocationEntityId') REFERENCES 'HydraulicLocationEntity' ('HydraulicLocationEntityId') ON DELETE Set Null ON UPDATE Cascade, + CONSTRAINT 'FK_ProbabilisticPipingCalculationEntitiy_PipingStochasticSoilProfileEntity' FOREIGN KEY ('PipingStochasticSoilProfileEntityId') REFERENCES 'PipingStochasticSoilProfileEntity' ('PipingStochasticSoilProfileEntityId') ON DELETE Set Null ON UPDATE Cascade, + CONSTRAINT 'FK_ProbabilisticPipingCalculationEntitiy_SurfaceLineEntity' FOREIGN KEY ('SurfaceLineEntityId') REFERENCES 'SurfaceLineEntity' ('SurfaceLineEntityId') ON DELETE Set Null ON UPDATE Cascade +) +; + +CREATE TABLE 'ProbabilisticPipingCalculationOutput' +( + 'ProbabilisticPipingCalculationOutputEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'ProbabilisticPipingCalculationEntityId' INTEGER NOT NULL, + 'ProfileSpecificGeneralResultFaultTreeIllustrationPointEntityId' INTEGER NULL, + 'SectionSpecificGeneralResultFaultTreeIllustrationPointEntityId' INTEGER NULL, + 'Order' INT (4) NOT NULL, + 'ProfileSpecificReliability' REAL NULL, + 'SectionSpecificReliability' REAL NULL, + CONSTRAINT 'FK_ProbabilisticPipingCalculationOutput_ProbabilisticPipingCalculationEntitiy' FOREIGN KEY ('ProbabilisticPipingCalculationEntityId') REFERENCES 'ProbabilisticPipingCalculationEntity' ('ProbabilisticPipingCalculationEntityId') ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT 'FK_ProbabilisticPipingCalculationOutput_Profile_GeneralResultFaultTreeIllustrationPointEntity' FOREIGN KEY ('ProfileSpecificGeneralResultFaultTreeIllustrationPointEntityId') REFERENCES 'GeneralResultFaultTreeIllustrationPointEntity' ('GeneralResultFaultTreeIllustrationPointEntityId') ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT 'FK_ProbabilisticPipingCalculationOutput_Section_GeneralResultFaultTreeIllustrationPointEntity' FOREIGN KEY ('SectionSpecificGeneralResultFaultTreeIllustrationPointEntityId') REFERENCES 'GeneralResultFaultTreeIllustrationPointEntity' ('GeneralResultFaultTreeIllustrationPointEntityId') ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT 'U_ProbabilisticPipingCalculationEntity' UNIQUE ('ProbabilisticPipingCalculationEntityId') +) +; + +CREATE TABLE 'SemiProbabilisticPipingCalculationOutputEntity' +( + 'SemiProbabilisticPipingCalculationOutputEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'SemiProbabilisticPipingCalculationEntityId' INTEGER NOT NULL, + 'Order' INT (4) NOT NULL, + 'HeaveFactorOfSafety' REAL NULL, + 'UpliftFactorOfSafety' REAL NULL, + 'SellmeijerFactorOfSafety' REAL NULL, + 'UpliftEffectiveStress' REAL NULL, + 'HeaveGradient' REAL NULL, + 'SellmeijerCreepCoefficient' REAL NULL, + 'SellmeijerCriticalFall' REAL NULL, + 'SellmeijerReducedFall' REAL NULL, + CONSTRAINT 'FK_SemiProbabilisticPipingCalculationOutputEntity_SemiProbabilisticPipingCalculationEntity' FOREIGN KEY ('SemiProbabilisticPipingCalculationEntityId') REFERENCES 'SemiProbabilisticPipingCalculationEntity' ('SemiProbabilisticPipingCalculationEntityId') ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT 'U_SemiProbabilisticPipingCalculationEntity' UNIQUE ('SemiProbabilisticPipingCalculationEntityId') +) +; + CREATE TABLE 'StabilityPointStructureEntity' ( 'StabilityPointStructureEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -2120,20 +2169,20 @@ ON 'GrassCoverErosionInwardsFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) ; -CREATE INDEX 'IXFK_PipingCalculationEntity_PipingStochasticSoilProfileEntity' - ON 'PipingCalculationEntity' ('PipingStochasticSoilProfileEntityId' ASC) +CREATE INDEX 'IXFK_SemiProbabilisticPipingCalculationEntity_PipingStochasticSoilProfileEntity' + ON 'SemiProbabilisticPipingCalculationEntity' ('PipingStochasticSoilProfileEntityId' ASC) ; -CREATE INDEX 'IXFK_PipingCalculationEntity_SurfaceLineEntity' - ON 'PipingCalculationEntity' ('SurfaceLineEntityId' ASC) +CREATE INDEX 'IXFK_SemiProbabilisticPipingCalculationEntity_SurfaceLineEntity' + ON 'SemiProbabilisticPipingCalculationEntity' ('SurfaceLineEntityId' ASC) ; -CREATE INDEX 'IXFK_PipingCalculationEntity_HydraulicLocationEntity' - ON 'PipingCalculationEntity' ('HydraulicLocationEntityId' ASC) +CREATE INDEX 'IXFK_SemiProbabilisticPipingCalculationEntity_HydraulicLocationEntity' + ON 'SemiProbabilisticPipingCalculationEntity' ('HydraulicLocationEntityId' ASC) ; -CREATE INDEX 'IXFK_PipingCalculationEntity_CalculationGroupEntity' - ON 'PipingCalculationEntity' ('CalculationGroupEntityId' ASC) +CREATE INDEX 'IXFK_SemiProbabilisticPipingCalculationEntity_CalculationGroupEntity' + ON 'SemiProbabilisticPipingCalculationEntity' ('CalculationGroupEntityId' ASC) ; CREATE INDEX 'IXFK_GrassCoverErosionInwardsCalculationEntity_CalculationGroupEntity' @@ -2672,10 +2721,6 @@ ON 'MicrostabilitySectionResultEntity' ('FailureMechanismSectionEntityId' ASC) ; -CREATE INDEX 'IXFK_PipingCalculationOutputEntity_PipingCalculationEntity' - ON 'PipingCalculationOutputEntity' ('PipingCalculationEntityId' ASC) -; - CREATE INDEX 'IXFK_PipingFailureMechanismMetaEntity_FailureMechanismEntity' ON 'PipingFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) ; @@ -2692,6 +2737,38 @@ ON 'PipingStructureSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) ; +CREATE INDEX 'IXFK_ProbabilisticPipingCalculationEntitiy_CalculationGroupEntity' + ON 'ProbabilisticPipingCalculationEntity' ('CalculationGroupEntityId' ASC) +; + +CREATE INDEX 'IXFK_ProbabilisticPipingCalculationEntitiy_HydraulicLocationEntity' + ON 'ProbabilisticPipingCalculationEntity' ('HydraulicLocationEntityId' ASC) +; + +CREATE INDEX 'IXFK_ProbabilisticPipingCalculationEntitiy_PipingStochasticSoilProfileEntity' + ON 'ProbabilisticPipingCalculationEntity' ('PipingStochasticSoilProfileEntityId' ASC) +; + +CREATE INDEX 'IXFK_ProbabilisticPipingCalculationEntitiy_SurfaceLineEntity' + ON 'ProbabilisticPipingCalculationEntity' ('SurfaceLineEntityId' ASC) +; + +CREATE INDEX 'IXFK_ProbabilisticPipingCalculationOutput_ProbabilisticPipingCalculationEntitiy' + ON 'ProbabilisticPipingCalculationOutput' ('ProbabilisticPipingCalculationEntityId' ASC) +; + +CREATE INDEX 'IXFK_ProbabilisticPipingCalculationOutput_Profile_GeneralResultFaultTreeIllustrationPointEntity' + ON 'ProbabilisticPipingCalculationOutput' ('ProfileSpecificGeneralResultFaultTreeIllustrationPointEntityId' ASC) +; + +CREATE INDEX 'IXFK_ProbabilisticPipingCalculationOutput_Section_GeneralResultFaultTreeIllustrationPointEntity' + ON 'ProbabilisticPipingCalculationOutput' ('ProfileSpecificGeneralResultFaultTreeIllustrationPointEntityId' ASC) +; + +CREATE INDEX 'IXFK_SemiProbabilisticPipingCalculationOutputEntity_SemiProbabilisticPipingCalculationEntity' + ON 'SemiProbabilisticPipingCalculationOutputEntity' ('SemiProbabilisticPipingCalculationEntityId' ASC) +; + CREATE INDEX 'IXFK_StabilityPointStructureEntity_FailureMechanismEntity' ON 'StabilityPointStructureEntity' ('FailureMechanismEntityId' ASC) ;