Index: Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql =================================================================== diff -u -r23766b602d9b509a2ffc030f284e8d5e82325a3e -r508d720230c5f63bce7f95bddc3b7a04808d267d --- Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 23766b602d9b509a2ffc030f284e8d5e82325a3e) +++ Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 508d720230c5f63bce7f95bddc3b7a04808d267d) @@ -1,6 +1,6 @@ /* ---------------------------------------------------- */ /* Generated by Enterprise Architect Version 12.0 */ -/* Created On : 28-jul-2016 16:23:20 */ +/* Created On : 01-aug-2016 14:44:48 */ /* DBMS : SQLite */ /* ---------------------------------------------------- */ @@ -24,9 +24,6 @@ DROP TABLE IF EXISTS 'FailureMechanismEntity' ; -DROP TABLE IF EXISTS 'FailureMechanismSectionPointEntity' -; - DROP TABLE IF EXISTS 'CalculationGroupEntity' ; @@ -42,15 +39,12 @@ DROP TABLE IF EXISTS 'GrassCoverErosionInwardsCalculationEntity' ; -DROP TABLE IF EXISTS 'ReferenceLinePointEntity' +DROP TABLE IF EXISTS 'SoilProfileEntity' ; DROP TABLE IF EXISTS 'SoilLayerEntity' ; -DROP TABLE IF EXISTS 'SoilProfileEntity' -; - DROP TABLE IF EXISTS 'StochasticSoilProfileEntity' ; @@ -60,9 +54,6 @@ DROP TABLE IF EXISTS 'SurfaceLineEntity' ; -DROP TABLE IF EXISTS 'SurfaceLinePointEntity' -; - DROP TABLE IF EXISTS 'PipingCalculationOutputEntity' ; @@ -173,6 +164,7 @@ 'HydraulicDatabaseVersion' TEXT, 'HydraulicDatabaseLocation' TEXT, 'Composition' SMALLINT NOT NULL, -- Enum: Dike = 0, Dune = 1, DikeAndDune = 2 + 'ReferenceLinePointData' BLOB, CONSTRAINT 'FK_AssessmentSectionEntity_ProjectEntity' FOREIGN KEY ('ProjectEntityId') REFERENCES 'ProjectEntity' ('ProjectEntityId') ON DELETE Cascade ON UPDATE Cascade ) ; @@ -182,6 +174,7 @@ 'FailureMechanismSectionEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismEntityId' INTEGER NOT NULL, 'Name' VARCHAR (260) NOT NULL, + 'FailureMechanismSectionPointData' BLOB NOT NULL, CONSTRAINT 'FK_FailureMechanismSectionEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade ) ; @@ -200,17 +193,6 @@ ) ; -CREATE TABLE 'FailureMechanismSectionPointEntity' -( - 'FailureMechanismSectionPointEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismSectionEntityId' INTEGER NOT NULL, - 'X' REAL, - 'Y' REAL, - 'Order' INT (4) NOT NULL, - CONSTRAINT 'FK_FailureMechanismSectionPointEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade -) -; - CREATE TABLE 'CalculationGroupEntity' ( 'CalculationGroupEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -306,14 +288,11 @@ ) ; -CREATE TABLE 'ReferenceLinePointEntity' +CREATE TABLE 'SoilProfileEntity' ( - 'ReferenceLinePointEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'AssessmentSectionEntityId' INTEGER NOT NULL, - 'X' REAL, - 'Y' REAL, - 'Order' INT (4) NOT NULL, - CONSTRAINT 'FK_ReferenceLinePointEntity_AssessmentSectionEntity' FOREIGN KEY ('AssessmentSectionEntityId') REFERENCES 'AssessmentSectionEntity' ('AssessmentSectionEntityId') ON DELETE Cascade ON UPDATE Cascade + 'SoilProfileEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'Bottom' REAL, + 'Name' TEXT ) ; @@ -336,14 +315,6 @@ ) ; -CREATE TABLE 'SoilProfileEntity' -( - 'SoilProfileEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'Bottom' REAL, - 'Name' TEXT -) -; - CREATE TABLE 'StochasticSoilProfileEntity' ( 'StochasticSoilProfileEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -361,7 +332,7 @@ 'FailureMechanismEntityId' INTEGER NOT NULL, 'Name' TEXT, 'SegmentName' TEXT, - 'SegmentPoints' BLOB NOT NULL, + 'StochasticSoilModelSegmentPointData' BLOB NOT NULL, CONSTRAINT 'FK_StochasticSoilModelEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade ) ; @@ -373,22 +344,11 @@ 'Name' VARCHAR (260), 'ReferenceLineIntersectionX' REAL, 'ReferenceLineIntersectionY' REAL, + 'PointsData' BLOB NOT NULL, CONSTRAINT 'FK_SurfaceLineEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE No Action ON UPDATE No Action ) ; -CREATE TABLE 'SurfaceLinePointEntity' -( - 'SurfaceLinePointEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'SurfaceLineEntityId' INTEGER NOT NULL, - 'X' REAL, - 'Y' REAL, - 'Order' INT (4) NOT NULL, - 'Z' REAL, - CONSTRAINT 'FK_SurfaceLinePointEntity_SurfaceLineEntity' FOREIGN KEY ('SurfaceLineEntityId') REFERENCES 'SurfaceLineEntity' ('SurfaceLineEntityId') ON DELETE No Action ON UPDATE No Action -) -; - CREATE TABLE 'PipingCalculationOutputEntity' ( 'PipingCalculationOutputEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -404,9 +364,12 @@ CREATE TABLE 'CharacteristicPointEntity' ( 'CharacteristicPointEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'CharacteristicPointType' SMALLINT NOT NULL, -- Enum: 1 = DikeToeAtRiver 2 = DikeToeAtPolder 3 = DitchDikeSide 4 = BottomDitchDikeSide 5 = BottomDitchPolderSide 6 = DitchPolderSide - 'SurfaceLinePointEntityId' INTEGER NOT NULL, - CONSTRAINT 'FK_CharacteristicPointEntity_SurfaceLinePointEntity' FOREIGN KEY ('SurfaceLinePointEntityId') REFERENCES 'SurfaceLinePointEntity' ('SurfaceLinePointEntityId') ON DELETE No Action ON UPDATE No Action + 'SurfaceLineEntityId' INTEGER NOT NULL, + 'Type' SMALLINT NOT NULL, -- Enum: 1 = DikeToeAtRiver 2 = DikeToeAtPolder 3 = DitchDikeSide 4 = BottomDitchDikeSide 5 = BottomDitchPolderSide 6 = DitchPolderSide + 'X' REAL, + 'Y' REAL, + 'Z' REAL, + CONSTRAINT 'FK_SurfaceLinePointEntity_SurfaceLineEntity' FOREIGN KEY ('SurfaceLineEntityId') REFERENCES 'SurfaceLineEntity' ('SurfaceLineEntityId') ON DELETE No Action ON UPDATE No Action ) ; @@ -684,10 +647,6 @@ ON 'FailureMechanismEntity' ('CalculationGroupEntityId' ASC) ; -CREATE INDEX 'IXFK_FailureMechanismSectionPointEntity_FailureMechanismSectionEntity' - ON 'FailureMechanismSectionPointEntity' ('FailureMechanismSectionEntityId' ASC) -; - CREATE INDEX 'IXFK_CalculationGroupEntity_CalculationGroupEntity' ON 'CalculationGroupEntity' ('ParentCalculationGroupEntityId' ASC) ; @@ -740,10 +699,6 @@ ON 'GrassCoverErosionInwardsCalculationEntity' ('HydraulicLocationEntityId' ASC) ; -CREATE INDEX 'IXFK_ReferenceLinePointEntity_AssessmentSectionEntity' - ON 'ReferenceLinePointEntity' ('AssessmentSectionEntityId' ASC) -; - CREATE INDEX 'IXFK_StochasticSoilProfileEntity_SoilProfileEntity' ON 'StochasticSoilProfileEntity' ('SoilProfileEntityId' ASC) ; @@ -761,13 +716,9 @@ ; CREATE INDEX 'IXFK_SurfaceLinePointEntity_SurfaceLineEntity' - ON 'SurfaceLinePointEntity' ('SurfaceLineEntityId' ASC) + ON 'CharacteristicPointEntity' ('SurfaceLineEntityId' ASC) ; -CREATE INDEX 'IXFK_CharacteristicPointEntity_SurfaceLinePointEntity' - ON 'CharacteristicPointEntity' ('SurfaceLinePointEntityId' ASC) -; - CREATE INDEX 'IXFK_PipingSectionResultEntity_FailureMechanismSectionEntity' ON 'PipingSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) ;