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