Index: Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql
===================================================================
diff -u -ra18b7dcb5ed74f0d8ffc9a4d284d98b25816b9b8 -ra914845d8247dae200d90a19e7d5a9c855c83eb1
--- Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql	(.../DatabaseStructure.sql)	(revision a18b7dcb5ed74f0d8ffc9a4d284d98b25816b9b8)
+++ Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/DatabaseStructure.sql	(.../DatabaseStructure.sql)	(revision a914845d8247dae200d90a19e7d5a9c855c83eb1)
@@ -1,6 +1,6 @@
 /* ---------------------------------------------------- */
 /*  Generated by Enterprise Architect Version 12.0 		*/
-/*  Created On : 13-dec-2016 11:22:15 				*/
+/*  Created On : 14-dec-2016 16:29:22 				*/
 /*  DBMS       : SQLite 								*/
 /* ---------------------------------------------------- */
 
@@ -215,7 +215,7 @@
 	'TargetReliability' REAL,
 	'CalculatedProbability' REAL,
 	'CalculatedReliability' REAL,
-	'CalculationConvergence' TINYINT (1) NOT NULL, -- NotCalculated, CalculatedNotConverged or CalculatedConverged
+	'CalculationConvergence' TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated, 2 = CalculationNotConverged, 3 = CalculationConverged
 	CONSTRAINT 'FK_GrassCoverErosionInwardsDikeHeightOutputEntity_GrassCoverErosionInwardsOutputEntity' FOREIGN KEY ('GrassCoverErosionInwardsOutputEntityId') REFERENCES 'GrassCoverErosionInwardsOutputEntity' ('GrassCoverErosionInwardsOutputEntityId') ON DELETE Cascade ON UPDATE Cascade,
 	CONSTRAINT 'U_GrassCoverErosionInwardsOutputEntity' UNIQUE ('GrassCoverErosionInwardsOutputEntityId')
 )
@@ -238,7 +238,7 @@
 	'Norm' REAL NOT NULL,
 	'HydraulicDatabaseVersion' TEXT,
 	'HydraulicDatabaseLocation' TEXT,
-	'Composition' SMALLINT NOT NULL, -- Enum:  Dike = 1 Dune = 2 DikeAndDune = 3
+	'Composition' TINYINT (1) NOT NULL, -- Enum:  1 = Dike, 2 = Dune, 3 = DikeAndDune
 	'ReferenceLinePointXml' TEXT,
 	'Order' INT (4) NOT NULL,
 	CONSTRAINT 'FK_AssessmentSectionEntity_ProjectEntity' FOREIGN KEY ('ProjectEntityId') REFERENCES 'ProjectEntity' ('ProjectEntityId') ON DELETE Cascade ON UPDATE Cascade
@@ -255,10 +255,10 @@
 	'Order' INT (4) NOT NULL,
 	'Name' VARCHAR (260),
 	'Comments' TEXT,
-	'UseBreakWater' TINYINT (1) NOT NULL,
-	'BreakWaterType' SMALLINT NOT NULL,
+	'UseBreakWater' TINYINT (1) NOT NULL, -- true or false
+	'BreakWaterType' TINYINT (1) NOT NULL, -- Enum: 1 = Wall, 2 = Caisson, 3 = Dam
 	'BreakWaterHeight' REAL,
-	'UseForeshore' TINYINT (1) NOT NULL,
+	'UseForeshore' TINYINT (1) NOT NULL, -- true or false
 	'StructureNormalOrientation' REAL,
 	'StorageStructureAreaMean' REAL,
 	'StorageStructureAreaCoefficientOfVariation' REAL,
@@ -303,8 +303,8 @@
 	'StabilityQuadraticLoadModelCoefficientOfVariation' REAL,
 	'AreaFlowAperturesMean' REAL,
 	'AreaFlowAperturesStandardDeviation' REAL,
-	'InflowModelType' TINYINT (1) NOT NULL,
-	'LoadSchematizationType' TINYINT (1) NOT NULL,
+	'InflowModelType' TINYINT (1) NOT NULL, -- Enum: 1 = VerticalWall, 2 = LowSill, 3 = FloodedCulvert
+	'LoadSchematizationType' TINYINT (1) NOT NULL, -- Enum: 1 = Linear, 2 = Quadratic
 	'VolumicWeightWater' REAL,
 	'StormDurationMean' REAL,
 	'ModelFactorSuperCriticalFlowMean' REAL,
