Data Model ERD (from text)

  erDiagram

    CLAIM ||--o{ CLAIM_VERSION : has_versions
    CLAIM {
        string claim_id
        string title
        string short_summary
        string category
        string status
        datetime created_at
        string created_by
    }

    CLAIM_VERSION ||--o{ EVIDENCE_ITEM : evidence_items
    CLAIM_VERSION ||--o{ ASSUMPTION : assumptions
    CLAIM_VERSION ||--o{ CONTEXT_BLOCK : context_blocks
    CLAIM_VERSION ||--o{ RATING : ratings
    CLAIM_VERSION {
        string version_id
        int version_number
        string version_status
        datetime updated_at
        string updated_by
        string claim_text
    }

    EVIDENCE_ITEM }o--|| SOURCE : originates_from
    EVIDENCE_ITEM {
        string evidence_id
        string type
        string extraction_method
        string relevance
        string interpretation
    }

    SOURCE {
        string source_id
        string source_type
        string url
        string publisher
        datetime published_date
        string source_reliability
    }

    ASSUMPTION {
        string assumption_id
        string description
        string justification
        string impact_level
    }

    CONTEXT_BLOCK {
        string context_id
        string description
        string category
    }

    RATING ||--|| METHODOLOGY : uses
    RATING ||--|| REVIEWER : rated_by
    RATING {
        string rating_id
        float score
        string scale
        string explanation
        datetime rated_at
    }

    METHODOLOGY {
        string methodology_id
        string name
        string version
        string description
        string formula
    }

    REVIEWER {
        string reviewer_id
        string name
        string role
        string expertise_area
        string affiliation
    }

    CLAIM ||--o{ DISCUSSION_THREAD : discussions
    DISCUSSION_THREAD ||--o{ COMMENT : comments
    COMMENT ||--|| USER : written_by

    DISCUSSION_THREAD {
        string thread_id
        string topic
        datetime created_at
    }

    COMMENT {
        string comment_id
        string content
        datetime posted_at
    }

    USER {
        string user_id
        string name
        string role
    }

    CLAIM ||--o{ GOVERNANCE_RECORD : governance_records
    GOVERNANCE_RECORD ||--|| GOVERNANCE_RULE : applies_rule

    GOVERNANCE_RECORD {
        string gov_record_id
        string action
        string performed_by
        datetime timestamp
        string justification
    }

    GOVERNANCE_RULE {
        string rule_id
        string rule_type
        string description
        string severity
    }