ott

Tables (12)

content

  • content_id — varchar(100) — Primary key — NOT NULL
  • title — varchar(100)
  • summary — LONGTEXT
  • type — varchar(45) — 영화/드라마/예능/다큐/만화
  • age — varchar(45)
  • released — varchar(45)

content_cast

  • content_cast_id — varchar(100) — Primary key — NOT NULL
  • content_id — varchar(100) — NOT NULL
  • cast_id — varchar(100) — NOT NULL
  • cast_role — varchar(45) — (주연,조연,감독 등)

content_country

  • content_country_id — bigint — Primary key — NOT NULL
  • content_id — bigint — NOT NULL
  • country_id — int — NOT NULL

content_genre

  • content_genre_id — varchar(100) — Primary key — NOT NULL
  • content_id — varchar(100) — NOT NULL
  • genre_id — int — NOT NULL

content_series

  • content_series_id — varchar(100) — Primary key — NOT NULL
  • content_id — varchar(100) — NOT NULL
  • inner_series_id — varchar(100) — NOT NULL

inner_cast

  • cast_id — varchar(100) — Primary key — NOT NULL
  • cast_name — varchar(45) — 마동석, 봉준호 등
  • cast_birth_date — varchar(45)
  • cast_height — varchar(50 NULL, `cast_weight` varchar(50)
  • cast_nationality — varchar(100)
  • cast_image — varchar(255)
  • cast_agency — varchar(100)
  • cast_debut — varchar(100)
  • cast_debut_work — varchar(100)

inner_country

  • country_id — int — Primary key — NOT NULL — AI
  • country — varchar(45) — NOT NULL — 영화 제작 국가

inner_genre

  • genre_id — varchar(100) — Primary key — NOT NULL
  • genre — varchar(45)

inner_series

  • inner_series_id — varchar(100) — Primary key — NOT NULL
  • series_title — varchar(100) — 해당회차 소제목
  • series_summary — longtext — 회차당 줄거리
  • series_runtime — varchar(45)
  • series_episode — varchar(45) — 1,2,3...회차
  • series_img — varchar(255)

main_category

  • main_category_id — int — Primary key — NOT NULL
  • main_category — varchar(45) — 메인 카테고리 (About us , 랭킹, 신작, OTT, 자유게시판)

movie

  • movie_id — varchar(100) — Primary key — NOT NULL
  • content_id — varchar(100) — NOT NULL
  • movie_runtime — varchar(45)

platform

  • platform_id — varchar(100) — Primary key — NOT NULL
  • platform — varchar(45) — 넷플,카카오,티빙