Careplay DB ERD
Tables (4)
BPM
- Timestamp — datetime — Primary key — NOT NULL — The timestamp of the moment when the data was collected.
- ID — UUID — Foreign key → User.ID — NOT NULL — This will be the main unique ID for each user
- BPM — Float — The BPM of the user in specific time
Data_list
- ID — UUID — Foreign key → User.ID — NOT NULL — This will be the main unique ID for each user
- data_type — String — NOT NULL — Avalable data type for current user.
HRV
- Timestamp — datetime — Primary key — NOT NULL — The timestamp of the moment when the data was collected.
- ID — UUID — Foreign key → User.ID — NOT NULL — This will be the main unique ID for each user
- HRV — Float — The HRV of the user in specific time
User
- ID — UUID — Primary key — NOT NULL — This will be the main unique ID for each user
- user_nickname — String — NOT NULL — The user's in-game nickname or id
- metadata — json — All possible metadata as the type of the content, the version of the hardware etc...
- s3_path — String — NOT NULL — The path to the raw data extracted from the hardware in the s3 bucket