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