왓챠 피디아
테이블 (7)
book
- book_id — VARCHAR(10) — 기본 키
- book_title — VARCHAR(50) — NOT NULL
- book_author — VARCHAR(30) — NOT NULL
- book_genre — VARCHAR(20) — NOT NULL
- book_page — VARCHAR(10) — NOT NULL
- book_rank — VARCHAR(40)
- book_img — VARCHAR(40) — NOT NULL
- book_detail — TEXT
- book_author_img — VARCHAR(40)
- book_index — TEXT
- book_publisher_introduction — TEXT
- book_aladin — BOOLEAN — NOT NULL
- book_yes24 — BOOLEAN — NOT NULL
- book_kyobo — BOOLEAN — NOT NULL
evaluation
- eval_contentsid — VARCHAR(10) — 기본 키 — NOT NULL
- eval_title — VARCHAR(100) — NOT NULL
- eval_date — DATE — NOT NULL
- eval_score — VARCHAR(10) — NOT NULL
- eval_comment — TEXT
- eval_memid — VARCHAR(60) — NOT NULL
member
- mem_id — VARCHAR(60) — 기본 키
- mem_pass — VARCHAR(15) — NOT NULL
- mem_join — DATE — NOT NULL
- mem_name — VARCHAR(20)
- mem_introduction — TEXT
movie
- movie_id — VARCHAR(10) — 기본 키
- movie_title — VARCHAR(100) — NOT NULL
- movie_direc — VARCHAR(60) — NOT NULL
- movie_time — VARCHAR(20) — NOT NULL
- movie_rating — VARCHAR(20) — NOT NULL
- movie_genre — VARCHAR(100) — NOT NULL
- movie_country — VARCHAR(20) — NOT NULL
- movie_year — INT — NOT NULL
- movie_orgname — VARCHAR(100)
- movie_audience — VARCHAR(20)
- movie_netflix — BOOLEAN — NOT NULL
- movie_watcha — BOOLEAN — NOT NULL
- movie_disney — BOOLEAN — NOT NULL
- movie_tving — BOOLEAN — NOT NULL
- movie_wavve — BOOLEAN — NOT NULL
- movie_couplay — BOOLEAN — NOT NULL
series
- series_id — VARCHAR(10) — 기본 키
- series_title — VARCHAR(100) — NOT NULL
- series_direc — VARCHAR(60) — NOT NULL
- series_episode — VARCHAR(20) — NOT NULL
- series_rating — VARCHAR(20) — NOT NULL
- series_genre — VARCHAR(100) — NOT NULL
- series_country — VARCHAR(20) — NOT NULL
- series_year — INT — NOT NULL
- series_broadcast — VARCHAR(20) — NOT NULL
- series_orgname — VARCHAR(100)
- series_netflix — BOOLEAN — NOT NULL
- series_watcha — BOOLEAN — NOT NULL
- series_disney — BOOLEAN — NOT NULL
- series_tving — BOOLEAN — NOT NULL
- series_wavve — BOOLEAN — NOT NULL
- series_couplay — BOOLEAN — NOT NULL
webtoon
- webtoon_id — VARCHAR(10) — 기본 키
- webtoon_title — VARCHAR(100) — NOT NULL
- webtoon_writer — VARCHAR(20) — NOT NULL
- webtoon_painter — VARCHAR(20) — NOT NULL
- webtoon_orgwriter — VARCHAR(20)
- webtoon_dramatize — VARCHAR(20)
- webtoon_serial — VARCHAR(10) — NOT NULL
- webtoon_start — DATE — NOT NULL
- webtoon_end — DATE
- webtoon_orgtitle — VARCHAR(100)
- webtoon_genre — VARCHAR(100) — NOT NULL
- webtoon_introduce — TEXT
- webtoon_kakao — BOOLEAN — NOT NULL
- webtoon_kakaopage — BOOLEAN — NOT NULL
- webtoon_naver — BOOLEAN — NOT NULL
- webtoon_bomtoon — BOOLEAN — NOT NULL
- webtoon_ridi — BOOLEAN — NOT NULL
- webtoon_watcha — BOOLEAN — NOT NULL