s

Tables (5)

TTS

  • id — INT — NOT NULL
  • chatbubble_id — INT — Foreign key → chatBubble.id — NOT NULL
  • audio_url — VARCHAR(500) — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL

character

  • id — INT — NOT NULL
  • name — VARCHAR(20) — NOT NULL
  • prompt — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL

chat

  • id — INT — NOT NULL
  • character_id — INT — Foreign key → character.id — NOT NULL
  • name — VARCHAR(45) — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL

chatBubble

  • id — INT — NOT NULL
  • chat_id — INT — Foreign key → chat.id — NOT NULL
  • writer — BOOLEAN — NOT NULL
  • category — BOOLEAN — NOT NULL
  • content — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL

image

  • id — INT — NOT NULL
  • chatbubble_id — INT — Foreign key → chatBubble.id — NOT NULL
  • image_url — VARCHAR(500)
  • content — TEXT — NOT NULL
  • created_at — DATETIME — NOT NULL
  • updated_at — DATETIME — NOT NULL
  • is_deleted — BOOLEAN — NOT NULL