Index: Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql =================================================================== diff -u -rf9f201ed25d82301a1f9e03e909ff2b57deb7c12 -r11f0867b39150ae5fac83dc178a89fee46d27611 --- Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision f9f201ed25d82301a1f9e03e909ff2b57deb7c12) +++ Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 11f0867b39150ae5fac83dc178a89fee46d27611) @@ -1,6 +1,6 @@ /* ---------------------------------------------------- */ /* Generated by Enterprise Architect Version 12.0 */ -/* Created On : 15-Aug-2016 3:45:08 PM */ +/* Created On : 13-sep-2016 16:01:42 */ /* DBMS : SQLite */ /* ---------------------------------------------------- */ @@ -18,10 +18,10 @@ DROP TABLE IF EXISTS 'AssessmentSectionEntity' ; -DROP TABLE IF EXISTS 'FailureMechanismSectionEntity' +DROP TABLE IF EXISTS 'FailureMechanismEntity' ; -DROP TABLE IF EXISTS 'FailureMechanismEntity' +DROP TABLE IF EXISTS 'FailureMechanismSectionEntity' ; DROP TABLE IF EXISTS 'CalculationGroupEntity' @@ -39,12 +39,15 @@ DROP TABLE IF EXISTS 'GrassCoverErosionInwardsCalculationEntity' ; -DROP TABLE IF EXISTS 'SoilProfileEntity' +DROP TABLE IF EXISTS 'GrassCoverErosionOutwardsFailureMechanismMetaEntity' ; DROP TABLE IF EXISTS 'SoilLayerEntity' ; +DROP TABLE IF EXISTS 'SoilProfileEntity' +; + DROP TABLE IF EXISTS 'StochasticSoilProfileEntity' ; @@ -54,10 +57,10 @@ DROP TABLE IF EXISTS 'SurfaceLineEntity' ; -DROP TABLE IF EXISTS 'PipingCalculationOutputEntity' +DROP TABLE IF EXISTS 'CharacteristicPointEntity' ; -DROP TABLE IF EXISTS 'CharacteristicPointEntity' +DROP TABLE IF EXISTS 'PipingCalculationOutputEntity' ; DROP TABLE IF EXISTS 'ProbabilisticOutputEntity' @@ -171,16 +174,6 @@ ) ; -CREATE TABLE 'FailureMechanismSectionEntity' -( - 'FailureMechanismSectionEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismEntityId' INTEGER NOT NULL, - 'Name' VARCHAR (260) NOT NULL, - 'FailureMechanismSectionPointXml' TEXT NOT NULL, - CONSTRAINT 'FK_FailureMechanismSectionEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade -) -; - CREATE TABLE 'FailureMechanismEntity' ( 'FailureMechanismEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -195,6 +188,16 @@ ) ; +CREATE TABLE 'FailureMechanismSectionEntity' +( + 'FailureMechanismSectionEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'FailureMechanismEntityId' INTEGER NOT NULL, + 'Name' VARCHAR (260) NOT NULL, + 'FailureMechanismSectionPointXml' TEXT NOT NULL, + CONSTRAINT 'FK_FailureMechanismSectionEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade +) +; + CREATE TABLE 'CalculationGroupEntity' ( 'CalculationGroupEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -217,8 +220,8 @@ 'DesignWaterLevel' REAL, 'WaveHeight' REAL, 'Order' INT (4) NOT NULL, - 'DesignWaterLevelCalculationConvergence' TINYINT (1) NOT NULL, - 'WaveHeightCalculationConvergence' TINYINT (1) NOT NULL, + 'DesignWaterLevelCalculationConvergence' TINYINT (1) NOT NULL, -- NotCalculated, CalculatedNotConverged or CalculatedConverged + 'WaveHeightCalculationConvergence' TINYINT (1) NOT NULL, -- NotCalculated, CalculatedNotConverged or CalculatedConverged CONSTRAINT 'FK_HydraulicLocationEntity_AssessmentSectionEntity' FOREIGN KEY ('AssessmentSectionEntityId') REFERENCES 'AssessmentSectionEntity' ('AssessmentSectionEntityId') ON DELETE Cascade ON UPDATE Cascade ) ; @@ -287,11 +290,12 @@ ) ; -CREATE TABLE 'SoilProfileEntity' +CREATE TABLE 'GrassCoverErosionOutwardsFailureMechanismMetaEntity' ( - 'SoilProfileEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'Bottom' REAL, - 'Name' TEXT + 'GrassCoverErosionOutwardsFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'FailureMechanismEntityId' INTEGER, + 'N' TINYINT (1) NOT NULL, + CONSTRAINT 'FK_GrassCoverErosionOutwardsFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade ) ; @@ -315,6 +319,14 @@ ) ; +CREATE TABLE 'SoilProfileEntity' +( + 'SoilProfileEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'Bottom' REAL, + 'Name' TEXT +) +; + CREATE TABLE 'StochasticSoilProfileEntity' ( 'StochasticSoilProfileEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -352,18 +364,6 @@ ) ; -CREATE TABLE 'PipingCalculationOutputEntity' -( - 'PipingCalculationOutputEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'HeaveFactorOfSafety' REAL, - 'HeaveZValue' REAL, - 'UpliftFactorOfSafety' REAL, - 'UpliftZValue' REAL, - 'SellmeijerFactorOfSafety' REAL, - 'SellmeijerZValue' REAL -) -; - CREATE TABLE 'CharacteristicPointEntity' ( 'CharacteristicPointEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -376,6 +376,18 @@ ) ; +CREATE TABLE 'PipingCalculationOutputEntity' +( + 'PipingCalculationOutputEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'HeaveFactorOfSafety' REAL, + 'HeaveZValue' REAL, + 'UpliftFactorOfSafety' REAL, + 'UpliftZValue' REAL, + 'SellmeijerFactorOfSafety' REAL, + 'SellmeijerZValue' REAL +) +; + CREATE TABLE 'ProbabilisticOutputEntity' ( 'ProbabilisticOutputEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -638,10 +650,6 @@ ON 'AssessmentSectionEntity' ('ProjectEntityId' ASC) ; -CREATE INDEX 'IXFK_FailureMechanismSectionEntity_FailureMechanismEntity' - ON 'FailureMechanismSectionEntity' ('FailureMechanismEntityId' ASC) -; - CREATE INDEX 'IXFK_FailureMechanismEntity_AssessmentSectionEntity' ON 'FailureMechanismEntity' ('AssessmentSectionEntityId' ASC) ; @@ -650,6 +658,10 @@ ON 'FailureMechanismEntity' ('CalculationGroupEntityId' ASC) ; +CREATE INDEX 'IXFK_FailureMechanismSectionEntity_FailureMechanismEntity' + ON 'FailureMechanismSectionEntity' ('FailureMechanismEntityId' ASC) +; + CREATE INDEX 'IXFK_CalculationGroupEntity_CalculationGroupEntity' ON 'CalculationGroupEntity' ('ParentCalculationGroupEntityId' ASC) ; @@ -702,6 +714,10 @@ ON 'GrassCoverErosionInwardsCalculationEntity' ('HydraulicLocationEntityId' ASC) ; +CREATE INDEX 'IXFK_GrassCoverErosionOutwardsFailureMechanismMetaEntity_FailureMechanismEntity' + ON 'GrassCoverErosionOutwardsFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) +; + CREATE INDEX 'IXFK_StochasticSoilProfileEntity_SoilProfileEntity' ON 'StochasticSoilProfileEntity' ('SoilProfileEntityId' ASC) ;