KT-aivle-mini-proj05

Tables (8)

Untitled

    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