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

Summary

Details

Page properties
Content
... ... @@ -225,99 +225,9 @@
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 -{{mermaid}}
229 -erDiagram
230 - CLAIM_CLUSTER {
231 - string ClusterID PK
232 - string EmbeddingVectorRef
233 - string Theme
234 - }
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"/}}
235 235  
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 -
321 321  **Important points:**
322 322  
323 323  * Scenarios and Evidence are **linked via their versions**
... ... @@ -338,149 +338,9 @@
338 338  * Roles and role assignments
339 339  * Review actions on versioned entities
340 340  
341 -{{mermaid}}
342 -erDiagram
343 - %% Core clusters shown for context
344 - CLAIM_CLUSTER {
345 - string ClusterID PK
346 - string EmbeddingVectorRef
347 - string Theme
348 - }
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"/}}
349 349  
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 -
484 484  Notes:
485 485  
486 486  * Most roles (READER, CONTRIBUTOR, TRUSTED_CONTRIBUTOR, REVIEWER, MODERATOR,