Skip to Content

Changes for page Data Model

Last modified by Robert Schaub on 2025/12/24 20:34
From version 6.4
edited by Robert Schaub
on 2025/12/16 20:28
Change comment: Renamed back-links.
To version 6.2
edited by Robert Schaub
on 2025/12/16 20:25
Change comment: Update document after refactoring.

Summary

Details

Page properties
Parent
... ... @@ -1,1 +1,1 @@
1 -FactHarbor.Archive.FactHarbor V0\.9\.18.Specification.WebHome
1 +FactHarbor.Archive.FactHarbor.Specification.WebHome
Content
... ... @@ -5,7 +5,6 @@
5 5  == Versioning Strategy ==
6 6  
7 7  Every entity in FactHarbor has a full immutable version history. This ensures:
8 -
9 9  * Complete auditability
10 10  * Ability to reconstruct historical state
11 11  * Federation-compatible lineage tracking
... ... @@ -14,19 +14,16 @@
14 14  === Core Versioning Principles ===
15 15  
16 16  **Immutability**:
17 -
18 18  * Each version is stored independently
19 19  * Versions cannot be deleted, only superseded
20 20  * Historical versions remain accessible
21 21  
22 22  **Lineage**:
23 -
24 24  * Each version links to its parent via `ParentVersionID`
25 25  * Forms directed acyclic graph (DAG) of changes
26 26  * Supports branching in federated environments
27 27  
28 28  **Provenance**:
29 -
30 30  * Every version timestamped (`CreatedAt`)
31 31  * Author type recorded (`AuthorType`: Human, AI, ExternalNode)
32 32  * Justification captured (`JustificationText`)
... ... @@ -33,7 +33,6 @@
33 33  * Digital signatures for integrity (`SignatureHash` in Release 1.0)
34 34  
35 35  **Federation Support**:
36 -
37 37  * Versions can originate from remote nodes
38 38  * Conflict detection via lineage comparison
39 39  * Parallel version trees for branching scenarios
... ... @@ -61,7 +61,6 @@
61 61  === User Entities ===
62 62  
63 63  **USER** (base user table):
64 -
65 65  * ``UserID`` (PK)
66 66  * ``UserType`` (Reader|Contributor|Reviewer|Auditor|Expert|Moderator|Maintainer)
67 67  * ``DisplayName``
... ... @@ -71,7 +71,6 @@
71 71  * ``Status`` (active|suspended|banned)
72 72  
73 73  **TECHNICAL_USER** (system processes):
74 -
75 75  * ``SystemID`` (PK)
76 76  * ``SystemName``
77 77  * ``Purpose`` (AKEL|FederationSync|BackupService|Monitor|Audit)
... ... @@ -82,7 +82,6 @@
82 82  * ``Permissions`` (JSON - authorized operations)
83 83  
84 84  **Examples of Technical Users**:
85 -
86 86  * AKEL instances (AI processing)
87 87  * Federation sync bots
88 88  * Scheduled audit tasks
... ... @@ -97,7 +97,6 @@
97 97  The system relies on the following versioned core entities:
98 98  
99 99  **CLAIM_CLUSTER**:
100 -
101 101  * ``ClusterID`` (PK)
102 102  * ``EmbeddingVectorRef``
103 103  * ``Theme``
... ... @@ -106,81 +106,77 @@
106 106  * A Claim belongs to exactly one primary cluster
107 107  
108 108  **CLAIM / CLAIM_VERSION**:
109 -
110 110  * ``CLAIM`` is the long-lived anchor for a real-world claim
111 111  * ``CLAIM_VERSION`` is an immutable snapshot that includes:
112 -* ``VersionID`` (PK)
113 -* ``ClaimID`` (FK to CLAIM)
114 -* ``ParentVersionID`` (FK to prior version, nullable)
115 -* ``Text``
116 -* ``Domain``
117 -* ``ClaimType`` (literal|metaphorical|rhetorical|supernatural)
118 -* ``Evaluability`` (empirical|subjective|non-falsifiable)
119 -* ``RiskTier`` (A|B|C) - replaced SafetyCategory for consistency
120 -* ``PublicationMode`` (Mode1|Mode2|Mode3)
121 -* ``ReviewStatus`` (draft|in_review|approved|rejected)
122 -* ``CreatedAt``, ``AuthorType``, ``CreatedBy``, ``JustificationText``
123 -* ``NodeOrigin``, ``SignatureHash``
124 -* ``Status`` (active|superseded|merged)
102 + * ``VersionID`` (PK)
103 + * ``ClaimID`` (FK to CLAIM)
104 + * ``ParentVersionID`` (FK to prior version, nullable)
105 + * ``Text``
106 + * ``Domain``
107 + * ``ClaimType`` (literal|metaphorical|rhetorical|supernatural)
108 + * ``Evaluability`` (empirical|subjective|non-falsifiable)
109 + * ``RiskTier`` (A|B|C) - replaced SafetyCategory for consistency
110 + * ``PublicationMode`` (Mode1|Mode2|Mode3)
111 + * ``ReviewStatus`` (draft|in_review|approved|rejected)
112 + * ``CreatedAt``, ``AuthorType``, ``CreatedBy``, ``JustificationText``
113 + * ``NodeOrigin``, ``SignatureHash``
114 + * ``Status`` (active|superseded|merged)
125 125  
126 126  **SCENARIO / SCENARIO_VERSION**:
127 -
128 128  * ``SCENARIO`` is the anchor for a scenario across time
129 129  * ``SCENARIO_VERSION`` is an immutable snapshot:
130 -* ``VersionID`` (PK)
131 -* ``ScenarioID`` (FK to SCENARIO)
132 -* ``ParentVersionID``
133 -* ``ClaimID`` (FK to CLAIM)
134 -* ``Definitions`` (JSON)
135 -* ``Boundaries`` (JSON)
136 -* ``Assumptions`` (JSON)
137 -* ``Context`` (text)
138 -* ``EvaluationMethod`` (text)
139 -* ``PublicationMode`` (Mode1|Mode2|Mode3)
140 -* ``ReviewStatus`` (draft|in_review|approved|rejected)
141 -* ``CreatedAt``, ``AuthorType``, ``CreatedBy``, ``JustificationText``
142 -* ``NodeOrigin``, ``SignatureHash``
143 -* ``Status`` (active|superseded|deprecated)
119 + * ``VersionID`` (PK)
120 + * ``ScenarioID`` (FK to SCENARIO)
121 + * ``ParentVersionID``
122 + * ``ClaimID`` (FK to CLAIM)
123 + * ``Definitions`` (JSON)
124 + * ``Boundaries`` (JSON)
125 + * ``Assumptions`` (JSON)
126 + * ``Context`` (text)
127 + * ``EvaluationMethod`` (text)
128 + * ``PublicationMode`` (Mode1|Mode2|Mode3)
129 + * ``ReviewStatus`` (draft|in_review|approved|rejected)
130 + * ``CreatedAt``, ``AuthorType``, ``CreatedBy``, ``JustificationText``
131 + * ``NodeOrigin``, ``SignatureHash``
132 + * ``Status`` (active|superseded|deprecated)
144 144  
145 145  **Note**: SafetyClass removed from Scenario - risk tier is at claim level
146 146  
147 147  **EVIDENCE / EVIDENCE_VERSION**:
148 -
149 149  * ``EVIDENCE`` is the anchor
150 150  * ``EVIDENCE_VERSION`` is the versioned snapshot:
151 -* ``VersionID`` (PK)
152 -* ``EvidenceID`` (FK to EVIDENCE)
153 -* ``ParentVersionID``
154 -* ``Type`` (paper|dataset|report|transcript|expert|media)
155 -* ``Category`` (empirical|historical|rhetorical|dataset|meta-analysis)
156 -* ``Reliability`` (low|medium|high)
157 -* ``Provenance`` (URL, DOI, source metadata)
158 -* ``ExtractionMethod`` (manual|OCR|API|AKEL)
159 -* ``ContentHash`` (SHA256 of evidence content)
160 -* ``PublicationMode`` (Mode1|Mode2|Mode3)
161 -* ``ReviewStatus`` (draft|verified|disputed|retracted)
162 -* ``CreatedAt``, ``AuthorType``, ``CreatedBy``, ``JustificationText``
163 -* ``NodeOrigin``, ``SignatureHash``
164 -* ``Status`` (active|superseded)
139 + * ``VersionID`` (PK)
140 + * ``EvidenceID`` (FK to EVIDENCE)
141 + * ``ParentVersionID``
142 + * ``Type`` (paper|dataset|report|transcript|expert|media)
143 + * ``Category`` (empirical|historical|rhetorical|dataset|meta-analysis)
144 + * ``Reliability`` (low|medium|high)
145 + * ``Provenance`` (URL, DOI, source metadata)
146 + * ``ExtractionMethod`` (manual|OCR|API|AKEL)
147 + * ``ContentHash`` (SHA256 of evidence content)
148 + * ``PublicationMode`` (Mode1|Mode2|Mode3)
149 + * ``ReviewStatus`` (draft|verified|disputed|retracted)
150 + * ``CreatedAt``, ``AuthorType``, ``CreatedBy``, ``JustificationText``
151 + * ``NodeOrigin``, ``SignatureHash``
152 + * ``Status`` (active|superseded)
165 165  
166 166  **VERDICT / VERDICT_VERSION**:
167 -
168 168  * ``VERDICT`` is the anchor
169 169  * ``VERDICT_VERSION`` is the snapshot:
170 -* ``VersionID`` (PK)
171 -* ``VerdictID`` (FK to VERDICT)
172 -* ``ParentVersionID``
173 -* ``ClaimID`` (FK to CLAIM)
174 -* ``ScenarioVersionID`` (FK to specific SCENARIO_VERSION)
175 -* ``EvidenceVersionSet`` (JSON array of Evidence VersionIDs used)
176 -* ``LikelihoodRange`` (0–1, with uncertainty bounds)
177 -* ``ExplanationChain`` (JSON)
178 -* ``UncertaintyFactors`` (JSON)
179 -* ``PublicationMode`` (Mode1|Mode2|Mode3)
180 -* ``ReviewStatus`` (draft|in_review|approved|retracted)
181 -* ``CreatedAt``, ``AuthorType``, ``CreatedBy``, ``JustificationText``
182 -* ``NodeOrigin``, ``SignatureHash``
183 -* ``Status`` (current|outdated|superseded|retracted)
157 + * ``VersionID`` (PK)
158 + * ``VerdictID`` (FK to VERDICT)
159 + * ``ParentVersionID``
160 + * ``ClaimID`` (FK to CLAIM)
161 + * ``ScenarioVersionID`` (FK to specific SCENARIO_VERSION)
162 + * ``EvidenceVersionSet`` (JSON array of Evidence VersionIDs used)
163 + * ``LikelihoodRange`` (0–1, with uncertainty bounds)
164 + * ``ExplanationChain`` (JSON)
165 + * ``UncertaintyFactors`` (JSON)
166 + * ``PublicationMode`` (Mode1|Mode2|Mode3)
167 + * ``ReviewStatus`` (draft|in_review|approved|retracted)
168 + * ``CreatedAt``, ``AuthorType``, ``CreatedBy``, ``JustificationText``
169 + * ``NodeOrigin``, ``SignatureHash``
170 + * ``Status`` (current|outdated|superseded|retracted)
184 184  
185 185  ----
186 186  
... ... @@ -187,7 +187,6 @@
187 187  == Many-to-Many Linking Tables ==
188 188  
189 189  **ScenarioEvidenceLink**:
190 -
191 191  * Links scenario versions to evidence versions with relevance scoring
192 192  * ``ScenarioID``, ``ScenarioVersionID``
193 193  * ``EvidenceID``, ``EvidenceVersionID``
... ... @@ -195,7 +195,6 @@
195 195  * ``LinkJustification`` - Brief explanation of relevance
196 196  
197 197  **Purpose**:
198 -
199 199  * Evidence can be used by multiple scenarios
200 200  * Scenarios can draw from multiple pieces of evidence
201 201  * Relevance scoring helps prioritize evidence
... ... @@ -202,7 +202,6 @@
202 202  * Version-specific linking preserves historical accuracy
203 203  
204 204  **ClaimCluster**:
205 -
206 206  * Semantic clustering of similar claims
207 207  * ``ClusterID`` (PK)
208 208  * ``EmbeddingVector`` - Vector representation for semantic search
... ... @@ -214,12 +214,10 @@
214 214  == Key Changes in v0.9.1 ==
215 215  
216 216  **Updated Field Names**:
217 -
218 218  * `SafetyCategory` → `RiskTier` (consistency with risk tier system A/B/C)
219 219  * `SafetyClass` removed from Scenario (redundant with claim-level RiskTier)
220 220  
221 221  **Added Fields to All Version Entities**:
222 -
223 223  * `PublicationMode` - Track Mode 1/2/3 status
224 224  * `ReviewStatus` - Track workflow state
225 225  * `NodeOrigin` - Federation provenance
... ... @@ -226,11 +226,9 @@
226 226  * `CreatedBy` - FK to User/TechnicalUser (clarified)
227 227  
228 228  **New Entity**:
229 -
230 230  * `TECHNICAL_USER` - Separate system processes from human users
231 231  
232 232  **Clarifications**:
233 -
234 234  * `ScenarioVersionID` in Verdict (not just ScenarioID) - links to specific version
235 235  * `ContentHash` in Evidence - SHA256 for integrity checking
236 236  
... ... @@ -241,7 +241,6 @@
241 241  === Late-Arriving Evidence ===
242 242  
243 243  When new evidence versions appear:
244 -
245 245  1. Existing verdicts marked as **outdated**
246 246  2. Scenario relevance must be re-evaluated
247 247  3. Re-evaluation engine triggers verdict recomputation
... ... @@ -251,7 +251,6 @@
251 251  === Scenario Evolution ===
252 252  
253 253  When a scenario's assumptions or definitions change:
254 -
255 255  * Creates new scenario version (not in-place update)
256 256  * All dependent verdicts must be recalculated
257 257  * Previous scenario versions remain accessible
... ... @@ -260,7 +260,6 @@
260 260  === Federated Nodes ===
261 261  
262 262  Each node may share partial data:
263 -
264 264  * Claims and scenarios shared if relevant
265 265  * Evidence metadata shared, not always full files
266 266  * Version synchronization via NodeOrigin tracking
... ... @@ -274,7 +274,7 @@
274 274  
275 275  === Core Data Model ERD ===
276 276  
277 -{{include reference="FactHarbor.Archive.FactHarbor V0\.9\.23 Lost Data.Specification.Diagrams.Core Data Model ERD.WebHome"/}}
254 +{{include reference="Test.FactHarborV09.Specification.Diagrams.Core Data Model ERD.WebHome"/}}
278 278  
279 279  === User Roles Structure ===
280 280  
... ... @@ -291,3 +291,4 @@
291 291  * [[Federation & Decentralization>>FactHarbor.Specification.Federation & Decentralization.WebHome]]
292 292  * [[AKEL (AI Knowledge Extraction Layer)>>FactHarbor.Specification.AI Knowledge Extraction Layer (AKEL).WebHome]]
293 293  * [[Architecture>>FactHarbor.Specification.Architecture.WebHome]]
271 +