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)