Index: build/DatabaseStructure.sql =================================================================== diff -u -r0843c692f56e6a977d9e53ae2e55e1890edb7f7b -r8f70bb3fd13657fc1fea6846c4b91bd9f37696f1 --- build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 0843c692f56e6a977d9e53ae2e55e1890edb7f7b) +++ build/DatabaseStructure.sql (.../DatabaseStructure.sql) (revision 8f70bb3fd13657fc1fea6846c4b91bd9f37696f1) @@ -1,6 +1,6 @@ /* ---------------------------------------------------- */ /* Generated by Enterprise Architect Version 14.1 */ -/* Created On : 07-dec-2021 13:56:49 */ +/* Created On : 07-dec-2021 15:20:56 */ /* DBMS : SQLite */ /* ---------------------------------------------------- */ @@ -30,15 +30,18 @@ DROP TABLE IF EXISTS 'HydraulicLocationEntity' ; -DROP TABLE IF EXISTS 'GrassCoverErosionInwardsFailureMechanismMetaEntity' +DROP TABLE IF EXISTS 'SemiProbabilisticPipingCalculationEntity' ; -DROP TABLE IF EXISTS 'SemiProbabilisticPipingCalculationEntity' +DROP TABLE IF EXISTS 'GrassCoverErosionInwardsFailureMechanismMetaEntity' ; DROP TABLE IF EXISTS 'GrassCoverErosionInwardsCalculationEntity' ; +DROP TABLE IF EXISTS 'GrassCoverSlipOffInwardsFailureMechanismMetaEntity' +; + DROP TABLE IF EXISTS 'GrassCoverErosionOutwardsFailureMechanismMetaEntity' ; @@ -63,6 +66,9 @@ DROP TABLE IF EXISTS 'PipingCharacteristicPointEntity' ; +DROP TABLE IF EXISTS 'WaterPressureAsphaltCoverFailureMechanismMetaEntity' +; + DROP TABLE IF EXISTS 'WaveImpactAsphaltCoverFailureMechanismMetaEntity' ; @@ -156,6 +162,9 @@ DROP TABLE IF EXISTS 'GrassCoverSlipOffInwardsSectionResultEntity' ; +DROP TABLE IF EXISTS 'GrassCoverSlipOffOutwardsFailureMechanismMetaEntity' +; + DROP TABLE IF EXISTS 'GrassCoverSlipOffOutwardsSectionResultEntity' ; @@ -240,6 +249,9 @@ DROP TABLE IF EXISTS 'MacroStabilityOutwardsSectionResultEntity' ; +DROP TABLE IF EXISTS 'MicrostabilityOutwardsFailureMechanismMetaEntity' +; + DROP TABLE IF EXISTS 'MicrostabilitySectionResultEntity' ; @@ -300,6 +312,9 @@ DROP TABLE IF EXISTS 'StochastEntity' ; +DROP TABLE IF EXISTS 'StrengthStabilityLengthwiseConstructionFailureMechanismMetaEntity' +; + DROP TABLE IF EXISTS 'StrengthStabilityLengthwiseConstructionSectionResultEntity' ; @@ -309,6 +324,9 @@ DROP TABLE IF EXISTS 'SubMechanismIllustrationPointStochastEntity' ; +DROP TABLE IF EXISTS 'TechnicalInnovationFailureMechanismMetaEntity' +; + DROP TABLE IF EXISTS 'TechnicalInnovationSectionResultEntity' ; @@ -430,16 +448,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 'SemiProbabilisticPipingCalculationEntity' ( 'SemiProbabilisticPipingCalculationEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -467,6 +475,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 'GrassCoverErosionInwardsCalculationEntity' ( 'GrassCoverErosionInwardsCalculationEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, @@ -499,6 +517,15 @@ ) ; +CREATE TABLE 'GrassCoverSlipOffInwardsFailureMechanismMetaEntity' +( + 'GrassCoverSlipOffInwardsFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'FailureMechanismEntityId' INTEGER NOT NULL, + 'N' REAL 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, @@ -597,6 +624,15 @@ ) ; +CREATE TABLE 'WaterPressureAsphaltCoverFailureMechanismMetaEntity' +( + 'WaterPressureAsphaltCoverFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'FailureMechanismEntityId' INTEGER NOT NULL, + 'N' REAL 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, @@ -1089,6 +1125,15 @@ ) ; +CREATE TABLE 'GrassCoverSlipOffOutwardsFailureMechanismMetaEntity' +( + 'GrassCoverSlipOffOutwardsFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'FailureMechanismEntityId' INTEGER NOT NULL, + 'N' REAL 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, @@ -1594,6 +1639,15 @@ ) ; +CREATE TABLE 'MicrostabilityOutwardsFailureMechanismMetaEntity' +( + 'MicrostabilityFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'FailureMechanismEntityId' INTEGER NOT NULL, + 'N' REAL 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, @@ -2005,6 +2059,15 @@ ) ; +CREATE TABLE 'StrengthStabilityLengthwiseConstructionFailureMechanismMetaEntity' +( + 'StrengthStabilityLengthwiseConstructionFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'FailureMechanismEntityId' INTEGER NOT NULL, + 'N' REAL 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, @@ -2040,6 +2103,15 @@ ) ; +CREATE TABLE 'TechnicalInnovationFailureMechanismMetaEntity' +( + 'TechnicalInnovationFailureMechanismMetaEntityId' INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT, + 'FailureMechanismEntityId' INTEGER NOT NULL, + 'N' REAL 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, @@ -2201,10 +2273,6 @@ ON 'HydraulicLocationEntity' ('AssessmentSectionEntityId' ASC) ; -CREATE INDEX 'IXFK_GrassCoverErosionInwardsFailureMechanismMetaEntity_FailureMechanismEntity' - ON 'GrassCoverErosionInwardsFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) -; - CREATE INDEX 'IXFK_SemiProbabilisticPipingCalculationEntity_PipingStochasticSoilProfileEntity' ON 'SemiProbabilisticPipingCalculationEntity' ('PipingStochasticSoilProfileEntityId' ASC) ; @@ -2221,6 +2289,10 @@ ON 'SemiProbabilisticPipingCalculationEntity' ('CalculationGroupEntityId' ASC) ; +CREATE INDEX 'IXFK_GrassCoverErosionInwardsFailureMechanismMetaEntity_FailureMechanismEntity' + ON 'GrassCoverErosionInwardsFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) +; + CREATE INDEX 'IXFK_GrassCoverErosionInwardsCalculationEntity_CalculationGroupEntity' ON 'GrassCoverErosionInwardsCalculationEntity' ('CalculationGroupEntityId' ASC) ; @@ -2233,6 +2305,10 @@ ON 'GrassCoverErosionInwardsCalculationEntity' ('HydraulicLocationEntityId' ASC) ; +CREATE INDEX 'IXFK_GrassCoverSlipOffInwardsFailureMechanismMetaEntity_FailureMechanismEntity' + ON 'GrassCoverSlipOffInwardsFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) +; + CREATE INDEX 'IXFK_GrassCoverErosionOutwardsFailureMechanismMetaEntity_FailureMechanismEntity' ON 'GrassCoverErosionOutwardsFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) ; @@ -2261,6 +2337,10 @@ ON 'PipingCharacteristicPointEntity' ('SurfaceLineEntityId' ASC) ; +CREATE INDEX 'IXFK_WaterPressureAsphaltCoverFailureMechanismMetaEntity_FailureMechanismEntity' + ON 'WaterPressureAsphaltCoverFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) +; + CREATE INDEX 'IXFK_WaveImpactAsphaltCoverFailureMechanismMetaEntity_FailureMechanismEntity' ON 'WaveImpactAsphaltCoverFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) ; @@ -2536,6 +2616,10 @@ ON 'GrassCoverSlipOffInwardsSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) ; +CREATE INDEX 'IXFK_GrassCoverSlipOffOutwardsFailureMechanismMetaEntity_FailureMechanismEntity' + ON 'GrassCoverSlipOffOutwardsFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) +; + CREATE INDEX 'IXFK_GrassCoverSlipOffOutwardsSectionResultEntity_FailureMechanismSectionEntity' ON 'GrassCoverSlipOffOutwardsSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) ; @@ -2747,6 +2831,10 @@ ON 'MacroStabilityOutwardsSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) ; +CREATE INDEX 'IXFK_MicrostabilityFailureMechanismMetaEntity_FailureMechanismEntity' + ON 'MicrostabilityOutwardsFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) +; + CREATE INDEX 'IXFK_MicrostabilitySectionResultEntity_FailureMechanismSectionEntity' ON 'MicrostabilitySectionResultEntity' ('FailureMechanismSectionEntityId' ASC) ; @@ -2901,6 +2989,10 @@ ON 'StabilityStoneCoverWaveConditionsOutputEntity' ('StabilityStoneCoverWaveConditionsCalculationEntityId' ASC) ; +CREATE INDEX 'IXFK_StrengthStabilityLengthwiseConstructionFailureMechanismMetaEntity_FailureMechanismEntity' + ON 'StrengthStabilityLengthwiseConstructionFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) +; + CREATE INDEX 'IXFK_StrengthStabilityLengthwiseConstructionSectionResultEntity_FailureMechanismSectionEntity' ON 'StrengthStabilityLengthwiseConstructionSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) ; @@ -2909,6 +3001,10 @@ ON 'SubMechanismIllustrationPointStochastEntity' ('SubMechanismIllustrationPointEntityId' ASC) ; +CREATE INDEX 'IXFK_TechnicalInnovationFailureMechanismMetaEntity_FailureMechanismEntity' + ON 'TechnicalInnovationFailureMechanismMetaEntity' ('FailureMechanismEntityId' ASC) +; + CREATE INDEX 'IXFK_TechnicalInnovationSectionResultEntity_FailureMechanismSectionEntity' ON 'TechnicalInnovationSectionResultEntity' ('FailureMechanismSectionEntityId' ASC) ; Index: design/DatabaseDesign.eap =================================================================== diff -u -r0843c692f56e6a977d9e53ae2e55e1890edb7f7b -r8f70bb3fd13657fc1fea6846c4b91bd9f37696f1 Binary files differ