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