Fisheye on Riskeer/build/DatabaseStructure.sql

Riskeer (feature/2953_param_c_in_asphalt_adjustable): Updating SQL creation script. WTI-1963

Elmar Kleijn — Tue, 11 Nov 2025 11:10:57 +0100

Elmar Kleijn committed 42e6d79 on branch master, Release25_1 and 3 more in Riskeer

Updating SQL creation script. WTI-1963

· /build/DatabaseStructure.sql

(-1, +4)

| History

| Source

| Diff

Riskeer (feature/2953_param_c_in_asphalt_adjustable): Adapted database creation script. WTI-2888

Elmar Kleijn — Tue, 23 Jul 2024 13:43:14 +0200

Elmar Kleijn committed 2f3e074 on branch master, Release24_1 and 4 more in Riskeer

Adapted database creation script. WTI-2888

· /build/DatabaseStructure.sql

(-5, +5)

| History

| Source

| Diff

Riskeer (feature/2953_param_c_in_asphalt_adjustable): WTI-2876: Incorporated comments review:...

Mon, 24 Jun 2024 08:12:36 +0200

Dennis Tang committed c5d1208 on branch master, Release24_1 and 4 more in Riskeer

WTI-2876: Incorporated comments review:

- Updated database design

-- Renamed columns and tables

· /Riskeer/Migration/src/Riskeer.Migration.Core/EmbeddedResources/DatabaseStructure23.2.sql	(-4, +4)	\| History	\| Source	\| Diff
· /build/DatabaseStructure.sql	(-4, +4)	\| History	\| Source	\| Diff
· /design/DatabaseDesign.eap	(binary)	\| History	\| Source	\| Diff

Riskeer (feature/2953_param_c_in_asphalt_adjustable): WTI-2876: Adjusted database...

Thu, 13 Jun 2024 13:35:02 +0200

Dennis Tang committed f71c2df on branch master, Release24_1 and 4 more in Riskeer

WTI-2876: Adjusted database

- Removed 'A' column from the meta-entity tables

- Adjusted and added relevant failure mechanism section configuration tables

· /Riskeer/Migration/src/Riskeer.Migration.Core/EmbeddedResources/DatabaseStructure23.2.sql	(-18, +33)	\| History	\| Source	\| Diff
· /Riskeer/Storage/src/Riskeer.Storage.Core/Riskeer.risk	(binary)	\| History	\| Source	\| Diff
· /build/DatabaseStructure.sql	(-18, +33)	\| History	\| Source	\| Diff
· /design/DatabaseDesign.eap	(binary)	\| History	\| Source	\| Diff

Riskeer (feature/2953_param_c_in_asphalt_adjustable): WTI-2870: Adjusted DB design

Wed, 08 May 2024 09:16:28 +0200

Dennis Tang committed 965bee8 on branch master, Release24_1 and 4 more in Riskeer

WTI-2870: Adjusted DB design

· /Riskeer/Migration/src/Riskeer.Migration.Core/EmbeddedResources/DatabaseStructure23.2.sql	(-76, +31)	\| History	\| Source	\| Diff
· /Riskeer/Storage/src/Riskeer.Storage.Core/Riskeer.risk	(binary)	\| History	\| Source	\| Diff
· /build/DatabaseStructure.sql	(-76, +31)	\| History	\| Source	\| Diff
· /design/DatabaseDesign.eap	(binary)	\| History	\| Source	\| Diff

Riskeer (feature/2953_param_c_in_asphalt_adjustable): WTI-2868: Implemented comments review 4978:...

Mon, 06 May 2024 14:05:25 +0200

Dennis Tang committed a9d3845 on branch master, Release24_1 and 4 more in Riskeer

WTI-2868: Implemented comments review 4978:

- Cleanup database structure

· /Riskeer/Migration/src/Riskeer.Migration.Core/EmbeddedResources/DatabaseStructure23.2.sql	(-3, +1)	\| History	\| Source	\| Diff
· /build/DatabaseStructure.sql	(-3, +1)	\| History	\| Source	\| Diff
· /design/DatabaseDesign.eap	(binary)	\| History	\| Source	\| Diff

Riskeer (feature/2953_param_c_in_asphalt_adjustable): WTI-2868 Updated DB design:...

Thu, 25 Apr 2024 10:44:38 +0200

Dennis Tang committed 6b5c3c0 on branch master, Release24_1 and 4 more in Riskeer

WTI-2868 Updated DB design:

- Removed length effect columns

- Removed obsolete tables

