Skip to Content
Last modified by Robert Schaub on 2025/12/24 20:35
From version 7.1
edited by Robert Schaub
on 2025/11/27 12:41
Change comment: There is no comment for this version
To version 5.2
edited by Robert Schaub
on 2025/11/27 12:31
Change comment: There is no comment for this version

Summary

Details

Page properties
Content
... ... @@ -62,8 +62,110 @@
62 62  and fields with {{code}}...IdFk{{/code}} are foreign keys.
63 63  
64 64  {{comment}} Core Data Model ERD (Mermaid, from /Specification/Diagrams/Data Model) {{/comment}}
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"/}}
65 +{{include document="FactHarbor.Playground.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 +
67 67  **Important points:**
68 68  
69 69  * Scenarios and Evidence are **linked via their versions**
... ... @@ -85,7 +85,7 @@
85 85  * Review actions on versioned entities
86 86  
87 87  {{comment}} Data Use ERD (Mermaid, from /Specification/Diagrams/Data Use ERD) {{/comment}}
88 -{{include document="FactHarbor.Playground.Data Use ERD Page (from Specification chat).WebHome" reference="FactHarbor.Playground.data.Data Use ERD Page (from Specification chat).WebHome"/}}
190 +{{include document="FactHarbor.Playground.Data Use ERD Page (from Specification chat).WebHome"/}}
89 89  
90 90  = Data Use ERD (Roles, Review & Versioned Entities) =
91 91