Korot

Tables (5)

Analysis (Untitled4)

  • id (Key) — INTEGER — Primary key — NOT NULL
  • user_id (Field) — INTEGER
  • blood_pressure_data (Field2) — JSON
  • post_care_data (Field3) — JSON
  • created_at (Field4) — DATATIME

AverageBloodPressure (CopyOfUntitled22)

  • id (Key) — INTEGER — Primary key — NOT NULL
  • id (Key2) — INTEGER — Foreign key → USER.UserID — NOT NULL
  • user_id (Field2) — INTEGER
  • data (Field4) — DATA
  • measurement_time (Field5) — DATATIME
  • cuff_graph (Field6) — BLOB
  • systolic (Field7) — INTEGER
  • diastolic (Field) — INTEGER
  • pulse (Field3) — INTEGER

BloodPressureData (Untitled2)

  • id (Key) — INTEGER — Primary key — NOT NULL
  • id (Key2) — INTEGER — Foreign key → USER.UserID — NOT NULL
  • user_id (Field2) — INTEGER
  • data (Field4) — DATA
  • measurement_time (Field5) — DATATIME
  • cuff_graph (Field6) — BLOB
  • systolic (Field7) — INTEGER
  • diastolic (Field) — INTEGER
  • pulse (Field3) — INTEGER

PostCare (Untitled3)

  • PostCareID (Key) — INTEGER — Primary key — NOT NULL
  • UserID (Key2) — INTEGER — Foreign key → USER.UserID — NOT NULL
  • user_id (Field) — INTEGER
  • medication (Field2) — VARCHAR(255)
  • exercise (Field3) — VARCHAR(255)
  • diet (Field4) — VARCHAR(255)
  • alcohol (Field5) — VARCHAR(50
  • smoking (Field6) — VARCHAR(50
  • created_at (Field7) — DATETIME

USER (Untitled)

  • UserID (Key) — INTEGER — Primary key — NOT NULL
  • username (Field2) — VARCHAR(50)
  • password (Field3) — VARCHAR(255)
  • phonenumber (Field4) — VARCHAR(15)
  • age (Field5) — INTEGER
  • tall (Field6) — FLOAT
  • weight (Field7) — FLOAT
  • sex (Field) — ENUM('male', 'female', 'other')
  • item_number (Field8) — VARCHAR(20)