Index: Riskeer/Migration/src/Riskeer.Migration.Core/EmbeddedResources/DatabaseStructure20.1.sql =================================================================== diff -u -r56f8fcd91e346b2260acc9b8ccee3b5add2852c1 -r947fdc29e0733d9a0f099a502a5826141bcd7050 --- Riskeer/Migration/src/Riskeer.Migration.Core/EmbeddedResources/DatabaseStructure20.1.sql (.../DatabaseStructure20.1.sql) (revision 56f8fcd91e346b2260acc9b8ccee3b5add2852c1) +++ Riskeer/Migration/src/Riskeer.Migration.Core/EmbeddedResources/DatabaseStructure20.1.sql (.../DatabaseStructure20.1.sql) (revision 947fdc29e0733d9a0f099a502a5826141bcd7050) @@ -1,6 +1,6 @@ /* ---------------------------------------------------- */ /* Generated by Enterprise Architect Version 14.1 */ -/* Created On : 03-nov-2020 11:25:55 */ +/* Created On : 04-nov-2020 13:17:24 */ /* DBMS : SQLite */ /* ---------------------------------------------------- */ @@ -243,7 +243,7 @@ DROP TABLE IF EXISTS 'ProbabilisticPipingCalculationEntity' ; -DROP TABLE IF EXISTS 'ProbabilisticPipingCalculationOutput' +DROP TABLE IF EXISTS 'ProbabilisticPipingCalculationOutputEntity' ; DROP TABLE IF EXISTS 'SemiProbabilisticPipingCalculationOutputEntity' @@ -1639,19 +1639,19 @@ 'PhreaticLevelExitMean' REAL NULL, 'PhreaticLevelExitStandardDeviation' REAL NULL, 'DampingFactorExitMean' REAL NULL, - 'DampingFactorStandardDeviation' REAL NULL, + 'DampingFactorExitStandardDeviation' 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 + CONSTRAINT 'FK_ProbabilisticPipingCalculationEntity_CalculationGroupEntity' FOREIGN KEY ('CalculationGroupEntityId') REFERENCES 'CalculationGroupEntity' ('CalculationGroupEntityId') ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT 'FK_ProbabilisticPipingCalculationEntity_HydraulicLocationEntity' FOREIGN KEY ('HydraulicLocationEntityId') REFERENCES 'HydraulicLocationEntity' ('HydraulicLocationEntityId') ON DELETE Set Null ON UPDATE Cascade, + CONSTRAINT 'FK_ProbabilisticPipingCalculationEntity_PipingStochasticSoilProfileEntity' FOREIGN KEY ('PipingStochasticSoilProfileEntityId') REFERENCES 'PipingStochasticSoilProfileEntity' ('PipingStochasticSoilProfileEntityId') ON DELETE Set Null ON UPDATE Cascade, + CONSTRAINT 'FK_ProbabilisticPipingCalculationEntity_SurfaceLineEntity' FOREIGN KEY ('SurfaceLineEntityId') REFERENCES 'SurfaceLineEntity' ('SurfaceLineEntityId') ON DELETE Set Null ON UPDATE Cascade ) ; -CREATE TABLE 'ProbabilisticPipingCalculationOutput' +CREATE TABLE 'ProbabilisticPipingCalculationOutputEntity' ( 'ProbabilisticPipingCalculationOutputEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'ProbabilisticPipingCalculationEntityId' INTEGER NOT NULL, @@ -1660,7 +1660,7 @@ '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_ProbabilisticPipingCalculationEntity' 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') @@ -2737,32 +2737,32 @@ ON 'PipingStructureSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) ; -CREATE INDEX 'IXFK_ProbabilisticPipingCalculationEntitiy_CalculationGroupEntity' +CREATE INDEX 'IXFK_ProbabilisticPipingCalculationEntity_CalculationGroupEntity' ON 'ProbabilisticPipingCalculationEntity' ('CalculationGroupEntityId' ASC) ; -CREATE INDEX 'IXFK_ProbabilisticPipingCalculationEntitiy_HydraulicLocationEntity' +CREATE INDEX 'IXFK_ProbabilisticPipingCalculationEntity_HydraulicLocationEntity' ON 'ProbabilisticPipingCalculationEntity' ('HydraulicLocationEntityId' ASC) ; -CREATE INDEX 'IXFK_ProbabilisticPipingCalculationEntitiy_PipingStochasticSoilProfileEntity' +CREATE INDEX 'IXFK_ProbabilisticPipingCalculationEntity_PipingStochasticSoilProfileEntity' ON 'ProbabilisticPipingCalculationEntity' ('PipingStochasticSoilProfileEntityId' ASC) ; -CREATE INDEX 'IXFK_ProbabilisticPipingCalculationEntitiy_SurfaceLineEntity' +CREATE INDEX 'IXFK_ProbabilisticPipingCalculationEntity_SurfaceLineEntity' ON 'ProbabilisticPipingCalculationEntity' ('SurfaceLineEntityId' ASC) ; -CREATE INDEX 'IXFK_ProbabilisticPipingCalculationOutput_ProbabilisticPipingCalculationEntitiy' - ON 'ProbabilisticPipingCalculationOutput' ('ProbabilisticPipingCalculationEntityId' ASC) +CREATE INDEX 'IXFK_ProbabilisticPipingCalculationOutput_ProbabilisticPipingCalculationEntity' + ON 'ProbabilisticPipingCalculationOutputEntity' ('ProbabilisticPipingCalculationEntityId' ASC) ; CREATE INDEX 'IXFK_ProbabilisticPipingCalculationOutput_Profile_GeneralResultFaultTreeIllustrationPointEntity' - ON 'ProbabilisticPipingCalculationOutput' ('ProfileSpecificGeneralResultFaultTreeIllustrationPointEntityId' ASC) + ON 'ProbabilisticPipingCalculationOutputEntity' ('ProfileSpecificGeneralResultFaultTreeIllustrationPointEntityId' ASC) ; CREATE INDEX 'IXFK_ProbabilisticPipingCalculationOutput_Section_GeneralResultFaultTreeIllustrationPointEntity' - ON 'ProbabilisticPipingCalculationOutput' ('ProfileSpecificGeneralResultFaultTreeIllustrationPointEntityId' ASC) + ON 'ProbabilisticPipingCalculationOutputEntity' ('ProfileSpecificGeneralResultFaultTreeIllustrationPointEntityId' ASC) ; CREATE INDEX 'IXFK_SemiProbabilisticPipingCalculationOutputEntity_SemiProbabilisticPipingCalculationEntity' Index: build/DatabaseStructure.sql =================================================================== diff -u -r56f8fcd91e346b2260acc9b8ccee3b5add2852c1 -r947fdc29e0733d9a0f099a502a5826141bcd7050 --- build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 56f8fcd91e346b2260acc9b8ccee3b5add2852c1) +++ build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 947fdc29e0733d9a0f099a502a5826141bcd7050) @@ -1,6 +1,6 @@ /* ---------------------------------------------------- */ /* Generated by Enterprise Architect Version 14.1 */ -/* Created On : 03-nov-2020 11:25:55 */ +/* Created On : 04-nov-2020 13:17:24 */ /* DBMS : SQLite */ /* ---------------------------------------------------- */ @@ -243,7 +243,7 @@ DROP TABLE IF EXISTS 'ProbabilisticPipingCalculationEntity' ; -DROP TABLE IF EXISTS 'ProbabilisticPipingCalculationOutput' +DROP TABLE IF EXISTS 'ProbabilisticPipingCalculationOutputEntity' ; DROP TABLE IF EXISTS 'SemiProbabilisticPipingCalculationOutputEntity' @@ -1639,19 +1639,19 @@ 'PhreaticLevelExitMean' REAL NULL, 'PhreaticLevelExitStandardDeviation' REAL NULL, 'DampingFactorExitMean' REAL NULL, - 'DampingFactorStandardDeviation' REAL NULL, + 'DampingFactorExitStandardDeviation' 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 + CONSTRAINT 'FK_ProbabilisticPipingCalculationEntity_CalculationGroupEntity' FOREIGN KEY ('CalculationGroupEntityId') REFERENCES 'CalculationGroupEntity' ('CalculationGroupEntityId') ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT 'FK_ProbabilisticPipingCalculationEntity_HydraulicLocationEntity' FOREIGN KEY ('HydraulicLocationEntityId') REFERENCES 'HydraulicLocationEntity' ('HydraulicLocationEntityId') ON DELETE Set Null ON UPDATE Cascade, + CONSTRAINT 'FK_ProbabilisticPipingCalculationEntity_PipingStochasticSoilProfileEntity' FOREIGN KEY ('PipingStochasticSoilProfileEntityId') REFERENCES 'PipingStochasticSoilProfileEntity' ('PipingStochasticSoilProfileEntityId') ON DELETE Set Null ON UPDATE Cascade, + CONSTRAINT 'FK_ProbabilisticPipingCalculationEntity_SurfaceLineEntity' FOREIGN KEY ('SurfaceLineEntityId') REFERENCES 'SurfaceLineEntity' ('SurfaceLineEntityId') ON DELETE Set Null ON UPDATE Cascade ) ; -CREATE TABLE 'ProbabilisticPipingCalculationOutput' +CREATE TABLE 'ProbabilisticPipingCalculationOutputEntity' ( 'ProbabilisticPipingCalculationOutputEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'ProbabilisticPipingCalculationEntityId' INTEGER NOT NULL, @@ -1660,7 +1660,7 @@ '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_ProbabilisticPipingCalculationEntity' 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') @@ -2737,32 +2737,32 @@ ON 'PipingStructureSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) ; -CREATE INDEX 'IXFK_ProbabilisticPipingCalculationEntitiy_CalculationGroupEntity' +CREATE INDEX 'IXFK_ProbabilisticPipingCalculationEntity_CalculationGroupEntity' ON 'ProbabilisticPipingCalculationEntity' ('CalculationGroupEntityId' ASC) ; -CREATE INDEX 'IXFK_ProbabilisticPipingCalculationEntitiy_HydraulicLocationEntity' +CREATE INDEX 'IXFK_ProbabilisticPipingCalculationEntity_HydraulicLocationEntity' ON 'ProbabilisticPipingCalculationEntity' ('HydraulicLocationEntityId' ASC) ; -CREATE INDEX 'IXFK_ProbabilisticPipingCalculationEntitiy_PipingStochasticSoilProfileEntity' +CREATE INDEX 'IXFK_ProbabilisticPipingCalculationEntity_PipingStochasticSoilProfileEntity' ON 'ProbabilisticPipingCalculationEntity' ('PipingStochasticSoilProfileEntityId' ASC) ; -CREATE INDEX 'IXFK_ProbabilisticPipingCalculationEntitiy_SurfaceLineEntity' +CREATE INDEX 'IXFK_ProbabilisticPipingCalculationEntity_SurfaceLineEntity' ON 'ProbabilisticPipingCalculationEntity' ('SurfaceLineEntityId' ASC) ; -CREATE INDEX 'IXFK_ProbabilisticPipingCalculationOutput_ProbabilisticPipingCalculationEntitiy' - ON 'ProbabilisticPipingCalculationOutput' ('ProbabilisticPipingCalculationEntityId' ASC) +CREATE INDEX 'IXFK_ProbabilisticPipingCalculationOutput_ProbabilisticPipingCalculationEntity' + ON 'ProbabilisticPipingCalculationOutputEntity' ('ProbabilisticPipingCalculationEntityId' ASC) ; CREATE INDEX 'IXFK_ProbabilisticPipingCalculationOutput_Profile_GeneralResultFaultTreeIllustrationPointEntity' - ON 'ProbabilisticPipingCalculationOutput' ('ProfileSpecificGeneralResultFaultTreeIllustrationPointEntityId' ASC) + ON 'ProbabilisticPipingCalculationOutputEntity' ('ProfileSpecificGeneralResultFaultTreeIllustrationPointEntityId' ASC) ; CREATE INDEX 'IXFK_ProbabilisticPipingCalculationOutput_Section_GeneralResultFaultTreeIllustrationPointEntity' - ON 'ProbabilisticPipingCalculationOutput' ('ProfileSpecificGeneralResultFaultTreeIllustrationPointEntityId' ASC) + ON 'ProbabilisticPipingCalculationOutputEntity' ('ProfileSpecificGeneralResultFaultTreeIllustrationPointEntityId' ASC) ; CREATE INDEX 'IXFK_SemiProbabilisticPipingCalculationOutputEntity_SemiProbabilisticPipingCalculationEntity'