Skip to Content

Wiki source code of Data Model ERD (from text)

Last modified by Robert Schaub on 2025/12/24 20:35
Hide last authors
Robert Schaub 1.1 1 {{mermaid}}
Robert Schaub 2.1 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
Robert Schaub 1.1 125 {{/mermaid}}