@@ -333,7 +333,7 @@
 	'FailureMechanismEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
 	'AssessmentSectionEntityId' INTEGER NOT NULL,
 	'CalculationGroupEntityId' INTEGER,
-	'FailureMechanismType' SMALLINT NOT NULL, -- Enumerator for different failure mechanism types (piping, macrostability, dunes, etc)  1 = Piping 2 = Macrostabiliteit binnenwaarts 3= Golfklappen op asfaltbekleding 4= Grasbekleding erosie buitentalud 5 = Grasbekleding afschuiven buitentalud 6 = Grasbekleding erosie kruin en binnentalud 7 = Stabiliteit steenzetting 8 = Duinafslag 9 = Hoogte kunstwerk 10 = Betrouwbaarheid sluiten kunstwerk 11 = Piping bij kunstwerk 12 = Sterkte en stabiliteit puntconstructires 13 = Macrostabiliteit buitenwaarts 14 = Microstabiliteit 15 = Wateroverdruk bij asfaltbekleding 16 = Grasbekleding afschuiven binnentalud 17 = Sterkte en stabiliteit langsconstructires 18 = Technische innovaties
+	'FailureMechanismType' SMALLINT NOT NULL, -- Enum: 1 = Piping, 2 = Macrostabiliteit binnenwaarts, 3= Golfklappen op asfaltbekleding, 4= Grasbekleding erosie buitentalud, 5 = Grasbekleding afschuiven buitentalud, 6 = Grasbekleding erosie kruin en binnentalud, 7 = Stabiliteit steenzetting, 8 = Duinafslag, 9 = Hoogte kunstwerk, 10 = Betrouwbaarheid sluiten kunstwerk, 11 = Piping bij kunstwerk, 12 = Sterkte en stabiliteit puntconstructires, 13 = Macrostabiliteit buitenwaarts, 14 = Microstabiliteit, 15 = Wateroverdruk bij asfaltbekleding, 16 = Grasbekleding afschuiven binnentalud, 17 = Sterkte en stabiliteit langsconstructires, 18 = Technische innovaties
 	'IsRelevant' TINYINT (1) NOT NULL, -- true or false
 	'InputComments' TEXT,
 	'OutputComments' TEXT,
@@ -420,7 +420,7 @@
 	'PhreaticLevelExitStandardDeviation' REAL,
 	'DampingFactorExitMean' REAL,
 	'DampingFactorExitStandardDeviation' REAL,
-	'RelevantForScenario' TINYINT (1) NOT NULL,
+	'RelevantForScenario' TINYINT (1) NOT NULL, -- true or false
 	'ScenarioContribution' REAL,
 	'AssessmentLevel' REAL,
 	'UseAssessmentLevelManualInput' TINYINT (1) NOT NULL, -- true or false
@@ -452,11 +452,11 @@
 	'Orientation' REAL,
 	'CriticalFlowRateMean' REAL,
 	'CriticalFlowRateStandardDeviation' REAL,
-	'UseForeshore' TINYINT (1) NOT NULL,
-	'DikeHeightCalculationType' TINYINT (1) NOT NULL, -- NoCalculation = 1, CalculateByAssessmentSectionNorm = 2, CalculateByProfileSpecificRequiredProbability = 3
+	'UseForeshore' TINYINT (1) NOT NULL, -- true or false
+	'DikeHeightCalculationType' TINYINT (1) NOT NULL, -- Enum: 1 = NoCalculation, 2 = CalculateByAssessmentSectionNorm, 3 = CalculateByProfileSpecificRequiredProbability
 	'DikeHeight' REAL,
-	'UseBreakWater' TINYINT (1) NOT NULL,
-	'BreakWaterType' SMALLINT NOT NULL,
+	'UseBreakWater' TINYINT (1) NOT NULL, -- true or false
+	'BreakWaterType' TINYINT (1) NOT NULL, -- Enum: 1 = Wall, 2 = Caisson, 3 = Dam
 	'BreakWaterHeight' REAL,
 	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,
