왓챠 피디아

테이블 (7)

Untitled

  • Field

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