Index: Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql =================================================================== diff -u -r0145176179f872562b3a0408860ffc7187aecb1b -re69abddf5b9c6634b764df231d4e1b290c9e0fb5 --- Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 0145176179f872562b3a0408860ffc7187aecb1b) +++ Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision e69abddf5b9c6634b764df231d4e1b290c9e0fb5) @@ -1,6 +1,6 @@ /* ---------------------------------------------------- */ /* Generated by Enterprise Architect Version 12.0 */ -/* Created On : 08-jun-2016 11:12:19 */ +/* Created On : 08-jun-2016 15:49:57 */ /* DBMS : SQLite */ /* ---------------------------------------------------- */ @@ -66,6 +66,9 @@ DROP TABLE IF EXISTS 'CharacteristicPointEntity' ; +DROP TABLE IF EXISTS 'PipingSemiProbabilisticOutputEntity' +; + /* Create Tables with Primary and Foreign Keys, Check and Unique Constraints */ CREATE TABLE 'PipingFailureMechanismMetaEntity' @@ -190,6 +193,7 @@ 'SaturatedVolumicWeightOfCoverageLayerShift' NUMERIC NOT NULL, 'RelevantForScenario' TINYINT (1) NOT NULL, 'ScenarioContribution' NUMERIC NOT NULL, + 'PipingSemiProbabilisticOutputEntityId' INTEGER, CONSTRAINT 'FK_PipingCalculationEntity_CalculationGroupEntity' FOREIGN KEY ('CalculationGroupEntityId') REFERENCES 'CalculationGroupEntity' ('CalculationGroupEntityId') ON DELETE No Action ON UPDATE No Action, CONSTRAINT 'FK_PipingCalculationEntity_HydraulicLocationEntity' FOREIGN KEY ('HydraulicLocationEntityId') REFERENCES 'HydraulicLocationEntity' ('HydraulicLocationEntityId') ON DELETE No Action ON UPDATE No Action, CONSTRAINT 'FK_PipingCalculationEntity_StochasticSoilProfileEntity' FOREIGN KEY ('StochasticSoilProfileEntityId') REFERENCES 'StochasticSoilProfileEntity' ('StochasticSoilProfileEntityId') ON DELETE No Action ON UPDATE No Action, @@ -304,6 +308,28 @@ ) ; +CREATE TABLE 'PipingSemiProbabilisticOutputEntity' +( + 'PipingSemiProbabilisticOutputEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'PipingCalculationEntityId' INTEGER, + 'UpliftFactorOfSafety' NUMERIC, + 'UpliftReliability' NUMERIC, + 'UpliftProbability' NUMERIC, + 'HeaveFactorOfSafety' NUMERIC, + 'HeaveReliability' NUMERIC, + 'HeaveProbability' NUMERIC, + 'SellmeijerFactorOfSafety' NUMERIC, + 'SellmeijerReliability' NUMERIC, + 'SellmeijerProbability' NUMERIC, + 'RequiredProbability' NUMERIC, + 'RequiredReliability' NUMERIC, + 'PipingProbability' NUMERIC, + 'PipingReliability' NUMERIC, + 'PipingFactorOfSafety' NUMERIC, + CONSTRAINT 'FK_PipingSemiProbabilisticOutputEntity_PipingCalculationEntity' FOREIGN KEY ('PipingCalculationEntityId') REFERENCES 'PipingCalculationEntity' ('PipingCalculationEntityId') ON DELETE No Action ON UPDATE No Action +) +; + /* Create Indexes and Triggers */ CREATE INDEX 'IXFK_PipingFailureMechanismMetaEntity_FailureMechanismEntity' @@ -385,3 +411,7 @@ CREATE INDEX 'IXFK_CharacteristicPointEntity_SurfaceLinePointEntity' ON 'CharacteristicPointEntity' ('SurfaceLinePointEntityId' ASC) ; + +CREATE INDEX 'IXFK_PipingSemiProbabilisticOutputEntity_PipingCalculationEntity' + ON 'PipingSemiProbabilisticOutputEntity' ('PipingCalculationEntityId' ASC) +;