@@ -542,7 +542,7 @@
 (
 	'CharacteristicPointEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
 	'SurfaceLineEntityId' INTEGER NOT NULL,
-	'Type' SMALLINT NOT NULL, -- Enum: 1 = DikeToeAtRiver 2 = DikeToeAtPolder 3 = DitchDikeSide 4 = BottomDitchDikeSide 5 = BottomDitchPolderSide 6 = DitchPolderSide
+	'Type' TINYINT (1) NOT NULL, -- Enum: 1 = DikeToeAtRiver, 2 = DikeToeAtPolder, 3 = DitchDikeSide, 4 = BottomDitchDikeSide, 5 = BottomDitchPolderSide, 6 = DitchPolderSide
 	'X' REAL,
 	'Y' REAL,
 	'Z' REAL,
@@ -599,7 +599,7 @@
 (
 	'PipingSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
 	'FailureMechanismSectionEntityId' INTEGER NOT NULL,
-	'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed 2 = Sufficient 3 = NoVerdict
+	'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed, 2 = Sufficient, 3 = NoVerdict
 	'LayerThree' REAL,
 	CONSTRAINT 'FK_PipingSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade
 )
@@ -610,7 +610,7 @@
 	'GrassCoverErosionInwardsSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
 	'FailureMechanismSectionEntityId' INTEGER NOT NULL,
 	'GrassCoverErosionInwardsCalculationEntityId' INTEGER,
-	'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed 2 = Sufficient 3 = NoVerdict
+	'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed, 2 = Sufficient, 3 = NoVerdict
 	'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
@@ -622,7 +622,7 @@
 	'HeightStructuresSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
 	'FailureMechanismSectionEntityId' INTEGER NOT NULL,
 	'HeightStructuresCalculationEntityId' INTEGER,
-	'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed 2 = Sufficient 3 = NoVerdict
+	'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed, 2 = Sufficient, 3 = NoVerdict
 	'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
@@ -633,7 +633,7 @@
 (
 	'StrengthStabilityLengthwiseConstructionSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
 	'FailureMechanismSectionEntityId' INTEGER NOT NULL,
-	'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed 2 = Sufficient 3 = NoVerdict
+	'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed, 2 = Sufficient, 3 = NoVerdict
 	'LayerThree' REAL,
 	CONSTRAINT 'FK_StrengthStabilityLengthwiseConstructionSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade
 )
@@ -643,7 +643,7 @@
 (
 	'TechnicalInnovationSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
 	'FailureMechanismSectionEntityId' INTEGER NOT NULL,
-	'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed 2 = Sufficient 3 = NeedsDetailedAssessment
+	'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed, 2 = Sufficient, 3 = NoVerdict
 	'LayerThree' REAL,
 	CONSTRAINT 'FK_TechnicalInnovationSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade
 )
@@ -653,7 +653,7 @@
 (
 	'WaterPressureAsphaltCoverSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
 	'FailureMechanismSectionEntityId' INTEGER NOT NULL,
-	'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed 2 = Sufficient 3 = NoVerdict
+	'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed, 2 = Sufficient, 3 = NoVerdict
 	'LayerThree' REAL,
 	CONSTRAINT 'FK_WaterPressureAsphaltCoverSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade
 )
@@ -664,7 +664,7 @@
 	'ClosingStructuresSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
 	'FailureMechanismSectionEntityId' INTEGER NOT NULL,
 	'ClosingStructuresCalculationEntityId' INTEGER,
-	'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed 2 = Sufficient 3 = NoVerdict
+	'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed, 2 = Sufficient, 3 = NoVerdict
 	'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
@@ -675,8 +675,8 @@
 (
 	'GrassCoverErosionOutwardsSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
 	'FailureMechanismSectionEntityId' INTEGER NOT NULL,
-	'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed 2 = Sufficient 3 = NoVerdict
-	'LayerTwoA' TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated 2 = Failed 3 = Successful
+	'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed, 2 = Sufficient, 3 = NoVerdict
+	'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
 )
@@ -686,8 +686,8 @@
 (
 	'GrassCoverSlipOffInwardsSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
 	'FailureMechanismSectionEntityId' INTEGER NOT NULL,
-	'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed 2 = Sufficient 3 = NoVerdict
-	'LayerTwoA' TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated 2 = Failed 3 = Successful
+	'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed, 2 = Sufficient, 3 = NoVerdict
+	'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
 )
@@ -697,8 +697,8 @@
 (
 	'GrassCoverSlipOffOutwardsSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
 	'FailureMechanismSectionEntityId' INTEGER NOT NULL,
-	'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed 2 = Sufficient 3 = NoVerdict
-	'LayerTwoA' TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated 2 = Failed 3 = Successful
+	'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed, 2 = Sufficient, 3 = NoVerdict
+	'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
 )
@@ -708,7 +708,7 @@
 (
 	'MacrostabilityInwardsSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
 	'FailureMechanismSectionEntityId' INTEGER NOT NULL,
-	'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed 2 = Sufficient 3 = NoVerdict
+	'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed, 2 = Sufficient, 3 = NoVerdict
 	'LayerTwoA' REAL,
 	'LayerThree' REAL,
 	CONSTRAINT 'FK_MacrostabilityInwardsSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade
@@ -719,7 +719,7 @@
 (
 	'MacrostabilityOutwardsSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
 	'FailureMechanismSectionEntityId' INTEGER NOT NULL,
-	'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed 2 = Sufficient 3 = NoVerdict
+	'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed, 2 = Sufficient, 3 = NoVerdict
 	'LayerTwoA' REAL,
 	'LayerThree' REAL,
 	CONSTRAINT 'FK_MacrostabilityOutwardsSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade
@@ -730,8 +730,8 @@
 (
 	'WaveImpactAsphaltCoverSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
 	'FailureMechanismSectionEntityId' INTEGER NOT NULL,
-	'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed 2 = Sufficient 3 = NoVerdict
-	'LayerTwoA' TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated 2 = Failed 3 = Successful
+	'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed, 2 = Sufficient, 3 = NoVerdict
+	'LayerTwoA' TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated, 2 = Failed, 3 = Successful
 	'LayerThree' REAL,
 	CONSTRAINT 'FK_WaveImpactAsphaltCoverSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade
 )
@@ -741,8 +741,8 @@
 (
 	'MicrostabilitySectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
 	'FailureMechanismSectionEntityId' INTEGER NOT NULL,
-	'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed 2 = Sufficient 3 = NoVerdict
-	'LayerTwoA' TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated 2 = Failed 3 = Successful
+	'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed, 2 = Sufficient, 3 = NoVerdict
+	'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
 )
@@ -752,8 +752,8 @@
 (
 	'PipingStructureSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
 	'FailureMechanismSectionEntityId' INTEGER NOT NULL,
-	'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed 2 = Sufficient 3 = NoVerdict
-	'LayerTwoA' TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated 2 = Failed 3 = Successful
+	'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed, 2 = Sufficient, 3 = NoVerdict
+	'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
 )
@@ -763,8 +763,8 @@
 (
 	'DuneErosionSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
 	'FailureMechanismSectionEntityId' INTEGER NOT NULL,
-	'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed 2 = Sufficient 3 = NoVerdict
-	'LayerTwoA' TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated 2 = Failed 3 = Successful
+	'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed, 2 = Sufficient, 3 = NoVerdict
+	'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
 )
@@ -774,8 +774,8 @@
 (
 	'StabilityStoneCoverSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
 	'FailureMechanismSectionEntityId' INTEGER NOT NULL,
-	'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed 2 = Sufficient 3 = NoVerdict
-	'LayerTwoA' TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated 2 = Failed 3 = Successful
+	'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed, 2 = Sufficient, 3 = NoVerdict
+	'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
 )
@@ -786,7 +786,7 @@
 	'StabilityPointStructuresSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
 	'FailureMechanismSectionEntityId' INTEGER NOT NULL,
 	'StabilityPointStructuresCalculationEntityId' INTEGER,
-	'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed 2 = Sufficient 3 = NoVerdict
+	'LayerOne' TINYINT (1) NOT NULL, -- Enum: 1 = NotAssessed, 2 = Sufficient, 3 = NoVerdict
 	'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
@@ -817,7 +817,7 @@
 	'GrassCoverErosionInwardsOutputEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
 	'GrassCoverErosionInwardsCalculationEntityId' INTEGER NOT NULL,
 	'Order' INT (4) NOT NULL,
-	'IsOvertoppingDominant' TINYINT (1) NOT NULL,
+	'IsOvertoppingDominant' TINYINT (1) NOT NULL, -- true or false
 	'WaveHeight' REAL,
 	'RequiredProbability' REAL,
 	'RequiredReliability' REAL,
@@ -835,7 +835,7 @@
 	'FailureMechanismEntityId' INTEGER NOT NULL,
 	'Name' VARCHAR (260),
 	'Orientation' REAL,
-	'BreakWaterType' TINYINT (1), -- Enum: 1 = Wall 2 = Caisson 3 = Dam
+	'BreakWaterType' TINYINT (1), -- Enum: 1 = Wall, 2 = Caisson, 3 = Dam
 	'BreakWaterHeight' REAL,
 	'GeometryXml' TEXT NOT NULL,
 	'X' REAL,
@@ -856,15 +856,15 @@
 	'Name' VARCHAR (260),
 	'Comments' TEXT,
 	'UseBreakWater' TINYINT (1) NOT NULL, -- true or false
-	'BreakWaterType' TINYINT (1) NOT NULL, -- Enum: 1 = Wall 2 = Caisson 3 = Dam
+	'BreakWaterType' TINYINT (1) NOT NULL, -- Enum: 1 = Wall, 2 = Caisson, 3 = Dam
 	'BreakWaterHeight' REAL,
 	'UseForeshore' TINYINT (1) NOT NULL, -- true or false
 	'Orientation' REAL,
 	'UpperBoundaryRevetment' REAL,
 	'LowerBoundaryRevetment' REAL,
 	'UpperBoundaryWaterLevels' REAL,
 	'LowerBoundaryWaterLevels' REAL,
-	'StepSize' TINYINT (1) NOT NULL, -- 0.5, 1.0 or 2.0
+	'StepSize' TINYINT (1) NOT NULL, -- Enum: 1 = 0.5, 2 = 1.0, 3 = 2.0
 	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
@@ -876,7 +876,7 @@
 	'StabilityStoneCoverWaveConditionsOutputEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
 	'StabilityStoneCoverWaveConditionsCalculationEntityId' INTEGER NOT NULL,
 	'Order' INT (4) NOT NULL,
-	'OutputType' TINYINT (1) NOT NULL, -- 0 = column 1 = block
+	'OutputType' TINYINT (1) NOT NULL, -- Enum: 1 = Column, 2 = Block
 	'WaterLevel' REAL,
 	'WaveHeight' REAL,
 	'WavePeakPeriod' REAL,
@@ -886,7 +886,7 @@
 	'TargetReliability' REAL,
 	'CalculatedProbability' REAL,
 	'CalculatedReliability' REAL,
-	'CalculationConvergence' TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated 2 = CalculationNotConverged 3 = CalculationConverged
+	'CalculationConvergence' TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated, 2 = CalculationNotConverged, 3 = CalculationConverged
 	CONSTRAINT 'FK_StabilityStoneCoverWaveConditionsOutputEntity_StabilityStoneCoverWaveConditionsCalculationEntity' FOREIGN KEY ('StabilityStoneCoverWaveConditionsCalculationEntityId') REFERENCES 'StabilityStoneCoverWaveConditionsCalculationEntity' ('StabilityStoneCoverWaveConditionsCalculationEntityId') ON DELETE Cascade ON UPDATE Cascade
 )
 ;
@@ -901,15 +901,15 @@
 	'Name' VARCHAR (260),
 	'Comments' TEXT,
 	'UseBreakWater' TINYINT (1) NOT NULL, -- true or false
-	'BreakWaterType' TINYINT (1) NOT NULL, -- Enum: 1 = Wall 2 = Caisson 3 = Dam
+	'BreakWaterType' TINYINT (1) NOT NULL, -- Enum: 1 = Wall, 2 = Caisson, 3 = Dam
 	'BreakWaterHeight' REAL,
 	'UseForeshore' TINYINT (1) NOT NULL, -- true or false
 	'Orientation' REAL,
 	'UpperBoundaryRevetment' REAL,
 	'LowerBoundaryRevetment' REAL,
 	'UpperBoundaryWaterLevels' REAL,
 	'LowerBoundaryWaterLevels' REAL,
-	'StepSize' TINYINT (1) NOT NULL, -- 0.5, 1.0 or 2.0
+	'StepSize' TINYINT (1) NOT NULL, -- Enum: 1 = 0.5, 2 = 1.0, 3 = 2.0
 	CONSTRAINT 'FK_WaveImpactAsphaltCoverWaveConditionsCalculationEntity_CalculationGroupEntity' FOREIGN KEY ('CalculationGroupEntityId') REFERENCES 'CalculationGroupEntity' ('CalculationGroupEntityId') ON DELETE Cascade ON UPDATE Cascade,
 	CONSTRAINT 'FK_WaveImpactAsphaltCoverWaveConditionsCalculationEntity_ForeshoreProfileEntity' FOREIGN KEY ('ForeshoreProfileEntityId') REFERENCES 'ForeshoreProfileEntity' ('ForeshoreProfileEntityId') ON DELETE Set Null ON UPDATE Cascade,
 	CONSTRAINT 'FK_WaveImpactAsphaltCoverWaveConditionsCalculationEntity_HydraulicLocationEntity' FOREIGN KEY ('HydraulicLocationEntityId') REFERENCES 'HydraulicLocationEntity' ('HydraulicLocationEntityId') ON DELETE Set Null ON UPDATE Cascade
@@ -930,7 +930,7 @@
 	'TargetReliability' REAL,
 	'CalculatedProbability' REAL,
 	'CalculatedReliability' REAL,
-	'CalculationConvergence' TINYINT (1) NOT NULL, -- Enum 1 = NotCalculated 2 = CalculationNotConverged 3 = CalculationConverged
+	'CalculationConvergence' TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated, 2 = CalculationNotConverged, 3 = CalculationConverged
 	CONSTRAINT 'FK_WaveImpactAsphaltCoverWaveConditionsOutputEntity_WaveImpactAsphaltCoverWaveConditionsCalculationEntity' FOREIGN KEY ('WaveImpactAsphaltCoverWaveConditionsCalculationEntityId') REFERENCES 'WaveImpactAsphaltCoverWaveConditionsCalculationEntity' ('WaveImpactAsphaltCoverWaveConditionsCalculationEntityId') ON DELETE Cascade ON UPDATE Cascade
 )
 ;
@@ -945,15 +945,15 @@
 	'Name' VARCHAR (260),
 	'Comments' TEXT,
 	'UseBreakWater' TINYINT (1) NOT NULL, -- true or false
-	'BreakWaterType' TINYINT (1) NOT NULL, -- Enum: 1 = Wall 2 = Caisson 3 = Dam
+	'BreakWaterType' TINYINT (1) NOT NULL, -- Enum: 1 = Wall, 2 = Caisson, 3 = Dam
 	'BreakWaterHeight' REAL,
 	'UseForeshore' TINYINT (1) NOT NULL, -- true or false
 	'Orientation' REAL,
 	'UpperBoundaryRevetment' REAL,
 	'LowerBoundaryRevetment' REAL,
 	'UpperBoundaryWaterLevels' REAL,
 	'LowerBoundaryWaterLevels' REAL,
-	'StepSize' TINYINT (1) NOT NULL, -- 0.5, 1.0 or 2.0
+	'StepSize' TINYINT (1) NOT NULL, -- Enum: 1 = 0.5, 2 = 1.0, 3 = 2.0
 	CONSTRAINT 'FK_GrassCoverErosionOutwardsWaveConditionsCalculationEntity_CalculationGroupEntity' FOREIGN KEY ('CalculationGroupEntityId') REFERENCES 'CalculationGroupEntity' ('CalculationGroupEntityId') ON DELETE Cascade ON UPDATE Cascade,
 	CONSTRAINT 'FK_GrassCoverErosionOutwardsWaveConditionsCalculationEntity_ForeshoreProfileEntity' FOREIGN KEY ('ForeshoreProfileEntityId') REFERENCES 'ForeshoreProfileEntity' ('ForeshoreProfileEntityId') ON DELETE Set Null ON UPDATE Cascade,
 	CONSTRAINT 'FK_GrassCoverErosionOutwardsWaveConditionsCalculationEntity_GrassCoverErosionOutwardsHydraulicLocationEntity' FOREIGN KEY ('GrassCoverErosionOutwardsHydraulicLocationEntityId') REFERENCES 'GrassCoverErosionOutwardsHydraulicLocationEntity' ('GrassCoverErosionOutwardsHydraulicLocationEntityId') ON DELETE Set Null ON UPDATE Cascade
@@ -987,7 +987,7 @@
 	'TargetReliability' REAL,
 	'CalculatedProbability' REAL,
 	'CalculatedReliability' REAL,
-	'CalculationConvergence' TINYINT (1) NOT NULL, -- Enum: 0 = NotCalculated 1 = CalculationNotConverged 2 = CalculationConverged
+	'CalculationConvergence' TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated, 2 = CalculationNotConverged, 3 = CalculationConverged
 	CONSTRAINT 'FK_GrassCoverErosionOutwardsWaveConditionsOutputEntity_GrassCoverErosionOutwardsWaveConditionsCalculationEntity' FOREIGN KEY ('GrassCoverErosionOutwardsWaveConditionsCalculationEntityId') REFERENCES 'GrassCoverErosionOutwardsWaveConditionsCalculationEntity' ('GrassCoverErosionOutwardsWaveConditionsCalculationEntityId') ON DELETE Cascade ON UPDATE Cascade
 )
 ;
