health_care
Tables (4)
HealthRecord (Untitled2)
- record_id (Key) — INT — Primary key — NOT NULL
- user_id (Field) — INT
- date (Field2) — DATE
- weight (Field3) — FLOAT
- exercise_time (Field4) — INT
- sleep_time (Field5) — INT
- blood_pressure (Field6) — VARCHAR(20)
- user_id (Key2) — INT — Foreign key → User.user_id — NOT NULL
Log (Untitled4)
- log_id (Key) — INT — Primary key — NOT NULL
- user_id (Field) — INT
- action (Field2) — VARCHAR(20)
- table_name (Field3) — VARCHAR(50)
- record_id (Field4) — INT
- changed_at (Field5) — DATETIME
- user_id (Key2) — INT — Foreign key → User.user_id — NOT NULL
Report (Untitled3)
- report_id (Key) — INT — Primary key — NOT NULL
- user_id (Field) — INT
- period (Field2) — VARCHAR(20)
- avg_weight (Field3) — FLOAT
- total_exercise_time (Field4) — INT
- avg_sleep_time (Field5) — INT
- created_at (Field6) — DATETIME
- user_id (Key2) — INT — Foreign key → User.user_id — NOT NULL
User (Untitled)
- user_id (Key) — INT — Primary key — NOT NULL
- username (Field) — VARCHAR(50)
- email (Field2) — VARCHAR(100)
- password (Field3) — VARCHAR(100)