Skip to Content
Last modified by Robert Schaub on 2025/12/24 20:35
From version 6.3
edited by Robert Schaub
on 2025/11/27 12:36
Change comment: Renamed back-links.
To version 7.1
edited by Robert Schaub
on 2025/11/27 12:41
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -64,108 +64,6 @@
64 64  {{comment}} Core Data Model ERD (Mermaid, from /Specification/Diagrams/Data Model) {{/comment}}
65 65  {{include document="FactHarbor.Playground.Core Data Model ERD Page (from Specification chat).WebHome" reference="FactHarbor.Playground.data.Core Data Model ERD Page (from Specification chat).WebHome"/}}
66 66  
67 -= Core Data Model ERD (Versioned) =
68 -
69 -This diagram shows the full core data model with all versioned entities.
70 -
71 -{{mermaid}}
72 -erDiagram
73 - CLAIM_CLUSTER {
74 - string ClusterID PK
75 - string EmbeddingVectorRef
76 - string Theme
77 - }
78 -
79 - CLAIM {
80 - string ClaimID PK
81 - string ClusterID FK
82 - string Status
83 - datetime CreatedAt
84 - }
85 -
86 - CLAIM_VERSION {
87 - string ClaimVersionID PK
88 - string ClaimID FK
89 - string Text
90 - string ClaimType
91 - string Domain
92 - datetime CreatedAt
93 - }
94 -
95 - SCENARIO {
96 - string ScenarioID PK
97 - string ClaimID FK
98 - string Name
99 - datetime CreatedAt
100 - }
101 -
102 - SCENARIO_VERSION {
103 - string ScenarioVersionID PK
104 - string ScenarioID FK
105 - string Definitions
106 - string Assumptions
107 - string Boundaries
108 - datetime CreatedAt
109 - }
110 -
111 - EVIDENCE {
112 - string EvidenceID PK
113 - string SourceType
114 - string URL
115 - float ReliabilityScore
116 - }
117 -
118 - EVIDENCE_VERSION {
119 - string EvidenceVersionID PK
120 - string EvidenceID FK
121 - string Summary
122 - float ReliabilityScore
123 - datetime CreatedAt
124 - }
125 -
126 - SCENARIO_EVIDENCE_LINK {
127 - string LinkID PK
128 - string ScenarioVersionID FK
129 - string EvidenceVersionID FK
130 - float Relevance
131 - string Direction
132 - }
133 -
134 - VERDICT {
135 - string VerdictID PK
136 - string ScenarioID FK
137 - }
138 -
139 - VERDICT_VERSION {
140 - string VerdictVersionID PK
141 - string VerdictID FK
142 - float Verdict
143 - float Confidence
144 - string Reasoning
145 - datetime CreatedAt
146 - }
147 -
148 - CLAIM_CLUSTER ||--o{ CLAIM : contains
149 - CLAIM ||--o{ CLAIM_VERSION : versions
150 -
151 - CLAIM ||--o{ SCENARIO : has
152 - SCENARIO ||--o{ SCENARIO_VERSION : versions
153 -
154 - EVIDENCE ||--o{ EVIDENCE_VERSION : versions
155 -
156 - SCENARIO_VERSION ||--o{ SCENARIO_EVIDENCE_LINK : links
157 - EVIDENCE_VERSION ||--o{ SCENARIO_EVIDENCE_LINK : linked
158 -
159 - SCENARIO ||--o{ VERDICT : assessed
160 - VERDICT ||--o{ VERDICT_VERSION : versions
161 -{{/mermaid}}
162 -
163 -{{info}}
164 -All key entities are explicitly versioned here (…VERSION tables).
165 -This reflects the versioning requirements in the textual Data Model chapter.
166 -{{/info}}
167 -
168 -
169 169  **Important points:**
170 170  
171 171  * Scenarios and Evidence are **linked via their versions**