MZ
Tables (8)
character_info (캐릭터)
- id (PK) — INT — Primary key — NOT NULL
- name — VARCHAR(20)
- script (성격 스크립트) — VARCHAR(1000)
- deleted_at — DATETIME
- created_at — DATETIME
- updated_at — DATETIME
chat_episode (채팅방-상황)
- id — INT — Primary key — NOT NULL
- chat_room_id — INT — Foreign key → chat_room.id — NOT NULL
- episode_id — INT — Foreign key → episode.id — NOT NULL
chat_room (채팅방)
- id — INT — Primary key — NOT NULL
- user_id — INT — Foreign key → user.id — NOT NULL
- character_id — INT — Foreign key → character_info.id — NOT NULL
- result — VARCHAR(2000)
- deleted_at — DATETIME
- created_at — DATETIME
- updated_at — DATETIME
episode (상황)
- id — INT — Primary key — NOT NULL
- episode_time_id — INT — Foreign key → episode_time.id — NOT NULL
- content — VARCHAR(200)
- deleted_at — DATETIME
- created_at — DATETIME
- updated_at — DATETIME
episode_time (상황 시간)
- id — INT — Primary key — NOT NULL
- time — VARCHAR(200)
- deleted_at — DATETIME
- created_at — DATETIME
- updated_at — DATETIME
photo (사진)
- id — INT — Primary key — NOT NULL
- chat_room_id — INT — Foreign key → chat_room.id — NOT NULL
- image_url — VARCHAR(2048)
- deleted_at — DATETIME
- created_at — DATETIME
- updated_at — DATETIME
user (사용자)
- id — INT — Primary key — NOT NULL
- email — VARCHAR(20)
- password — VARCHAR(200)
- name — VARCHAR(5)
- deleted_at — DATETIME
- created_at — DATETIME
- updated_at — DATETIME
voice (음성)
- id — VARCHAR(200) — Primary key — NOT NULL
- character_id — INT — Foreign key → character_info.id — NOT NULL
- stability — INT
- similarity — INT
- style — INT
- user_speaker_boost — BOOLEAN