Skip to Content
Last modified by Robert Schaub on 2026/02/08 08:31
From version 1.1
edited by Robert Schaub
on 2026/01/20 21:40
Change comment: Imported from XAR
To version 2.2
edited by Robert Schaub
on 2026/02/08 08:31
Change comment: Renamed back-links.

Summary

Details

Page properties
Content
... ... @@ -10,7 +10,7 @@
10 10   JOBS ||--o{ JOB_EVENTS : logs
11 11  
12 12   JOBS {
13 - int JobId PK
13 + int JobId_PK
14 14   string Status
15 15   datetime CreatedAt
16 16   datetime UpdatedAt
... ... @@ -19,8 +19,8 @@
19 19   }
20 20  
21 21   JOB_EVENTS {
22 - int Id PK
23 - int JobId FK
22 + int Id_PK
23 + int JobId_FK
24 24   datetime TsUtc
25 25   string Level
26 26   string Message
... ... @@ -29,6 +29,7 @@
29 29  {{/mermaid}}
30 30  
31 31  **Current audit capabilities:**
32 +
32 32  * Job creation and completion timestamps
33 33  * Job execution events (start, progress, errors)
34 34  * No entity-level versioning
... ... @@ -46,37 +46,37 @@
46 46   KEY_FACTORS ||--o{ EDITS : tracks
47 47  
48 48   USERS {
49 - uuid id PK
50 + uuid id_PK
50 50   text name
51 51   text email
52 52   }
53 53  
54 54   CLAIMS {
55 - uuid id PK
56 + uuid id_PK
56 56   text text
57 57   }
58 58  
59 59   EVIDENCE {
60 - uuid id PK
61 - uuid claim_id FK
61 + uuid id_PK
62 + uuid claim_id_FK
62 62   }
63 63  
64 64   SOURCES {
65 - uuid id PK
66 + uuid id_PK
66 66   text name
67 67   }
68 68  
69 69   KEY_FACTORS {
70 - uuid id PK
71 - uuid claim_id FK
71 + uuid id_PK
72 + uuid claim_id_FK
72 72   text question
73 73   }
74 74  
75 75   EDITS {
76 - uuid id PK
77 + uuid id_PK
77 77   text entity_type
78 78   uuid entity_id
79 - uuid user_id FK
80 + uuid user_id_FK
80 80   text change_type
81 81   boolean is_automated
82 82   jsonb changes
... ... @@ -87,9 +87,10 @@
87 87  {{/mermaid}}
88 88  
89 89  **Target features:**
91 +
90 90  * Full entity versioning (Claims, Evidence, Sources, KeyFactors)
91 91  * User attribution for all changes
92 92  * AKEL vs human edit distinction
93 93  * Hot/cold storage tiering (PostgreSQL + S3)
94 94  
95 -See [[Data Model>>FactHarbor.Specification.Data Model.WebHome]] for complete target architecture.
97 +See [[Data Model>>Archive.FactHarbor 2026\.02\.08.Specification.Data Model.WebHome]] for complete target architecture.