Index: build/DatabaseStructure.sql =================================================================== diff -u -rf18e15506f15ac89e88f9c587c7efa02b9458470 -re7ab01284b029cda0f82d269a08b8bd6de70e3ae --- build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision f18e15506f15ac89e88f9c587c7efa02b9458470) +++ build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision e7ab01284b029cda0f82d269a08b8bd6de70e3ae) @@ -1,6 +1,6 @@ /* ---------------------------------------------------- */ /* Generated by Enterprise Architect Version 12.0 */ -/* Created On : 10-Sep-2018 10:04:29 */ +/* Created On : 11-feb-2019 13:26:20 */ /* DBMS : SQLite */ /* ---------------------------------------------------- */ @@ -300,6 +300,9 @@ DROP TABLE IF EXISTS 'DuneLocationCalculationEntity' ; +DROP TABLE IF EXISTS 'HydraulicBoundaryDatabaseEntity' +; + /* Create Tables with Primary and Foreign Keys, Check and Unique Constraints */ CREATE TABLE 'VersionEntity' @@ -364,8 +367,6 @@ 'LowerLimitNorm' REAL NOT NULL, 'SignalingNorm' REAL NOT NULL, 'NormativeNormType' TINYINT (1) NOT NULL, -- EnumType: 1 = LowerLimit, 2 = Signaling - 'HydraulicDatabaseVersion' TEXT, - 'HydraulicDatabaseLocation' TEXT, 'Composition' TINYINT (1) NOT NULL, -- Enum: 1 = Dike, 2 = Dune, 3 = DikeAndDune 'ReferenceLinePointXml' TEXT, 'Order' INT (4) NOT NULL, @@ -1144,6 +1145,7 @@ 'LowerBoundaryWaterLevels' REAL, 'StepSize' TINYINT (1) NOT NULL, -- Enum: 1 = 0.5, 2 = 1.0, 3 = 2.0 'CategoryType' TINYINT (1) NOT NULL, -- Enum: 1 = FactorizedSignalingNorm, 2 = SignalingNorm, 3 = LowerLimitNorm, 4 = FactorizedLowerLimitNorm + 'CalculationType' TINYINT (1) NOT NULL, CONSTRAINT 'FK_StabilityStoneCoverWaveConditionsCalculationEntity_CalculationGroupEntity' FOREIGN KEY ('CalculationGroupEntityId') REFERENCES 'CalculationGroupEntity' ('CalculationGroupEntityId') ON DELETE Cascade ON UPDATE Cascade, CONSTRAINT 'FK_StabilityStoneCoverWaveConditionsCalculationEntity_ForeshoreProfileEntity' FOREIGN KEY ('ForeshoreProfileEntityId') REFERENCES 'ForeshoreProfileEntity' ('ForeshoreProfileEntityId') ON DELETE Set Null ON UPDATE Cascade, CONSTRAINT 'FK_StabilityStoneCoverWaveConditionsCalculationEntity_HydraulicLocationEntity' FOREIGN KEY ('HydraulicLocationEntityId') REFERENCES 'HydraulicLocationEntity' ('HydraulicLocationEntityId') ON DELETE Set Null ON UPDATE Cascade @@ -2016,6 +2018,26 @@ ) ; +CREATE TABLE 'HydraulicBoundaryDatabaseEntity' +( + 'HydraulicBoundaryDatabaseEntity' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'AssessmentSectionEntityId' INTEGER NOT NULL, + 'Version' TEXT NOT NULL, + 'FilePath' TEXT NOT NULL, + 'HydraulicLocationConfigurationSettingsFilePath' TEXT NOT NULL, + 'HydraulicLocationConfigurationSettingsScenarioName' TEXT NOT NULL, + 'HydraulicLocationConfigurationSettingsYear' INT (4) NOT NULL, + 'HydraulicLocationConfigurationSettingsScope' TEXT NOT NULL, + 'HydraulicLocationConfigurationSettingsSeaLevel' TEXT, + 'HydraulicLocationConfigurationSettingsRiverDischarge' TEXT, + 'HydraulicLocationConfigurationSettingsLakeLevel' TEXT, + 'HydraulicLocationConfigurationSettingsWindDirection' TEXT, + 'HydraulicLocationConfigurationSettingsWindSpeed' TEXT, + 'HydraulicLocationConfigurationSettingsComment' TEXT, + CONSTRAINT 'FK_HydraulicBoundaryDatabaseEntity_AssessmentSectionEntity' FOREIGN KEY ('AssessmentSectionEntityId') REFERENCES 'AssessmentSectionEntity' ('AssessmentSectionEntityId') ON DELETE Cascade ON UPDATE Cascade +) +; + /* Create Indexes and Triggers */ CREATE INDEX 'IXFK_GrassCoverErosionInwardsDikeHeightOutputEntity_GeneralResultFaultTreeIllustrationPointEntity' @@ -2823,3 +2845,7 @@ CREATE INDEX 'IXFK_DuneLocationCalculationEntity_DuneLocationEntity' ON 'DuneLocationCalculationEntity' ('DuneLocationEntityId' ASC) ; + +CREATE INDEX 'IXFK_HydraulicBoundaryDatabaseEntity_AssessmentSectionEntity' + ON 'HydraulicBoundaryDatabaseEntity' ('AssessmentSectionEntityId' ASC) +;