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)