Index: build/DatabaseStructure.sql =================================================================== diff -u -rec2b6db721e7e9ae0bf421d53556834253cb24c0 -r3576f3f9944cfc1d88ad72cda03de8a2fe271214 --- build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision ec2b6db721e7e9ae0bf421d53556834253cb24c0) +++ build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 3576f3f9944cfc1d88ad72cda03de8a2fe271214) @@ -1,6 +1,6 @@ /* ---------------------------------------------------- */ /* Generated by Enterprise Architect Version 12.0 */ -/* Created On : 30-May-2018 10:34:37 */ +/* Created On : 31-May-2018 13:40:52 */ /* DBMS : SQLite */ /* ---------------------------------------------------- */ @@ -207,7 +207,7 @@ DROP TABLE IF EXISTS 'DuneLocationEntity' ; -DROP TABLE IF EXISTS 'DuneLocationOutputEntity' +DROP TABLE IF EXISTS 'DuneLocationCalculationOutputEntity' ; DROP TABLE IF EXISTS 'BackgroundDataEntity' @@ -1548,9 +1548,9 @@ ) ; -CREATE TABLE 'DuneLocationOutputEntity' +CREATE TABLE 'DuneLocationCalculationOutputEntity' ( - 'DuneLocationOutputEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'DuneLocationCalculationOutputEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'DuneLocationCalculationEntityId' INTEGER NOT NULL, 'WaterLevel' REAL, 'WaveHeight' REAL, @@ -1560,7 +1560,7 @@ 'CalculatedProbability' REAL, 'CalculatedReliability' REAL, 'CalculationConvergence' TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated, 2 = CalculatedNotConverged, 3 = CalculatedConverged - CONSTRAINT 'FK_DuneLocationOutputEntity_DuneLocationCalculationEntity' FOREIGN KEY ('DuneLocationCalculationEntityId') REFERENCES 'DuneLocationCalculationEntity' ('DuneLocationCalculationEntityId') ON DELETE Cascade ON UPDATE Cascade + CONSTRAINT 'FK_DuneLocationCalculationOutputEntity_DuneLocationCalculationEntity' FOREIGN KEY ('DuneLocationCalculationEntityId') REFERENCES 'DuneLocationCalculationEntity' ('DuneLocationCalculationEntityId') ON DELETE Cascade ON UPDATE Cascade ) ; @@ -2589,8 +2589,8 @@ ON 'DuneLocationEntity' ('FailureMechanismEntityId' ASC) ; -CREATE INDEX 'IXFK_DuneLocationOutputEntity_DuneLocationCalculationEntity' - ON 'DuneLocationOutputEntity' ('DuneLocationCalculationEntityId' ASC) +CREATE INDEX 'IXFK_DuneLocationCalculationOutputEntity_DuneLocationCalculationEntity' + ON 'DuneLocationCalculationOutputEntity' ('DuneLocationCalculationEntityId' ASC) ; CREATE INDEX 'IXFK_BackgroundDataEntity_AssessmentSectionEntity'