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)