File size: 1,309 Bytes
2205681 | 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 | # Entity-Relationship Diagram
```mermaid
erDiagram
User ||--o{ Chat : has
User ||--o{ ModelUsage : has
Chat ||--o{ Message : has
Chat ||--o{ ModelUsage : linked_to
User {
Integer user_id PK
String username "Unique, Not Null"
String email "Unique, Not Null"
DateTime created_at "Default=datetime.utcnow"
}
Chat {
Integer chat_id PK
Integer user_id FK
String title "Default='New Chat'"
DateTime created_at "Default=datetime.utcnow"
}
Message {
Integer message_id PK
Integer chat_id FK
String sender "Not Null"
Text content "Not Null"
DateTime timestamp "Default=datetime.utcnow"
}
ModelUsage {
Integer usage_id PK
Integer user_id FK
Integer chat_id FK
String model_name "Not Null"
String provider "Not Null"
Integer prompt_tokens "Default=0"
Integer completion_tokens "Default=0"
Integer total_tokens "Default=0"
Integer query_size "Default=0"
Integer response_size "Default=0"
Float cost "Default=0.0"
DateTime timestamp "Default=datetime.utcnow"
Boolean is_streaming "Default=False"
Integer request_time_ms "Default=0"
}
``` |