Changes for page Data Model
Last modified by Robert Schaub on 2025/12/24 20:30
To version 2.2
edited by Robert Schaub
on 2025/12/17 18:07
on 2025/12/17 18:07
Change comment:
Update document after refactoring.
Summary
-
Page properties (2 modified, 0 added, 0 removed)
Details
- Page properties
-
- Parent
-
... ... @@ -1,1 +1,1 @@ 1 -FactHarbor.Specification.WebHome 1 +FactHarbor.Archive.FactHarbor 0\.9\.40.Specification.WebHome - Content
-
... ... @@ -1,6 +1,6 @@ 1 1 = Data Model = 2 2 3 -This page describes the current data model for FactHarbor v0.9.1.3 +This page describes the current data model for FactHarbor 0.9.25. 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 - 106 - 107 - 108 - 109 - 110 - 111 - 112 - 113 - 114 - 115 - 116 - 117 - 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 - 123 - 124 - 125 - 126 - 127 - 128 - 129 - 130 - 131 - 132 - 133 - 134 - 135 - 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 - 143 - 144 - 145 - 146 - 147 - 148 - 149 - 150 - 151 - 152 - 153 - 154 - 155 - 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 - 161 - 162 - 163 - 164 - 165 - 166 - 167 - 168 - 169 - 170 - 171 - 172 - 173 - 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 in v0.9.1 ==199 +== 4. Key Changes Since 0.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**: