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)