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