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