@@ -1060,9 +1060,9 @@
 	'LevelCrestStructureMean' REAL,
 	'LevelCrestStructureStandardDeviation' REAL,
 	'DeviationWaveDirection' REAL,
-	'UseBreakWater' TINYINT (1) NOT NULL,
-	'UseForeshore' TINYINT (1) NOT NULL,
-	'BreakWaterType' SMALLINT NOT NULL, -- Enum: 1 = Wall 2 = Caisson 3 = Dam
+	'UseBreakWater' TINYINT (1) NOT NULL, -- true or false
+	'UseForeshore' TINYINT (1) NOT NULL, -- true or false
+	'BreakWaterType' TINYINT (1) NOT NULL, -- Enum: 1 = Wall, 2 = Caisson, 3 = Dam
 	'BreakWaterHeight' REAL,
 	CONSTRAINT 'FK_HeightStructuresCalculationEntity_CalculationGroupEntity' FOREIGN KEY ('CalculationGroupEntityId') REFERENCES 'CalculationGroupEntity' ('CalculationGroupEntityId') ON DELETE Cascade ON UPDATE Cascade,
 	CONSTRAINT 'FK_HeightStructuresCalculationEntity_ForeshoreProfileEntity' FOREIGN KEY ('ForeshoreProfileEntityId') REFERENCES 'ForeshoreProfileEntity' ('ForeshoreProfileEntityId') ON DELETE Set Null ON UPDATE Cascade,
