Skip to Content
Last modified by Robert Schaub on 2025/12/24 20:35
From version 8.1
edited by Robert Schaub
on 2025/11/27 12:55
Change comment: There is no comment for this version
To version 7.1
edited by Robert Schaub
on 2025/11/27 12:41
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -76,7 +76,7 @@
76 76  
77 77  ----
78 78  
79 -= 5.3 Data Use & Review ERD =
79 += 5.3 Data Use & Review ERD (expanded, versioned) =
80 80  
81 81  The **Data Use** model captures who does what with which versioned data:
82 82  
... ... @@ -87,7 +87,161 @@
87 87  {{comment}} Data Use ERD (Mermaid, from /Specification/Diagrams/Data Use ERD) {{/comment}}
88 88  {{include document="FactHarbor.Playground.Data Use ERD Page (from Specification chat).WebHome" reference="FactHarbor.Playground.data.Data Use ERD Page (from Specification chat).WebHome"/}}
89 89  
90 += Data Use ERD (Roles, Review & Versioned Entities) =
90 90  
92 +This diagram shows how users, roles, and review actions relate to the
93 +versioned core entities.
94 +
95 +{{mermaid}}
96 +erDiagram
97 + %% Core clusters shown for context
98 + CLAIM_CLUSTER {
99 + string ClusterID PK
100 + string EmbeddingVectorRef
101 + string Theme
102 + }
103 +
104 + CLAIM {
105 + string ClaimID PK
106 + string ClusterID FK
107 + string Status
108 + datetime CreatedAt
109 + }
110 +
111 + CLAIM_VERSION {
112 + string ClaimVersionID PK
113 + string ClaimID FK
114 + string Text
115 + string ClaimType
116 + string Domain
117 + datetime CreatedAt
118 + }
119 +
120 + SCENARIO {
121 + string ScenarioID PK
122 + string ClaimID FK
123 + string Name
124 + datetime CreatedAt
125 + }
126 +
127 + SCENARIO_VERSION {
128 + string ScenarioVersionID PK
129 + string ScenarioID FK
130 + string Definitions
131 + string Assumptions
132 + string Boundaries
133 + datetime CreatedAt
134 + }
135 +
136 + EVIDENCE {
137 + string EvidenceID PK
138 + string SourceType
139 + string URL
140 + float ReliabilityScore
141 + }
142 +
143 + EVIDENCE_VERSION {
144 + string EvidenceVersionID PK
145 + string EvidenceID FK
146 + string Summary
147 + float ReliabilityScore
148 + datetime CreatedAt
149 + }
150 +
151 + VERDICT {
152 + string VerdictID PK
153 + string ScenarioID FK
154 + }
155 +
156 + VERDICT_VERSION {
157 + string VerdictVersionID PK
158 + string VerdictID FK
159 + float Verdict
160 + float Confidence
161 + string Reasoning
162 + datetime CreatedAt
163 + }
164 +
165 + %% Users and roles
166 + USER {
167 + string UserID PK
168 + string Handle
169 + string Email
170 + }
171 +
172 + TECHNICAL_USER {
173 + string UserID PK
174 + string SystemName
175 + }
176 +
177 + CONTRIBUTING_USER {
178 + string UserID PK
179 + string DisplayName
180 + }
181 +
182 + TRUSTED_CONTRIBUTOR {
183 + string UserID PK
184 + string TrustLevel
185 + }
186 +
187 + REVIEWER {
188 + string UserID PK
189 + string Domain
190 + }
191 +
192 + EXPERT {
193 + string UserID PK
194 + string ExpertiseArea
195 + }
196 +
197 + FEDERATION_NODE {
198 + string NodeID PK
199 + string Region
200 + }
201 +
202 + FEDERATION_ADMIN {
203 + string UserID PK
204 + string Permissions
205 + }
206 +
207 + REVIEW_ACTION {
208 + string ReviewActionID PK
209 + string UserID FK
210 + string TargetEntityType
211 + string TargetEntityVersionID
212 + string ActionType
213 + string Comment
214 + datetime Timestamp
215 + }
216 +
217 + %% Inheritance / specialization (modelled as relationships)
218 + USER ||--o{ TECHNICAL_USER : "is a"
219 + USER ||--o{ CONTRIBUTING_USER : "is a"
220 +
221 + CONTRIBUTING_USER ||--o{ TRUSTED_CONTRIBUTOR : "subset"
222 + CONTRIBUTING_USER ||--o{ REVIEWER : "subset"
223 + CONTRIBUTING_USER ||--o{ EXPERT : "subset"
224 +
225 + TECHNICAL_USER ||--o{ FEDERATION_NODE : "operates"
226 + TECHNICAL_USER ||--o{ FEDERATION_ADMIN : "administers"
227 +
228 + %% Review actions on versioned entities
229 + USER ||--o{ REVIEW_ACTION : performs
230 +
231 + REVIEW_ACTION }o--|| CLAIM_VERSION : reviews
232 + REVIEW_ACTION }o--|| SCENARIO_VERSION : reviews
233 + REVIEW_ACTION }o--|| EVIDENCE_VERSION : reviews
234 + REVIEW_ACTION }o--|| VERDICT_VERSION : reviews
235 +{{/mermaid}}
236 +
237 +{{info}}
238 +This diagram focuses on *who* uses and reviews *which* versioned entities.
239 +USER is the base type; TECHNICAL_USER and CONTRIBUTING_USER are specializations.
240 +Other roles (REVIEWER, EXPERT, TRUSTED_CONTRIBUTOR, FEDERATION_ADMIN, FEDERATION_NODE)
241 +are modelled as specializations or technical subtypes.
242 +{{/info}}
243 +
244 +
91 91  Notes:
92 92  
93 93  * Most roles (READER, CONTRIBUTOR, TRUSTED_CONTRIBUTOR, REVIEWER, MODERATOR,