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
Change comment: There is no comment for this version
To version 2.1
edited by Robert Schaub
on 2025/11/25 13:51
Change comment: There is no comment for this version

Summary

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