· /Riskeer/Migration/src/Riskeer.Migration.Core/EmbeddedResources/DatabaseStructure23.2.sql	(-133, +37)	\| History	\| Source	\| Diff
· /build/DatabaseStructure.sql	(-133, +37)	\| History	\| Source	\| Diff
· /design/DatabaseDesign.eap	(binary)	\| History	\| Source	\| Diff

Riskeer (feature/2953_param_c_in_asphalt_adjustable): WTI-2819: Updated database

Fri, 15 Mar 2024 10:08:52 +0100

Dennis Tang committed 72411eb on branch master, Release24_1 and 4 more in Riskeer

WTI-2819: Updated database

· /Riskeer/Migration/src/Riskeer.Migration.Core/EmbeddedResources/DatabaseStructure23.2.sql	(-828, +662)	\| History	\| Source	\| Diff
· /Riskeer/Storage/src/Riskeer.Storage.Core/Riskeer.risk	(binary)	\| History	\| Source	\| Diff
· /build/DatabaseStructure.sql	(-4, +4)	\| History	\| Source	\| Diff
· /design/DatabaseDesign.eap	(binary)	\| History	\| Source	\| Diff

Riskeer (feature/2953_param_c_in_asphalt_adjustable): WTI-2799: Updated database design:...

Tue, 27 Feb 2024 16:37:04 +0100

Dennis Tang committed 315365d on branch master, Release24_1 and 4 more in Riskeer

WTI-2799: Updated database design:

- Generated new database files

· /Riskeer/Storage/src/Riskeer.Storage.Core/Riskeer.risk	(binary)	\| History	\| Source	\| Diff
· /build/DatabaseStructure.sql	(-1, +2)	\| History	\| Source	\| Diff
· /design/DatabaseDesign.eap	(binary)	\| History	\| Source	\| Diff

Riskeer (task/net10-upgrade): Review related changes. WTI-2791. Paired with kok.

Thu, 25 May 2023 12:59:34 +0200

Robert Tangerman committed c3f8f8f on branch master, Release23_1 and 5 more in Riskeer

Review related changes. WTI-2791. Paired with kok.

· /Riskeer/Migration/src/Riskeer.Migration.Core/EmbeddedResources/DatabaseStructure23.1.sql	(-296, +296)	\| History	\| Source	\| Diff
· /build/DatabaseStructure.sql	(-3, +3)	\| History	\| Source	\| Diff
· /design/DatabaseDesign.eap	(binary)	\| History	\| Source	\| Diff

Riskeer (task/net10-upgrade): WTI-2791: updated storage

Fri, 12 May 2023 15:18:57 +0200

Ralf Kok committed 8e8b211 on branch master, Release23_1 and 5 more in Riskeer

WTI-2791: updated storage

· /Riskeer/Migration/src/Riskeer.Migration.Core/EmbeddedResources/DatabaseStructure23.1.sql	(-3, +3)	\| History	\| Source	\| Diff
· /build/DatabaseStructure.sql	(-3, +3)	\| History	\| Source	\| Diff
· /design/DatabaseDesign.eap	(binary)	\| History	\| Source	\| Diff

Riskeer (task/net10-upgrade): WTI-2786: Regenerated sql file based on EA16.1

Fri, 05 May 2023 15:04:50 +0200

Dennis Tang committed dea5708 on branch master, Release23_1 and 5 more in Riskeer

WTI-2786: Regenerated sql file based on EA16.1

· /Riskeer/Migration/src/Riskeer.Migration.Core/EmbeddedResources/DatabaseStructure23.1.sql	(-1744, +1744)	\| History	\| Source	\| Diff
· /build/DatabaseStructure.sql	(-1716, +1716)	\| History	\| Source	\| Diff

Riskeer (task/net10-upgrade): WTI-2786: Updated database design

Fri, 05 May 2023 13:15:36 +0200

Dennis Tang committed d6d9201 on branch master, Release23_1 and 5 more in Riskeer

WTI-2786: Updated database design

· /build/DatabaseStructure.sql	(-3, +4)	\| History	\| Source	\| Diff
· /design/DatabaseDesign.eap	(binary)	\| History	\| Source	\| Diff

Riskeer (task/net10-upgrade): Updated database for dune locations.

Tue, 11 Apr 2023 10:33:57 +0200

Robert Tangerman committed c4b7db1 on branch master, Release23_1 and 6 more in Riskeer

Updated database for dune locations.

· /Riskeer/Storage/src/Riskeer.Storage.Core/Riskeer.risk	(binary)	\| History	\| Source	\| Diff
· /build/DatabaseStructure.sql	(-5, +8)	\| History	\| Source	\| Diff
· /design/DatabaseDesign.eap	(binary)	\| History	\| Source	\| Diff

