DatabaseDesign.eap

Clone Tools
  • last updated a few seconds ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Revert "Updated database design:" WTI-1579

This reverts commit 074d71977a6b500b6737be2cd1f0f2ff8b20f68c.

Updated database design: - Set new table from Proposed to Implemented

WTI-1579

Updated database design: - Introduced 8FKs to refer to the calculations - Introduced hydraulic location calculation entity

WTI-1579

Note: one test will fail, because the 17.3 full test project is not updated yet according to the new database structure of 17.2 with the zoning columns

Merged revision(s) 12917-12925 from branches/Release/17_2

Related to Issue [WTI-1469]

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/trunk@12929 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: b950cab1950cda19858d053390169aa21089ee07

Former-commit-id: 9841a9ecb876e2c8ea68c8991856cb16e4eed247

  1. … 86 more files in changeset.
Added 3 properties related to zoning to the database design: - Updated empty 17.2 file

Note: some tests will fail, because 17.2 database structure was not updated yet. This is done in a subsequent merge action from the release branch.

Related to Issue [WTI-1469]

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/trunk@12926 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: e782c72e944e62b1668e0a4d649a0bd39389960b

Former-commit-id: 80f90ca2deb565ebf66f9a3df0bd346176b08db7

  1. … 6 more files in changeset.
Merged revision(s) 12858-12859, 12861, 12864, 12867, 12870-12873, 12877, 12881, 12883, 12885, 12888-12893 from branches/Release/17_2_Development

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/branches/Release/17_2@12917 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: b171c3f8193be7784084a70966d2080f7c5a0cb5

Former-commit-id: e8596e3fab5614b7b8197409f84380503cbbd5e0

  1. … 88 more files in changeset.
Updated database design to add zone boundaries type for macro stability inwards. Related to Issue [WTI-1469]

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/branches/Release/17_2_Development@12872 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: 28db99aedc22a3b402509af308a0738ebd3bac37

Former-commit-id: b47822ddb55ac1c62440598e65996376f716cae7

  1. … 5 more files in changeset.
Updated database design to add zone boundaries for macro stability inwards. Related to Issue [WTI-1469]

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/branches/Release/17_2_Development@12867 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: 1468b7ff1bbb34dcf79ead04d86d5b4a410cf93a

Former-commit-id: 2413ff4f3a4dcfc26cea23ab1666e1049a88ab00

  1. … 5 more files in changeset.
Merged revision(s) from branches/1444

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/trunk@12811 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: cf752322c5967ec6824f11c711b243f30bf67f0e

Former-commit-id: 9753484fe13d42b8eb5a3c526c4d37f40ca70446

  1. … 245 more files in changeset.
Merged revision(s) 12660 from trunk: Update data model to allow for null values for soil layer colors. A NULL Color translates to Color.Empty, before both Color.Empty and a color with values (0;0;0;0) were both stored as 0 (Empty should be displayed as white, (0;0;0;0) as fully transparent black)

........

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/branches/1444@12700 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: e456a20057277be562177b52dada7b0655fe65a1

Former-commit-id: 96174e36bb23fe8ef47ea1824d9667c9cba0bdb8

  1. … 7 more files in changeset.
Update data model to allow for null values for soil layer colors. A NULL Color translates to Color.Empty, before both Color.Empty and a color with values (0;0;0;0) were both stored as 0 (Empty should be displayed as white, (0;0;0;0) as fully transparent black) Related to Issue [WTI-1298]

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/trunk@12660 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: b513037bae8a5683ad007ab66164741d2efd5fab

Former-commit-id: 4b61dd2b15f07a22245de42732e1e8fe591a9add

  1. … 21 more files in changeset.
Implemented storage for the preprocessor properties. Related to Issue [WTI-1477]

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/branches/1444@12645 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: 02bcddf17cf72268d6a727d113baf47d22a0c738

Former-commit-id: 56a7c8ae2b3200cb4c6f65dea447375fa17158fb

  1. … 8 more files in changeset.
Updated database design for preprocessor. Related to Issue [WTI-1477]

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/branches/1444@12630 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: a9f3102a48f096d752bf26240b343806a8a53c65

Former-commit-id: e1bb793559785375c920dfc9632624a879b4378c

  1. … 8 more files in changeset.
Made MacroStabilityInwardsSoilLayerTwoDEntity.Color not NULL Related to Issue [WTI-1451]

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/trunk@12475 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: 31830864433b88af11dc4588a7bd11ce3e9f84a1

Former-commit-id: 25e3ef0e31b67336511b139aaf17f61718444b02

  1. … 5 more files in changeset.
- Created an intermediate table for the relation between MacroStabilityInwardsSoilLayerTwoDEntity and MacroStabilityInwardsSoilProfileTwoDEntity. - Extended MacroStabilityInwardsSoilLayerTwoDEntity with a self reference. This is intended for the nested layers Related to Issue [WTI-1451]

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/trunk@12390 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: 5240691c06b921bb614015c40fbcbac27ed0cf65

Former-commit-id: b27a4656de02fd2fc81d9757c4ae9788acf147d5

  1. … 9 more files in changeset.
- Removed TrafficLoadInside and TrafficLoadOutside from our data model. - - Only the CharacteristicPointsCsvReader in Ringtoets.Common.IO.SurfaceLines has knowledge of the existence of these traffic load properties Related to Issue [WTI-1443]

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/trunk@12258 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: 81160300b03498fde6c5dd16d23a54992961ea78

Former-commit-id: 18cd599b8704c1b45334953e1fbe944524939564

  1. … 33 more files in changeset.
