Webtoon

Tables (7)

AUTHOR (Untitled)

  • PK (author_id) — Long — Primary key — NOT NULL
  • 닉네임 (nick_name) — varchar
  • 이메일 (email) — varchar
  • 비밀번호 (password) — varchar

CARTOON (Untitled2)

  • PK (cartoon_id) — Long — Primary key — NOT NULL
  • 제목 (title) — varchar
  • 요일 (day_of_the_week) — varchar
  • 진행 상황 (progress) — varchar
  • 장르 (genre) — varchar
  • 별점 (rating) — Float
  • 좋아요 수 (likes) — Long
  • FK (author_id) — Long — Foreign key → AUTHOR.PK — NOT NULL

CARTOON_MEMBER (Untitled6)

  • PK (cartoon_member_id) — Long — Primary key — NOT NULL
  • 좋아요 누름 (thumbs_up) — boolean
  • FK (cartoon_id) — Long — Foreign key → CARTOON.PK — NOT NULL
  • PK (member_id) — Long — Foreign key → MEMBER.PK — NOT NULL

CONTENT (Untitled3)

  • PK (content_id) — Long — Primary key — NOT NULL
  • 부제 (sub_title) — varchar
  • 에피소드 (episode) — Long
  • 별점 (rating) — Float
  • 등록 날짜 (registration_date) — TIMESTAMP
  • FK (cartoon_id) — Long — Foreign key → CARTOON.PK — NOT NULL

CONTENT_IMG_INFO (Untitled4)

  • PK (content_img_info_id) — Long — Primary key — NOT NULL
  • 이미지 이름 (img_name) — varchar
  • FK (content_id) — Long — Foreign key → CONTENT.PK — NOT NULL

CONTENT_MEMBER (Untitled7)

  • PK (content_member_id) — Long — Primary key — NOT NULL
  • FK (content_id) — Long — Foreign key → CONTENT.PK — NOT NULL
  • FK (member_id) — Long — Foreign key → MEMBER.PK — NOT NULL

MEMBER (Untitled5)

  • PK (member_id) — Long — Primary key — NOT NULL
  • 닉네임 (nick_name) — varchar
  • 이메일 (email) — varchar
  • 비밀번호 (password) — varchar
  • 코인 (coin) — integer