Riskeer / design

DatabaseDesign.eap

Clone Tools

Stats

Commits this week: 0
Total Committers: 8
Last Commit: 26 Nov
Commits this week: 0

Lines of code count not available

Commit Activity

Commits By Day In Week
52 week commits volume
Commits By Day In Week
Commits by day
Commits By Day In Week
Commits by hour
Commits By Hour In Day
Commit calendar
 

Most active committers (90 days)

loading
loading
  • last updated a few seconds ago
All Commits Reviews
Constraints
Constraints: committers
 
Constraints: files
Constraints: dates
Friday 06 Apr 2018
4:03 pm

Carlos Lubbers

Updated database design document for section results in group 4 WTI-1668

Options
    • binary
    ./DatabaseDesign.eap
2:14 pm

Dennis Tang <dennis.tang@deltares.nl>

Updated database design for failure mechanism section results in group 3 (WaveImpactAsphaltCover, DuneErosion, GrassCoverErosionOutwards, StabilityStoneCover) - FK relation with WaveImpactAsphaltCover was corrupted, readded relation

WTI-1667

Options
    • binary
    ./DatabaseDesign.eap
1:15 pm

Dennis Tang <dennis.tang@deltares.nl>

Updated database design for failure mechanism section results in group 3 (WaveImpactAsphaltCover, DuneErosion, GrassCoverErosionOutwards, StabilityStoneCover)

WTI-1667

Options
    • binary
    ./DatabaseDesign.eap
Thursday 05 Apr 2018
4:02 pm

Dennis Tang <dennis.tang@deltares.nl>

Updated database design for failure mechanism section results in group 2 (piping, macrostability inwards)

WTI-1666

Options
    • binary
    ./DatabaseDesign.eap
Wednesday 04 Apr 2018
4:27 pm

Dennis Tang <dennis.tang@deltares.nl>

Updated database design for the remaining failure mechanism section result in group 1 (GrassCoverErosionInwards, StabilityPointStructures, ClosingStructures) - Added/renamed columns that should be stored

WTI-1665

Options
    • binary
    ./DatabaseDesign.eap
4:07 pm

Dennis Tang <dennis.tang@deltares.nl>

Merge branch 'master' into 1601

# Conflicts:

# Application/Ringtoets/src/Application.Ringtoets.Migration.Core/EmbeddedResources/DatabaseStructure18.1.sql

# Application/Ringtoets/src/Application.Ringtoets.Storage/Ringtoets.rtd

# build/DatabaseStructure.sql

# design/DatabaseDesign.eap

Options
    • binary
    ./DatabaseDesign.eap
  2. … 4 more files in changeset.
1:10 pm

Dennis Tang <dennis.tang@deltares.nl>

Cleanup: - Readded trigger for the association table between collection and calculations --> calculations are not removed automatically if a grass cover erosion outwards failure mechanism meta entity entry is removed

WTI-1657

Options
    • binary
    ./DatabaseDesign.eap
  2. … 3 more files in changeset.
8:55 am

Dennis Tang <dennis.tang@deltares.nl>

Updated database design for the failure mechanism section result for height structures - Added/renamed columns that should be stored - Added boundary to indicate failure mechanism section results

WTI-1665

Options
    • binary
    ./DatabaseDesign.eap
Friday 30 Mar 2018
8:34 am

Dennis Tang <dennis.tang@deltares.nl>

Adjusted database design for the proposed solution: - Removed obsolete failure mechanism specific hydraulic boundary location tables.

WTI-1657

Options
    • binary
    ./DatabaseDesign.eap
Thursday 29 Mar 2018
4:06 pm

Dennis Tang <dennis.tang@deltares.nl>

Adjusted database design for the proposed solution - Added the FK relations between the GrassCoverErosionFailureMechanismMetaEntity and the HydraulicLocationCalculationCollectionEntity - Changed state of the association table - Renamed FK definitions between the AssessmentSectionEntity and the HydraulicLocationCalculationCollectionEntity corresponding to the naming conventions

WTI-1657

Options
    • binary
    ./DatabaseDesign.eap
Wednesday 28 Mar 2018
12:01 pm

Dennis Tang <dennis.tang@deltares.nl>

Cleanup: - Removed constraint on the combination of FKs of calculation collections (constraint was not present in the previous implementation)

WTI-1656

Options
    • binary
    ./DatabaseDesign.eap
  2. … 5 more files in changeset.
Friday 23 Mar 2018
2:04 pm

Dennis Tang <dennis.tang@deltares.nl>

Further cleanup of the database design file: - Tidied up the AssessmentSection view

WTI-1656

Options
    • binary
    ./DatabaseDesign.eap
Thursday 22 Mar 2018
11:38 am

Dennis Tang <dennis.tang@deltares.nl>

Finalized database design: - Added comments to indicate which FK represents which type of calculation - Adjusted read and create extensions on the assessment section to maintain consistency with the comments

WTI-1656

Options
    • binary
    ./DatabaseDesign.eap
  2. … 6 more files in changeset.
8:41 am

Dennis Tang <dennis.tang@deltares.nl>

Cleaned up database related files: - Removed trigger from association table between the calculation collection and the calculation - Renamed names of foreign key according to the naming conventions - Added uniqueness constraint for: -- the association table on the calculations -- the uniqueness of the FK entries of the assessment section entity - Removed two obsolete table entities from the .eap file - Updated the .sql file --> added HydraulicBoundaryLocationCalculationCollection entities should be autonumbered - Removed obsolete lines from the edmx.diagram - Added additional load logic for the PartialRingtoetsEntities in order to fully load the project