@@ -1103,7 +1103,7 @@
 	'FailureProbabilityOpenStructure' REAL,
 	'IdenticalApertures' INT (4) NOT NULL,
 	'FailureProbabilityReparation' REAL,
-	'InflowModelType' TINYINT (1) NOT NULL, -- Enum: VerticalWall = 1 LowSill = 2 FloodedCulvert = 3
+	'InflowModelType' TINYINT (1) NOT NULL, -- Enum: 1 = VerticalWall, 2 = LowSill, 3 = FloodedCulvert
 	CONSTRAINT 'FK_ClosingStructureEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade
 )
 ;
@@ -1118,10 +1118,10 @@
 	'Order' INT (4) NOT NULL,
 	'Name' VARCHAR (255),
 	'Comments' TEXT,
-	'UseBreakWater' TINYINT (1) NOT NULL,
-	'BreakWaterType' SMALLINT NOT NULL,
+	'UseBreakWater' TINYINT (1) NOT NULL, -- true or false
+	'BreakWaterType' TINYINT (1) NOT NULL, -- Enum: 1 = Wall, 2 = Caisson, 3 = Dam
 	'BreakWaterHeight' REAL,
-	'UseForeshore' TINYINT (1) NOT NULL,
+	'UseForeshore' TINYINT (1) NOT NULL, -- true or false
 	'Orientation' REAL,
 	'StructureNormalOrientation' REAL,
 	'StorageStructureAreaMean' REAL,
