Gieoksaerok
Tables (4)
Conversations (대화STT)
- conversation_id (Key) — Primary key — NOT NULL
- transcript (Field)
- status (Field2)
- recorded_at (Field3)
- person_id (Key2) — Foreign key → People.person_id — NOT NULL
- user_id (Key3) — Foreign key → Users.user_id — NOT NULL
Memories (대화요약)
- recap (Field)
- memory_at (Field2)
- verified_at (Field3)
- conversation_id (Key2) — Foreign key → Conversations.conversation_id — NOT NULL
- person_id (Key3) — Foreign key → People.person_id — NOT NULL
- user_id (Key4) — Foreign key → Users.user_id — NOT NULL
People (관련인물)
- person_id (Key) — Primary key — NOT NULL
- name (Field2)
- relationship (Field3)
- face_descriptor (Field4)
- user_id (Key2) — Foreign key → Users.user_id — NOT NULL
Users (환자)
- user_id (Key) — Primary key — NOT NULL
- email (Field)
- name (Field2)
- password (Field3)