Core Data Model ERD (v2.6.33)

Version 1.1 by Robert Schaub on 2026/01/20 21:40

Warning

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.

Current Implementation Data Model


erDiagram
    ARTICLE ||--o{ CLAIM : contains
    ARTICLE ||--|| ARTICLE_VERDICT : has
    CLAIM ||--|| CLAIM_VERDICT : has
    CLAIM ||--o{ CLAIM : depends_on
    CLAIM_VERDICT }o--o{ FACT : supported_by
    SOURCE ||--o{ FACT : provides
    ARTICLE ||--o{ ANALYSIS_CONTEXT : has

    ARTICLE {
        string id PK
        string inputType
        string inputValue
        string articleThesis
        string detectedInputType
        boolean hasMultipleScopes
        json distinctScopes
        string schemaVersion
    }

    CLAIM {
        string id PK
        string articleId FK
        string text
        string type
        string claimRole
        string_array dependsOn
        string keyFactorId
        boolean isCentral
        string relatedScopeId
    }

    CLAIM_VERDICT {
        string id PK
        string claimId FK
        string verdict
        int truthPercentage
        int confidence
        string explanation
        string_array supportingFactIds
        string_array opposingFactIds
    }

    ARTICLE_VERDICT {
        string articleId FK
        string verdict
        int truthPercentage
        int confidence
        string summary
    }

    FACT {
        string id PK
        string sourceId FK
        string text
        string quote
        string relevance
        boolean supports
    }

    SOURCE {
        string id PK
        string name
        string domain
        string url
        float reliabilityScore
        string bias
    }

    ANALYSIS_CONTEXT {
        string id PK
        string articleId FK
        string name
        string description
        string methodology
        string temporalPeriod
    }

Key Implementation Notes

7-Point Verdict Scale:

  • TRUE (86-100%) / MOSTLY-TRUE (72-85%) / LEANING-TRUE (58-71%)
  • MIXED (43-57%, high confidence) / UNVERIFIED (43-57%, low confidence)
  • LEANING-FALSE (29-42%) / MOSTLY-FALSE (15-28%) / FALSE (0-14%)

KeyFactors: Optional decomposition questions discovered during analysis - not stored as separate entities.

Storage: All data stored as JSON blob in SQLite ResultJson field.

See Also: Target Data Model for normalized design.