Skip to Content
Last modified by Robert Schaub on 2025/12/24 20:35
From version 7.1
edited by Robert Schaub
on 2025/11/27 12:41
Change comment: There is no comment for this version
To version 8.1
edited by Robert Schaub
on 2025/11/27 12:55
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 (expanded, versioned) =
79 += 5.3 Data Use & Review ERD =
80 80  
81 81  The **Data Use** model captures who does what with which versioned data:
82 82  
... ... @@ -87,161 +87,7 @@
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) =
91 91  
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 -
245 245  Notes:
246 246  
247 247  * Most roles (READER, CONTRIBUTOR, TRUSTED_CONTRIBUTOR, REVIEWER, MODERATOR,