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