DatabaseStructure.sql

Clone Tools
  • last updated a few seconds ago
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Added entities for storing macrostability calculations and output Related to Issue [WTI-1379]

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

Former-commit-id: a1a79229c9eb111d274c713bc64872f668ca417a

Former-commit-id: 91ddd35549632b924df218099ba154f42c485a23

  1. … 12 more files in changeset.
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.
Changed order of MacroStabilityInwardsCharacteristicPointType Added XMLdoc for methods where exceptions can be thrown Introduced MacroStabilityInwardsSoilLayer2DTestFactory Split tests Added typeof asserts for test factories tests to ensure no derived class is returned Related to Issue [WTI-1378]

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

Former-commit-id: 4d58850fe95d97a907f357520f8e9338bc147cf8

Former-commit-id: 5fba5fe8edbc57fed83a0daecc88bb8ca7167783

  1. … 17 more files in changeset.
Grouped BelowPhreaticLevel properties in PipingSoilLayerEntity Updated XMLdoc Updated legacy code to newer standards Reverted any changes on Empty valid Release 17.1.rtd

Related to Issue [WTI-1378]

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

Former-commit-id: 0e39134125c1ede94ce32c4db48ca9c8323eff45

Former-commit-id: cd332c0cbb0f37aee26c89e3704b166a312ef342

  1. … 10 more files in changeset.
Renamed PipingCalculationEntity.StochasticSoilProfileEntityId to PipingCalculationEntity.PipingStochasticSoilProfileEntityId Changed enum note of MacroStabilityInwardsSoilLayer*DEntity.ShearStrengthModel Set XML properties to NOT NULL Removed SectionLength form storage Updated format of database triggers Added NULL check for PipingSoilLayerCreateExtensions Refactored static call to TestHelper.SolutionRoot to a method that is called while running the test Related to Issue [WTI-1378]

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

Former-commit-id: ffc212f543edb5fe3e4647c5f87ebed29cbce0dc

Former-commit-id: 31f4b4630ce9bdade4eedf7b1adf7488748df9d9

  1. … 19 more files in changeset.
Renamed NormativeNorm to NormativeNormType Related to Issue [WTI-1364]

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

Former-commit-id: 648ab2a9ae6b3c9a7e3ffb8dc5e02de9ece81c11

Former-commit-id: cd4dc0cbb7ea8f26e048512d8e3978eb7d991fb7

  1. … 12 more files in changeset.
Removed MacroStabilityInwardsFailureMechanismMetaEntity parameter B from database Related to Issue [WTI-1378]

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

Former-commit-id: 4af883cff3b3d99a9f9b2d38a3577097c2d21cd3

Former-commit-id: 3b048029a680f81bd24f08072fcb8d7b6cf43ebf

  1. … 6 more files in changeset.
Added trigger for MacroStabilityInwardsStochasticSoilProfileEntity such that it can be guaranteed that either Added Order property for MacroStabilityInwardsPreconsolidationStressEntity Related to Issue [WTI-1378]

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

Former-commit-id: 75a9b442c22f2c41b19341c2cc8a31b8f352d538

Former-commit-id: ea4ac59ed20f71ea2dc23118883f19e5d03b91e0

  1. … 10 more files in changeset.
Changed database table names to no longer contain a numeric value, so that Entity Framework is able to prularize it. Related to Issue [WTI-1378]

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

Former-commit-id: c10c99fdfeabe77617f31bb071f08cd0ce301bcd

Former-commit-id: ad10811df4ea76bb497712d24add740a15b2546e

  1. … 54 more files in changeset.
- Updated property names - Created MacroStabilityInwardsSoilLayer1DCreateExtensions - Updated PipingSoilLayerCreateExtensions Related to Issue [WTI-1378]

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

Former-commit-id: c1666baf3b502ff456deb41f39aa9795b6e716ef

Former-commit-id: 0a95832cf4992a61bb736ea6361decc2d03c45e5

  1. … 13 more files in changeset.
Updated property names Related to Issue [WTI-1378]

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

