Index: build/DatabaseStructure.sql =================================================================== diff -u -ra465305f884f6437ac8cb86f922e23b96ade4724 -rfe88135b797eda12b8e4d9b829036d2d7a52b10f --- build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision a465305f884f6437ac8cb86f922e23b96ade4724) +++ build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision fe88135b797eda12b8e4d9b829036d2d7a52b10f) @@ -1,6 +1,6 @@ /* ---------------------------------------------------- */ /* Generated by Enterprise Architect Version 12.0 */ -/* Created On : 23-Mar-2017 14:01:06 */ +/* Created On : 10-Apr-2017 13:58:22 */ /* DBMS : SQLite */ /* ---------------------------------------------------- */ @@ -210,6 +210,9 @@ DROP TABLE IF EXISTS 'BackgroundDataMetaEntity' ; +DROP TABLE IF EXISTS 'GrassCoverErosionInwardsOvertoppingRateOutputEntity' +; + /* Create Tables with Primary and Foreign Keys, Check and Unique Constraints */ CREATE TABLE 'VersionEntity' @@ -483,6 +486,7 @@ 'UseBreakWater' TINYINT (1) NOT NULL, -- true or false 'BreakWaterType' TINYINT (1) NOT NULL, -- Enum: 1 = Wall, 2 = Caisson, 3 = Dam 'BreakWaterHeight' REAL, + 'OvertoppingRateCalculationType' TINYINT (1) NOT NULL, -- Enum: 1 = NoCalculation, 2 = CalculateByAssessmentSectionNorm, 3 = CalculateByProfileSpecificRequiredProbability CONSTRAINT 'FK_GrassCoverErosionInwardsCalculationEntity_CalculationGroupEntity' FOREIGN KEY ('CalculationGroupEntityId') REFERENCES 'CalculationGroupEntity' ('CalculationGroupEntityId') ON DELETE Cascade ON UPDATE Cascade, CONSTRAINT 'FK_GrassCoverErosionInwardsCalculationEntity_DikeProfileEntity' FOREIGN KEY ('DikeProfileEntityId') REFERENCES 'DikeProfileEntity' ('DikeProfileEntityId') ON DELETE Set Null ON UPDATE Cascade, CONSTRAINT 'FK_GrassCoverErosionInwardsCalculationEntity_HydraulicLocationEntity' FOREIGN KEY ('HydraulicLocationEntityId') REFERENCES 'HydraulicLocationEntity' ('HydraulicLocationEntityId') ON DELETE Set Null ON UPDATE Cascade @@ -1363,6 +1367,21 @@ ) ; +CREATE TABLE 'GrassCoverErosionInwardsOvertoppingRateOutputEntity' +( + 'GrassCoverErosionInwardsOvertoppingRateOutputEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'GrassCoverErosionInwardsOutputEntityId' INTEGER NOT NULL, + 'OvertoppingRate' REAL, + 'TargetProbability' REAL, + 'TargetReliability' REAL, + 'CalculatedProbability' REAL, + 'CalculatedReliability' REAL, + 'CalculationConvergence' TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated, 2 = CalculationNotConverged, 3 = CalculationConverged + CONSTRAINT 'FK_GrassCoverErosionInwardsOvertoppingRateOutputEntity_GrassCoverErosionInwardsOutputEntity' FOREIGN KEY ('GrassCoverErosionInwardsOutputEntityId') REFERENCES 'GrassCoverErosionInwardsOutputEntity' ('GrassCoverErosionInwardsOutputEntityId') ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT 'U_GrassCoverErosionInwardsOutputEntity' UNIQUE ('GrassCoverErosionInwardsOutputEntityId') +) +; + /* Create Indexes and Triggers */ CREATE INDEX 'IXFK_GrassCoverErosionInwardsDikeHeightOutputEntity_GrassCoverErosionInwardsOutputEntity' @@ -1724,3 +1743,7 @@ CREATE INDEX 'IXFK_BackgroundDataMetaEntity_BackgroundDataEntity' ON 'BackgroundDataMetaEntity' ('BackgroundDataEntityId' ASC) ; + +CREATE INDEX 'IXFK_GrassCoverErosionInwardsOvertoppingRateOutputEntity_GrassCoverErosionInwardsOutputEntity' + ON 'GrassCoverErosionInwardsOvertoppingRateOutputEntity' ('GrassCoverErosionInwardsOutputEntityId' ASC) +;