Last modified by Robert Schaub on 2025/12/24 21:53

Hide last authors
Robert Schaub 1.1 1 {{mermaid}}
2 erDiagram
Robert Schaub 2.1 3 USER {
4 string UserID PK
5 string role
6 int reputation
7 }
8 MODERATOR {
9 string ModeratorID PK
10 string UserID FK
11 string[] permissions
12 }
13 SYSTEM_SERVICE {
14 string ServiceID PK
15 string ServiceName
16 string Purpose
17 string Status
18 }
19 AKEL {
20 string InstanceID PK
21 string ServiceID FK
22 string Version
23 }
24 BACKGROUND_SCHEDULER {
25 string SchedulerID PK
26 string ServiceID FK
27 string[] ScheduledTasks
28 }
29 SEARCH_INDEXER {
30 string IndexerID PK
31 string ServiceID FK
32 string LastSyncTime
33 }
34 USER ||--o| MODERATOR : "appointed-as"
35 MODERATOR ||--o{ SYSTEM_SERVICE : "monitors"
36 SYSTEM_SERVICE ||--|| AKEL : "AI-processing"
37 SYSTEM_SERVICE ||--|| BACKGROUND_SCHEDULER : "periodic-tasks"
38 SYSTEM_SERVICE ||--|| SEARCH_INDEXER : "search-sync"
Robert Schaub 1.1 39 {{/mermaid}}
40
41 **Simplified technical model**:
42 * **USER**: Standard users (Reader/Contributor based on reputation)
43 * **MODERATOR**: Appointed users with moderation permissions
44 * **SYSTEM_SERVICE**: Automated background services
45 * **AKEL**: AI processing engine
46 * **BACKGROUND_SCHEDULER**: Quality metrics, source updates, cleanup
47 * **SEARCH_INDEXER**: Elasticsearch synchronization
48 **Removed** (no longer in simplified model):