Former-commit-id: 209f639e6c361939c40aea3e9caf835c752eaaf5

Former-commit-id: 857e1cedd4e7638fe4286a99b9ee26712cf9b2ef

  1. … 7 more files in changeset.
Added MacroStabilityInwards tables Related to Issue [WTI-1378]

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

Former-commit-id: 1aba6bdff419b5a53477041d4b2d0ea296cfb890

Former-commit-id: f178c56ee4e1d0d8329645c0953cfb9e09f2b2c6

  1. … 16 more files in changeset.
- Cleaned up storage classes - Updated XMLdocs - Removed unused references - prefixed Piping specific tables with "Piping" - - Renamed classes accordingly Related to Issue [WTI-1378]

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

Former-commit-id: 3d9e5d4d5719b5cc1c65322e9979fe82d9455d5c

Former-commit-id: 849fa061b4cbc4f128046b60ce800aa9bc8f4521

  1. … 68 more files in changeset.
Updated database design to make traject id NOT NULL Introduced temp table with signaling and lower limit norm to use later on Related to Issue [WTI-1364]

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

Former-commit-id: f1b560ae8eba928e9f0cd3033549632342469e4b

Former-commit-id: 5da0fefac7ed2d2da293bb66d97b15e9e61425a4

  1. … 3 more files in changeset.
Updated database design to store both Signaling and LowerLimit Norm Related to Issue [WTI-1364]

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

Former-commit-id: 16d9a5df0c1888856fb9c27197cc114d2e753eec

Former-commit-id: 1d602d2a75cf42648bfc09e77e8844874db64ff1

  1. … 11 more files in changeset.
Initialized MechanismSurfaceLineBase.Name from constructor and added check for Null Related to Issue [WTI-1343]

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

Former-commit-id: 2e9213487250cbc814b3b91307890cf7b5979f23

Former-commit-id: 1af404f013ac6e0a765c468b3c13ec22aa80a186

  1. … 99 more files in changeset.
Set SoilProfileEntity.Name to be not null Related to Issue [WTI-1343]

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

Former-commit-id: e97e925d1e5f2d25d11f65496dbb566aca98356a

Former-commit-id: c9392fd939ffe39f33d1a7c8f8eba64ae146bdac

  1. … 3 more files in changeset.
Moved 'Type' from StochasticSoilProfileEntity to 'SourceType' SoilProfileEntity in database Ran Cleanup for storage Related to Issue [WTI-1343]

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

Former-commit-id: 5390416ecba199da438854b0481ab20184862a17

Former-commit-id: 2102fe55684e8b3215a87aa15960a2dd62b27852

  1. … 17 more files in changeset.
Updated database design to store the general results for all the grass cover erosion inwards calculation outputs - Fixed failing tests: -- Restored accidentally removed columns in the DatabaseStructure.sql Related to Issue [WTI-1319]

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

Former-commit-id: f58d35ca21b41410200daa3045db0b4f7cd4f15b

Former-commit-id: c3002057971a05c28cee11ece4265e6b9496dcce

Updated database design to store the general results for all the grass cover erosion inwards calculation outputs - Updated Migration script: -- Row value for calculating the illustration points is per default FALSE -- Row value for the general result entity of the grass output is per default NULL Related to Issue [WTI-1319]

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

Former-commit-id: a6e32f96b906b4b64510c63345178cd50eafc2be

Former-commit-id: 4479e2a1d1daeae1b11d7c1a71f5930cf1a3eaab

    • -1208
    • +1099
    ./DatabaseStructure.sql
  1. … 19 more files in changeset.
Incorporated comments review 2000 - Removed superfluous GeneralResult assertions - Added missing assertions - Renamed variables and fixed typos

Paired with ~janssen

Related to Issue [WTI-1309]

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

Former-commit-id: 66ce181cb0df03c034bbe0d0b71960ce91f8f964

Former-commit-id: 99935a220f1560d9d3aa04f6aad2269d90f96065

  1. … 11 more files in changeset.
