Skip to Content
Last modified by Robert Schaub on 2025/12/24 20:31
Show last authors
1 = Data Use ERD (Roles, Review & Versioned Entities) =
2
3 This diagram shows how users, roles, and review actions relate to the
4 versioned core entities.
5
6 {{mermaid}}
7 erDiagram
8 %% Core clusters shown for context
9 CLAIM_CLUSTER {
10 string ClusterID PK
11 string EmbeddingVectorRef
12 string Theme
13 }
14
15 CLAIM {
16 string ClaimID PK
17 string ClusterID FK
18 string Status
19 datetime CreatedAt
20 }
21
22 CLAIM_VERSION {
23 string ClaimVersionID PK
24 string ClaimID FK
25 string Text
26 string ClaimType
27 string Domain
28 datetime CreatedAt
29 }
30
31 SCENARIO {
32 string ScenarioID PK
33 string ClaimID FK
34 string Name
35 datetime CreatedAt
36 }
37
38 SCENARIO_VERSION {
39 string ScenarioVersionID PK
40 string ScenarioID FK
41 string Definitions
42 string Assumptions
43 string Boundaries
44 datetime CreatedAt
45 }
46
47 EVIDENCE {
48 string EvidenceID PK
49 string SourceType
50 string URL
51 float ReliabilityScore
52 }
53
54 EVIDENCE_VERSION {
55 string EvidenceVersionID PK
56 string EvidenceID FK
57 string Summary
58 float ReliabilityScore
59 datetime CreatedAt
60 }
61
62 VERDICT {
63 string VerdictID PK
64 string ScenarioID FK
65 }
66
67 VERDICT_VERSION {
68 string VerdictVersionID PK
69 string VerdictID FK
70 float Verdict
71 float Confidence
72 string Reasoning
73 datetime CreatedAt
74 }
75
76 %% Users and roles
77 USER {
78 string UserID PK
79 string Handle
80 string Email
81 }
82
83 TECHNICAL_USER {
84 string UserID PK
85 string SystemName
86 }
87
88 CONTRIBUTING_USER {
89 string UserID PK
90 string DisplayName
91 }
92
93 TRUSTED_CONTRIBUTOR {
94 string UserID PK
95 string TrustLevel
96 }
97
98 REVIEWER {
99 string UserID PK
100 string Domain
101 }
102
103 EXPERT {
104 string UserID PK
105 string ExpertiseArea
106 }
107
108 FEDERATION_NODE {
109 string NodeID PK
110 string Region
111 }
112
113 FEDERATION_ADMIN {
114 string UserID PK
115 string Permissions
116 }
117
118 REVIEW_ACTION {
119 string ReviewActionID PK
120 string UserID FK
121 string TargetEntityType
122 string TargetEntityVersionID
123 string ActionType
124 string Comment
125 datetime Timestamp
126 }
127
128 %% Inheritance / specialization (modelled as relationships)
129 USER ||--o{ TECHNICAL_USER : "is a"
130 USER ||--o{ CONTRIBUTING_USER : "is a"
131
132 CONTRIBUTING_USER ||--o{ TRUSTED_CONTRIBUTOR : "subset"
133 CONTRIBUTING_USER ||--o{ REVIEWER : "subset"
134 CONTRIBUTING_USER ||--o{ EXPERT : "subset"
135
136 TECHNICAL_USER ||--o{ FEDERATION_NODE : "operates"
137 TECHNICAL_USER ||--o{ FEDERATION_ADMIN : "administers"
138
139 %% Review actions on versioned entities
140 USER ||--o{ REVIEW_ACTION : performs
141
142 REVIEW_ACTION }o--|| CLAIM_VERSION : reviews
143 REVIEW_ACTION }o--|| SCENARIO_VERSION : reviews
144 REVIEW_ACTION }o--|| EVIDENCE_VERSION : reviews
145 REVIEW_ACTION }o--|| VERDICT_VERSION : reviews
146 {{/mermaid}}
147
148 {{info}}
149 This diagram focuses on *who* uses and reviews *which* versioned entities.
150 USER is the base type; TECHNICAL_USER and CONTRIBUTING_USER are specializations.
151 Other roles (REVIEWER, EXPERT, TRUSTED_CONTRIBUTOR, FEDERATION_ADMIN, FEDERATION_NODE)
152 are modelled as specializations or technical subtypes.
153 {{/info}}