Skip to Content
Last modified by Robert Schaub on 2025/12/24 20:35
From version 9.6
edited by Robert Schaub
on 2025/12/11 16:53
Change comment: Updated parent field.
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
Parent
... ... @@ -1,1 +1,1 @@
1 -xwiki:FactHarbor.Archive.FactHarbor.Playground.WebHome
1 +FactHarbor.Playground.WebHome
Content
... ... @@ -1,5 +1,5 @@
1 1  (((
2 -
2 +
3 3  )))
4 4  
5 5  = 5. Data Model =
... ... @@ -62,110 +62,8 @@
62 62  and fields with {{code}}...IdFk{{/code}} are foreign keys.
63 63  
64 64  {{comment}} Core Data Model ERD (Mermaid, from /Specification/Diagrams/Data Model) {{/comment}}
65 -{{include document="FactHarbor.Playground.Core Data Model ERD Page (from Specification chat).WebHome" reference="FactHarbor.Playground.FactHarbor.Playground.data.Core Data Model ERD Page (from Specification chat).WebHome"/}}
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  
... ... @@ -187,7 +187,7 @@
187 187  * Review actions on versioned entities
188 188  
189 189  {{comment}} Data Use ERD (Mermaid, from /Specification/Diagrams/Data Use ERD) {{/comment}}
190 -{{include document="FactHarbor.Playground.Data Use ERD Page (from Specification chat).WebHome" reference="FactHarbor.Playground.FactHarbor.Playground.data.Data Use ERD Page (from Specification chat).WebHome"/}}
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"/}}
191 191  
192 192  = Data Use ERD (Roles, Review & Versioned Entities) =
193 193  
... ... @@ -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,27 +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 -
418 -USER
419 -├── TECHNICAL_USER
420 -│  ├── FEDERATION_ADMIN
421 -│  └── AKEL_AGENT (optional future)
422 -
423 -READER
424 -└── CONTRIBUTING_USER
425 - ├── TRUSTED_CONTRIBUTOR
426 - ├── REVIEWER
427 - ├── EXPERT
428 - ├── MODERATOR
429 -
430 -
431 -ADMIN
432 -
433 -FEDERATION_ADMIN (administrative, but human)
434 -
435 -
436 436  == 1. Overall analysis & review of the data model ==
437 437  
438 438  === 1.1 Strengths of the current design ===