health care

Tables (5)

health_alerts

  • alert_id — SERIAL — Primary key — NOT NULL
  • record_id — INT — Foreign key → health_records.record_id — NOT NULL
  • alert_type — VARCHAR(30) — NOT NULL
  • message — TEXT — NOT NULL
  • created_at — TIMESTAMP

health_goals

  • goal_id — SERIAL — Primary key — NOT NULL
  • user_id — INT — Foreign key → users.user_id — NOT NULL
  • target_weight — NUMERIC(5, 2)
  • target_systolic — INT
  • target_diastolic — INT
  • target_blood_sugar — INT
  • start_date — DATE — NOT NULL
  • target_date — DATE
  • created_at — TIMESTAMP

health_records

  • record_id — SERIAL — Primary key — NOT NULL
  • user_id — INT — Foreign key → users.user_id — NOT NULL
  • record_date — DATE — NOT NULL
  • weight — NUMERIC(5, 2) — NOT NULL
  • systolic — INT — NOT NULL
  • diastolic — INT — NOT NULL
  • blood_sugar — INT — NOT NULL
  • steps — INT
  • sleep_hours — NUMERIC(4, 1)
  • memo — TEXT
  • bmi — NUMERIC(4, 1)
  • bmi_category — VARCHAR(20)
  • bp_category — VARCHAR(20)
  • sugar_category — VARCHAR(20)
  • created_at — TIMESTAMP

user_profiles

  • profile_id — SERIAL — Primary key — NOT NULL
  • user_id — INT — Foreign key → users.user_id — NOT NULL
  • height — NUMERIC(5, 2) — NOT NULL
  • gender — VARCHAR(10)
  • birth_date — DATE
  • updated_at — TIMESTAMP

users

  • user_id — SERIAL — Primary key — NOT NULL
  • email — VARCHAR(100) — NOT NULL
  • username — VARCHAR(50) — NOT NULL
  • created_at — TIMESTAMP