healthcare
Tables (4)
Untitled (health_records)
- Key (record_id) — Primary key — NOT NULL
- Key (member_id) — Foreign key → members.Key — NOT NULL
- Field (date) — DATE
- Field (weight) — FLOAT
- Field2 (height) — FLOAT
- Field (systolic) — INT
- Field (diastolic) — INT
- Field (blood_sugar) — INT
- Field (steps) — INT
- Field (sleep_hours) — FLOAT
- Field (memo) — TEXT
Untitled (results)
- Key (result_id) — Primary key — NOT NULL
- Key (user_id) — Foreign key → members.Key — NOT NULL
- Key (record_id) — Foreign key → Untitled.Key — NOT NULL
- bmi_value — INT
- bmi_category — VARCHAR(5)
- Field (blood_pressure) — VARCHAR(5)
- Field (blood_sugar) — VARCHAR(5)
edit_history
- Key (edit_id) — Primary key — NOT NULL
- Field (edit_time)
members (users)
- Key (user_id) — Primary key — NOT NULL
- Field (is_admin) — Boolean
- phone_no — VARCHAR(20)
- name — VARCHAR(20)