AI_Vtuber

Tables (4)

History (대화로그)

  • history_id — Primary key — NOT NULL
  • user_id — bigint — Foreign key → User.user_id — NOT NULL
  • 역할 (role) — enum — NOT NULL
  • 대화 (content) — text

LLM (LLM 데이터베이스)

  • llm_id — Primary key — NOT NULL
  • user_id — bigint — Foreign key → User.user_id — NOT NULL
  • 이름 (name) — varchar(255)
  • 나이 (age) — bigint
  • 성벌 (sex) — enum
  • 키 (height) — bigint
  • 몸무게 (weight) — bigint
  • 성격 (personality) — varchar(255)
  • 좋아하는 것 (favorite) — varchar(255)
  • 싫어하는 것 (hate) — varchar(255)

Setting (모델 설정)

  • setting_id — Primary key — NOT NULL
  • user_id — bigint — Foreign key → User.user_id — NOT NULL
  • LLM 모델 (llm_model) — varchar(255) — NOT NULL
  • STT 모델 (stt_model) — varchar(255) — NOT NULL
  • TTS 모델 (tts_model) — varchar(255) — NOT NULL

User (사용자)

  • user_id — bigint — Primary key — NOT NULL
  • 아이디 (identifier) — bigint — NOT NULL
  • 이름 (name) — bigint — NOT NULL