4JO-FINAL

Tables (5)

call_logs

  • id — UUID
  • elder_id — UUID — NOT NULL
  • call_started_at — TIMESTAMPTZ — NOT NULL
  • call_ended_at — TIMESTAMPTZ
  • status — VARCHAR(20) — NOT NULL
  • audio_file_url — VARCHAR(255)
  • transcript — TEXT

diaries

  • id — UUID
  • elder_id — UUID — NOT NULL
  • call_log_id — UUID
  • diary_date — DATE — NOT NULL
  • summary — TEXT — NOT NULL
  • image_prompt — TEXT
  • generated_image_url — VARCHAR(255)
  • ai_analysis — TEXT
  • created_at — TIMESTAMPTZ

todos

  • id — UUID
  • elder_id — UUID — NOT NULL
  • created_by_guardian_id — UUID — NOT NULL
  • content — TEXT — NOT NULL
  • due_date — TIMESTAMPTZ — NOT NULL
  • is_completed — BOOLEAN
  • completed_at — TIMESTAMPTZ
  • created_at — TIMESTAMPTZ

user_relationships

  • guardian_id — UUID — Primary key — NOT NULL
  • elder_id — UUID — Primary key — NOT NULL

users

  • id — UUID
  • phone_number — VARCHAR(20) — NOT NULL
  • password_hash — VARCHAR(255) — NOT NULL
  • full_name — VARCHAR(100) — NOT NULL
  • role — USER_ROLE — NOT NULL
  • created_at — TIMESTAMPTZ
  • updated_at — TIMESTAMPTZ