Index: Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql =================================================================== diff -u -rcc3d0b350842ff7a7fd54f746525e1cc4e800a2e -rd8e9a837dff0271be1994d93fabeed19ac996f85 --- Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision cc3d0b350842ff7a7fd54f746525e1cc4e800a2e) +++ Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision d8e9a837dff0271be1994d93fabeed19ac996f85) @@ -1,6 +1,6 @@ /* ---------------------------------------------------- */ /* Generated by Enterprise Architect Version 12.0 */ -/* Created On : 01-Nov-2016 12:53:48 PM */ +/* Created On : 17-nov-2016 11:31:00 */ /* DBMS : SQLite */ /* ---------------------------------------------------- */ @@ -569,7 +569,7 @@ ( 'PipingSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismSectionEntityId' INTEGER NOT NULL, - 'LayerOne' TINYINT (1) NOT NULL, -- true or false + 'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed 2 = Sufficient 3 = NeedsDetailedAssessment 'LayerThree' REAL, CONSTRAINT 'FK_PipingSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade ) @@ -580,7 +580,7 @@ 'GrassCoverErosionInwardsSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismSectionEntityId' INTEGER NOT NULL, 'GrassCoverErosionInwardsCalculationEntityId' INTEGER, - 'LayerOne' TINYINT (1) NOT NULL, -- true or false + 'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed 2 = Sufficient 3 = NeedsDetailedAssessment 'LayerThree' REAL, CONSTRAINT 'FK_GrassCoverErosionInwardsSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade, CONSTRAINT 'FK_GrassCoverErosionInwardsSectionResultEntity_GrassCoverErosionInwardsCalculationEntity' FOREIGN KEY ('GrassCoverErosionInwardsCalculationEntityId') REFERENCES 'GrassCoverErosionInwardsCalculationEntity' ('GrassCoverErosionInwardsCalculationEntityId') ON DELETE Set Null ON UPDATE Cascade @@ -592,7 +592,7 @@ 'HeightStructuresSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismSectionEntityId' INTEGER NOT NULL, 'HeightStructuresCalculationEntityId' INTEGER, - 'LayerOne' TINYINT (1) NOT NULL, -- true or false + 'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed 2 = Sufficient 3 = NeedsDetailedAssessment 'LayerThree' REAL, CONSTRAINT 'FK_HeightStructuresSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade, CONSTRAINT 'FK_HeightStructuresSectionResultEntity_HeightStructuresCalculationEntity' FOREIGN KEY ('HeightStructuresCalculationEntityId') REFERENCES 'HeightStructuresCalculationEntity' ('HeightStructuresCalculationEntityId') ON DELETE Set Null ON UPDATE Cascade @@ -603,7 +603,7 @@ ( 'StrengthStabilityLengthwiseConstructionSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismSectionEntityId' INTEGER NOT NULL, - 'LayerOne' TINYINT (1) NOT NULL, -- true or false + 'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed 2 = Sufficient 3 = NeedsDetailedAssessment 'LayerThree' REAL, CONSTRAINT 'FK_StrengthStabilityLengthwiseConstructionSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade ) @@ -613,7 +613,7 @@ ( 'TechnicalInnovationSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismSectionEntityId' INTEGER NOT NULL, - 'LayerOne' TINYINT (1) NOT NULL, -- true or false + 'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed 2 = Sufficient 3 = NeedsDetailedAssessment 'LayerThree' REAL, CONSTRAINT 'FK_TechnicalInnovationSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade ) @@ -623,7 +623,7 @@ ( 'WaterPressureAsphaltCoverSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismSectionEntityId' INTEGER NOT NULL, - 'LayerOne' TINYINT (1) NOT NULL, -- true or false + 'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed 2 = Sufficient 3 = NeedsDetailedAssessment 'LayerThree' REAL, CONSTRAINT 'FK_WaterPressureAsphaltCoverSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade ) @@ -634,7 +634,7 @@ 'ClosingStructuresSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismSectionEntityId' INTEGER NOT NULL, 'ClosingStructuresCalculationEntityId' INTEGER, - 'LayerOne' TINYINT (1) NOT NULL, -- true or false + 'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed 2 = Sufficient 3 = NeedsDetailedAssessment 'LayerThree' REAL, CONSTRAINT 'FK_ClosingStructuresSectionResultEntity_ClosingStructuresCalculationEntity' FOREIGN KEY ('ClosingStructuresCalculationEntityId') REFERENCES 'ClosingStructuresCalculationEntity' ('ClosingStructuresCalculationEntityId') ON DELETE Set Null ON UPDATE Cascade, CONSTRAINT 'FK_ClosingStructuresSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade @@ -645,7 +645,7 @@ ( 'GrassCoverErosionOutwardsSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismSectionEntityId' INTEGER NOT NULL, - 'LayerOne' TINYINT (1) NOT NULL, -- true or false + 'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed 2 = Sufficient 3 = NeedsDetailedAssessment 'LayerTwoA' TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated 2 = Failed 3 = Successful 'LayerThree' REAL, CONSTRAINT 'FK_GrassCoverErosionOutwardsSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade @@ -656,7 +656,7 @@ ( 'GrassCoverSlipOffInwardsSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismSectionEntityId' INTEGER NOT NULL, - 'LayerOne' TINYINT (1) NOT NULL, -- true or false + 'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed 2 = Sufficient 3 = NeedsDetailedAssessment 'LayerTwoA' TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated 2 = Failed 3 = Successful 'LayerThree' REAL, CONSTRAINT 'FK_GrassCoverSlipOffInwardsSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade @@ -667,7 +667,7 @@ ( 'GrassCoverSlipOffOutwardsSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismSectionEntityId' INTEGER NOT NULL, - 'LayerOne' TINYINT (1) NOT NULL, -- true or false + 'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed 2 = Sufficient 3 = NeedsDetailedAssessment 'LayerTwoA' TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated 2 = Failed 3 = Successful 'LayerThree' REAL, CONSTRAINT 'FK_GrassCoverSlipOffOutwardsSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade @@ -678,7 +678,7 @@ ( 'MacrostabilityInwardsSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismSectionEntityId' INTEGER NOT NULL, - 'LayerOne' TINYINT (1) NOT NULL, -- true or false + 'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed 2 = Sufficient 3 = NeedsDetailedAssessment 'LayerTwoA' REAL, 'LayerThree' REAL, CONSTRAINT 'FK_MacrostabilityInwardsSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade @@ -689,7 +689,7 @@ ( 'MacrostabilityOutwardsSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismSectionEntityId' INTEGER NOT NULL, - 'LayerOne' TINYINT (1) NOT NULL, -- true or false + 'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed 2 = Sufficient 3 = NeedsDetailedAssessment 'LayerTwoA' REAL, 'LayerThree' REAL, CONSTRAINT 'FK_MacrostabilityOutwardsSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade @@ -700,7 +700,7 @@ ( 'WaveImpactAsphaltCoverSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismSectionEntityId' INTEGER NOT NULL, - 'LayerOne' TINYINT (1) NOT NULL, -- true or false + 'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed 2 = Sufficient 3 = NeedsDetailedAssessment 'LayerTwoA' REAL, 'LayerThree' REAL, CONSTRAINT 'FK_WaveImpactAsphaltCoverSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade @@ -711,7 +711,7 @@ ( 'MicrostabilitySectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismSectionEntityId' INTEGER NOT NULL, - 'LayerOne' TINYINT (1) NOT NULL, -- true or false + 'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed 2 = Sufficient 3 = NeedsDetailedAssessment 'LayerTwoA' TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated 2 = Failed 3 = Successful 'LayerThree' REAL, CONSTRAINT 'FK_MicrostabilitySectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade @@ -722,7 +722,7 @@ ( 'PipingStructureSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismSectionEntityId' INTEGER NOT NULL, - 'LayerOne' TINYINT (1) NOT NULL, -- true or false + 'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed 2 = Sufficient 3 = NeedsDetailedAssessment 'LayerTwoA' TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated 2 = Failed 3 = Successful 'LayerThree' REAL, CONSTRAINT 'FK_PipingStructureSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade @@ -733,7 +733,7 @@ ( 'DuneErosionSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismSectionEntityId' INTEGER NOT NULL, - 'LayerOne' TINYINT (1) NOT NULL, + 'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed 2 = Sufficient 3 = NeedsDetailedAssessment 'LayerTwoA' TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated 2 = Failed 3 = Successful 'LayerThree' REAL, CONSTRAINT 'FK_DuneErosionSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade @@ -744,7 +744,7 @@ ( 'StabilityStoneCoverSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismSectionEntityId' INTEGER NOT NULL, - 'LayerOne' TINYINT (1) NOT NULL, + 'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed 2 = Sufficient 3 = NeedsDetailedAssessment 'LayerTwoA' TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated 2 = Failed 3 = Successful 'LayerThree' REAL, CONSTRAINT 'FK_StabilityStoneCoverSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade @@ -756,7 +756,7 @@ 'StabilityPointStructuresSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, 'FailureMechanismSectionEntityId' INTEGER NOT NULL, 'StabilityPointStructuresCalculationEntityId' INTEGER, - 'LayerOne' TINYINT (1) NOT NULL, + 'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed 2 = Sufficient 3 = NeedsDetailedAssessment 'LayerThree' REAL, CONSTRAINT 'FK_StabilityPointStructuresSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade, CONSTRAINT 'FK_StabilityPointStructuresSectionResultEntity_StabilityPointStructuresCalculationEntity' FOREIGN KEY ('StabilityPointStructuresCalculationEntityId') REFERENCES 'StabilityPointStructuresCalculationEntity' ('StabilityPointStructuresCalculationEntityId') ON DELETE Set Null ON UPDATE Cascade