Skip to Content
Last modified by Robert Schaub on 2025/12/24 20:35
From version 8.2
edited by Robert Schaub
on 2025/11/27 23:15
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
... ... @@ -1,5 +1,5 @@
1 1  (((
2 -
2 +
3 3  )))
4 4  
5 5  = 5. Data Model =
... ... @@ -64,108 +64,6 @@
64 64  {{comment}} Core Data Model ERD (Mermaid, from /Specification/Diagrams/Data Model) {{/comment}}
65 65  {{include document="FactHarbor.Playground.Core Data Model ERD Page (from Specification chat).WebHome" reference="FactHarbor.Playground.data.Core Data Model ERD Page (from Specification chat).WebHome"/}}
66 66  
67 -= Core Data Model ERD (Versioned) =
68 -
69 -This diagram shows the full core data model with all versioned entities.
70 -
71 -{{mermaid}}
72 -erDiagram
73 - CLAIM_CLUSTER {
74 - string ClusterID PK
75 - string EmbeddingVectorRef
76 - string Theme
77 - }
78 -
79 - CLAIM {
80 - string ClaimID PK
81 - string ClusterID FK
82 - string Status
83 - datetime CreatedAt
84 - }
85 -
86 - CLAIM_VERSION {
87 - string ClaimVersionID PK
88 - string ClaimID FK
89 - string Text
90 - string ClaimType
91 - string Domain
92 - datetime CreatedAt
93 - }
94 -
95 - SCENARIO {
96 - string ScenarioID PK
97 - string ClaimID FK
98 - string Name
99 - datetime CreatedAt
100 - }
101 -
102 - SCENARIO_VERSION {
103 - string ScenarioVersionID PK
104 - string ScenarioID FK
105 - string Definitions
106 - string Assumptions
107 - string Boundaries
108 - datetime CreatedAt
109 - }
110 -
111 - EVIDENCE {
112 - string EvidenceID PK
113 - string SourceType
114 - string URL
115 - float ReliabilityScore
116 - }
117 -
118 - EVIDENCE_VERSION {
119 - string EvidenceVersionID PK
120 - string EvidenceID FK
121 - string Summary
122 - float ReliabilityScore
123 - datetime CreatedAt
124 - }
125 -
126 - SCENARIO_EVIDENCE_LINK {
127 - string LinkID PK
128 - string ScenarioVersionID FK
129 - string EvidenceVersionID FK
130 - float Relevance
131 - string Direction
132 - }
133 -
134 - VERDICT {
135 - string VerdictID PK
136 - string ScenarioID FK
137 - }
138 -
139 - VERDICT_VERSION {
140 - string VerdictVersionID PK
141 - string VerdictID FK
142 - float Verdict
143 - float Confidence
144 - string Reasoning
145 - datetime CreatedAt
146 - }
147 -
148 - CLAIM_CLUSTER ||--o{ CLAIM : contains
149 - CLAIM ||--o{ CLAIM_VERSION : versions
150 -
151 - CLAIM ||--o{ SCENARIO : has
152 - SCENARIO ||--o{ SCENARIO_VERSION : versions
153 -
154 - EVIDENCE ||--o{ EVIDENCE_VERSION : versions
155 -
156 - SCENARIO_VERSION ||--o{ SCENARIO_EVIDENCE_LINK : links
157 - EVIDENCE_VERSION ||--o{ SCENARIO_EVIDENCE_LINK : linked
158 -
159 - SCENARIO ||--o{ VERDICT : assessed
160 - VERDICT ||--o{ VERDICT_VERSION : versions
161 -{{/mermaid}}
162 -
163 -{{info}}
164 -All key entities are explicitly versioned here (…VERSION tables).
165 -This reflects the versioning requirements in the textual Data Model chapter.
166 -{{/info}}
167 -
168 -
169 169  **Important points:**
170 170  
171 171  * Scenarios and Evidence are **linked via their versions**
... ... @@ -178,7 +178,7 @@
178 178  
179 179  ----
180 180  
181 -= 5.3 Data Use & Review ERD =
79 += 5.3 Data Use & Review ERD (expanded, versioned) =
182 182  
183 183  The **Data Use** model captures who does what with which versioned data:
184 184  
... ... @@ -344,7 +344,6 @@
344 344  {{/info}}
345 345  
346 346  
347 -
348 348  Notes:
349 349  
350 350  * Most roles (READER, CONTRIBUTOR, TRUSTED_CONTRIBUTOR, REVIEWER, MODERATOR,
... ... @@ -412,26 +412,8 @@
412 412  replication logs, and trust rules) are described in the Federation &
413 413  Decentralization chapter and build on top of the core data model defined here.
414 414  
312 +----
415 415  
416 -
417 -USER
418 -├── TECHNICAL_USER
419 -│  ├── FEDERATION_ADMIN
420 -│  └── AKEL_AGENT (optional future)
421 -
422 -READER
423 -└── CONTRIBUTING_USER
424 - ├── TRUSTED_CONTRIBUTOR
425 - ├── REVIEWER
426 - ├── EXPERT
427 - ├── MODERATOR
428 -
429 -
430 -ADMIN
431 -
432 -FEDERATION_ADMIN (administrative, but human)
433 -
434 -
435 435  == 1. Overall analysis & review of the data model ==
436 436  
437 437  === 1.1 Strengths of the current design ===