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