Skip to Content

Wiki source code of Core Data Model ERD (v2.6.33)

Last modified by Robert Schaub on 2026/02/08 08:31
Show last authors
1 {{warning}}
2 **Implementation Status (v2.6.33)** - This diagram shows the **current implementation** data model. Storage is JSON blobs in SQLite, not normalized tables. Scenarios replaced by KeyFactors (optional decomposition questions). No user system implemented.
3 {{/warning}}
4
5 = Current Implementation Data Model =
6
7 {{mermaid}}
8
9 erDiagram
10 ARTICLE ||--o{ CLAIM : contains
11 ARTICLE ||--|| ARTICLE_VERDICT : has
12 CLAIM ||--|| CLAIM_VERDICT : has
13 CLAIM ||--o{ CLAIM : depends_on
14 CLAIM_VERDICT }o--o{ FACT : supported_by
15 SOURCE ||--o{ FACT : provides
16 ARTICLE ||--o{ ANALYSIS_CONTEXT : has
17
18 ARTICLE {
19 string id_PK
20 string inputType
21 string inputValue
22 string articleThesis
23 string detectedInputType
24 boolean hasMultipleScopes
25 json distinctScopes
26 string schemaVersion
27 }
28
29 CLAIM {
30 string id_PK
31 string articleId_FK
32 string text
33 string type
34 string claimRole
35 string_array dependsOn
36 string keyFactorId
37 boolean isCentral
38 string relatedScopeId
39 }
40
41 CLAIM_VERDICT {
42 string id_PK
43 string claimId_FK
44 string verdict
45 int truthPercentage
46 int confidence
47 string explanation
48 string_array supportingFactIds
49 string_array opposingFactIds
50 }
51
52 ARTICLE_VERDICT {
53 string articleId_FK
54 string verdict
55 int truthPercentage
56 int confidence
57 string summary
58 }
59
60 FACT {
61 string id_PK
62 string sourceId_FK
63 string text
64 string quote
65 string relevance
66 boolean supports
67 }
68
69 SOURCE {
70 string id_PK
71 string name
72 string domain
73 string url
74 float reliabilityScore
75 string bias
76 }
77
78 ANALYSIS_CONTEXT {
79 string id_PK
80 string articleId_FK
81 string name
82 string description
83 string methodology
84 string temporalPeriod
85 }
86
87 {{/mermaid}}
88
89 == Key Implementation Notes ==
90
91 **7-Point Verdict Scale:**
92
93 * TRUE (86-100%) / MOSTLY-TRUE (72-85%) / LEANING-TRUE (58-71%)
94 * MIXED (43-57%, high confidence) / UNVERIFIED (43-57%, low confidence)
95 * LEANING-FALSE (29-42%) / MOSTLY-FALSE (15-28%) / FALSE (0-14%)
96
97 **KeyFactors:** Optional decomposition questions discovered during analysis - not stored as separate entities.
98
99 **Storage:** All data stored as JSON blob in SQLite ##ResultJson## field.
100
101 **See Also:** [[Target Data Model>>Archive.FactHarbor 2026\.02\.08.Specification.Data Model.WebHome]] for normalized design.