Index: Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql =================================================================== diff -u -r3b154768800db81f1cf35b68248bcc53f417c90a -r5b4d76a9812fa9c9f06529c05fe47d6aafdb479c --- Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 3b154768800db81f1cf35b68248bcc53f417c90a) +++ Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 5b4d76a9812fa9c9f06529c05fe47d6aafdb479c) @@ -1,6 +1,6 @@ /* ---------------------------------------------------- */ /* Generated by Enterprise Architect Version 12.0 */ -/* Created On : 25-Oct-2016 8:28:00 AM */ +/* Created On : 25-okt-2016 9:42:54 */ /* DBMS : SQLite */ /* ---------------------------------------------------- */ @@ -165,6 +165,9 @@ DROP TABLE IF EXISTS 'HeightStructuresCalculationEntity' ; +DROP TABLE IF EXISTS 'ClosingStructureEntity' +; + /* Create Tables with Primary and Foreign Keys, Check and Unique Constraints */ CREATE TABLE 'VersionEntity' @@ -914,6 +917,43 @@ ) ; +CREATE TABLE 'ClosingStructureEntity' +( + 'ClosingStructureEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'FailureMechanismEntityId' INTEGER NOT NULL, + 'Order' INT (4) NOT NULL, + 'Name' VARCHAR (260), + 'Id' VARCHAR (260), + 'X' REAL, + 'Y' REAL, + 'StructureNormalOrientation' REAL, + 'StorageStructureAreaMean' REAL, + 'StorageStructureAreaCoefficientOfVariation' REAL, + 'AllowedLevelIncreaseStorageMean' REAL, + 'AllowedLevelIncreaseStorageStandardDeviation' REAL, + 'WidthFlowAperturesMean' REAL, + 'WidthFlowAperturesCoefficientOfVariation' REAL, + 'LevelCrestStructureNotClosingMean' REAL, + 'LevelCrestStructureNotClosingStandardDeviation' REAL, + 'InsideWaterLevelMean' REAL, + 'InsideWaterLevelStandardDeviation' REAL, + 'ThresholdHeightOpenWeirMean' REAL, + 'ThresholdHeightOpenWeirStandardDeviation' REAL, + 'AreaFlowAperturesMean' REAL, + 'AreaFlowAperturesStandardDeviation' REAL, + 'CriticalOvertoppingDischargeMean' REAL, + 'CriticalOvertoppingDischargeCoefficientOfVariation' REAL, + 'FlowWidthAtBottomProtectionMean' REAL, + 'FlowWidthAtBottomProtectionStandardDeviation' REAL, + 'ProbabilityOpenStructureBeforeFlooding' REAL, + 'FailureProbabilityOpenStructure' REAL, + 'IdenticalApertures' REAL, + 'FailureProbabilityReparation' REAL, + 'InflowModelType' TINYINT (1), + CONSTRAINT 'FK_ClosingStructureEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade +) +; + /* Create Indexes and Triggers */ CREATE INDEX 'IXFK_PipingFailureMechanismMetaEntity_FailureMechanismEntity' @@ -1179,3 +1219,7 @@ CREATE INDEX 'IXFK_HeightStructuresCalculationEntity_HydraulicLocationEntity' ON 'HeightStructuresCalculationEntity' ('HydraulicLocationEntityId' ASC) ; + +CREATE INDEX 'IXFK_ClosingStructureEntity_FailureMechanismEntity' + ON 'ClosingStructureEntity' ('FailureMechanismEntityId' ASC) +;