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) — 넷플,카카오,티빙