GrandBy

Tables (12)

call_logs

  • call_id — VARCHAR(36)
  • elderly_id — VARCHAR(36) — NOT NULL
  • call_status — VARCHAR(20) — NOT NULL
  • call_start_time — TIMESTAMP
  • call_end_time — TIMESTAMP
  • call_duration — INTEGER
  • audio_file_url — VARCHAR(500)
  • conversation_summary — TEXT
  • twilio_call_sid — VARCHAR(100)
  • created_at — TIMESTAMP

call_settings

  • setting_id — VARCHAR(36)
  • elderly_id — VARCHAR(36) — NOT NULL
  • frequency — VARCHAR(20)
  • call_time — TIME — NOT NULL
  • is_active — BOOLEAN
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

call_transcripts

  • transcript_id — VARCHAR(36)
  • call_id — VARCHAR(36) — NOT NULL
  • speaker — VARCHAR(20) — NOT NULL
  • text — TEXT — NOT NULL
  • timestamp — FLOAT
  • created_at — TIMESTAMP

diaries

  • diary_id — VARCHAR(36)
  • user_id — VARCHAR(36) — NOT NULL
  • author_id — VARCHAR(36) — NOT NULL
  • call_id — VARCHAR(36)
  • date — DATE — NOT NULL
  • content — TEXT — NOT NULL
  • author_type — VARCHAR(20) — NOT NULL
  • is_auto_generated — BOOLEAN
  • status — VARCHAR(20)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

diary_comments

  • comment_id — VARCHAR(36)
  • diary_id — VARCHAR(36) — NOT NULL
  • user_id — VARCHAR(36) — NOT NULL
  • content — TEXT — NOT NULL
  • is_read — BOOLEAN
  • created_at — TIMESTAMP

diary_photos

  • photo_id — VARCHAR(36)
  • diary_id — VARCHAR(36) — NOT NULL
  • uploaded_by — VARCHAR(36) — NOT NULL
  • photo_url — VARCHAR(500) — NOT NULL
  • created_at — TIMESTAMP

emotion_logs

  • emotion_id — VARCHAR(36)
  • call_id — VARCHAR(36) — NOT NULL
  • emotion_type — VARCHAR(20) — NOT NULL
  • emotion_score — FLOAT — NOT NULL
  • detected_keywords — TEXT
  • analyzed_at — TIMESTAMP

notifications

  • notification_id — VARCHAR(36)
  • user_id — VARCHAR(36) — NOT NULL
  • type — VARCHAR(30) — NOT NULL
  • title — VARCHAR(200) — NOT NULL
  • message — TEXT — NOT NULL
  • related_id — VARCHAR(36)
  • is_read — BOOLEAN
  • is_pushed — BOOLEAN
  • created_at — TIMESTAMP
  • read_at — TIMESTAMP

todos

  • todo_id — VARCHAR(36)
  • elderly_id — VARCHAR(36) — NOT NULL
  • creator_id — VARCHAR(36) — NOT NULL
  • call_id — VARCHAR(36)
  • title — VARCHAR(200) — NOT NULL
  • description — TEXT
  • category — VARCHAR(20)
  • due_date — DATE — NOT NULL
  • due_time — TIME
  • is_recurring — BOOLEAN
  • recurring_type — VARCHAR(20)
  • recurring_interval — INTEGER
  • recurring_days — INTEGER
  • recurring_day_of_month — INTEGER
  • recurring_start_date — DATE
  • recurring_end_date — DATE
  • parent_recurring_id — VARCHAR(36)
  • creator_type — VARCHAR(20) — NOT NULL
  • status — VARCHAR(20)
  • is_confirmed — BOOLEAN
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • completed_at — TIMESTAMP

user_connections

  • connection_id — VARCHAR(36)
  • caregiver_id — VARCHAR(36) — NOT NULL
  • elderly_id — VARCHAR(36) — NOT NULL
  • status — VARCHAR(20)
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP

user_settings

  • setting_id — VARCHAR(36)
  • user_id — VARCHAR(36) — NOT NULL
  • auto_diary_enabled — BOOLEAN
  • push_notification_enabled — BOOLEAN
  • language_preference — VARCHAR(10)
  • updated_at — TIMESTAMP

users

  • user_id — VARCHAR(36)
  • email — VARCHAR(255) — NOT NULL
  • password_hash — VARCHAR(255)
  • name — VARCHAR(100) — NOT NULL
  • phone_number — VARCHAR(20)
  • birth_date — DATE
  • gender — VARCHAR(10)
  • role — VARCHAR(20) — NOT NULL
  • auth_provider — VARCHAR(20)
  • profile_image_url — VARCHAR(500)
  • is_active — BOOLEAN
  • is_verified — BOOLEAN
  • created_at — TIMESTAMP
  • updated_at — TIMESTAMP
  • last_login_at — TIMESTAMP
  • deleted_at — TIMESTAMP