Index: build/DatabaseStructure.sql =================================================================== diff -u -rd6d9201c17fc7f8479c86722c8f9cd1b3b68f18b -rdea5708b2c085512ce1724cf19eab59e79bc78c6 --- build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision d6d9201c17fc7f8479c86722c8f9cd1b3b68f18b) +++ build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision dea5708b2c085512ce1724cf19eab59e79bc78c6) @@ -1,1993 +1,1993 @@ /* ---------------------------------------------------- */ -/* Generated by Enterprise Architect Version 15.2 */ -/* Created On : 05-mei-2023 11:51:44 */ +/* Generated by Enterprise Architect Version 16.1 */ +/* Created On : 05-mei-2023 15:02:30 */ /* DBMS : SQLite */ /* ---------------------------------------------------- */ /* Drop Tables */ -DROP TABLE IF EXISTS 'VersionEntity' +DROP TABLE IF EXISTS VersionEntity ; -DROP TABLE IF EXISTS 'ProjectEntity' +DROP TABLE IF EXISTS ProjectEntity ; -DROP TABLE IF EXISTS 'AssessmentSectionEntity' +DROP TABLE IF EXISTS AssessmentSectionEntity ; -DROP TABLE IF EXISTS 'FailureMechanismSectionEntity' +DROP TABLE IF EXISTS FailureMechanismSectionEntity ; -DROP TABLE IF EXISTS 'FailureMechanismEntity' +DROP TABLE IF EXISTS FailureMechanismEntity ; -DROP TABLE IF EXISTS 'ClosingStructuresFailureMechanismMetaEntity' +DROP TABLE IF EXISTS ClosingStructuresFailureMechanismMetaEntity ; -DROP TABLE IF EXISTS 'CalculationGroupEntity' +DROP TABLE IF EXISTS CalculationGroupEntity ; -DROP TABLE IF EXISTS 'HydraulicLocationEntity' +DROP TABLE IF EXISTS HydraulicLocationEntity ; -DROP TABLE IF EXISTS 'GrassCoverErosionInwardsFailureMechanismMetaEntity' +DROP TABLE IF EXISTS GrassCoverErosionInwardsFailureMechanismMetaEntity ; -DROP TABLE IF EXISTS 'SemiProbabilisticPipingCalculationEntity' +DROP TABLE IF EXISTS SemiProbabilisticPipingCalculationEntity ; -DROP TABLE IF EXISTS 'GrassCoverErosionInwardsCalculationEntity' +DROP TABLE IF EXISTS GrassCoverErosionInwardsCalculationEntity ; -DROP TABLE IF EXISTS 'GrassCoverSlipOffInwardsFailureMechanismMetaEntity' +DROP TABLE IF EXISTS GrassCoverSlipOffInwardsFailureMechanismMetaEntity ; -DROP TABLE IF EXISTS 'GrassCoverErosionOutwardsFailureMechanismMetaEntity' +DROP TABLE IF EXISTS GrassCoverErosionOutwardsFailureMechanismMetaEntity ; -DROP TABLE IF EXISTS 'PipingSoilLayerEntity' +DROP TABLE IF EXISTS PipingSoilLayerEntity ; -DROP TABLE IF EXISTS 'PipingSoilProfileEntity' +DROP TABLE IF EXISTS PipingSoilProfileEntity ; -DROP TABLE IF EXISTS 'PipingStochasticSoilProfileEntity' +DROP TABLE IF EXISTS PipingStochasticSoilProfileEntity ; -DROP TABLE IF EXISTS 'PipingScenarioConfigurationPerFailureMechanismSectionEntity' +DROP TABLE IF EXISTS PipingScenarioConfigurationPerFailureMechanismSectionEntity ; -DROP TABLE IF EXISTS 'StochasticSoilModelEntity' +DROP TABLE IF EXISTS StochasticSoilModelEntity ; -DROP TABLE IF EXISTS 'SurfaceLineEntity' +DROP TABLE IF EXISTS SurfaceLineEntity ; -DROP TABLE IF EXISTS 'PipingCharacteristicPointEntity' +DROP TABLE IF EXISTS PipingCharacteristicPointEntity ; -DROP TABLE IF EXISTS 'WaterPressureAsphaltCoverFailureMechanismMetaEntity' +DROP TABLE IF EXISTS WaterPressureAsphaltCoverFailureMechanismMetaEntity ; -DROP TABLE IF EXISTS 'WaveImpactAsphaltCoverFailureMechanismMetaEntity' +DROP TABLE IF EXISTS WaveImpactAsphaltCoverFailureMechanismMetaEntity ; -DROP TABLE IF EXISTS 'AdoptableFailureMechanismSectionResultEntity' +DROP TABLE IF EXISTS AdoptableFailureMechanismSectionResultEntity ; -DROP TABLE IF EXISTS 'AdoptableWithProfileProbabilityFailureMechanismSectionResultEntity' +DROP TABLE IF EXISTS AdoptableWithProfileProbabilityFailureMechanismSectionResultEntity ; -DROP TABLE IF EXISTS 'BackgroundDataEntity' +DROP TABLE IF EXISTS BackgroundDataEntity ; -DROP TABLE IF EXISTS 'BackgroundDataMetaEntity' +DROP TABLE IF EXISTS BackgroundDataMetaEntity ; -DROP TABLE IF EXISTS 'ClosingStructureEntity' +DROP TABLE IF EXISTS ClosingStructureEntity ; -DROP TABLE IF EXISTS 'ClosingStructuresCalculationEntity' +DROP TABLE IF EXISTS ClosingStructuresCalculationEntity ; -DROP TABLE IF EXISTS 'ClosingStructuresOutputEntity' +DROP TABLE IF EXISTS ClosingStructuresOutputEntity ; -DROP TABLE IF EXISTS 'DikeProfileEntity' +DROP TABLE IF EXISTS DikeProfileEntity ; -DROP TABLE IF EXISTS 'DuneErosionFailureMechanismMetaEntity' +DROP TABLE IF EXISTS DuneErosionFailureMechanismMetaEntity ; -DROP TABLE IF EXISTS 'DuneLocationCalculationEntity' +DROP TABLE IF EXISTS DuneLocationCalculationEntity ; -DROP TABLE IF EXISTS 'DuneLocationCalculationForTargetProbabilityCollectionEntity' +DROP TABLE IF EXISTS DuneLocationCalculationForTargetProbabilityCollectionEntity ; -DROP TABLE IF EXISTS 'DuneLocationCalculationOutputEntity' +DROP TABLE IF EXISTS DuneLocationCalculationOutputEntity ; -DROP TABLE IF EXISTS 'DuneLocationEntity' +DROP TABLE IF EXISTS DuneLocationEntity ; -DROP TABLE IF EXISTS 'FailureMechanismFailureMechanismSectionEntity' +DROP TABLE IF EXISTS FailureMechanismFailureMechanismSectionEntity ; -DROP TABLE IF EXISTS 'FaultTreeIllustrationPointEntity' +DROP TABLE IF EXISTS FaultTreeIllustrationPointEntity ; -DROP TABLE IF EXISTS 'FaultTreeIllustrationPointStochastEntity' +DROP TABLE IF EXISTS FaultTreeIllustrationPointStochastEntity ; -DROP TABLE IF EXISTS 'FaultTreeSubmechanismIllustrationPointEntity' +DROP TABLE IF EXISTS FaultTreeSubmechanismIllustrationPointEntity ; -DROP TABLE IF EXISTS 'ForeshoreProfileEntity' +DROP TABLE IF EXISTS ForeshoreProfileEntity ; -DROP TABLE IF EXISTS 'GeneralResultFaultTreeIllustrationPointEntity' +DROP TABLE IF EXISTS GeneralResultFaultTreeIllustrationPointEntity ; -DROP TABLE IF EXISTS 'GeneralResultFaultTreeIllustrationPointStochastEntity' +DROP TABLE IF EXISTS GeneralResultFaultTreeIllustrationPointStochastEntity ; -DROP TABLE IF EXISTS 'GeneralResultSubMechanismIllustrationPointEntity' +DROP TABLE IF EXISTS GeneralResultSubMechanismIllustrationPointEntity ; -DROP TABLE IF EXISTS 'GeneralResultSubMechanismIllustrationPointStochastEntity' +DROP TABLE IF EXISTS GeneralResultSubMechanismIllustrationPointStochastEntity ; -DROP TABLE IF EXISTS 'GrassCoverErosionInwardsDikeHeightOutputEntity' +DROP TABLE IF EXISTS GrassCoverErosionInwardsDikeHeightOutputEntity ; -DROP TABLE IF EXISTS 'GrassCoverErosionInwardsOutputEntity' +DROP TABLE IF EXISTS GrassCoverErosionInwardsOutputEntity ; -DROP TABLE IF EXISTS 'GrassCoverErosionInwardsOvertoppingRateOutputEntity' +DROP TABLE IF EXISTS GrassCoverErosionInwardsOvertoppingRateOutputEntity ; -DROP TABLE IF EXISTS 'GrassCoverErosionOutwardsWaveConditionsCalculationEntity' +DROP TABLE IF EXISTS GrassCoverErosionOutwardsWaveConditionsCalculationEntity ; -DROP TABLE IF EXISTS 'GrassCoverErosionOutwardsWaveConditionsOutputEntity' +DROP TABLE IF EXISTS GrassCoverErosionOutwardsWaveConditionsOutputEntity ; -DROP TABLE IF EXISTS 'GrassCoverSlipOffOutwardsFailureMechanismMetaEntity' +DROP TABLE IF EXISTS GrassCoverSlipOffOutwardsFailureMechanismMetaEntity ; -DROP TABLE IF EXISTS 'HeightStructureEntity' +DROP TABLE IF EXISTS HeightStructureEntity ; -DROP TABLE IF EXISTS 'HeightStructuresCalculationEntity' +DROP TABLE IF EXISTS HeightStructuresCalculationEntity ; -DROP TABLE IF EXISTS 'HeightStructuresFailureMechanismMetaEntity' +DROP TABLE IF EXISTS HeightStructuresFailureMechanismMetaEntity ; -DROP TABLE IF EXISTS 'HeightStructuresOutputEntity' +DROP TABLE IF EXISTS HeightStructuresOutputEntity ; -DROP TABLE IF EXISTS 'HydraulicBoundaryDatabaseEntity' +DROP TABLE IF EXISTS HydraulicBoundaryDatabaseEntity ; -DROP TABLE IF EXISTS 'HydraulicBoundaryDataEntity' +DROP TABLE IF EXISTS HydraulicBoundaryDataEntity ; -DROP TABLE IF EXISTS 'HydraulicLocationCalculationCollectionEntity' +DROP TABLE IF EXISTS HydraulicLocationCalculationCollectionEntity ; -DROP TABLE IF EXISTS 'HydraulicLocationCalculationCollectionHydraulicLocationCalculationEntity' +DROP TABLE IF EXISTS HydraulicLocationCalculationCollectionHydraulicLocationCalculationEntity ; -DROP TABLE IF EXISTS 'HydraulicLocationCalculationEntity' +DROP TABLE IF EXISTS HydraulicLocationCalculationEntity ; -DROP TABLE IF EXISTS 'HydraulicLocationCalculationForTargetProbabilityCollectionEntity' +DROP TABLE IF EXISTS HydraulicLocationCalculationForTargetProbabilityCollectionEntity ; -DROP TABLE IF EXISTS 'HydraulicLocationCalculationForTargetProbabilityCollectionHydraulicLocationCalculationEntity' +DROP TABLE IF EXISTS HydraulicLocationCalculationForTargetProbabilityCollectionHydraulicLocationCalculationEntity ; -DROP TABLE IF EXISTS 'HydraulicLocationOutputEntity' +DROP TABLE IF EXISTS HydraulicLocationOutputEntity ; -DROP TABLE IF EXISTS 'IllustrationPointResultEntity' +DROP TABLE IF EXISTS IllustrationPointResultEntity ; -DROP TABLE IF EXISTS 'MacroStabilityInwardsCalculationEntity' +DROP TABLE IF EXISTS MacroStabilityInwardsCalculationEntity ; -DROP TABLE IF EXISTS 'MacroStabilityInwardsCalculationOutputEntity' +DROP TABLE IF EXISTS MacroStabilityInwardsCalculationOutputEntity ; -DROP TABLE IF EXISTS 'MacroStabilityInwardsCharacteristicPointEntity' +DROP TABLE IF EXISTS MacroStabilityInwardsCharacteristicPointEntity ; -DROP TABLE IF EXISTS 'MacroStabilityInwardsFailureMechanismMetaEntity' +DROP TABLE IF EXISTS MacroStabilityInwardsFailureMechanismMetaEntity ; -DROP TABLE IF EXISTS 'MacroStabilityInwardsPreconsolidationStressEntity' +DROP TABLE IF EXISTS MacroStabilityInwardsPreconsolidationStressEntity ; -DROP TABLE IF EXISTS 'MacroStabilityInwardsSoilLayerOneDEntity' +DROP TABLE IF EXISTS MacroStabilityInwardsSoilLayerOneDEntity ; -DROP TABLE IF EXISTS 'MacroStabilityInwardsSoilLayerTwoDEntity' +DROP TABLE IF EXISTS MacroStabilityInwardsSoilLayerTwoDEntity ; -DROP TABLE IF EXISTS 'MacroStabilityInwardsSoilProfileOneDEntity' +DROP TABLE IF EXISTS MacroStabilityInwardsSoilProfileOneDEntity ; -DROP TABLE IF EXISTS 'MacroStabilityInwardsSoilProfileTwoDEntity' +DROP TABLE IF EXISTS MacroStabilityInwardsSoilProfileTwoDEntity ; -DROP TABLE IF EXISTS 'MacroStabilityInwardsSoilProfileTwoDSoilLayerTwoDEntity' +DROP TABLE IF EXISTS MacroStabilityInwardsSoilProfileTwoDSoilLayerTwoDEntity ; -DROP TABLE IF EXISTS 'MacroStabilityInwardsStochasticSoilProfileEntity' +DROP TABLE IF EXISTS MacroStabilityInwardsStochasticSoilProfileEntity ; -DROP TABLE IF EXISTS 'MicrostabilityFailureMechanismMetaEntity' +DROP TABLE IF EXISTS MicrostabilityFailureMechanismMetaEntity ; -DROP TABLE IF EXISTS 'NonAdoptableFailureMechanismSectionResultEntity' +DROP TABLE IF EXISTS NonAdoptableFailureMechanismSectionResultEntity ; -DROP TABLE IF EXISTS 'NonAdoptableWithProfileProbabilityFailureMechanismSectionResultEntity' +DROP TABLE IF EXISTS NonAdoptableWithProfileProbabilityFailureMechanismSectionResultEntity ; -DROP TABLE IF EXISTS 'PipingFailureMechanismMetaEntity' +DROP TABLE IF EXISTS PipingFailureMechanismMetaEntity ; -DROP TABLE IF EXISTS 'PipingStructureFailureMechanismMetaEntity' +DROP TABLE IF EXISTS PipingStructureFailureMechanismMetaEntity ; -DROP TABLE IF EXISTS 'ProbabilisticPipingCalculationEntity' +DROP TABLE IF EXISTS ProbabilisticPipingCalculationEntity ; -DROP TABLE IF EXISTS 'ProbabilisticPipingCalculationOutputEntity' +DROP TABLE IF EXISTS ProbabilisticPipingCalculationOutputEntity ; -DROP TABLE IF EXISTS 'SemiProbabilisticPipingCalculationOutputEntity' +DROP TABLE IF EXISTS SemiProbabilisticPipingCalculationOutputEntity ; -DROP TABLE IF EXISTS 'SpecificFailureMechanismEntity' +DROP TABLE IF EXISTS SpecificFailureMechanismEntity ; -DROP TABLE IF EXISTS 'SpecificFailureMechanismFailureMechanismSectionEntity' +DROP TABLE IF EXISTS SpecificFailureMechanismFailureMechanismSectionEntity ; -DROP TABLE IF EXISTS 'StabilityPointStructureEntity' +DROP TABLE IF EXISTS StabilityPointStructureEntity ; -DROP TABLE IF EXISTS 'StabilityPointStructuresCalculationEntity' +DROP TABLE IF EXISTS StabilityPointStructuresCalculationEntity ; -DROP TABLE IF EXISTS 'StabilityPointStructuresFailureMechanismMetaEntity' +DROP TABLE IF EXISTS StabilityPointStructuresFailureMechanismMetaEntity ; -DROP TABLE IF EXISTS 'StabilityPointStructuresOutputEntity' +DROP TABLE IF EXISTS StabilityPointStructuresOutputEntity ; -DROP TABLE IF EXISTS 'StabilityStoneCoverFailureMechanismMetaEntity' +DROP TABLE IF EXISTS StabilityStoneCoverFailureMechanismMetaEntity ; -DROP TABLE IF EXISTS 'StabilityStoneCoverWaveConditionsCalculationEntity' +DROP TABLE IF EXISTS StabilityStoneCoverWaveConditionsCalculationEntity ; -DROP TABLE IF EXISTS 'StabilityStoneCoverWaveConditionsOutputEntity' +DROP TABLE IF EXISTS StabilityStoneCoverWaveConditionsOutputEntity ; -DROP TABLE IF EXISTS 'StochastEntity' +DROP TABLE IF EXISTS StochastEntity ; -DROP TABLE IF EXISTS 'SubMechanismIllustrationPointEntity' +DROP TABLE IF EXISTS SubMechanismIllustrationPointEntity ; -DROP TABLE IF EXISTS 'SubMechanismIllustrationPointStochastEntity' +DROP TABLE IF EXISTS SubMechanismIllustrationPointStochastEntity ; -DROP TABLE IF EXISTS 'TopLevelFaultTreeIllustrationPointEntity' +DROP TABLE IF EXISTS TopLevelFaultTreeIllustrationPointEntity ; -DROP TABLE IF EXISTS 'TopLevelSubMechanismIllustrationPointEntity' +DROP TABLE IF EXISTS TopLevelSubMechanismIllustrationPointEntity ; -DROP TABLE IF EXISTS 'WaveImpactAsphaltCoverWaveConditionsCalculationEntity' +DROP TABLE IF EXISTS WaveImpactAsphaltCoverWaveConditionsCalculationEntity ; -DROP TABLE IF EXISTS 'WaveImpactAsphaltCoverWaveConditionsOutputEntity' +DROP TABLE IF EXISTS WaveImpactAsphaltCoverWaveConditionsOutputEntity ; /* Create Tables with Primary and Foreign Keys, Check and Unique Constraints */ -CREATE TABLE 'VersionEntity' +CREATE TABLE VersionEntity ( - 'VersionId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'Version' VARCHAR (20) NOT NULL, - 'Timestamp' DATETIME NOT NULL, - 'FingerPrint' BLOB NOT NULL + VersionId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + Version VARCHAR (20) NOT NULL, + Timestamp DATETIME NOT NULL, + FingerPrint BLOB NOT NULL ) ; -CREATE TABLE 'ProjectEntity' +CREATE TABLE ProjectEntity ( - 'ProjectEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'Description' VARCHAR (260) NULL + ProjectEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + Description VARCHAR (260) NULL ) ; -CREATE TABLE 'AssessmentSectionEntity' +CREATE TABLE AssessmentSectionEntity ( - 'AssessmentSectionEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'ProjectEntityId' INTEGER NOT NULL, - 'HydraulicLocationCalculationCollectionEntity1Id' INTEGER NOT NULL, -- Represents the water level signal flooding probability - 'HydraulicLocationCalculationCollectionEntity2Id' INTEGER NOT NULL, -- Represents the water level maximum allowable flooding probability - 'Id' TEXT NULL, - 'Name' VARCHAR (260) NULL, - 'Comments' TEXT NULL, - 'MaximumAllowableFloodingProbability' REAL NOT NULL, - 'SignalFloodingProbability' REAL NOT NULL, - 'NormativeProbabilityType' TINYINT (1) NOT NULL, -- EnumType: 1 = MaximumAllowableFloodingProbability, 2 = SignalFloodingProbability - 'Composition' TINYINT (1) NOT NULL, -- Enum: 1 = Dike, 2 = Dune, 3 = DikeAndDune - 'ReferenceLinePointXml' TEXT NULL, - CONSTRAINT 'FK_AssessmentSectionEntity_HydraulicLocationCalculationCollectionEntity1' FOREIGN KEY ('HydraulicLocationCalculationCollectionEntity1Id') REFERENCES 'HydraulicLocationCalculationCollectionEntity' ('HydraulicLocationCalculationCollectionEntityId') ON DELETE No Action ON UPDATE Cascade, - CONSTRAINT 'FK_AssessmentSectionEntity_HydraulicLocationCalculationCollectionEntity2' FOREIGN KEY ('HydraulicLocationCalculationCollectionEntity2Id') REFERENCES 'HydraulicLocationCalculationCollectionEntity' ('HydraulicLocationCalculationCollectionEntityId') ON DELETE No Action ON UPDATE Cascade, - CONSTRAINT 'FK_AssessmentSectionEntity_ProjectEntity' FOREIGN KEY ('ProjectEntityId') REFERENCES 'ProjectEntity' ('ProjectEntityId') ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT 'U_HydraulicLocationCalculationCollectionEntity1Id' UNIQUE ('HydraulicLocationCalculationCollectionEntity1Id'), - CONSTRAINT 'U_HydraulicLocationCalculationCollectionEntity2Id' UNIQUE ('HydraulicLocationCalculationCollectionEntity2Id') + AssessmentSectionEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + ProjectEntityId INTEGER NOT NULL, + HydraulicLocationCalculationCollectionEntity1Id INTEGER NOT NULL, -- Represents the water level signal flooding probability + HydraulicLocationCalculationCollectionEntity2Id INTEGER NOT NULL, -- Represents the water level maximum allowable flooding probability + Id TEXT NULL COLLATE NOCASE, + Name VARCHAR (260) NULL, + Comments TEXT NULL COLLATE NOCASE, + MaximumAllowableFloodingProbability REAL NOT NULL, + SignalFloodingProbability REAL NOT NULL, + NormativeProbabilityType TINYINT (1) NOT NULL, -- EnumType: 1 = MaximumAllowableFloodingProbability, 2 = SignalFloodingProbability + Composition TINYINT (1) NOT NULL, -- Enum: 1 = Dike, 2 = Dune, 3 = DikeAndDune + ReferenceLinePointXml TEXT NULL COLLATE NOCASE, + CONSTRAINT FK_AssessmentSectionEntity_HydraulicLocationCalculationCollectionEntity1 FOREIGN KEY (HydraulicLocationCalculationCollectionEntity1Id) REFERENCES HydraulicLocationCalculationCollectionEntity (HydraulicLocationCalculationCollectionEntityId) ON DELETE No Action ON UPDATE Cascade, + CONSTRAINT FK_AssessmentSectionEntity_HydraulicLocationCalculationCollectionEntity2 FOREIGN KEY (HydraulicLocationCalculationCollectionEntity2Id) REFERENCES HydraulicLocationCalculationCollectionEntity (HydraulicLocationCalculationCollectionEntityId) ON DELETE No Action ON UPDATE Cascade, + CONSTRAINT FK_AssessmentSectionEntity_ProjectEntity FOREIGN KEY (ProjectEntityId) REFERENCES ProjectEntity (ProjectEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT U_HydraulicLocationCalculationCollectionEntity1Id UNIQUE (HydraulicLocationCalculationCollectionEntity1Id), + CONSTRAINT U_HydraulicLocationCalculationCollectionEntity2Id UNIQUE (HydraulicLocationCalculationCollectionEntity2Id) ) ; -CREATE TABLE 'FailureMechanismSectionEntity' +CREATE TABLE FailureMechanismSectionEntity ( - 'FailureMechanismSectionEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'Name' VARCHAR (260) NOT NULL, - 'FailureMechanismSectionPointXml' TEXT NOT NULL + FailureMechanismSectionEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + Name VARCHAR (260) NOT NULL, + FailureMechanismSectionPointXml TEXT NOT NULL COLLATE NOCASE ) ; -CREATE TABLE 'FailureMechanismEntity' +CREATE TABLE FailureMechanismEntity ( - 'FailureMechanismEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'AssessmentSectionEntityId' INTEGER NOT NULL, - 'CalculationGroupEntityId' INTEGER NULL, - '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 = Microstabiliteit, 14 = Wateroverdruk bij asfaltbekleding, 15 = Grasbekleding afschuiven binnentalud - 'InAssembly' TINYINT (1) NOT NULL, -- true or false - 'FailureMechanismSectionCollectionSourcePath' TEXT NULL, - 'InAssemblyInputComments' TEXT NULL, - 'InAssemblyOutputComments' TEXT NULL, - 'NotInAssemblyComments' TEXT NULL, - 'CalculationsInputComments' TEXT NULL, - 'FailureMechanismAssemblyResultProbabilityResultType' TINYINT (1) NOT NULL, -- Enum: Automatic = 1, Manual = 2 - 'FailureMechanismAssemblyResultManualFailureMechanismAssemblyProbability' REAL NULL, - CONSTRAINT 'FK_FailureMechanismEntity_AssessmentSectionEntity' FOREIGN KEY ('AssessmentSectionEntityId') REFERENCES 'AssessmentSectionEntity' ('AssessmentSectionEntityId') ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT 'FK_FailureMechanismEntity_CalculationGroupEntity' FOREIGN KEY ('CalculationGroupEntityId') REFERENCES 'CalculationGroupEntity' ('CalculationGroupEntityId') ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT 'UI_AssessmentSectionEntityId_FailureMechanismType' UNIQUE ('AssessmentSectionEntityId','FailureMechanismType') + FailureMechanismEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + AssessmentSectionEntityId INTEGER NOT NULL, + CalculationGroupEntityId INTEGER NULL, + 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 = Microstabiliteit, 14 = Wateroverdruk bij asfaltbekleding, 15 = Grasbekleding afschuiven binnentalud + InAssembly TINYINT (1) NOT NULL, -- true or false + FailureMechanismSectionCollectionSourcePath TEXT NULL COLLATE NOCASE, + InAssemblyInputComments TEXT NULL COLLATE NOCASE, + InAssemblyOutputComments TEXT NULL COLLATE NOCASE, + NotInAssemblyComments TEXT NULL COLLATE NOCASE, + CalculationsInputComments TEXT NULL COLLATE NOCASE, + FailureMechanismAssemblyResultProbabilityResultType TINYINT (1) NOT NULL, -- Enum: Automatic = 1, Manual = 2 + FailureMechanismAssemblyResultManualFailureMechanismAssemblyProbability REAL NULL, + CONSTRAINT FK_FailureMechanismEntity_AssessmentSectionEntity FOREIGN KEY (AssessmentSectionEntityId) REFERENCES AssessmentSectionEntity (AssessmentSectionEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT FK_FailureMechanismEntity_CalculationGroupEntity FOREIGN KEY (CalculationGroupEntityId) REFERENCES CalculationGroupEntity (CalculationGroupEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT UI_AssessmentSectionEntityId_FailureMechanismType UNIQUE (AssessmentSectionEntityId,FailureMechanismType) ) ; -CREATE TABLE 'ClosingStructuresFailureMechanismMetaEntity' +CREATE TABLE ClosingStructuresFailureMechanismMetaEntity ( - 'ClosingStructuresFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismEntityId' INTEGER NOT NULL, - 'N2A' INT (4) NOT NULL, - 'ClosingStructureCollectionSourcePath' TEXT NULL, - 'ForeshoreProfileCollectionSourcePath' TEXT NULL, - CONSTRAINT 'FK_ClosingStructuresFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade + ClosingStructuresFailureMechanismMetaEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + FailureMechanismEntityId INTEGER NOT NULL, + N2A INT (4) NOT NULL, + ClosingStructureCollectionSourcePath TEXT NULL COLLATE NOCASE, + ForeshoreProfileCollectionSourcePath TEXT NULL COLLATE NOCASE, + CONSTRAINT FK_ClosingStructuresFailureMechanismMetaEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; -CREATE TABLE 'CalculationGroupEntity' +CREATE TABLE CalculationGroupEntity ( - 'CalculationGroupEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'ParentCalculationGroupEntityId' INTEGER NULL, - 'Name' VARCHAR (260) NULL, + CalculationGroupEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + ParentCalculationGroupEntityId INTEGER NULL, + Name VARCHAR (260) NULL, 'Order' INT (4) NOT NULL, - CONSTRAINT 'FK_CalculationGroupEntity_CalculationGroupEntity' FOREIGN KEY ('ParentCalculationGroupEntityId') REFERENCES 'CalculationGroupEntity' ('CalculationGroupEntityId') ON DELETE Cascade ON UPDATE Cascade + CONSTRAINT FK_CalculationGroupEntity_CalculationGroupEntity FOREIGN KEY (ParentCalculationGroupEntityId) REFERENCES CalculationGroupEntity (CalculationGroupEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; -CREATE TABLE 'HydraulicLocationEntity' +CREATE TABLE HydraulicLocationEntity ( - 'HydraulicLocationEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'HydraulicBoundaryDatabaseEntityId' INTEGER NOT NULL, - 'LocationId' INTEGER NOT NULL, - 'Name' VARCHAR (260) NOT NULL, - 'LocationX' REAL NULL, - 'LocationY' REAL NULL, + HydraulicLocationEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + HydraulicBoundaryDatabaseEntityId INTEGER NOT NULL, + LocationId INTEGER NOT NULL, + Name VARCHAR (260) NOT NULL, + LocationX REAL NULL, + LocationY REAL NULL, 'Order' INT (4) NOT NULL, - CONSTRAINT 'FK_HydraulicLocationEntity_HydraulicBoundaryDatabaseEntity' FOREIGN KEY ('HydraulicBoundaryDatabaseEntityId') REFERENCES 'HydraulicBoundaryDatabaseEntity' ('HydraulicBoundaryDatabaseEntityId') ON DELETE Cascade ON UPDATE Cascade + CONSTRAINT FK_HydraulicLocationEntity_HydraulicBoundaryDatabaseEntity FOREIGN KEY (HydraulicBoundaryDatabaseEntityId) REFERENCES HydraulicBoundaryDatabaseEntity (HydraulicBoundaryDatabaseEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; -CREATE TABLE 'GrassCoverErosionInwardsFailureMechanismMetaEntity' +CREATE TABLE GrassCoverErosionInwardsFailureMechanismMetaEntity ( - 'GrassCoverErosionInwardsFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismEntityId' INTEGER NOT NULL, - 'N' REAL NOT NULL, - 'DikeProfileCollectionSourcePath' TEXT NULL, - 'ApplyLengthEffectInSection' TINYINT (1) NOT NULL, - CONSTRAINT 'FK_GrassCoverErosionInwardsFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade + GrassCoverErosionInwardsFailureMechanismMetaEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + FailureMechanismEntityId INTEGER NOT NULL, + N REAL NOT NULL, + DikeProfileCollectionSourcePath TEXT NULL COLLATE NOCASE, + ApplyLengthEffectInSection TINYINT (1) NOT NULL, + CONSTRAINT FK_GrassCoverErosionInwardsFailureMechanismMetaEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; -CREATE TABLE 'SemiProbabilisticPipingCalculationEntity' +CREATE TABLE SemiProbabilisticPipingCalculationEntity ( - 'SemiProbabilisticPipingCalculationEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'CalculationGroupEntityId' INTEGER NOT NULL, - 'SurfaceLineEntityId' INTEGER NULL, - 'PipingStochasticSoilProfileEntityId' INTEGER NULL, - 'HydraulicLocationEntityId' INTEGER NULL, + SemiProbabilisticPipingCalculationEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + CalculationGroupEntityId INTEGER NOT NULL, + SurfaceLineEntityId INTEGER NULL, + PipingStochasticSoilProfileEntityId INTEGER NULL, + HydraulicLocationEntityId INTEGER NULL, 'Order' INT (4) NOT NULL, - 'Name' VARCHAR (260) NULL, - 'Comments' TEXT NULL, - 'EntryPointL' REAL NULL, - 'ExitPointL' REAL NULL, - 'PhreaticLevelExitMean' REAL NULL, - 'PhreaticLevelExitStandardDeviation' REAL NULL, - 'DampingFactorExitMean' REAL NULL, - 'DampingFactorExitStandardDeviation' REAL NULL, - 'RelevantForScenario' TINYINT (1) NOT NULL, -- true or false - 'ScenarioContribution' REAL NOT NULL, - 'AssessmentLevel' REAL NULL, - 'UseAssessmentLevelManualInput' TINYINT (1) NOT NULL, -- true or false - CONSTRAINT 'FK_SemiProbabilisticPipingCalculationEntity_CalculationGroupEntity' FOREIGN KEY ('CalculationGroupEntityId') REFERENCES 'CalculationGroupEntity' ('CalculationGroupEntityId') ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT 'FK_SemiProbabilisticPipingCalculationEntity_HydraulicLocationEntity' FOREIGN KEY ('HydraulicLocationEntityId') REFERENCES 'HydraulicLocationEntity' ('HydraulicLocationEntityId') ON DELETE Set Null ON UPDATE Cascade, - CONSTRAINT 'FK_SemiProbabilisticPipingCalculationEntity_PipingStochasticSoilProfileEntity' FOREIGN KEY ('PipingStochasticSoilProfileEntityId') REFERENCES 'PipingStochasticSoilProfileEntity' ('PipingStochasticSoilProfileEntityId') ON DELETE Set Null ON UPDATE Cascade, - CONSTRAINT 'FK_SemiProbabilisticPipingCalculationEntity_SurfaceLineEntity' FOREIGN KEY ('SurfaceLineEntityId') REFERENCES 'SurfaceLineEntity' ('SurfaceLineEntityId') ON DELETE Set Null ON UPDATE Cascade + Name VARCHAR (260) NULL, + Comments TEXT NULL COLLATE NOCASE, + EntryPointL REAL NULL, + ExitPointL REAL NULL, + PhreaticLevelExitMean REAL NULL, + PhreaticLevelExitStandardDeviation REAL NULL, + DampingFactorExitMean REAL NULL, + DampingFactorExitStandardDeviation REAL NULL, + RelevantForScenario TINYINT (1) NOT NULL, -- true or false + ScenarioContribution REAL NOT NULL, + AssessmentLevel REAL NULL, + UseAssessmentLevelManualInput TINYINT (1) NOT NULL, -- true or false + CONSTRAINT FK_SemiProbabilisticPipingCalculationEntity_CalculationGroupEntity FOREIGN KEY (CalculationGroupEntityId) REFERENCES CalculationGroupEntity (CalculationGroupEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT FK_SemiProbabilisticPipingCalculationEntity_HydraulicLocationEntity FOREIGN KEY (HydraulicLocationEntityId) REFERENCES HydraulicLocationEntity (HydraulicLocationEntityId) ON DELETE Set Null ON UPDATE Cascade, + CONSTRAINT FK_SemiProbabilisticPipingCalculationEntity_PipingStochasticSoilProfileEntity FOREIGN KEY (PipingStochasticSoilProfileEntityId) REFERENCES PipingStochasticSoilProfileEntity (PipingStochasticSoilProfileEntityId) ON DELETE Set Null ON UPDATE Cascade, + CONSTRAINT FK_SemiProbabilisticPipingCalculationEntity_SurfaceLineEntity FOREIGN KEY (SurfaceLineEntityId) REFERENCES SurfaceLineEntity (SurfaceLineEntityId) ON DELETE Set Null ON UPDATE Cascade ) ; -CREATE TABLE 'GrassCoverErosionInwardsCalculationEntity' +CREATE TABLE GrassCoverErosionInwardsCalculationEntity ( - 'GrassCoverErosionInwardsCalculationEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'CalculationGroupEntityId' INTEGER NOT NULL, - 'HydraulicLocationEntityId' INTEGER NULL, - 'DikeProfileEntityId' INTEGER NULL, + GrassCoverErosionInwardsCalculationEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + CalculationGroupEntityId INTEGER NOT NULL, + HydraulicLocationEntityId INTEGER NULL, + DikeProfileEntityId INTEGER NULL, 'Order' INT (4) NOT NULL, - 'Name' VARCHAR (260) NULL, - 'Comments' TEXT NULL, - 'Orientation' REAL NULL, - 'CriticalFlowRateMean' REAL NULL, - 'CriticalFlowRateStandardDeviation' REAL NULL, - 'UseForeshore' TINYINT (1) NOT NULL, -- true or false - 'DikeHeight' REAL NULL, - 'UseBreakWater' TINYINT (1) NOT NULL, -- true or false - 'BreakWaterType' TINYINT (1) NOT NULL, -- Enum: 1 = Wall, 2 = Caisson, 3 = Dam - 'BreakWaterHeight' REAL NULL, - 'ShouldOvertoppingOutputIllustrationPointsBeCalculated' TINYINT (1) NOT NULL, -- true or false - 'ShouldDikeHeightBeCalculated' TINYINT (1) NOT NULL, -- true or false - 'DikeHeightTargetProbability' REAL NOT NULL, - 'ShouldDikeHeightIllustrationPointsBeCalculated' TINYINT (1) NOT NULL, -- true or false - 'ShouldOvertoppingRateBeCalculated' TINYINT (1) NOT NULL, -- true or false - 'OvertoppingRateTargetProbability' REAL NOT NULL, - 'ShouldOvertoppingRateIllustrationPointsBeCalculated' TINYINT (1) NOT NULL, -- true or false - 'RelevantForScenario' TINYINT (1) NOT NULL, -- true or false - 'ScenarioContribution' REAL NOT NULL, - 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 + Name VARCHAR (260) NULL, + Comments TEXT NULL COLLATE NOCASE, + Orientation REAL NULL, + CriticalFlowRateMean REAL NULL, + CriticalFlowRateStandardDeviation REAL NULL, + UseForeshore TINYINT (1) NOT NULL, -- true or false + DikeHeight REAL NULL, + UseBreakWater TINYINT (1) NOT NULL, -- true or false + BreakWaterType TINYINT (1) NOT NULL, -- Enum: 1 = Wall, 2 = Caisson, 3 = Dam + BreakWaterHeight REAL NULL, + ShouldOvertoppingOutputIllustrationPointsBeCalculated TINYINT (1) NOT NULL, -- true or false + ShouldDikeHeightBeCalculated TINYINT (1) NOT NULL, -- true or false + DikeHeightTargetProbability REAL NOT NULL, + ShouldDikeHeightIllustrationPointsBeCalculated TINYINT (1) NOT NULL, -- true or false + ShouldOvertoppingRateBeCalculated TINYINT (1) NOT NULL, -- true or false + OvertoppingRateTargetProbability REAL NOT NULL, + ShouldOvertoppingRateIllustrationPointsBeCalculated TINYINT (1) NOT NULL, -- true or false + RelevantForScenario TINYINT (1) NOT NULL, -- true or false + ScenarioContribution REAL NOT NULL, + 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 ) ; -CREATE TABLE 'GrassCoverSlipOffInwardsFailureMechanismMetaEntity' +CREATE TABLE GrassCoverSlipOffInwardsFailureMechanismMetaEntity ( - 'GrassCoverSlipOffInwardsFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismEntityId' INTEGER NOT NULL, - 'N' REAL NOT NULL, - 'ApplyLengthEffectInSection' TINYINT (1) NOT NULL, - CONSTRAINT 'FK_GrassCoverSlipOffInwardsFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade + GrassCoverSlipOffInwardsFailureMechanismMetaEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + FailureMechanismEntityId INTEGER NOT NULL, + N REAL NOT NULL, + ApplyLengthEffectInSection TINYINT (1) NOT NULL, + CONSTRAINT FK_GrassCoverSlipOffInwardsFailureMechanismMetaEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; -CREATE TABLE 'GrassCoverErosionOutwardsFailureMechanismMetaEntity' +CREATE TABLE GrassCoverErosionOutwardsFailureMechanismMetaEntity ( - 'GrassCoverErosionOutwardsFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismEntityId' INTEGER NOT NULL, - 'N' REAL NOT NULL, - 'ForeshoreProfileCollectionSourcePath' TEXT NULL, - 'ApplyLengthEffectInSection' TINYINT (1) NOT NULL, - CONSTRAINT 'FK_GrassCoverErosionOutwardsFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade + GrassCoverErosionOutwardsFailureMechanismMetaEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + FailureMechanismEntityId INTEGER NOT NULL, + N REAL NOT NULL, + ForeshoreProfileCollectionSourcePath TEXT NULL COLLATE NOCASE, + ApplyLengthEffectInSection TINYINT (1) NOT NULL, + CONSTRAINT FK_GrassCoverErosionOutwardsFailureMechanismMetaEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; -CREATE TABLE 'PipingSoilLayerEntity' +CREATE TABLE PipingSoilLayerEntity ( - 'PipingSoilLayerEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'PipingSoilProfileEntityId' INTEGER NOT NULL, - 'Top' REAL NULL, - 'IsAquifer' TINYINT (1) NOT NULL, -- true or false - 'Color' INTEGER NULL, -- ARGB value of Color. - 'MaterialName' TEXT NOT NULL, - 'BelowPhreaticLevelMean' REAL NULL, - 'BelowPhreaticLevelDeviation' REAL NULL, - 'BelowPhreaticLevelShift' REAL NULL, - 'DiameterD70Mean' REAL NULL, - 'DiameterD70CoefficientOfVariation' REAL NULL, - 'PermeabilityMean' REAL NULL, - 'PermeabilityCoefficientOfVariation' REAL NULL, + PipingSoilLayerEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + PipingSoilProfileEntityId INTEGER NOT NULL, + Top REAL NULL, + IsAquifer TINYINT (1) NOT NULL, -- true or false + Color INTEGER NULL, -- ARGB value of Color. + MaterialName TEXT NOT NULL COLLATE NOCASE, + BelowPhreaticLevelMean REAL NULL, + BelowPhreaticLevelDeviation REAL NULL, + BelowPhreaticLevelShift REAL NULL, + DiameterD70Mean REAL NULL, + DiameterD70CoefficientOfVariation REAL NULL, + PermeabilityMean REAL NULL, + PermeabilityCoefficientOfVariation REAL NULL, 'Order' INT (4) NOT NULL, - CONSTRAINT 'FK_PipingSoilLayerEntity_SoilProfileEntity' FOREIGN KEY ('PipingSoilProfileEntityId') REFERENCES 'PipingSoilProfileEntity' ('PipingSoilProfileEntityId') ON DELETE Cascade ON UPDATE Cascade + CONSTRAINT FK_PipingSoilLayerEntity_SoilProfileEntity FOREIGN KEY (PipingSoilProfileEntityId) REFERENCES PipingSoilProfileEntity (PipingSoilProfileEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; -CREATE TABLE 'PipingSoilProfileEntity' +CREATE TABLE PipingSoilProfileEntity ( - 'PipingSoilProfileEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'Bottom' REAL NULL, - 'Name' TEXT NOT NULL, - 'SourceType' TINYINT (1) NOT NULL -- Enum: 1 = SoilProfile1D, 2 = SoilProfile2D + PipingSoilProfileEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + Bottom REAL NULL, + Name TEXT NOT NULL COLLATE NOCASE, + SourceType TINYINT (1) NOT NULL -- Enum: 1 = SoilProfile1D, 2 = SoilProfile2D ) ; -CREATE TABLE 'PipingStochasticSoilProfileEntity' +CREATE TABLE PipingStochasticSoilProfileEntity ( - 'PipingStochasticSoilProfileEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'PipingSoilProfileEntityId' INTEGER NOT NULL, - 'StochasticSoilModelEntityId' INTEGER NOT NULL, - 'Probability' REAL NOT NULL, + PipingStochasticSoilProfileEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + PipingSoilProfileEntityId INTEGER NOT NULL, + StochasticSoilModelEntityId INTEGER NOT NULL, + Probability REAL NOT NULL, 'Order' INT (4) NOT NULL, - CONSTRAINT 'FK_PipingStochasticSoilProfileEntity_SoilProfileEntity' FOREIGN KEY ('PipingSoilProfileEntityId') REFERENCES 'PipingSoilProfileEntity' ('PipingSoilProfileEntityId') ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT 'FK_PipingStochasticSoilProfileEntity_StochasticSoilModelEntity' FOREIGN KEY ('StochasticSoilModelEntityId') REFERENCES 'StochasticSoilModelEntity' ('StochasticSoilModelEntityId') ON DELETE Cascade ON UPDATE Cascade + CONSTRAINT FK_PipingStochasticSoilProfileEntity_SoilProfileEntity FOREIGN KEY (PipingSoilProfileEntityId) REFERENCES PipingSoilProfileEntity (PipingSoilProfileEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT FK_PipingStochasticSoilProfileEntity_StochasticSoilModelEntity FOREIGN KEY (StochasticSoilModelEntityId) REFERENCES StochasticSoilModelEntity (StochasticSoilModelEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; -CREATE TABLE 'PipingScenarioConfigurationPerFailureMechanismSectionEntity' +CREATE TABLE PipingScenarioConfigurationPerFailureMechanismSectionEntity ( - 'PipingScenarioConfigurationPerFailureMechanismSectionEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismSectionEntityId' INTEGER NOT NULL, - 'PipingScenarioConfigurationPerFailureMechanismSectionType' TINYINT (1) NOT NULL, -- Enum: SemiProbabilistic = 1 Probabilistic = 2 - CONSTRAINT 'FK_PipingScenarioConfigurationPerFailureMechanismSectionEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade + PipingScenarioConfigurationPerFailureMechanismSectionEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + FailureMechanismSectionEntityId INTEGER NOT NULL, + PipingScenarioConfigurationPerFailureMechanismSectionType TINYINT (1) NOT NULL, -- Enum: SemiProbabilistic = 1 Probabilistic = 2 + CONSTRAINT FK_PipingScenarioConfigurationPerFailureMechanismSectionEntity_FailureMechanismSectionEntity FOREIGN KEY (FailureMechanismSectionEntityId) REFERENCES FailureMechanismSectionEntity (FailureMechanismSectionEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; -CREATE TABLE 'StochasticSoilModelEntity' +CREATE TABLE StochasticSoilModelEntity ( - 'StochasticSoilModelEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismEntityId' INTEGER NOT NULL, - 'Name' TEXT NOT NULL, - 'StochasticSoilModelSegmentPointXml' TEXT NOT NULL, + StochasticSoilModelEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + FailureMechanismEntityId INTEGER NOT NULL, + Name TEXT NOT NULL COLLATE NOCASE, + StochasticSoilModelSegmentPointXml TEXT NOT NULL COLLATE NOCASE, 'Order' INT (4) NOT NULL, - CONSTRAINT 'FK_StochasticSoilModelEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT 'UQ_StochasticSoilModelEntity_NameFailureMechanismEntityId' UNIQUE ('Name','FailureMechanismEntityId') + CONSTRAINT FK_StochasticSoilModelEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT UQ_StochasticSoilModelEntity_NameFailureMechanismEntityId UNIQUE (Name,FailureMechanismEntityId) ) ; -CREATE TABLE 'SurfaceLineEntity' +CREATE TABLE SurfaceLineEntity ( - 'SurfaceLineEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismEntityId' INTEGER NOT NULL, - 'Name' VARCHAR (260) NOT NULL, - 'ReferenceLineIntersectionX' REAL NULL, - 'ReferenceLineIntersectionY' REAL NULL, - 'PointsXml' TEXT NOT NULL, + SurfaceLineEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + FailureMechanismEntityId INTEGER NOT NULL, + Name VARCHAR (260) NOT NULL, + ReferenceLineIntersectionX REAL NULL, + ReferenceLineIntersectionY REAL NULL, + PointsXml TEXT NOT NULL COLLATE NOCASE, 'Order' INT (4) NOT NULL, - CONSTRAINT 'FK_SurfaceLineEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT 'UQ_SurfaceLineEntity_NameFailureMechanismEntityId' UNIQUE ('Name','FailureMechanismEntityId') + CONSTRAINT FK_SurfaceLineEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT UQ_SurfaceLineEntity_NameFailureMechanismEntityId UNIQUE (Name,FailureMechanismEntityId) ) ; -CREATE TABLE 'PipingCharacteristicPointEntity' +CREATE TABLE PipingCharacteristicPointEntity ( - 'PipingCharacteristicPointEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'SurfaceLineEntityId' INTEGER NOT NULL, - 'Type' TINYINT (1) NOT NULL, -- Enum: 1 = DikeToeAtRiver, 2 = DikeToeAtPolder, 3 = DitchDikeSide, 4 = BottomDitchDikeSide, 5 = BottomDitchPolderSide, 6 = DitchPolderSide - 'X' REAL NULL, - 'Y' REAL NULL, - 'Z' REAL NULL, - CONSTRAINT 'FK_SurfaceLinePointEntity_SurfaceLineEntity' FOREIGN KEY ('SurfaceLineEntityId') REFERENCES 'SurfaceLineEntity' ('SurfaceLineEntityId') ON DELETE Cascade ON UPDATE Cascade + PipingCharacteristicPointEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + SurfaceLineEntityId INTEGER NOT NULL, + Type TINYINT (1) NOT NULL, -- Enum: 1 = DikeToeAtRiver, 2 = DikeToeAtPolder, 3 = DitchDikeSide, 4 = BottomDitchDikeSide, 5 = BottomDitchPolderSide, 6 = DitchPolderSide + X REAL NULL, + Y REAL NULL, + Z REAL NULL, + CONSTRAINT FK_SurfaceLinePointEntity_SurfaceLineEntity FOREIGN KEY (SurfaceLineEntityId) REFERENCES SurfaceLineEntity (SurfaceLineEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; -CREATE TABLE 'WaterPressureAsphaltCoverFailureMechanismMetaEntity' +CREATE TABLE WaterPressureAsphaltCoverFailureMechanismMetaEntity ( - 'WaterPressureAsphaltCoverFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismEntityId' INTEGER NOT NULL, - 'N' REAL NOT NULL, - 'ApplyLengthEffectInSection' TINYINT (1) NOT NULL, - CONSTRAINT 'FK_WaterPressureAsphaltCoverFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade + WaterPressureAsphaltCoverFailureMechanismMetaEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + FailureMechanismEntityId INTEGER NOT NULL, + N REAL NOT NULL, + ApplyLengthEffectInSection TINYINT (1) NOT NULL, + CONSTRAINT FK_WaterPressureAsphaltCoverFailureMechanismMetaEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; -CREATE TABLE 'WaveImpactAsphaltCoverFailureMechanismMetaEntity' +CREATE TABLE WaveImpactAsphaltCoverFailureMechanismMetaEntity ( - 'WaveImpactAsphaltCoverFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismEntityId' INTEGER NOT NULL, - 'ForeshoreProfileCollectionSourcePath' TEXT NULL, - 'DeltaL' REAL NOT NULL, - 'ApplyLengthEffectInSection' TINYINT (1) NOT NULL, - CONSTRAINT 'FK_WaveImpactAsphaltCoverFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade + WaveImpactAsphaltCoverFailureMechanismMetaEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + FailureMechanismEntityId INTEGER NOT NULL, + ForeshoreProfileCollectionSourcePath TEXT NULL COLLATE NOCASE, + DeltaL REAL NOT NULL, + ApplyLengthEffectInSection TINYINT (1) NOT NULL, + CONSTRAINT FK_WaveImpactAsphaltCoverFailureMechanismMetaEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; -CREATE TABLE 'AdoptableFailureMechanismSectionResultEntity' +CREATE TABLE AdoptableFailureMechanismSectionResultEntity ( - 'AdoptableFailureMechanismSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismSectionEntityId' INTEGER NOT NULL, - 'IsRelevant' TINYINT (1) NOT NULL, -- true or false - 'InitialFailureMechanismResultType' TINYINT (1) NOT NULL, -- Enum: Adopt = 1 Manual = 2 NoFailureProbability = 3 - 'ManualInitialFailureMechanismResultSectionProbability' REAL NULL, - 'FurtherAnalysisType' TINYINT (1) NOT NULL, -- Enum: NotNecessary = 1 Necessary = 2 Executed = 3 - 'RefinedSectionProbability' REAL NULL, - CONSTRAINT 'FK_AdoptableFailureMechanismSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade + AdoptableFailureMechanismSectionResultEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + FailureMechanismSectionEntityId INTEGER NOT NULL, + IsRelevant TINYINT (1) NOT NULL, -- true or false + InitialFailureMechanismResultType TINYINT (1) NOT NULL, -- Enum: Adopt = 1 Manual = 2 NoFailureProbability = 3 + ManualInitialFailureMechanismResultSectionProbability REAL NULL, + FurtherAnalysisType TINYINT (1) NOT NULL, -- Enum: NotNecessary = 1 Necessary = 2 Executed = 3 + RefinedSectionProbability REAL NULL, + CONSTRAINT FK_AdoptableFailureMechanismSectionResultEntity_FailureMechanismSectionEntity FOREIGN KEY (FailureMechanismSectionEntityId) REFERENCES FailureMechanismSectionEntity (FailureMechanismSectionEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; -CREATE TABLE 'AdoptableWithProfileProbabilityFailureMechanismSectionResultEntity' +CREATE TABLE AdoptableWithProfileProbabilityFailureMechanismSectionResultEntity ( - 'AdoptableWithProfileProbabilityFailureMechanismSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismSectionEntityId' INTEGER NOT NULL, - 'IsRelevant' TINYINT (1) NOT NULL, -- true or false - 'InitialFailureMechanismResultType' TINYINT (1) NOT NULL, -- Enum: Adopt = 1 Manual = 2 NoFailureProbability = 3 - 'ManualInitialFailureMechanismResultSectionProbability' REAL NULL, - 'ManualInitialFailureMechanismResultProfileProbability' REAL NULL, - 'FurtherAnalysisType' TINYINT (1) NOT NULL, -- Enum: NotNecessary = 1 Necessary = 2 Executed = 3 - 'ProbabilityRefinementType' TINYINT (1) NOT NULL, -- Enum: Profile = 1 Section = 2 Both = 3 - 'RefinedSectionProbability' REAL NULL, - 'RefinedProfileProbability' REAL NULL, - CONSTRAINT 'FK_AdoptableWithProfileProbabilityFailureMechanismSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade + AdoptableWithProfileProbabilityFailureMechanismSectionResultEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + FailureMechanismSectionEntityId INTEGER NOT NULL, + IsRelevant TINYINT (1) NOT NULL, -- true or false + InitialFailureMechanismResultType TINYINT (1) NOT NULL, -- Enum: Adopt = 1 Manual = 2 NoFailureProbability = 3 + ManualInitialFailureMechanismResultSectionProbability REAL NULL, + ManualInitialFailureMechanismResultProfileProbability REAL NULL, + FurtherAnalysisType TINYINT (1) NOT NULL, -- Enum: NotNecessary = 1 Necessary = 2 Executed = 3 + ProbabilityRefinementType TINYINT (1) NOT NULL, -- Enum: Profile = 1 Section = 2 Both = 3 + RefinedSectionProbability REAL NULL, + RefinedProfileProbability REAL NULL, + CONSTRAINT FK_AdoptableWithProfileProbabilityFailureMechanismSectionResultEntity_FailureMechanismSectionEntity FOREIGN KEY (FailureMechanismSectionEntityId) REFERENCES FailureMechanismSectionEntity (FailureMechanismSectionEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; -CREATE TABLE 'BackgroundDataEntity' +CREATE TABLE BackgroundDataEntity ( - 'BackgroundDataEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'AssessmentSectionEntityId' INTEGER NOT NULL, - 'Name' TEXT NOT NULL, - 'IsVisible' TINYINT (1) NOT NULL, -- true or false - 'Transparency' REAL NOT NULL, - 'BackgroundDataType' TINYINT (1) NOT NULL, -- Enum: 1 = Wmts, 2 = WellKnown - CONSTRAINT 'FK_BackgroundDataEntity_AssessmentSectionEntity' FOREIGN KEY ('AssessmentSectionEntityId') REFERENCES 'AssessmentSectionEntity' ('AssessmentSectionEntityId') ON DELETE Cascade ON UPDATE Cascade + BackgroundDataEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + AssessmentSectionEntityId INTEGER NOT NULL, + Name TEXT NOT NULL COLLATE NOCASE, + IsVisible TINYINT (1) NOT NULL, -- true or false + Transparency REAL NOT NULL, + BackgroundDataType TINYINT (1) NOT NULL, -- Enum: 1 = Wmts, 2 = WellKnown + CONSTRAINT FK_BackgroundDataEntity_AssessmentSectionEntity FOREIGN KEY (AssessmentSectionEntityId) REFERENCES AssessmentSectionEntity (AssessmentSectionEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; -CREATE TABLE 'BackgroundDataMetaEntity' +CREATE TABLE BackgroundDataMetaEntity ( - 'BackgroundDataMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'BackgroundDataEntityId' INTEGER NOT NULL, - 'Key' TEXT NOT NULL, - 'Value' TEXT NOT NULL, - CONSTRAINT 'FK_BackgroundDataMetaEntity_BackgroundDataEntity' FOREIGN KEY ('BackgroundDataEntityId') REFERENCES 'BackgroundDataEntity' ('BackgroundDataEntityId') ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT 'U_BackgroundDataEntityId_Key' UNIQUE ('BackgroundDataEntityId','Key') + BackgroundDataMetaEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + BackgroundDataEntityId INTEGER NOT NULL, + 'Key' TEXT NOT NULL COLLATE NOCASE, + Value TEXT NOT NULL COLLATE NOCASE, + CONSTRAINT FK_BackgroundDataMetaEntity_BackgroundDataEntity FOREIGN KEY (BackgroundDataEntityId) REFERENCES BackgroundDataEntity (BackgroundDataEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT U_BackgroundDataEntityId_Key UNIQUE (BackgroundDataEntityId,'Key') ) ; -CREATE TABLE 'ClosingStructureEntity' +CREATE TABLE ClosingStructureEntity ( - 'ClosingStructureEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismEntityId' INTEGER NOT NULL, + ClosingStructureEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + FailureMechanismEntityId INTEGER NOT NULL, 'Order' INT (4) NOT NULL, - 'Name' VARCHAR (260) NOT NULL, - 'Id' VARCHAR (260) NOT NULL, - 'X' REAL NULL, - 'Y' REAL NULL, - 'StructureNormalOrientation' REAL NULL, - 'StorageStructureAreaMean' REAL NULL, - 'StorageStructureAreaCoefficientOfVariation' REAL NULL, - 'AllowedLevelIncreaseStorageMean' REAL NULL, - 'AllowedLevelIncreaseStorageStandardDeviation' REAL NULL, - 'WidthFlowAperturesMean' REAL NULL, - 'WidthFlowAperturesStandardDeviation' REAL NULL, - 'LevelCrestStructureNotClosingMean' REAL NULL, - 'LevelCrestStructureNotClosingStandardDeviation' REAL NULL, - 'InsideWaterLevelMean' REAL NULL, - 'InsideWaterLevelStandardDeviation' REAL NULL, - 'ThresholdHeightOpenWeirMean' REAL NULL, - 'ThresholdHeightOpenWeirStandardDeviation' REAL NULL, - 'AreaFlowAperturesMean' REAL NULL, - 'AreaFlowAperturesStandardDeviation' REAL NULL, - 'CriticalOvertoppingDischargeMean' REAL NULL, - 'CriticalOvertoppingDischargeCoefficientOfVariation' REAL NULL, - 'FlowWidthAtBottomProtectionMean' REAL NULL, - 'FlowWidthAtBottomProtectionStandardDeviation' REAL NULL, - 'ProbabilityOpenStructureBeforeFlooding' REAL NULL, - 'FailureProbabilityOpenStructure' REAL NULL, - 'IdenticalApertures' INT (4) NOT NULL, - 'FailureProbabilityReparation' REAL NULL, - '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, - CONSTRAINT 'U_Id_FailureMechanismEntityId' UNIQUE ('FailureMechanismEntityId','Id') + Name VARCHAR (260) NOT NULL, + Id VARCHAR (260) NOT NULL, + X REAL NULL, + Y REAL NULL, + StructureNormalOrientation REAL NULL, + StorageStructureAreaMean REAL NULL, + StorageStructureAreaCoefficientOfVariation REAL NULL, + AllowedLevelIncreaseStorageMean REAL NULL, + AllowedLevelIncreaseStorageStandardDeviation REAL NULL, + WidthFlowAperturesMean REAL NULL, + WidthFlowAperturesStandardDeviation REAL NULL, + LevelCrestStructureNotClosingMean REAL NULL, + LevelCrestStructureNotClosingStandardDeviation REAL NULL, + InsideWaterLevelMean REAL NULL, + InsideWaterLevelStandardDeviation REAL NULL, + ThresholdHeightOpenWeirMean REAL NULL, + ThresholdHeightOpenWeirStandardDeviation REAL NULL, + AreaFlowAperturesMean REAL NULL, + AreaFlowAperturesStandardDeviation REAL NULL, + CriticalOvertoppingDischargeMean REAL NULL, + CriticalOvertoppingDischargeCoefficientOfVariation REAL NULL, + FlowWidthAtBottomProtectionMean REAL NULL, + FlowWidthAtBottomProtectionStandardDeviation REAL NULL, + ProbabilityOpenStructureBeforeFlooding REAL NULL, + FailureProbabilityOpenStructure REAL NULL, + IdenticalApertures INT (4) NOT NULL, + FailureProbabilityReparation REAL NULL, + 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, + CONSTRAINT U_Id_FailureMechanismEntityId UNIQUE (FailureMechanismEntityId,Id) ) ; -CREATE TABLE 'ClosingStructuresCalculationEntity' +CREATE TABLE ClosingStructuresCalculationEntity ( - 'ClosingStructuresCalculationEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'CalculationGroupEntityId' INTEGER NOT NULL, - 'ForeshoreProfileEntityId' INTEGER NULL, - 'HydraulicLocationEntityId' INTEGER NULL, - 'ClosingStructureEntityId' INTEGER NULL, + ClosingStructuresCalculationEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + CalculationGroupEntityId INTEGER NOT NULL, + ForeshoreProfileEntityId INTEGER NULL, + HydraulicLocationEntityId INTEGER NULL, + ClosingStructureEntityId INTEGER NULL, 'Order' INT (4) NOT NULL, - 'Name' VARCHAR (255) NULL, - 'Comments' TEXT NULL, - 'UseBreakWater' TINYINT (1) NOT NULL, -- true or false - 'BreakWaterType' TINYINT (1) NOT NULL, -- Enum: 1 = Wall, 2 = Caisson, 3 = Dam - 'BreakWaterHeight' REAL NULL, - 'UseForeshore' TINYINT (1) NOT NULL, -- true or false - 'Orientation' REAL NULL, - 'StructureNormalOrientation' REAL NULL, - 'StorageStructureAreaMean' REAL NULL, - 'StorageStructureAreaCoefficientOfVariation' REAL NULL, - 'AllowedLevelIncreaseStorageMean' REAL NULL, - 'AllowedLevelIncreaseStorageStandardDeviation' REAL NULL, - 'WidthFlowAperturesMean' REAL NULL, - 'WidthFlowAperturesStandardDeviation' REAL NULL, - 'LevelCrestStructureNotClosingMean' REAL NULL, - 'LevelCrestStructureNotClosingStandardDeviation' REAL NULL, - 'InsideWaterLevelMean' REAL NULL, - 'InsideWaterLevelStandardDeviation' REAL NULL, - 'ThresholdHeightOpenWeirMean' REAL NULL, - 'ThresholdHeightOpenWeirStandardDeviation' REAL NULL, - 'AreaFlowAperturesMean' REAL NULL, - 'AreaFlowAperturesStandardDeviation' REAL NULL, - 'CriticalOvertoppingDischargeMean' REAL NULL, - 'CriticalOvertoppingDischargeCoefficientOfVariation' REAL NULL, - 'FlowWidthAtBottomProtectionMean' REAL NULL, - 'FlowWidthAtBottomProtectionStandardDeviation' REAL NULL, - 'ProbabilityOpenStructureBeforeFlooding' REAL NOT NULL, - 'FailureProbabilityOpenStructure' REAL NOT NULL, - 'IdenticalApertures' INT (4) NOT NULL, - 'FailureProbabilityReparation' REAL NOT NULL, - 'InflowModelType' TINYINT (1) NOT NULL, -- Enum: 1 = VerticalWall, 2 = LowSill, 3 = FloodedCulvert - 'FailureProbabilityStructureWithErosion' REAL NOT NULL, - 'DeviationWaveDirection' REAL NULL, - 'DrainCoefficientMean' REAL NULL, - 'DrainCoefficientStandardDeviation' REAL NULL, - 'ModelFactorSuperCriticalFlowMean' REAL NULL, - 'StormDurationMean' REAL NULL, - 'FactorStormDurationOpenStructure' REAL NULL, - 'ShouldIllustrationPointsBeCalculated' TINYINT (1) NOT NULL, -- true or false - 'RelevantForScenario' TINYINT (1) NOT NULL, -- true or false - 'ScenarioContribution' REAL NOT NULL, - CONSTRAINT 'FK_ClosingStructuresCalculationEntity_CalculationGroupEntity' FOREIGN KEY ('CalculationGroupEntityId') REFERENCES 'CalculationGroupEntity' ('CalculationGroupEntityId') ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT 'FK_ClosingStructuresCalculationEntity_ClosingStructureEntity' FOREIGN KEY ('ClosingStructureEntityId') REFERENCES 'ClosingStructureEntity' ('ClosingStructureEntityId') ON DELETE Set Null ON UPDATE Cascade, - CONSTRAINT 'FK_ClosingStructuresCalculationEntity_ForeshoreProfileEntity' FOREIGN KEY ('ForeshoreProfileEntityId') REFERENCES 'ForeshoreProfileEntity' ('ForeshoreProfileEntityId') ON DELETE Set Null ON UPDATE Cascade, - CONSTRAINT 'FK_ClosingStructuresCalculationEntity_HydraulicLocationEntity' FOREIGN KEY ('HydraulicLocationEntityId') REFERENCES 'HydraulicLocationEntity' ('HydraulicLocationEntityId') ON DELETE Set Null ON UPDATE Cascade + Name VARCHAR (255) NULL, + Comments TEXT NULL COLLATE NOCASE, + UseBreakWater TINYINT (1) NOT NULL, -- true or false + BreakWaterType TINYINT (1) NOT NULL, -- Enum: 1 = Wall, 2 = Caisson, 3 = Dam + BreakWaterHeight REAL NULL, + UseForeshore TINYINT (1) NOT NULL, -- true or false + Orientation REAL NULL, + StructureNormalOrientation REAL NULL, + StorageStructureAreaMean REAL NULL, + StorageStructureAreaCoefficientOfVariation REAL NULL, + AllowedLevelIncreaseStorageMean REAL NULL, + AllowedLevelIncreaseStorageStandardDeviation REAL NULL, + WidthFlowAperturesMean REAL NULL, + WidthFlowAperturesStandardDeviation REAL NULL, + LevelCrestStructureNotClosingMean REAL NULL, + LevelCrestStructureNotClosingStandardDeviation REAL NULL, + InsideWaterLevelMean REAL NULL, + InsideWaterLevelStandardDeviation REAL NULL, + ThresholdHeightOpenWeirMean REAL NULL, + ThresholdHeightOpenWeirStandardDeviation REAL NULL, + AreaFlowAperturesMean REAL NULL, + AreaFlowAperturesStandardDeviation REAL NULL, + CriticalOvertoppingDischargeMean REAL NULL, + CriticalOvertoppingDischargeCoefficientOfVariation REAL NULL, + FlowWidthAtBottomProtectionMean REAL NULL, + FlowWidthAtBottomProtectionStandardDeviation REAL NULL, + ProbabilityOpenStructureBeforeFlooding REAL NOT NULL, + FailureProbabilityOpenStructure REAL NOT NULL, + IdenticalApertures INT (4) NOT NULL, + FailureProbabilityReparation REAL NOT NULL, + InflowModelType TINYINT (1) NOT NULL, -- Enum: 1 = VerticalWall, 2 = LowSill, 3 = FloodedCulvert + FailureProbabilityStructureWithErosion REAL NOT NULL, + DeviationWaveDirection REAL NULL, + DrainCoefficientMean REAL NULL, + DrainCoefficientStandardDeviation REAL NULL, + ModelFactorSuperCriticalFlowMean REAL NULL, + StormDurationMean REAL NULL, + FactorStormDurationOpenStructure REAL NULL, + ShouldIllustrationPointsBeCalculated TINYINT (1) NOT NULL, -- true or false + RelevantForScenario TINYINT (1) NOT NULL, -- true or false + ScenarioContribution REAL NOT NULL, + CONSTRAINT FK_ClosingStructuresCalculationEntity_CalculationGroupEntity FOREIGN KEY (CalculationGroupEntityId) REFERENCES CalculationGroupEntity (CalculationGroupEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT FK_ClosingStructuresCalculationEntity_ClosingStructureEntity FOREIGN KEY (ClosingStructureEntityId) REFERENCES ClosingStructureEntity (ClosingStructureEntityId) ON DELETE Set Null ON UPDATE Cascade, + CONSTRAINT FK_ClosingStructuresCalculationEntity_ForeshoreProfileEntity FOREIGN KEY (ForeshoreProfileEntityId) REFERENCES ForeshoreProfileEntity (ForeshoreProfileEntityId) ON DELETE Set Null ON UPDATE Cascade, + CONSTRAINT FK_ClosingStructuresCalculationEntity_HydraulicLocationEntity FOREIGN KEY (HydraulicLocationEntityId) REFERENCES HydraulicLocationEntity (HydraulicLocationEntityId) ON DELETE Set Null ON UPDATE Cascade ) ; -CREATE TABLE 'ClosingStructuresOutputEntity' +CREATE TABLE ClosingStructuresOutputEntity ( - 'ClosingStructuresOutputEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'ClosingStructuresCalculationEntityId' INTEGER NOT NULL, - 'GeneralResultFaultTreeIllustrationPointEntityId' INTEGER NULL, - 'Reliability' REAL NULL, - CONSTRAINT 'FK_ClosingStructuresOutputEntity_ClosingStructuresCalculationEntity' FOREIGN KEY ('ClosingStructuresCalculationEntityId') REFERENCES 'ClosingStructuresCalculationEntity' ('ClosingStructuresCalculationEntityId') ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT 'FK_ClosingStructuresOutputEntity_GeneralResultFaultTreeIllustrationPointEntity' FOREIGN KEY ('GeneralResultFaultTreeIllustrationPointEntityId') REFERENCES 'GeneralResultFaultTreeIllustrationPointEntity' ('GeneralResultFaultTreeIllustrationPointEntityId') ON DELETE Set Null ON UPDATE Cascade, - CONSTRAINT 'U_ClosingStructuresCalculationEntity' UNIQUE ('ClosingStructuresCalculationEntityId') + ClosingStructuresOutputEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + ClosingStructuresCalculationEntityId INTEGER NOT NULL, + GeneralResultFaultTreeIllustrationPointEntityId INTEGER NULL, + Reliability REAL NULL, + CONSTRAINT FK_ClosingStructuresOutputEntity_ClosingStructuresCalculationEntity FOREIGN KEY (ClosingStructuresCalculationEntityId) REFERENCES ClosingStructuresCalculationEntity (ClosingStructuresCalculationEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT FK_ClosingStructuresOutputEntity_GeneralResultFaultTreeIllustrationPointEntity FOREIGN KEY (GeneralResultFaultTreeIllustrationPointEntityId) REFERENCES GeneralResultFaultTreeIllustrationPointEntity (GeneralResultFaultTreeIllustrationPointEntityId) ON DELETE Set Null ON UPDATE Cascade, + CONSTRAINT U_ClosingStructuresCalculationEntity UNIQUE (ClosingStructuresCalculationEntityId) ) ; -CREATE TABLE 'DikeProfileEntity' +CREATE TABLE DikeProfileEntity ( - 'DikeProfileEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismEntityId' INTEGER NOT NULL, - 'Id' VARCHAR (260) NOT NULL, - 'Name' VARCHAR (260) NOT NULL, - 'Orientation' REAL NULL, - 'BreakWaterType' TINYINT (1) NULL, -- Enum: 1 = Wall 2 = Caisson 3 = Dam - 'BreakWaterHeight' REAL NULL, - 'ForeshoreXml' TEXT NOT NULL, - 'DikeGeometryXml' TEXT NOT NULL, - 'DikeHeight' REAL NULL, - 'X' REAL NULL, - 'Y' REAL NULL, - 'X0' REAL NULL, + DikeProfileEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + FailureMechanismEntityId INTEGER NOT NULL, + Id VARCHAR (260) NOT NULL, + Name VARCHAR (260) NOT NULL, + Orientation REAL NULL, + BreakWaterType TINYINT (1) NULL, -- Enum: 1 = Wall 2 = Caisson 3 = Dam + BreakWaterHeight REAL NULL, + ForeshoreXml TEXT NOT NULL COLLATE NOCASE, + DikeGeometryXml TEXT NOT NULL COLLATE NOCASE, + DikeHeight REAL NULL, + X REAL NULL, + Y REAL NULL, + X0 REAL NULL, 'Order' INT (4) NOT NULL, - CONSTRAINT 'FK_DikeProfileEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT 'UQ_DikeProfileEntity_IdFailureMechanismEntityId' UNIQUE ('Id','FailureMechanismEntityId') + CONSTRAINT FK_DikeProfileEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT UQ_DikeProfileEntity_IdFailureMechanismEntityId UNIQUE (Id,FailureMechanismEntityId) ) ; -CREATE TABLE 'DuneErosionFailureMechanismMetaEntity' +CREATE TABLE DuneErosionFailureMechanismMetaEntity ( - 'DuneErosionFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismEntityId' INTEGER NOT NULL, - 'N' REAL NOT NULL, - CONSTRAINT 'FK_DuneErosionFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade + DuneErosionFailureMechanismMetaEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + FailureMechanismEntityId INTEGER NOT NULL, + N REAL NOT NULL, + CONSTRAINT FK_DuneErosionFailureMechanismMetaEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; -CREATE TABLE 'DuneLocationCalculationEntity' +CREATE TABLE DuneLocationCalculationEntity ( - 'DuneLocationCalculationEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'DuneLocationEntityId' INTEGER NOT NULL, - 'DuneLocationCalculationForTargetProbabilityCollectionEntityId' INTEGER NOT NULL, - CONSTRAINT 'FK_DuneLocationCalculationEntity_DuneLocationCalculationCollectionEntity' FOREIGN KEY ('DuneLocationCalculationForTargetProbabilityCollectionEntityId') REFERENCES 'DuneLocationCalculationForTargetProbabilityCollectionEntity' ('DuneLocationCalculationCollectionEntityId') ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT 'FK_DuneLocationCalculationEntity_DuneLocationEntity' FOREIGN KEY ('DuneLocationEntityId') REFERENCES 'DuneLocationEntity' ('DuneLocationEntityId') ON DELETE Cascade ON UPDATE Cascade + DuneLocationCalculationEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + DuneLocationEntityId INTEGER NOT NULL, + DuneLocationCalculationForTargetProbabilityCollectionEntityId INTEGER NOT NULL, + CONSTRAINT FK_DuneLocationCalculationEntity_DuneLocationCalculationCollectionEntity FOREIGN KEY (DuneLocationCalculationForTargetProbabilityCollectionEntityId) REFERENCES DuneLocationCalculationForTargetProbabilityCollectionEntity (DuneLocationCalculationCollectionEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT FK_DuneLocationCalculationEntity_DuneLocationEntity FOREIGN KEY (DuneLocationEntityId) REFERENCES DuneLocationEntity (DuneLocationEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; -CREATE TABLE 'DuneLocationCalculationForTargetProbabilityCollectionEntity' +CREATE TABLE DuneLocationCalculationForTargetProbabilityCollectionEntity ( - 'DuneLocationCalculationCollectionEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'DuneErosionFailureMechanismMetaEntityId' INTEGER NOT NULL, + DuneLocationCalculationCollectionEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + DuneErosionFailureMechanismMetaEntityId INTEGER NOT NULL, 'Order' INT (4) NOT NULL, - 'TargetProbability' REAL NOT NULL, - CONSTRAINT 'FK_DuneLocationCalculationForTargetProbabilityCollectionEntity_DuneErosionFailureMechanismMetaEntity' FOREIGN KEY ('DuneErosionFailureMechanismMetaEntityId') REFERENCES 'DuneErosionFailureMechanismMetaEntity' ('DuneErosionFailureMechanismMetaEntityId') ON DELETE Cascade ON UPDATE Cascade + TargetProbability REAL NOT NULL, + CONSTRAINT FK_DuneLocationCalculationForTargetProbabilityCollectionEntity_DuneErosionFailureMechanismMetaEntity FOREIGN KEY (DuneErosionFailureMechanismMetaEntityId) REFERENCES DuneErosionFailureMechanismMetaEntity (DuneErosionFailureMechanismMetaEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; -CREATE TABLE 'DuneLocationCalculationOutputEntity' +CREATE TABLE DuneLocationCalculationOutputEntity ( - 'DuneLocationCalculationOutputEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'DuneLocationCalculationEntityId' INTEGER NOT NULL, - 'WaterLevel' REAL NULL, - 'WaveHeight' REAL NULL, - 'WavePeriod' REAL NULL, - 'MeanTidalAmplitude' REAL NULL, - 'WaveDirectionalSpread' REAL NULL, - 'TideSurgePhaseDifference' REAL NULL, - 'TargetProbability' REAL NULL, - 'TargetReliability' REAL NULL, - 'CalculatedProbability' REAL NULL, - 'CalculatedReliability' REAL NULL, - 'CalculationConvergence' TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated, 2 = CalculatedNotConverged, 3 = CalculatedConverged - CONSTRAINT 'FK_DuneLocationCalculationOutputEntity_DuneLocationCalculationEntity' FOREIGN KEY ('DuneLocationCalculationEntityId') REFERENCES 'DuneLocationCalculationEntity' ('DuneLocationCalculationEntityId') ON DELETE Cascade ON UPDATE Cascade + DuneLocationCalculationOutputEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + DuneLocationCalculationEntityId INTEGER NOT NULL, + WaterLevel REAL NULL, + WaveHeight REAL NULL, + WavePeriod REAL NULL, + MeanTidalAmplitude REAL NULL, + WaveDirectionalSpread REAL NULL, + TideSurgePhaseDifference REAL NULL, + TargetProbability REAL NULL, + TargetReliability REAL NULL, + CalculatedProbability REAL NULL, + CalculatedReliability REAL NULL, + CalculationConvergence TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated, 2 = CalculatedNotConverged, 3 = CalculatedConverged + CONSTRAINT FK_DuneLocationCalculationOutputEntity_DuneLocationCalculationEntity FOREIGN KEY (DuneLocationCalculationEntityId) REFERENCES DuneLocationCalculationEntity (DuneLocationCalculationEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; -CREATE TABLE 'DuneLocationEntity' +CREATE TABLE DuneLocationEntity ( - 'DuneLocationEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'HydraulicLocationEntityId' INTEGER NOT NULL, - 'FailureMechanismEntityId' INTEGER NOT NULL, - 'Name' VARCHAR (260) NOT NULL, - 'CoastalAreaId' INT (4) NOT NULL, + DuneLocationEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + HydraulicLocationEntityId INTEGER NOT NULL, + FailureMechanismEntityId INTEGER NOT NULL, + Name VARCHAR (260) NOT NULL, + CoastalAreaId INT (4) NOT NULL, 'Offset' REAL NULL, 'Order' INT (4) NOT NULL, - CONSTRAINT 'FK_DuneLocationEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT 'FK_DuneLocationEntity_HydraulicLocationEntity' FOREIGN KEY ('HydraulicLocationEntityId') REFERENCES 'HydraulicLocationEntity' ('HydraulicLocationEntityId') ON DELETE Cascade ON UPDATE Cascade + CONSTRAINT FK_DuneLocationEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT FK_DuneLocationEntity_HydraulicLocationEntity FOREIGN KEY (HydraulicLocationEntityId) REFERENCES HydraulicLocationEntity (HydraulicLocationEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; -CREATE TABLE 'FailureMechanismFailureMechanismSectionEntity' +CREATE TABLE FailureMechanismFailureMechanismSectionEntity ( - 'FailureMechanismEntityId' INTEGER NOT NULL, - 'FailureMechanismSectionEntityId' INTEGER NOT NULL, - CONSTRAINT 'PK_FailureMechanismFailureMechanismSectionEntity' PRIMARY KEY ('FailureMechanismSectionEntityId','FailureMechanismEntityId'), - CONSTRAINT 'FK_FailureMechanismFailureMechanismSectionEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT 'FK_FailureMechanismFailureMechanismSectionEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade + FailureMechanismEntityId INTEGER NOT NULL, + FailureMechanismSectionEntityId INTEGER NOT NULL, + CONSTRAINT PK_FailureMechanismFailureMechanismSectionEntity PRIMARY KEY (FailureMechanismSectionEntityId,FailureMechanismEntityId), + CONSTRAINT FK_FailureMechanismFailureMechanismSectionEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT FK_FailureMechanismFailureMechanismSectionEntity_FailureMechanismSectionEntity FOREIGN KEY (FailureMechanismSectionEntityId) REFERENCES FailureMechanismSectionEntity (FailureMechanismSectionEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; -CREATE TABLE 'FaultTreeIllustrationPointEntity' +CREATE TABLE FaultTreeIllustrationPointEntity ( - 'FaultTreeIllustrationPointEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'ParentFaultTreeIllustrationPointEntityId' INTEGER NULL, - 'Name' TEXT NOT NULL, - 'Beta' REAL NOT NULL, - 'CombinationType' TINYINT (1) NOT NULL, -- Enum: 1 = Or, 2 = And + FaultTreeIllustrationPointEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + ParentFaultTreeIllustrationPointEntityId INTEGER NULL, + Name TEXT NOT NULL COLLATE NOCASE, + Beta REAL NOT NULL, + CombinationType TINYINT (1) NOT NULL, -- Enum: 1 = Or, 2 = And 'Order' INT (4) NOT NULL, - CONSTRAINT 'FK_FaultTreeIllustrationPoint_FaultTreeIllustrationPoint' FOREIGN KEY ('ParentFaultTreeIllustrationPointEntityId') REFERENCES 'FaultTreeIllustrationPointEntity' ('FaultTreeIllustrationPointEntityId') ON DELETE Cascade ON UPDATE Cascade + CONSTRAINT FK_FaultTreeIllustrationPoint_FaultTreeIllustrationPoint FOREIGN KEY (ParentFaultTreeIllustrationPointEntityId) REFERENCES FaultTreeIllustrationPointEntity (FaultTreeIllustrationPointEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; -CREATE TABLE 'FaultTreeIllustrationPointStochastEntity' +CREATE TABLE FaultTreeIllustrationPointStochastEntity ( - 'FaultTreeIllustrationPointEntityId' INTEGER NOT NULL, - 'StochastEntityId' INTEGER NOT NULL, - CONSTRAINT 'PK_FaultTreeIllustrationPointStochastEntity' PRIMARY KEY ('FaultTreeIllustrationPointEntityId','StochastEntityId'), - CONSTRAINT 'FK_FaultTreeIllustrationPointStochastEntity_FaultTreeIllustrationPoint' FOREIGN KEY ('FaultTreeIllustrationPointEntityId') REFERENCES 'FaultTreeIllustrationPointEntity' ('FaultTreeIllustrationPointEntityId') ON DELETE No Action ON UPDATE No Action, - CONSTRAINT 'FK_FaultTreeIllustrationPointStochastEntity_StochastEntity' FOREIGN KEY ('StochastEntityId') REFERENCES 'StochastEntity' ('StochastEntityId') ON DELETE Cascade ON UPDATE Cascade + FaultTreeIllustrationPointEntityId INTEGER NOT NULL, + StochastEntityId INTEGER NOT NULL, + CONSTRAINT PK_FaultTreeIllustrationPointStochastEntity PRIMARY KEY (FaultTreeIllustrationPointEntityId,StochastEntityId), + CONSTRAINT FK_FaultTreeIllustrationPointStochastEntity_FaultTreeIllustrationPoint FOREIGN KEY (FaultTreeIllustrationPointEntityId) REFERENCES FaultTreeIllustrationPointEntity (FaultTreeIllustrationPointEntityId) ON DELETE No Action ON UPDATE No Action, + CONSTRAINT FK_FaultTreeIllustrationPointStochastEntity_StochastEntity FOREIGN KEY (StochastEntityId) REFERENCES StochastEntity (StochastEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; -CREATE TABLE 'FaultTreeSubmechanismIllustrationPointEntity' +CREATE TABLE FaultTreeSubmechanismIllustrationPointEntity ( - 'SubMechanismIllustrationPointEntityId' INTEGER NOT NULL, - 'FaultTreeIllustrationPointEntityId' INTEGER NOT NULL, - CONSTRAINT 'PK_FaultTreeSubMechanismIllustrationPointEntityId' PRIMARY KEY ('SubMechanismIllustrationPointEntityId','FaultTreeIllustrationPointEntityId'), - CONSTRAINT 'FK_FaultTreeIllustrationPointEntity_FaultTreeIllustrationPointEntity' FOREIGN KEY ('FaultTreeIllustrationPointEntityId') REFERENCES 'FaultTreeIllustrationPointEntity' ('FaultTreeIllustrationPointEntityId') ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT 'FK_FaultTreeIllustrationPointEntity_SubMechanismIllustrationPointEntity' FOREIGN KEY ('SubMechanismIllustrationPointEntityId') REFERENCES 'SubMechanismIllustrationPointEntity' ('SubMechanismIllustrationPointEntityId') ON DELETE Cascade ON UPDATE Cascade + SubMechanismIllustrationPointEntityId INTEGER NOT NULL, + FaultTreeIllustrationPointEntityId INTEGER NOT NULL, + CONSTRAINT PK_FaultTreeSubMechanismIllustrationPointEntityId PRIMARY KEY (SubMechanismIllustrationPointEntityId,FaultTreeIllustrationPointEntityId), + CONSTRAINT FK_FaultTreeIllustrationPointEntity_FaultTreeIllustrationPointEntity FOREIGN KEY (FaultTreeIllustrationPointEntityId) REFERENCES FaultTreeIllustrationPointEntity (FaultTreeIllustrationPointEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT FK_FaultTreeIllustrationPointEntity_SubMechanismIllustrationPointEntity FOREIGN KEY (SubMechanismIllustrationPointEntityId) REFERENCES SubMechanismIllustrationPointEntity (SubMechanismIllustrationPointEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; -CREATE TABLE 'ForeshoreProfileEntity' +CREATE TABLE ForeshoreProfileEntity ( - 'ForeshoreProfileEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismEntityId' INTEGER NOT NULL, - 'Id' VARCHAR (260) NOT NULL, - 'Name' VARCHAR (260) NOT NULL, - 'Orientation' REAL NULL, - 'BreakWaterType' TINYINT (1) NULL, -- Enum: 1 = Wall, 2 = Caisson, 3 = Dam - 'BreakWaterHeight' REAL NULL, - 'GeometryXml' TEXT NOT NULL, - 'X' REAL NULL, - 'Y' REAL NULL, - 'X0' REAL NULL, + ForeshoreProfileEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + FailureMechanismEntityId INTEGER NOT NULL, + Id VARCHAR (260) NOT NULL, + Name VARCHAR (260) NOT NULL, + Orientation REAL NULL, + BreakWaterType TINYINT (1) NULL, -- Enum: 1 = Wall, 2 = Caisson, 3 = Dam + BreakWaterHeight REAL NULL, + GeometryXml TEXT NOT NULL COLLATE NOCASE, + X REAL NULL, + Y REAL NULL, + X0 REAL NULL, 'Order' INT (4) NOT NULL, - CONSTRAINT 'FK_ForeshoreProfileEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT 'UQ_ForeshoreProfileEntity_IdFailureMechanismEntityId' UNIQUE ('Id','FailureMechanismEntityId') + CONSTRAINT FK_ForeshoreProfileEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT UQ_ForeshoreProfileEntity_IdFailureMechanismEntityId UNIQUE (Id,FailureMechanismEntityId) ) ; -CREATE TABLE 'GeneralResultFaultTreeIllustrationPointEntity' +CREATE TABLE GeneralResultFaultTreeIllustrationPointEntity ( - 'GeneralResultFaultTreeIllustrationPointEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'GoverningWindDirectionName' TEXT NOT NULL, - 'GoverningWindDirectionAngle' REAL NOT NULL + GeneralResultFaultTreeIllustrationPointEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + GoverningWindDirectionName TEXT NOT NULL COLLATE NOCASE, + GoverningWindDirectionAngle REAL NOT NULL ) ; -CREATE TABLE 'GeneralResultFaultTreeIllustrationPointStochastEntity' +CREATE TABLE GeneralResultFaultTreeIllustrationPointStochastEntity ( - 'GeneralResultFaultTreeIllustrationPointEntityId' INTEGER NOT NULL, - 'StochastEntityId' INTEGER NOT NULL, - CONSTRAINT 'PK_GeneralResultFaultTreeIllustrationPointStochastEntity' PRIMARY KEY ('GeneralResultFaultTreeIllustrationPointEntityId','StochastEntityId'), - CONSTRAINT 'FK_GeneralResultFaultTreeIllustrationPointStochastEntity_GeneralResultFaultTreeIllustrationPointEntity' FOREIGN KEY ('GeneralResultFaultTreeIllustrationPointEntityId') REFERENCES 'GeneralResultFaultTreeIllustrationPointEntity' ('GeneralResultFaultTreeIllustrationPointEntityId') ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT 'FK_GeneralResultFaultTreeIllustrationPointStochastEntity_StochastEntity' FOREIGN KEY ('StochastEntityId') REFERENCES 'StochastEntity' ('StochastEntityId') ON DELETE Cascade ON UPDATE Cascade + GeneralResultFaultTreeIllustrationPointEntityId INTEGER NOT NULL, + StochastEntityId INTEGER NOT NULL, + CONSTRAINT PK_GeneralResultFaultTreeIllustrationPointStochastEntity PRIMARY KEY (GeneralResultFaultTreeIllustrationPointEntityId,StochastEntityId), + CONSTRAINT FK_GeneralResultFaultTreeIllustrationPointStochastEntity_GeneralResultFaultTreeIllustrationPointEntity FOREIGN KEY (GeneralResultFaultTreeIllustrationPointEntityId) REFERENCES GeneralResultFaultTreeIllustrationPointEntity (GeneralResultFaultTreeIllustrationPointEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT FK_GeneralResultFaultTreeIllustrationPointStochastEntity_StochastEntity FOREIGN KEY (StochastEntityId) REFERENCES StochastEntity (StochastEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; -CREATE TABLE 'GeneralResultSubMechanismIllustrationPointEntity' +CREATE TABLE GeneralResultSubMechanismIllustrationPointEntity ( - 'GeneralResultSubMechanismIllustrationPointEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'GoverningWindDirectionName' TEXT NOT NULL, - 'GoverningWindDirectionAngle' REAL NOT NULL + GeneralResultSubMechanismIllustrationPointEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + GoverningWindDirectionName TEXT NOT NULL COLLATE NOCASE, + GoverningWindDirectionAngle REAL NOT NULL ) ; -CREATE TABLE 'GeneralResultSubMechanismIllustrationPointStochastEntity' +CREATE TABLE GeneralResultSubMechanismIllustrationPointStochastEntity ( - 'GeneralResultSubMechanismIllustrationPointEntityId' INTEGER NOT NULL, - 'StochastEntityId' INTEGER NOT NULL, - CONSTRAINT 'PK_GeneralResultSubMechanismIllustrationPointStochastEntity' PRIMARY KEY ('GeneralResultSubMechanismIllustrationPointEntityId','StochastEntityId'), - CONSTRAINT 'FK_GeneralResultSubMechanisIllustrationPointStochastEntity_GeneralResultSubMechanismIllustrationPointEntity' FOREIGN KEY ('GeneralResultSubMechanismIllustrationPointEntityId') REFERENCES 'GeneralResultSubMechanismIllustrationPointEntity' ('GeneralResultSubMechanismIllustrationPointEntityId') ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT 'FK_GeneralResultSubMechanismIllustrationPointStochastEntity_StochastEntity' FOREIGN KEY ('StochastEntityId') REFERENCES 'StochastEntity' ('StochastEntityId') ON DELETE Cascade ON UPDATE Cascade + GeneralResultSubMechanismIllustrationPointEntityId INTEGER NOT NULL, + StochastEntityId INTEGER NOT NULL, + CONSTRAINT PK_GeneralResultSubMechanismIllustrationPointStochastEntity PRIMARY KEY (GeneralResultSubMechanismIllustrationPointEntityId,StochastEntityId), + CONSTRAINT FK_GeneralResultSubMechanisIllustrationPointStochastEntity_GeneralResultSubMechanismIllustrationPointEntity FOREIGN KEY (GeneralResultSubMechanismIllustrationPointEntityId) REFERENCES GeneralResultSubMechanismIllustrationPointEntity (GeneralResultSubMechanismIllustrationPointEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT FK_GeneralResultSubMechanismIllustrationPointStochastEntity_StochastEntity FOREIGN KEY (StochastEntityId) REFERENCES StochastEntity (StochastEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; -CREATE TABLE 'GrassCoverErosionInwardsDikeHeightOutputEntity' +CREATE TABLE GrassCoverErosionInwardsDikeHeightOutputEntity ( - 'GrassCoverErosionInwardsDikeHeightOutputEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'GrassCoverErosionInwardsOutputEntityId' INTEGER NOT NULL, - 'GeneralResultFaultTreeIllustrationPointEntityId' INTEGER NULL, - 'DikeHeight' REAL NULL, - 'TargetProbability' REAL NULL, - 'TargetReliability' REAL NULL, - 'CalculatedProbability' REAL NULL, - 'CalculatedReliability' REAL NULL, - 'CalculationConvergence' TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated, 2 = CalculationNotConverged, 3 = CalculationConverged - CONSTRAINT 'FK_GrassCoverErosionInwardsDikeHeightOutputEntity_GeneralResultFaultTreeIllustrationPointEntity' FOREIGN KEY ('GeneralResultFaultTreeIllustrationPointEntityId') REFERENCES 'GeneralResultFaultTreeIllustrationPointEntity' ('GeneralResultFaultTreeIllustrationPointEntityId') ON DELETE Set Null ON UPDATE Cascade, - CONSTRAINT 'FK_GrassCoverErosionInwardsDikeHeightOutputEntity_GrassCoverErosionInwardsOutputEntity' FOREIGN KEY ('GrassCoverErosionInwardsOutputEntityId') REFERENCES 'GrassCoverErosionInwardsOutputEntity' ('GrassCoverErosionInwardsOutputEntityId') ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT 'U_GrassCoverErosionInwardsOutputEntity' UNIQUE ('GrassCoverErosionInwardsOutputEntityId') + GrassCoverErosionInwardsDikeHeightOutputEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + GrassCoverErosionInwardsOutputEntityId INTEGER NOT NULL, + GeneralResultFaultTreeIllustrationPointEntityId INTEGER NULL, + DikeHeight REAL NULL, + TargetProbability REAL NULL, + TargetReliability REAL NULL, + CalculatedProbability REAL NULL, + CalculatedReliability REAL NULL, + CalculationConvergence TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated, 2 = CalculationNotConverged, 3 = CalculationConverged + CONSTRAINT FK_GrassCoverErosionInwardsDikeHeightOutputEntity_GeneralResultFaultTreeIllustrationPointEntity FOREIGN KEY (GeneralResultFaultTreeIllustrationPointEntityId) REFERENCES GeneralResultFaultTreeIllustrationPointEntity (GeneralResultFaultTreeIllustrationPointEntityId) ON DELETE Set Null ON UPDATE Cascade, + CONSTRAINT FK_GrassCoverErosionInwardsDikeHeightOutputEntity_GrassCoverErosionInwardsOutputEntity FOREIGN KEY (GrassCoverErosionInwardsOutputEntityId) REFERENCES GrassCoverErosionInwardsOutputEntity (GrassCoverErosionInwardsOutputEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT U_GrassCoverErosionInwardsOutputEntity UNIQUE (GrassCoverErosionInwardsOutputEntityId) ) ; -CREATE TABLE 'GrassCoverErosionInwardsOutputEntity' +CREATE TABLE GrassCoverErosionInwardsOutputEntity ( - 'GrassCoverErosionInwardsOutputEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'GrassCoverErosionInwardsCalculationEntityId' INTEGER NOT NULL, - 'GeneralResultFaultTreeIllustrationPointEntityId' INTEGER NULL, + GrassCoverErosionInwardsOutputEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + GrassCoverErosionInwardsCalculationEntityId INTEGER NOT NULL, + GeneralResultFaultTreeIllustrationPointEntityId INTEGER NULL, 'Order' INT (4) NOT NULL, - 'IsOvertoppingDominant' TINYINT (1) NOT NULL, -- true or false - 'WaveHeight' REAL NULL, - 'Reliability' REAL NULL, - CONSTRAINT 'FK_GrassCoverErosionInwardsOutputEntity_GeneralResultFaultTreeIllustrationPointEntity' FOREIGN KEY ('GeneralResultFaultTreeIllustrationPointEntityId') REFERENCES 'GeneralResultFaultTreeIllustrationPointEntity' ('GeneralResultFaultTreeIllustrationPointEntityId') ON DELETE Set Null ON UPDATE Cascade, - CONSTRAINT 'FK_GrassCoverErosionInwardsOutputEntity_GrassCoverErosionInwardsCalculationEntity' FOREIGN KEY ('GrassCoverErosionInwardsCalculationEntityId') REFERENCES 'GrassCoverErosionInwardsCalculationEntity' ('GrassCoverErosionInwardsCalculationEntityId') ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT 'U_GrassCoverErosionInwardsCalculationEntity' UNIQUE ('GrassCoverErosionInwardsCalculationEntityId') + IsOvertoppingDominant TINYINT (1) NOT NULL, -- true or false + WaveHeight REAL NULL, + Reliability REAL NULL, + CONSTRAINT FK_GrassCoverErosionInwardsOutputEntity_GeneralResultFaultTreeIllustrationPointEntity FOREIGN KEY (GeneralResultFaultTreeIllustrationPointEntityId) REFERENCES GeneralResultFaultTreeIllustrationPointEntity (GeneralResultFaultTreeIllustrationPointEntityId) ON DELETE Set Null ON UPDATE Cascade, + CONSTRAINT FK_GrassCoverErosionInwardsOutputEntity_GrassCoverErosionInwardsCalculationEntity FOREIGN KEY (GrassCoverErosionInwardsCalculationEntityId) REFERENCES GrassCoverErosionInwardsCalculationEntity (GrassCoverErosionInwardsCalculationEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT U_GrassCoverErosionInwardsCalculationEntity UNIQUE (GrassCoverErosionInwardsCalculationEntityId) ) ; -CREATE TABLE 'GrassCoverErosionInwardsOvertoppingRateOutputEntity' +CREATE TABLE GrassCoverErosionInwardsOvertoppingRateOutputEntity ( - 'GrassCoverErosionInwardsOvertoppingRateOutputEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'GrassCoverErosionInwardsOutputEntityId' INTEGER NOT NULL, - 'GeneralResultFaultTreeIllustrationPointEntityId' INTEGER NULL, - 'OvertoppingRate' REAL NULL, - 'TargetProbability' REAL NULL, - 'TargetReliability' REAL NULL, - 'CalculatedProbability' REAL NULL, - 'CalculatedReliability' REAL NULL, - 'CalculationConvergence' TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated, 2 = CalculationNotConverged, 3 = CalculationConverged - CONSTRAINT 'FK_GrassCoverErosionInwardsOvertoppingRateOutputEntity_GeneralResultFaultTreeIllustrationPointEntity' FOREIGN KEY ('GeneralResultFaultTreeIllustrationPointEntityId') REFERENCES 'GeneralResultFaultTreeIllustrationPointEntity' ('GeneralResultFaultTreeIllustrationPointEntityId') ON DELETE Set Null ON UPDATE Cascade, - CONSTRAINT 'FK_GrassCoverErosionInwardsOvertoppingRateOutputEntity_GrassCoverErosionInwardsOutputEntity' FOREIGN KEY ('GrassCoverErosionInwardsOutputEntityId') REFERENCES 'GrassCoverErosionInwardsOutputEntity' ('GrassCoverErosionInwardsOutputEntityId') ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT 'U_GrassCoverErosionInwardsOutputEntity' UNIQUE ('GrassCoverErosionInwardsOutputEntityId') + GrassCoverErosionInwardsOvertoppingRateOutputEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + GrassCoverErosionInwardsOutputEntityId INTEGER NOT NULL, + GeneralResultFaultTreeIllustrationPointEntityId INTEGER NULL, + OvertoppingRate REAL NULL, + TargetProbability REAL NULL, + TargetReliability REAL NULL, + CalculatedProbability REAL NULL, + CalculatedReliability REAL NULL, + CalculationConvergence TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated, 2 = CalculationNotConverged, 3 = CalculationConverged + CONSTRAINT FK_GrassCoverErosionInwardsOvertoppingRateOutputEntity_GeneralResultFaultTreeIllustrationPointEntity FOREIGN KEY (GeneralResultFaultTreeIllustrationPointEntityId) REFERENCES GeneralResultFaultTreeIllustrationPointEntity (GeneralResultFaultTreeIllustrationPointEntityId) ON DELETE Set Null ON UPDATE Cascade, + CONSTRAINT FK_GrassCoverErosionInwardsOvertoppingRateOutputEntity_GrassCoverErosionInwardsOutputEntity FOREIGN KEY (GrassCoverErosionInwardsOutputEntityId) REFERENCES GrassCoverErosionInwardsOutputEntity (GrassCoverErosionInwardsOutputEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT U_GrassCoverErosionInwardsOutputEntity UNIQUE (GrassCoverErosionInwardsOutputEntityId) ) ; -CREATE TABLE 'GrassCoverErosionOutwardsWaveConditionsCalculationEntity' +CREATE TABLE GrassCoverErosionOutwardsWaveConditionsCalculationEntity ( - 'GrassCoverErosionOutwardsWaveConditionsCalculationEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'CalculationGroupEntityId' INTEGER NOT NULL, - 'ForeshoreProfileEntityId' INTEGER NULL, - 'HydraulicLocationEntityId' INTEGER NULL, - 'HydraulicLocationCalculationForTargetProbabilityCollectionEntityId' INTEGER NULL, + GrassCoverErosionOutwardsWaveConditionsCalculationEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + CalculationGroupEntityId INTEGER NOT NULL, + ForeshoreProfileEntityId INTEGER NULL, + HydraulicLocationEntityId INTEGER NULL, + HydraulicLocationCalculationForTargetProbabilityCollectionEntityId INTEGER NULL, 'Order' INT (4) NOT NULL, - 'Name' VARCHAR (260) NULL, - 'Comments' TEXT NULL, - 'UseBreakWater' TINYINT (1) NOT NULL, -- true or false - 'BreakWaterType' TINYINT (1) NOT NULL, -- Enum: 1 = Wall, 2 = Caisson, 3 = Dam - 'BreakWaterHeight' REAL NULL, - 'UseForeshore' TINYINT (1) NOT NULL, -- true or false - 'Orientation' REAL NULL, - 'UpperBoundaryRevetment' REAL NULL, - 'LowerBoundaryRevetment' REAL NULL, - 'UpperBoundaryWaterLevels' REAL NULL, - 'LowerBoundaryWaterLevels' REAL NULL, - 'StepSize' TINYINT (1) NOT NULL, -- Enum: 1 = 0.5, 2 = 1.0, 3 = 2.0 - 'CalculationType' TINYINT (1) NOT NULL, -- Enum: 1 = WaveRunUp 2 = WaveImpact 3 = WaveRunUpAndWaveImpact 4 = WaveImpactWithWaveDirection 5 = WaveRunUpAndWaveImpactWithWaveDirection 6 = All - 'WaterLevelType' TINYINT (1) NOT NULL, -- Enum: 1 = None, 2 = MaximumAllowableFloodingProbability, 3 = SignalFloodingProbability, 4 = UserDefinedTargetProbability - 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_HydraulicLocationCalculationForTargetProbabilityCollectionEntity' FOREIGN KEY ('HydraulicLocationCalculationForTargetProbabilityCollectionEntityId') REFERENCES 'HydraulicLocationCalculationForTargetProbabilityCollectionEntity' ('HydraulicLocationCalculationForTargetProbabilityCollectionEntityId') ON DELETE Set Null ON UPDATE Cascade, - CONSTRAINT 'FK_GrassCoverErosionOutwardsWaveConditionsCalculationEntity_HydraulicLocationEntity' FOREIGN KEY ('HydraulicLocationEntityId') REFERENCES 'HydraulicLocationEntity' ('HydraulicLocationEntityId') ON DELETE Set Null ON UPDATE Cascade + Name VARCHAR (260) NULL, + Comments TEXT NULL COLLATE NOCASE, + UseBreakWater TINYINT (1) NOT NULL, -- true or false + BreakWaterType TINYINT (1) NOT NULL, -- Enum: 1 = Wall, 2 = Caisson, 3 = Dam + BreakWaterHeight REAL NULL, + UseForeshore TINYINT (1) NOT NULL, -- true or false + Orientation REAL NULL, + UpperBoundaryRevetment REAL NULL, + LowerBoundaryRevetment REAL NULL, + UpperBoundaryWaterLevels REAL NULL, + LowerBoundaryWaterLevels REAL NULL, + StepSize TINYINT (1) NOT NULL, -- Enum: 1 = 0.5, 2 = 1.0, 3 = 2.0 + CalculationType TINYINT (1) NOT NULL, -- Enum: 1 = WaveRunUp 2 = WaveImpact 3 = WaveRunUpAndWaveImpact 4 = WaveImpactWithWaveDirection 5 = WaveRunUpAndWaveImpactWithWaveDirection 6 = All + WaterLevelType TINYINT (1) NOT NULL, -- Enum: 1 = None, 2 = MaximumAllowableFloodingProbability, 3 = SignalFloodingProbability, 4 = UserDefinedTargetProbability + 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_HydraulicLocationCalculationForTargetProbabilityCollectionEntity FOREIGN KEY (HydraulicLocationCalculationForTargetProbabilityCollectionEntityId) REFERENCES HydraulicLocationCalculationForTargetProbabilityCollectionEntity (HydraulicLocationCalculationForTargetProbabilityCollectionEntityId) ON DELETE Set Null ON UPDATE Cascade, + CONSTRAINT FK_GrassCoverErosionOutwardsWaveConditionsCalculationEntity_HydraulicLocationEntity FOREIGN KEY (HydraulicLocationEntityId) REFERENCES HydraulicLocationEntity (HydraulicLocationEntityId) ON DELETE Set Null ON UPDATE Cascade ) ; -CREATE TABLE 'GrassCoverErosionOutwardsWaveConditionsOutputEntity' +CREATE TABLE GrassCoverErosionOutwardsWaveConditionsOutputEntity ( - 'GrassCoverErosionOutwardsWaveConditionsOutputEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'GrassCoverErosionOutwardsWaveConditionsCalculationEntityId' INTEGER NOT NULL, + GrassCoverErosionOutwardsWaveConditionsOutputEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + GrassCoverErosionOutwardsWaveConditionsCalculationEntityId INTEGER NOT NULL, 'Order' INT (4) NOT NULL, - 'OutputType' TINYINT (1) NOT NULL, -- Enum: 1 = WaveRunUp 2 = WaveImpact 3 = WaveImpactWithWaveDirection - 'WaterLevel' REAL NULL, - 'WaveHeight' REAL NULL, - 'WavePeakPeriod' REAL NULL, - 'WaveAngle' REAL NULL, - 'WaveDirection' REAL NULL, - 'TargetProbability' REAL NULL, - 'TargetReliability' REAL NULL, - 'CalculatedProbability' REAL NULL, - 'CalculatedReliability' REAL NULL, - '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 + OutputType TINYINT (1) NOT NULL, -- Enum: 1 = WaveRunUp 2 = WaveImpact 3 = WaveImpactWithWaveDirection + WaterLevel REAL NULL, + WaveHeight REAL NULL, + WavePeakPeriod REAL NULL, + WaveAngle REAL NULL, + WaveDirection REAL NULL, + TargetProbability REAL NULL, + TargetReliability REAL NULL, + CalculatedProbability REAL NULL, + CalculatedReliability REAL NULL, + 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 ) ; -CREATE TABLE 'GrassCoverSlipOffOutwardsFailureMechanismMetaEntity' +CREATE TABLE GrassCoverSlipOffOutwardsFailureMechanismMetaEntity ( - 'GrassCoverSlipOffOutwardsFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismEntityId' INTEGER NOT NULL, - 'N' REAL NOT NULL, - 'ApplyLengthEffectInSection' TINYINT (1) NOT NULL, - CONSTRAINT 'FK_GrassCoverSlipOffOutwardsFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade + GrassCoverSlipOffOutwardsFailureMechanismMetaEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + FailureMechanismEntityId INTEGER NOT NULL, + N REAL NOT NULL, + ApplyLengthEffectInSection TINYINT (1) NOT NULL, + CONSTRAINT FK_GrassCoverSlipOffOutwardsFailureMechanismMetaEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; -CREATE TABLE 'HeightStructureEntity' +CREATE TABLE HeightStructureEntity ( - 'HeightStructureEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismEntityId' INTEGER NOT NULL, + HeightStructureEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + FailureMechanismEntityId INTEGER NOT NULL, 'Order' INT (4) NOT NULL, - 'Name' VARCHAR (260) NOT NULL, - 'Id' VARCHAR (260) NOT NULL, - 'X' REAL NULL, - 'Y' REAL NULL, - 'StructureNormalOrientation' REAL NULL, - 'LevelCrestStructureMean' REAL NULL, - 'LevelCrestStructureStandardDeviation' REAL NULL, - 'FlowWidthAtBottomProtectionMean' REAL NULL, - 'FlowWidthAtBottomProtectionStandardDeviation' REAL NULL, - 'CriticalOvertoppingDischargeMean' REAL NULL, - 'CriticalOvertoppingDischargeCoefficientOfVariation' REAL NULL, - 'WidthFlowAperturesMean' REAL NULL, - 'WidthFlowAperturesStandardDeviation' REAL NULL, - 'FailureProbabilityStructureWithErosion' REAL NULL, - 'StorageStructureAreaMean' REAL NULL, - 'StorageStructureAreaCoefficientOfVariation' REAL NULL, - 'AllowedLevelIncreaseStorageMean' REAL NULL, - 'AllowedLevelIncreaseStorageStandardDeviation' REAL NULL, - CONSTRAINT 'FK_HeightStructure_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT 'U_Id_FailureMechanismEntityId' UNIQUE ('FailureMechanismEntityId','Id') + Name VARCHAR (260) NOT NULL, + Id VARCHAR (260) NOT NULL, + X REAL NULL, + Y REAL NULL, + StructureNormalOrientation REAL NULL, + LevelCrestStructureMean REAL NULL, + LevelCrestStructureStandardDeviation REAL NULL, + FlowWidthAtBottomProtectionMean REAL NULL, + FlowWidthAtBottomProtectionStandardDeviation REAL NULL, + CriticalOvertoppingDischargeMean REAL NULL, + CriticalOvertoppingDischargeCoefficientOfVariation REAL NULL, + WidthFlowAperturesMean REAL NULL, + WidthFlowAperturesStandardDeviation REAL NULL, + FailureProbabilityStructureWithErosion REAL NULL, + StorageStructureAreaMean REAL NULL, + StorageStructureAreaCoefficientOfVariation REAL NULL, + AllowedLevelIncreaseStorageMean REAL NULL, + AllowedLevelIncreaseStorageStandardDeviation REAL NULL, + CONSTRAINT FK_HeightStructure_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT U_Id_FailureMechanismEntityId UNIQUE (FailureMechanismEntityId,Id) ) ; -CREATE TABLE 'HeightStructuresCalculationEntity' +CREATE TABLE HeightStructuresCalculationEntity ( - 'HeightStructuresCalculationEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'CalculationGroupEntityId' INTEGER NOT NULL, - 'HydraulicLocationEntityId' INTEGER NULL, - 'HeightStructureEntityId' INTEGER NULL, - 'ForeshoreProfileEntityId' INTEGER NULL, + HeightStructuresCalculationEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + CalculationGroupEntityId INTEGER NOT NULL, + HydraulicLocationEntityId INTEGER NULL, + HeightStructureEntityId INTEGER NULL, + ForeshoreProfileEntityId INTEGER NULL, 'Order' INT (4) NOT NULL, - 'Name' VARCHAR (260) NULL, - 'Comments' TEXT NULL, - 'ModelFactorSuperCriticalFlowMean' REAL NULL, - 'StructureNormalOrientation' REAL NULL, - 'AllowedLevelIncreaseStorageMean' REAL NULL, - 'AllowedLevelIncreaseStorageStandardDeviation' REAL NULL, - 'StorageStructureAreaMean' REAL NULL, - 'StorageStructureAreaCoefficientOfVariation' REAL NULL, - 'FlowWidthAtBottomProtectionMean' REAL NULL, - 'FlowWidthAtBottomProtectionStandardDeviation' REAL NULL, - 'CriticalOvertoppingDischargeMean' REAL NULL, - 'CriticalOvertoppingDischargeCoefficientOfVariation' REAL NULL, - 'FailureProbabilityStructureWithErosion' REAL NOT NULL, - 'WidthFlowAperturesMean' REAL NULL, - 'WidthFlowAperturesStandardDeviation' REAL NULL, - 'StormDurationMean' REAL NULL, - 'LevelCrestStructureMean' REAL NULL, - 'LevelCrestStructureStandardDeviation' REAL NULL, - 'DeviationWaveDirection' REAL NULL, - '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 NULL, - 'ShouldIllustrationPointsBeCalculated' TINYINT (1) NOT NULL, -- true or false - 'RelevantForScenario' TINYINT (1) NOT NULL, -- true or false - 'ScenarioContribution' REAL NOT NULL, - 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, - CONSTRAINT 'FK_HeightStructuresCalculationEntity_HeightStructureEntity' FOREIGN KEY ('HeightStructureEntityId') REFERENCES 'HeightStructureEntity' ('HeightStructureEntityId') ON DELETE Set Null ON UPDATE Cascade, - CONSTRAINT 'FK_HeightStructuresCalculationEntity_HydraulicLocationEntity' FOREIGN KEY ('HydraulicLocationEntityId') REFERENCES 'HydraulicLocationEntity' ('HydraulicLocationEntityId') ON DELETE Set Null ON UPDATE Cascade + Name VARCHAR (260) NULL, + Comments TEXT NULL COLLATE NOCASE, + ModelFactorSuperCriticalFlowMean REAL NULL, + StructureNormalOrientation REAL NULL, + AllowedLevelIncreaseStorageMean REAL NULL, + AllowedLevelIncreaseStorageStandardDeviation REAL NULL, + StorageStructureAreaMean REAL NULL, + StorageStructureAreaCoefficientOfVariation REAL NULL, + FlowWidthAtBottomProtectionMean REAL NULL, + FlowWidthAtBottomProtectionStandardDeviation REAL NULL, + CriticalOvertoppingDischargeMean REAL NULL, + CriticalOvertoppingDischargeCoefficientOfVariation REAL NULL, + FailureProbabilityStructureWithErosion REAL NOT NULL, + WidthFlowAperturesMean REAL NULL, + WidthFlowAperturesStandardDeviation REAL NULL, + StormDurationMean REAL NULL, + LevelCrestStructureMean REAL NULL, + LevelCrestStructureStandardDeviation REAL NULL, + DeviationWaveDirection REAL NULL, + 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 NULL, + ShouldIllustrationPointsBeCalculated TINYINT (1) NOT NULL, -- true or false + RelevantForScenario TINYINT (1) NOT NULL, -- true or false + ScenarioContribution REAL NOT NULL, + 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, + CONSTRAINT FK_HeightStructuresCalculationEntity_HeightStructureEntity FOREIGN KEY (HeightStructureEntityId) REFERENCES HeightStructureEntity (HeightStructureEntityId) ON DELETE Set Null ON UPDATE Cascade, + CONSTRAINT FK_HeightStructuresCalculationEntity_HydraulicLocationEntity FOREIGN KEY (HydraulicLocationEntityId) REFERENCES HydraulicLocationEntity (HydraulicLocationEntityId) ON DELETE Set Null ON UPDATE Cascade ) ; -CREATE TABLE 'HeightStructuresFailureMechanismMetaEntity' +CREATE TABLE HeightStructuresFailureMechanismMetaEntity ( - 'HeightStructuresFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismEntityId' INTEGER NOT NULL, - 'N' REAL NOT NULL, - 'HeightStructureCollectionSourcePath' TEXT NULL, - 'ForeshoreProfileCollectionSourcePath' TEXT NULL, - CONSTRAINT 'FK_HeightStructuresFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade + HeightStructuresFailureMechanismMetaEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + FailureMechanismEntityId INTEGER NOT NULL, + N REAL NOT NULL, + HeightStructureCollectionSourcePath TEXT NULL COLLATE NOCASE, + ForeshoreProfileCollectionSourcePath TEXT NULL COLLATE NOCASE, + CONSTRAINT FK_HeightStructuresFailureMechanismMetaEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; -CREATE TABLE 'HeightStructuresOutputEntity' +CREATE TABLE HeightStructuresOutputEntity ( - 'HeightStructuresOutputEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'HeightStructuresCalculationEntityId' INTEGER NOT NULL, - 'GeneralResultFaultTreeIllustrationPointEntityId' INTEGER NULL, - 'Reliability' REAL NULL, - CONSTRAINT 'FK_HeightStructuresOutputEntity_GeneralResultFaultTreeIllustrationPointEntity' FOREIGN KEY ('GeneralResultFaultTreeIllustrationPointEntityId') REFERENCES 'GeneralResultFaultTreeIllustrationPointEntity' ('GeneralResultFaultTreeIllustrationPointEntityId') ON DELETE Set Null ON UPDATE Cascade, - CONSTRAINT 'FK_HeightStructuresOutputEntity_HeightStructuresCalculationEntity' FOREIGN KEY ('HeightStructuresCalculationEntityId') REFERENCES 'HeightStructuresCalculationEntity' ('HeightStructuresCalculationEntityId') ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT 'U_HeightStructuresCalculationEntity' UNIQUE ('HeightStructuresCalculationEntityId') + HeightStructuresOutputEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + HeightStructuresCalculationEntityId INTEGER NOT NULL, + GeneralResultFaultTreeIllustrationPointEntityId INTEGER NULL, + Reliability REAL NULL, + CONSTRAINT FK_HeightStructuresOutputEntity_GeneralResultFaultTreeIllustrationPointEntity FOREIGN KEY (GeneralResultFaultTreeIllustrationPointEntityId) REFERENCES GeneralResultFaultTreeIllustrationPointEntity (GeneralResultFaultTreeIllustrationPointEntityId) ON DELETE Set Null ON UPDATE Cascade, + CONSTRAINT FK_HeightStructuresOutputEntity_HeightStructuresCalculationEntity FOREIGN KEY (HeightStructuresCalculationEntityId) REFERENCES HeightStructuresCalculationEntity (HeightStructuresCalculationEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT U_HeightStructuresCalculationEntity UNIQUE (HeightStructuresCalculationEntityId) ) ; -CREATE TABLE 'HydraulicBoundaryDatabaseEntity' +CREATE TABLE HydraulicBoundaryDatabaseEntity ( - 'HydraulicBoundaryDatabaseEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'HydraulicBoundaryDataEntityId' INTEGER NOT NULL, - 'Version' TEXT NOT NULL, - 'FilePath' TEXT NOT NULL, - 'UsePreprocessorClosure' TINYINT (1) NOT NULL, -- True or false + HydraulicBoundaryDatabaseEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + HydraulicBoundaryDataEntityId INTEGER NOT NULL, + Version TEXT NOT NULL COLLATE NOCASE, + FilePath TEXT NOT NULL COLLATE NOCASE, + UsePreprocessorClosure TINYINT (1) NOT NULL, -- True or false 'Order' INT (4) NOT NULL, - CONSTRAINT 'FK_HydraulicBoundaryDatabaseEntity_HydraulicBoundaryDataEntity' FOREIGN KEY ('HydraulicBoundaryDataEntityId') REFERENCES 'HydraulicBoundaryDataEntity' ('HydraulicBoundaryDataEntityId') ON DELETE Cascade ON UPDATE Cascade + CONSTRAINT FK_HydraulicBoundaryDatabaseEntity_HydraulicBoundaryDataEntity FOREIGN KEY (HydraulicBoundaryDataEntityId) REFERENCES HydraulicBoundaryDataEntity (HydraulicBoundaryDataEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; -CREATE TABLE 'HydraulicBoundaryDataEntity' +CREATE TABLE HydraulicBoundaryDataEntity ( - 'HydraulicBoundaryDataEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'AssessmentSectionEntityId' INTEGER NOT NULL, - 'HydraulicLocationConfigurationDatabaseFilePath' TEXT NOT NULL, - 'HydraulicLocationConfigurationDatabaseScenarioName' TEXT NOT NULL, - 'HydraulicLocationConfigurationDatabaseYear' INT (4) NOT NULL, - 'HydraulicLocationConfigurationDatabaseScope' TEXT NOT NULL, - 'HydraulicLocationConfigurationDatabaseSeaLevel' TEXT NULL, - 'HydraulicLocationConfigurationDatabaseRiverDischarge' TEXT NULL, - 'HydraulicLocationConfigurationDatabaseLakeLevel' TEXT NULL, - 'HydraulicLocationConfigurationDatabaseWindDirection' TEXT NULL, - 'HydraulicLocationConfigurationDatabaseWindSpeed' TEXT NULL, - 'HydraulicLocationConfigurationDatabaseComment' TEXT NULL, - CONSTRAINT 'FK_HydraulicBoundaryDatabaseEntity_AssessmentSectionEntity' FOREIGN KEY ('AssessmentSectionEntityId') REFERENCES 'AssessmentSectionEntity' ('AssessmentSectionEntityId') ON DELETE Cascade ON UPDATE Cascade + HydraulicBoundaryDataEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + AssessmentSectionEntityId INTEGER NOT NULL, + HydraulicLocationConfigurationDatabaseFilePath TEXT NOT NULL COLLATE NOCASE, + HydraulicLocationConfigurationDatabaseScenarioName TEXT NOT NULL COLLATE NOCASE, + HydraulicLocationConfigurationDatabaseYear INT (4) NOT NULL, + HydraulicLocationConfigurationDatabaseScope TEXT NOT NULL COLLATE NOCASE, + HydraulicLocationConfigurationDatabaseSeaLevel TEXT NULL COLLATE NOCASE, + HydraulicLocationConfigurationDatabaseRiverDischarge TEXT NULL COLLATE NOCASE, + HydraulicLocationConfigurationDatabaseLakeLevel TEXT NULL COLLATE NOCASE, + HydraulicLocationConfigurationDatabaseWindDirection TEXT NULL COLLATE NOCASE, + HydraulicLocationConfigurationDatabaseWindSpeed TEXT NULL COLLATE NOCASE, + HydraulicLocationConfigurationDatabaseComment TEXT NULL COLLATE NOCASE, + CONSTRAINT FK_HydraulicBoundaryDatabaseEntity_AssessmentSectionEntity FOREIGN KEY (AssessmentSectionEntityId) REFERENCES AssessmentSectionEntity (AssessmentSectionEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; -CREATE TABLE 'HydraulicLocationCalculationCollectionEntity' +CREATE TABLE HydraulicLocationCalculationCollectionEntity ( - 'HydraulicLocationCalculationCollectionEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT + HydraulicLocationCalculationCollectionEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT ) ; -CREATE TABLE 'HydraulicLocationCalculationCollectionHydraulicLocationCalculationEntity' +CREATE TABLE HydraulicLocationCalculationCollectionHydraulicLocationCalculationEntity ( - 'HydraulicLocationCalculationCollectionEntityId' INTEGER NOT NULL, - 'HydraulicLocationCalculationEntityId' INTEGER NOT NULL, - CONSTRAINT 'PK_HydraulicLocationCalculationCollectionHydraulicLocationCalculationEntity' PRIMARY KEY ('HydraulicLocationCalculationCollectionEntityId','HydraulicLocationCalculationEntityId'), - CONSTRAINT 'HydraulicLocationCalculationCollectionHydraulicLocationCalculationEntity_HydraulicLocationCalculationCollectionEntityId' FOREIGN KEY ('HydraulicLocationCalculationCollectionEntityId') REFERENCES 'HydraulicLocationCalculationCollectionEntity' ('HydraulicLocationCalculationCollectionEntityId') ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT 'HydraulicLocationCalculationEntityId' FOREIGN KEY ('HydraulicLocationCalculationEntityId') REFERENCES 'HydraulicLocationCalculationEntity' ('HydraulicLocationCalculationEntityId') ON DELETE Cascade ON UPDATE Cascade + HydraulicLocationCalculationCollectionEntityId INTEGER NOT NULL, + HydraulicLocationCalculationEntityId INTEGER NOT NULL, + CONSTRAINT PK_HydraulicLocationCalculationCollectionHydraulicLocationCalculationEntity PRIMARY KEY (HydraulicLocationCalculationCollectionEntityId,HydraulicLocationCalculationEntityId), + CONSTRAINT HydraulicLocationCalculationCollectionHydraulicLocationCalculationEntity_HydraulicLocationCalculationCollectionEntityId FOREIGN KEY (HydraulicLocationCalculationCollectionEntityId) REFERENCES HydraulicLocationCalculationCollectionEntity (HydraulicLocationCalculationCollectionEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT HydraulicLocationCalculationEntityId FOREIGN KEY (HydraulicLocationCalculationEntityId) REFERENCES HydraulicLocationCalculationEntity (HydraulicLocationCalculationEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; -CREATE TABLE 'HydraulicLocationCalculationEntity' +CREATE TABLE HydraulicLocationCalculationEntity ( - 'HydraulicLocationCalculationEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'HydraulicLocationEntityId' INTEGER NOT NULL, - 'ShouldIllustrationPointsBeCalculated' TINYINT (1) NOT NULL, -- True or false - CONSTRAINT 'FK_HydraulicLocationCalculationEntity_HydraulicLocationEntity' FOREIGN KEY ('HydraulicLocationEntityId') REFERENCES 'HydraulicLocationEntity' ('HydraulicLocationEntityId') ON DELETE Cascade ON UPDATE Cascade + HydraulicLocationCalculationEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + HydraulicLocationEntityId INTEGER NOT NULL, + ShouldIllustrationPointsBeCalculated TINYINT (1) NOT NULL, -- True or false + CONSTRAINT FK_HydraulicLocationCalculationEntity_HydraulicLocationEntity FOREIGN KEY (HydraulicLocationEntityId) REFERENCES HydraulicLocationEntity (HydraulicLocationEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; -CREATE TABLE 'HydraulicLocationCalculationForTargetProbabilityCollectionEntity' +CREATE TABLE HydraulicLocationCalculationForTargetProbabilityCollectionEntity ( - 'HydraulicLocationCalculationForTargetProbabilityCollectionEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'AssessmentSectionEntityId' INTEGER NOT NULL, + HydraulicLocationCalculationForTargetProbabilityCollectionEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + AssessmentSectionEntityId INTEGER NOT NULL, 'Order' INT (4) NOT NULL, - 'HydraulicBoundaryLocationCalculationType' TINYINT (1) NOT NULL, -- Enum: 1 = Waterlevel 2 = Waveheight - 'TargetProbability' REAL NOT NULL, - CONSTRAINT 'FK_HydraulicBoundaryLocationCalculationsForTargetProbabilityEntity_AssessmentSectionEntity' FOREIGN KEY ('AssessmentSectionEntityId') REFERENCES 'AssessmentSectionEntity' ('AssessmentSectionEntityId') ON DELETE Cascade ON UPDATE Cascade + HydraulicBoundaryLocationCalculationType TINYINT (1) NOT NULL, -- Enum: 1 = Waterlevel 2 = Waveheight + TargetProbability REAL NOT NULL, + CONSTRAINT FK_HydraulicBoundaryLocationCalculationsForTargetProbabilityEntity_AssessmentSectionEntity FOREIGN KEY (AssessmentSectionEntityId) REFERENCES AssessmentSectionEntity (AssessmentSectionEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; -CREATE TABLE 'HydraulicLocationCalculationForTargetProbabilityCollectionHydraulicLocationCalculationEntity' +CREATE TABLE HydraulicLocationCalculationForTargetProbabilityCollectionHydraulicLocationCalculationEntity ( - 'HydraulicLocationCalculationForTargetProbabilityCollectionEntityId' INTEGER NOT NULL, - 'HydraulicLocationCalculationEntityId' INTEGER NOT NULL, - CONSTRAINT 'PK_HydraulicBoundaryLocationCalculationsForTargetProbabilityHydraulicLocationCalculationEntity' PRIMARY KEY ('HydraulicLocationCalculationForTargetProbabilityCollectionEntityId','HydraulicLocationCalculationEntityId'), - CONSTRAINT 'HydraulicBoundaryLocationCalculationsForTargetProbabilityHydraulicLocationCalculationEntity_HydraulicBoundaryLocationCalculationsForTargetProbabilityEntityId' FOREIGN KEY ('HydraulicLocationCalculationForTargetProbabilityCollectionEntityId') REFERENCES 'HydraulicLocationCalculationForTargetProbabilityCollectionEntity' ('HydraulicLocationCalculationForTargetProbabilityCollectionEntityId') ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT 'HydraulicBoundaryLocationCalculationsForTargetProbabilityHydraulicLocationCalculationEntity_HydraulicLocationCalculationEntityId' FOREIGN KEY ('HydraulicLocationCalculationEntityId') REFERENCES 'HydraulicLocationCalculationEntity' ('HydraulicLocationCalculationEntityId') ON DELETE No Action ON UPDATE No Action + HydraulicLocationCalculationForTargetProbabilityCollectionEntityId INTEGER NOT NULL, + HydraulicLocationCalculationEntityId INTEGER NOT NULL, + CONSTRAINT PK_HydraulicBoundaryLocationCalculationsForTargetProbabilityHydraulicLocationCalculationEntity PRIMARY KEY (HydraulicLocationCalculationForTargetProbabilityCollectionEntityId,HydraulicLocationCalculationEntityId), + CONSTRAINT HydraulicBoundaryLocationCalculationsForTargetProbabilityHydraulicLocationCalculationEntity_HydraulicBoundaryLocationCalculationsForTargetProbabilityEntityId FOREIGN KEY (HydraulicLocationCalculationForTargetProbabilityCollectionEntityId) REFERENCES HydraulicLocationCalculationForTargetProbabilityCollectionEntity (HydraulicLocationCalculationForTargetProbabilityCollectionEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT HydraulicBoundaryLocationCalculationsForTargetProbabilityHydraulicLocationCalculationEntity_HydraulicLocationCalculationEntityId FOREIGN KEY (HydraulicLocationCalculationEntityId) REFERENCES HydraulicLocationCalculationEntity (HydraulicLocationCalculationEntityId) ON DELETE No Action ON UPDATE No Action ) ; -CREATE TABLE 'HydraulicLocationOutputEntity' +CREATE TABLE HydraulicLocationOutputEntity ( - 'HydraulicLocationOutputEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'HydraulicLocationCalculationEntityId' INTEGER NOT NULL, - 'GeneralResultSubMechanismIllustrationPointEntityId' INTEGER NULL, - 'Result' REAL NULL, - 'TargetProbability' REAL NULL, - 'TargetReliability' REAL NULL, - 'CalculatedProbability' REAL NULL, - 'CalculatedReliability' REAL NULL, - 'CalculationConvergence' TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated, 2 = CalculatedNotConverged, 3 = CalculatedConverged - CONSTRAINT 'FK_HydraulicLocationOutputEntity_GeneralResultSubMechanismIllustrationPointEntity' FOREIGN KEY ('GeneralResultSubMechanismIllustrationPointEntityId') REFERENCES 'GeneralResultSubMechanismIllustrationPointEntity' ('GeneralResultSubMechanismIllustrationPointEntityId') ON DELETE Set Null ON UPDATE Cascade, - CONSTRAINT 'FK_HydraulicLocationOutputEntity_HydraulicLocationCalculationEntity' FOREIGN KEY ('HydraulicLocationCalculationEntityId') REFERENCES 'HydraulicLocationCalculationEntity' ('HydraulicLocationCalculationEntityId') ON DELETE Set Null ON UPDATE Cascade + HydraulicLocationOutputEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + HydraulicLocationCalculationEntityId INTEGER NOT NULL, + GeneralResultSubMechanismIllustrationPointEntityId INTEGER NULL, + Result REAL NULL, + TargetProbability REAL NULL, + TargetReliability REAL NULL, + CalculatedProbability REAL NULL, + CalculatedReliability REAL NULL, + CalculationConvergence TINYINT (1) NOT NULL, -- Enum: 1 = NotCalculated, 2 = CalculatedNotConverged, 3 = CalculatedConverged + CONSTRAINT FK_HydraulicLocationOutputEntity_GeneralResultSubMechanismIllustrationPointEntity FOREIGN KEY (GeneralResultSubMechanismIllustrationPointEntityId) REFERENCES GeneralResultSubMechanismIllustrationPointEntity (GeneralResultSubMechanismIllustrationPointEntityId) ON DELETE Set Null ON UPDATE Cascade, + CONSTRAINT FK_HydraulicLocationOutputEntity_HydraulicLocationCalculationEntity FOREIGN KEY (HydraulicLocationCalculationEntityId) REFERENCES HydraulicLocationCalculationEntity (HydraulicLocationCalculationEntityId) ON DELETE Set Null ON UPDATE Cascade ) ; -CREATE TABLE 'IllustrationPointResultEntity' +CREATE TABLE IllustrationPointResultEntity ( - 'IllustrationPointResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'SubMechanismIllustrationPointEntityId' INTEGER NOT NULL, - 'Description' TEXT NOT NULL, - 'Unit' TEXT NOT NULL, - 'Value' REAL NOT NULL, + IllustrationPointResultEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + SubMechanismIllustrationPointEntityId INTEGER NOT NULL, + Description TEXT NOT NULL COLLATE NOCASE, + Unit TEXT NOT NULL COLLATE NOCASE, + Value REAL NOT NULL, 'Order' INT (4) NOT NULL, - CONSTRAINT 'FK_IllustrationPointResultEntity_SubMechanismIllustrationPointEntity' FOREIGN KEY ('SubMechanismIllustrationPointEntityId') REFERENCES 'SubMechanismIllustrationPointEntity' ('SubMechanismIllustrationPointEntityId') ON DELETE Cascade ON UPDATE Cascade + CONSTRAINT FK_IllustrationPointResultEntity_SubMechanismIllustrationPointEntity FOREIGN KEY (SubMechanismIllustrationPointEntityId) REFERENCES SubMechanismIllustrationPointEntity (SubMechanismIllustrationPointEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; -CREATE TABLE 'MacroStabilityInwardsCalculationEntity' +CREATE TABLE MacroStabilityInwardsCalculationEntity ( - 'MacroStabilityInwardsCalculationEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'CalculationGroupEntityId' INTEGER NOT NULL, - 'SurfaceLineEntityId' INTEGER NULL, - 'MacroStabilityInwardsStochasticSoilProfileEntityId' INTEGER NULL, - 'HydraulicLocationEntityId' INTEGER NULL, + MacroStabilityInwardsCalculationEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + CalculationGroupEntityId INTEGER NOT NULL, + SurfaceLineEntityId INTEGER NULL, + MacroStabilityInwardsStochasticSoilProfileEntityId INTEGER NULL, + HydraulicLocationEntityId INTEGER NULL, 'Order' INT (4) NOT NULL, - 'Name' VARCHAR (260) NULL, - 'Comment' TEXT NULL, - 'RelevantForScenario' TINYINT (1) NOT NULL, -- true or false - 'ScenarioContribution' REAL NOT NULL, - 'AssessmentLevel' REAL NULL, - 'UseAssessmentLevelManualInput' TINYINT (1) NOT NULL, -- true or false - 'SlipPlaneMinimumDepth' REAL NULL, - 'SlipPlaneMinimumLength' REAL NULL, - 'MaximumSliceWidth' REAL NULL, - 'MoveGrid' TINYINT (1) NOT NULL, -- true or false - 'GridDeterminationType' TINYINT (1) NOT NULL, -- Enumtype: 1 = Automatic, 2 = Manual - 'TangentLineDeterminationType' TINYINT (1) NOT NULL, -- Enumtype: 1 = Specified, 2 = LayerSeparated - 'TangentLineZTop' REAL NULL, - 'TangentLineZBottom' REAL NULL, - 'TangentLineNumber' INT (4) NOT NULL, - 'LeftGridXLeft' REAL NULL, - 'LeftGridXRight' REAL NULL, - 'LeftGridNrOfHorizontalPoints' INT (4) NOT NULL, - 'LeftGridZTop' REAL NULL, - 'LeftGridZBottom' REAL NULL, - 'LeftGridNrOfVerticalPoints' INT (4) NOT NULL, - 'RightGridXLeft' REAL NULL, - 'RightGridXRight' REAL NULL, - 'RightGridNrOfHorizontalPoints' INT (4) NOT NULL, - 'RightGridZTop' REAL NULL, - 'RightGridZBottom' REAL NULL, - 'RightGridNrOfVerticalPoints' INT (4) NOT NULL, - 'DikeSoilScenario' TINYINT (1) NOT NULL, -- Enumtype: 1 = ClayDikeOnClay, 2 = SandDikeOnClay, 3 = ClayDikeOnSand, 4 = SandDikeOnSand - 'WaterLevelRiverAverage' REAL NULL, - 'DrainageConstructionPresent' TINYINT (1) NOT NULL, -- true or false - 'DrainageConstructionCoordinateX' REAL NULL, - 'DrainageConstructionCoordinateZ' REAL NULL, - 'MinimumLevelPhreaticLineAtDikeTopRiver' REAL NULL, - 'MinimumLevelPhreaticLineAtDikeTopPolder' REAL NULL, - 'AdjustPhreaticLine3And4ForUplift' TINYINT (1) NOT NULL, -- true or false - 'LeakageLengthOutwardsPhreaticLine3' REAL NULL, - 'LeakageLengthInwardsPhreaticLine3' REAL NULL, - 'LeakageLengthOutwardsPhreaticLine4' REAL NULL, - 'LeakageLengthInwardsPhreaticLine4' REAL NULL, - 'PiezometricHeadPhreaticLine2Outwards' REAL NULL, - 'PiezometricHeadPhreaticLine2Inwards' REAL NULL, - 'LocationInputExtremeWaterLevelPolder' REAL NULL, - 'LocationInputExtremeUseDefaultOffsets' TINYINT (1) NOT NULL, -- true or false - 'LocationInputExtremePhreaticLineOffsetBelowDikeTopAtRiver' REAL NULL, - 'LocationInputExtremePhreaticLineOffsetBelowDikeTopAtPolder' REAL NULL, - 'LocationInputExtremePhreaticLineOffsetBelowShoulderBaseInside' REAL NULL, - 'LocationInputExtremePhreaticLineOffsetDikeToeAtPolder' REAL NULL, - 'LocationInputExtremePenetrationLength' REAL NULL, - 'LocationInputDailyWaterLevelPolder' REAL NULL, - 'LocationInputDailyUseDefaultOffsets' TINYINT (1) NOT NULL, -- true or false - 'LocationInputDailyPhreaticLineOffsetBelowDikeTopAtRiver' REAL NULL, - 'LocationInputDailyPhreaticLineOffsetBelowDikeTopAtPolder' REAL NULL, - 'LocationInputDailyPhreaticLineOffsetBelowShoulderBaseInside' REAL NULL, - 'LocationInputDailyPhreaticLineOffsetDikeToeAtPolder' REAL NULL, - 'CreateZones' TINYINT (1) NOT NULL, -- true or false - 'ZoningBoundariesDeterminationType' TINYINT (1) NOT NULL, -- Enumtype: 1 = Automatic 2 = Manual - 'ZoneBoundaryLeft' REAL NULL, - 'ZoneBoundaryRight' REAL NULL, - CONSTRAINT 'FK_MacroStabilityInwardsCalculationEntity_CalculationGroupEntity' FOREIGN KEY ('CalculationGroupEntityId') REFERENCES 'CalculationGroupEntity' ('CalculationGroupEntityId') ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT 'FK_MacroStabilityInwardsCalculationEntity_HydraulicLocationEntity' FOREIGN KEY ('HydraulicLocationEntityId') REFERENCES 'HydraulicLocationEntity' ('HydraulicLocationEntityId') ON DELETE Set Null ON UPDATE Cascade, - CONSTRAINT 'FK_MacroStabilityInwardsCalculationEntity_MacroStabilityInwardsStochasticSoilProfileEntity' FOREIGN KEY ('MacroStabilityInwardsStochasticSoilProfileEntityId') REFERENCES 'MacroStabilityInwardsStochasticSoilProfileEntity' ('MacroStabilityInwardsStochasticSoilProfileEntityId') ON DELETE Set Null ON UPDATE Cascade, - CONSTRAINT 'FK_MacroStabilityInwardsCalculationEntity_SurfaceLineEntity' FOREIGN KEY ('SurfaceLineEntityId') REFERENCES 'SurfaceLineEntity' ('SurfaceLineEntityId') ON DELETE Set Null ON UPDATE Cascade + Name VARCHAR (260) NULL, + Comment TEXT NULL COLLATE NOCASE, + RelevantForScenario TINYINT (1) NOT NULL, -- true or false + ScenarioContribution REAL NOT NULL, + AssessmentLevel REAL NULL, + UseAssessmentLevelManualInput TINYINT (1) NOT NULL, -- true or false + SlipPlaneMinimumDepth REAL NULL, + SlipPlaneMinimumLength REAL NULL, + MaximumSliceWidth REAL NULL, + MoveGrid TINYINT (1) NOT NULL, -- true or false + GridDeterminationType TINYINT (1) NOT NULL, -- Enumtype: 1 = Automatic, 2 = Manual + TangentLineDeterminationType TINYINT (1) NOT NULL, -- Enumtype: 1 = Specified, 2 = LayerSeparated + TangentLineZTop REAL NULL, + TangentLineZBottom REAL NULL, + TangentLineNumber INT (4) NOT NULL, + LeftGridXLeft REAL NULL, + LeftGridXRight REAL NULL, + LeftGridNrOfHorizontalPoints INT (4) NOT NULL, + LeftGridZTop REAL NULL, + LeftGridZBottom REAL NULL, + LeftGridNrOfVerticalPoints INT (4) NOT NULL, + RightGridXLeft REAL NULL, + RightGridXRight REAL NULL, + RightGridNrOfHorizontalPoints INT (4) NOT NULL, + RightGridZTop REAL NULL, + RightGridZBottom REAL NULL, + RightGridNrOfVerticalPoints INT (4) NOT NULL, + DikeSoilScenario TINYINT (1) NOT NULL, -- Enumtype: 1 = ClayDikeOnClay, 2 = SandDikeOnClay, 3 = ClayDikeOnSand, 4 = SandDikeOnSand + WaterLevelRiverAverage REAL NULL, + DrainageConstructionPresent TINYINT (1) NOT NULL, -- true or false + DrainageConstructionCoordinateX REAL NULL, + DrainageConstructionCoordinateZ REAL NULL, + MinimumLevelPhreaticLineAtDikeTopRiver REAL NULL, + MinimumLevelPhreaticLineAtDikeTopPolder REAL NULL, + AdjustPhreaticLine3And4ForUplift TINYINT (1) NOT NULL, -- true or false + LeakageLengthOutwardsPhreaticLine3 REAL NULL, + LeakageLengthInwardsPhreaticLine3 REAL NULL, + LeakageLengthOutwardsPhreaticLine4 REAL NULL, + LeakageLengthInwardsPhreaticLine4 REAL NULL, + PiezometricHeadPhreaticLine2Outwards REAL NULL, + PiezometricHeadPhreaticLine2Inwards REAL NULL, + LocationInputExtremeWaterLevelPolder REAL NULL, + LocationInputExtremeUseDefaultOffsets TINYINT (1) NOT NULL, -- true or false + LocationInputExtremePhreaticLineOffsetBelowDikeTopAtRiver REAL NULL, + LocationInputExtremePhreaticLineOffsetBelowDikeTopAtPolder REAL NULL, + LocationInputExtremePhreaticLineOffsetBelowShoulderBaseInside REAL NULL, + LocationInputExtremePhreaticLineOffsetDikeToeAtPolder REAL NULL, + LocationInputExtremePenetrationLength REAL NULL, + LocationInputDailyWaterLevelPolder REAL NULL, + LocationInputDailyUseDefaultOffsets TINYINT (1) NOT NULL, -- true or false + LocationInputDailyPhreaticLineOffsetBelowDikeTopAtRiver REAL NULL, + LocationInputDailyPhreaticLineOffsetBelowDikeTopAtPolder REAL NULL, + LocationInputDailyPhreaticLineOffsetBelowShoulderBaseInside REAL NULL, + LocationInputDailyPhreaticLineOffsetDikeToeAtPolder REAL NULL, + CreateZones TINYINT (1) NOT NULL, -- true or false + ZoningBoundariesDeterminationType TINYINT (1) NOT NULL, -- Enumtype: 1 = Automatic 2 = Manual + ZoneBoundaryLeft REAL NULL, + ZoneBoundaryRight REAL NULL, + CONSTRAINT FK_MacroStabilityInwardsCalculationEntity_CalculationGroupEntity FOREIGN KEY (CalculationGroupEntityId) REFERENCES CalculationGroupEntity (CalculationGroupEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT FK_MacroStabilityInwardsCalculationEntity_HydraulicLocationEntity FOREIGN KEY (HydraulicLocationEntityId) REFERENCES HydraulicLocationEntity (HydraulicLocationEntityId) ON DELETE Set Null ON UPDATE Cascade, + CONSTRAINT FK_MacroStabilityInwardsCalculationEntity_MacroStabilityInwardsStochasticSoilProfileEntity FOREIGN KEY (MacroStabilityInwardsStochasticSoilProfileEntityId) REFERENCES MacroStabilityInwardsStochasticSoilProfileEntity (MacroStabilityInwardsStochasticSoilProfileEntityId) ON DELETE Set Null ON UPDATE Cascade, + CONSTRAINT FK_MacroStabilityInwardsCalculationEntity_SurfaceLineEntity FOREIGN KEY (SurfaceLineEntityId) REFERENCES SurfaceLineEntity (SurfaceLineEntityId) ON DELETE Set Null ON UPDATE Cascade ) ; -CREATE TABLE 'MacroStabilityInwardsCalculationOutputEntity' +CREATE TABLE MacroStabilityInwardsCalculationOutputEntity ( - 'MacroStabilityInwardsCalculationOutputEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'MacroStabilityInwardsCalculationEntityId' INTEGER NOT NULL, - 'FactorOfStability' REAL NULL, - 'ForbiddenZonesXEntryMin' REAL NULL, - 'ForbiddenZonesXEntryMax' REAL NULL, - 'SlidingCurveLeftSlidingCircleCenterX' REAL NULL, - 'SlidingCurveLeftSlidingCircleCenterY' REAL NULL, - 'SlidingCurveLeftSlidingCircleRadius' REAL NULL, - 'SlidingCurveLeftSlidingCircleIsActive' TINYINT (1) NOT NULL, -- true or false - 'SlidingCurveLeftSlidingCircleNonIteratedForce' REAL NULL, - 'SlidingCurveLeftSlidingCircleIteratedForce' REAL NULL, - 'SlidingCurveLeftSlidingCircleDrivingMoment' REAL NULL, - 'SlidingCurveLeftSlidingCircleResistingMoment' REAL NULL, - 'SlidingCurveRightSlidingCircleCenterX' REAL NULL, - 'SlidingCurveRightSlidingCircleCenterY' REAL NULL, - 'SlidingCurveRightSlidingCircleRadius' REAL NULL, - 'SlidingCurveRightSlidingCircleIsActive' TINYINT (1) NOT NULL, -- true or false - 'SlidingCurveRightSlidingCircleNonIteratedForce' REAL NULL, - 'SlidingCurveRightSlidingCircleIteratedForce' REAL NULL, - 'SlidingCurveRightSlidingCircleDrivingMoment' REAL NULL, - 'SlidingCurveRightSlidingCircleResistingMoment' REAL NULL, - 'SlidingCurveNonIteratedHorizontalForce' REAL NULL, - 'SlidingCurveIteratedHorizontalForce' REAL NULL, - 'SlidingCurveSliceXML' TEXT NOT NULL, -- XML representation of MacroStabilityInwardsSlice - 'SlipPlaneLeftGridXLeft' REAL NULL, - 'SlipPlaneLeftGridXRight' REAL NULL, - 'SlipPlaneLeftGridNrOfHorizontalPoints' INT (4) NOT NULL, - 'SlipPlaneLeftGridZTop' REAL NULL, - 'SlipPlaneLeftGridZBottom' REAL NULL, - 'SlipPlaneLeftGridNrOfVerticalPoints' INT (4) NOT NULL, - 'SlipPlaneRightGridXLeft' REAL NULL, - 'SlipPlaneRightGridXRight' REAL NULL, - 'SlipPlaneRightGridNrOfHorizontalPoints' INT (4) NOT NULL, - 'SlipPlaneRightGridZTop' REAL NULL, - 'SlipPlaneRightGridZBottom' REAL NULL, - 'SlipPlaneRightGridNrOfVerticalPoints' INT (4) NOT NULL, - 'SlipPlaneTangentLinesXml' TEXT NOT NULL, -- XML representation of TangentLines - CONSTRAINT 'FK_MacroStabilityInwardsCalculationOutput_MacroStabilityInwardsCalculationEntity' FOREIGN KEY ('MacroStabilityInwardsCalculationEntityId') REFERENCES 'MacroStabilityInwardsCalculationEntity' ('MacroStabilityInwardsCalculationEntityId') ON DELETE Cascade ON UPDATE Cascade + MacroStabilityInwardsCalculationOutputEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + MacroStabilityInwardsCalculationEntityId INTEGER NOT NULL, + FactorOfStability REAL NULL, + ForbiddenZonesXEntryMin REAL NULL, + ForbiddenZonesXEntryMax REAL NULL, + SlidingCurveLeftSlidingCircleCenterX REAL NULL, + SlidingCurveLeftSlidingCircleCenterY REAL NULL, + SlidingCurveLeftSlidingCircleRadius REAL NULL, + SlidingCurveLeftSlidingCircleIsActive TINYINT (1) NOT NULL, -- true or false + SlidingCurveLeftSlidingCircleNonIteratedForce REAL NULL, + SlidingCurveLeftSlidingCircleIteratedForce REAL NULL, + SlidingCurveLeftSlidingCircleDrivingMoment REAL NULL, + SlidingCurveLeftSlidingCircleResistingMoment REAL NULL, + SlidingCurveRightSlidingCircleCenterX REAL NULL, + SlidingCurveRightSlidingCircleCenterY REAL NULL, + SlidingCurveRightSlidingCircleRadius REAL NULL, + SlidingCurveRightSlidingCircleIsActive TINYINT (1) NOT NULL, -- true or false + SlidingCurveRightSlidingCircleNonIteratedForce REAL NULL, + SlidingCurveRightSlidingCircleIteratedForce REAL NULL, + SlidingCurveRightSlidingCircleDrivingMoment REAL NULL, + SlidingCurveRightSlidingCircleResistingMoment REAL NULL, + SlidingCurveNonIteratedHorizontalForce REAL NULL, + SlidingCurveIteratedHorizontalForce REAL NULL, + SlidingCurveSliceXML TEXT NOT NULL COLLATE NOCASE, -- XML representation of MacroStabilityInwardsSlice + SlipPlaneLeftGridXLeft REAL NULL, + SlipPlaneLeftGridXRight REAL NULL, + SlipPlaneLeftGridNrOfHorizontalPoints INT (4) NOT NULL, + SlipPlaneLeftGridZTop REAL NULL, + SlipPlaneLeftGridZBottom REAL NULL, + SlipPlaneLeftGridNrOfVerticalPoints INT (4) NOT NULL, + SlipPlaneRightGridXLeft REAL NULL, + SlipPlaneRightGridXRight REAL NULL, + SlipPlaneRightGridNrOfHorizontalPoints INT (4) NOT NULL, + SlipPlaneRightGridZTop REAL NULL, + SlipPlaneRightGridZBottom REAL NULL, + SlipPlaneRightGridNrOfVerticalPoints INT (4) NOT NULL, + SlipPlaneTangentLinesXml TEXT NOT NULL COLLATE NOCASE, -- XML representation of TangentLines + CONSTRAINT FK_MacroStabilityInwardsCalculationOutput_MacroStabilityInwardsCalculationEntity FOREIGN KEY (MacroStabilityInwardsCalculationEntityId) REFERENCES MacroStabilityInwardsCalculationEntity (MacroStabilityInwardsCalculationEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; -CREATE TABLE 'MacroStabilityInwardsCharacteristicPointEntity' +CREATE TABLE MacroStabilityInwardsCharacteristicPointEntity ( - 'MacroStabilityInwardsCharacteristicPointEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'SurfaceLineEntityId' INTEGER NOT NULL, - 'Type' SMALLINT NOT NULL, -- Enumtype: 1 = SurfaceLevelOutside 2 = DikeTopAtRiver 3 = DikeToeAtRiver 4 = DikeTopAtPolder 5 = ShoulderBaseInside 6 = ShoulderTopInside 7 = DikeToeAtPolder 8 = DitchDikeSide 9 = BottomDitchDikeSide 10 = BottomDitchPolderSide 11 = DitchPolderSide 12 = SurfaceLevelInside - 'X' REAL NULL, - 'Y' REAL NULL, - 'Z' REAL NULL, - CONSTRAINT 'FK_MacroStabilityInwardsCharacteristicPointEntity_SurfaceLineEntity' FOREIGN KEY ('SurfaceLineEntityId') REFERENCES 'SurfaceLineEntity' ('SurfaceLineEntityId') ON DELETE Cascade ON UPDATE Cascade + MacroStabilityInwardsCharacteristicPointEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + SurfaceLineEntityId INTEGER NOT NULL, + Type SMALLINT NOT NULL, -- Enumtype: 1 = SurfaceLevelOutside 2 = DikeTopAtRiver 3 = DikeToeAtRiver 4 = DikeTopAtPolder 5 = ShoulderBaseInside 6 = ShoulderTopInside 7 = DikeToeAtPolder 8 = DitchDikeSide 9 = BottomDitchDikeSide 10 = BottomDitchPolderSide 11 = DitchPolderSide 12 = SurfaceLevelInside + X REAL NULL, + Y REAL NULL, + Z REAL NULL, + CONSTRAINT FK_MacroStabilityInwardsCharacteristicPointEntity_SurfaceLineEntity FOREIGN KEY (SurfaceLineEntityId) REFERENCES SurfaceLineEntity (SurfaceLineEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; -CREATE TABLE 'MacroStabilityInwardsFailureMechanismMetaEntity' +CREATE TABLE MacroStabilityInwardsFailureMechanismMetaEntity ( - 'MacroStabilityInwardsFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismEntityId' INTEGER NOT NULL, - 'A' REAL NOT NULL, - 'StochasticSoilModelCollectionSourcePath' TEXT NULL, - 'SurfaceLineCollectionSourcePath' TEXT NULL, - CONSTRAINT 'FK_MacroStabilityInwardsFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade + MacroStabilityInwardsFailureMechanismMetaEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + FailureMechanismEntityId INTEGER NOT NULL, + A REAL NOT NULL, + StochasticSoilModelCollectionSourcePath TEXT NULL COLLATE NOCASE, + SurfaceLineCollectionSourcePath TEXT NULL COLLATE NOCASE, + CONSTRAINT FK_MacroStabilityInwardsFailureMechanismMetaEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; -CREATE TABLE 'MacroStabilityInwardsPreconsolidationStressEntity' +CREATE TABLE MacroStabilityInwardsPreconsolidationStressEntity ( - 'MacroStabilityInwardsPreconsolidationStressEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'MacroStabilityInwardsSoilProfileTwoDEntityId' INTEGER NOT NULL, - 'CoordinateX' REAL NOT NULL, - 'CoordinateZ' REAL NOT NULL, - 'PreconsolidationStressMean' REAL NULL, - 'PreconsolidationStressCoefficientOfVariation' REAL NULL, + MacroStabilityInwardsPreconsolidationStressEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + MacroStabilityInwardsSoilProfileTwoDEntityId INTEGER NOT NULL, + CoordinateX REAL NOT NULL, + CoordinateZ REAL NOT NULL, + PreconsolidationStressMean REAL NULL, + PreconsolidationStressCoefficientOfVariation REAL NULL, 'Order' INT (4) NOT NULL, - CONSTRAINT 'FK_MacroStabilityInwardsPreconsolidationStressEntity_MacroStabilityInwardsSoilProfileTwoDEntity' FOREIGN KEY ('MacroStabilityInwardsSoilProfileTwoDEntityId') REFERENCES 'MacroStabilityInwardsSoilProfileTwoDEntity' ('MacroStabilityInwardsSoilProfileTwoDEntityId') ON DELETE Cascade ON UPDATE Cascade + CONSTRAINT FK_MacroStabilityInwardsPreconsolidationStressEntity_MacroStabilityInwardsSoilProfileTwoDEntity FOREIGN KEY (MacroStabilityInwardsSoilProfileTwoDEntityId) REFERENCES MacroStabilityInwardsSoilProfileTwoDEntity (MacroStabilityInwardsSoilProfileTwoDEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; -CREATE TABLE 'MacroStabilityInwardsSoilLayerOneDEntity' +CREATE TABLE MacroStabilityInwardsSoilLayerOneDEntity ( - 'MacroStabilityInwardsSoilLayerOneDEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'MacroStabilityInwardsSoilProfileOneDEntityId' INTEGER NOT NULL, - 'Top' REAL NULL, - 'IsAquifer' TINYINT (1) NOT NULL, -- true or false - 'Color' INTEGER NULL, -- ARGB value of Color. - 'MaterialName' TEXT NOT NULL, - 'ShearStrengthModel' TINYINT (1) NOT NULL, -- Enumtype: 1 = SuCalculated, 2 = CPhi, 3 = CPhiOrSuCalculated - 'UsePop' TINYINT (1) NOT NULL, -- true of false - 'AbovePhreaticLevelMean' REAL NULL, - 'AbovePhreaticLevelCoefficientOfVariation' REAL NULL, - 'AbovePhreaticLevelShift' REAL NULL, - 'BelowPhreaticLevelMean' REAL NULL, - 'BelowPhreaticLevelCoefficientOfVariation' REAL NULL, - 'BelowPhreaticLevelShift' REAL NULL, - 'CohesionMean' REAL NULL, - 'CohesionCoefficientOfVariation' REAL NULL, - 'FrictionAngleMean' REAL NULL, - 'FrictionAngleCoefficientOfVariation' REAL NULL, - 'ShearStrengthRatioMean' REAL NULL, - 'ShearStrengthRatioCoefficientOfVariation' REAL NULL, - 'StrengthIncreaseExponentMean' REAL NULL, - 'StrengthIncreaseExponentCoefficientOfVariation' REAL NULL, - 'PopMean' REAL NULL, - 'PopCoefficientOfVariation' REAL NULL, + MacroStabilityInwardsSoilLayerOneDEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + MacroStabilityInwardsSoilProfileOneDEntityId INTEGER NOT NULL, + Top REAL NULL, + IsAquifer TINYINT (1) NOT NULL, -- true or false + Color INTEGER NULL, -- ARGB value of Color. + MaterialName TEXT NOT NULL COLLATE NOCASE, + ShearStrengthModel TINYINT (1) NOT NULL, -- Enumtype: 1 = SuCalculated, 2 = CPhi, 3 = CPhiOrSuCalculated + UsePop TINYINT (1) NOT NULL, -- true of false + AbovePhreaticLevelMean REAL NULL, + AbovePhreaticLevelCoefficientOfVariation REAL NULL, + AbovePhreaticLevelShift REAL NULL, + BelowPhreaticLevelMean REAL NULL, + BelowPhreaticLevelCoefficientOfVariation REAL NULL, + BelowPhreaticLevelShift REAL NULL, + CohesionMean REAL NULL, + CohesionCoefficientOfVariation REAL NULL, + FrictionAngleMean REAL NULL, + FrictionAngleCoefficientOfVariation REAL NULL, + ShearStrengthRatioMean REAL NULL, + ShearStrengthRatioCoefficientOfVariation REAL NULL, + StrengthIncreaseExponentMean REAL NULL, + StrengthIncreaseExponentCoefficientOfVariation REAL NULL, + PopMean REAL NULL, + PopCoefficientOfVariation REAL NULL, 'Order' INT (4) NOT NULL, - CONSTRAINT 'FK_MacroStabilityInwardsSoilLayerOneDEntity_MacroStabilityInwardsSoilProfileOneDEntity' FOREIGN KEY ('MacroStabilityInwardsSoilProfileOneDEntityId') REFERENCES 'MacroStabilityInwardsSoilProfileOneDEntity' ('MacroStabilityInwardsSoilProfileOneDEntityId') ON DELETE Cascade ON UPDATE Cascade + CONSTRAINT FK_MacroStabilityInwardsSoilLayerOneDEntity_MacroStabilityInwardsSoilProfileOneDEntity FOREIGN KEY (MacroStabilityInwardsSoilProfileOneDEntityId) REFERENCES MacroStabilityInwardsSoilProfileOneDEntity (MacroStabilityInwardsSoilProfileOneDEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; -CREATE TABLE 'MacroStabilityInwardsSoilLayerTwoDEntity' +CREATE TABLE MacroStabilityInwardsSoilLayerTwoDEntity ( - 'MacroStabilityInwardsSoilLayerTwoDEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'ParentMacroStabilityInwardsSoilLayerTwoDEntityId' INTEGER NULL, - 'IsAquifer' TINYINT (1) NOT NULL, -- true or false - 'Color' INTEGER NULL, -- ARGB value of Color. - 'MaterialName' TEXT NOT NULL, - 'ShearStrengthModel' TINYINT (1) NOT NULL, -- Enumtype: 1 = SuCalculated, 2 = CPhi, 3 = CPhiOrSuCalculated - 'UsePop' TINYINT (1) NOT NULL, -- true of false - 'AbovePhreaticLevelMean' REAL NULL, - 'AbovePhreaticLevelCoefficientOfVariation' REAL NULL, - 'AbovePhreaticLevelShift' REAL NULL, - 'BelowPhreaticLevelMean' REAL NULL, - 'BelowPhreaticLevelCoefficientOfVariation' REAL NULL, - 'BelowPhreaticLevelShift' REAL NULL, - 'CohesionMean' REAL NULL, - 'CohesionCoefficientOfVariation' REAL NULL, - 'FrictionAngleMean' REAL NULL, - 'FrictionAngleCoefficientOfVariation' REAL NULL, - 'ShearStrengthRatioMean' REAL NULL, - 'ShearStrengthRatioCoefficientOfVariation' REAL NULL, - 'StrengthIncreaseExponentMean' REAL NULL, - 'StrengthIncreaseExponentCoefficientOfVariation' REAL NULL, - 'PopMean' REAL NULL, - 'PopCoefficientOfVariation' REAL NULL, - 'OuterRingXml' TEXT NOT NULL, + MacroStabilityInwardsSoilLayerTwoDEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + ParentMacroStabilityInwardsSoilLayerTwoDEntityId INTEGER NULL, + IsAquifer TINYINT (1) NOT NULL, -- true or false + Color INTEGER NULL, -- ARGB value of Color. + MaterialName TEXT NOT NULL COLLATE NOCASE, + ShearStrengthModel TINYINT (1) NOT NULL, -- Enumtype: 1 = SuCalculated, 2 = CPhi, 3 = CPhiOrSuCalculated + UsePop TINYINT (1) NOT NULL, -- true of false + AbovePhreaticLevelMean REAL NULL, + AbovePhreaticLevelCoefficientOfVariation REAL NULL, + AbovePhreaticLevelShift REAL NULL, + BelowPhreaticLevelMean REAL NULL, + BelowPhreaticLevelCoefficientOfVariation REAL NULL, + BelowPhreaticLevelShift REAL NULL, + CohesionMean REAL NULL, + CohesionCoefficientOfVariation REAL NULL, + FrictionAngleMean REAL NULL, + FrictionAngleCoefficientOfVariation REAL NULL, + ShearStrengthRatioMean REAL NULL, + ShearStrengthRatioCoefficientOfVariation REAL NULL, + StrengthIncreaseExponentMean REAL NULL, + StrengthIncreaseExponentCoefficientOfVariation REAL NULL, + PopMean REAL NULL, + PopCoefficientOfVariation REAL NULL, + OuterRingXml TEXT NOT NULL COLLATE NOCASE, 'Order' INT (4) NOT NULL, - CONSTRAINT 'FK_MacroStabilityInwardsSoilLayerTwoDEntity_MacroStabilityInwardsSoilLayerTwoDEntity' FOREIGN KEY ('ParentMacroStabilityInwardsSoilLayerTwoDEntityId') REFERENCES 'MacroStabilityInwardsSoilLayerTwoDEntity' ('MacroStabilityInwardsSoilLayerTwoDEntityId') ON DELETE Cascade ON UPDATE Cascade + CONSTRAINT FK_MacroStabilityInwardsSoilLayerTwoDEntity_MacroStabilityInwardsSoilLayerTwoDEntity FOREIGN KEY (ParentMacroStabilityInwardsSoilLayerTwoDEntityId) REFERENCES MacroStabilityInwardsSoilLayerTwoDEntity (MacroStabilityInwardsSoilLayerTwoDEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; -CREATE TABLE 'MacroStabilityInwardsSoilProfileOneDEntity' +CREATE TABLE MacroStabilityInwardsSoilProfileOneDEntity ( - 'MacroStabilityInwardsSoilProfileOneDEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'Name' TEXT NOT NULL, - 'Bottom' REAL NULL + MacroStabilityInwardsSoilProfileOneDEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + Name TEXT NOT NULL COLLATE NOCASE, + Bottom REAL NULL ) ; -CREATE TABLE 'MacroStabilityInwardsSoilProfileTwoDEntity' +CREATE TABLE MacroStabilityInwardsSoilProfileTwoDEntity ( - 'MacroStabilityInwardsSoilProfileTwoDEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'Name' TEXT NOT NULL + MacroStabilityInwardsSoilProfileTwoDEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + Name TEXT NOT NULL COLLATE NOCASE ) ; -CREATE TABLE 'MacroStabilityInwardsSoilProfileTwoDSoilLayerTwoDEntity' +CREATE TABLE MacroStabilityInwardsSoilProfileTwoDSoilLayerTwoDEntity ( - 'MacroStabilityInwardsSoilProfileTwoDEntityId' INTEGER NOT NULL, - 'MacroStabilityInwardsSoilLayerTwoDEntityId' INTEGER NOT NULL, - CONSTRAINT 'PK_MacroStabilityInwardsSoilProfileTwoDSoilLayerTwoDEntity' PRIMARY KEY ('MacroStabilityInwardsSoilProfileTwoDEntityId','MacroStabilityInwardsSoilLayerTwoDEntityId'), - CONSTRAINT 'FK_MacroStabilityInwardsSoilProfileTwoDSoilLayerTwoDEntity_MacroStabilityInwardsSoilLayerTwoDEntity' FOREIGN KEY ('MacroStabilityInwardsSoilLayerTwoDEntityId') REFERENCES 'MacroStabilityInwardsSoilLayerTwoDEntity' ('MacroStabilityInwardsSoilLayerTwoDEntityId') ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT 'FK_MacroStabilityInwardsSoilProfileTwoDSoilLayerTwoDEntity_MacroStabilityInwardsSoilProfileTwoDEntity' FOREIGN KEY ('MacroStabilityInwardsSoilProfileTwoDEntityId') REFERENCES 'MacroStabilityInwardsSoilProfileTwoDEntity' ('MacroStabilityInwardsSoilProfileTwoDEntityId') ON DELETE Cascade ON UPDATE Cascade + MacroStabilityInwardsSoilProfileTwoDEntityId INTEGER NOT NULL, + MacroStabilityInwardsSoilLayerTwoDEntityId INTEGER NOT NULL, + CONSTRAINT PK_MacroStabilityInwardsSoilProfileTwoDSoilLayerTwoDEntity PRIMARY KEY (MacroStabilityInwardsSoilProfileTwoDEntityId,MacroStabilityInwardsSoilLayerTwoDEntityId), + CONSTRAINT FK_MacroStabilityInwardsSoilProfileTwoDSoilLayerTwoDEntity_MacroStabilityInwardsSoilLayerTwoDEntity FOREIGN KEY (MacroStabilityInwardsSoilLayerTwoDEntityId) REFERENCES MacroStabilityInwardsSoilLayerTwoDEntity (MacroStabilityInwardsSoilLayerTwoDEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT FK_MacroStabilityInwardsSoilProfileTwoDSoilLayerTwoDEntity_MacroStabilityInwardsSoilProfileTwoDEntity FOREIGN KEY (MacroStabilityInwardsSoilProfileTwoDEntityId) REFERENCES MacroStabilityInwardsSoilProfileTwoDEntity (MacroStabilityInwardsSoilProfileTwoDEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; -CREATE TABLE 'MacroStabilityInwardsStochasticSoilProfileEntity' +CREATE TABLE MacroStabilityInwardsStochasticSoilProfileEntity ( - 'MacroStabilityInwardsStochasticSoilProfileEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'StochasticSoilModelEntityId' INTEGER NOT NULL, - 'MacroStabilityInwardsSoilProfileOneDEntityId' INTEGER NULL, - 'MacroStabilityInwardsSoilProfileTwoDEntityId' INTEGER NULL, - 'Probability' REAL NOT NULL, + MacroStabilityInwardsStochasticSoilProfileEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + StochasticSoilModelEntityId INTEGER NOT NULL, + MacroStabilityInwardsSoilProfileOneDEntityId INTEGER NULL, + MacroStabilityInwardsSoilProfileTwoDEntityId INTEGER NULL, + Probability REAL NOT NULL, 'Order' INT (4) NOT NULL, - CONSTRAINT 'FK_MacroStabilityInwardsStochasticSoilProfileEntity_MacroStabilityInwardsSoilProfileOneDEntity' FOREIGN KEY ('MacroStabilityInwardsSoilProfileOneDEntityId') REFERENCES 'MacroStabilityInwardsSoilProfileOneDEntity' ('MacroStabilityInwardsSoilProfileOneDEntityId') ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT 'FK_MacroStabilityInwardsStochasticSoilProfileEntity_MacroStabilityInwardsSoilProfileTwoDEntity' FOREIGN KEY ('MacroStabilityInwardsSoilProfileTwoDEntityId') REFERENCES 'MacroStabilityInwardsSoilProfileTwoDEntity' ('MacroStabilityInwardsSoilProfileTwoDEntityId') ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT 'FK_MacroStabilityInwardsStochasticSoilProfileEntity_StochasticSoilModelEntity' FOREIGN KEY ('StochasticSoilModelEntityId') REFERENCES 'StochasticSoilModelEntity' ('StochasticSoilModelEntityId') ON DELETE Cascade ON UPDATE Cascade + CONSTRAINT FK_MacroStabilityInwardsStochasticSoilProfileEntity_MacroStabilityInwardsSoilProfileOneDEntity FOREIGN KEY (MacroStabilityInwardsSoilProfileOneDEntityId) REFERENCES MacroStabilityInwardsSoilProfileOneDEntity (MacroStabilityInwardsSoilProfileOneDEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT FK_MacroStabilityInwardsStochasticSoilProfileEntity_MacroStabilityInwardsSoilProfileTwoDEntity FOREIGN KEY (MacroStabilityInwardsSoilProfileTwoDEntityId) REFERENCES MacroStabilityInwardsSoilProfileTwoDEntity (MacroStabilityInwardsSoilProfileTwoDEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT FK_MacroStabilityInwardsStochasticSoilProfileEntity_StochasticSoilModelEntity FOREIGN KEY (StochasticSoilModelEntityId) REFERENCES StochasticSoilModelEntity (StochasticSoilModelEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; -CREATE TABLE 'MicrostabilityFailureMechanismMetaEntity' +CREATE TABLE MicrostabilityFailureMechanismMetaEntity ( - 'MicrostabilityFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismEntityId' INTEGER NOT NULL, - 'N' REAL NOT NULL, - 'ApplyLengthEffectInSection' TINYINT (1) NOT NULL, - CONSTRAINT 'FK_MicrostabilityFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade + MicrostabilityFailureMechanismMetaEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + FailureMechanismEntityId INTEGER NOT NULL, + N REAL NOT NULL, + ApplyLengthEffectInSection TINYINT (1) NOT NULL, + CONSTRAINT FK_MicrostabilityFailureMechanismMetaEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; -CREATE TABLE 'NonAdoptableFailureMechanismSectionResultEntity' +CREATE TABLE NonAdoptableFailureMechanismSectionResultEntity ( - 'NonAdoptableFailureMechanismSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismSectionEntityId' INTEGER NOT NULL, - 'IsRelevant' TINYINT (1) NOT NULL, -- true or false - 'InitialFailureMechanismResultType' TINYINT (1) NOT NULL, -- Enum: Manual = 1, NoFailureProbability = 2 - 'ManualInitialFailureMechanismResultSectionProbability' REAL NULL, - 'FurtherAnalysisType' TINYINT (1) NOT NULL, -- Enum: NotNecessary = 1 Necessary = 2 Executed = 3 - 'RefinedSectionProbability' REAL NULL, - CONSTRAINT 'FK_NonAdoptableFailureMechanismSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade + NonAdoptableFailureMechanismSectionResultEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + FailureMechanismSectionEntityId INTEGER NOT NULL, + IsRelevant TINYINT (1) NOT NULL, -- true or false + InitialFailureMechanismResultType TINYINT (1) NOT NULL, -- Enum: Manual = 1, NoFailureProbability = 2 + ManualInitialFailureMechanismResultSectionProbability REAL NULL, + FurtherAnalysisType TINYINT (1) NOT NULL, -- Enum: NotNecessary = 1 Necessary = 2 Executed = 3 + RefinedSectionProbability REAL NULL, + CONSTRAINT FK_NonAdoptableFailureMechanismSectionResultEntity_FailureMechanismSectionEntity FOREIGN KEY (FailureMechanismSectionEntityId) REFERENCES FailureMechanismSectionEntity (FailureMechanismSectionEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; -CREATE TABLE 'NonAdoptableWithProfileProbabilityFailureMechanismSectionResultEntity' +CREATE TABLE NonAdoptableWithProfileProbabilityFailureMechanismSectionResultEntity ( - 'NonAdoptableWithProfileProbabilityFailureMechanismSectionResultEntity' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismSectionEntityId' INTEGER NULL, - 'IsRelevant' TINYINT (1) NOT NULL, -- true or false - 'InitialFailureMechanismResultType' TINYINT (1) NOT NULL, -- Enum: Manual = 1 NoFailureProbability = 2 - 'ManualInitialFailureMechanismResultSectionProbability' REAL NULL, - 'ManualInitialFailureMechanismResultProfileProbability' REAL NULL, - 'FurtherAnalysisType' TINYINT (1) NOT NULL, -- Enum: NotNecessary = 1 Necessary = 2 Executed = 3 - 'RefinedSectionProbability' REAL NULL, - 'RefinedProfileProbability' REAL NULL, - CONSTRAINT 'FK_NonAdoptableWithProfileProbabilityFailureMechanismSectionResultEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade + NonAdoptableWithProfileProbabilityFailureMechanismSectionResultEntity INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + FailureMechanismSectionEntityId INTEGER NULL, + IsRelevant TINYINT (1) NOT NULL, -- true or false + InitialFailureMechanismResultType TINYINT (1) NOT NULL, -- Enum: Manual = 1 NoFailureProbability = 2 + ManualInitialFailureMechanismResultSectionProbability REAL NULL, + ManualInitialFailureMechanismResultProfileProbability REAL NULL, + FurtherAnalysisType TINYINT (1) NOT NULL, -- Enum: NotNecessary = 1 Necessary = 2 Executed = 3 + RefinedSectionProbability REAL NULL, + RefinedProfileProbability REAL NULL, + CONSTRAINT FK_NonAdoptableWithProfileProbabilityFailureMechanismSectionResultEntity_FailureMechanismSectionEntity FOREIGN KEY (FailureMechanismSectionEntityId) REFERENCES FailureMechanismSectionEntity (FailureMechanismSectionEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; -CREATE TABLE 'PipingFailureMechanismMetaEntity' +CREATE TABLE PipingFailureMechanismMetaEntity ( - 'PipingFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismEntityId' INTEGER NOT NULL, - 'A' REAL NOT NULL, - 'WaterVolumetricWeight' REAL NOT NULL, - 'StochasticSoilModelCollectionSourcePath' TEXT NULL, - 'SurfaceLineCollectionSourcePath' TEXT NULL, - 'PipingScenarioConfigurationType' TINYINT (1) NOT NULL, -- Enum: SemiProbabilistic = 1 Probabilistic = 2 PerFailureMechanismSection = 3 - CONSTRAINT 'FK_PipingFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade + PipingFailureMechanismMetaEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + FailureMechanismEntityId INTEGER NOT NULL, + A REAL NOT NULL, + WaterVolumetricWeight REAL NOT NULL, + StochasticSoilModelCollectionSourcePath TEXT NULL COLLATE NOCASE, + SurfaceLineCollectionSourcePath TEXT NULL COLLATE NOCASE, + PipingScenarioConfigurationType TINYINT (1) NOT NULL, -- Enum: SemiProbabilistic = 1 Probabilistic = 2 PerFailureMechanismSection = 3 + CONSTRAINT FK_PipingFailureMechanismMetaEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; -CREATE TABLE 'PipingStructureFailureMechanismMetaEntity' +CREATE TABLE PipingStructureFailureMechanismMetaEntity ( - 'PipingStructureFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismEntityId' INTEGER NOT NULL, - 'N' REAL NOT NULL, - CONSTRAINT 'FK_PipingStructureFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade + PipingStructureFailureMechanismMetaEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + FailureMechanismEntityId INTEGER NOT NULL, + N REAL NOT NULL, + CONSTRAINT FK_PipingStructureFailureMechanismMetaEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; -CREATE TABLE 'ProbabilisticPipingCalculationEntity' +CREATE TABLE ProbabilisticPipingCalculationEntity ( - 'ProbabilisticPipingCalculationEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'CalculationGroupEntityId' INTEGER NOT NULL, - 'SurfaceLineEntityId' INTEGER NULL, - 'PipingStochasticSoilProfileEntityId' INTEGER NULL, - 'HydraulicLocationEntityId' INTEGER NULL, + ProbabilisticPipingCalculationEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + CalculationGroupEntityId INTEGER NOT NULL, + SurfaceLineEntityId INTEGER NULL, + PipingStochasticSoilProfileEntityId INTEGER NULL, + HydraulicLocationEntityId INTEGER NULL, 'Order' INT (4) NOT NULL, - 'Name' VARCHAR (260) NULL, - 'Comments' TEXT NULL, - 'EntryPointL' REAL NULL, - 'ExitPointL' REAL NULL, - 'PhreaticLevelExitMean' REAL NULL, - 'PhreaticLevelExitStandardDeviation' REAL NULL, - 'DampingFactorExitMean' REAL NULL, - 'DampingFactorExitStandardDeviation' REAL NULL, - 'RelevantForScenario' TINYINT (1) NOT NULL, -- true or false - 'ScenarioContribution' REAL NOT NULL, - 'ShouldProfileSpecificIllustrationPointsBeCalculated' TINYINT (1) NOT NULL, -- true or false - 'ShouldSectionSpecificIllustrationPointsBeCalculated' TINYINT (1) NOT NULL, -- true or false - CONSTRAINT 'FK_ProbabilisticPipingCalculationEntity_CalculationGroupEntity' FOREIGN KEY ('CalculationGroupEntityId') REFERENCES 'CalculationGroupEntity' ('CalculationGroupEntityId') ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT 'FK_ProbabilisticPipingCalculationEntity_HydraulicLocationEntity' FOREIGN KEY ('HydraulicLocationEntityId') REFERENCES 'HydraulicLocationEntity' ('HydraulicLocationEntityId') ON DELETE Set Null ON UPDATE Cascade, - CONSTRAINT 'FK_ProbabilisticPipingCalculationEntity_PipingStochasticSoilProfileEntity' FOREIGN KEY ('PipingStochasticSoilProfileEntityId') REFERENCES 'PipingStochasticSoilProfileEntity' ('PipingStochasticSoilProfileEntityId') ON DELETE Set Null ON UPDATE Cascade, - CONSTRAINT 'FK_ProbabilisticPipingCalculationEntity_SurfaceLineEntity' FOREIGN KEY ('SurfaceLineEntityId') REFERENCES 'SurfaceLineEntity' ('SurfaceLineEntityId') ON DELETE Set Null ON UPDATE Cascade + Name VARCHAR (260) NULL, + Comments TEXT NULL COLLATE NOCASE, + EntryPointL REAL NULL, + ExitPointL REAL NULL, + PhreaticLevelExitMean REAL NULL, + PhreaticLevelExitStandardDeviation REAL NULL, + DampingFactorExitMean REAL NULL, + DampingFactorExitStandardDeviation REAL NULL, + RelevantForScenario TINYINT (1) NOT NULL, -- true or false + ScenarioContribution REAL NOT NULL, + ShouldProfileSpecificIllustrationPointsBeCalculated TINYINT (1) NOT NULL, -- true or false + ShouldSectionSpecificIllustrationPointsBeCalculated TINYINT (1) NOT NULL, -- true or false + CONSTRAINT FK_ProbabilisticPipingCalculationEntity_CalculationGroupEntity FOREIGN KEY (CalculationGroupEntityId) REFERENCES CalculationGroupEntity (CalculationGroupEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT FK_ProbabilisticPipingCalculationEntity_HydraulicLocationEntity FOREIGN KEY (HydraulicLocationEntityId) REFERENCES HydraulicLocationEntity (HydraulicLocationEntityId) ON DELETE Set Null ON UPDATE Cascade, + CONSTRAINT FK_ProbabilisticPipingCalculationEntity_PipingStochasticSoilProfileEntity FOREIGN KEY (PipingStochasticSoilProfileEntityId) REFERENCES PipingStochasticSoilProfileEntity (PipingStochasticSoilProfileEntityId) ON DELETE Set Null ON UPDATE Cascade, + CONSTRAINT FK_ProbabilisticPipingCalculationEntity_SurfaceLineEntity FOREIGN KEY (SurfaceLineEntityId) REFERENCES SurfaceLineEntity (SurfaceLineEntityId) ON DELETE Set Null ON UPDATE Cascade ) ; -CREATE TABLE 'ProbabilisticPipingCalculationOutputEntity' +CREATE TABLE ProbabilisticPipingCalculationOutputEntity ( - 'ProbabilisticPipingCalculationOutputEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'ProbabilisticPipingCalculationEntityId' INTEGER NOT NULL, - 'ProfileSpecificGeneralResultFaultTreeIllustrationPointEntityId' INTEGER NULL, - 'SectionSpecificGeneralResultFaultTreeIllustrationPointEntityId' INTEGER NULL, - 'ProfileSpecificGeneralResultSubMechanismIllustrationPointEntityId' INTEGER NULL, - 'SectionSpecificGeneralResultSubMechanismIllustrationPointEntityId' INTEGER NULL, + ProbabilisticPipingCalculationOutputEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + ProbabilisticPipingCalculationEntityId INTEGER NOT NULL, + ProfileSpecificGeneralResultFaultTreeIllustrationPointEntityId INTEGER NULL, + SectionSpecificGeneralResultFaultTreeIllustrationPointEntityId INTEGER NULL, + ProfileSpecificGeneralResultSubMechanismIllustrationPointEntityId INTEGER NULL, + SectionSpecificGeneralResultSubMechanismIllustrationPointEntityId INTEGER NULL, 'Order' INT (4) NOT NULL, - 'ProfileSpecificReliability' REAL NULL, - 'SectionSpecificReliability' REAL NULL, - CONSTRAINT 'FK_ProbabilisticPipingCalculationOutputEntity_ProbabilisticPipingCalculationEntity' FOREIGN KEY ('ProbabilisticPipingCalculationEntityId') REFERENCES 'ProbabilisticPipingCalculationEntity' ('ProbabilisticPipingCalculationEntityId') ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT 'FK_ProbabilisticPipingCalculationOutputEntity_Profile_GeneralResultFaultTreeIllustrationPointEntity' FOREIGN KEY ('ProfileSpecificGeneralResultFaultTreeIllustrationPointEntityId') REFERENCES 'GeneralResultFaultTreeIllustrationPointEntity' ('GeneralResultFaultTreeIllustrationPointEntityId') ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT 'FK_ProbabilisticPipingCalculationOutputEntity_Profile_GeneralResultSubMechanismIllustrationPointEntity' FOREIGN KEY ('ProfileSpecificGeneralResultSubMechanismIllustrationPointEntityId') REFERENCES 'GeneralResultSubMechanismIllustrationPointEntity' ('GeneralResultSubMechanismIllustrationPointEntityId') ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT 'FK_ProbabilisticPipingCalculationOutputEntity_Section_GeneralResultFaultTreeIllustrationPointEntity' FOREIGN KEY ('SectionSpecificGeneralResultFaultTreeIllustrationPointEntityId') REFERENCES 'GeneralResultFaultTreeIllustrationPointEntity' ('GeneralResultFaultTreeIllustrationPointEntityId') ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT 'FK_ProbabilisticPipingCalculationOutputEntity_Section_GeneralResultSubMechanismIllustrationPointEntity' FOREIGN KEY ('SectionSpecificGeneralResultSubMechanismIllustrationPointEntityId') REFERENCES 'GeneralResultSubMechanismIllustrationPointEntity' ('GeneralResultSubMechanismIllustrationPointEntityId') ON DELETE No Action ON UPDATE No Action, - CONSTRAINT 'U_ProbabilisticPipingCalculationEntity' UNIQUE ('ProbabilisticPipingCalculationEntityId') + ProfileSpecificReliability REAL NULL, + SectionSpecificReliability REAL NULL, + CONSTRAINT FK_ProbabilisticPipingCalculationOutputEntity_ProbabilisticPipingCalculationEntity FOREIGN KEY (ProbabilisticPipingCalculationEntityId) REFERENCES ProbabilisticPipingCalculationEntity (ProbabilisticPipingCalculationEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT FK_ProbabilisticPipingCalculationOutputEntity_Profile_GeneralResultFaultTreeIllustrationPointEntity FOREIGN KEY (ProfileSpecificGeneralResultFaultTreeIllustrationPointEntityId) REFERENCES GeneralResultFaultTreeIllustrationPointEntity (GeneralResultFaultTreeIllustrationPointEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT FK_ProbabilisticPipingCalculationOutputEntity_Profile_GeneralResultSubMechanismIllustrationPointEntity FOREIGN KEY (ProfileSpecificGeneralResultSubMechanismIllustrationPointEntityId) REFERENCES GeneralResultSubMechanismIllustrationPointEntity (GeneralResultSubMechanismIllustrationPointEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT FK_ProbabilisticPipingCalculationOutputEntity_Section_GeneralResultFaultTreeIllustrationPointEntity FOREIGN KEY (SectionSpecificGeneralResultFaultTreeIllustrationPointEntityId) REFERENCES GeneralResultFaultTreeIllustrationPointEntity (GeneralResultFaultTreeIllustrationPointEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT FK_ProbabilisticPipingCalculationOutputEntity_Section_GeneralResultSubMechanismIllustrationPointEntity FOREIGN KEY (SectionSpecificGeneralResultSubMechanismIllustrationPointEntityId) REFERENCES GeneralResultSubMechanismIllustrationPointEntity (GeneralResultSubMechanismIllustrationPointEntityId) ON DELETE No Action ON UPDATE No Action, + CONSTRAINT U_ProbabilisticPipingCalculationEntity UNIQUE (ProbabilisticPipingCalculationEntityId) ) ; -CREATE TABLE 'SemiProbabilisticPipingCalculationOutputEntity' +CREATE TABLE SemiProbabilisticPipingCalculationOutputEntity ( - 'SemiProbabilisticPipingCalculationOutputEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'SemiProbabilisticPipingCalculationEntityId' INTEGER NOT NULL, + SemiProbabilisticPipingCalculationOutputEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + SemiProbabilisticPipingCalculationEntityId INTEGER NOT NULL, 'Order' INT (4) NOT NULL, - 'HeaveFactorOfSafety' REAL NULL, - 'UpliftFactorOfSafety' REAL NULL, - 'SellmeijerFactorOfSafety' REAL NULL, - 'UpliftEffectiveStress' REAL NULL, - 'HeaveGradient' REAL NULL, - 'SellmeijerCreepCoefficient' REAL NULL, - 'SellmeijerCriticalFall' REAL NULL, - 'SellmeijerReducedFall' REAL NULL, - CONSTRAINT 'FK_SemiProbabilisticPipingCalculationOutputEntity_SemiProbabilisticPipingCalculationEntity' FOREIGN KEY ('SemiProbabilisticPipingCalculationEntityId') REFERENCES 'SemiProbabilisticPipingCalculationEntity' ('SemiProbabilisticPipingCalculationEntityId') ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT 'U_SemiProbabilisticPipingCalculationEntity' UNIQUE ('SemiProbabilisticPipingCalculationEntityId') + HeaveFactorOfSafety REAL NULL, + UpliftFactorOfSafety REAL NULL, + SellmeijerFactorOfSafety REAL NULL, + UpliftEffectiveStress REAL NULL, + HeaveGradient REAL NULL, + SellmeijerCreepCoefficient REAL NULL, + SellmeijerCriticalFall REAL NULL, + SellmeijerReducedFall REAL NULL, + CONSTRAINT FK_SemiProbabilisticPipingCalculationOutputEntity_SemiProbabilisticPipingCalculationEntity FOREIGN KEY (SemiProbabilisticPipingCalculationEntityId) REFERENCES SemiProbabilisticPipingCalculationEntity (SemiProbabilisticPipingCalculationEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT U_SemiProbabilisticPipingCalculationEntity UNIQUE (SemiProbabilisticPipingCalculationEntityId) ) ; -CREATE TABLE 'SpecificFailureMechanismEntity' +CREATE TABLE SpecificFailureMechanismEntity ( - 'SpecificFailureMechanismEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'AssessmentSectionEntityId' INTEGER NOT NULL, - 'Name' VARCHAR (260) NULL, - 'Code' VARCHAR (260) NULL, + SpecificFailureMechanismEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + AssessmentSectionEntityId INTEGER NOT NULL, + Name VARCHAR (260) NULL, + Code VARCHAR (260) NULL, 'Order' INT (4) NOT NULL, - 'InAssembly' TINYINT (1) NOT NULL, -- true or false - 'FailureMechanismSectionCollectionSourcePath' TEXT NULL, - 'InAssemblyInputComments' TEXT NULL, - 'InAssemblyOutputComments' TEXT NULL, - 'NotInAssemblyComments' TEXT NULL, - 'N' REAL NOT NULL, - 'FailureMechanismAssemblyResultProbabilityResultType' TINYINT (1) NOT NULL, -- Enum: Automatic = 1, Manual = 2 - 'FailureMechanismAssemblyResultManualFailureMechanismAssemblyProbability' REAL NULL, - 'ApplyLengthEffectInSection' TINYINT (1) NOT NULL, - CONSTRAINT 'FK_SpecificFailureMechanismEntity_AssessmentSectionEntity' FOREIGN KEY ('AssessmentSectionEntityId') REFERENCES 'AssessmentSectionEntity' ('AssessmentSectionEntityId') ON DELETE Cascade ON UPDATE Cascade + InAssembly TINYINT (1) NOT NULL, -- true or false + FailureMechanismSectionCollectionSourcePath TEXT NULL COLLATE NOCASE, + InAssemblyInputComments TEXT NULL COLLATE NOCASE, + InAssemblyOutputComments TEXT NULL COLLATE NOCASE, + NotInAssemblyComments TEXT NULL COLLATE NOCASE, + N REAL NOT NULL, + FailureMechanismAssemblyResultProbabilityResultType TINYINT (1) NOT NULL, -- Enum: Automatic = 1, Manual = 2 + FailureMechanismAssemblyResultManualFailureMechanismAssemblyProbability REAL NULL, + ApplyLengthEffectInSection TINYINT (1) NOT NULL, + CONSTRAINT FK_SpecificFailureMechanismEntity_AssessmentSectionEntity FOREIGN KEY (AssessmentSectionEntityId) REFERENCES AssessmentSectionEntity (AssessmentSectionEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; -CREATE TABLE 'SpecificFailureMechanismFailureMechanismSectionEntity' +CREATE TABLE SpecificFailureMechanismFailureMechanismSectionEntity ( - 'SpecificFailureMechanismEntityId' INTEGER NOT NULL, - 'FailureMechanismSectionEntityId' INTEGER NOT NULL, - CONSTRAINT 'PK_SpecificFailureMechanismFailureMechanismSectionEntity' PRIMARY KEY ('SpecificFailureMechanismEntityId','FailureMechanismSectionEntityId'), - CONSTRAINT 'FK_SpecificFailureMechanismFailureMechanismSectionEntity_FailureMechanismSectionEntity' FOREIGN KEY ('FailureMechanismSectionEntityId') REFERENCES 'FailureMechanismSectionEntity' ('FailureMechanismSectionEntityId') ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT 'FK_SpecificFailureMechanismFailureMechanismSectionEntity_SpecificFailureMechanismEntity' FOREIGN KEY ('SpecificFailureMechanismEntityId') REFERENCES 'SpecificFailureMechanismEntity' ('SpecificFailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade + SpecificFailureMechanismEntityId INTEGER NOT NULL, + FailureMechanismSectionEntityId INTEGER NOT NULL, + CONSTRAINT PK_SpecificFailureMechanismFailureMechanismSectionEntity PRIMARY KEY (SpecificFailureMechanismEntityId,FailureMechanismSectionEntityId), + CONSTRAINT FK_SpecificFailureMechanismFailureMechanismSectionEntity_FailureMechanismSectionEntity FOREIGN KEY (FailureMechanismSectionEntityId) REFERENCES FailureMechanismSectionEntity (FailureMechanismSectionEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT FK_SpecificFailureMechanismFailureMechanismSectionEntity_SpecificFailureMechanismEntity FOREIGN KEY (SpecificFailureMechanismEntityId) REFERENCES SpecificFailureMechanismEntity (SpecificFailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; -CREATE TABLE 'StabilityPointStructureEntity' +CREATE TABLE StabilityPointStructureEntity ( - 'StabilityPointStructureEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismEntityId' INTEGER NOT NULL, + StabilityPointStructureEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + FailureMechanismEntityId INTEGER NOT NULL, 'Order' INT (4) NOT NULL, - 'Name' VARCHAR (260) NOT NULL, - 'Id' VARCHAR (260) NOT NULL, - 'X' REAL NULL, - 'Y' REAL NULL, - 'StructureNormalOrientation' REAL NULL, - 'StorageStructureAreaMean' REAL NULL, - 'StorageStructureAreaCoefficientOfVariation' REAL NULL, - 'AllowedLevelIncreaseStorageMean' REAL NULL, - 'AllowedLevelIncreaseStorageStandardDeviation' REAL NULL, - 'WidthFlowAperturesMean' REAL NULL, - 'WidthFlowAperturesStandardDeviation' REAL NULL, - 'InsideWaterLevelMean' REAL NULL, - 'InsideWaterLevelStandardDeviation' REAL NULL, - 'ThresholdHeightOpenWeirMean' REAL NULL, - 'ThresholdHeightOpenWeirStandardDeviation' REAL NULL, - 'CriticalOvertoppingDischargeMean' REAL NULL, - 'CriticalOvertoppingDischargeCoefficientOfVariation' REAL NULL, - 'FlowWidthAtBottomProtectionMean' REAL NULL, - 'FlowWidthAtBottomProtectionStandardDeviation' REAL NULL, - 'ConstructiveStrengthLinearLoadModelMean' REAL NULL, - 'ConstructiveStrengthLinearLoadModelCoefficientOfVariation' REAL NULL, - 'ConstructiveStrengthQuadraticLoadModelMean' REAL NULL, - 'ConstructiveStrengthQuadraticLoadModelCoefficientOfVariation' REAL NULL, - 'BankWidthMean' REAL NULL, - 'BankWidthStandardDeviation' REAL NULL, - 'InsideWaterLevelFailureConstructionMean' REAL NULL, - 'InsideWaterLevelFailureConstructionStandardDeviation' REAL NULL, - 'EvaluationLevel' REAL NULL, - 'LevelCrestStructureMean' REAL NULL, - 'LevelCrestStructureStandardDeviation' REAL NULL, - 'VerticalDistance' REAL NULL, - 'FailureProbabilityRepairClosure' REAL NULL, - 'FailureCollisionEnergyMean' REAL NULL, - 'FailureCollisionEnergyCoefficientOfVariation' REAL NULL, - 'ShipMassMean' REAL NULL, - 'ShipMassCoefficientOfVariation' REAL NULL, - 'ShipVelocityMean' REAL NULL, - 'ShipVelocityCoefficientOfVariation' REAL NULL, - 'LevellingCount' INT (4) NOT NULL, - 'ProbabilityCollisionSecondaryStructure' REAL NULL, - 'FlowVelocityStructureClosableMean' REAL NULL, - 'StabilityLinearLoadModelMean' REAL NULL, - 'StabilityLinearLoadModelCoefficientOfVariation' REAL NULL, - 'StabilityQuadraticLoadModelMean' REAL NULL, - 'StabilityQuadraticLoadModelCoefficientOfVariation' REAL NULL, - 'AreaFlowAperturesMean' REAL NULL, - 'AreaFlowAperturesStandardDeviation' REAL NULL, - '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, - CONSTRAINT 'U_Id_FailureMechanismEntityId' UNIQUE ('FailureMechanismEntityId','Id') + Name VARCHAR (260) NOT NULL, + Id VARCHAR (260) NOT NULL, + X REAL NULL, + Y REAL NULL, + StructureNormalOrientation REAL NULL, + StorageStructureAreaMean REAL NULL, + StorageStructureAreaCoefficientOfVariation REAL NULL, + AllowedLevelIncreaseStorageMean REAL NULL, + AllowedLevelIncreaseStorageStandardDeviation REAL NULL, + WidthFlowAperturesMean REAL NULL, + WidthFlowAperturesStandardDeviation REAL NULL, + InsideWaterLevelMean REAL NULL, + InsideWaterLevelStandardDeviation REAL NULL, + ThresholdHeightOpenWeirMean REAL NULL, + ThresholdHeightOpenWeirStandardDeviation REAL NULL, + CriticalOvertoppingDischargeMean REAL NULL, + CriticalOvertoppingDischargeCoefficientOfVariation REAL NULL, + FlowWidthAtBottomProtectionMean REAL NULL, + FlowWidthAtBottomProtectionStandardDeviation REAL NULL, + ConstructiveStrengthLinearLoadModelMean REAL NULL, + ConstructiveStrengthLinearLoadModelCoefficientOfVariation REAL NULL, + ConstructiveStrengthQuadraticLoadModelMean REAL NULL, + ConstructiveStrengthQuadraticLoadModelCoefficientOfVariation REAL NULL, + BankWidthMean REAL NULL, + BankWidthStandardDeviation REAL NULL, + InsideWaterLevelFailureConstructionMean REAL NULL, + InsideWaterLevelFailureConstructionStandardDeviation REAL NULL, + EvaluationLevel REAL NULL, + LevelCrestStructureMean REAL NULL, + LevelCrestStructureStandardDeviation REAL NULL, + VerticalDistance REAL NULL, + FailureProbabilityRepairClosure REAL NULL, + FailureCollisionEnergyMean REAL NULL, + FailureCollisionEnergyCoefficientOfVariation REAL NULL, + ShipMassMean REAL NULL, + ShipMassCoefficientOfVariation REAL NULL, + ShipVelocityMean REAL NULL, + ShipVelocityCoefficientOfVariation REAL NULL, + LevellingCount INT (4) NOT NULL, + ProbabilityCollisionSecondaryStructure REAL NULL, + FlowVelocityStructureClosableMean REAL NULL, + StabilityLinearLoadModelMean REAL NULL, + StabilityLinearLoadModelCoefficientOfVariation REAL NULL, + StabilityQuadraticLoadModelMean REAL NULL, + StabilityQuadraticLoadModelCoefficientOfVariation REAL NULL, + AreaFlowAperturesMean REAL NULL, + AreaFlowAperturesStandardDeviation REAL NULL, + 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, + CONSTRAINT U_Id_FailureMechanismEntityId UNIQUE (FailureMechanismEntityId,Id) ) ; -CREATE TABLE 'StabilityPointStructuresCalculationEntity' +CREATE TABLE StabilityPointStructuresCalculationEntity ( - 'StabilityPointStructuresCalculationEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'CalculationGroupEntityId' INTEGER NOT NULL, - 'ForeshoreProfileEntityId' INTEGER NULL, - 'HydraulicLocationEntityId' INTEGER NULL, - 'StabilityPointStructureEntityId' INTEGER NULL, + StabilityPointStructuresCalculationEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + CalculationGroupEntityId INTEGER NOT NULL, + ForeshoreProfileEntityId INTEGER NULL, + HydraulicLocationEntityId INTEGER NULL, + StabilityPointStructureEntityId INTEGER NULL, 'Order' INT (4) NOT NULL, - 'Name' VARCHAR (260) NULL, - 'Comments' TEXT NULL, - 'UseBreakWater' TINYINT (1) NOT NULL, -- true or false - 'BreakWaterType' TINYINT (1) NOT NULL, -- Enum: 1 = Wall, 2 = Caisson, 3 = Dam - 'BreakWaterHeight' REAL NULL, - 'UseForeshore' TINYINT (1) NOT NULL, -- true or false - 'StructureNormalOrientation' REAL NULL, - 'StorageStructureAreaMean' REAL NULL, - 'StorageStructureAreaCoefficientOfVariation' REAL NULL, - 'AllowedLevelIncreaseStorageMean' REAL NULL, - 'AllowedLevelIncreaseStorageStandardDeviation' REAL NULL, - 'WidthFlowAperturesMean' REAL NULL, - 'WidthFlowAperturesStandardDeviation' REAL NULL, - 'InsideWaterLevelMean' REAL NULL, - 'InsideWaterLevelStandardDeviation' REAL NULL, - 'ThresholdHeightOpenWeirMean' REAL NULL, - 'ThresholdHeightOpenWeirStandardDeviation' REAL NULL, - 'CriticalOvertoppingDischargeMean' REAL NULL, - 'CriticalOvertoppingDischargeCoefficientOfVariation' REAL NULL, - 'FlowWidthAtBottomProtectionMean' REAL NULL, - 'FlowWidthAtBottomProtectionStandardDeviation' REAL NULL, - 'ConstructiveStrengthLinearLoadModelMean' REAL NULL, - 'ConstructiveStrengthLinearLoadModelCoefficientOfVariation' REAL NULL, - 'ConstructiveStrengthQuadraticLoadModelMean' REAL NULL, - 'ConstructiveStrengthQuadraticLoadModelCoefficientOfVariation' REAL NULL, - 'BankWidthMean' REAL NULL, - 'BankWidthStandardDeviation' REAL NULL, - 'InsideWaterLevelFailureConstructionMean' REAL NULL, - 'InsideWaterLevelFailureConstructionStandardDeviation' REAL NULL, - 'EvaluationLevel' REAL NULL, - 'LevelCrestStructureMean' REAL NULL, - 'LevelCrestStructureStandardDeviation' REAL NULL, - 'VerticalDistance' REAL NULL, - 'FailureProbabilityRepairClosure' REAL NOT NULL, - 'FailureCollisionEnergyMean' REAL NULL, - 'FailureCollisionEnergyCoefficientOfVariation' REAL NULL, - 'ShipMassMean' REAL NULL, - 'ShipMassCoefficientOfVariation' REAL NULL, - 'ShipVelocityMean' REAL NULL, - 'ShipVelocityCoefficientOfVariation' REAL NULL, - 'LevellingCount' INT (4) NOT NULL, - 'ProbabilityCollisionSecondaryStructure' REAL NOT NULL, - 'FlowVelocityStructureClosableMean' REAL NULL, - 'StabilityLinearLoadModelMean' REAL NULL, - 'StabilityLinearLoadModelCoefficientOfVariation' REAL NULL, - 'StabilityQuadraticLoadModelMean' REAL NULL, - 'StabilityQuadraticLoadModelCoefficientOfVariation' REAL NULL, - 'AreaFlowAperturesMean' REAL NULL, - 'AreaFlowAperturesStandardDeviation' REAL 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 NULL, - 'StormDurationMean' REAL NULL, - 'FactorStormDurationOpenStructure' REAL NULL, - 'DrainCoefficientMean' REAL NULL, - 'DrainCoefficientStandardDeviation' REAL NULL, - 'FailureProbabilityStructureWithErosion' REAL NOT NULL, - 'ShouldIllustrationPointsBeCalculated' TINYINT (1) NOT NULL, -- true or false - 'RelevantForScenario' TINYINT (1) NOT NULL, -- true or false - 'ScenarioContribution' REAL NOT NULL, - CONSTRAINT 'FK_StabilityPointStructuresCalculationEntity_CalculationGroupEntity' FOREIGN KEY ('CalculationGroupEntityId') REFERENCES 'CalculationGroupEntity' ('CalculationGroupEntityId') ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT 'FK_StabilityPointStructuresCalculationEntity_ForeshoreProfileEntity' FOREIGN KEY ('ForeshoreProfileEntityId') REFERENCES 'ForeshoreProfileEntity' ('ForeshoreProfileEntityId') ON DELETE Set Null ON UPDATE Cascade, - CONSTRAINT 'FK_StabilityPointStructuresCalculationEntity_HydraulicLocationEntity' FOREIGN KEY ('HydraulicLocationEntityId') REFERENCES 'HydraulicLocationEntity' ('HydraulicLocationEntityId') ON DELETE Set Null ON UPDATE Cascade, - CONSTRAINT 'FK_StabilityPointStructuresCalculationEntity_StabilityPointStructureEntity' FOREIGN KEY ('StabilityPointStructureEntityId') REFERENCES 'StabilityPointStructureEntity' ('StabilityPointStructureEntityId') ON DELETE Set Null ON UPDATE Cascade + Name VARCHAR (260) NULL, + Comments TEXT NULL COLLATE NOCASE, + UseBreakWater TINYINT (1) NOT NULL, -- true or false + BreakWaterType TINYINT (1) NOT NULL, -- Enum: 1 = Wall, 2 = Caisson, 3 = Dam + BreakWaterHeight REAL NULL, + UseForeshore TINYINT (1) NOT NULL, -- true or false + StructureNormalOrientation REAL NULL, + StorageStructureAreaMean REAL NULL, + StorageStructureAreaCoefficientOfVariation REAL NULL, + AllowedLevelIncreaseStorageMean REAL NULL, + AllowedLevelIncreaseStorageStandardDeviation REAL NULL, + WidthFlowAperturesMean REAL NULL, + WidthFlowAperturesStandardDeviation REAL NULL, + InsideWaterLevelMean REAL NULL, + InsideWaterLevelStandardDeviation REAL NULL, + ThresholdHeightOpenWeirMean REAL NULL, + ThresholdHeightOpenWeirStandardDeviation REAL NULL, + CriticalOvertoppingDischargeMean REAL NULL, + CriticalOvertoppingDischargeCoefficientOfVariation REAL NULL, + FlowWidthAtBottomProtectionMean REAL NULL, + FlowWidthAtBottomProtectionStandardDeviation REAL NULL, + ConstructiveStrengthLinearLoadModelMean REAL NULL, + ConstructiveStrengthLinearLoadModelCoefficientOfVariation REAL NULL, + ConstructiveStrengthQuadraticLoadModelMean REAL NULL, + ConstructiveStrengthQuadraticLoadModelCoefficientOfVariation REAL NULL, + BankWidthMean REAL NULL, + BankWidthStandardDeviation REAL NULL, + InsideWaterLevelFailureConstructionMean REAL NULL, + InsideWaterLevelFailureConstructionStandardDeviation REAL NULL, + EvaluationLevel REAL NULL, + LevelCrestStructureMean REAL NULL, + LevelCrestStructureStandardDeviation REAL NULL, + VerticalDistance REAL NULL, + FailureProbabilityRepairClosure REAL NOT NULL, + FailureCollisionEnergyMean REAL NULL, + FailureCollisionEnergyCoefficientOfVariation REAL NULL, + ShipMassMean REAL NULL, + ShipMassCoefficientOfVariation REAL NULL, + ShipVelocityMean REAL NULL, + ShipVelocityCoefficientOfVariation REAL NULL, + LevellingCount INT (4) NOT NULL, + ProbabilityCollisionSecondaryStructure REAL NOT NULL, + FlowVelocityStructureClosableMean REAL NULL, + StabilityLinearLoadModelMean REAL NULL, + StabilityLinearLoadModelCoefficientOfVariation REAL NULL, + StabilityQuadraticLoadModelMean REAL NULL, + StabilityQuadraticLoadModelCoefficientOfVariation REAL NULL, + AreaFlowAperturesMean REAL NULL, + AreaFlowAperturesStandardDeviation REAL 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 NULL, + StormDurationMean REAL NULL, + FactorStormDurationOpenStructure REAL NULL, + DrainCoefficientMean REAL NULL, + DrainCoefficientStandardDeviation REAL NULL, + FailureProbabilityStructureWithErosion REAL NOT NULL, + ShouldIllustrationPointsBeCalculated TINYINT (1) NOT NULL, -- true or false + RelevantForScenario TINYINT (1) NOT NULL, -- true or false + ScenarioContribution REAL NOT NULL, + CONSTRAINT FK_StabilityPointStructuresCalculationEntity_CalculationGroupEntity FOREIGN KEY (CalculationGroupEntityId) REFERENCES CalculationGroupEntity (CalculationGroupEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT FK_StabilityPointStructuresCalculationEntity_ForeshoreProfileEntity FOREIGN KEY (ForeshoreProfileEntityId) REFERENCES ForeshoreProfileEntity (ForeshoreProfileEntityId) ON DELETE Set Null ON UPDATE Cascade, + CONSTRAINT FK_StabilityPointStructuresCalculationEntity_HydraulicLocationEntity FOREIGN KEY (HydraulicLocationEntityId) REFERENCES HydraulicLocationEntity (HydraulicLocationEntityId) ON DELETE Set Null ON UPDATE Cascade, + CONSTRAINT FK_StabilityPointStructuresCalculationEntity_StabilityPointStructureEntity FOREIGN KEY (StabilityPointStructureEntityId) REFERENCES StabilityPointStructureEntity (StabilityPointStructureEntityId) ON DELETE Set Null ON UPDATE Cascade ) ; -CREATE TABLE 'StabilityPointStructuresFailureMechanismMetaEntity' +CREATE TABLE StabilityPointStructuresFailureMechanismMetaEntity ( - 'StabilityPointStructuresFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismEntityId' INTEGER NOT NULL, - 'N' REAL NOT NULL, - 'ForeshoreProfileCollectionSourcePath' TEXT NULL, - 'StabilityPointStructureCollectionSourcePath' TEXT NULL, - CONSTRAINT 'FK_StrengthStabilityPointConstructionFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade + StabilityPointStructuresFailureMechanismMetaEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + FailureMechanismEntityId INTEGER NOT NULL, + N REAL NOT NULL, + ForeshoreProfileCollectionSourcePath TEXT NULL COLLATE NOCASE, + StabilityPointStructureCollectionSourcePath TEXT NULL COLLATE NOCASE, + CONSTRAINT FK_StrengthStabilityPointConstructionFailureMechanismMetaEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; -CREATE TABLE 'StabilityPointStructuresOutputEntity' +CREATE TABLE StabilityPointStructuresOutputEntity ( - 'StabilityPointStructuresOutputEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'StabilityPointStructuresCalculationEntityId' INTEGER NOT NULL, - 'GeneralResultFaultTreeIllustrationPointEntityId' INTEGER NULL, - 'Reliability' REAL NULL, - CONSTRAINT 'FK_StabilityPointStructuresOutputEntity_GeneralResultFaultTreeIllustrationPointEntity' FOREIGN KEY ('GeneralResultFaultTreeIllustrationPointEntityId') REFERENCES 'GeneralResultFaultTreeIllustrationPointEntity' ('GeneralResultFaultTreeIllustrationPointEntityId') ON DELETE Set Null ON UPDATE Cascade, - CONSTRAINT 'FK_StabilityPointStructuresOutputEntity_StabilityPointStructuresCalculationEntity' FOREIGN KEY ('StabilityPointStructuresCalculationEntityId') REFERENCES 'StabilityPointStructuresCalculationEntity' ('StabilityPointStructuresCalculationEntityId') ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT 'U_StabilityPointStructuresCalculationEntity' UNIQUE ('StabilityPointStructuresCalculationEntityId') + StabilityPointStructuresOutputEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + StabilityPointStructuresCalculationEntityId INTEGER NOT NULL, + GeneralResultFaultTreeIllustrationPointEntityId INTEGER NULL, + Reliability REAL NULL, + CONSTRAINT FK_StabilityPointStructuresOutputEntity_GeneralResultFaultTreeIllustrationPointEntity FOREIGN KEY (GeneralResultFaultTreeIllustrationPointEntityId) REFERENCES GeneralResultFaultTreeIllustrationPointEntity (GeneralResultFaultTreeIllustrationPointEntityId) ON DELETE Set Null ON UPDATE Cascade, + CONSTRAINT FK_StabilityPointStructuresOutputEntity_StabilityPointStructuresCalculationEntity FOREIGN KEY (StabilityPointStructuresCalculationEntityId) REFERENCES StabilityPointStructuresCalculationEntity (StabilityPointStructuresCalculationEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT U_StabilityPointStructuresCalculationEntity UNIQUE (StabilityPointStructuresCalculationEntityId) ) ; -CREATE TABLE 'StabilityStoneCoverFailureMechanismMetaEntity' +CREATE TABLE StabilityStoneCoverFailureMechanismMetaEntity ( - 'StabilityStoneCoverFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismEntityId' INTEGER NOT NULL, - 'ForeshoreProfileCollectionSourcePath' TEXT NULL, - 'N' REAL NOT NULL, - 'ApplyLengthEffectInSection' TINYINT (1) NOT NULL, - CONSTRAINT 'FK_StabilityStoneCoverFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade + StabilityStoneCoverFailureMechanismMetaEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + FailureMechanismEntityId INTEGER NOT NULL, + ForeshoreProfileCollectionSourcePath TEXT NULL COLLATE NOCASE, + N REAL NOT NULL, + ApplyLengthEffectInSection TINYINT (1) NOT NULL, + CONSTRAINT FK_StabilityStoneCoverFailureMechanismMetaEntity_FailureMechanismEntity FOREIGN KEY (FailureMechanismEntityId) REFERENCES FailureMechanismEntity (FailureMechanismEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; -CREATE TABLE 'StabilityStoneCoverWaveConditionsCalculationEntity' +CREATE TABLE StabilityStoneCoverWaveConditionsCalculationEntity ( - 'StabilityStoneCoverWaveConditionsCalculationEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'CalculationGroupEntityId' INTEGER NOT NULL, - 'ForeshoreProfileEntityId' INTEGER NULL, - 'HydraulicLocationEntityId' INTEGER NULL, - 'HydraulicLocationCalculationForTargetProbabilityCollectionEntityId' INTEGER NULL, + StabilityStoneCoverWaveConditionsCalculationEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + CalculationGroupEntityId INTEGER NOT NULL, + ForeshoreProfileEntityId INTEGER NULL, + HydraulicLocationEntityId INTEGER NULL, + HydraulicLocationCalculationForTargetProbabilityCollectionEntityId INTEGER NULL, 'Order' INT (4) NOT NULL, - 'Name' VARCHAR (260) NULL, - 'Comments' TEXT NULL, - 'UseBreakWater' TINYINT (1) NOT NULL, -- true or false - 'BreakWaterType' TINYINT (1) NOT NULL, -- Enum: 1 = Wall, 2 = Caisson, 3 = Dam - 'BreakWaterHeight' REAL NULL, - 'UseForeshore' TINYINT (1) NOT NULL, -- true or false - 'Orientation' REAL NULL, - 'UpperBoundaryRevetment' REAL NULL, - 'LowerBoundaryRevetment' REAL NULL, - 'UpperBoundaryWaterLevels' REAL NULL, - 'LowerBoundaryWaterLevels' REAL NULL, - 'StepSize' TINYINT (1) NOT NULL, -- Enum: 1 = 0.5, 2 = 1.0, 3 = 2.0 - 'CalculationType' TINYINT (1) NOT NULL, -- Enum: 1 = Blocks, 2 = Columns, 3 = Both - 'WaterLevelType' TINYINT (1) NOT NULL, -- Enum: 1 = None, 2 = MaximumAllowableFloodingProbability, 3 = SignalFloodingProbability, 4 = UserDefinedTargetProbability - 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_HydraulicLocationCalculationForTargetProbabilityCollectionEntity' FOREIGN KEY ('HydraulicLocationCalculationForTargetProbabilityCollectionEntityId') REFERENCES 'HydraulicLocationCalculationForTargetProbabilityCollectionEntity' ('HydraulicLocationCalculationForTargetProbabilityCollectionEntityId') ON DELETE Set Null ON UPDATE Cascade, - CONSTRAINT 'FK_StabilityStoneCoverWaveConditionsCalculationEntity_HydraulicLocationEntity' FOREIGN KEY ('HydraulicLocationEntityId') REFERENCES 'HydraulicLocationEntity' ('HydraulicLocationEntityId') ON DELETE Set Null ON UPDATE Cascade + Name VARCHAR (260) NULL, + Comments TEXT NULL COLLATE NOCASE, + UseBreakWater TINYINT (1) NOT NULL, -- true or false + BreakWaterType TINYINT (1) NOT NULL, -- Enum: 1 = Wall, 2 = Caisson, 3 = Dam + BreakWaterHeight REAL NULL, + UseForeshore TINYINT (1) NOT NULL, -- true or false + Orientation REAL NULL, + UpperBoundaryRevetment REAL NULL, + LowerBoundaryRevetment REAL NULL, + UpperBoundaryWaterLevels REAL NULL, + LowerBoundaryWaterLevels REAL NULL, + StepSize TINYINT (1) NOT NULL, -- Enum: 1 = 0.5, 2 = 1.0, 3 = 2.0 + CalculationType TINYINT (1) NOT NULL, -- Enum: 1 = Blocks, 2 = Columns, 3 = Both + WaterLevelType TINYINT (1) NOT NULL, -- Enum: 1 = None, 2 = MaximumAllowableFloodingProbability, 3 = SignalFloodingProbability, 4 = UserDefinedTargetProbability + 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_HydraulicLocationCalculationForTargetProbabilityCollectionEntity FOREIGN KEY (HydraulicLocationCalculationForTargetProbabilityCollectionEntityId) REFERENCES HydraulicLocationCalculationForTargetProbabilityCollectionEntity (HydraulicLocationCalculationForTargetProbabilityCollectionEntityId) ON DELETE Set Null ON UPDATE Cascade, + CONSTRAINT FK_StabilityStoneCoverWaveConditionsCalculationEntity_HydraulicLocationEntity FOREIGN KEY (HydraulicLocationEntityId) REFERENCES HydraulicLocationEntity (HydraulicLocationEntityId) ON DELETE Set Null ON UPDATE Cascade ) ; -CREATE TABLE 'StabilityStoneCoverWaveConditionsOutputEntity' +CREATE TABLE StabilityStoneCoverWaveConditionsOutputEntity ( - 'StabilityStoneCoverWaveConditionsOutputEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'StabilityStoneCoverWaveConditionsCalculationEntityId' INTEGER NOT NULL, + StabilityStoneCoverWaveConditionsOutputEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + StabilityStoneCoverWaveConditionsCalculationEntityId INTEGER NOT NULL, 'Order' INT (4) NOT NULL, - 'OutputType' TINYINT (1) NOT NULL, -- Enum: 1 = Column, 2 = Block - 'WaterLevel' REAL NULL, - 'WaveHeight' REAL NULL, - 'WavePeakPeriod' REAL NULL, - 'WaveAngle' REAL NULL, - 'WaveDirection' REAL NULL, - 'TargetProbability' REAL NULL, - 'TargetReliability' REAL NULL, - 'CalculatedProbability' REAL NULL, - 'CalculatedReliability' REAL NULL, - '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 + OutputType TINYINT (1) NOT NULL, -- Enum: 1 = Column, 2 = Block + WaterLevel REAL NULL, + WaveHeight REAL NULL, + WavePeakPeriod REAL NULL, + WaveAngle REAL NULL, + WaveDirection REAL NULL, + TargetProbability REAL NULL, + TargetReliability REAL NULL, + CalculatedProbability REAL NULL, + CalculatedReliability REAL NULL, + 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 ) ; -CREATE TABLE 'StochastEntity' +CREATE TABLE StochastEntity ( - 'StochastEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'Name' TEXT NOT NULL, - 'Duration' REAL NOT NULL, - 'Alpha' REAL NOT NULL, + StochastEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + Name TEXT NOT NULL COLLATE NOCASE, + Duration REAL NOT NULL, + Alpha REAL NOT NULL, 'Order' INT (4) NOT NULL ) ; -CREATE TABLE 'SubMechanismIllustrationPointEntity' +CREATE TABLE SubMechanismIllustrationPointEntity ( - 'SubMechanismIllustrationPointEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'Name' TEXT NOT NULL, - 'Beta' REAL NOT NULL, + SubMechanismIllustrationPointEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + Name TEXT NOT NULL COLLATE NOCASE, + Beta REAL NOT NULL, 'Order' INT (4) NOT NULL ) ; -CREATE TABLE 'SubMechanismIllustrationPointStochastEntity' +CREATE TABLE SubMechanismIllustrationPointStochastEntity ( - 'SubMechanismIllustrationPointStochastEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'SubMechanismIllustrationPointEntityId' INTEGER NOT NULL, - 'Name' TEXT NOT NULL, - 'Unit' TEXT NOT NULL, - 'Duration' REAL NOT NULL, - 'Alpha' REAL NOT NULL, - 'Realization' REAL NOT NULL, + SubMechanismIllustrationPointStochastEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + SubMechanismIllustrationPointEntityId INTEGER NOT NULL, + Name TEXT NOT NULL COLLATE NOCASE, + Unit TEXT NOT NULL COLLATE NOCASE, + Duration REAL NOT NULL, + Alpha REAL NOT NULL, + Realization REAL NOT NULL, 'Order' INT (4) NOT NULL, - CONSTRAINT 'FK_SubMechanismIllustrationPointStochast_SubMechanismIllustrationPointEntity' FOREIGN KEY ('SubMechanismIllustrationPointEntityId') REFERENCES 'SubMechanismIllustrationPointEntity' ('SubMechanismIllustrationPointEntityId') ON DELETE No Action ON UPDATE No Action + CONSTRAINT FK_SubMechanismIllustrationPointStochast_SubMechanismIllustrationPointEntity FOREIGN KEY (SubMechanismIllustrationPointEntityId) REFERENCES SubMechanismIllustrationPointEntity (SubMechanismIllustrationPointEntityId) ON DELETE No Action ON UPDATE No Action ) ; -CREATE TABLE 'TopLevelFaultTreeIllustrationPointEntity' +CREATE TABLE TopLevelFaultTreeIllustrationPointEntity ( - 'TopLevelFaultTreeIllustrationPointEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FaultTreeIllustrationPointEntityId' INTEGER NOT NULL, - 'GeneralResultFaultTreeIllustrationPointEntityId' INTEGER NOT NULL, - 'ClosingSituation' TEXT NOT NULL, - 'WindDirectionName' TEXT NOT NULL, - 'WindDirectionAngle' REAL NOT NULL, + TopLevelFaultTreeIllustrationPointEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + FaultTreeIllustrationPointEntityId INTEGER NOT NULL, + GeneralResultFaultTreeIllustrationPointEntityId INTEGER NOT NULL, + ClosingSituation TEXT NOT NULL COLLATE NOCASE, + WindDirectionName TEXT NOT NULL COLLATE NOCASE, + WindDirectionAngle REAL NOT NULL, 'Order' INT (4) NOT NULL, - CONSTRAINT 'FK_TopLevelFaultTreeIllustrationPointEntity_FaultTreeIllustrationPointEntity' FOREIGN KEY ('FaultTreeIllustrationPointEntityId') REFERENCES 'FaultTreeIllustrationPointEntity' ('FaultTreeIllustrationPointEntityId') ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT 'FK_TopLevelFaultTreeIllustrationPointEntity_GeneralResultFaultTreeIllustrationPointEntity' FOREIGN KEY ('GeneralResultFaultTreeIllustrationPointEntityId') REFERENCES 'GeneralResultFaultTreeIllustrationPointEntity' ('GeneralResultFaultTreeIllustrationPointEntityId') ON DELETE Cascade ON UPDATE Cascade + CONSTRAINT FK_TopLevelFaultTreeIllustrationPointEntity_FaultTreeIllustrationPointEntity FOREIGN KEY (FaultTreeIllustrationPointEntityId) REFERENCES FaultTreeIllustrationPointEntity (FaultTreeIllustrationPointEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT FK_TopLevelFaultTreeIllustrationPointEntity_GeneralResultFaultTreeIllustrationPointEntity FOREIGN KEY (GeneralResultFaultTreeIllustrationPointEntityId) REFERENCES GeneralResultFaultTreeIllustrationPointEntity (GeneralResultFaultTreeIllustrationPointEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; -CREATE TABLE 'TopLevelSubMechanismIllustrationPointEntity' +CREATE TABLE TopLevelSubMechanismIllustrationPointEntity ( - 'TopLevelSubMechanismIllustrationPointEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'GeneralResultSubMechanismIllustrationPointEntityId' INTEGER NOT NULL, - 'SubMechanismIllustrationPointEntityId' INTEGER NOT NULL, - 'ClosingSituation' TEXT NOT NULL, - 'WindDirectionName' TEXT NOT NULL, - 'WindDirectionAngle' REAL NOT NULL, + TopLevelSubMechanismIllustrationPointEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + GeneralResultSubMechanismIllustrationPointEntityId INTEGER NOT NULL, + SubMechanismIllustrationPointEntityId INTEGER NOT NULL, + ClosingSituation TEXT NOT NULL COLLATE NOCASE, + WindDirectionName TEXT NOT NULL COLLATE NOCASE, + WindDirectionAngle REAL NOT NULL, 'Order' INT (4) NOT NULL, - CONSTRAINT 'FK_TopLevelSubMechanismIllustrationPointEntity_GeneralResultSubMechanismIllustrationPointEntity' FOREIGN KEY ('GeneralResultSubMechanismIllustrationPointEntityId') REFERENCES 'GeneralResultSubMechanismIllustrationPointEntity' ('GeneralResultSubMechanismIllustrationPointEntityId') ON DELETE Cascade ON UPDATE Cascade, - CONSTRAINT 'FK_TopLevelSubMechanismIllustrationPointEntity_SubMechanismIllustrationPointEntity' FOREIGN KEY ('SubMechanismIllustrationPointEntityId') REFERENCES 'SubMechanismIllustrationPointEntity' ('SubMechanismIllustrationPointEntityId') ON DELETE Cascade ON UPDATE Cascade + CONSTRAINT FK_TopLevelSubMechanismIllustrationPointEntity_GeneralResultSubMechanismIllustrationPointEntity FOREIGN KEY (GeneralResultSubMechanismIllustrationPointEntityId) REFERENCES GeneralResultSubMechanismIllustrationPointEntity (GeneralResultSubMechanismIllustrationPointEntityId) ON DELETE Cascade ON UPDATE Cascade, + CONSTRAINT FK_TopLevelSubMechanismIllustrationPointEntity_SubMechanismIllustrationPointEntity FOREIGN KEY (SubMechanismIllustrationPointEntityId) REFERENCES SubMechanismIllustrationPointEntity (SubMechanismIllustrationPointEntityId) ON DELETE Cascade ON UPDATE Cascade ) ; -CREATE TABLE 'WaveImpactAsphaltCoverWaveConditionsCalculationEntity' +CREATE TABLE WaveImpactAsphaltCoverWaveConditionsCalculationEntity ( - 'WaveImpactAsphaltCoverWaveConditionsCalculationEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'CalculationGroupEntityId' INTEGER NOT NULL, - 'ForeshoreProfileEntityId' INTEGER NULL, - 'HydraulicLocationEntityId' INTEGER NULL, - 'HydraulicLocationCalculationForTargetProbabilityCollectionEntityId' INTEGER NULL, + WaveImpactAsphaltCoverWaveConditionsCalculationEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + CalculationGroupEntityId INTEGER NOT NULL, + ForeshoreProfileEntityId INTEGER NULL, + HydraulicLocationEntityId INTEGER NULL, + HydraulicLocationCalculationForTargetProbabilityCollectionEntityId INTEGER NULL, 'Order' INT (4) NOT NULL, - 'Name' VARCHAR (260) NULL, - 'Comments' TEXT NULL, - 'UseBreakWater' TINYINT (1) NOT NULL, -- true or false - 'BreakWaterType' TINYINT (1) NOT NULL, -- Enum: 1 = Wall, 2 = Caisson, 3 = Dam - 'BreakWaterHeight' REAL NULL, - 'UseForeshore' TINYINT (1) NOT NULL, -- true or false - 'Orientation' REAL NULL, - 'UpperBoundaryRevetment' REAL NULL, - 'LowerBoundaryRevetment' REAL NULL, - 'UpperBoundaryWaterLevels' REAL NULL, - 'LowerBoundaryWaterLevels' REAL NULL, - 'StepSize' TINYINT (1) NOT NULL, -- Enum: 1 = 0.5, 2 = 1.0, 3 = 2.0 - 'WaterLevelType' TINYINT (1) NOT NULL, -- Enum: 1 = None, 2 = MaximumAllowableFloodingProbability, 3 = SignalFloodingProbability, 4 = UserDefinedTargetProbability - 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_HydraulicLocationCalculationForTargetProbabilityCollectionEntity' FOREIGN KEY ('HydraulicLocationCalculationForTargetProbabilityCollectionEntityId') REFERENCES 'HydraulicLocationCalculationForTargetProbabilityCollectionEntity' ('HydraulicLocationCalculationForTargetProbabilityCollectionEntityId') ON DELETE Set Null ON UPDATE Cascade, - CONSTRAINT 'FK_WaveImpactAsphaltCoverWaveConditionsCalculationEntity_HydraulicLocationEntity' FOREIGN KEY ('HydraulicLocationEntityId') REFERENCES 'HydraulicLocationEntity' ('HydraulicLocationEntityId') ON DELETE Set Null ON UPDATE Cascade + Name VARCHAR (260) NULL, + Comments TEXT NULL COLLATE NOCASE, + UseBreakWater TINYINT (1) NOT NULL, -- true or false + BreakWaterType TINYINT (1) NOT NULL, -- Enum: 1 = Wall, 2 = Caisson, 3 = Dam + BreakWaterHeight REAL NULL, + UseForeshore TINYINT (1) NOT NULL, -- true or false + Orientation REAL NULL, + UpperBoundaryRevetment REAL NULL, + LowerBoundaryRevetment REAL NULL, + UpperBoundaryWaterLevels REAL NULL, + LowerBoundaryWaterLevels REAL NULL, + StepSize TINYINT (1) NOT NULL, -- Enum: 1 = 0.5, 2 = 1.0, 3 = 2.0 + WaterLevelType TINYINT (1) NOT NULL, -- Enum: 1 = None, 2 = MaximumAllowableFloodingProbability, 3 = SignalFloodingProbability, 4 = UserDefinedTargetProbability + 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_HydraulicLocationCalculationForTargetProbabilityCollectionEntity FOREIGN KEY (HydraulicLocationCalculationForTargetProbabilityCollectionEntityId) REFERENCES HydraulicLocationCalculationForTargetProbabilityCollectionEntity (HydraulicLocationCalculationForTargetProbabilityCollectionEntityId) ON DELETE Set Null ON UPDATE Cascade, + CONSTRAINT FK_WaveImpactAsphaltCoverWaveConditionsCalculationEntity_HydraulicLocationEntity FOREIGN KEY (HydraulicLocationEntityId) REFERENCES HydraulicLocationEntity (HydraulicLocationEntityId) ON DELETE Set Null ON UPDATE Cascade ) ; -CREATE TABLE 'WaveImpactAsphaltCoverWaveConditionsOutputEntity' +CREATE TABLE WaveImpactAsphaltCoverWaveConditionsOutputEntity ( - 'WaveImpactAsphaltCoverWaveConditionsOutputEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'WaveImpactAsphaltCoverWaveConditionsCalculationEntityId' INTEGER NOT NULL, + WaveImpactAsphaltCoverWaveConditionsOutputEntityId INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + WaveImpactAsphaltCoverWaveConditionsCalculationEntityId INTEGER NOT NULL, 'Order' INT (4) NOT NULL, - 'WaterLevel' REAL NULL, - 'WaveHeight' REAL NULL, - 'WavePeakPeriod' REAL NULL, - 'WaveAngle' REAL NULL, - 'WaveDirection' REAL NULL, - 'TargetProbability' REAL NULL, - 'TargetReliability' REAL NULL, - 'CalculatedProbability' REAL NULL, - 'CalculatedReliability' REAL NULL, - '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 + WaterLevel REAL NULL, + WaveHeight REAL NULL, + WavePeakPeriod REAL NULL, + WaveAngle REAL NULL, + WaveDirection REAL NULL, + TargetProbability REAL NULL, + TargetReliability REAL NULL, + CalculatedProbability REAL NULL, + CalculatedReliability REAL NULL, + 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 ) ; /* Create Indexes and Triggers */ -CREATE INDEX 'IXFK_AssessmentSectionEntity_HydraulicLocationCalculationCollectionEntity1' - ON 'AssessmentSectionEntity' ('HydraulicLocationCalculationCollectionEntity1Id' ASC) +CREATE INDEX IXFK_AssessmentSectionEntity_HydraulicLocationCalculationCollectionEntity1 + ON AssessmentSectionEntity (HydraulicLocationCalculationCollectionEntity1Id ASC) ; -CREATE INDEX 'IXFK_AssessmentSectionEntity_HydraulicLocationCalculationCollectionEntity2' - ON 'AssessmentSectionEntity' ('HydraulicLocationCalculationCollectionEntity2Id' ASC) +CREATE INDEX IXFK_AssessmentSectionEntity_HydraulicLocationCalculationCollectionEntity2 + ON AssessmentSectionEntity (HydraulicLocationCalculationCollectionEntity2Id ASC) ; -CREATE INDEX 'IXFK_AssessmentSectionEntity_ProjectEntity' - ON 'AssessmentSectionEntity' ('ProjectEntityId' ASC) +CREATE INDEX IXFK_AssessmentSectionEntity_ProjectEntity + ON AssessmentSectionEntity (ProjectEntityId ASC) ; CREATE TRIGGER [TR_AfterDeleteAssessmentSectionEntity_RemoveHydraulicLocationCalculationCollectionEntities] AFTER DELETE @@ -2001,136 +2001,136 @@ END; ; -CREATE INDEX 'IXFK_FailureMechanismEntity_AssessmentSectionEntity' - ON 'FailureMechanismEntity' ('AssessmentSectionEntityId' ASC) +CREATE INDEX IXFK_FailureMechanismEntity_AssessmentSectionEntity + ON FailureMechanismEntity (AssessmentSectionEntityId ASC) ; -CREATE INDEX 'IXFK_FailureMechanismEntity_CalculationGroupEntity' - ON 'FailureMechanismEntity' ('CalculationGroupEntityId' ASC) +CREATE INDEX IXFK_FailureMechanismEntity_CalculationGroupEntity + ON FailureMechanismEntity (CalculationGroupEntityId ASC) ; -CREATE INDEX 'IXFK_ClosingStructuresFailureMechanismMetaEntity_FailureMechanismEntity' - ON 'ClosingStructuresFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) +CREATE INDEX IXFK_ClosingStructuresFailureMechanismMetaEntity_FailureMechanismEntity + ON ClosingStructuresFailureMechanismMetaEntity (FailureMechanismEntityId ASC) ; -CREATE INDEX 'IXFK_CalculationGroupEntity_CalculationGroupEntity' - ON 'CalculationGroupEntity' ('ParentCalculationGroupEntityId' ASC) +CREATE INDEX IXFK_CalculationGroupEntity_CalculationGroupEntity + ON CalculationGroupEntity (ParentCalculationGroupEntityId ASC) ; -CREATE INDEX 'IXFK_HydraulicLocationEntity_HydraulicBoundaryDatabaseEntity' - ON 'HydraulicLocationEntity' ('HydraulicBoundaryDatabaseEntityId' ASC) +CREATE INDEX IXFK_HydraulicLocationEntity_HydraulicBoundaryDatabaseEntity + ON HydraulicLocationEntity (HydraulicBoundaryDatabaseEntityId ASC) ; -CREATE INDEX 'IXFK_GrassCoverErosionInwardsFailureMechanismMetaEntity_FailureMechanismEntity' - ON 'GrassCoverErosionInwardsFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) +CREATE INDEX IXFK_GrassCoverErosionInwardsFailureMechanismMetaEntity_FailureMechanismEntity + ON GrassCoverErosionInwardsFailureMechanismMetaEntity (FailureMechanismEntityId ASC) ; -CREATE INDEX 'IXFK_SemiProbabilisticPipingCalculationEntity_PipingStochasticSoilProfileEntity' - ON 'SemiProbabilisticPipingCalculationEntity' ('PipingStochasticSoilProfileEntityId' ASC) +CREATE INDEX IXFK_SemiProbabilisticPipingCalculationEntity_PipingStochasticSoilProfileEntity + ON SemiProbabilisticPipingCalculationEntity (PipingStochasticSoilProfileEntityId ASC) ; -CREATE INDEX 'IXFK_SemiProbabilisticPipingCalculationEntity_SurfaceLineEntity' - ON 'SemiProbabilisticPipingCalculationEntity' ('SurfaceLineEntityId' ASC) +CREATE INDEX IXFK_SemiProbabilisticPipingCalculationEntity_SurfaceLineEntity + ON SemiProbabilisticPipingCalculationEntity (SurfaceLineEntityId ASC) ; -CREATE INDEX 'IXFK_SemiProbabilisticPipingCalculationEntity_HydraulicLocationEntity' - ON 'SemiProbabilisticPipingCalculationEntity' ('HydraulicLocationEntityId' ASC) +CREATE INDEX IXFK_SemiProbabilisticPipingCalculationEntity_HydraulicLocationEntity + ON SemiProbabilisticPipingCalculationEntity (HydraulicLocationEntityId ASC) ; -CREATE INDEX 'IXFK_SemiProbabilisticPipingCalculationEntity_CalculationGroupEntity' - ON 'SemiProbabilisticPipingCalculationEntity' ('CalculationGroupEntityId' ASC) +CREATE INDEX IXFK_SemiProbabilisticPipingCalculationEntity_CalculationGroupEntity + ON SemiProbabilisticPipingCalculationEntity (CalculationGroupEntityId ASC) ; -CREATE INDEX 'IXFK_GrassCoverErosionInwardsCalculationEntity_CalculationGroupEntity' - ON 'GrassCoverErosionInwardsCalculationEntity' ('CalculationGroupEntityId' ASC) +CREATE INDEX IXFK_GrassCoverErosionInwardsCalculationEntity_CalculationGroupEntity + ON GrassCoverErosionInwardsCalculationEntity (CalculationGroupEntityId ASC) ; -CREATE INDEX 'IXFK_GrassCoverErosionInwardsCalculationEntity_DikeProfileEntity' - ON 'GrassCoverErosionInwardsCalculationEntity' ('DikeProfileEntityId' ASC) +CREATE INDEX IXFK_GrassCoverErosionInwardsCalculationEntity_DikeProfileEntity + ON GrassCoverErosionInwardsCalculationEntity (DikeProfileEntityId ASC) ; -CREATE INDEX 'IXFK_GrassCoverErosionInwardsCalculationEntity_HydraulicLocationEntity' - ON 'GrassCoverErosionInwardsCalculationEntity' ('HydraulicLocationEntityId' ASC) +CREATE INDEX IXFK_GrassCoverErosionInwardsCalculationEntity_HydraulicLocationEntity + ON GrassCoverErosionInwardsCalculationEntity (HydraulicLocationEntityId ASC) ; -CREATE INDEX 'IXFK_GrassCoverSlipOffInwardsFailureMechanismMetaEntity_FailureMechanismEntity' - ON 'GrassCoverSlipOffInwardsFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) +CREATE INDEX IXFK_GrassCoverSlipOffInwardsFailureMechanismMetaEntity_FailureMechanismEntity + ON GrassCoverSlipOffInwardsFailureMechanismMetaEntity (FailureMechanismEntityId ASC) ; -CREATE INDEX 'IXFK_GrassCoverErosionOutwardsFailureMechanismMetaEntity_FailureMechanismEntity' - ON 'GrassCoverErosionOutwardsFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) +CREATE INDEX IXFK_GrassCoverErosionOutwardsFailureMechanismMetaEntity_FailureMechanismEntity + ON GrassCoverErosionOutwardsFailureMechanismMetaEntity (FailureMechanismEntityId ASC) ; -CREATE INDEX 'IXFK_PipingStochasticSoilProfileEntity_SoilProfileEntity' - ON 'PipingStochasticSoilProfileEntity' ('PipingSoilProfileEntityId' ASC) +CREATE INDEX IXFK_PipingStochasticSoilProfileEntity_SoilProfileEntity + ON PipingStochasticSoilProfileEntity (PipingSoilProfileEntityId ASC) ; -CREATE INDEX 'IXFK_PipingStochasticSoilProfileEntity_StochasticSoilModelEntity' - ON 'PipingStochasticSoilProfileEntity' ('StochasticSoilModelEntityId' ASC) +CREATE INDEX IXFK_PipingStochasticSoilProfileEntity_StochasticSoilModelEntity + ON PipingStochasticSoilProfileEntity (StochasticSoilModelEntityId ASC) ; -CREATE INDEX 'IXFK_PipingScenarioConfigurationPerFailureMechanismSectionEntity_FailureMechanismSectionEntity' - ON 'PipingScenarioConfigurationPerFailureMechanismSectionEntity' ('FailureMechanismSectionEntityId' ASC) +CREATE INDEX IXFK_PipingScenarioConfigurationPerFailureMechanismSectionEntity_FailureMechanismSectionEntity + ON PipingScenarioConfigurationPerFailureMechanismSectionEntity (FailureMechanismSectionEntityId ASC) ; -CREATE INDEX 'IXFK_StochasticSoilModelEntity_FailureMechanismEntity' - ON 'StochasticSoilModelEntity' ('FailureMechanismEntityId' ASC) +CREATE INDEX IXFK_StochasticSoilModelEntity_FailureMechanismEntity + ON StochasticSoilModelEntity (FailureMechanismEntityId ASC) ; -CREATE INDEX 'IXFK_SurfaceLineEntity_FailureMechanismEntity' - ON 'SurfaceLineEntity' ('FailureMechanismEntityId' ASC) +CREATE INDEX IXFK_SurfaceLineEntity_FailureMechanismEntity + ON SurfaceLineEntity (FailureMechanismEntityId ASC) ; -CREATE INDEX 'IXFK_SurfaceLinePointEntity_SurfaceLineEntity' - ON 'PipingCharacteristicPointEntity' ('SurfaceLineEntityId' ASC) +CREATE INDEX IXFK_SurfaceLinePointEntity_SurfaceLineEntity + ON PipingCharacteristicPointEntity (SurfaceLineEntityId ASC) ; -CREATE INDEX 'IXFK_WaterPressureAsphaltCoverFailureMechanismMetaEntity_FailureMechanismEntity' - ON 'WaterPressureAsphaltCoverFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) +CREATE INDEX IXFK_WaterPressureAsphaltCoverFailureMechanismMetaEntity_FailureMechanismEntity + ON WaterPressureAsphaltCoverFailureMechanismMetaEntity (FailureMechanismEntityId ASC) ; -CREATE INDEX 'IXFK_WaveImpactAsphaltCoverFailureMechanismMetaEntity_FailureMechanismEntity' - ON 'WaveImpactAsphaltCoverFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) +CREATE INDEX IXFK_WaveImpactAsphaltCoverFailureMechanismMetaEntity_FailureMechanismEntity + ON WaveImpactAsphaltCoverFailureMechanismMetaEntity (FailureMechanismEntityId ASC) ; -CREATE INDEX 'IXFK_AdoptableFailureMechanismSectionResultEntity_FailureMechanismSectionEntity' - ON 'AdoptableFailureMechanismSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) +CREATE INDEX IXFK_AdoptableFailureMechanismSectionResultEntity_FailureMechanismSectionEntity + ON AdoptableFailureMechanismSectionResultEntity (FailureMechanismSectionEntityId ASC) ; -CREATE INDEX 'IXFK_AdoptableWithProfileProbabilityFailureMechanismSectionResultEntity_FailureMechanismSectionEntity' - ON 'AdoptableWithProfileProbabilityFailureMechanismSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) +CREATE INDEX IXFK_AdoptableWithProfileProbabilityFailureMechanismSectionResultEntity_FailureMechanismSectionEntity + ON AdoptableWithProfileProbabilityFailureMechanismSectionResultEntity (FailureMechanismSectionEntityId ASC) ; -CREATE INDEX 'IXFK_BackgroundDataEntity_AssessmentSectionEntity' - ON 'BackgroundDataEntity' ('AssessmentSectionEntityId' ASC) +CREATE INDEX IXFK_BackgroundDataEntity_AssessmentSectionEntity + ON BackgroundDataEntity (AssessmentSectionEntityId ASC) ; -CREATE INDEX 'IXFK_BackgroundDataMetaEntity_BackgroundDataEntity' - ON 'BackgroundDataMetaEntity' ('BackgroundDataEntityId' ASC) +CREATE INDEX IXFK_BackgroundDataMetaEntity_BackgroundDataEntity + ON BackgroundDataMetaEntity (BackgroundDataEntityId ASC) ; -CREATE INDEX 'IXFK_ClosingStructureEntity_FailureMechanismEntity' - ON 'ClosingStructureEntity' ('FailureMechanismEntityId' ASC) +CREATE INDEX IXFK_ClosingStructureEntity_FailureMechanismEntity + ON ClosingStructureEntity (FailureMechanismEntityId ASC) ; -CREATE INDEX 'IXFK_ClosingStructuresCalculationEntity_CalculationGroupEntity' - ON 'ClosingStructuresCalculationEntity' ('CalculationGroupEntityId' ASC) +CREATE INDEX IXFK_ClosingStructuresCalculationEntity_CalculationGroupEntity + ON ClosingStructuresCalculationEntity (CalculationGroupEntityId ASC) ; -CREATE INDEX 'IXFK_ClosingStructuresCalculationEntity_ClosingStructureEntity' - ON 'ClosingStructuresCalculationEntity' ('ClosingStructureEntityId' ASC) +CREATE INDEX IXFK_ClosingStructuresCalculationEntity_ClosingStructureEntity + ON ClosingStructuresCalculationEntity (ClosingStructureEntityId ASC) ; -CREATE INDEX 'IXFK_ClosingStructuresCalculationEntity_ForeshoreProfileEntity' - ON 'ClosingStructuresCalculationEntity' ('ForeshoreProfileEntityId' ASC) +CREATE INDEX IXFK_ClosingStructuresCalculationEntity_ForeshoreProfileEntity + ON ClosingStructuresCalculationEntity (ForeshoreProfileEntityId ASC) ; -CREATE INDEX 'IXFK_ClosingStructuresCalculationEntity_HydraulicLocationEntity' - ON 'ClosingStructuresCalculationEntity' ('HydraulicLocationEntityId' ASC) +CREATE INDEX IXFK_ClosingStructuresCalculationEntity_HydraulicLocationEntity + ON ClosingStructuresCalculationEntity (HydraulicLocationEntityId ASC) ; -CREATE INDEX 'IXFK_ClosingStructuresOutputEntity_ClosingStructuresCalculationEntity' - ON 'ClosingStructuresOutputEntity' ('ClosingStructuresCalculationEntityId' ASC) +CREATE INDEX IXFK_ClosingStructuresOutputEntity_ClosingStructuresCalculationEntity + ON ClosingStructuresOutputEntity (ClosingStructuresCalculationEntityId ASC) ; CREATE TRIGGER [TR_AfterDeleteClosingStructuresOutputEntity_RemoveGeneralResultFaultTreeIllustrationPointEntity] AFTER DELETE @@ -2144,44 +2144,44 @@ END; ; -CREATE INDEX 'IXFK_DikeProfileEntity_FailureMechanismEntity' - ON 'DikeProfileEntity' ('FailureMechanismEntityId' ASC) +CREATE INDEX IXFK_DikeProfileEntity_FailureMechanismEntity + ON DikeProfileEntity (FailureMechanismEntityId ASC) ; -CREATE INDEX 'IXFK_DuneErosionFailureMechanismMetaEntity_FailureMechanismEntity' - ON 'DuneErosionFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) +CREATE INDEX IXFK_DuneErosionFailureMechanismMetaEntity_FailureMechanismEntity + ON DuneErosionFailureMechanismMetaEntity (FailureMechanismEntityId ASC) ; -CREATE INDEX 'IXFK_DuneLocationCalculationEntity_DuneLocationCalculationCollectionEntity' - ON 'DuneLocationCalculationEntity' ('DuneLocationCalculationForTargetProbabilityCollectionEntityId' ASC) +CREATE INDEX IXFK_DuneLocationCalculationEntity_DuneLocationCalculationCollectionEntity + ON DuneLocationCalculationEntity (DuneLocationCalculationForTargetProbabilityCollectionEntityId ASC) ; -CREATE INDEX 'IXFK_DuneLocationCalculationEntity_DuneLocationEntity' - ON 'DuneLocationCalculationEntity' ('DuneLocationEntityId' ASC) +CREATE INDEX IXFK_DuneLocationCalculationEntity_DuneLocationEntity + ON DuneLocationCalculationEntity (DuneLocationEntityId ASC) ; -CREATE INDEX 'IXFK_DuneLocationCalculationForTargetProbabilityCollectionEntity_DuneErosionFailureMechanismMetaEntity' - ON 'DuneLocationCalculationForTargetProbabilityCollectionEntity' ('DuneErosionFailureMechanismMetaEntityId' ASC) +CREATE INDEX IXFK_DuneLocationCalculationForTargetProbabilityCollectionEntity_DuneErosionFailureMechanismMetaEntity + ON DuneLocationCalculationForTargetProbabilityCollectionEntity (DuneErosionFailureMechanismMetaEntityId ASC) ; -CREATE INDEX 'IXFK_DuneLocationCalculationOutputEntity_DuneLocationCalculationEntity' - ON 'DuneLocationCalculationOutputEntity' ('DuneLocationCalculationEntityId' ASC) +CREATE INDEX IXFK_DuneLocationCalculationOutputEntity_DuneLocationCalculationEntity + ON DuneLocationCalculationOutputEntity (DuneLocationCalculationEntityId ASC) ; -CREATE INDEX 'IXFK_DuneLocationEntity_FailureMechanismEntity' - ON 'DuneLocationEntity' ('FailureMechanismEntityId' ASC) +CREATE INDEX IXFK_DuneLocationEntity_FailureMechanismEntity + ON DuneLocationEntity (FailureMechanismEntityId ASC) ; -CREATE INDEX 'IXFK_DuneLocationEntity_HydraulicLocationEntity' - ON 'DuneLocationEntity' ('HydraulicLocationEntityId' ASC) +CREATE INDEX IXFK_DuneLocationEntity_HydraulicLocationEntity + ON DuneLocationEntity (HydraulicLocationEntityId ASC) ; -CREATE INDEX 'IXFK_FailureMechanismFailureMechanismSectionEntity_FailureMechanismEntity' - ON 'FailureMechanismFailureMechanismSectionEntity' ('FailureMechanismEntityId' ASC) +CREATE INDEX IXFK_FailureMechanismFailureMechanismSectionEntity_FailureMechanismEntity + ON FailureMechanismFailureMechanismSectionEntity (FailureMechanismEntityId ASC) ; -CREATE INDEX 'IXFK_FailureMechanismFailureMechanismSectionEntity_FailureMechanismSectionEntity' - ON 'FailureMechanismFailureMechanismSectionEntity' ('FailureMechanismSectionEntityId' ASC) +CREATE INDEX IXFK_FailureMechanismFailureMechanismSectionEntity_FailureMechanismSectionEntity + ON FailureMechanismFailureMechanismSectionEntity (FailureMechanismSectionEntityId ASC) ; CREATE TRIGGER [TR_AfterDeleteFailureMechanismFailureMechanismSectionEntity_RemoveFailureMechanismSectionEntityId] AFTER DELETE @@ -2195,16 +2195,16 @@ END; ; -CREATE INDEX 'IXFK_FaultTreeIllustrationPoint_FaultTreeIllustrationPoint' - ON 'FaultTreeIllustrationPointEntity' ('ParentFaultTreeIllustrationPointEntityId' ASC) +CREATE INDEX IXFK_FaultTreeIllustrationPoint_FaultTreeIllustrationPoint + ON FaultTreeIllustrationPointEntity (ParentFaultTreeIllustrationPointEntityId ASC) ; -CREATE INDEX 'IXFK_FaultTreeIllustrationPointStochastEntity_FaultTreeIllustrationPoint' - ON 'FaultTreeIllustrationPointStochastEntity' ('FaultTreeIllustrationPointEntityId' ASC) +CREATE INDEX IXFK_FaultTreeIllustrationPointStochastEntity_FaultTreeIllustrationPoint + ON FaultTreeIllustrationPointStochastEntity (FaultTreeIllustrationPointEntityId ASC) ; -CREATE INDEX 'IXFK_FaultTreeIllustrationPointStochastEntity_StochastEntity' - ON 'FaultTreeIllustrationPointStochastEntity' ('StochastEntityId' ASC) +CREATE INDEX IXFK_FaultTreeIllustrationPointStochastEntity_StochastEntity + ON FaultTreeIllustrationPointStochastEntity (StochastEntityId ASC) ; CREATE TRIGGER [TR_AfterDeleteFaultTreeIllustrationPointStochastEntity_RemoveStochastEntity] AFTER DELETE @@ -2218,12 +2218,12 @@ END; ; -CREATE INDEX 'IXFK_FaultTreeIllustrationPointEntity_FaultTreeIllustrationPointEntity' - ON 'FaultTreeSubmechanismIllustrationPointEntity' ('FaultTreeIllustrationPointEntityId' ASC) +CREATE INDEX IXFK_FaultTreeIllustrationPointEntity_FaultTreeIllustrationPointEntity + ON FaultTreeSubmechanismIllustrationPointEntity (FaultTreeIllustrationPointEntityId ASC) ; -CREATE INDEX 'IXFK_FaultTreeIllustrationPointEntity_SubMechanismIllustrationPointEntity' - ON 'FaultTreeSubmechanismIllustrationPointEntity' ('SubMechanismIllustrationPointEntityId' ASC) +CREATE INDEX IXFK_FaultTreeIllustrationPointEntity_SubMechanismIllustrationPointEntity + ON FaultTreeSubmechanismIllustrationPointEntity (SubMechanismIllustrationPointEntityId ASC) ; CREATE TRIGGER [TR_AfterDeleteFaultTreeSubmechanismIllustrationPointEntity_RemoveSubmechanismIllustrationPointEntity] AFTER DELETE @@ -2237,16 +2237,16 @@ END; ; -CREATE INDEX 'IXFK_ForeshoreProfileEntity_FailureMechanismEntity' - ON 'ForeshoreProfileEntity' ('FailureMechanismEntityId' ASC) +CREATE INDEX IXFK_ForeshoreProfileEntity_FailureMechanismEntity + ON ForeshoreProfileEntity (FailureMechanismEntityId ASC) ; -CREATE INDEX 'IXFK_GeneralResultFaultTreeIllustrationPointStochastEntity_GeneralResultFaultTreeIllustrationPointEntity' - ON 'GeneralResultFaultTreeIllustrationPointStochastEntity' ('GeneralResultFaultTreeIllustrationPointEntityId' ASC) +CREATE INDEX IXFK_GeneralResultFaultTreeIllustrationPointStochastEntity_GeneralResultFaultTreeIllustrationPointEntity + ON GeneralResultFaultTreeIllustrationPointStochastEntity (GeneralResultFaultTreeIllustrationPointEntityId ASC) ; -CREATE INDEX 'IXFK_GeneralResultFaultTreeIllustrationPointStochastEntity_StochastEntity' - ON 'GeneralResultFaultTreeIllustrationPointStochastEntity' ('StochastEntityId' ASC) +CREATE INDEX IXFK_GeneralResultFaultTreeIllustrationPointStochastEntity_StochastEntity + ON GeneralResultFaultTreeIllustrationPointStochastEntity (StochastEntityId ASC) ; CREATE TRIGGER [TR_AfterDeleteGeneralResultFaultTreeIllustrationPointStochastEntity_RemoveStochastEntity] AFTER DELETE @@ -2260,12 +2260,12 @@ END; ; -CREATE INDEX 'IXFK_GeneralResultSubMechanismIllustrationPointStochastEntity_GeneralResultSubMechanismIllustrationPointEntity' - ON 'GeneralResultSubMechanismIllustrationPointStochastEntity' ('GeneralResultSubMechanismIllustrationPointEntityId' ASC) +CREATE INDEX IXFK_GeneralResultSubMechanismIllustrationPointStochastEntity_GeneralResultSubMechanismIllustrationPointEntity + ON GeneralResultSubMechanismIllustrationPointStochastEntity (GeneralResultSubMechanismIllustrationPointEntityId ASC) ; -CREATE INDEX 'IXFK_GeneralResultSubMechanismIllustrationPointStochastEntity_StochastEntity' - ON 'GeneralResultSubMechanismIllustrationPointStochastEntity' ('StochastEntityId' ASC) +CREATE INDEX IXFK_GeneralResultSubMechanismIllustrationPointStochastEntity_StochastEntity + ON GeneralResultSubMechanismIllustrationPointStochastEntity (StochastEntityId ASC) ; CREATE TRIGGER [TR_AfterDeleteGeneralResultSubMechanismIllustrationPointStochastEntity_RemoveStochastEntity] AFTER DELETE @@ -2279,12 +2279,12 @@ END; ; -CREATE INDEX 'IXFK_GrassCoverErosionInwardsDikeHeightOutputEntity_GeneralResultFaultTreeIllustrationPointEntity' - ON 'GrassCoverErosionInwardsDikeHeightOutputEntity' ('GeneralResultFaultTreeIllustrationPointEntityId' ASC) +CREATE INDEX IXFK_GrassCoverErosionInwardsDikeHeightOutputEntity_GeneralResultFaultTreeIllustrationPointEntity + ON GrassCoverErosionInwardsDikeHeightOutputEntity (GeneralResultFaultTreeIllustrationPointEntityId ASC) ; -CREATE INDEX 'IXFK_GrassCoverErosionInwardsDikeHeightOutputEntity_GrassCoverErosionInwardsOutputEntity' - ON 'GrassCoverErosionInwardsDikeHeightOutputEntity' ('GrassCoverErosionInwardsOutputEntityId' ASC) +CREATE INDEX IXFK_GrassCoverErosionInwardsDikeHeightOutputEntity_GrassCoverErosionInwardsOutputEntity + ON GrassCoverErosionInwardsDikeHeightOutputEntity (GrassCoverErosionInwardsOutputEntityId ASC) ; CREATE TRIGGER [TR_AfterDeleteGrassCoverErosionInwardsDikeHeightOutputEntity_RemoveGeneralResultFaultTreeIllustrationPointEntity] AFTER DELETE @@ -2298,12 +2298,12 @@ END; ; -CREATE INDEX 'IXFK_GrassCoverErosionInwardsOutputEntity_GeneralResultFaultTreeIllustrationPointEntity' - ON 'GrassCoverErosionInwardsOutputEntity' ('GeneralResultFaultTreeIllustrationPointEntityId' ASC) +CREATE INDEX IXFK_GrassCoverErosionInwardsOutputEntity_GeneralResultFaultTreeIllustrationPointEntity + ON GrassCoverErosionInwardsOutputEntity (GeneralResultFaultTreeIllustrationPointEntityId ASC) ; -CREATE INDEX 'IXFK_GrassCoverErosionInwardsOutputEntity_GrassCoverErosionInwardsCalculationEntity' - ON 'GrassCoverErosionInwardsOutputEntity' ('GrassCoverErosionInwardsCalculationEntityId' ASC) +CREATE INDEX IXFK_GrassCoverErosionInwardsOutputEntity_GrassCoverErosionInwardsCalculationEntity + ON GrassCoverErosionInwardsOutputEntity (GrassCoverErosionInwardsCalculationEntityId ASC) ; CREATE TRIGGER [TR_AfterDeleteGrassCoverErosionInwardsOutputEntity_RemoveGeneralResultFaultTreeIllustrationPointEntity] AFTER DELETE @@ -2317,12 +2317,12 @@ END; ; -CREATE INDEX 'IXFK_GrassCoverErosionInwardsOvertoppingRateOutputEntity_GeneralResultFaultTreeIllustrationPointEntity' - ON 'GrassCoverErosionInwardsOvertoppingRateOutputEntity' ('GeneralResultFaultTreeIllustrationPointEntityId' ASC) +CREATE INDEX IXFK_GrassCoverErosionInwardsOvertoppingRateOutputEntity_GeneralResultFaultTreeIllustrationPointEntity + ON GrassCoverErosionInwardsOvertoppingRateOutputEntity (GeneralResultFaultTreeIllustrationPointEntityId ASC) ; -CREATE INDEX 'IXFK_GrassCoverErosionInwardsOvertoppingRateOutputEntity_GrassCoverErosionInwardsOutputEntity' - ON 'GrassCoverErosionInwardsOvertoppingRateOutputEntity' ('GrassCoverErosionInwardsOutputEntityId' ASC) +CREATE INDEX IXFK_GrassCoverErosionInwardsOvertoppingRateOutputEntity_GrassCoverErosionInwardsOutputEntity + ON GrassCoverErosionInwardsOvertoppingRateOutputEntity (GrassCoverErosionInwardsOutputEntityId ASC) ; CREATE TRIGGER [TR_AfterDeleteGrassCoverErosionInwardsOvertoppingRateOutputEntity_RemoveGeneralResultFaultTreeIllustrationPointEntity] AFTER DELETE @@ -2336,56 +2336,56 @@ END; ; -CREATE INDEX 'IXFK_GrassCoverErosionOutwardsWaveConditionsCalculationEntity_CalculationGroupEntity' - ON 'GrassCoverErosionOutwardsWaveConditionsCalculationEntity' ('CalculationGroupEntityId' ASC) +CREATE INDEX IXFK_GrassCoverErosionOutwardsWaveConditionsCalculationEntity_CalculationGroupEntity + ON GrassCoverErosionOutwardsWaveConditionsCalculationEntity (CalculationGroupEntityId ASC) ; -CREATE INDEX 'IXFK_GrassCoverErosionOutwardsWaveConditionsCalculationEntity_ForeshoreProfileEntity' - ON 'GrassCoverErosionOutwardsWaveConditionsCalculationEntity' ('ForeshoreProfileEntityId' ASC) +CREATE INDEX IXFK_GrassCoverErosionOutwardsWaveConditionsCalculationEntity_ForeshoreProfileEntity + ON GrassCoverErosionOutwardsWaveConditionsCalculationEntity (ForeshoreProfileEntityId ASC) ; -CREATE INDEX 'IXFK_GrassCoverErosionOutwardsWaveConditionsCalculationEntity_HydraulicLocationCalculationForTargetProbabilityCollectionEntity' - ON 'GrassCoverErosionOutwardsWaveConditionsCalculationEntity' ('HydraulicLocationCalculationForTargetProbabilityCollectionEntityId' ASC) +CREATE INDEX IXFK_GrassCoverErosionOutwardsWaveConditionsCalculationEntity_HydraulicLocationCalculationForTargetProbabilityCollectionEntity + ON GrassCoverErosionOutwardsWaveConditionsCalculationEntity (HydraulicLocationCalculationForTargetProbabilityCollectionEntityId ASC) ; -CREATE INDEX 'IXFK_GrassCoverErosionOutwardsWaveConditionsCalculationEntity_HydraulicLocationEntity' - ON 'GrassCoverErosionOutwardsWaveConditionsCalculationEntity' ('HydraulicLocationEntityId' ASC) +CREATE INDEX IXFK_GrassCoverErosionOutwardsWaveConditionsCalculationEntity_HydraulicLocationEntity + ON GrassCoverErosionOutwardsWaveConditionsCalculationEntity (HydraulicLocationEntityId ASC) ; -CREATE INDEX 'IXFK_GrassCoverErosionOutwardsWaveConditionsOutputEntity_GrassCoverErosionOutwardsWaveConditionsCalculationEntity' - ON 'GrassCoverErosionOutwardsWaveConditionsOutputEntity' ('GrassCoverErosionOutwardsWaveConditionsCalculationEntityId' ASC) +CREATE INDEX IXFK_GrassCoverErosionOutwardsWaveConditionsOutputEntity_GrassCoverErosionOutwardsWaveConditionsCalculationEntity + ON GrassCoverErosionOutwardsWaveConditionsOutputEntity (GrassCoverErosionOutwardsWaveConditionsCalculationEntityId ASC) ; -CREATE INDEX 'IXFK_GrassCoverSlipOffOutwardsFailureMechanismMetaEntity_FailureMechanismEntity' - ON 'GrassCoverSlipOffOutwardsFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) +CREATE INDEX IXFK_GrassCoverSlipOffOutwardsFailureMechanismMetaEntity_FailureMechanismEntity + ON GrassCoverSlipOffOutwardsFailureMechanismMetaEntity (FailureMechanismEntityId ASC) ; -CREATE INDEX 'IXFK_HeightStructure_FailureMechanismEntity' - ON 'HeightStructureEntity' ('FailureMechanismEntityId' ASC) +CREATE INDEX IXFK_HeightStructure_FailureMechanismEntity + ON HeightStructureEntity (FailureMechanismEntityId ASC) ; -CREATE INDEX 'IXFK_HeightStructuresCalculationEntity_CalculationGroupEntity' - ON 'HeightStructuresCalculationEntity' ('CalculationGroupEntityId' ASC) +CREATE INDEX IXFK_HeightStructuresCalculationEntity_CalculationGroupEntity + ON HeightStructuresCalculationEntity (CalculationGroupEntityId ASC) ; -CREATE INDEX 'IXFK_HeightStructuresCalculationEntity_ForeshoreProfileEntity' - ON 'HeightStructuresCalculationEntity' ('ForeshoreProfileEntityId' ASC) +CREATE INDEX IXFK_HeightStructuresCalculationEntity_ForeshoreProfileEntity + ON HeightStructuresCalculationEntity (ForeshoreProfileEntityId ASC) ; -CREATE INDEX 'IXFK_HeightStructuresCalculationEntity_HeightStructureEntity' - ON 'HeightStructuresCalculationEntity' ('HeightStructureEntityId' ASC) +CREATE INDEX IXFK_HeightStructuresCalculationEntity_HeightStructureEntity + ON HeightStructuresCalculationEntity (HeightStructureEntityId ASC) ; -CREATE INDEX 'IXFK_HeightStructuresCalculationEntity_HydraulicLocationEntity' - ON 'HeightStructuresCalculationEntity' ('HydraulicLocationEntityId' ASC) +CREATE INDEX IXFK_HeightStructuresCalculationEntity_HydraulicLocationEntity + ON HeightStructuresCalculationEntity (HydraulicLocationEntityId ASC) ; -CREATE INDEX 'IXFK_HeightStructuresFailureMechanismMetaEntity_FailureMechanismEntity' - ON 'HeightStructuresFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) +CREATE INDEX IXFK_HeightStructuresFailureMechanismMetaEntity_FailureMechanismEntity + ON HeightStructuresFailureMechanismMetaEntity (FailureMechanismEntityId ASC) ; -CREATE INDEX 'IXFK_HeightStructuresOutputEntity_HeightStructuresCalculationEntity' - ON 'HeightStructuresOutputEntity' ('HeightStructuresCalculationEntityId' ASC) +CREATE INDEX IXFK_HeightStructuresOutputEntity_HeightStructuresCalculationEntity + ON HeightStructuresOutputEntity (HeightStructuresCalculationEntityId ASC) ; CREATE TRIGGER [TR_AfterDeleteHeightStructuresOutputEntity_RemoveGeneralResultFaultTreeIllustrationPointEntity] AFTER DELETE @@ -2399,20 +2399,20 @@ END; ; -CREATE INDEX 'IXFK_HydraulicBoundaryDatabaseEntity_HydraulicBoundaryDataEntity' - ON 'HydraulicBoundaryDatabaseEntity' ('HydraulicBoundaryDataEntityId' ASC) +CREATE INDEX IXFK_HydraulicBoundaryDatabaseEntity_HydraulicBoundaryDataEntity + ON HydraulicBoundaryDatabaseEntity (HydraulicBoundaryDataEntityId ASC) ; -CREATE INDEX 'IXFK_HydraulicBoundaryDatabaseEntity_AssessmentSectionEntity' - ON 'HydraulicBoundaryDataEntity' ('AssessmentSectionEntityId' ASC) +CREATE INDEX IXFK_HydraulicBoundaryDatabaseEntity_AssessmentSectionEntity + ON HydraulicBoundaryDataEntity (AssessmentSectionEntityId ASC) ; -CREATE INDEX 'IXFK_HydraulicLocationCalculationCollectionHydraulicLocationCalculationEntity_HydraulicLocationCalculationCollectionEntity' - ON 'HydraulicLocationCalculationCollectionHydraulicLocationCalculationEntity' ('HydraulicLocationCalculationCollectionEntityId' ASC) +CREATE INDEX IXFK_HydraulicLocationCalculationCollectionHydraulicLocationCalculationEntity_HydraulicLocationCalculationCollectionEntity + ON HydraulicLocationCalculationCollectionHydraulicLocationCalculationEntity (HydraulicLocationCalculationCollectionEntityId ASC) ; -CREATE INDEX 'IXFK_HydraulicLocationCalculationCollectionHydraulicLocationCalculationEntity_HydraulicLocationCalculationEntity' - ON 'HydraulicLocationCalculationCollectionHydraulicLocationCalculationEntity' ('HydraulicLocationCalculationEntityId' ASC) +CREATE INDEX IXFK_HydraulicLocationCalculationCollectionHydraulicLocationCalculationEntity_HydraulicLocationCalculationEntity + ON HydraulicLocationCalculationCollectionHydraulicLocationCalculationEntity (HydraulicLocationCalculationEntityId ASC) ; CREATE TRIGGER [TR_AfterDeleteHydraulicLocationCalculationCollectionHydraulicLocationCalculationEntity_RemoveHydraulicLocationCalculationEntity] AFTER DELETE @@ -2426,20 +2426,20 @@ END; ; -CREATE INDEX 'IXFK_HydraulicLocationCalculationEntity_HydraulicLocationEntity' - ON 'HydraulicLocationCalculationEntity' ('HydraulicLocationEntityId' ASC) +CREATE INDEX IXFK_HydraulicLocationCalculationEntity_HydraulicLocationEntity + ON HydraulicLocationCalculationEntity (HydraulicLocationEntityId ASC) ; -CREATE INDEX 'IXFK_HydraulicBoundaryLocationCalculationsForTargetProbabilityEntity_AssessmentSectionEntity' - ON 'HydraulicLocationCalculationForTargetProbabilityCollectionEntity' ('AssessmentSectionEntityId' ASC) +CREATE INDEX IXFK_HydraulicBoundaryLocationCalculationsForTargetProbabilityEntity_AssessmentSectionEntity + ON HydraulicLocationCalculationForTargetProbabilityCollectionEntity (AssessmentSectionEntityId ASC) ; -CREATE INDEX 'IXFK_HydraulicBoundaryLocationCalculationsForTargetProbabilityHydraulicLocationCalculationEntity_HydraulicBoundaryLocationCalculationsForTargetProbabilityEntity' - ON 'HydraulicLocationCalculationForTargetProbabilityCollectionHydraulicLocationCalculationEntity' ('HydraulicLocationCalculationForTargetProbabilityCollectionEntityId' ASC) +CREATE INDEX IXFK_HydraulicBoundaryLocationCalculationsForTargetProbabilityHydraulicLocationCalculationEntity_HydraulicBoundaryLocationCalculationsForTargetProbabilityEntity + ON HydraulicLocationCalculationForTargetProbabilityCollectionHydraulicLocationCalculationEntity (HydraulicLocationCalculationForTargetProbabilityCollectionEntityId ASC) ; -CREATE INDEX 'IXFK_HydraulicBoundaryLocationCalculationsForTargetProbabilityHydraulicLocationCalculationEntity_HydraulicLocationCalculationEntity' - ON 'HydraulicLocationCalculationForTargetProbabilityCollectionHydraulicLocationCalculationEntity' ('HydraulicLocationCalculationEntityId' ASC) +CREATE INDEX IXFK_HydraulicBoundaryLocationCalculationsForTargetProbabilityHydraulicLocationCalculationEntity_HydraulicLocationCalculationEntity + ON HydraulicLocationCalculationForTargetProbabilityCollectionHydraulicLocationCalculationEntity (HydraulicLocationCalculationEntityId ASC) ; CREATE TRIGGER [TR_AfterDeleteHydraulicLocationCalculationForTargetProbabilityCollectionHydraulicLocationCalculationEntity_RemoveHydraulicLocationCalculationEntity] AFTER DELETE @@ -2453,12 +2453,12 @@ END; ; -CREATE INDEX 'IXFK_HydraulicLocationOutputEntity_GeneralResultSubMechanismIllustrationPointEntity' - ON 'HydraulicLocationOutputEntity' ('GeneralResultSubMechanismIllustrationPointEntityId' ASC) +CREATE INDEX IXFK_HydraulicLocationOutputEntity_GeneralResultSubMechanismIllustrationPointEntity + ON HydraulicLocationOutputEntity (GeneralResultSubMechanismIllustrationPointEntityId ASC) ; -CREATE INDEX 'IXFK_HydraulicLocationOutputEntity_HydraulicLocationCalculationEntity' - ON 'HydraulicLocationOutputEntity' ('HydraulicLocationCalculationEntityId' ASC) +CREATE INDEX IXFK_HydraulicLocationOutputEntity_HydraulicLocationCalculationEntity + ON HydraulicLocationOutputEntity (HydraulicLocationCalculationEntityId ASC) ; CREATE TRIGGER [TR_AfterDeleteHydraulicLocationOutputEntity_RemoveGeneralResultSubMechanismIllustrationPointEntity] AFTER DELETE @@ -2472,36 +2472,36 @@ END; ; -CREATE INDEX 'IXFK_IllustrationPointResultEntity_SubMechanismIllustrationPointEntity' - ON 'IllustrationPointResultEntity' ('SubMechanismIllustrationPointEntityId' ASC) +CREATE INDEX IXFK_IllustrationPointResultEntity_SubMechanismIllustrationPointEntity + ON IllustrationPointResultEntity (SubMechanismIllustrationPointEntityId ASC) ; -CREATE INDEX 'IXFK_MacroStabilityInwardsCalculationEntity_CalculationGroupEntity' - ON 'MacroStabilityInwardsCalculationEntity' ('CalculationGroupEntityId' ASC) +CREATE INDEX IXFK_MacroStabilityInwardsCalculationEntity_CalculationGroupEntity + ON MacroStabilityInwardsCalculationEntity (CalculationGroupEntityId ASC) ; -CREATE INDEX 'IXFK_MacroStabilityInwardsCalculationEntity_HydraulicLocationEntity' - ON 'MacroStabilityInwardsCalculationEntity' ('HydraulicLocationEntityId' ASC) +CREATE INDEX IXFK_MacroStabilityInwardsCalculationEntity_HydraulicLocationEntity + ON MacroStabilityInwardsCalculationEntity (HydraulicLocationEntityId ASC) ; -CREATE INDEX 'IXFK_MacroStabilityInwardsCalculationEntity_MacroStabilityInwardsStochasticSoilProfileEntity' - ON 'MacroStabilityInwardsCalculationEntity' ('MacroStabilityInwardsStochasticSoilProfileEntityId' ASC) +CREATE INDEX IXFK_MacroStabilityInwardsCalculationEntity_MacroStabilityInwardsStochasticSoilProfileEntity + ON MacroStabilityInwardsCalculationEntity (MacroStabilityInwardsStochasticSoilProfileEntityId ASC) ; -CREATE INDEX 'IXFK_MacroStabilityInwardsCalculationOutput_MacroStabilityInwardsCalculationEntity' - ON 'MacroStabilityInwardsCalculationOutputEntity' ('MacroStabilityInwardsCalculationEntityId' ASC) +CREATE INDEX IXFK_MacroStabilityInwardsCalculationOutput_MacroStabilityInwardsCalculationEntity + ON MacroStabilityInwardsCalculationOutputEntity (MacroStabilityInwardsCalculationEntityId ASC) ; -CREATE INDEX 'IXFK_MacroStabilityCharacteristicPointEntity_SurfaceLineEntity' - ON 'MacroStabilityInwardsCharacteristicPointEntity' ('SurfaceLineEntityId' ASC) +CREATE INDEX IXFK_MacroStabilityCharacteristicPointEntity_SurfaceLineEntity + ON MacroStabilityInwardsCharacteristicPointEntity (SurfaceLineEntityId ASC) ; -CREATE INDEX 'IXFK_MacroStabilityInwardsFailureMechanismMetaEntity_FailureMechanismEntity' - ON 'MacroStabilityInwardsFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) +CREATE INDEX IXFK_MacroStabilityInwardsFailureMechanismMetaEntity_FailureMechanismEntity + ON MacroStabilityInwardsFailureMechanismMetaEntity (FailureMechanismEntityId ASC) ; -CREATE INDEX 'IXFK_MacroStabilityInwardsSoilLayerOneDEntity_MacroStabilityInwardsSoilProfileOneDEntity' - ON 'MacroStabilityInwardsSoilLayerOneDEntity' ('MacroStabilityInwardsSoilProfileOneDEntityId' ASC) +CREATE INDEX IXFK_MacroStabilityInwardsSoilLayerOneDEntity_MacroStabilityInwardsSoilProfileOneDEntity + ON MacroStabilityInwardsSoilLayerOneDEntity (MacroStabilityInwardsSoilProfileOneDEntityId ASC) ; CREATE TRIGGER [TR_AfterDeleteMacroStabilityInwardsSoilProfileTwoDEntity_MacroStabilityInwardsSoilLayerTwoDEntity] @@ -2516,8 +2516,8 @@ END; ; -CREATE INDEX 'IXFK_MacroStabilityInwardsStochasticSoilProfileEntity_StochasticSoilModelEntity' - ON 'MacroStabilityInwardsStochasticSoilProfileEntity' ('StochasticSoilModelEntityId' ASC) +CREATE INDEX IXFK_MacroStabilityInwardsStochasticSoilProfileEntity_StochasticSoilModelEntity + ON MacroStabilityInwardsStochasticSoilProfileEntity (StochasticSoilModelEntityId ASC) ; CREATE TRIGGER [TR_BeforeInsertMacroStabilityInwardsStochasticSoilProfileEntity_MustHaveOneDOrTwoD] BEFORE INSERT @@ -2555,76 +2555,76 @@ END; ; -CREATE INDEX 'IXFK_MicrostabilityFailureMechanismMetaEntity_FailureMechanismEntity' - ON 'MicrostabilityFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) +CREATE INDEX IXFK_MicrostabilityFailureMechanismMetaEntity_FailureMechanismEntity + ON MicrostabilityFailureMechanismMetaEntity (FailureMechanismEntityId ASC) ; -CREATE INDEX 'IXFK_NonAdoptableFailureMechanismSectionResultEntity_FailureMechanismSectionEntity' - ON 'NonAdoptableFailureMechanismSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) +CREATE INDEX IXFK_NonAdoptableFailureMechanismSectionResultEntity_FailureMechanismSectionEntity + ON NonAdoptableFailureMechanismSectionResultEntity (FailureMechanismSectionEntityId ASC) ; -CREATE INDEX 'IXFK_NonAdoptableWithProfileProbabilityFailureMechanismSectionResultEntity_FailureMechanismSectionEntity' - ON 'NonAdoptableWithProfileProbabilityFailureMechanismSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) +CREATE INDEX IXFK_NonAdoptableWithProfileProbabilityFailureMechanismSectionResultEntity_FailureMechanismSectionEntity + ON NonAdoptableWithProfileProbabilityFailureMechanismSectionResultEntity (FailureMechanismSectionEntityId ASC) ; -CREATE INDEX 'IXFK_PipingFailureMechanismMetaEntity_FailureMechanismEntity' - ON 'PipingFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) +CREATE INDEX IXFK_PipingFailureMechanismMetaEntity_FailureMechanismEntity + ON PipingFailureMechanismMetaEntity (FailureMechanismEntityId ASC) ; -CREATE INDEX 'IXFK_PipingStructureFailureMechanismMetaEntity_FailureMechanismEntity' - ON 'PipingStructureFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) +CREATE INDEX IXFK_PipingStructureFailureMechanismMetaEntity_FailureMechanismEntity + ON PipingStructureFailureMechanismMetaEntity (FailureMechanismEntityId ASC) ; -CREATE INDEX 'IXFK_ProbabilisticPipingCalculationEntity_CalculationGroupEntity' - ON 'ProbabilisticPipingCalculationEntity' ('CalculationGroupEntityId' ASC) +CREATE INDEX IXFK_ProbabilisticPipingCalculationEntity_CalculationGroupEntity + ON ProbabilisticPipingCalculationEntity (CalculationGroupEntityId ASC) ; -CREATE INDEX 'IXFK_ProbabilisticPipingCalculationEntity_HydraulicLocationEntity' - ON 'ProbabilisticPipingCalculationEntity' ('HydraulicLocationEntityId' ASC) +CREATE INDEX IXFK_ProbabilisticPipingCalculationEntity_HydraulicLocationEntity + ON ProbabilisticPipingCalculationEntity (HydraulicLocationEntityId ASC) ; -CREATE INDEX 'IXFK_ProbabilisticPipingCalculationEntity_PipingStochasticSoilProfileEntity' - ON 'ProbabilisticPipingCalculationEntity' ('PipingStochasticSoilProfileEntityId' ASC) +CREATE INDEX IXFK_ProbabilisticPipingCalculationEntity_PipingStochasticSoilProfileEntity + ON ProbabilisticPipingCalculationEntity (PipingStochasticSoilProfileEntityId ASC) ; -CREATE INDEX 'IXFK_ProbabilisticPipingCalculationEntity_SurfaceLineEntity' - ON 'ProbabilisticPipingCalculationEntity' ('SurfaceLineEntityId' ASC) +CREATE INDEX IXFK_ProbabilisticPipingCalculationEntity_SurfaceLineEntity + ON ProbabilisticPipingCalculationEntity (SurfaceLineEntityId ASC) ; -CREATE INDEX 'IXFK_ProbabilisticPipingCalculationOutputEntity_ProbabilisticPipingCalculationEntity' - ON 'ProbabilisticPipingCalculationOutputEntity' ('ProbabilisticPipingCalculationEntityId' ASC) +CREATE INDEX IXFK_ProbabilisticPipingCalculationOutputEntity_ProbabilisticPipingCalculationEntity + ON ProbabilisticPipingCalculationOutputEntity (ProbabilisticPipingCalculationEntityId ASC) ; -CREATE INDEX 'IXFK_ProbabilisticPipingCalculationOutputEntity_Profile_GeneralResultFaultTreeIllustrationPointEntity' - ON 'ProbabilisticPipingCalculationOutputEntity' ('ProfileSpecificGeneralResultFaultTreeIllustrationPointEntityId' ASC) +CREATE INDEX IXFK_ProbabilisticPipingCalculationOutputEntity_Profile_GeneralResultFaultTreeIllustrationPointEntity + ON ProbabilisticPipingCalculationOutputEntity (ProfileSpecificGeneralResultFaultTreeIllustrationPointEntityId ASC) ; -CREATE INDEX 'IXFK_ProbabilisticPipingCalculationOutputEntity_Profile_GeneralResultSubMechanismIllustrationPointEntity' - ON 'ProbabilisticPipingCalculationOutputEntity' ('ProfileSpecificGeneralResultSubMechanismIllustrationPointEntityId' ASC) +CREATE INDEX IXFK_ProbabilisticPipingCalculationOutputEntity_Profile_GeneralResultSubMechanismIllustrationPointEntity + ON ProbabilisticPipingCalculationOutputEntity (ProfileSpecificGeneralResultSubMechanismIllustrationPointEntityId ASC) ; -CREATE INDEX 'IXFK_ProbabilisticPipingCalculationOutputEntity_Section_GeneralResultFaultTreeIllustrationPointEntity' - ON 'ProbabilisticPipingCalculationOutputEntity' ('ProfileSpecificGeneralResultFaultTreeIllustrationPointEntityId' ASC) +CREATE INDEX IXFK_ProbabilisticPipingCalculationOutputEntity_Section_GeneralResultFaultTreeIllustrationPointEntity + ON ProbabilisticPipingCalculationOutputEntity (ProfileSpecificGeneralResultFaultTreeIllustrationPointEntityId ASC) ; -CREATE INDEX 'IXFK_ProbabilisticPipingCalculationOutputEntity_Section_GeneralResultSubMechanismIllustrationPointEntity' - ON 'ProbabilisticPipingCalculationOutputEntity' ('SectionSpecificGeneralResultSubMechanismIllustrationPointEntityId' ASC) +CREATE INDEX IXFK_ProbabilisticPipingCalculationOutputEntity_Section_GeneralResultSubMechanismIllustrationPointEntity + ON ProbabilisticPipingCalculationOutputEntity (SectionSpecificGeneralResultSubMechanismIllustrationPointEntityId ASC) ; -CREATE INDEX 'IXFK_SemiProbabilisticPipingCalculationOutputEntity_SemiProbabilisticPipingCalculationEntity' - ON 'SemiProbabilisticPipingCalculationOutputEntity' ('SemiProbabilisticPipingCalculationEntityId' ASC) +CREATE INDEX IXFK_SemiProbabilisticPipingCalculationOutputEntity_SemiProbabilisticPipingCalculationEntity + ON SemiProbabilisticPipingCalculationOutputEntity (SemiProbabilisticPipingCalculationEntityId ASC) ; -CREATE INDEX 'IXFK_SpecificFailureMechanismEntity_AssessmentSectionEntity' - ON 'SpecificFailureMechanismEntity' ('AssessmentSectionEntityId' ASC) +CREATE INDEX IXFK_SpecificFailureMechanismEntity_AssessmentSectionEntity + ON SpecificFailureMechanismEntity (AssessmentSectionEntityId ASC) ; -CREATE INDEX 'IXFK_SpecificFailureMechanismFailureMechanismSectionEntity_FailureMechanismSectionEntity' - ON 'SpecificFailureMechanismFailureMechanismSectionEntity' ('FailureMechanismSectionEntityId' ASC) +CREATE INDEX IXFK_SpecificFailureMechanismFailureMechanismSectionEntity_FailureMechanismSectionEntity + ON SpecificFailureMechanismFailureMechanismSectionEntity (FailureMechanismSectionEntityId ASC) ; -CREATE INDEX 'IXFK_SpecificFailureMechanismFailureMechanismSectionEntity_SpecificFailureMechanismEntity' - ON 'SpecificFailureMechanismFailureMechanismSectionEntity' ('SpecificFailureMechanismEntityId' ASC) +CREATE INDEX IXFK_SpecificFailureMechanismFailureMechanismSectionEntity_SpecificFailureMechanismEntity + ON SpecificFailureMechanismFailureMechanismSectionEntity (SpecificFailureMechanismEntityId ASC) ; CREATE TRIGGER [TR_AfterDeleteSpecificFailureMechanismFailureMechanismSectionEntity_RemoveFailureMechanismSectionEntityId] AFTER DELETE @@ -2638,32 +2638,32 @@ END; ; -CREATE INDEX 'IXFK_StabilityPointStructureEntity_FailureMechanismEntity' - ON 'StabilityPointStructureEntity' ('FailureMechanismEntityId' ASC) +CREATE INDEX IXFK_StabilityPointStructureEntity_FailureMechanismEntity + ON StabilityPointStructureEntity (FailureMechanismEntityId ASC) ; -CREATE INDEX 'IXFK_StabilityPointStructuresCalculationEntity_CalculationGroupEntity' - ON 'StabilityPointStructuresCalculationEntity' ('CalculationGroupEntityId' ASC) +CREATE INDEX IXFK_StabilityPointStructuresCalculationEntity_CalculationGroupEntity + ON StabilityPointStructuresCalculationEntity (CalculationGroupEntityId ASC) ; -CREATE INDEX 'IXFK_StabilityPointStructuresCalculationEntity_ForeshoreProfileEntity' - ON 'StabilityPointStructuresCalculationEntity' ('ForeshoreProfileEntityId' ASC) +CREATE INDEX IXFK_StabilityPointStructuresCalculationEntity_ForeshoreProfileEntity + ON StabilityPointStructuresCalculationEntity (ForeshoreProfileEntityId ASC) ; -CREATE INDEX 'IXFK_StabilityPointStructuresCalculationEntity_HydraulicLocationEntity' - ON 'StabilityPointStructuresCalculationEntity' ('HydraulicLocationEntityId' ASC) +CREATE INDEX IXFK_StabilityPointStructuresCalculationEntity_HydraulicLocationEntity + ON StabilityPointStructuresCalculationEntity (HydraulicLocationEntityId ASC) ; -CREATE INDEX 'IXFK_StabilityPointStructuresCalculationEntity_StabilityPointStructureEntity' - ON 'StabilityPointStructuresCalculationEntity' ('StabilityPointStructureEntityId' ASC) +CREATE INDEX IXFK_StabilityPointStructuresCalculationEntity_StabilityPointStructureEntity + ON StabilityPointStructuresCalculationEntity (StabilityPointStructureEntityId ASC) ; -CREATE INDEX 'IXFK_StrengthStabilityPointConstructionFailureMechanismMetaEntity_FailureMechanismEntity' - ON 'StabilityPointStructuresFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) +CREATE INDEX IXFK_StrengthStabilityPointConstructionFailureMechanismMetaEntity_FailureMechanismEntity + ON StabilityPointStructuresFailureMechanismMetaEntity (FailureMechanismEntityId ASC) ; -CREATE INDEX 'IXFK_StabilityPointStructuresOutputEntity_StabilityPointStructuresCalculationEntity' - ON 'StabilityPointStructuresOutputEntity' ('StabilityPointStructuresCalculationEntityId' ASC) +CREATE INDEX IXFK_StabilityPointStructuresOutputEntity_StabilityPointStructuresCalculationEntity + ON StabilityPointStructuresOutputEntity (StabilityPointStructuresCalculationEntityId ASC) ; CREATE TRIGGER [TR_AfterDeleteStabilityPointStructuresOutputEntity_RemoveGeneralResultFaultTreeIllustrationPointEntity] AFTER DELETE @@ -2677,40 +2677,40 @@ END; ; -CREATE INDEX 'IXFK_StabilityStoneCoverFailureMechanismMetaEntity_FailureMechanismEntity' - ON 'StabilityStoneCoverFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) +CREATE INDEX IXFK_StabilityStoneCoverFailureMechanismMetaEntity_FailureMechanismEntity + ON StabilityStoneCoverFailureMechanismMetaEntity (FailureMechanismEntityId ASC) ; -CREATE INDEX 'IXFK_StabilityStoneCoverWaveConditionsCalculationEntity_CalculationGroupEntity' - ON 'StabilityStoneCoverWaveConditionsCalculationEntity' ('CalculationGroupEntityId' ASC) +CREATE INDEX IXFK_StabilityStoneCoverWaveConditionsCalculationEntity_CalculationGroupEntity + ON StabilityStoneCoverWaveConditionsCalculationEntity (CalculationGroupEntityId ASC) ; -CREATE INDEX 'IXFK_StabilityStoneCoverWaveConditionsCalculationEntity_ForeshoreProfileEntity' - ON 'StabilityStoneCoverWaveConditionsCalculationEntity' ('ForeshoreProfileEntityId' ASC) +CREATE INDEX IXFK_StabilityStoneCoverWaveConditionsCalculationEntity_ForeshoreProfileEntity + ON StabilityStoneCoverWaveConditionsCalculationEntity (ForeshoreProfileEntityId ASC) ; -CREATE INDEX 'IXFK_StabilityStoneCoverWaveConditionsCalculationEntity_HydraulicLocationCalculationForTargetProbabilityCollectionEntity' - ON 'StabilityStoneCoverWaveConditionsCalculationEntity' ('HydraulicLocationCalculationForTargetProbabilityCollectionEntityId' ASC) +CREATE INDEX IXFK_StabilityStoneCoverWaveConditionsCalculationEntity_HydraulicLocationCalculationForTargetProbabilityCollectionEntity + ON StabilityStoneCoverWaveConditionsCalculationEntity (HydraulicLocationCalculationForTargetProbabilityCollectionEntityId ASC) ; -CREATE INDEX 'IXFK_StabilityStoneCoverWaveConditionsCalculationEntity_HydraulicLocationEntity' - ON 'StabilityStoneCoverWaveConditionsCalculationEntity' ('HydraulicLocationEntityId' ASC) +CREATE INDEX IXFK_StabilityStoneCoverWaveConditionsCalculationEntity_HydraulicLocationEntity + ON StabilityStoneCoverWaveConditionsCalculationEntity (HydraulicLocationEntityId ASC) ; -CREATE INDEX 'IXFK_StabilityStoneCoverWaveConditionsOutputEntity_StabilityStoneCoverWaveConditionsCalculationEntity' - ON 'StabilityStoneCoverWaveConditionsOutputEntity' ('StabilityStoneCoverWaveConditionsCalculationEntityId' ASC) +CREATE INDEX IXFK_StabilityStoneCoverWaveConditionsOutputEntity_StabilityStoneCoverWaveConditionsCalculationEntity + ON StabilityStoneCoverWaveConditionsOutputEntity (StabilityStoneCoverWaveConditionsCalculationEntityId ASC) ; -CREATE INDEX 'IXFK_SubMechanismIllustrationPointStochast_SubMechanismIllustrationPointEntity' - ON 'SubMechanismIllustrationPointStochastEntity' ('SubMechanismIllustrationPointEntityId' ASC) +CREATE INDEX IXFK_SubMechanismIllustrationPointStochast_SubMechanismIllustrationPointEntity + ON SubMechanismIllustrationPointStochastEntity (SubMechanismIllustrationPointEntityId ASC) ; -CREATE INDEX 'IXFK_TopLevelFaultTreeIllustrationPointEntity_FaultTreeIllustrationPointEntity' - ON 'TopLevelFaultTreeIllustrationPointEntity' ('FaultTreeIllustrationPointEntityId' ASC) +CREATE INDEX IXFK_TopLevelFaultTreeIllustrationPointEntity_FaultTreeIllustrationPointEntity + ON TopLevelFaultTreeIllustrationPointEntity (FaultTreeIllustrationPointEntityId ASC) ; -CREATE INDEX 'IXFK_TopLevelFaultTreeIllustrationPointEntity_GeneralResultFaultTreeIllustrationPointEntity' - ON 'TopLevelFaultTreeIllustrationPointEntity' ('GeneralResultFaultTreeIllustrationPointEntityId' ASC) +CREATE INDEX IXFK_TopLevelFaultTreeIllustrationPointEntity_GeneralResultFaultTreeIllustrationPointEntity + ON TopLevelFaultTreeIllustrationPointEntity (GeneralResultFaultTreeIllustrationPointEntityId ASC) ; CREATE TRIGGER [TR_AfterDeleteTopLevelFaultTreeIllustrationPointEntity_RemoveFaultTreeIllustrationPointEntity] AFTER DELETE @@ -2724,12 +2724,12 @@ END; ; -CREATE INDEX 'IXFK_TopLevelSubMechanismIllustrationPointEntity_GeneralResultSubMechanismIllustrationPointEntity' - ON 'TopLevelSubMechanismIllustrationPointEntity' ('GeneralResultSubMechanismIllustrationPointEntityId' ASC) +CREATE INDEX IXFK_TopLevelSubMechanismIllustrationPointEntity_GeneralResultSubMechanismIllustrationPointEntity + ON TopLevelSubMechanismIllustrationPointEntity (GeneralResultSubMechanismIllustrationPointEntityId ASC) ; -CREATE INDEX 'IXFK_TopLevelSubMechanismIllustrationPointEntity_SubMechanismIllustrationPointEntity' - ON 'TopLevelSubMechanismIllustrationPointEntity' ('SubMechanismIllustrationPointEntityId' ASC) +CREATE INDEX IXFK_TopLevelSubMechanismIllustrationPointEntity_SubMechanismIllustrationPointEntity + ON TopLevelSubMechanismIllustrationPointEntity (SubMechanismIllustrationPointEntityId ASC) ; CREATE TRIGGER [TR_AfterDeleteTopLevelSubMechanismIllustrationPointEntity_RemoveSubMechanismIllustrationPointEntity] AFTER DELETE @@ -2743,22 +2743,22 @@ END; ; -CREATE INDEX 'IXFK_WaveImpactAsphaltCoverWaveConditionsCalculationEntity_CalculationGroupEntity' - ON 'WaveImpactAsphaltCoverWaveConditionsCalculationEntity' ('CalculationGroupEntityId' ASC) +CREATE INDEX IXFK_WaveImpactAsphaltCoverWaveConditionsCalculationEntity_CalculationGroupEntity + ON WaveImpactAsphaltCoverWaveConditionsCalculationEntity (CalculationGroupEntityId ASC) ; -CREATE INDEX 'IXFK_WaveImpactAsphaltCoverWaveConditionsCalculationEntity_ForeshoreProfileEntity' - ON 'WaveImpactAsphaltCoverWaveConditionsCalculationEntity' ('ForeshoreProfileEntityId' ASC) +CREATE INDEX IXFK_WaveImpactAsphaltCoverWaveConditionsCalculationEntity_ForeshoreProfileEntity + ON WaveImpactAsphaltCoverWaveConditionsCalculationEntity (ForeshoreProfileEntityId ASC) ; -CREATE INDEX 'IXFK_WaveImpactAsphaltCoverWaveConditionsCalculationEntity_HydraulicLocationCalculationForTargetProbabilityCollectionEntity' - ON 'WaveImpactAsphaltCoverWaveConditionsCalculationEntity' ('HydraulicLocationCalculationForTargetProbabilityCollectionEntityId' ASC) +CREATE INDEX IXFK_WaveImpactAsphaltCoverWaveConditionsCalculationEntity_HydraulicLocationCalculationForTargetProbabilityCollectionEntity + ON WaveImpactAsphaltCoverWaveConditionsCalculationEntity (HydraulicLocationCalculationForTargetProbabilityCollectionEntityId ASC) ; -CREATE INDEX 'IXFK_WaveImpactAsphaltCoverWaveConditionsCalculationEntity_HydraulicLocationEntity' - ON 'WaveImpactAsphaltCoverWaveConditionsCalculationEntity' ('HydraulicLocationEntityId' ASC) +CREATE INDEX IXFK_WaveImpactAsphaltCoverWaveConditionsCalculationEntity_HydraulicLocationEntity + ON WaveImpactAsphaltCoverWaveConditionsCalculationEntity (HydraulicLocationEntityId ASC) ; -CREATE INDEX 'IXFK_WaveImpactAsphaltCoverWaveConditionsOutputEntity_WaveImpactAsphaltCoverWaveConditionsCalculationEntity' - ON 'WaveImpactAsphaltCoverWaveConditionsOutputEntity' ('WaveImpactAsphaltCoverWaveConditionsCalculationEntityId' ASC) +CREATE INDEX IXFK_WaveImpactAsphaltCoverWaveConditionsOutputEntity_WaveImpactAsphaltCoverWaveConditionsCalculationEntity + ON WaveImpactAsphaltCoverWaveConditionsOutputEntity (WaveImpactAsphaltCoverWaveConditionsCalculationEntityId ASC) ;