@@ -1146,7 +1146,7 @@
 	'FailureProbabilityOpenStructure' REAL NOT NULL,
 	'IdenticalApertures' INT (4) NOT NULL,
 	'FailureProbabilityReparation' REAL NOT NULL,
-	'InflowModelType' TINYINT (1) NOT NULL,
+	'InflowModelType' TINYINT (1) NOT NULL, -- Enum: 1 = VerticalWall, 2 = LowSill, 3 = FloodedCulvert
 	'FailureProbabilityStructureWithErosion' REAL NOT NULL,
 	'DeviationWaveDirection' REAL,
 	'DrainCoefficientMean' REAL,
@@ -1227,7 +1227,7 @@
 	'StabilityQuadraticLoadModelCoefficientOfVariation' REAL,
 	'AreaFlowAperturesMean' REAL,
 	'AreaFlowAperturesStandardDeviation' REAL,
-	'InflowModelType' TINYINT (1) NOT NULL, -- Enum: LowSill = 1, FloodedCulvert = 2
+	'InflowModelType' TINYINT (1) NOT NULL, -- Enum: 1 = LowSill, 2 = FloodedCulvert
 	CONSTRAINT 'FK_StabilityPointStructureEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade
 )
 ;
@@ -1250,13 +1250,13 @@
 (
 	'HydraulicLocationEntityOutputId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
 	'HydraulicLocationEntityId' INTEGER NOT NULL,
-	'HydraulicLocationOutputType' TINYINT (1) NOT NULL,
+	'HydraulicLocationOutputType' TINYINT (1) NOT NULL, -- Enum: 1 = DesignWaterLevel, 2 = WaveHeight
 	'Result' REAL,
 	'TargetProbability' REAL,
 	'TargetReliability' REAL,
 	'CalculatedProbability' REAL,
 	'CalculatedReliability' REAL,
-	'CalculationConvergence' TINYINT (1) NOT NULL, -- NotCalculated, CalculatedNotConverged or CalculatedConverged
+	'CalculationConvergence' TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated, 2 = CalculatedNotConverged, 3 = CalculatedConverged
 	CONSTRAINT 'FK_HydraulicLocationOutputEntity_HydraulicLocationEntity' FOREIGN KEY ('HydraulicLocationEntityId') REFERENCES 'HydraulicLocationEntity' ('HydraulicLocationEntityId') ON DELETE Cascade ON UPDATE Cascade,
 	CONSTRAINT 'U_HydraulicLocationEntityOutputType' UNIQUE ('HydraulicLocationEntityId','HydraulicLocationOutputType')
 )
