Index: Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql =================================================================== diff -u -r290ba0afb9b78a0823f1fa7b4fa01c1011952df8 -r8b5a6f938fe2b04cd78623649df37580e145055f --- Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 290ba0afb9b78a0823f1fa7b4fa01c1011952df8) +++ Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 8b5a6f938fe2b04cd78623649df37580e145055f) @@ -1,6 +1,6 @@ /* ---------------------------------------------------- */ -/* Generated by Enterprise Architect Version 12.0 */ -/* Created On : 25-Mar-2016 4:01:03 PM */ +/* Generated by Enterprise Architect Version 12.1 */ +/* Created On : 31-mrt-2016 13:21:34 */ /* DBMS : SQLite */ /* ---------------------------------------------------- */ @@ -12,7 +12,7 @@ DROP TABLE IF EXISTS 'ProjectEntity' ; -DROP TABLE IF EXISTS 'DikeAssessmentSectionEntity' +DROP TABLE IF EXISTS 'AssessmentSectionEntity' ; DROP TABLE IF EXISTS 'FailureMechanismEntity' @@ -42,9 +42,9 @@ ) ; -CREATE TABLE 'DikeAssessmentSectionEntity' +CREATE TABLE 'AssessmentSectionEntity' ( - 'DikeAssessmentSectionEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'AssessmentSectionEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'ProjectEntityId' INTEGER NOT NULL, 'Name' VARCHAR (260) NOT NULL, 'Norm' INT (4) NOT NULL, @@ -58,51 +58,51 @@ CREATE TABLE 'FailureMechanismEntity' ( 'FailureMechanismEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'DikeAssessmentSectionEntityId' INTEGER NOT NULL, + 'AssessmentSectionEntityId' INTEGER NOT NULL, 'FailureMechanismType' SMALLINT NOT NULL, -- Enumerator for different failure mechanism types (piping, macrostability, dunes, etc) - CONSTRAINT 'FK_FailureMechanismEntity_AssessmentSectionEntity' FOREIGN KEY ('DikeAssessmentSectionEntityId') REFERENCES 'DikeAssessmentSectionEntity' ('DikeAssessmentSectionEntityId') ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT 'UI_AS_FMT' UNIQUE ('FailureMechanismType','DikeAssessmentSectionEntityId') + CONSTRAINT 'FK_FailureMechanismEntity_AssessmentSectionEntity' FOREIGN KEY ('AssessmentSectionEntityId') REFERENCES 'AssessmentSectionEntity' ('AssessmentSectionEntityId') ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT 'UI_AS_FMT' UNIQUE ('FailureMechanismType','AssessmentSectionEntityId') ) ; CREATE TABLE 'HydraulicLocationEntity' ( 'HydraulicLocationEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'DikeAssessmentSectionEntityId' INTEGER NOT NULL, + 'AssessmentSectionEntityId' INTEGER NOT NULL, 'LocationId' INTEGER NOT NULL, 'Name' VARCHAR (260) NOT NULL, 'LocationX' NUMERIC NOT NULL, 'LocationY' NUMERIC NOT NULL, 'DesignWaterLevel' REAL, - CONSTRAINT 'FK_HydraulicLocationEntity_DikeAssessmentSectionEntity' FOREIGN KEY ('DikeAssessmentSectionEntityId') REFERENCES 'DikeAssessmentSectionEntity' ('DikeAssessmentSectionEntityId') ON DELETE Cascade ON UPDATE Cascade + CONSTRAINT 'FK_HydraulicLocationEntity_AssessmentSectionEntity' FOREIGN KEY ('AssessmentSectionEntityId') REFERENCES 'AssessmentSectionEntity' ('AssessmentSectionEntityId') ON DELETE Cascade ON UPDATE Cascade ) ; CREATE TABLE 'ReferenceLinePointEntity' ( 'ReferenceLinePointEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'DikeAssessmentSectionEntityId' INTEGER NOT NULL, + 'AssessmentSectionEntityId' INTEGER NOT NULL, 'X' NUMERIC NOT NULL, 'Y' NUMERIC NOT NULL, 'Order' INT (4) NOT NULL, - CONSTRAINT 'FK_ReferenceLinePointEntity_DikeAssessmentSectionEntity' FOREIGN KEY ('DikeAssessmentSectionEntityId') REFERENCES 'DikeAssessmentSectionEntity' ('DikeAssessmentSectionEntityId') ON DELETE Cascade ON UPDATE Cascade + CONSTRAINT 'FK_ReferenceLinePointEntity_AssessmentSectionEntity' FOREIGN KEY ('AssessmentSectionEntityId') REFERENCES 'AssessmentSectionEntity' ('AssessmentSectionEntityId') ON DELETE Cascade ON UPDATE Cascade ) ; /* Create Indexes and Triggers */ CREATE INDEX 'IXFK_AssessmentSection_ProjectEntity' - ON 'DikeAssessmentSectionEntity' ('ProjectEntityId' ASC) + ON 'AssessmentSectionEntity' ('ProjectEntityId' ASC) ; CREATE INDEX 'IXFK_FailureMechanismEntity_AssessmentSectionEntity' - ON 'FailureMechanismEntity' ('DikeAssessmentSectionEntityId' ASC) + ON 'FailureMechanismEntity' ('AssessmentSectionEntityId' ASC) ; -CREATE INDEX 'IXFK_HydraulicLocationEntity_DikeAssessmentSectionEntity' - ON 'HydraulicLocationEntity' ('DikeAssessmentSectionEntityId' ASC) +CREATE INDEX 'IXFK_HydraulicLocationEntity_AssessmentSectionEntity' + ON 'HydraulicLocationEntity' ('AssessmentSectionEntityId' ASC) ; -CREATE INDEX 'IXFK_ReferenceLinePointEntity_DikeAssessmentSectionEntity' - ON 'ReferenceLinePointEntity' ('DikeAssessmentSectionEntityId' ASC) +CREATE INDEX 'IXFK_ReferenceLinePointEntity_AssessmentSectionEntity' + ON 'ReferenceLinePointEntity' ('AssessmentSectionEntityId' ASC) ;