Changes for page Data Model ERD (from text)
Last modified by Robert Schaub on 2025/12/24 20:35
From version 1.1
edited by Robert Schaub
on 2025/11/25 13:49
on 2025/11/25 13:49
Change comment:
There is no comment for this version
To version 2.1
edited by Robert Schaub
on 2025/11/25 13:51
on 2025/11/25 13:51
Change comment:
There is no comment for this version
Summary
-
Page properties (1 modified, 0 added, 0 removed)
Details
- Page properties
-
- Content
-
... ... @@ -1,3 +1,126 @@ 1 1 {{mermaid}} 2 + erDiagram 3 + 4 + CLAIM ||--o{ CLAIM_VERSION : has_versions 5 + CLAIM { 6 + string claim_id 7 + string title 8 + string short_summary 9 + string category 10 + string status 11 + datetime created_at 12 + string created_by 13 + } 14 + 15 + CLAIM_VERSION ||--o{ EVIDENCE_ITEM : evidence_items 16 + CLAIM_VERSION ||--o{ ASSUMPTION : assumptions 17 + CLAIM_VERSION ||--o{ CONTEXT_BLOCK : context_blocks 18 + CLAIM_VERSION ||--o{ RATING : ratings 19 + CLAIM_VERSION { 20 + string version_id 21 + int version_number 22 + string version_status 23 + datetime updated_at 24 + string updated_by 25 + string claim_text 26 + } 27 + 28 + EVIDENCE_ITEM }o--|| SOURCE : originates_from 29 + EVIDENCE_ITEM { 30 + string evidence_id 31 + string type 32 + string extraction_method 33 + string relevance 34 + string interpretation 35 + } 36 + 37 + SOURCE { 38 + string source_id 39 + string source_type 40 + string url 41 + string publisher 42 + datetime published_date 43 + string source_reliability 44 + } 45 + 46 + ASSUMPTION { 47 + string assumption_id 48 + string description 49 + string justification 50 + string impact_level 51 + } 52 + 53 + CONTEXT_BLOCK { 54 + string context_id 55 + string description 56 + string category 57 + } 58 + 59 + RATING ||--|| METHODOLOGY : uses 60 + RATING ||--|| REVIEWER : rated_by 61 + RATING { 62 + string rating_id 63 + float score 64 + string scale 65 + string explanation 66 + datetime rated_at 67 + } 68 + 69 + METHODOLOGY { 70 + string methodology_id 71 + string name 72 + string version 73 + string description 74 + string formula 75 + } 76 + 77 + REVIEWER { 78 + string reviewer_id 79 + string name 80 + string role 81 + string expertise_area 82 + string affiliation 83 + } 84 + 85 + CLAIM ||--o{ DISCUSSION_THREAD : discussions 86 + DISCUSSION_THREAD ||--o{ COMMENT : comments 87 + COMMENT ||--|| USER : written_by 88 + 89 + DISCUSSION_THREAD { 90 + string thread_id 91 + string topic 92 + datetime created_at 93 + } 94 + 95 + COMMENT { 96 + string comment_id 97 + string content 98 + datetime posted_at 99 + } 100 + 101 + USER { 102 + string user_id 103 + string name 104 + string role 105 + } 106 + 107 + CLAIM ||--o{ GOVERNANCE_RECORD : governance_records 108 + GOVERNANCE_RECORD ||--|| GOVERNANCE_RULE : applies_rule 109 + 110 + GOVERNANCE_RECORD { 111 + string gov_record_id 112 + string action 113 + string performed_by 114 + datetime timestamp 115 + string justification 116 + } 117 + 118 + GOVERNANCE_RULE { 119 + string rule_id 120 + string rule_type 121 + string description 122 + string severity 123 + } 124 + 2 2 {{/mermaid}} 3 3