Skip to Content
Last modified by Robert Schaub on 2025/12/24 20:35
From version 3.1
edited by Robert Schaub
on 2025/11/26 07:22
Change comment: There is no comment for this version
To version 1.1
edited by Robert Schaub
on 2025/11/25 13:49
Change comment: There is no comment for this version

Summary

Details

Page properties
Title
... ... @@ -1,1 +1,1 @@
1 -Data Model ERD (from text)
1 +ERD
Content
... ... @@ -1,125 +1,3 @@
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 -
125 125  {{/mermaid}}
3 +