Index: Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql =================================================================== diff -u -re570ba372fafe1802a4caae2ef9410b64457198b -r3b154768800db81f1cf35b68248bcc53f417c90a --- Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision e570ba372fafe1802a4caae2ef9410b64457198b) +++ Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 3b154768800db81f1cf35b68248bcc53f417c90a) @@ -1,6 +1,6 @@ /* ---------------------------------------------------- */ /* Generated by Enterprise Architect Version 12.0 */ -/* Created On : 21-okt-2016 14:43:18 */ +/* Created On : 25-Oct-2016 8:28:00 AM */ /* DBMS : SQLite */ /* ---------------------------------------------------- */ @@ -162,6 +162,9 @@ DROP TABLE IF EXISTS 'HeightStructureEntity' ; +DROP TABLE IF EXISTS 'HeightStructuresCalculationEntity' +; + /* Create Tables with Primary and Foreign Keys, Check and Unique Constraints */ CREATE TABLE 'VersionEntity' @@ -875,6 +878,42 @@ ) ; +CREATE TABLE 'HeightStructuresCalculationEntity' +( + 'HeightStructuresCalculationEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'CalculationGroupEntityId' INTEGER NOT NULL, + 'HydraulicLocationEntityId' INTEGER, + 'HeightStructureEntityId' INTEGER, + 'ForeshoreProfileEntityId' INTEGER, + 'HydraulicBoundaryLocationEntityId' INTEGER, + 'Order' INT (4) NOT NULL, + 'Name' VARCHAR (260), + 'Comments' TEXT, + 'ModelFactorSuperCriticalFlowMean' REAL, + 'VariationCoefficientLogNormalDistributionMean' REAL, + 'StructureNormalOrientation' REAL, + 'AllowedLevelIncreaseStorageMean' REAL, + 'AllowedLevelIncreaseStorageStandardDeviation' REAL, + 'StorageStructureAreaMean' REAL, + 'StorageStructureAreaCoefficientOfVariation' REAL, + 'FlowWidthAtBottomProtectionMean' REAL, + 'FlowWidthAtBottomProtectionCoefficientOfVariation' REAL, + 'CriticalOvertoppingDischargeMean' REAL, + 'CriticalOvertoppingDischargeCoefficientOfVariation' REAL, + 'FailureProbabilityStructureWithErosion' REAL, + 'WidthFlowAperturesMean' REAL, + 'WidthFlowAperturesCoefficientOfVariation' REAL, + 'UseBreakWater' TINYINT (1) NOT NULL, + 'UseForeshore' TINYINT (1) NOT NULL, + 'BreakWaterType' SMALLINT NOT NULL, -- Enum: 1 = Wall 2 = Caisson 3 = Dam + 'BreakWaterHeight' REAL, + CONSTRAINT 'FK_HeightStructuresCalculationEntity_CalculationGroupEntity' FOREIGN KEY ('CalculationGroupEntityId') REFERENCES 'CalculationGroupEntity' ('CalculationGroupEntityId') ON DELETE No Action ON UPDATE No Action, + CONSTRAINT 'FK_HeightStructuresCalculationEntity_ForeshoreProfileEntity' FOREIGN KEY ('ForeshoreProfileEntityId') REFERENCES 'ForeshoreProfileEntity' ('ForeshoreProfileEntityId') ON DELETE Set Null ON UPDATE Set Null, + CONSTRAINT 'FK_HeightStructuresCalculationEntity_HeightStructureEntity' FOREIGN KEY ('HeightStructureEntityId') REFERENCES 'HeightStructureEntity' ('HeightStructureEntityId') ON DELETE No Action ON UPDATE No Action, + CONSTRAINT 'FK_HeightStructuresCalculationEntity_HydraulicLocationEntity' FOREIGN KEY ('HydraulicLocationEntityId') REFERENCES 'HydraulicLocationEntity' ('HydraulicLocationEntityId') ON DELETE No Action ON UPDATE No Action +) +; + /* Create Indexes and Triggers */ CREATE INDEX 'IXFK_PipingFailureMechanismMetaEntity_FailureMechanismEntity' @@ -1124,3 +1163,19 @@ CREATE INDEX 'IXFK_HeightStructure_FailureMechanismEntity' ON 'HeightStructureEntity' ('FailureMechanismEntityId' ASC) ; + +CREATE INDEX 'IXFK_HeightStructuresCalculationEntity_CalculationGroupEntity' + ON 'HeightStructuresCalculationEntity' ('CalculationGroupEntityId' ASC) +; + +CREATE INDEX 'IXFK_HeightStructuresCalculationEntity_ForeshoreProfileEntity' + ON 'HeightStructuresCalculationEntity' ('ForeshoreProfileEntityId' ASC) +; + +CREATE INDEX 'IXFK_HeightStructuresCalculationEntity_HeightStructureEntity' + ON 'HeightStructuresCalculationEntity' ('HeightStructureEntityId' ASC) +; + +CREATE INDEX 'IXFK_HeightStructuresCalculationEntity_HydraulicLocationEntity' + ON 'HeightStructuresCalculationEntity' ('HydraulicLocationEntityId' ASC) +;