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.2
edited by Robert Schaub
on 2025/11/27 23:15
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,6 +64,108 @@
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 +
67 67  **Important points:**
68 68  
69 69  * Scenarios and Evidence are **linked via their versions**
... ... @@ -76,7 +76,7 @@
76 76  
77 77  ----
78 78  
79 -= 5.3 Data Use & Review ERD (expanded, versioned) =
181 += 5.3 Data Use & Review ERD =
80 80  
81 81  The **Data Use** model captures who does what with which versioned data:
82 82  
... ... @@ -242,6 +242,7 @@
242 242  {{/info}}
243 243  
244 244  
347 +
245 245  Notes:
246 246  
247 247  * Most roles (READER, CONTRIBUTOR, TRUSTED_CONTRIBUTOR, REVIEWER, MODERATOR,
... ... @@ -309,8 +309,26 @@
309 309  replication logs, and trust rules) are described in the Federation &
310 310  Decentralization chapter and build on top of the core data model defined here.
311 311  
312 -----
313 313  
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 +
314 314  == 1. Overall analysis & review of the data model ==
315 315  
316 316  === 1.1 Strengths of the current design ===