Skip to Content
Last modified by Robert Schaub on 2025/12/24 20:34
Show last authors
1 {{mermaid}}
2 erDiagram
3 CONTRIBUTOR {
4 string UserID PK
5 }
6
7 TECHNICAL_USER {
8 string SystemID PK
9 }
10
11 REVIEWER {
12 string ReviewerID PK
13 }
14
15 CLAIM_VERSION {
16 string VersionID PK
17 string ClaimID FK
18 string ParentVersionID FK
19 string Text
20 enum RiskTier "A,B,C"
21 enum PublicationMode "Mode1,Mode2,Mode3"
22 enum ReviewStatus
23 string CreatedBy FK
24 datetime CreatedAt
25 }
26
27 SCENARIO_VERSION {
28 string VersionID PK
29 string ScenarioID FK
30 string ParentVersionID FK
31 string ClaimID FK
32 json Definitions
33 json Assumptions
34 enum PublicationMode
35 enum ReviewStatus
36 string CreatedBy FK
37 datetime CreatedAt
38 }
39
40 CONTRIBUTOR ||--o{ CLAIM_VERSION : "submits"
41 CONTRIBUTOR ||--o{ SCENARIO_VERSION : "proposes"
42 TECHNICAL_USER ||--o{ CLAIM_VERSION : "generates"
43 TECHNICAL_USER ||--o{ SCENARIO_VERSION : "drafts"
44 REVIEWER ||--o{ CLAIM_VERSION : "reviews"
45 REVIEWER ||--o{ SCENARIO_VERSION : "validates"
46 CLAIM_VERSION ||--o{ SCENARIO_VERSION : "has-scenarios"
47
48 {{/mermaid}}