Database Design (ERD)
Visualizing the Hybrid Data Architecture: Firestore (Cloud) + Local Repository.
Logical Entity Relationship Diagram
The diagram below illustrates the relationship between the User entity (Cloud) and the Task entity (Local).
USER (Cloud)
PK userId
UUID
username
String
email
String
adhdType
List
tasksDone
Int
sessions
Int
➜
TASK (Local)
PK taskId
UUID
FK userId
UUID
title
String
desc
String
done
Bool
due
Long
NoSQL Document Structure
Since AxonFlow uses Firebase Firestore, the data is structured as Documents within Collections. Below is the JSON representation of a User Profile document.
/users/{userId}
{
"username": "EdwinW",
"email": "edwin@example.com",
"adhdTypes": ["Combined"],
"tasksCompleted": 5,
"sessionsCompleted": 3
}
{
"username": "EdwinW",
"email": "edwin@example.com",
"adhdTypes": ["Combined"],
"tasksCompleted": 5,
"sessionsCompleted": 3
}