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