KT-aivle-mini-proj05
Tables (8)
auther_like
- auther_like_id — int — Primary key — NOT NULL
- user_id — int — Foreign key → user.user_id — NOT NULL
- created_at — datetime
- updated_at — datetime
book_info
- book_id — int — Primary key — NOT NULL
- user_id — int — Foreign key → user.user_id — NOT NULL
- title — text
- auther — text
- description — text
- category (Field4) — text
- cover — text
- created_at — datetime
- updated_at — datetime
comment
- comment_id — Primary key — NOT NULL
- episode_id — int — Foreign key → episode.episode_id — NOT NULL
- book_id — int — Foreign key → episode.book_id — NOT NULL
- user_id — int — Foreign key → user.user_id — NOT NULL
- user_id (user_id2) — int — Foreign key → episode.user_id — NOT NULL
- content — text
- created_at — datetime
- updated_at — datetime
episode (book_detail)
- episode_id — int — Primary key — NOT NULL
- book_id — int — Foreign key → book_info.book_id — NOT NULL
- user_id — int — Foreign key → book_info.user_id — NOT NULL
- episode_title — text
- view — int
- episode_index — int
- content — int
- tts_path — text
- created_at — datetime
- updated_at — datetime
like
- like_id — int — Primary key — NOT NULL
- user_id — int — Foreign key → user.user_id — NOT NULL
- book_id — int — Foreign key → book_info.book_id — NOT NULL
- user_id (user_id2) — int — Foreign key → book_info.user_id — NOT NULL
- created_at — datetime
- updated_at — datetime
token
- token_id — int — Primary key — NOT NULL
- user_id — int — Foreign key → user.user_id — NOT NULL
- token — text
user
- user_id — int — Primary key — NOT NULL
- email — text
- name — text
- address — text
- phone_number — text
- created_at — datetime
- updated_at — datetime
- Field