- Updated 'True/false' indicators in DatabaseDesign.eap - Formatted DatabaseStructure.sql to use tabs instead of spaces - Formatted Migration_17.1_17.2.sql to use tabs instead of spaces Related to Issue [WTI-1309]

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

Former-commit-id: e40073342b4fe78e16730f3208b96c508097e18d

Former-commit-id: 4dc1221ed9f91fdd176934e8ebf3915698ae8ac7

    • -1082
    • +1238
    ./DatabaseStructure.sql
  1. … 3 more files in changeset.
- Updated database structure to allow illustration points checkbox to be saved for closing, height, and stability point structures - cleaned up SQL scripts for triggers Related to Issue [WTI-1309]

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

Former-commit-id: 8ad836dabcae087b9fe2f6795744585b25cfe61a

Former-commit-id: 3ff9f166b319dedf175816064d437a1ca6048694

  1. … 8 more files in changeset.
Updated database structure to allow illustration points to be saved for closing, height, and stability point structures Related to Issue [WTI-1309]

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

Former-commit-id: be8c916f68ddeb29afdb2bb13805fcafea3d3e66

Former-commit-id: 160e78924ef4560ed5b7f4b86ce0eb9b6e0c3319

  1. … 16 more files in changeset.
Updated database items: - Renamed ShouldWaterLevelIllustrationPointsBeCalculated to ShouldDesignWaterLevelIllustrationPointsBeCalculated for consistency - Migration script updated Related to Issue [WTI-1305]

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

Former-commit-id: dfd8709b8f04316ff5f4d057765601383e8fc9e1

Former-commit-id: ecbc3f3561b1fcafc99e54520552bbec7f1c70d6

  1. … 15 more files in changeset.
Updated database items: - Removed obsolete column Beta from the TopLevelSubMechanismIllustrationPoint: beta is stored in the children - Updated all string based properties: the database entity property should have an AreEqualButNotSame assert and implementation

Related to Issue [WTI-1305]

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

Former-commit-id: 8006b700370e30dd3a5e2569de77172fe7c27366

Former-commit-id: 1e9b3abb2f1dd84dc47b0e5452b5514459bd582a

  1. … 9 more files in changeset.
Renamed Submechanism<X> to SubMechanism<X> for the illustration points: - Initial commit - Performed on the RT side only - Updated database and migration scripts with the updated names

Related to Issue [WTI-1305]

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

Former-commit-id: b4e245c45841961f67a8e6a215a8ddc0108b06d0

Former-commit-id: 9551680e9783a3e8a70dd77616fb14872b7ebcde

  1. … 90 more files in changeset.
Updated database design: - Incorporated new proposed design for the HBL: -- Removed obsolete functions, interfaces and partial classes - Adjusted migration script --> HBL output entities contain 10 instead of 9 columns, 10 column is filled with a NULL value as it is a FK referring to a general result. This result is not available in prior versions - Made final adjustments in the .eap file

Related to Issue [WTI-1305]

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

Former-commit-id: a3794269143bbcedac08b328c29405ee9381d62f

Former-commit-id: 71d06472bab4af5854e1bba0119db7a626652c83

  1. … 52 more files in changeset.
Updated database design: - GrassCoverErosionOutwardsHydraulicLocationGeneralResultEntityId NOT NULL - HydraulicLocationWindDirectionClosingSituationIllustrationPointEntityId.Name --> IllustrationPointName - GrassCoverErosionOutwardsHydraulicLocationWindDirectionClosingSituationIllustrationPointEntity.Name --> IllustrationPointName Related to Issue [WTI-1305]

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

Former-commit-id: 3da96a93828cb50dae0e84cf2fa10f8ebd52b5fb

Former-commit-id: e8ce056c878fd3818e395ffda68c998aafe254b6

  1. … 11 more files in changeset.
Updated DatabaseDesign: - Added Order property for tables that represent items in a list

Related to Issue [WTI-1305]

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

Former-commit-id: 2efddb53739e7e899f2e123701991e12f09ffae9

Former-commit-id: 467bb1ef02a72497007b67c646f1bec786f0672d

  1. … 13 more files in changeset.