pill

Tables (4)

member (Untitled3)

  • PK (id) — Integer — Primary key — NOT NULL
  • Field (name) — VARCHAR
  • Field (email) — VARCHAR
  • Field (password) — VARCHAR
  • Field (gender) — ENUM

pill (Untitled2)

  • PK (id) — Integer — Primary key — NOT NULL
  • Field (name) — VARCHAR
  • Field (code) — VARCHAR
  • Field (effect) — TEXT
  • Field (image_url) — VARCHAR
  • Field (dosing) — TEXT
  • Field (caution) — TEXT

pill_schedule (Untitled)

  • PK (id) — Integer — Primary key — NOT NULL
  • Field (pill_name) — VARCHAR
  • Field (is_breakfast) — BOOLEAN
  • Field (is_lunch) — BOOLEAN
  • Field (is_dinner) — BOOLEAN
  • Field
  • FK (pill_id) — Integer — Foreign key → pill.PK — NOT NULL
  • FK (member_id) — Integer — Foreign key → member.PK — NOT NULL
  • Field (is_eat) — BOOLEAN

schedule_day (Untitled4)

  • PK (id) — Integer — Primary key — NOT NULL
  • Field (day) — VARCHAR
  • FK (pill_schedule_id) — Integer — Foreign key → pill_schedule.PK — NOT NULL