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)