Riskeer (task/net10-upgrade): Adapted database design and entities to fix primary key error.

Fri, 10 Mar 2023 09:12:35 +0100

Robert Tangerman committed be91c0e on branch master, Multiple_HRD_Final and 8 more in Riskeer

Adapted database design and entities to fix primary key error.

· /Riskeer/Storage/src/Riskeer.Storage.Core/DbContext/RiskeerEntities.Context.cs	(-1, +1)	\| History	\| Source	\| Diff
· /Riskeer/Storage/src/Riskeer.Storage.Core/DbContext/RiskeerEntities.edmx	(-2, +2)	\| History	\| Source	\| Diff
· /Riskeer/Storage/src/Riskeer.Storage.Core/DbContext/RiskeerEntities.edmx.diagram	(-83, +83)	\| History	\| Source	\| Diff
· /Riskeer/Storage/src/Riskeer.Storage.Core/Riskeer.risk	(binary)	\| History	\| Source	\| Diff
· /build/DatabaseStructure.sql	(-2, +2)	\| History	\| Source	\| Diff
· /design/DatabaseDesign.eap	(binary)	\| History	\| Source	\| Diff

Riskeer (task/net10-upgrade): Generated SQL.

Thu, 09 Mar 2023 11:40:54 +0100

Robert Tangerman committed 139950b on branch master, Multiple_HRD_Final and 8 more in Riskeer

Generated SQL.

· /build/DatabaseStructure.sql

(-21, +37)

| History

| Source

| Diff

Riskeer (task/net10-upgrade): WTI-2735: Updated database design: - Removed obsolete failure mechanism specific section result entities - Cleaned up da...

Tue, 05 Apr 2022 09:32:15 +0200

Dennis Tang committed 9c42e1d on branch master, MapSelection and 20 more in Riskeer

WTI-2735: Updated database design: - Removed obsolete failure mechanism specific section result entities - Cleaned up database views - Updated database structure files

· /Riskeer/Migration/src/Riskeer.Migration.Core/EmbeddedResources/DatabaseStructure21.2.sql	(-353, +93)	\| History	\| Source	\| Diff
· /build/DatabaseStructure.sql	(-353, +93)	\| History	\| Source	\| Diff
· /design/DatabaseDesign.eap	(binary)	\| History	\| Source	\| Diff

Riskeer (task/net10-upgrade): WTI-2737: Renamed norm: - Updated database design

Thu, 31 Mar 2022 14:45:24 +0200

Dennis Tang committed cbe0f46 on branch master, MapSelection and 20 more in Riskeer

WTI-2737: Renamed norm: - Updated database design

· /Riskeer/Migration/src/Riskeer.Migration.Core/EmbeddedResources/DatabaseStructure21.2.sql	(-9, +9)	\| History	\| Source	\| Diff
· /build/DatabaseStructure.sql	(-9, +9)	\| History	\| Source	\| Diff
· /design/DatabaseDesign.eap	(binary)	\| History	\| Source	\| Diff

Riskeer (task/net10-upgrade): WTI-2737: Renamed failure path to failure mechanism - Updated database structure...

Wed, 30 Mar 2022 10:44:24 +0200

Dennis Tang committed a1dcf62 on branch master, MapSelection and 20 more in Riskeer

WTI-2737: Renamed failure path to failure mechanism - Updated database structure

Paired with tangerma.

· /Riskeer/Migration/src/Riskeer.Migration.Core/EmbeddedResources/DatabaseStructure21.2.sql	(-1617, +1617)	\| History	\| Source	\| Diff
· /build/DatabaseStructure.sql	(-24, +24)	\| History	\| Source	\| Diff
· /design/DatabaseDesign.eap	(binary)	\| History	\| Source	\| Diff

Riskeer (task/net10-upgrade): Updated database design. WTI-2673

Thu, 03 Mar 2022 10:59:56 +0100

Ringo van der Velden committed 94ec35a on branch master, MapSelection and 20 more in Riskeer

Updated database design. WTI-2673

· /Riskeer/Storage/src/Riskeer.Storage.Core/Riskeer.risk	(binary)	\| History	\| Source	\| Diff
· /build/DatabaseStructure.sql	(-26, +48)	\| History	\| Source	\| Diff
· /design/DatabaseDesign.eap	(binary)	\| History	\| Source	\| Diff

Riskeer (task/net10-upgrade): Updated database design. WTI-2690

Thu, 10 Feb 2022 15:00:59 +0100

