Skip to Content

Changes for page Data Model

Last modified by Robert Schaub on 2025/12/24 20:30
From version 2.1
edited by Robert Schaub
on 2025/12/17 13:57
Change comment: Imported from XAR
To version 1.1
edited by Robert Schaub
on 2025/12/16 21:42
Change comment: Imported from XAR

Summary

Details

Page properties
Parent
... ... @@ -1,1 +1,1 @@
1 -Test.FactHarbor.Specification.WebHome
1 +FactHarbor.Specification.WebHome
Content
... ... @@ -1,6 +1,6 @@
1 1  = Data Model =
2 2  
3 -This page describes the current data model for FactHarbor 0.9.25.
3 +This page describes the current data model for FactHarbor v0.9.1.
4 4  
5 5  == 1. Versioning Strategy ==
6 6  
... ... @@ -102,37 +102,37 @@
102 102  **CLAIM / CLAIM_VERSION**:
103 103  * ``CLAIM`` is the long-lived anchor for a real-world claim
104 104  * ``CLAIM_VERSION`` is an immutable snapshot that includes:
105 - * ``VersionID`` (PK)
106 - * ``ClaimID`` (FK to CLAIM)
107 - * ``ParentVersionID`` (FK to prior version, nullable)
108 - * ``Text``
109 - * ``Domain``
110 - * ``ClaimType`` (literal|metaphorical|rhetorical|supernatural)
111 - * ``Evaluability`` (empirical|subjective|non-falsifiable)
112 - * ``RiskTier`` (A|B|C) - replaced SafetyCategory for consistency
113 - * ``PublicationMode`` (Mode1|Mode2|Mode3)
114 - * ``ReviewStatus`` (draft|in_review|approved|rejected)
115 - * ``CreatedAt``, ``AuthorType``, ``CreatedBy``, ``JustificationText``
116 - * ``NodeOrigin``, ``SignatureHash``
117 - * ``Status`` (active|superseded|merged)
105 + * ``VersionID`` (PK)
106 + * ``ClaimID`` (FK to CLAIM)
107 + * ``ParentVersionID`` (FK to prior version, nullable)
108 + * ``Text``
109 + * ``Domain``
110 + * ``ClaimType`` (literal|metaphorical|rhetorical|supernatural)
111 + * ``Evaluability`` (empirical|subjective|non-falsifiable)
112 + * ``RiskTier`` (A|B|C) - replaced SafetyCategory for consistency
113 + * ``PublicationMode`` (Mode1|Mode2|Mode3)
114 + * ``ReviewStatus`` (draft|in_review|approved|rejected)
115 + * ``CreatedAt``, ``AuthorType``, ``CreatedBy``, ``JustificationText``
116 + * ``NodeOrigin``, ``SignatureHash``
117 + * ``Status`` (active|superseded|merged)
118 118  
119 119  **SCENARIO / SCENARIO_VERSION**:
120 120  * ``SCENARIO`` is the anchor for a scenario across time
121 121  * ``SCENARIO_VERSION`` is an immutable snapshot:
122 - * ``VersionID`` (PK)
123 - * ``ScenarioID`` (FK to SCENARIO)
124 - * ``ParentVersionID``
125 - * ``ClaimID`` (FK to CLAIM)
126 - * ``Definitions`` (JSON)
127 - * ``Boundaries`` (JSON)
128 - * ``Assumptions`` (JSON)
129 - * ``Context`` (text)
130 - * ``EvaluationMethod`` (text)
131 - * ``PublicationMode`` (Mode1|Mode2|Mode3)
132 - * ``ReviewStatus`` (draft|in_review|approved|rejected)
133 - * ``CreatedAt``, ``AuthorType``, ``CreatedBy``, ``JustificationText``
134 - * ``NodeOrigin``, ``SignatureHash``
135 - * ``Status`` (active|superseded|deprecated)
122 + * ``VersionID`` (PK)
123 + * ``ScenarioID`` (FK to SCENARIO)
124 + * ``ParentVersionID``
125 + * ``ClaimID`` (FK to CLAIM)
126 + * ``Definitions`` (JSON)
127 + * ``Boundaries`` (JSON)
128 + * ``Assumptions`` (JSON)
129 + * ``Context`` (text)
130 + * ``EvaluationMethod`` (text)
131 + * ``PublicationMode`` (Mode1|Mode2|Mode3)
132 + * ``ReviewStatus`` (draft|in_review|approved|rejected)
133 + * ``CreatedAt``, ``AuthorType``, ``CreatedBy``, ``JustificationText``
134 + * ``NodeOrigin``, ``SignatureHash``
135 + * ``Status`` (active|superseded|deprecated)
136 136  
137 137  **Note**: SafetyClass removed from Scenario - risk tier is at claim level
138 138  
... ... @@ -139,38 +139,38 @@
139 139  **EVIDENCE / EVIDENCE_VERSION**:
140 140  * ``EVIDENCE`` is the anchor
141 141  * ``EVIDENCE_VERSION`` is the versioned snapshot:
142 - * ``VersionID`` (PK)
143 - * ``EvidenceID`` (FK to EVIDENCE)
144 - * ``ParentVersionID``
145 - * ``Type`` (paper|dataset|report|transcript|expert|media)
146 - * ``Category`` (empirical|historical|rhetorical|dataset|meta-analysis)
147 - * ``Reliability`` (low|medium|high)
148 - * ``Provenance`` (URL, DOI, source metadata)
149 - * ``ExtractionMethod`` (manual|OCR|API|AKEL)
150 - * ``ContentHash`` (SHA256 of evidence content)
151 - * ``PublicationMode`` (Mode1|Mode2|Mode3)
152 - * ``ReviewStatus`` (draft|verified|disputed|retracted)
153 - * ``CreatedAt``, ``AuthorType``, ``CreatedBy``, ``JustificationText``
154 - * ``NodeOrigin``, ``SignatureHash``
155 - * ``Status`` (active|superseded)
142 + * ``VersionID`` (PK)
143 + * ``EvidenceID`` (FK to EVIDENCE)
144 + * ``ParentVersionID``
145 + * ``Type`` (paper|dataset|report|transcript|expert|media)
146 + * ``Category`` (empirical|historical|rhetorical|dataset|meta-analysis)
147 + * ``Reliability`` (low|medium|high)
148 + * ``Provenance`` (URL, DOI, source metadata)
149 + * ``ExtractionMethod`` (manual|OCR|API|AKEL)
150 + * ``ContentHash`` (SHA256 of evidence content)
151 + * ``PublicationMode`` (Mode1|Mode2|Mode3)
152 + * ``ReviewStatus`` (draft|verified|disputed|retracted)
153 + * ``CreatedAt``, ``AuthorType``, ``CreatedBy``, ``JustificationText``
154 + * ``NodeOrigin``, ``SignatureHash``
155 + * ``Status`` (active|superseded)
156 156  
157 157  **VERDICT / VERDICT_VERSION**:
158 158  * ``VERDICT`` is the anchor
159 159  * ``VERDICT_VERSION`` is the snapshot:
160 - * ``VersionID`` (PK)
161 - * ``VerdictID`` (FK to VERDICT)
162 - * ``ParentVersionID``
163 - * ``ClaimID`` (FK to CLAIM)
164 - * ``ScenarioVersionID`` (FK to specific SCENARIO_VERSION)
165 - * ``EvidenceVersionSet`` (JSON array of Evidence VersionIDs used)
166 - * ``LikelihoodRange`` (0–1, with uncertainty bounds)
167 - * ``ExplanationChain`` (JSON)
168 - * ``UncertaintyFactors`` (JSON)
169 - * ``PublicationMode`` (Mode1|Mode2|Mode3)
170 - * ``ReviewStatus`` (draft|in_review|approved|retracted)
171 - * ``CreatedAt``, ``AuthorType``, ``CreatedBy``, ``JustificationText``
172 - * ``NodeOrigin``, ``SignatureHash``
173 - * ``Status`` (current|outdated|superseded|retracted)
160 + * ``VersionID`` (PK)
161 + * ``VerdictID`` (FK to VERDICT)
162 + * ``ParentVersionID``
163 + * ``ClaimID`` (FK to CLAIM)
164 + * ``ScenarioVersionID`` (FK to specific SCENARIO_VERSION)
165 + * ``EvidenceVersionSet`` (JSON array of Evidence VersionIDs used)
166 + * ``LikelihoodRange`` (0–1, with uncertainty bounds)
167 + * ``ExplanationChain`` (JSON)
168 + * ``UncertaintyFactors`` (JSON)
169 + * ``PublicationMode`` (Mode1|Mode2|Mode3)
170 + * ``ReviewStatus`` (draft|in_review|approved|retracted)
171 + * ``CreatedAt``, ``AuthorType``, ``CreatedBy``, ``JustificationText``
172 + * ``NodeOrigin``, ``SignatureHash``
173 + * ``Status`` (current|outdated|superseded|retracted)
174 174  
175 175  
176 176  == 3. Many-to-Many Linking Tables ==
... ... @@ -196,10 +196,10 @@
196 196  * ``Theme`` - Human-readable theme description
197 197  
198 198  
199 -== 4. Key Changes Since 0.9.1 ==
199 +== 4. Key Changes in v0.9.1 ==
200 200  
201 201  **Updated Field Names**:
202 -* `SafetyCategory` → ``RiskTier`` (consistency with risk tier system A/B/C)
202 +* `SafetyCategory` → `RiskTier` (consistency with risk tier system A/B/C)
203 203  * `SafetyClass` removed from Scenario (redundant with claim-level RiskTier)
204 204  
205 205  **Added Fields to All Version Entities**: