WebToon

테이블 (9)

Comment (comments)

  • id (Key) — Long — 기본 키 — NOT NULL
  • writer (FK) — Long — 외래 키 → 회원.회원ID — NOT NULL
  • webtoon_chapter (FK2) — Long — 외래 키 → WebtoonChapter.id — NOT NULL
  • parent (FK3) — Comment — 외래 키 → Comment.id — NOT NULL
  • content (Field) — String
  • isDeleted (Field2) — Boolean
  • created_at (Field3) — timestamp
  • updated_at (Field4) — timestamp

InterestWebtoon (interest_webtoon)

  • id (Key) — Long — 기본 키 — NOT NULL
  • user_id (FK) — Long — 외래 키 → 회원.회원ID — NOT NULL
  • webtoon_id (FK2) — Long — 외래 키 → Webtoon.id — NOT NULL

Recommand (recommand)

  • id (Key) — Long — 기본 키 — NOT NULL
  • coment_id (FK) — Long — 외래 키 → Comment.id — NOT NULL
  • user_id (FK2) — Long — 외래 키 → 회원.회원ID — NOT NULL
  • recommand_type (Field) — Boolean

StarScore (starscore)

  • id (Key) — Long — 기본 키 — NOT NULL
  • user (FK) — Long — 외래 키 → 회원.회원ID — NOT NULL
  • webtoonchapter (FK2) — Long — 외래 키 → WebtoonChapter.id — NOT NULL
  • starscore (Field) — Long
  • created_at (Field2) — timestamp
  • updated_at (Field3) — timestamp

Webtoon (webtoons)

  • id (Key) — Long — 기본 키 — NOT NULL
  • author (FK) — Long — 외래 키 → 회원.회원ID — NOT NULL
  • hashtags (FK2) — Set<String> — 외래 키 → WebtoonHashtag.id — NOT NULL
  • webtoon_name (Field) — String
  • upload_day (Field2) — String
  • view_count (Field4) — Long
  • star_score (Field5) — Long
  • created_at (Field6) — timestamp
  • updated_at (Field7) — timestamp

WebtoonChapter (webtoon_chapters)

  • id (Key) — Long — 기본 키 — NOT NULL
  • webtoon_id (FK) — String — 외래 키 → Webtoon.id — NOT NULL
  • chapter_name (Field) — String
  • chapter_count (Field6) — Long
  • created_at (Field3) — timestamp
  • updated_at (Field4) — timestamp
  • webtoom_imgs (FK2) — List<String> — 외래 키 → WebtoonImg.id — NOT NULL

WebtoonHashtag (webtoon_hashtag)

  • id (Key) — Long — 기본 키 — NOT NULL
  • name (Field) — String

WebtoonImg (webtoon_imgs)

  • id (Key) — Long — 기본 키 — NOT NULL
  • img_url (Field) — String

회원 (users)

  • 회원ID (id) — bigint — 기본 키 — NOT NULL
  • 회원권한 (role) — enum — NOT NULL
  • 닉네임 (nickname) — varchar — NOT NULL
  • email (Field3) — String
  • password (Field4) — String
  • isDeleted (Field7) — Boolean
  • created_at (Field5) — timestamp
  • updated_at (Field6) — timestamp