Ringo van der Velden committed 5f1494b on branch master, MapSelection and 20 more in Riskeer

Updated database design. WTI-2690

· /build/DatabaseStructure.sql	(-1, +2)	\| History	\| Source	\| Diff
· /design/DatabaseDesign.eap	(binary)	\| History	\| Source	\| Diff

Riskeer (task/net10-upgrade): Updated database design. WTI-2703

Mon, 07 Feb 2022 09:07:52 +0100

Ringo van der Velden committed 4cd5871 on branch master, MapSelection and 20 more in Riskeer

Updated database design. WTI-2703

· /build/DatabaseStructure.sql	(-16, +16)	\| History	\| Source	\| Diff
· /design/DatabaseDesign.eap	(binary)	\| History	\| Source	\| Diff

Riskeer (task/net10-upgrade): Updated database design and migration script. WTI-2719

Fri, 28 Jan 2022 11:31:53 +0100

Ringo van der Velden committed 18c6c78 on branch master, MapSelection and 20 more in Riskeer

Updated database design and migration script. WTI-2719

· /Riskeer/Migration/src/Riskeer.Migration.Core/EmbeddedResources/Migration_21.1_21.2.sql	(-21, +0)	\| History	\| Source	\| Diff
· /build/DatabaseStructure.sql	(-147, +37)	\| History	\| Source	\| Diff
· /design/DatabaseDesign.eap	(binary)	\| History	\| Source	\| Diff

Riskeer (task/net10-upgrade): Adjusted database design. WTI-2662

Thu, 27 Jan 2022 10:31:41 +0100

Ringo van der Velden committed 0d7ddbb on branch master, MapSelection and 20 more in Riskeer

Adjusted database design. WTI-2662

· /build/DatabaseStructure.sql	(-6, +8)	\| History	\| Source	\| Diff
· /design/DatabaseDesign.eap	(binary)	\| History	\| Source	\| Diff

Riskeer (task/net10-upgrade): Adjusted database design. WTI-2657

Thu, 27 Jan 2022 07:18:38 +0100

Ringo van der Velden committed ff2de18 on branch master, MapSelection and 20 more in Riskeer

Adjusted database design. WTI-2657

· /build/DatabaseStructure.sql	(-6, +8)	\| History	\| Source	\| Diff
· /design/DatabaseDesign.eap	(binary)	\| History	\| Source	\| Diff

Riskeer (task/net10-upgrade): Adjusted database design. WTI-2647

Wed, 26 Jan 2022 09:46:22 +0100

Ringo van der Velden committed 0675861 on branch master, MapSelection and 20 more in Riskeer

Adjusted database design. WTI-2647

· /build/DatabaseStructure.sql	(-5, +8)	\| History	\| Source	\| Diff
· /design/DatabaseDesign.eap	(binary)	\| History	\| Source	\| Diff

Riskeer (task/net10-upgrade): Adjusted database design. WTI-2627

Tue, 25 Jan 2022 12:48:17 +0100

Ringo van der Velden committed d3dce67 on branch master, MapSelection and 20 more in Riskeer

Adjusted database design. WTI-2627

· /build/DatabaseStructure.sql	(-6, +8)	\| History	\| Source	\| Diff
· /design/DatabaseDesign.eap	(binary)	\| History	\| Source	\| Diff

Riskeer (task/net10-upgrade): Updated database design. WTI-2652

Mon, 24 Jan 2022 15:26:02 +0100

Ringo van der Velden committed 6b23553 on branch master, MapSelection and 20 more in Riskeer

Updated database design. WTI-2652

· /build/DatabaseStructure.sql

(-10, +8)

| History

| Source

| Diff

Riskeer (task/net10-upgrade): Updated database design. WTI-2642

Mon, 24 Jan 2022 08:14:38 +0100

Ringo van der Velden committed 39e91a3 on branch master, MapSelection and 21 more in Riskeer

Updated database design. WTI-2642

· /build/DatabaseStructure.sql	(-10, +8)	\| History	\| Source	\| Diff
· /design/DatabaseDesign.eap	(binary)	\| History	\| Source	\| Diff

Riskeer (task/net10-upgrade): Updated database design. WTI-2637

Fri, 21 Jan 2022 08:11:31 +0100

Ringo van der Velden committed 62365fe on branch master, MapSelection and 21 more in Riskeer

Updated database design. WTI-2637

· /build/DatabaseStructure.sql	(-9, +9)	\| History	\| Source	\| Diff
· /design/DatabaseDesign.eap	(binary)	\| History	\| Source	\| Diff