Index: build/DatabaseStructure.sql =================================================================== diff -u -r6c9489333cd8dad0c635d356099064c8a1f7fd53 -r972aca6de21263e7f13f5a0bddaf9bb6e8c1e483 --- build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 6c9489333cd8dad0c635d356099064c8a1f7fd53) +++ build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 972aca6de21263e7f13f5a0bddaf9bb6e8c1e483) @@ -1,6 +1,6 @@ /* ---------------------------------------------------- */ /* Generated by Enterprise Architect Version 14.1 */ -/* Created On : 27-feb-2020 11:06:02 */ +/* Created On : 27-feb-2020 14:37:49 */ /* DBMS : SQLite */ /* ---------------------------------------------------- */ @@ -15,10 +15,10 @@ DROP TABLE IF EXISTS 'AssessmentSectionEntity' ; -DROP TABLE IF EXISTS 'FailureMechanismSectionEntity' +DROP TABLE IF EXISTS 'FailureMechanismEntity' ; -DROP TABLE IF EXISTS 'FailureMechanismEntity' +DROP TABLE IF EXISTS 'FailureMechanismSectionEntity' ; DROP TABLE IF EXISTS 'ClosingStructuresFailureMechanismMetaEntity' @@ -30,33 +30,27 @@ DROP TABLE IF EXISTS 'HydraulicLocationEntity' ; -DROP TABLE IF EXISTS 'PipingCalculationEntity' +DROP TABLE IF EXISTS 'GrassCoverErosionInwardsFailureMechanismMetaEntity' ; -DROP TABLE IF EXISTS 'GrassCoverErosionInwardsFailureMechanismMetaEntity' +DROP TABLE IF EXISTS 'PipingCalculationEntity' ; DROP TABLE IF EXISTS 'GrassCoverErosionInwardsCalculationEntity' ; -DROP TABLE IF EXISTS 'GrassCoverSlipOffInwardsFailureMechanismMetaEntity' +DROP TABLE IF EXISTS 'GrassCoverErosionOutwardsFailureMechanismMetaEntity' ; -DROP TABLE IF EXISTS 'GrassCoverErosionOutwardsFailureMechanismMetaEntity' +DROP TABLE IF EXISTS 'PipingSoilLayerEntity' ; DROP TABLE IF EXISTS 'PipingSoilProfileEntity' ; -DROP TABLE IF EXISTS 'PipingSoilLayerEntity' -; - DROP TABLE IF EXISTS 'PipingStochasticSoilProfileEntity' ; -DROP TABLE IF EXISTS 'GrassCoverErosionInwardsRoughnessProfileSectionEntity' -; - DROP TABLE IF EXISTS 'StochasticSoilModelEntity' ; @@ -66,9 +60,6 @@ DROP TABLE IF EXISTS 'PipingCharacteristicPointEntity' ; -DROP TABLE IF EXISTS 'WaterPressureAsphaltCoverFailureMechanismMetaEntity' -; - DROP TABLE IF EXISTS 'WaveImpactAsphaltCoverFailureMechanismMetaEntity' ; @@ -159,9 +150,6 @@ DROP TABLE IF EXISTS 'GrassCoverSlipOffInwardsSectionResultEntity' ; -DROP TABLE IF EXISTS 'GrassCoverSlipOffOutwardsFailureMechanismMetaEntity' -; - DROP TABLE IF EXISTS 'GrassCoverSlipOffOutwardsSectionResultEntity' ; @@ -213,9 +201,6 @@ DROP TABLE IF EXISTS 'MacroStabilityInwardsSectionResultEntity' ; -DROP TABLE IF EXISTS 'MacroStabilityInwardsSlidingCurveEntity' -; - DROP TABLE IF EXISTS 'MacroStabilityInwardsSoilLayerOneDEntity' ; @@ -240,9 +225,6 @@ DROP TABLE IF EXISTS 'MacroStabilityOutwardsSectionResultEntity' ; -DROP TABLE IF EXISTS 'MicrostabilityOutwardsFailureMechanismMetaEntity' -; - DROP TABLE IF EXISTS 'MicrostabilitySectionResultEntity' ; @@ -291,9 +273,6 @@ DROP TABLE IF EXISTS 'StochastEntity' ; -DROP TABLE IF EXISTS 'StrengthStabilityLengthwiseConstructionFailureMechanismMetaEntity' -; - DROP TABLE IF EXISTS 'StrengthStabilityLengthwiseConstructionSectionResultEntity' ; @@ -303,9 +282,6 @@ DROP TABLE IF EXISTS 'SubMechanismIllustrationPointStochastEntity' ; -DROP TABLE IF EXISTS 'TechnicalInnovationFailureMechanismMetaEntity' -; - DROP TABLE IF EXISTS 'TechnicalInnovationSectionResultEntity' ; @@ -386,16 +362,6 @@ ) ; -CREATE TABLE 'FailureMechanismSectionEntity' -( - 'FailureMechanismSectionEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismEntityId' INTEGER NOT NULL, - 'Name' VARCHAR (260) NOT NULL, - 'FailureMechanismSectionPointXml' TEXT NOT NULL, - CONSTRAINT 'FK_FailureMechanismSectionEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade -) -; - CREATE TABLE 'FailureMechanismEntity' ( 'FailureMechanismEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -413,6 +379,16 @@ ) ; +CREATE TABLE 'FailureMechanismSectionEntity' +( + 'FailureMechanismSectionEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'FailureMechanismEntityId' INTEGER NOT NULL, + 'Name' VARCHAR (260) NOT NULL, + 'FailureMechanismSectionPointXml' TEXT NOT NULL, + CONSTRAINT 'FK_FailureMechanismSectionEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade +) +; + CREATE TABLE 'ClosingStructuresFailureMechanismMetaEntity' ( 'ClosingStructuresFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -447,6 +423,16 @@ ) ; +CREATE TABLE 'GrassCoverErosionInwardsFailureMechanismMetaEntity' +( + 'GrassCoverErosionInwardsFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'FailureMechanismEntityId' INTEGER NOT NULL, + 'N' REAL NOT NULL, + 'DikeProfileCollectionSourcePath' TEXT NULL, + CONSTRAINT 'FK_GrassCoverErosionInwardsFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade +) +; + CREATE TABLE 'PipingCalculationEntity' ( 'PipingCalculationEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -474,16 +460,6 @@ ) ; -CREATE TABLE 'GrassCoverErosionInwardsFailureMechanismMetaEntity' -( - 'GrassCoverErosionInwardsFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismEntityId' INTEGER NOT NULL, - 'N' REAL NOT NULL, - 'DikeProfileCollectionSourcePath' TEXT NULL, - CONSTRAINT 'FK_GrassCoverErosionInwardsFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade -) -; - CREATE TABLE 'GrassCoverErosionInwardsCalculationEntity' ( 'GrassCoverErosionInwardsCalculationEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -512,14 +488,6 @@ ) ; -CREATE TABLE 'GrassCoverSlipOffInwardsFailureMechanismMetaEntity' -( - 'GrassCoverSlipOffInwardsFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismEntityId' INTEGER NOT NULL, - CONSTRAINT 'FK_GrassCoverSlipOffInwardsFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade -) -; - CREATE TABLE 'GrassCoverErosionOutwardsFailureMechanismMetaEntity' ( 'GrassCoverErosionOutwardsFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -548,15 +516,6 @@ ) ; -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 -) -; - CREATE TABLE 'PipingSoilLayerEntity' ( 'PipingSoilLayerEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -577,6 +536,15 @@ ) ; +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 +) +; + CREATE TABLE 'PipingStochasticSoilProfileEntity' ( 'PipingStochasticSoilProfileEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -589,19 +557,6 @@ ) ; -CREATE TABLE 'GrassCoverErosionInwardsRoughnessProfileSectionEntity' -( - 'GrassCoverErosionInwardsRoughnessProfileSectionEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'GrassCoverErosionInwardsCalculationEntityId' INTEGER NOT NULL, - 'StartPointX' NUMERIC NOT NULL, - 'StartPointY' INTEGER NOT NULL, - 'EndPointX' NUMERIC NOT NULL, - 'EndPointY' NUMERIC NOT NULL, - 'Roughness' NUMERIC NOT NULL, - CONSTRAINT 'FK_GrassCoverErosionInwardsRoughnessProfileSectionEntity_GrassCoverErosionInwardsCalculationEntity' FOREIGN KEY ('GrassCoverErosionInwardsCalculationEntityId') REFERENCES 'GrassCoverErosionInwardsCalculationEntity' ('GrassCoverErosionInwardsCalculationEntityId') ON DELETE Cascade ON UPDATE Cascade -) -; - CREATE TABLE 'StochasticSoilModelEntity' ( 'StochasticSoilModelEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -640,14 +595,6 @@ ) ; -CREATE TABLE 'WaterPressureAsphaltCoverFailureMechanismMetaEntity' -( - 'WaterPressureAsphaltCoverFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismEntityId' INTEGER NOT NULL, - CONSTRAINT 'FK_WaterPressureAsphaltCoverFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade -) -; - CREATE TABLE 'WaveImpactAsphaltCoverFailureMechanismMetaEntity' ( 'WaveImpactAsphaltCoverFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -1135,14 +1082,6 @@ ) ; -CREATE TABLE 'GrassCoverSlipOffOutwardsFailureMechanismMetaEntity' -( - 'GrassCoverSlipOffOutwardsFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismEntityId' INTEGER NOT NULL, - CONSTRAINT 'FK_GrassCoverSlipOffOutwardsFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade -) -; - CREATE TABLE 'GrassCoverSlipOffOutwardsSectionResultEntity' ( 'GrassCoverSlipOffOutwardsSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -1494,30 +1433,6 @@ ) ; -CREATE TABLE 'MacroStabilityInwardsSlidingCurveEntity' -( - 'MacroStabilityInwardsSlidingCurveEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'LeftSlidingCircleCenterX' REAL NULL, - 'LeftSlidingCircleCenterY' REAL NULL, - 'LeftSlidingCircleRadius' REAL NULL, - 'LeftSlidingCircleIsActive' TINYINT (1) NOT NULL, -- true or false - 'LeftSlidingCircleNonIteratedForce' REAL NULL, - 'LeftSlidingCircleIteratedForce' REAL NULL, - 'LeftSlidingCircleDrivingMoment' REAL NULL, - 'LeftSlidingCircleResistingMoment' REAL NULL, - 'RightSlidingCircleCenterX' REAL NULL, - 'RightSlidingCircleCenterY' REAL NULL, - 'RightSlidingCircleRadius' REAL NULL, - 'RightSlidingCircleIsActive' TINYINT (1) NOT NULL, -- true or false - 'RightSlidingCircleNonIteratedForce' REAL NULL, - 'RightSlidingCircleIteratedForce' REAL NULL, - 'RightSlidingCircleDrivingMoment' REAL NULL, - 'RightSlidingCircleResistingMoment' REAL NULL, - 'NonIteratedHorizontalForce' REAL NULL, - 'IteratedHorizontalForce' REAL NULL -) -; - CREATE TABLE 'MacroStabilityInwardsSoilLayerOneDEntity' ( 'MacroStabilityInwardsSoilLayerOneDEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -1643,14 +1558,6 @@ ) ; -CREATE TABLE 'MicrostabilityOutwardsFailureMechanismMetaEntity' -( - 'MicrostabilityFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismEntityId' INTEGER NOT NULL, - CONSTRAINT 'FK_MicrostabilityFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade -) -; - CREATE TABLE 'MicrostabilitySectionResultEntity' ( 'MicrostabilitySectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -1986,14 +1893,6 @@ ) ; -CREATE TABLE 'StrengthStabilityLengthwiseConstructionFailureMechanismMetaEntity' -( - 'StrengthStabilityLengthwiseConstructionFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismEntityId' INTEGER NOT NULL, - CONSTRAINT 'FK_StrengthStabilityLengthwiseConstructionFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade -) -; - CREATE TABLE 'StrengthStabilityLengthwiseConstructionSectionResultEntity' ( 'StrengthStabilityLengthwiseConstructionSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -2028,14 +1927,6 @@ ) ; -CREATE TABLE 'TechnicalInnovationFailureMechanismMetaEntity' -( - 'TechnicalInnovationFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, - 'FailureMechanismEntityId' INTEGER NOT NULL, - CONSTRAINT 'FK_TechnicalInnovationFailureMechanismMetaEntity_FailureMechanismEntity' FOREIGN KEY ('FailureMechanismEntityId') REFERENCES 'FailureMechanismEntity' ('FailureMechanismEntityId') ON DELETE Cascade ON UPDATE Cascade -) -; - CREATE TABLE 'TechnicalInnovationSectionResultEntity' ( 'TechnicalInnovationSectionResultEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -2205,10 +2096,6 @@ END; ; -CREATE INDEX 'IXFK_FailureMechanismSectionEntity_FailureMechanismEntity' - ON 'FailureMechanismSectionEntity' ('FailureMechanismEntityId' ASC) -; - CREATE INDEX 'IXFK_FailureMechanismEntity_AssessmentSectionEntity' ON 'FailureMechanismEntity' ('AssessmentSectionEntityId' ASC) ; @@ -2217,6 +2104,10 @@ ON 'FailureMechanismEntity' ('CalculationGroupEntityId' ASC) ; +CREATE INDEX 'IXFK_FailureMechanismSectionEntity_FailureMechanismEntity' + ON 'FailureMechanismSectionEntity' ('FailureMechanismEntityId' ASC) +; + CREATE INDEX 'IXFK_ClosingStructuresFailureMechanismMetaEntity_FailureMechanismEntity' ON 'ClosingStructuresFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) ; @@ -2229,6 +2120,10 @@ ON 'HydraulicLocationEntity' ('AssessmentSectionEntityId' ASC) ; +CREATE INDEX 'IXFK_GrassCoverErosionInwardsFailureMechanismMetaEntity_FailureMechanismEntity' + ON 'GrassCoverErosionInwardsFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) +; + CREATE INDEX 'IXFK_PipingCalculationEntity_PipingStochasticSoilProfileEntity' ON 'PipingCalculationEntity' ('PipingStochasticSoilProfileEntityId' ASC) ; @@ -2245,10 +2140,6 @@ ON 'PipingCalculationEntity' ('CalculationGroupEntityId' ASC) ; -CREATE INDEX 'IXFK_GrassCoverErosionInwardsFailureMechanismMetaEntity_FailureMechanismEntity' - ON 'GrassCoverErosionInwardsFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) -; - CREATE INDEX 'IXFK_GrassCoverErosionInwardsCalculationEntity_CalculationGroupEntity' ON 'GrassCoverErosionInwardsCalculationEntity' ('CalculationGroupEntityId' ASC) ; @@ -2261,10 +2152,6 @@ ON 'GrassCoverErosionInwardsCalculationEntity' ('HydraulicLocationEntityId' ASC) ; -CREATE INDEX 'IXFK_GrassCoverSlipOffInwardsFailureMechanismMetaEntity_FailureMechanismEntity' - ON 'GrassCoverSlipOffInwardsFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) -; - CREATE INDEX 'IXFK_GrassCoverErosionOutwardsFailureMechanismMetaEntity_FailureMechanismEntity' ON 'GrassCoverErosionOutwardsFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) ; @@ -2318,10 +2205,6 @@ ON 'PipingStochasticSoilProfileEntity' ('StochasticSoilModelEntityId' ASC) ; -CREATE INDEX 'IXFK_GrassCoverErosionInwardsRoughnessProfileSectionEntity_GrassCoverErosionInwardsCalculationEntity' - ON 'GrassCoverErosionInwardsRoughnessProfileSectionEntity' ('GrassCoverErosionInwardsCalculationEntityId' ASC) -; - CREATE INDEX 'IXFK_StochasticSoilModelEntity_FailureMechanismEntity' ON 'StochasticSoilModelEntity' ('FailureMechanismEntityId' ASC) ; @@ -2334,10 +2217,6 @@ ON 'PipingCharacteristicPointEntity' ('SurfaceLineEntityId' ASC) ; -CREATE INDEX 'IXFK_WaterPressureAsphaltCoverFailureMechanismMetaEntity_FailureMechanismEntity' - ON 'WaterPressureAsphaltCoverFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) -; - CREATE INDEX 'IXFK_WaveImpactAsphaltCoverFailureMechanismMetaEntity_FailureMechanismEntity' ON 'WaveImpactAsphaltCoverFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) ; @@ -2628,10 +2507,6 @@ ON 'GrassCoverSlipOffInwardsSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) ; -CREATE INDEX 'IXFK_GrassCoverSlipOffOutwardsFailureMechanismMetaEntity_FailureMechanismEntity' - ON 'GrassCoverSlipOffOutwardsFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) -; - CREATE INDEX 'IXFK_GrassCoverSlipOffOutwardsSectionResultEntity_FailureMechanismSectionEntity' ON 'GrassCoverSlipOffOutwardsSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) ; @@ -2809,10 +2684,6 @@ ON 'MacroStabilityOutwardsSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) ; -CREATE INDEX 'IXFK_MicrostabilityFailureMechanismMetaEntity_FailureMechanismEntity' - ON 'MicrostabilityOutwardsFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) -; - CREATE INDEX 'IXFK_MicrostabilitySectionResultEntity_FailureMechanismSectionEntity' ON 'MicrostabilitySectionResultEntity' ('FailureMechanismSectionEntityId' ASC) ; @@ -2908,10 +2779,6 @@ ON 'StabilityStoneCoverWaveConditionsOutputEntity' ('StabilityStoneCoverWaveConditionsCalculationEntityId' ASC) ; -CREATE INDEX 'IXFK_StrengthStabilityLengthwiseConstructionFailureMechanismMetaEntity_FailureMechanismEntity' - ON 'StrengthStabilityLengthwiseConstructionFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) -; - CREATE INDEX 'IXFK_StrengthStabilityLengthwiseConstructionSectionResultEntity_FailureMechanismSectionEntity' ON 'StrengthStabilityLengthwiseConstructionSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) ; @@ -2920,10 +2787,6 @@ ON 'SubMechanismIllustrationPointStochastEntity' ('SubMechanismIllustrationPointEntityId' ASC) ; -CREATE INDEX 'IXFK_TechnicalInnovationFailureMechanismMetaEntity_FailureMechanismEntity' - ON 'TechnicalInnovationFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) -; - CREATE INDEX 'IXFK_TechnicalInnovationSectionResultEntity_FailureMechanismSectionEntity' ON 'TechnicalInnovationSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) ;