WTI-1656

Options
    • binary
    ./DatabaseDesign.eap
  2. … 8 more files in changeset.
Tuesday 20 Mar 2018
2:35 pm

Dennis Tang <dennis.tang@deltares.nl>

Adjusted database design

WTI-1656

Options
    • binary
    ./DatabaseDesign.eap
Friday 02 Feb 2018
8:30 am

Robert Tangerman <robert.tangerman@deltares.nl>

Removed derived output from storage. WTI-1591

Options
    • binary
    ./DatabaseDesign.eap
  2. … 31 more files in changeset.
Tuesday 30 Jan 2018
5:29 pm

Dennis Tang <dennis.tang@deltares.nl>

Added comments for the FKs to indicate which calculations they represent

WTI-1579

Options
    • binary
    ./DatabaseDesign.eap
  2. … 2 more files in changeset.
4:40 pm

Carlos Lubbers

Add delta L property to storage WTI-1531

Options
    • binary
    ./DatabaseDesign.eap
  2. … 41 more files in changeset.
4:40 pm

Carlos Lubbers

Add delta L property to storage WTI-1531

Options
    • binary
    ./DatabaseDesign.eap
  2. … 41 more files in changeset.
2:21 pm

Dennis Tang <dennis.tang@deltares.nl>

Merge branch '1579'

# Conflicts:

# Application/Ringtoets/src/Application.Ringtoets.Migration.Core/EmbeddedResources/DatabaseStructure18.1.sql

# Application/Ringtoets/src/Application.Ringtoets.Migration.Core/EmbeddedResources/Migration_17.3_18.1.sql

# Application/Ringtoets/src/Application.Ringtoets.Storage/DbContext/RingtoetsEntities.edmx.diagram

# Application/Ringtoets/src/Application.Ringtoets.Storage/Ringtoets.rtd

# Application/Ringtoets/test/Application.Ringtoets.Migration.Core.Test/test-data/FullTestProject181.rtd

# Application/Ringtoets/test/Application.Ringtoets.Storage.Test/IntegrationTests/MigrationTo181IntegrationTest.cs

# build/DatabaseStructure.sql

# design/DatabaseDesign.eap

Options
    • binary
    ./DatabaseDesign.eap
  2. … 107 more files in changeset.
8:51 am

Dennis Tang <dennis.tang@deltares.nl>

Updated database design: - Renamed PK of HydraulicLocationOutputEntity to match with the current naming conventions -- Updated migration script and integration test - Updated triggers of the HydraulicLocationEntity to match with the current naming convention and exhibit the correct behaviour

WTI-1579

Options
    • binary
    ./DatabaseDesign.eap
  2. … 9 more files in changeset.
Monday 29 Jan 2018
1:09 pm

Carlos Lubbers

Adapt storage with the N parameter for the Piping Structure failure mechanism WTI-1531

Options
    • binary
    ./DatabaseDesign.eap
  2. … 21 more files in changeset.
Friday 26 Jan 2018
5:00 pm

Carlos Lubbers

Adapt storage to include the macro stability outwards probability assessment input WTI-1531

Options
    • binary
    ./DatabaseDesign.eap
  2. … 35 more files in changeset.
8:02 am

Dennis Tang <dennis.tang@deltares.nl>

Regenerated context files related to the Ringtoets project files: - Regenerated with digit suffixes instead of written out digits

WTI-1579

Options
    • binary
    ./DatabaseDesign.eap
  2. … 7 more files in changeset.
Thursday 25 Jan 2018
4:54 pm

Carlos Lubbers

Adapt N parameter in stability point structures failure mechanism to be a double on the data model and storage WTI-1531

Options
    • binary
    ./DatabaseDesign.eap
  2. … 16 more files in changeset.
12:59 pm

Carlos Lubbers

Add N parameter to the grass cover erosion inwards, outwards and height structures failuremechanism database entities WTI-1531

Options
    • binary
    ./DatabaseDesign.eap
  2. … 23 more files in changeset.
Wednesday 24 Jan 2018
11:46 am

Carlos Lubbers

Add N parameter to the database for the stability stone cover failure mechanism WTI-1531

Options
    • binary
    ./DatabaseDesign.eap
  2. … 21 more files in changeset.
Tuesday 23 Jan 2018
4:07 pm

Dennis Tang <dennis.tang@deltares.nl>

Updated database design: - Added updated .sql database structure scripts to the solution - Generated new context objects

WTI-1579

Options
    • binary
    ./DatabaseDesign.eap
  2. … 10 more files in changeset.
3:48 pm

Dennis Tang <dennis.tang@deltares.nl>

Updated database design: - Introduced HydraulicCalculationEntity table and set its status to 'Implemented' - Introduced 8 FKs referring from the HydraulicLocationEntity to the prior introduced HydraulicLocationEntity for the 8 different calculations -- Implemented triggers to remove the CalculationEntity when an entry from the LocationEntity is removed

WTI-1579

Options
    • binary
    ./DatabaseDesign.eap
3:25 pm

Dennis Tang <dennis.tang@deltares.nl>

Revert "Updated database design:" WTI-1579

This reverts commit cabbd9b6eaeba226a291e3e9d5cf371f41a31cca.

Options
    • binary
    ./DatabaseDesign.eap