Updated database: - Renamed column DikeSoilScenarioType to DikeSoilScenario -- DikeSoilScenario does not really represent a type and scenario already indicates there are different kinds of options, hence the property was not renamed in the input class

Related to Issue [WTI-1379]

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/trunk@12207 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: 1888ef4a07dabd5f8178255499f19e63f9f06385

Former-commit-id: 60c4800f4e414da42a68e707a1b6dc8ea30375de

  1. … 9 more files in changeset.
Corrected implementation to improve coverage: - Removed unused columns in the MacroStabilityInwardsCalculationEntity => these are being split in the LocationInputExtreme and -Daily respectively

Related to Issue [WTI-1379]

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/trunk@12157 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: 2119baaa5c741498b5af4ac3c9b40d3e1cc36939

Former-commit-id: d36bf05606a1b18bcca0a611a0c41ebd72b7e7d4

  1. … 5 more files in changeset.
Updated database file: - Changed status of Approved MacroStabilityInwards tables to Implemented - Removed obsolete notes Related to Issue [WTI-1379]

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/trunk@12150 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: 98f4b7703b1eeee71115f05e665386fe3ffda38f

Former-commit-id: 173554fd3a0ae5b39da41ad40bf2888bc34d34f2

- Removed obsolete columns for the output entity: -- GridAutomaticallyCalculated -- ForbiddenZonesAutomaticallyCalculated - Renamed TangentLinesXml to SlipPlaneTangentLinesXml to indicate it belongs to a slipplane - Cleaned up test Related to Issue [WTI-1379]

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/trunk@12110 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: 8820f65107597f06dc52f25ff51b5faa9b7de68e

Former-commit-id: 2659f888f976aff2e2757017d09468b89a5cc3a7

  1. … 6 more files in changeset.
Added TangentLineNumber column to the calculation table for macro stability inwards Related to Issue [WTI-1379]

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/trunk@12102 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: a4d96dac162a5674e50efb16128178381fa31a81

Former-commit-id: 0f951701a6cab45f52b31fa8477d4f0d81333783

  1. … 5 more files in changeset.
Added read and create extensions: - Done for the semi probabilistic output - Renamed column name for the factor of stability -- Updated database, entities and sql files - Synchronised implementations of piping with MacroStabilityInwards => when NULL arguments are passed, ArgumentNullException thrown Related to Issue [WTI-1379]

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/trunk@12097 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: 74daeaea7a3522e36dc91931346a65599610abdc

Former-commit-id: ee9127a39b16e5ca0897c8f87bc54ca442c107b0

  1. … 15 more files in changeset.
Added factor of stability for the semi probabilistic output Related to Issue [WTI-1379]

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/trunk@12093 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: 42f9b351027b5c2407bc50c1f68d7e38173b91af

Former-commit-id: b344d467570e985fc4db1efe1108918a5f8ef42c

  1. … 5 more files in changeset.
Updated database design to enable NaN values for the stochastic distribution properties of preconsolidation stresses: - Updated Create and Read extensions - Regenerated affected entities

Related to Issue [WTI-1341]

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/trunk@12091 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: 941b6380ef22f6ecbc2ad888f86259ac97d1f131

Former-commit-id: 7b36beb1a8a2b33c953ede3bcec0ba3a0511ef68

  1. … 9 more files in changeset.
- Updated database design with the waternet inputs - Corrected FK relation between surfaceline and calculation for macrostability inwards - Added missing notes - Changed status of 'Proposed' tables to 'Approved'

Related to Issue [WTI-1379]

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/trunk@12088 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: 5ab80cee0f747a03b120ac8acbc757b2214b7e16

Former-commit-id: 771f9977331770e641b0e6adc47eafc4cd989285

Removed MacroStabilityInwardsSectionResultEntity.LayerTwoA from database Refactored MacroStabilityInwardsSectionResultEntityReadExtensionsTest.cs Removed redundant cast to RoundedDouble, since the MacroStabilityInwardsFailureMechanismSectionResult.AssessmentLayerThree is a double Related to Issue [WTI-1379]

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/trunk@11944 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: 0b5b77b702e87bae619860a184111114b2996ef9

Former-commit-id: 5685148d8e3970f65ae9b63fc7001e92ac975e1c

  1. … 8 more files in changeset.
Fixed properties types Renamed properties to have suffix Type Added note to tangentLineXml Removed empty constraints to old entities

Related to Issue [WTI-1379]

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/trunk@11899 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: 2fa25a0985855c591fe085faeaaadbf5d5678c69

Former-commit-id: fbbf34e1948540db35c8a94d31b87816ac6ae1c1

Updated database design: - Prefixed properties with their parent property name Related to Issue [WTI-1379]

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/trunk@11896 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: 5f4b92c5cc2055286240d2a644e3493d96b4047d

Former-commit-id: 36f6b4175c024a2f56b0ce96606f5f647c042542

Added missing properties Related to Issue [WTI-1379]

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/trunk@11889 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: 257133b7186f4dd93f6fea21aa9a3fd1e0712631

Former-commit-id: dc24762d74fab61e308932e0470a06375be5b3e2

Renamed columns to have postfix *Type* (as is done in the data model) Related to Issue [WTI-1379]

git-svn-id: https://repos.deltares.nl/repos/WettelijkToetsInstrumentarium/trunk@11885 5a3db67b-de53-47b5-99c8-a1c30a6650e2

Former-commit-id: 99c986d3a8b9ec0dc2e1ccb70f4e40008b160a0d

Former-commit-id: a8d7d47d94dc23d15553db2f19bf1a0866b59ba1