Skip to Content
Last modified by Robert Schaub on 2026/02/08 08:31
From version 2.3
edited by Robert Schaub
on 2026/02/08 08:31
Change comment: Update document after refactoring.
To version 1.1
edited by Robert Schaub
on 2026/01/20 21:40
Change comment: Imported from XAR

Summary

Details

Page properties
Parent
... ... @@ -1,1 +1,1 @@
1 -Archive.FactHarbor 2026\.02\.08.Specification.Diagrams.WebHome
1 +FactHarbor.Specification.Diagrams.WebHome
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,7 +29,6 @@
29 29  {{/mermaid}}
30 30  
31 31  **Current audit capabilities:**
32 -
33 33  * Job creation and completion timestamps
34 34  * Job execution events (start, progress, errors)
35 35  * No entity-level versioning
... ... @@ -47,37 +47,37 @@
47 47   KEY_FACTORS ||--o{ EDITS : tracks
48 48  
49 49   USERS {
50 - uuid id_PK
49 + uuid id PK
51 51   text name
52 52   text email
53 53   }
54 54  
55 55   CLAIMS {
56 - uuid id_PK
55 + uuid id PK
57 57   text text
58 58   }
59 59  
60 60   EVIDENCE {
61 - uuid id_PK
62 - uuid claim_id_FK
60 + uuid id PK
61 + uuid claim_id FK
63 63   }
64 64  
65 65   SOURCES {
66 - uuid id_PK
65 + uuid id PK
67 67   text name
68 68   }
69 69  
70 70   KEY_FACTORS {
71 - uuid id_PK
72 - uuid claim_id_FK
70 + uuid id PK
71 + uuid claim_id FK
73 73   text question
74 74   }
75 75  
76 76   EDITS {
77 - uuid id_PK
76 + uuid id PK
78 78   text entity_type
79 79   uuid entity_id
80 - uuid user_id_FK
79 + uuid user_id FK
81 81   text change_type
82 82   boolean is_automated
83 83   jsonb changes
... ... @@ -88,10 +88,9 @@
88 88  {{/mermaid}}
89 89  
90 90  **Target features:**
91 -
92 92  * Full entity versioning (Claims, Evidence, Sources, KeyFactors)
93 93  * User attribution for all changes
94 94  * AKEL vs human edit distinction
95 95  * Hot/cold storage tiering (PostgreSQL + S3)
96 96  
97 -See [[Data Model>>Archive.FactHarbor 2026\.02\.08.Specification.Data Model.WebHome]] for complete target architecture.
95 +See [[Data Model>>FactHarbor.Specification.Data Model.WebHome]] for complete target architecture.