Changes for page Data Model

Last modified by Robert Schaub on 2026/02/08 08:27

From version 3.1
edited by Robert Schaub
on 2025/12/19 14:41
Change comment: Imported from XAR
To version 1.1
edited by Robert Schaub
on 2025/12/18 12:03
Change comment: Imported from XAR

Summary

Details

Page properties
Content
... ... @@ -157,6 +157,8 @@
157 157  * **description** (text): Human-readable description of the scenario
158 158  * **assumptions** (JSONB): Key assumptions that define this scenario context
159 159  * **extracted_from** (UUID): Reference to evidence that this scenario was extracted from
160 +* **verdict_summary** (text): Compiled verdict for this scenario
161 +* **confidence** (decimal 0-1): Confidence level for verdict in this scenario
160 160  * **created_at** (timestamp): When scenario was created
161 161  * **updated_at** (timestamp): Last modification
162 162  **How Found**: Evidence search → Extract context → Create scenario → Link to claim
... ... @@ -166,33 +166,7 @@
166 166  * Scenario 2: "Real-world data (diverse population, Omicron variant)" from hospital data
167 167  * Scenario 3: "Immunocompromised patients" from specialist study
168 168  **V2.0 Evolution**: Many-to-many relationship can be added if users request cross-claim scenario sharing. For V1.0, keeping scenarios tied to single claims simplifies queries and reduces complexity without limiting functionality.
169 -
170 -=== 1.5 Verdict ===
171 -
172 -**Purpose**: Assessment of a claim within a specific scenario context. Each verdict provides a conclusion about whether the claim is supported, refuted, or uncertain given the scenario's assumptions and available evidence.
173 -
174 -**Core Fields**:
175 -* **id** (UUID): Primary key
176 -* **scenario_id** (UUID FK): The scenario being assessed
177 -* **created_at** (timestamp): When verdict was first created
178 -
179 -**Versioned via VERDICT_VERSION**: Verdicts evolve as new evidence emerges or analysis improves. Each version captures:
180 -* **likelihood_range** (text): Probabilistic assessment (e.g., "0.40-0.65 (uncertain)", "0.75-0.85 (likely true)")
181 -* **confidence** (decimal 0-1): How confident we are in this assessment
182 -* **explanation_summary** (text): Human-readable reasoning explaining the verdict
183 -* **uncertainty_factors** (text array): Specific factors limiting confidence (e.g., "Small sample sizes", "Lifestyle confounds", "Long-term effects unknown")
184 -* **created_at** (timestamp): When this version was generated
185 -
186 -**Relationship**: Each Scenario has multiple Verdicts over time (as understanding evolves). Each Verdict has multiple versions.
187 -
188 -**Example**:
189 -For claim "Exercise improves mental health" in scenario "Clinical trials (healthy adults, structured programs)":
190 -* Initial verdict (v1): likelihood_range="0.40-0.65 (uncertain)", uncertainty_factors=["Small sample sizes", "Short-term studies only"]
191 -* Updated verdict (v2): likelihood_range="0.70-0.85 (likely true)", uncertainty_factors=["Lifestyle confounds remain"]
192 -
193 -**Key Design**: Separating Verdict from Scenario allows tracking how our understanding evolves without losing history.
194 -
195 -=== 1.6 User ===
171 +=== 1.5 User ===
196 196  Fields: username, email, **role** (Reader/Contributor/Moderator), **reputation**, contributions_count
197 197  === User Reputation System ==
198 198  **V1.0 Approach**: Simple manual role assignment
... ... @@ -248,8 +248,8 @@
248 248  * Threshold-based promotions
249 249  * Reputation decay for inactive users
250 250  * Track record scoring for contributors
251 -See [[When to Add Complexity>>Test.FactHarbor.Specification.When-to-Add-Complexity]] for triggers.
252 -=== 1.7 Edit ===
227 +See [[When to Add Complexity>>FactHarbor.Specification.When-to-Add-Complexity]] for triggers.
228 +=== 1.6 Edit ===
253 253  **Fields**: entity_type, entity_id, user_id, before_state (JSON), after_state (JSON), edit_type, reason, created_at
254 254  **Purpose**: Complete audit trail for all content changes
255 255  === Edit History Details ===
... ... @@ -282,9 +282,9 @@
282 282  * Legal compliance (audit trail)
283 283  * Rollback capability
284 284  See **Edit History Documentation** for complete details on what gets edited by whom, retention policy, and use cases
285 -=== 1.8 Flag ===
261 +=== 1.7 Flag ===
286 286  Fields: entity_id, reported_by, issue_type, status, resolution_note
287 -=== 1.9 QualityMetric ===
263 +=== 1.8 QualityMetric ===
288 288  **Fields**: metric_type, category, value, target, timestamp
289 289  **Purpose**: Time-series quality tracking
290 290  **Usage**:
... ... @@ -294,7 +294,7 @@
294 294  * **A/B testing**: Compare control vs treatment metrics
295 295  * **Improvement validation**: Measure before/after changes
296 296  **Example**: `{type: "ErrorRate", category: "Politics", value: 0.12, target: 0.10, timestamp: "2025-12-17"}`
297 -=== 1.10 ErrorPattern ===
273 +=== 1.9 ErrorPattern ===
298 298  **Fields**: error_category, claim_id, description, root_cause, frequency, status
299 299  **Purpose**: Capture errors to trigger system improvements
300 300  **Usage**:
... ... @@ -303,13 +303,8 @@
303 303  * **Improvement workflow**: Analyze → Fix → Test → Deploy → Re-process → Monitor
304 304  * **Metrics**: Track error rate reduction over time
305 305  **Example**: `{category: "WrongSource", description: "Unreliable tabloid cited", root_cause: "No quality check", frequency: 23, status: "Fixed"}`
306 -
307 -== 1.4 Core Data Model ERD ==
308 -
309 -{{include reference="Test.FactHarbor.Specification.Diagrams.Core Data Model ERD.WebHome"/}}
310 -
311 311  == 1.5 User Class Diagram ==
312 -{{include reference="Test.FactHarbor.Specification.Diagrams.User Class Diagram.WebHome"/}}
283 +{{include reference="FactHarbor.Specification.Diagrams.User Class Diagram.WebHome"/}}
313 313  == 2. Versioning Strategy ==
314 314  **All Content Entities Are Versioned**:
315 315  * **Claim**: Every edit creates new version (V1→V2→V3...)
... ... @@ -572,6 +572,6 @@
572 572  * Source names (autocomplete)
573 573  Synchronized from PostgreSQL via change data capture or periodic sync.
574 574  == 4. Related Pages ==
575 -* [[Architecture>>Test.FactHarbor.Specification.Architecture.WebHome]]
576 -* [[Requirements>>Test.FactHarbor.Specification.Requirements.WebHome]]
577 -* [[Workflows>>Test.FactHarbor.Specification.Workflows.WebHome]]
546 +* [[Architecture>>FactHarbor.Specification.Architecture.WebHome]]
547 +* [[Requirements>>FactHarbor.Specification.Requirements.WebHome]]
548 +* [[Workflows>>FactHarbor.Specification.Workflows.WebHome]]