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