Toonight
Tables (6)
Favorites (보고싶어요)
- idx — int — Primary key — NOT NULL
- w_id (w-id) — int — Foreign key → Webtoon.w_id — NOT NULL
- u_id — int — Foreign key → User.u_id — NOT NULL
Liketo (좋아요)
- idx — int — Primary key — NOT NULL
- w_id (w-id) — int — Foreign key → Webtoon.w_id — NOT NULL
- u_id — int — Foreign key → User.u_id — NOT NULL
Reviews (태그(감정) 및 선호도)
- idx — Primary key — NOT NULL
- w_id (w-id) — int — Foreign key → Webtoon.w_id — NOT NULL
- u_id — int — Foreign key → User.u_id — NOT NULL
- rating — int — 별점
- tag1 — int — NOT NULL
- tag10 — int — NOT NULL
Subcribe (구독)
- idx — int — Primary key — NOT NULL
- w_id (w-id) — int — Foreign key → Webtoon.w_id — NOT NULL
- u_id — int — Foreign key → User.u_id — NOT NULL
User (사용자)
- u_id — int — Primary key — NOT NULL
- platform_type — varchar
- access_token — varchar
- email — varchar
- name — varchar
- password — varchar
Webtoon (웹툰)
- w_id — int — Primary key — NOT NULL
- w_title — varchar
- w_author — varchar
- intro — varchar — NOT NULL — 설명
- plamform — varchar
- main_link — varchar
- w_day — date
- gerne — varchar — NOT NULL
- image_link — varchar — NOT NULL