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

Summary

Details

Page properties
Content
... ... @@ -225,9 +225,99 @@
225 225  The convention is that fields ending in {{code}}Id{{/code}} are primary keys,
226 226  and fields with {{code}}...IdFk{{/code}} are foreign keys.
227 227  
228 -{{comment}} Core Data Model ERD (Mermaid, from /Specification/Diagrams/Data Model) {{/comment}}
229 -{{include document="FactHarbor.Playground.Core Data Model ERD Page (from Specification chat).WebHome"/}}
228 +{{mermaid}}
229 +erDiagram
230 + CLAIM_CLUSTER {
231 + string ClusterID PK
232 + string EmbeddingVectorRef
233 + string Theme
234 + }
230 230  
236 + CLAIM {
237 + string ClaimID PK
238 + string ClusterID FK
239 + string Status
240 + datetime CreatedAt
241 + }
242 +
243 + CLAIM_VERSION {
244 + string ClaimVersionID PK
245 + string ClaimID FK
246 + string Text
247 + string ClaimType
248 + string Domain
249 + datetime CreatedAt
250 + }
251 +
252 + SCENARIO {
253 + string ScenarioID PK
254 + string ClaimID FK
255 + string Name
256 + datetime CreatedAt
257 + }
258 +
259 + SCENARIO_VERSION {
260 + string ScenarioVersionID PK
261 + string ScenarioID FK
262 + string Definitions
263 + string Assumptions
264 + string Boundaries
265 + datetime CreatedAt
266 + }
267 +
268 + EVIDENCE {
269 + string EvidenceID PK
270 + string SourceType
271 + string URL
272 + float ReliabilityScore
273 + }
274 +
275 + EVIDENCE_VERSION {
276 + string EvidenceVersionID PK
277 + string EvidenceID FK
278 + string Summary
279 + float ReliabilityScore
280 + datetime CreatedAt
281 + }
282 +
283 + SCENARIO_EVIDENCE_LINK {
284 + string LinkID PK
285 + string ScenarioVersionID FK
286 + string EvidenceVersionID FK
287 + float Relevance
288 + string Direction
289 + }
290 +
291 + VERDICT {
292 + string VerdictID PK
293 + string ScenarioID FK
294 + }
295 +
296 + VERDICT_VERSION {
297 + string VerdictVersionID PK
298 + string VerdictID FK
299 + float Verdict
300 + float Confidence
301 + string Reasoning
302 + datetime CreatedAt
303 + }
304 +
305 + CLAIM_CLUSTER ||--o{ CLAIM : contains
306 + CLAIM ||--o{ CLAIM_VERSION : versions
307 +
308 + CLAIM ||--o{ SCENARIO : has
309 + SCENARIO ||--o{ SCENARIO_VERSION : versions
310 +
311 + EVIDENCE ||--o{ EVIDENCE_VERSION : versions
312 +
313 + SCENARIO_VERSION ||--o{ SCENARIO_EVIDENCE_LINK : links
314 + EVIDENCE_VERSION ||--o{ SCENARIO_EVIDENCE_LINK : linked
315 +
316 + SCENARIO ||--o{ VERDICT : assessed
317 + VERDICT ||--o{ VERDICT_VERSION : versions
318 +
319 +{{/mermaid}}
320 +
231 231  **Important points:**
232 232  
233 233  * Scenarios and Evidence are **linked via their versions**
... ... @@ -248,9 +248,149 @@
248 248  * Roles and role assignments
249 249  * Review actions on versioned entities
250 250  
251 -{{comment}} Data Use ERD (Mermaid, from /Specification/Diagrams/Data Use ERD) {{/comment}}
252 -{{include document="FactHarbor.Playground.Data Use ERD Page (from Specification chat).WebHome"/}}
341 +{{mermaid}}
342 +erDiagram
343 + %% Core clusters shown for context
344 + CLAIM_CLUSTER {
345 + string ClusterID PK
346 + string EmbeddingVectorRef
347 + string Theme
348 + }
253 253  
350 + CLAIM {
351 + string ClaimID PK
352 + string ClusterID FK
353 + string Status
354 + datetime CreatedAt
355 + }
356 +
357 + CLAIM_VERSION {
358 + string ClaimVersionID PK
359 + string ClaimID FK
360 + string Text
361 + string ClaimType
362 + string Domain
363 + datetime CreatedAt
364 + }
365 +
366 + SCENARIO {
367 + string ScenarioID PK
368 + string ClaimID FK
369 + string Name
370 + datetime CreatedAt
371 + }
372 +
373 + SCENARIO_VERSION {
374 + string ScenarioVersionID PK
375 + string ScenarioID FK
376 + string Definitions
377 + string Assumptions
378 + string Boundaries
379 + datetime CreatedAt
380 + }
381 +
382 + EVIDENCE {
383 + string EvidenceID PK
384 + string SourceType
385 + string URL
386 + float ReliabilityScore
387 + }
388 +
389 + EVIDENCE_VERSION {
390 + string EvidenceVersionID PK
391 + string EvidenceID FK
392 + string Summary
393 + float ReliabilityScore
394 + datetime CreatedAt
395 + }
396 +
397 + VERDICT {
398 + string VerdictID PK
399 + string ScenarioID FK
400 + }
401 +
402 + VERDICT_VERSION {
403 + string VerdictVersionID PK
404 + string VerdictID FK
405 + float Verdict
406 + float Confidence
407 + string Reasoning
408 + datetime CreatedAt
409 + }
410 +
411 + %% Users and roles
412 + USER {
413 + string UserID PK
414 + string Handle
415 + string Email
416 + }
417 +
418 + TECHNICAL_USER {
419 + string UserID PK
420 + string SystemName
421 + }
422 +
423 + CONTRIBUTING_USER {
424 + string UserID PK
425 + string DisplayName
426 + }
427 +
428 + TRUSTED_CONTRIBUTOR {
429 + string UserID PK
430 + string TrustLevel
431 + }
432 +
433 + REVIEWER {
434 + string UserID PK
435 + string Domain
436 + }
437 +
438 + EXPERT {
439 + string UserID PK
440 + string ExpertiseArea
441 + }
442 +
443 + FEDERATION_NODE {
444 + string NodeID PK
445 + string Region
446 + }
447 +
448 + FEDERATION_ADMIN {
449 + string UserID PK
450 + string Permissions
451 + }
452 +
453 + REVIEW_ACTION {
454 + string ReviewActionID PK
455 + string UserID FK
456 + string TargetEntityType
457 + string TargetEntityVersionID
458 + string ActionType
459 + string Comment
460 + datetime Timestamp
461 + }
462 +
463 + %% Inheritance / specialization (modelled as relationships)
464 + USER ||--o{ TECHNICAL_USER : "is a"
465 + USER ||--o{ CONTRIBUTING_USER : "is a"
466 +
467 + CONTRIBUTING_USER ||--o{ TRUSTED_CONTRIBUTOR : "subset"
468 + CONTRIBUTING_USER ||--o{ REVIEWER : "subset"
469 + CONTRIBUTING_USER ||--o{ EXPERT : "subset"
470 +
471 + TECHNICAL_USER ||--o{ FEDERATION_NODE : "operates"
472 + TECHNICAL_USER ||--o{ FEDERATION_ADMIN : "administers"
473 +
474 + %% Review actions on versioned entities
475 + USER ||--o{ REVIEW_ACTION : performs
476 +
477 + REVIEW_ACTION }o--|| CLAIM_VERSION : reviews
478 + REVIEW_ACTION }o--|| SCENARIO_VERSION : reviews
479 + REVIEW_ACTION }o--|| EVIDENCE_VERSION : reviews
480 + REVIEW_ACTION }o--|| VERDICT_VERSION : reviews
481 +
482 +{{/mermaid}}
483 +
254 254  Notes:
255 255  
256 256  * Most roles (READER, CONTRIBUTOR, TRUSTED_CONTRIBUTOR, REVIEWER, MODERATOR,