elderly
Tables (6)
Untitled (conversations)
- Key (conv_id) — INT PRIMARY KEY AUTO_INCREMENT — Primary key — NOT NULL
- user_id — INT FK — Foreign key → users.user_id — NOT NULL
- Field (role) — VARCHAR(10)
- Field (message) — TEXT
- Field (created_at) — DATETIME
Untitled (conditions)
- Key (cond_id) — INT PRIMARY KEY AUTO_INCREMENT — Primary key — NOT NULL
- user_id — INT FK — Foreign key → users.user_id — NOT NULL
- Field (meal) — VARCHAR(255)
- Field (sleep) — VARCHAR(255)
- Field (mood) — VARCHAR(255)
- Field (pain) — VARCHAR(255)
- Field (recorded_at) — DATETIME
Untitled (alerts)
- Key (alert_id) — INT PRIMARY KEY AUTO_INCREMENT — Primary key — NOT NULL
- user_id — INT FK — Foreign key → users.user_id — NOT NULL
- Field (cause) — text
- Field (level) — VARCHAR(10)
- Field (status) — VARCHAR(10)
- Field (created_at) — DATETIME
Untitled (medications)
- Key (med_id) — INT PRIMARY KEY AUTO_INCREMENT — Primary key — NOT NULL
- user_id — INT FK — Foreign key → users.user_id — NOT NULL
- Field (medicine) — VARCHAR(255)
- Field (recorded_at) — DATETIME
Untitled2 (relationships)
- Key (rel_id) — INT PRIMARY KEY AUTO_INCREMENT — Primary key — NOT NULL
- Field (target_id) — INT FK
- Field (guardian_id) — INT FK
- Field (worker_id) — INT FK
users
- user_id — INT PRIMARY KEY AUTO_INCREMENT — Primary key — NOT NULL
- role — VARCHAR(10)
- name — VARCHAR(255)
- code — VARCHAR(255)