@@ -1266,13 +1266,13 @@
 (
 	'GrassCoverErosionOutwardsHydraulicLocationOutputEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT,
 	'GrassCoverErosionOutwardsHydraulicLocationEntityId' INTEGER NOT NULL,
-	'HydraulicLocationOutputType' TINYINT (1) NOT NULL,
+	'HydraulicLocationOutputType' TINYINT (1) NOT NULL, -- Enum: 1 = DesignWaterLevel, 2 = WaveHeight
 	'Result' REAL,
 	'TargetProbability' REAL,
 	'TargetReliability' REAL,
 	'CalculatedProbability' REAL,
 	'CalculatedReliability' REAL,
-	'CalculationConvergence' TINYINT (1) NOT NULL, -- NotCalculated, CalculatedNotConverged or CalculatedConverged
+	'CalculationConvergence' TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated, 2 = CalculatedNotConverged, 3 = CalculatedConverged
 	CONSTRAINT 'FK_GrassCoverErosionOutwardsHydraulicLocationOutputEntity_GrassCoverErosionOutwardsHydraulicLocationEntity' FOREIGN KEY ('GrassCoverErosionOutwardsHydraulicLocationEntityId') REFERENCES 'GrassCoverErosionOutwardsHydraulicLocationEntity' ('GrassCoverErosionOutwardsHydraulicLocationEntityId') ON DELETE Cascade ON UPDATE Cascade,
 	CONSTRAINT 'U_HydraulicLocationOutputType' UNIQUE ('GrassCoverErosionOutwardsHydraulicLocationEntityId','HydraulicLocationOutputType')
 )
