Skip to Content
Last modified by Robert Schaub on 2025/12/24 20:34
Hide last authors
Robert Schaub 1.1 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 EXPERT {
16 string ExpertID PK
17 }
18
19 SCENARIO_VERSION {
20 string VersionID PK
21 string ScenarioID FK
22 }
23
24 EVIDENCE_VERSION {
25 string VersionID PK
26 string EvidenceID FK
27 enum Reliability "low,medium,high"
28 string Provenance
29 enum PublicationMode
30 enum ReviewStatus
31 datetime CreatedAt
32 }
33
34 VERDICT_VERSION {
35 string VersionID PK
36 string VerdictID FK
37 string ScenarioVersionID FK
38 json EvidenceVersionSet
39 float LikelihoodRange
40 enum PublicationMode
41 enum ReviewStatus
42 datetime CreatedAt
43 }
44
45 SCENARIO_EVIDENCE_LINK {
46 string ScenarioVersionID FK
47 string EvidenceVersionID FK
48 float RelevanceScore
49 }
50
51 CONTRIBUTOR ||--o{ EVIDENCE_VERSION : "attaches"
52 TECHNICAL_USER ||--o{ EVIDENCE_VERSION : "retrieves"
53 TECHNICAL_USER ||--o{ VERDICT_VERSION : "proposes"
54 REVIEWER ||--o{ VERDICT_VERSION : "approves-TierBC"
55 EXPERT ||--o{ VERDICT_VERSION : "approves-TierA"
56 SCENARIO_VERSION ||--o{ VERDICT_VERSION : "produces"
57 SCENARIO_VERSION ||--o{ SCENARIO_EVIDENCE_LINK : "uses"
58 EVIDENCE_VERSION ||--o{ SCENARIO_EVIDENCE_LINK : "supports"
59
60 {{/mermaid}}