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