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)