Last modified by Robert Schaub on 2025/12/22 13:50

Show last authors
1 {{mermaid}}
2 erDiagram
3 CONTRIBUTOR {
4 string UserID PK
5 }
6 TECHNICAL_USER {
7 string SystemID PK
8 }
9 REVIEWER {
10 string ContributorID PK
11 }
12 EXPERT {
13 string Trusted ContributorID PK
14 }
15 SCENARIO_VERSION {
16 string VersionID PK
17 string ScenarioID FK
18 }
19 EVIDENCE_VERSION {
20 string VersionID PK
21 string EvidenceID FK
22 enum Reliability "low,medium,high"
23 string Provenance
24 enum PublicationMode
25 enum ReviewStatus
26 datetime CreatedAt
27 }
28 VERDICT_VERSION {
29 string VersionID PK
30 string VerdictID FK
31 string ScenarioVersionID FK
32 json EvidenceVersionSet
33 float LikelihoodRange
34 enum PublicationMode
35 enum ReviewStatus
36 datetime CreatedAt
37 }
38 SCENARIO_EVIDENCE_LINK {
39 string ScenarioVersionID FK
40 string EvidenceVersionID FK
41 float RelevanceScore
42 }
43 CONTRIBUTOR ||--o{ EVIDENCE_VERSION : "attaches"
44 TECHNICAL_USER ||--o{ EVIDENCE_VERSION : "retrieves"
45 TECHNICAL_USER ||--o{ VERDICT_VERSION : "proposes"
46 REVIEWER ||--o{ VERDICT_VERSION : "approves-TierBC"
47 EXPERT ||--o{ VERDICT_VERSION : "approves-TierA"
48 SCENARIO_VERSION ||--o{ VERDICT_VERSION : "produces"
49 SCENARIO_VERSION ||--o{ SCENARIO_EVIDENCE_LINK : "uses"
50 EVIDENCE_VERSION ||--o{ SCENARIO_EVIDENCE_LINK : "supports"
51 {{/mermaid}}