NovelERD
Tables (5)
Comments (Untitled3)
- comment_id (Key) — Primary key — NOT NULL
- episode_id (Key2) — Foreign key → Episode.episode_id — NOT NULL
- novel_id (Key3) — Foreign key → Episode.novel_id — NOT NULL
- user_id (pk) — int — Foreign key → Episode.user_id — NOT NULL
- content (Field)
Episode (Untitled2)
- episode_id (Key2) — Primary key — NOT NULL
- novel_id (Key) — Foreign key → novel.novel_id — NOT NULL
- user_id (pk) — int — Foreign key → novel.user_id — NOT NULL
- episode_number (Field)
- title (Field2)
- content (Field3)
- view_count (Field4)
- created_at (Field5)
User (Untitled)
- user_id (pk) — int — Primary key — NOT NULL
- id (Field)
- password (Field2)
- name (Field3)
- email (Field4)
- premium (Field5) — boolean
- cash (Field6)
- role (Field7)
favorite (Untitled4)
- favorite_id (Key) — Primary key — NOT NULL
- novel_id (Key2) — Foreign key → novel.novel_id — NOT NULL
- user_id (pk) — int — Foreign key → novel.user_id — NOT NULL
novel (소설)
- novel_id (Key) — Primary key — NOT NULL
- user_id (pk) — int — Foreign key → User.user_id — NOT NULL
- title (Field)
- description (Field2)
- cover_image (Field3)
- gerne (Field4)
- status (Field5)