Skip to Content
Last modified by Robert Schaub on 2025/12/24 20:30
Show last authors
1 = Core Data Model ERD (Versioned) =
2
3 This diagram shows the full core data model with all versioned entities.
4
5 {{mermaid}}
6 erDiagram
7 CLAIM_CLUSTER {
8 string ClusterID PK
9 string EmbeddingVectorRef
10 string Theme
11 }
12
13 CLAIM {
14 string ClaimID PK
15 string ClusterID FK
16 string Status
17 datetime CreatedAt
18 }
19
20 CLAIM_VERSION {
21 string ClaimVersionID PK
22 string ClaimID FK
23 string Text
24 string ClaimType
25 string Domain
26 datetime CreatedAt
27 }
28
29 SCENARIO {
30 string ScenarioID PK
31 string ClaimID FK
32 string Name
33 datetime CreatedAt
34 }
35
36 SCENARIO_VERSION {
37 string ScenarioVersionID PK
38 string ScenarioID FK
39 string Definitions
40 string Assumptions
41 string Boundaries
42 datetime CreatedAt
43 }
44
45 EVIDENCE {
46 string EvidenceID PK
47 string SourceType
48 string URL
49 float ReliabilityScore
50 }
51
52 EVIDENCE_VERSION {
53 string EvidenceVersionID PK
54 string EvidenceID FK
55 string Summary
56 float ReliabilityScore
57 datetime CreatedAt
58 }
59
60 SCENARIO_EVIDENCE_LINK {
61 string LinkID PK
62 string ScenarioVersionID FK
63 string EvidenceVersionID FK
64 float Relevance
65 string Direction
66 }
67
68 VERDICT {
69 string VerdictID PK
70 string ScenarioID FK
71 }
72
73 VERDICT_VERSION {
74 string VerdictVersionID PK
75 string VerdictID FK
76 float Verdict
77 float Confidence
78 string Reasoning
79 datetime CreatedAt
80 }
81
82 CLAIM_CLUSTER ||--o{ CLAIM : contains
83 CLAIM ||--o{ CLAIM_VERSION : versions
84
85 CLAIM ||--o{ SCENARIO : has
86 SCENARIO ||--o{ SCENARIO_VERSION : versions
87
88 EVIDENCE ||--o{ EVIDENCE_VERSION : versions
89
90 SCENARIO_VERSION ||--o{ SCENARIO_EVIDENCE_LINK : links
91 EVIDENCE_VERSION ||--o{ SCENARIO_EVIDENCE_LINK : linked
92
93 SCENARIO ||--o{ VERDICT : assessed
94 VERDICT ||--o{ VERDICT_VERSION : versions
95 {{/mermaid}}
96
97 {{info}}
98 All key entities are explicitly versioned here (…VERSION tables).
99 This reflects the versioning requirements in the textual Data Model chapter.
100 {{/info}}