4주차 Netflix API 개발

스프링부트 환경 구축

1. jdk 설치

sudo apt install default-jdk -y

2. 템플릿 다운 받기

• 미리 깃허브에 공유 받은 템플릿을 레포 생성해서 업로드함
• 해당 레포 링크를 복사해서 git clone 받기

git clone 'repo 주소'

3. nginx 서버 블록 설정 변경

• 설정하는 파일 에디터 열기

vim /etc/nginx/sites-available/default

• root /var/www/html 부분을 다음과 같이 수정

root /var/www/spring-boot

• 서버 재시작 해주기

sudo systemctl restart nginx

4. Intellij 설정

• Tools 탭 > Deployment > Configuration 들어가기
• '+' > SFTP > spring_edu로 만들어줌
• SSH Configuration 들어가기 > +
  • Host에는 ec2 퍼블릭 ip 주소
  • Username에는 ubuntu
  • key pair 에는 pem key 가져오기
• Root path 에는 /var/www/spring-boot
• ok 누르기
• Deployment에서 Browse Remote Host 누르기

5. 권한 변경해주기

• git 폴더 삭제

rm -rf .git

• 권한 변경해주기

chmod -R 777 spring-boot/

6. 빌드 해주기

./gradlew clean build

java -jar build/libs/demo-0.0.1-SNAPSHOT.jar

→ 이 과정에서 빌드가 너무 오래 걸려서 로컬에서 먼저 빌드를 해준 뒤 git에 push해서 그걸 clone함

7. 설정 변경해주기

• 설정 파일로 가기

vim /etc/nginx/sites-available/default

• 변경하기
  • try_files $uri $uri/ =404; 주석처리
  • 그 밑에 proxy_pass http://127.0.0.1:9000; 추가
• 서버 재시작

sudo systemctl restart nginx

8. 다시 빌드

./gradlew clean build

java -jar build/libs/demo-0.0.1-SNAPSHOT.jar

9. 포스트맨으로 테스트 -> 성공

GET suadev.shop/test/log

EC2 인스턴스 메모리 스왑 설정

※ 이렇게 해도 서버가 멈춘다면 인스턴스 중단 후 실행하기
1. dd 명령어로 swap 메모리 할당하기 → 2GB

sudo dd if=/dev/zero of=/swapfile bs=128M count=16

2. swap 파일에 대한 읽기 및 쓰기 권한 변경

sudo chmod 600 /swapfile

3. Linux swap 영역 설정

sudo mkswap /swapfile

4. swap 공간에 swap 파일을 추가 → swap 파일 즉시 사용할 수 있게

sudo swapon /swapfile

5. 잘 적용 됐는지 확인

sudo swapon -s

6. /etc/fstab 파일을 편집하여 부팅 시 swap 파일을 활성화

sudo vi /etc/fstab

• 다음 줄 추가하고 저장

/swapfile swap swap defaults 0 0

7. 적용 확인

free -m

---

최종 SQL 스크립트

-- MySQL Workbench Forward Engineering

SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0;
SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0;
SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='ONLY_FULL_GROUP_BY,STRICT_TRANS_TABLES,NO_ZERO_IN_DATE,NO_ZERO_DATE,ERROR_FOR_DIVISION_BY_ZERO,NO_ENGINE_SUBSTITUTION';

-- -----------------------------------------------------
-- Schema mydb
-- -----------------------------------------------------
-- -----------------------------------------------------
-- Schema test
-- -----------------------------------------------------
DROP SCHEMA IF EXISTS `test` ;

-- -----------------------------------------------------
-- Schema test
-- -----------------------------------------------------
CREATE SCHEMA IF NOT EXISTS `test` DEFAULT CHARACTER SET utf8 ;
USE `test` ;

-- -----------------------------------------------------
-- Table `test`.`Actor`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `test`.`Actor` ;

CREATE TABLE IF NOT EXISTS `test`.`Actor` (
  `actorIdx` BIGINT NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(45) NULL DEFAULT NULL,
  PRIMARY KEY (`actorIdx`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb3;


-- -----------------------------------------------------
-- Table `test`.`Content`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `test`.`Content` ;

CREATE TABLE IF NOT EXISTS `test`.`Content` (
  `contentIdx` BIGINT NOT NULL AUTO_INCREMENT,
  `label` VARCHAR(45) NULL DEFAULT NULL,
  `info` VARCHAR(100) NULL DEFAULT NULL,
  `canDownload` INT NULL DEFAULT '0',
  `age` INT NULL DEFAULT NULL,
  `playtime` TIME NULL DEFAULT NULL,
  `previewUrl` TEXT NULL DEFAULT NULL,
  `title` VARCHAR(45) NOT NULL,
  `releasedAt` VARCHAR(4) NULL DEFAULT NULL,
  `quality` VARCHAR(10) NULL DEFAULT 'HD',
  `videoUrl` TEXT NULL DEFAULT NULL,
  `thumbnail` TEXT NULL DEFAULT NULL,
  `createdAt` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP,
  `updatedAt` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP,
  `status` VARCHAR(10) NULL DEFAULT 'ACTIVE',
  PRIMARY KEY (`contentIdx`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb3;


-- -----------------------------------------------------
-- Table `test`.`LanguagePack`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `test`.`LanguagePack` ;

CREATE TABLE IF NOT EXISTS `test`.`LanguagePack` (
  `languagePackIdx` BIGINT NOT NULL AUTO_INCREMENT,
  `nation` VARCHAR(45) NULL DEFAULT NULL,
  PRIMARY KEY (`languagePackIdx`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb3;


-- -----------------------------------------------------
-- Table `test`.`PresentLang`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `test`.`PresentLang` ;

CREATE TABLE IF NOT EXISTS `test`.`PresentLang` (
  `presentLangIdx` BIGINT NOT NULL AUTO_INCREMENT,
  `languagePackIdx` BIGINT NOT NULL,
  PRIMARY KEY (`presentLangIdx`),
  INDEX `fk_PresentLang_LanguagePack1_idx` (`languagePackIdx` ASC) VISIBLE,
  CONSTRAINT `fk_PresentLang_LanguagePack1`
    FOREIGN KEY (`languagePackIdx`)
    REFERENCES `test`.`LanguagePack` (`languagePackIdx`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb3;


-- -----------------------------------------------------
-- Table `test`.`Card`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `test`.`Card` ;

CREATE TABLE IF NOT EXISTS `test`.`Card` (
  `cardIdx` BIGINT NOT NULL AUTO_INCREMENT,
  `cardNumber` VARCHAR(45) NULL DEFAULT NULL,
  `name` VARCHAR(45) NULL DEFAULT NULL,
  `yymm` VARCHAR(4) NULL DEFAULT NULL,
  `birthYear` VARCHAR(4) NULL DEFAULT NULL,
  `birthMonth` VARCHAR(2) NULL DEFAULT NULL,
  `birthDay` VARCHAR(2) NULL DEFAULT NULL,
  `phone` VARCHAR(20) NULL DEFAULT NULL,
  PRIMARY KEY (`cardIdx`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb3;


-- -----------------------------------------------------
-- Table `test`.`Membership`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `test`.`Membership` ;

CREATE TABLE IF NOT EXISTS `test`.`Membership` (
  `membershipIdx` BIGINT NOT NULL AUTO_INCREMENT,
  `status` VARCHAR(10) NULL DEFAULT NULL,
  `type` VARCHAR(45) NULL DEFAULT NULL,
  `cost` INT NULL DEFAULT NULL,
  PRIMARY KEY (`membershipIdx`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb3;


-- -----------------------------------------------------
-- Table `test`.`User`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `test`.`User` ;

CREATE TABLE IF NOT EXISTS `test`.`User` (
  `userIdx` BIGINT NOT NULL AUTO_INCREMENT,
  `email` VARCHAR(45) NULL DEFAULT NULL,
  `password` TEXT NULL DEFAULT NULL,
  `status` VARCHAR(10) NULL DEFAULT 'ACTIVE',
  `createdAt` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP,
  `updatedAt` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP,
  `membershipIdx` BIGINT NOT NULL,
  `cardIdx` BIGINT NOT NULL,
  PRIMARY KEY (`userIdx`),
  INDEX `fk_user_Membership_idx` (`membershipIdx` ASC) VISIBLE,
  INDEX `fk_User_Card1_idx` (`cardIdx` ASC) VISIBLE,
  CONSTRAINT `fk_User_Card1`
    FOREIGN KEY (`cardIdx`)
    REFERENCES `test`.`Card` (`cardIdx`),
  CONSTRAINT `fk_user_Membership`
    FOREIGN KEY (`membershipIdx`)
    REFERENCES `test`.`Membership` (`membershipIdx`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb3;


-- -----------------------------------------------------
-- Table `test`.`Profile`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `test`.`Profile` ;

CREATE TABLE IF NOT EXISTS `test`.`Profile` (
  `profileIdx` BIGINT NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(45) NULL DEFAULT NULL,
  `image` TEXT NULL DEFAULT NULL,
  `password` VARCHAR(4) NULL DEFAULT NULL,
  `status` VARCHAR(10) NULL DEFAULT 'ACTIVE',
  `createdAt` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP,
  `updatedAt` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP,
  `isKids` INT NULL DEFAULT '0',
  `isNext` INT NULL DEFAULT '0',
  `isPreview` INT NULL DEFAULT '0',
  `userIdx` BIGINT NOT NULL,
  `presentLangIdx` BIGINT NOT NULL,
  PRIMARY KEY (`profileIdx`),
  INDEX `fk_profile_user1_idx` (`userIdx` ASC) VISIBLE,
  INDEX `fk_Profile_PresentLang1_idx` (`presentLangIdx` ASC) VISIBLE,
  CONSTRAINT `fk_Profile_PresentLang1`
    FOREIGN KEY (`presentLangIdx`)
    REFERENCES `test`.`PresentLang` (`presentLangIdx`),
  CONSTRAINT `fk_profile_user1`
    FOREIGN KEY (`userIdx`)
    REFERENCES `test`.`User` (`userIdx`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb3;


-- -----------------------------------------------------
-- Table `test`.`Alarm`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `test`.`Alarm` ;

CREATE TABLE IF NOT EXISTS `test`.`Alarm` (
  `alarmIdx` BIGINT NOT NULL AUTO_INCREMENT,
  `type` VARCHAR(45) NULL DEFAULT NULL,
  `profileIdx` BIGINT NOT NULL,
  `contentIdx` BIGINT NOT NULL,
  PRIMARY KEY (`alarmIdx`),
  INDEX `fk_Alarm_profile1_idx` (`profileIdx` ASC) VISIBLE,
  INDEX `fk_Alarm_content1_idx` (`contentIdx` ASC) VISIBLE,
  CONSTRAINT `fk_Alarm_content1`
    FOREIGN KEY (`contentIdx`)
    REFERENCES `test`.`Content` (`contentIdx`),
  CONSTRAINT `fk_Alarm_profile1`
    FOREIGN KEY (`profileIdx`)
    REFERENCES `test`.`Profile` (`profileIdx`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb3;


-- -----------------------------------------------------
-- Table `test`.`Category`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `test`.`Category` ;

CREATE TABLE IF NOT EXISTS `test`.`Category` (
  `categoryIdx` BIGINT NOT NULL AUTO_INCREMENT,
  `type` VARCHAR(45) NULL DEFAULT NULL,
  PRIMARY KEY (`categoryIdx`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb3;


-- -----------------------------------------------------
-- Table `test`.`ContentActor`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `test`.`ContentActor` ;

CREATE TABLE IF NOT EXISTS `test`.`ContentActor` (
  `contentActorIdx` BIGINT NOT NULL AUTO_INCREMENT,
  `actorIdx` BIGINT NOT NULL,
  `contentIdx` BIGINT NOT NULL,
  PRIMARY KEY (`contentActorIdx`),
  INDEX `fk_ContentActor_Actor1_idx` (`actorIdx` ASC) VISIBLE,
  INDEX `fk_ContentActor_content1_idx` (`contentIdx` ASC) VISIBLE,
  CONSTRAINT `fk_ContentActor_Actor1`
    FOREIGN KEY (`actorIdx`)
    REFERENCES `test`.`Actor` (`actorIdx`),
  CONSTRAINT `fk_ContentActor_content1`
    FOREIGN KEY (`contentIdx`)
    REFERENCES `test`.`Content` (`contentIdx`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb3;


-- -----------------------------------------------------
-- Table `test`.`Genre`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `test`.`Genre` ;

CREATE TABLE IF NOT EXISTS `test`.`Genre` (
  `genreIdx` BIGINT NOT NULL AUTO_INCREMENT,
  `type` VARCHAR(45) NULL DEFAULT NULL,
  PRIMARY KEY (`genreIdx`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb3;


-- -----------------------------------------------------
-- Table `test`.`ContentGenre`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `test`.`ContentGenre` ;

CREATE TABLE IF NOT EXISTS `test`.`ContentGenre` (
  `contentGenreIdx` BIGINT NOT NULL AUTO_INCREMENT,
  `contentIdx` BIGINT NOT NULL,
  `genreIdx` BIGINT NOT NULL,
  PRIMARY KEY (`contentGenreIdx`),
  INDEX `fk_ContentGenre_Content1_idx` (`contentIdx` ASC) VISIBLE,
  INDEX `fk_ContentGenre_Genre1_idx` (`genreIdx` ASC) VISIBLE,
  CONSTRAINT `fk_ContentGenre_Content1`
    FOREIGN KEY (`contentIdx`)
    REFERENCES `test`.`Content` (`contentIdx`),
  CONSTRAINT `fk_ContentGenre_Genre1`
    FOREIGN KEY (`genreIdx`)
    REFERENCES `test`.`Genre` (`genreIdx`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb3;


-- -----------------------------------------------------
-- Table `test`.`MainCategory`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `test`.`MainCategory` ;

CREATE TABLE IF NOT EXISTS `test`.`MainCategory` (
  `idx` BIGINT NOT NULL AUTO_INCREMENT,
  `categoryIdx` BIGINT NOT NULL,
  PRIMARY KEY (`idx`),
  INDEX `fk_MainCategory_Category1_idx` (`categoryIdx` ASC) VISIBLE,
  CONSTRAINT `fk_MainCategory_Category1`
    FOREIGN KEY (`categoryIdx`)
    REFERENCES `test`.`Category` (`categoryIdx`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb3;


-- -----------------------------------------------------
-- Table `test`.`ContentMainCategory`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `test`.`ContentMainCategory` ;

CREATE TABLE IF NOT EXISTS `test`.`ContentMainCategory` (
  `cMainCategoryIdx` BIGINT NOT NULL AUTO_INCREMENT,
  `mainCategoryIdx` BIGINT NOT NULL,
  `contentIdx` BIGINT NOT NULL,
  PRIMARY KEY (`cMainCategoryIdx`),
  INDEX `fk_ContentMainCategory_MainCategory1_idx` (`mainCategoryIdx` ASC) VISIBLE,
  INDEX `fk_ContentMainCategory_Content1_idx` (`contentIdx` ASC) VISIBLE,
  CONSTRAINT `fk_ContentMainCategory_Content1`
    FOREIGN KEY (`contentIdx`)
    REFERENCES `test`.`Content` (`contentIdx`),
  CONSTRAINT `fk_ContentMainCategory_MainCategory1`
    FOREIGN KEY (`mainCategoryIdx`)
    REFERENCES `test`.`MainCategory` (`idx`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb3;


-- -----------------------------------------------------
-- Table `test`.`MovieCategory`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `test`.`MovieCategory` ;

CREATE TABLE IF NOT EXISTS `test`.`MovieCategory` (
  `movieCategoryIdx` BIGINT NOT NULL AUTO_INCREMENT,
  `categoryIdx` BIGINT NOT NULL,
  PRIMARY KEY (`movieCategoryIdx`),
  INDEX `fk_MovieCategory_Category1_idx` (`categoryIdx` ASC) VISIBLE,
  CONSTRAINT `fk_MovieCategory_Category1`
    FOREIGN KEY (`categoryIdx`)
    REFERENCES `test`.`Category` (`categoryIdx`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb3;


-- -----------------------------------------------------
-- Table `test`.`ContentMovieCategory`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `test`.`ContentMovieCategory` ;

CREATE TABLE IF NOT EXISTS `test`.`ContentMovieCategory` (
  `cMovieCategoryIdx` BIGINT NOT NULL AUTO_INCREMENT,
  `movieCategoryIdx` BIGINT NOT NULL,
  `contentIdx` BIGINT NOT NULL,
  PRIMARY KEY (`cMovieCategoryIdx`),
  INDEX `fk_ContentMovieCategory_MovieCategory1_idx` (`movieCategoryIdx` ASC) VISIBLE,
  INDEX `fk_ContentMovieCategory_Content1_idx` (`contentIdx` ASC) VISIBLE,
  CONSTRAINT `fk_ContentMovieCategory_Content1`
    FOREIGN KEY (`contentIdx`)
    REFERENCES `test`.`Content` (`contentIdx`),
  CONSTRAINT `fk_ContentMovieCategory_MovieCategory1`
    FOREIGN KEY (`movieCategoryIdx`)
    REFERENCES `test`.`MovieCategory` (`movieCategoryIdx`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb3;


-- -----------------------------------------------------
-- Table `test`.`Producer`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `test`.`Producer` ;

CREATE TABLE IF NOT EXISTS `test`.`Producer` (
  `producerIdx` BIGINT NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(45) NULL DEFAULT NULL,
  PRIMARY KEY (`producerIdx`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb3;


-- -----------------------------------------------------
-- Table `test`.`ContentProducer`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `test`.`ContentProducer` ;

CREATE TABLE IF NOT EXISTS `test`.`ContentProducer` (
  `contentProducerIdx` BIGINT NOT NULL AUTO_INCREMENT,
  `producerIdx` BIGINT NOT NULL,
  `contentIdx` BIGINT NOT NULL,
  PRIMARY KEY (`contentProducerIdx`),
  INDEX `fk_ContentProducer_Producer1_idx` (`producerIdx` ASC) VISIBLE,
  INDEX `fk_ContentProducer_content1_idx` (`contentIdx` ASC) VISIBLE,
  CONSTRAINT `fk_ContentProducer_content1`
    FOREIGN KEY (`contentIdx`)
    REFERENCES `test`.`Content` (`contentIdx`),
  CONSTRAINT `fk_ContentProducer_Producer1`
    FOREIGN KEY (`producerIdx`)
    REFERENCES `test`.`Producer` (`producerIdx`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb3;


-- -----------------------------------------------------
-- Table `test`.`SeriesCategory`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `test`.`SeriesCategory` ;

CREATE TABLE IF NOT EXISTS `test`.`SeriesCategory` (
  `seriesCategoryIdx` BIGINT NOT NULL AUTO_INCREMENT,
  `categoryIdx` BIGINT NOT NULL,
  PRIMARY KEY (`seriesCategoryIdx`),
  INDEX `fk_SeriesCategory_Category1_idx` (`categoryIdx` ASC) VISIBLE,
  CONSTRAINT `fk_SeriesCategory_Category1`
    FOREIGN KEY (`categoryIdx`)
    REFERENCES `test`.`Category` (`categoryIdx`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb3;


-- -----------------------------------------------------
-- Table `test`.`ContentSeriesCategory`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `test`.`ContentSeriesCategory` ;

CREATE TABLE IF NOT EXISTS `test`.`ContentSeriesCategory` (
  `cSeriesCategoryIdx` BIGINT NOT NULL AUTO_INCREMENT,
  `seriesCategoryIdx` BIGINT NOT NULL,
  `contentIdx` BIGINT NOT NULL,
  PRIMARY KEY (`cSeriesCategoryIdx`),
  INDEX `fk_ContentSeriesCategory_SeriesCategory1_idx` (`seriesCategoryIdx` ASC) VISIBLE,
  INDEX `fk_ContentSeriesCategory_Content1_idx` (`contentIdx` ASC) VISIBLE,
  CONSTRAINT `fk_ContentSeriesCategory_Content1`
    FOREIGN KEY (`contentIdx`)
    REFERENCES `test`.`Content` (`contentIdx`),
  CONSTRAINT `fk_ContentSeriesCategory_SeriesCategory1`
    FOREIGN KEY (`seriesCategoryIdx`)
    REFERENCES `test`.`SeriesCategory` (`seriesCategoryIdx`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb3;


-- -----------------------------------------------------
-- Table `test`.`VideoGrade`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `test`.`VideoGrade` ;

CREATE TABLE IF NOT EXISTS `test`.`VideoGrade` (
  `videoGradeIdx` BIGINT NOT NULL AUTO_INCREMENT,
  `category` VARCHAR(45) NULL DEFAULT NULL,
  PRIMARY KEY (`videoGradeIdx`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb3;


-- -----------------------------------------------------
-- Table `test`.`ContentVideoGrade`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `test`.`ContentVideoGrade` ;

CREATE TABLE IF NOT EXISTS `test`.`ContentVideoGrade` (
  `idx` BIGINT NOT NULL AUTO_INCREMENT,
  `contentIdx` BIGINT NOT NULL,
  `videoGradeIdx` BIGINT NOT NULL,
  PRIMARY KEY (`idx`),
  INDEX `fk_ContentVideoGrade_content1_idx` (`contentIdx` ASC) VISIBLE,
  INDEX `fk_ContentVideoGrade_VideoGrade1_idx` (`videoGradeIdx` ASC) VISIBLE,
  CONSTRAINT `fk_ContentVideoGrade_content1`
    FOREIGN KEY (`contentIdx`)
    REFERENCES `test`.`Content` (`contentIdx`),
  CONSTRAINT `fk_ContentVideoGrade_VideoGrade1`
    FOREIGN KEY (`videoGradeIdx`)
    REFERENCES `test`.`VideoGrade` (`videoGradeIdx`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb3;


-- -----------------------------------------------------
-- Table `test`.`Writer`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `test`.`Writer` ;

CREATE TABLE IF NOT EXISTS `test`.`Writer` (
  `writerIdx` BIGINT NOT NULL AUTO_INCREMENT,
  `name` VARCHAR(45) NULL DEFAULT NULL,
  PRIMARY KEY (`writerIdx`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb3;


-- -----------------------------------------------------
-- Table `test`.`ContentWriter`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `test`.`ContentWriter` ;

CREATE TABLE IF NOT EXISTS `test`.`ContentWriter` (
  `contentWriterIdx` BIGINT NOT NULL AUTO_INCREMENT,
  `writerIdx` BIGINT NOT NULL,
  `contentIdx` BIGINT NOT NULL,
  PRIMARY KEY (`contentWriterIdx`),
  INDEX `fk_ContentWriter_Writer1_idx` (`writerIdx` ASC) VISIBLE,
  INDEX `fk_ContentWriter_Content1_idx` (`contentIdx` ASC) VISIBLE,
  CONSTRAINT `fk_ContentWriter_Writer1`
    FOREIGN KEY (`writerIdx`)
    REFERENCES `test`.`Writer` (`writerIdx`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION,
  CONSTRAINT `fk_ContentWriter_Content1`
    FOREIGN KEY (`contentIdx`)
    REFERENCES `test`.`Content` (`contentIdx`)
    ON DELETE NO ACTION
    ON UPDATE NO ACTION)
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb3;


-- -----------------------------------------------------
-- Table `test`.`Credit`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `test`.`Credit` ;

CREATE TABLE IF NOT EXISTS `test`.`Credit` (
  `creditIdx` BIGINT NOT NULL AUTO_INCREMENT,
  `createdAt` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP,
  `updatedAt` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP,
  `cost` INT NULL DEFAULT NULL,
  `unit` VARCHAR(10) NULL DEFAULT NULL,
  `tax` INT NULL DEFAULT NULL,
  `userIdx` BIGINT NOT NULL,
  `cardIdx` BIGINT NOT NULL,
  `info` VARCHAR(45) NULL DEFAULT NULL,
  `period` VARCHAR(45) NULL DEFAULT NULL,
  PRIMARY KEY (`creditIdx`),
  INDEX `fk_Credit_user_idx` (`userIdx` ASC) VISIBLE,
  INDEX `fk_Credit_Card1_idx` (`cardIdx` ASC) VISIBLE,
  CONSTRAINT `fk_Credit_Card1`
    FOREIGN KEY (`cardIdx`)
    REFERENCES `test`.`Card` (`cardIdx`),
  CONSTRAINT `fk_Credit_user`
    FOREIGN KEY (`userIdx`)
    REFERENCES `test`.`User` (`userIdx`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb3;


-- -----------------------------------------------------
-- Table `test`.`DetailContent`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `test`.`DetailContent` ;

CREATE TABLE IF NOT EXISTS `test`.`DetailContent` (
  `dtContentIdx` BIGINT NOT NULL AUTO_INCREMENT,
  `season` VARCHAR(45) NULL DEFAULT NULL,
  `episode` INT NOT NULL,
  `playtime` TIME NULL DEFAULT NULL,
  `title` VARCHAR(45) NOT NULL,
  `info` VARCHAR(100) NULL DEFAULT NULL,
  `canDownload` INT NULL DEFAULT '0',
  `status` VARCHAR(10) NULL DEFAULT 'ACTIVE',
  `createdAt` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP,
  `updatedAt` TIMESTAMP NULL DEFAULT CURRENT_TIMESTAMP,
  `quality` VARCHAR(10) NULL DEFAULT 'HD',
  `videoUrl` TEXT NULL DEFAULT NULL,
  `contentIdx` BIGINT NOT NULL,
  PRIMARY KEY (`dtContentIdx`),
  INDEX `fk_detailcontent_content1_idx` (`contentIdx` ASC) VISIBLE,
  CONSTRAINT `fk_detailcontent_content1`
    FOREIGN KEY (`contentIdx`)
    REFERENCES `test`.`Content` (`contentIdx`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb3;


-- -----------------------------------------------------
-- Table `test`.`SettingLang`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `test`.`SettingLang` ;

CREATE TABLE IF NOT EXISTS `test`.`SettingLang` (
  `settingLangIdx` BIGINT NOT NULL AUTO_INCREMENT,
  `languagePackIdx` BIGINT NOT NULL,
  `profileIdx` BIGINT NOT NULL,
  PRIMARY KEY (`settingLangIdx`),
  INDEX `fk_SettingLang_LanguagePack1_idx` (`languagePackIdx` ASC) VISIBLE,
  INDEX `fk_SettingLang_profile1_idx` (`profileIdx` ASC) VISIBLE,
  CONSTRAINT `fk_SettingLang_LanguagePack1`
    FOREIGN KEY (`languagePackIdx`)
    REFERENCES `test`.`LanguagePack` (`languagePackIdx`),
  CONSTRAINT `fk_SettingLang_profile1`
    FOREIGN KEY (`profileIdx`)
    REFERENCES `test`.`Profile` (`profileIdx`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb3;


-- -----------------------------------------------------
-- Table `test`.`Dubbing`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `test`.`Dubbing` ;

CREATE TABLE IF NOT EXISTS `test`.`Dubbing` (
  `dubbingIdx` BIGINT NOT NULL AUTO_INCREMENT,
  `settingLangIdx` BIGINT NOT NULL,
  `contentIdx` BIGINT NOT NULL,
  PRIMARY KEY (`dubbingIdx`),
  INDEX `fk_Dubbing_SettingLang1_idx` (`settingLangIdx` ASC) VISIBLE,
  INDEX `fk_Dubbing_content1_idx` (`contentIdx` ASC) VISIBLE,
  CONSTRAINT `fk_Dubbing_content1`
    FOREIGN KEY (`contentIdx`)
    REFERENCES `test`.`Content` (`contentIdx`),
  CONSTRAINT `fk_Dubbing_SettingLang1`
    FOREIGN KEY (`settingLangIdx`)
    REFERENCES `test`.`SettingLang` (`settingLangIdx`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb3;


-- -----------------------------------------------------
-- Table `test`.`Evaluate`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `test`.`Evaluate` ;

CREATE TABLE IF NOT EXISTS `test`.`Evaluate` (
  `evaluateIdx` BIGINT NOT NULL AUTO_INCREMENT,
  `likes` INT NULL DEFAULT NULL,
  `profileIdx` BIGINT NOT NULL,
  `contentIdx` BIGINT NOT NULL,
  PRIMARY KEY (`evaluateIdx`),
  INDEX `fk_Evaluate_profile1_idx` (`profileIdx` ASC) VISIBLE,
  INDEX `fk_Evaluate_content1_idx` (`contentIdx` ASC) VISIBLE,
  CONSTRAINT `fk_Evaluate_content1`
    FOREIGN KEY (`contentIdx`)
    REFERENCES `test`.`Content` (`contentIdx`),
  CONSTRAINT `fk_Evaluate_profile1`
    FOREIGN KEY (`profileIdx`)
    REFERENCES `test`.`Profile` (`profileIdx`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb3;


-- -----------------------------------------------------
-- Table `test`.`Feature`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `test`.`Feature` ;

CREATE TABLE IF NOT EXISTS `test`.`Feature` (
  `featureIdx` BIGINT NOT NULL AUTO_INCREMENT,
  `type` VARCHAR(45) NULL DEFAULT NULL,
  PRIMARY KEY (`featureIdx`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb3;


-- -----------------------------------------------------
-- Table `test`.`History`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `test`.`History` ;

CREATE TABLE IF NOT EXISTS `test`.`History` (
  `historyIdx` BIGINT NOT NULL AUTO_INCREMENT,
  `watchTime` TIME NULL DEFAULT NULL,
  `status` VARCHAR(10) NULL DEFAULT 'ACTIVE',
  `profileIdx` BIGINT NOT NULL,
  `contentIdx` BIGINT NOT NULL,
  PRIMARY KEY (`historyIdx`),
  INDEX `fk_history_profile1_idx` (`profileIdx` ASC) VISIBLE,
  INDEX `fk_history_content1_idx` (`contentIdx` ASC) VISIBLE,
  CONSTRAINT `fk_history_content1`
    FOREIGN KEY (`contentIdx`)
    REFERENCES `test`.`Content` (`contentIdx`),
  CONSTRAINT `fk_history_profile1`
    FOREIGN KEY (`profileIdx`)
    REFERENCES `test`.`Profile` (`profileIdx`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb3;


-- -----------------------------------------------------
-- Table `test`.`Hot`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `test`.`Hot` ;

CREATE TABLE IF NOT EXISTS `test`.`Hot` (
  `hotIdx` BIGINT NOT NULL AUTO_INCREMENT,
  `contentIdx` BIGINT NOT NULL,
  PRIMARY KEY (`hotIdx`),
  INDEX `fk_Hot_content1_idx` (`contentIdx` ASC) VISIBLE,
  CONSTRAINT `fk_Hot_content1`
    FOREIGN KEY (`contentIdx`)
    REFERENCES `test`.`Content` (`contentIdx`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb3;


-- -----------------------------------------------------
-- Table `test`.`LikeContent`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `test`.`LikeContent` ;

CREATE TABLE IF NOT EXISTS `test`.`LikeContent` (
  `likeContentIdx` BIGINT NOT NULL AUTO_INCREMENT,
  `contentIdx` BIGINT NOT NULL,
  `profileIdx` BIGINT NOT NULL,
  PRIMARY KEY (`likeContentIdx`),
  INDEX `fk_LikeContent_content1_idx` (`contentIdx` ASC) VISIBLE,
  INDEX `fk_LikeContent_profile1_idx` (`profileIdx` ASC) VISIBLE,
  CONSTRAINT `fk_LikeContent_content1`
    FOREIGN KEY (`contentIdx`)
    REFERENCES `test`.`Content` (`contentIdx`),
  CONSTRAINT `fk_LikeContent_profile1`
    FOREIGN KEY (`profileIdx`)
    REFERENCES `test`.`Profile` (`profileIdx`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb3;


-- -----------------------------------------------------
-- Table `test`.`MostSearch`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `test`.`MostSearch` ;

CREATE TABLE IF NOT EXISTS `test`.`MostSearch` (
  `mostSearchIdx` BIGINT NOT NULL AUTO_INCREMENT,
  `contentIdx` BIGINT NOT NULL,
  PRIMARY KEY (`mostSearchIdx`),
  INDEX `fk_MostSearch_content1_idx` (`contentIdx` ASC) VISIBLE,
  CONSTRAINT `fk_MostSearch_content1`
    FOREIGN KEY (`contentIdx`)
    REFERENCES `test`.`Content` (`contentIdx`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb3;


-- -----------------------------------------------------
-- Table `test`.`MovieFeature`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `test`.`MovieFeature` ;

CREATE TABLE IF NOT EXISTS `test`.`MovieFeature` (
  `movieFeatureIdx` BIGINT NOT NULL AUTO_INCREMENT,
  `contentIdx` BIGINT NOT NULL,
  `featureIdx` BIGINT NOT NULL,
  PRIMARY KEY (`movieFeatureIdx`),
  INDEX `fk_MovieFeature_Content1_idx` (`contentIdx` ASC) VISIBLE,
  INDEX `fk_MovieFeature_Feature1_idx` (`featureIdx` ASC) VISIBLE,
  CONSTRAINT `fk_MovieFeature_Content1`
    FOREIGN KEY (`contentIdx`)
    REFERENCES `test`.`Content` (`contentIdx`),
  CONSTRAINT `fk_MovieFeature_Feature1`
    FOREIGN KEY (`featureIdx`)
    REFERENCES `test`.`Feature` (`featureIdx`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb3;


-- -----------------------------------------------------
-- Table `test`.`NewHotFeature`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `test`.`NewHotFeature` ;

CREATE TABLE IF NOT EXISTS `test`.`NewHotFeature` (
  `nhFeatureIdx` BIGINT NOT NULL AUTO_INCREMENT,
  `featureIdx` BIGINT NOT NULL,
  `contentIdx` BIGINT NOT NULL,
  PRIMARY KEY (`nhFeatureIdx`),
  INDEX `fk_NewHotFeature_Feature1_idx` (`featureIdx` ASC) VISIBLE,
  INDEX `fk_NewHotFeature_Content1_idx` (`contentIdx` ASC) VISIBLE,
  CONSTRAINT `fk_NewHotFeature_Content1`
    FOREIGN KEY (`contentIdx`)
    REFERENCES `test`.`Content` (`contentIdx`),
  CONSTRAINT `fk_NewHotFeature_Feature1`
    FOREIGN KEY (`featureIdx`)
    REFERENCES `test`.`Feature` (`featureIdx`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb3;


-- -----------------------------------------------------
-- Table `test`.`News`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `test`.`News` ;

CREATE TABLE IF NOT EXISTS `test`.`News` (
  `newIdx` BIGINT NOT NULL AUTO_INCREMENT,
  `openDate` VARCHAR(45) NULL DEFAULT NULL,
  `contentIdx` BIGINT NOT NULL,
  PRIMARY KEY (`newIdx`),
  INDEX `fk_New_content1_idx` (`contentIdx` ASC) VISIBLE,
  CONSTRAINT `fk_New_content1`
    FOREIGN KEY (`contentIdx`)
    REFERENCES `test`.`Content` (`contentIdx`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb3;


-- -----------------------------------------------------
-- Table `test`.`Recommend`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `test`.`Recommend` ;

CREATE TABLE IF NOT EXISTS `test`.`Recommend` (
  `recommendIdx` BIGINT NOT NULL AUTO_INCREMENT,
  `type` VARCHAR(45) NULL DEFAULT NULL,
  `contentIdx` BIGINT NOT NULL,
  PRIMARY KEY (`recommendIdx`),
  INDEX `fk_recommend_content1_idx` (`contentIdx` ASC) VISIBLE,
  CONSTRAINT `fk_recommend_content1`
    FOREIGN KEY (`contentIdx`)
    REFERENCES `test`.`Content` (`contentIdx`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb3;


-- -----------------------------------------------------
-- Table `test`.`SaveContent`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `test`.`SaveContent` ;

CREATE TABLE IF NOT EXISTS `test`.`SaveContent` (
  `saveContentIdx` BIGINT NOT NULL AUTO_INCREMENT,
  `profileIdx` BIGINT NOT NULL,
  `contentIdx` BIGINT NOT NULL,
  `status` VARCHAR(10) NULL DEFAULT 'ACTIVE',
  PRIMARY KEY (`saveContentIdx`),
  INDEX `fk_SaveContent_profile1_idx` (`profileIdx` ASC) VISIBLE,
  INDEX `fk_SaveContent_content1_idx` (`contentIdx` ASC) VISIBLE,
  CONSTRAINT `fk_SaveContent_content1`
    FOREIGN KEY (`contentIdx`)
    REFERENCES `test`.`Content` (`contentIdx`),
  CONSTRAINT `fk_SaveContent_profile1`
    FOREIGN KEY (`profileIdx`)
    REFERENCES `test`.`Profile` (`profileIdx`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb3;


-- -----------------------------------------------------
-- Table `test`.`SeriesFeature`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `test`.`SeriesFeature` ;

CREATE TABLE IF NOT EXISTS `test`.`SeriesFeature` (
  `seriesFeatureIdx` BIGINT NOT NULL AUTO_INCREMENT,
  `contentIdx` BIGINT NOT NULL,
  `featureIdx` BIGINT NOT NULL,
  PRIMARY KEY (`seriesFeatureIdx`),
  INDEX `fk_SeriesFeature_Content1_idx` (`contentIdx` ASC) VISIBLE,
  INDEX `fk_SeriesFeature_Feature1_idx` (`featureIdx` ASC) VISIBLE,
  CONSTRAINT `fk_SeriesFeature_Content1`
    FOREIGN KEY (`contentIdx`)
    REFERENCES `test`.`Content` (`contentIdx`),
  CONSTRAINT `fk_SeriesFeature_Feature1`
    FOREIGN KEY (`featureIdx`)
    REFERENCES `test`.`Feature` (`featureIdx`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb3;


-- -----------------------------------------------------
-- Table `test`.`Subtitle`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `test`.`Subtitle` ;

CREATE TABLE IF NOT EXISTS `test`.`Subtitle` (
  `subtitleIdx` BIGINT NOT NULL AUTO_INCREMENT,
  `settingLangIdx` BIGINT NOT NULL,
  `contentIdx` BIGINT NOT NULL,
  PRIMARY KEY (`subtitleIdx`),
  INDEX `fk_Subtitle_SettingLang1_idx` (`settingLangIdx` ASC) VISIBLE,
  INDEX `fk_Subtitle_content1_idx` (`contentIdx` ASC) VISIBLE,
  CONSTRAINT `fk_Subtitle_content1`
    FOREIGN KEY (`contentIdx`)
    REFERENCES `test`.`Content` (`contentIdx`),
  CONSTRAINT `fk_Subtitle_SettingLang1`
    FOREIGN KEY (`settingLangIdx`)
    REFERENCES `test`.`SettingLang` (`settingLangIdx`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb3;


-- -----------------------------------------------------
-- Table `test`.`Top10Movie`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `test`.`Top10Movie` ;

CREATE TABLE IF NOT EXISTS `test`.`Top10Movie` (
  `top10MovieIdx` BIGINT NOT NULL AUTO_INCREMENT,
  `ranking` INT NULL DEFAULT NULL,
  `contentIdx` BIGINT NOT NULL,
  PRIMARY KEY (`top10MovieIdx`),
  INDEX `fk_Top10Movie_Content1_idx` (`contentIdx` ASC) VISIBLE,
  CONSTRAINT `fk_Top10Movie_Content1`
    FOREIGN KEY (`contentIdx`)
    REFERENCES `test`.`Content` (`contentIdx`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb3;


-- -----------------------------------------------------
-- Table `test`.`Top10Series`
-- -----------------------------------------------------
DROP TABLE IF EXISTS `test`.`Top10Series` ;

CREATE TABLE IF NOT EXISTS `test`.`Top10Series` (
  `top10SeriesIdx` BIGINT NOT NULL AUTO_INCREMENT,
  `contentIdx` BIGINT NOT NULL,
  `ranking` INT NULL DEFAULT NULL,
  PRIMARY KEY (`top10SeriesIdx`),
  INDEX `fk_Top10_content1_idx` (`contentIdx` ASC) VISIBLE,
  CONSTRAINT `fk_Top10_content1`
    FOREIGN KEY (`contentIdx`)
    REFERENCES `test`.`Content` (`contentIdx`))
ENGINE = InnoDB
DEFAULT CHARACTER SET = utf8mb3;


SET SQL_MODE=@OLD_SQL_MODE;
SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS;
SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS;

ERD Diagram

더미데이터 추가 삽입

1. Membership 테이블

insert into Membership(type, cost)
values ('Basic', 9500);

insert into Membership(type, cost)
values ('Standard', 12000);

insert into Membership(type, cost)
values ('Premium', 14500);

2. LanguagePack 테이블

insert into LanguagePack(nation)
values ('Dansk');

insert into LanguagePack(nation)
values ('English');

insert into LanguagePack(nation)
values ('Italiano');

insert into LanguagePack(nation)
values ('中文');

insert into LanguagePack(nation)
values ('日本語');

insert into LanguagePack(nation)
values ('한국어');

3. PresentLang 테이블

insert into PresentLang(languagePackIdx)
values (1);

insert into PresentLang(languagePackIdx)
values (2);

insert into PresentLang(languagePackIdx)
values (3);

insert into PresentLang(languagePackIdx)
values (4);

insert into PresentLang(languagePackIdx)
values (5);

insert into PresentLang(languagePackIdx)
values (6);

4. Content 테이블

insert into Content(label, info, canDownload, age, previewUrl, videoUrl, title, releasedAt, quality, thumbnail)
values ('시리즈', '천재적인 두뇌의 소유자 우영우. 대형 로펌의 신입 변호사이자 자폐 스펙트럼 장애를 가진 여성으로서 법정 안팎에서 다양한 난관을 헤쳐간다.', 1, 15, 'https://www.youtube.com/watch?v=5AXXoEvGrv4', 'https://www.youtube.com/watch?v=5AXXoEvGrv4', '이상한 변호사 우영우', '2022', 'HD',
'https://w.namu.la/s/31f67b04e8b6761effb26f1886877d9092342f963889c83822f0e0cfb5811d76d4c72d82042a05b9113971a82466b465c44759feac029af6c1887d463c130930785cd2d5513eb14e44bb590531b8e6f1f89c7c301a28ae2f8a88d787438586f2f6cc1aa9066c08827811fc2ca863c3d4')
, 
('시리즈', '초능력 탓에 인생이 피곤했던 사이키 쿠스오. 그래서 아예 초능력을 숨기고 살기로 했다. 평온한 인생도 그렇게 나쁘지 않은걸. 고등학교 가서 그 녀석들을 만나기 전까지는!', 1, 15, 'https://www.youtube.com/watch?v=87IkhpL1jVo', 'https://www.youtube.com/watch?v=87IkhpL1jVo', '사이키 쿠스오의 재난', '2018', 'HD',
'https://postfiles.pstatic.net/MjAyMTA0MTJfNDIg/MDAxNjE4MjA0MDM0Njkx.0wFGVYbfK5bdHRbHyItVjZoceZpRHcfeSA9spnxs4eAg.zeJejmcFxxF6em3sR6VXjGMJQtDT6_rDkeALQrfWpZkg.JPEG.everever0305/IMG_7774.JPG?type=w966')
, ('시리즈', '불사신 다쓰로 불리며 어둠의 세계에서 숱한 전설을 남기고 홀연히 사라졌던 야쿠자. 이 남자가 하드보일드 전업주부로 다시 돌아왔다.', 1, 18, 'https://www.netflix.com/kr/title/81261669', 'https://www.netflix.com/kr/title/81261669', '극주부도', '2021', 'HD',
'https://mblogthumb-phinf.pstatic.net/MjAyMTA0MTFfMTc2/MDAxNjE4MTUwNjE1OTQx.HkIwqpRUy9Uk03MEg_OE7bSwcItDIYa5gZJ5Wr6jFgcg.Hg2ajNtR9QfQCTc5gtxCUc2qwMdxiPNIKvinoKEC9HQg.JPEG.hwana7696/%EB%8B%A4%EC%9A%B4%EB%A1%9C%EB%93%9C.jpeg%EF%BC%8D71.jpg?type=w800')
, ('시리즈', '영화배우 뺨치는 얼굴로 마피아의 일을 돌보는 남자. 유능한 변호사로, 신랄한 유머 감각까지 갖춘 여자.', 1, 15, 'https://www.netflix.com/kr/title/81365087', 'https://www.netflix.com/kr/title/81365087', '빈센조', '2021', 'HD',
'https://image.kmib.co.kr/online_image/2021/0203/611811110015496461_1.jpg')
, ('시리즈', '태생부터 잘못된 운명이었다. 명문가 장씨 중 유일하게 술법을 못쓴다는 이유로 집안의 약자이자 치부가 되었다. 이제, 잃어버린 능력을 되찾으려 한다.', 1, 15, 'https://www.netflix.com/kr/title/81517188', 'https://www.netflix.com/kr/title/81517188', '환혼', '2022', 'HD',
'https://img.hankyung.com/photo/202207/BF.30608992.1.jpg')
, ('시리즈', '90년대 뉴욕의 청춘, 어쩌면 오늘을 살아가는 우리 모두의 이야기!', 1, 15, 'https://namu.wiki/w/%ED%94%84%EB%A0%8C%EC%A6%88', 'https://namu.wiki/w/%ED%94%84%EB%A0%8C%EC%A6%88','프렌즈', '2003', 'HD', 
'https://img.huffingtonpost.com/asset/5e09bed1250000061198f5c7.jpeg?ops=scalefit_630_noupscale')
,('시리즈', '위장 잠입 수사를 하다가 교도소에 수감된 사법연수생. 교도소에서 살아남아 복수하기 위해 재소자들의 불법 도박판에 뛰어든다.', 1, 19, 'https://namu.wiki/w/%EC%9D%B8%EC%82%AC%EC%9D%B4%EB%8D%94(%EB%93%9C%EB%9D%BC%EB%A7%88)', 'https://namu.wiki/w/%EC%9D%B8%EC%82%AC%EC%9D%B4%EB%8D%94(%EB%93%9C%EB%9D%BC%EB%A7%88)', '인사이더', '2022', 'HD', 
'https://biz.chosun.com/resizer/bL26dhX6IrkaxdbfsrMxWmBw6yE=/616x0/smart/cloudfront-ap-northeast-1.images.arcpublishing.com/chosunbiz/7QJG7QA3KPHTOUTVBMARQO5Y3U.jpg')
, ('시리즈', '스파이, 암살자 그리고 초능력자. 각자 다른 사정이 있는 세 사람이 서로에게 정체를 숨기고 가상 가족을 결성한다.', 1, 15, 'https://www.youtube.com/watch?v=J0b74jDWXGA', 'https://www.youtube.com/watch?v=J0b74jDWXGA', 'SPYxFAMILY 스파이 패밀리', '2022', 'HD', 
'https://biz.chosun.com/resizer/bL26dhX6IrkaxdbfsrMxWmBw6yE=/616x0/smart/cloudfront-ap-northeast-1.images.arcpublishing.com/chosunbiz/7QJG7QA3KPHTOUTVBMARQO5Y3U.jpg')
, ('영화', '이름도 없다. 두려움도 없다. 망설임도 없다. CIA 훈련 이후 유령이자 그림자로 존재하게 된 남자.', 1, 15, 'https://namu.wiki/w/%EA%B7%B8%EB%A0%88%EC%9D%B4%20%EB%A7%A8',  'https://namu.wiki/w/%EA%B7%B8%EB%A0%88%EC%9D%B4%20%EB%A7%A8','그레이 맨', '2022', 'HD', 
'https://t1.daumcdn.net/movie/52af21829df3edeaa0e45335b646795bf3d14ddb');

insert into Content(label, info, canDownload, age, previewUrl, videoUrl, title, releasedAt, quality, thumbnail)
values ('영화', '수수께끼 같은 사건에 휘말린 전직 경찰의 이야기를 다룬 수사 스릴러.', 1, 18, 'https://www.netflix.com/kr/title/81259570', 'https://www.netflix.com/kr/title/81259570', '피파', '2022', 'HD', 
'https://occ.a.nflxso.net/dnm/api/v6/X194eJsgWBDE2aQbaNdmCXGUP-Y/AAAABXyUe5-JhinW6TFhqdpqQ-1grqVh_Dcv96xHm6wVjbd5iNe4E7j7rhi8abBXZqnQtch-D_dIbm8d6_a2PD4Gk-8MQmGtzsXt9jk_NYzk5-VB1ice5a3mCwMah3e0ozGt0LhW4w.jpg?r=ec2');

insert into Content(label, info, canDownload, age, previewUrl, videoUrl, title, releasedAt, quality, thumbnail)
values ('영화', '요하네스 로버츠가 연출한 2021년 액션 공포 영화.', 1, 18, 'https://namu.wiki/w/%EB%A0%88%EC%A7%80%EB%8D%98%ED%8A%B8%20%EC%9D%B4%EB%B8%94:%20%EB%9D%BC%EC%BF%A4%EC%8B%9C%ED%8B%B0', 'https://namu.wiki/w/%EB%A0%88%EC%A7%80%EB%8D%98%ED%8A%B8%20%EC%9D%B4%EB%B8%94:%20%EB%9D%BC%EC%BF%A4%EC%8B%9C%ED%8B%B0', '레지던트 이블: 라쿤 시티', '2021', 'HD', 
'data:image/jpeg;base64,/9j/4AAQSkZJRgABAQAAAQABAAD/2wCEAAkGBxMTEhUTExMWFRUXGR4ZGBgYGRoZIRkgHSAdHR0eGx4fHyggGBsmHxcXITEhJSkrLi4uHR8zODMtNygtLisBCgoKDg0OGxAQGy0iICYvLysvLTUtNS0vKy0tNS0tNS0tLS0tLS0tLS0tLS0tLS8tLS0tLS0tLS8tLS0tLS0tLf/AABEIAQ0AuwMBIgACEQEDEQH/xAAcAAACAgMBAQAAAAAAAAAAAAAEBQMGAAIHAQj/xABBEAACAQIEAwYDBgUCBAcBAAABAhEDIQAEEjEFQVEGEyJhcYEykbEHQlKhwfAUI2LR4ZLxFSRygjM0U6Ky0uJD/8QAGgEAAgMBAQAAAAAAAAAAAAAAAgMAAQQFBv/EAC4RAAICAgEDAgQGAgMAAAAAAAABAhEDIRIEMUFRcQUTImEygZGhseHR8SNSwf/aAAwDAQACEQMRAD8A4djBielS1AxuLkE8v8Y1dRaDvy6Yqy2mlZHg7JZTVefUQfrgMJaYt1xZOC8KaqsorMFvN/3yOBnKkaOmxfMlTGPB8rI0k7crn6XOPM4mhmUXjB1HI1FO0EdP8HEZVqj2EuxgeZ2GM03o9DgxpaWlQ97F8Zq05yqNl6aVXFRqlY6QpQq29wTCwBG8XEE46tWpZVqNXUVrwJnUrPIJ0EGLNqfSsCx2nHAuKHLJNOpU1tHiFO4Rukxfl0iDbDng32iKs0xTGWJAC1klyNKhELI7FX0xIWQASxEEnD4Qko7OL1U8M8rcH/s+icmrCmgcguFGogQCYvA5CeWJz0wJwzNrVpq6NqVhIbkw6jBLA+X7/Yw0wPuSYHqZRCpUqIO9hf1643FQTBscS4hQtpcMppOhFXVOyqNxBuBadz54lOUTSBAhQBuTEEFfzAOCTSFvLHun/GIQDrUJCqEULIYja4IIiOUiT9DiHiubRAodlAJ5/PaZiAfliPtNxkZWi1TTqbZV6na/QXGOP1eN53iFQuXVKMQoImSQeU8pN8VJ0rGY4cpJCr7QO0ZzmZJAinTstNjquOZAtc7RIxvl0enTR0QNqEPMnQJgubdbgjphXxHKtRrJTzSKhO1WnI94JMrG4jacTcRRqaM2oy3MNAhgD4eqmfnfacKjrbOzFxlFxx6+z9BBns1VZpJCgyNU3gRv1BkCIvbHmZ4cWpq7Kw1LKgi0CZkiItJAHKJxPw/I9/UVSRAILTMv1mPugLtI582GDO2vFTmKpUfBSLJTA533iNrRz2wbaezJxkm09orFMLBXyF+s74Xut8P62U8FWo5OpHVWGwGoMdt7GnHvhO1ARYzHpf0xcWZ80HSBTjyMSeuNdOCMpKpCsCDysek9ca1aYUgA6tjIxGFOJEpE7X5eh/cXxQW32QdwnJGodyFnbri2GtUUhFZkQRABKA+ZjfmL7YC4PkWIXkBGojzMHb3vizZinQEUx49m1EahB+KNIm3r19cZJztne6fCscUvPkU5bi1QAqIKzfc8zEE7YZcApvVrOKcCoyN3d9IDNCAzBIgOfbA6ZN6zU0UQLaV8IMc2IEQDEyeuJuAZk0c3SIvFQKf6gWCkYrlUot+pteNzxTiu9Mr9bsJmBV7tjSSPD4SWk/IfPC/tD2YqZQDUyteDp/e2+OjcQGcqVK9X+H7l0IGmqZBLXABWxIi8dRfCPO5bMVk15g0mpsdJVVKlDeCt95C/M9L6Zykns87DFGS0X37E+0JbJCk+olHZeUfi9vix1FDa/Pnt++V8fPfZU0qFJKD1dL1WDjSxQ6lib23lRpmDptjo32fqtAtSXMuae60n0xS8RJCs0sxYsZk8/KcFGSZeTA+PJb9TofPG2I0edrjriTBGM8OMxo58j1/fPEeYrBFLGYAmAJPsOuIWlZyX7aeKsHp0A0A23gH4d/LxEc9h54rHB6ebStTy4pqqyZYodQF/iOqIlSAdPPzwZ9oGap5iocwkqhKtLASJ8QsYAspuCfkTDrjudUUWrBqiHQdSIVp782ZuQuPDvPni2rQ6C4y33Of9teIV3EVlWUazKp+EW8TazvKx4R9ca5rx0aRPIFLf03HO/wAf7nBnH82KmUgayiyTJFQ3mCWFokgSYwsoGctSEliGPKLRzJ5z9fTGR9jq4I1l9bR5lJVwwsBrEqbyq65/9u/kemHXZDgSPTfM1H06G0jkbiCfnUp39cIqVJipncH0G/5bnHmX4y1Oi1EfC2vr97uj05GiPngkwssa+x52ty5TUQPC7LqJv41XxC951MxPnhHr1VJ6x+d5/PBfE8/UqINUbyQYuZY6vfXfzwFQckgeRH1H0/TDV2OdPeRGueyxDGee37/e2BZwfxDOlwFbdRA9JY363OANOCj2EZEuTomoSxNoPMj+39sOUyKmmWAF4UxBjz/PFfooSd4A59MWHhqMgPIsII3mevU/TCsjpGnpIOcuw0oZsoCEJumi0iBadt5g4KyeYFNhrQ1ApDEEkAT1jzn5YWUW0na/XB6U9QkKLty+nty9+uMyO1GLtRQ04vxAVIVVRVFzoMhjAubCTH5zhcjEEEGCCCD0IuD88b06RJCqJJMADnhZxPiL06iokKyEl9QUwbQGkGwiY3ufTAwxyySvsbOo6rD0mNJ7fp59y89qu0DlFan8NUo76hZSwiA0/HIb0wjz/EkWmAZUDxQxU/mCQfriq5/tJUhqQh6elApeHK6ABMkb8j6fMSnxNqjq1U6o+EGAo9AOeN+SFnlYZ0rSVen2GPaNC9Om7eEqsgR15Hz/AFJwT2b7a53KurrXdgLaG8QjpeYnywn43xDvCqLJVRJ8/wDGIMhSNRrmANz+/fBRjqhGTJ9TaO3dkftdSpV7vM0lpK5+NSYDW3BuAY+eOsUaqsoZSCpEggyCDzBx8sZLhyRJUNEW9+u4OLr9nnbqrk6gylUa8ub02kBkG77/ABgeJoF7EAEmxODiL5qXudzaZsR6fs4izkaGk6RBJNrDnvbEpe0gT6R/fFG7edqaaocrSqxWeA0KW0q1j7n6T5YGm+ysKFclydL19Dk/abNg02pFy5Usqk2lR4RMHaB0+uDeOccqfw9CnRgVsxQp1GLQFClD3j6j8JDKSes7Tis9oqrBqtEDSqhY6sTcEnlMTpG0e5R1+IVyKaltQpJoSYMKDMTvAJsMHGLjFRkN6nLjnmcsfbx4/P8AMMznG8xVpilVcFCw1ECCxHwlzuVFrbc4m+Gwq0zTSmjr8JmLESd7wSYHSNsVWvUJE2nn54ddjuFrUzMVQSiUy7Kdp2UHqJIMeWFZcaapDej6qcMltXeiy5DJh6VdSfuK48yGYAERtOm46nFWzKGnWai1mW3ym3ni40kp0HV1EKQQygQNJ+MAbbHUI5gYG7QcKU5kNAY16aFTIA1SBY+axfofLGeOlT8HXzXNqUV33/RVauW12OB1yeki/I29z8+WD1FpxqyTNtgfkBJxFJ9hU8MG+TWxTXCkmBMCTuPbEf8AEf0L8sEpl5VrAA2G+4g8z5j54G7t+h+WHqjmz5R36+gwymSCb3PLywcoxHRWYMzPn9MFBMZZy3s7ODGkvpWjFE4MoPopVHBbUGpzpgmNYuskQRYe++IEWMXzhfY+m3DauYNUAssgCLafPcHyGLwR5T+wXVvhib89l7/Yo+Q4r3rMr1u5VZgIp11A1j495ItC9eeJ892ayzjwFqf9UzvyKmJPyOFtILk5rOoaqSVUTITptuxANxIAi98BNUrVlLBlWbqpJLODItyHvGNTu9djhSVfjX1P9RdxXhzUajIDrCQSwBETtP4cTVTo8JABAlTA2PKd4BP1wRwjiD0HcPu1m1DVIG02M77zi0ZbhuWzIDECeoY/SZGD5V3ELE59mU3JZTWGCyahYKB1nb5mcXThvZ9VpRbV99iDcne0+2J+E9n0y2YGYRtYWfAWAuQQCDHImcM8nmV8eqxJmDyH6+uAeT0GRw1+MSVMqlKCzaQJk8vcRC7C+2B+MuKSkAgkrEr94G9jY9BysCNjiLj/ABQhGFpcFQOk8/bFey7MQFlmH3Vm/sJnmR74OMnJWxWSEYSqJ9H5ji60MjRRGgimockMpUBRJINwTaOoM7Y5fwTO0mermqjTrYsLyYFh8wB/vg77S+0B7gK9iUVNI5ECCD6XxQqec0qoiZAkD9MaOnittiuobSUV3AON8TevVNRjuQqL+FQbD15nznA9GGPIQCSflE+5HzwdmKYp0hUIIdpVZ2m4JHWN/liLJnRQYgS1Te14BkAdJIB87Ytwalt/cXyTWvYLzPDqYQlKoOnxARMwASfIX0gET7Xww7CZrxZpTdmCnV00lv8A7D5Yr2eQJK6gWBIYAixBG1/F6wLzExIM7KOQ1SLagBbCMj0aem1NMsOTzxqVUQ8lefZWP6YZ5bM66QpOTqoy9PqQfiiTEruBP0wq4VlYrB4J8L7b2RiYxEtQqA2ogiYLRNz+mOdKVSs9V0sOeJp+NhvEnDUIA0uyVKp84qrE/wDaCY8ziuUwy6lN50z8pj5kW8hgvOVgz+J9AIO8xBubdLmes4iq0FYK6VAxYAmxtO4M2PthnZWY5NPJxXdeASooNgD6Dc9YJtyx5/w2p91jHLxYPqAqLX5AbST+5PvgU5jT4dRMc5P98CpN9gpYYL8VnvaPstXyNQpUMoIl1uJIm177b/2jEPD6ok+InzMCfTHfO1PZ3vK60u6fMCsrFqnhDUFS6w8eKWNklZ5m2OU9t+wFShWXuCGRgYDWIKi4uIJnkfxKOYxqnBT7HJwZ3iptfcANUATgmjxRtGgMwU7rO+Ktm83VSabiGBg2IM/354ynmatMBmQ6biSDB29uYxlWCSWjsL4tBSXp7DHtFVBpKAblp/0j/wDeBhlO6zTUjIVTEb9DF+k8xjerUFXuhpbSW59J8UeWkYBq12eq1Rjd2JPvjVijxikcrrc3zM8p+tfpRP2lZe8XRa0bzzwFk82UMqSp98EV8qagZxJi0z77Re2FWCbUmzLKMoVLtfYuXC+PajpLFWPPUCp9iPyw2z3FFSnLsCwBgrb9faMc3nE4rMwCSSOQwPBB/PdbQTXzDVWLHfkOmLf9neTU1Klep/4dABrxGs2T5eJv+3zwm4dw3u6DVqlPWxsqGVAH42uJnYL79MRZLjtRVNIaRSf4kCqA3K8eKfOcG3XgVCNu2zO2HEe8rWYNTHwxPPeZ5zP5YhoVtVNm2IA5+t457YI4jwaED05enUJKHfQwA1U2PInYdfCeuFlNigZDYn59RthmKa7rsLzwlyqXc9rZsMF1mQi6UUc/M+v6YhqZx3KjnNhaPliAA7gYlytUK4YjaeZ3ixte2+KcmwVFIlzOsFyGJBJJ98E9na2l4POMB06L1NhvYnl6YacH4WRVUGpTkG66rn0kQTtYGcBJeRuN1JFvoVAi1KhNkpty51CKQ/8AnPscKDmVMyVj5fvn8sbdoc6Vy5KE6q1aLX8NEX/91RPkcVZa9QiFETz3MepvjJLFy2d7H8R+UuCVjeo2tWIuZGkxIAB5ddjfEXfGmqrIALfEbxt59IwT2c4MtZ6i5nOU8stOC2rxM03hALet7Ttyww4GqnPUk4czM1NnfXmFGmFBCNpAOymAAJJItywxY9UYp9X9SmlT7X29zMhwqtWqUqNNGDVSdD1dSqQBqJmJ08pAIJMDE/Evs24hTqui0jUUGzrpAbnIkzz546rwjsdmqrLXzDrTrFkarUEu9XQSQApASilxYCbQRIBxek4bSAHgDebXJ9Tg440jP1HVzyvvVBhUHzxVu23D+8QBQutyFRiYAcSyav6WGpD6ri1acL+NBDRcOutY+DYs33QD906og8jBtGGJ0zIcmT7O62cZqucpik8aQoIY73JAJUKBsAdUeZnHOOM03y9SrQWozqhancyBBhJ5ahAEAC4tjuL8UzFQGklbuatMrTrNpgOdPjNINMG4IYczF4xzReH5ZKWcpZhtdZINHxBjYnWZQ7sBphiOVpIk1ZGzn+VqMro4H/hkEeoM8vPfEnFmGrwxp3EdDcflh72h4NSp16zkd1l1comkly5AvYwYtJIiARzM4QZrOIDpSkqjmLOf9TAkeg/TFcaROVvY24I4WkNiSZYb/P2AthXxbhwDFqYhYkqTMb7Hp6+e8YIy5Sq4VD3ZKyDsNQ+6y7QYiRF8SqHDd1VEMySJ5gXH1JwjFH63b7nQ6rqYzwRjW49n/JW9Vo88N+ydHXnKA06h3ikg7QCCZ8oBnywBnKGhto8sPuxbor1XcGFpNcD4SYAJ8r6ffD4x+qmc2UvpsvnC+D061CvmapLk1tOiTAZQBqMbkgj97JO0nZqiKGukAlQSReNXl5nG3ZHiFWrkc7Qp1SlWnUGYAADF0MIwEzEEIdufnho/B0ZkNSp/MWmneBWnVIVjBFhJt0IwGV7s14FcKrZROz/FSoakw1Uag8S9CLhl/qH0OLBmMmpomgEQkMtQuv3i51UagY30kfyyJATWtrkiscTprQzdRQNKySB0DDl6T+WOldnsvROTOZCmuwRqZpKJlW8T8jt44JESg2xWN1L7MHKuUNvcf4OU5lip0MCrLYr0jl7YGdZk7xv5YtfaDgz1YqUVaqykI5UEmpImnVEfddRfowYE3GD+A9jaqIa+YhIEIsrAqSoRKpnwsxZYAki8lebndmaIJm+B1F7sABUWmoBNhMAuf+osW/YwhznDqyVZ7t95DBSQfMEWx05tH/DaRJZ3qABSDABVQWknkZIHW2AchxV+7akaNaVPisDZhIiCQdjzwGZuK0PwYlJ/UwBOHtmMzlUdCiKoNQKSGLVQzMNvCD3cAm0zMzA6h9m3DqcEjJnLIsrpqBSWcQCZuWHhLTMGdyBhJm+IKlZnWgz1Up0gsq7FABJU00GpmPeaY2Fj63fsjn0qqCaBy1TxVBSD65RtILnSNIJMeDdbWE4FRpJ0TJkbbSerFnb/ALM16lSnm8nTptXp6g6PA71COXIupAjURvvhf9m3Z9qNaq2YoxmGitWaVYJOpadJSCYIAZ25TouYt0ChXlZAaRIIYiQZFmgkcwd9sRcGRgjd4qrU1t3mkkhjPhaSAboUMfd+GTGLsUEZjOIgUmSGYKNKs9yJHwgwIEybYLxmMxRDXENaiCpU7H+8z84OJAf3vvjYnEIUjjnZrVWfMM5UCSqqCZGmRbSSG1E+EAkwPQcv0mjVzKUsq1We6bU62UpU7zWyk6gGBAjcDeIOPoM9LHr+4xU+0/AKXdM1GjTlnVqi6VVioFwthsYYg3PiHOMGpeGU0cQ45ls3xDOOFYEU6avBMhBYG25JbUedovEYrHHeCvl28RBBmCJ36XvN8Xfs5nq1HiGbNOgGNSg5KMxUwWVg1g3ilgAOh3EHEvaPhGadylRKZpkmYUEgxa5+A33HnfFZHTGYoco/c5lSaCDzB23n/GLbwepTZFeDrpWYtEaJXUNryF0jprO+KpVy7ISD903I5f2xYOAuDSqodIlIDHcbltr6bIfIxhUnTUgoJu4sT5+q3PxHr/ke2HPYTMw9enpnvaUBfNXRp9YDYU09VWyqWaCYUE2HP0wy7MUalPO0wabAkNIjk6MPl4hjQ9Ssz1apA3DeJPk80tekNifDydTZlPkQfoeWL1muM0iy1UrqlB0haQABUrupUKTInfUQbkWjFE4rliah8JhSq2FoAvHynEOQrQ5LiU26QYJEHrc+s4GatNDcE3FpmcZznfVmqbcgD0H688W7sVxqgSmWrKoQABWMhtRMk6piZNgbWHnhBWyFOqnehhTAUGDHjYxIEm256x+eA8hkyWty54RLtrRqxQbybVpnX/tR4y+Wy2UTKVe4Z2MFGhv5cQp5lCTc9QJkHFSbtpWrmkKNL+GKnVmKqkw7tAL6QfhAhouBO22BstnVzXd5asYedNGt+Fj4Ye90aw5X0nlIV8P4ZVUMSGlGIJAkAXuv4xAMrzG3TD+nnz0+5m6rF8p67eCz53iaV6FKsWIYKpIgCSDpPhHI+IjEvZbiSs1SnAp94QWdmMwviJKkeHSqRHnM8sVfiGWq92jotlJISLRALGm336ZkMRMgiSIuAs3xU1QF0d0sXAJ8XkATYemCywbdExZ0o2dT4DWermUqA06dQvIDFmJQmAPCCJCW3PKcWnhOUZ0q0q9HX35D1K9APQCuAhRPj73ktwTfUDG2OG8J4jVpurq0lbi0EEe8R8sds7C8cTMsyVS1OoxSoaZIILpB1JchQQqyvI9DBKpSadS/IvipRuH5lozQevSNTL1VD6SKbS2nVIBM3BFiNjBm++GHDaDLTGskubvLBrncagq6gNgYFgMEUaaqNKiAOQ87n8ziXEFmY1vjbGYhCB6KkhoEgQDFxO8fIfLEhx6Tjm/av7T1ymaqZRaal0RYLsUBZgDuQF0gf1CTYHpC1tpHQ3IMqT05xvPvyOBzSViQ1OQAFDGDIM26x1nrzxx7KfaZnA41hCoILrpZTB6S0i0xynrjqJ4nTZVqK9iAQdpEaus7E25YCE1K16GnqOknhUZSaafZrZXMp9nS0M4uao1mMawVIEwwi7R44gCDEQOkGk9peKVlzLK1MiTIE6WAMzq1WeP6TysTjqGY7V0aWVqZqprCJeACWgGIgkeI2sSCb2tjjHbntBT4jWOYyiujooVmYIJUhj4WMEG3wnmTeNmSXLuJxT4PRUeKrRFUgmJ+Izy52G5OF2VpszOtOYhhPMjcL6EgDBJra17nu1hGJ1AmSbgkzvP6Dpj3IVEpk6qasuxksPQggyCDzxPlugXnTltGmbyncwoYlmEtaw8h1vJ5csW3htFawQU2ZBK6juUuAJ21CbD8+p8zBpZyg9RFIrU0XWGK+MDd5AF9iTE3brabg7LlMs+YVC2or3MtDPoksVtMd4afkdJiIuEan9MrtGuN4ryQpxaap99/+oD4rkGDO1wqs5qN90BSRaeZBAG5uJxVe61Kpj45IHuQLe2Oq9s+Hav4bJFtKin31dxyRLuYFpZjt5jFR4dwkioKmmKdNZGrqDYHrsMPmtGbCk5qJpxzg5yYpDR4lA7yL+ICnVMyPwvp9hjfiAQZhyihUdy6gRZWBKi1ogjGvbbjDZivWIJCFtQE8wiIR6QB8sJ8hWJCmZ0jb9PljLM6eFqM6JctVKVlcGCpDYmzPaOo1VWiDBUsPvyW0seWoa4B9epGPcjR1PmP6aLsPbT898C8OVHq01jTUNUErptoHigEkwJH+cM6du9GLrV5r1LJwni616gyVRWXu3IpvTMEGZmJgVASTqBvsZ3CXPZvu2OkAIymCG1K5YgFkHwgQswoEMzi0aVr6ZxlfWGKsSWkWIJ6YJ4hXpvDJ4NRJNJQQqExJWTABhYA6RyE6vmHO4UeJmLXwTkeNVKLh6bwVIYGTYjpf8tsInflhnw7NICJUauvT2/XCJtNbHY7i9Oj6n7C8fXO5RK4gMbOASQG5xPz/vvixDHzv2U7TZnLsGp1CUtKE2P9sdx4B2go5qmGRxqjxJIlT0jC1IfkxNLkuw5xmPJx5IwQkRZHjVN6dNwCutQ+nYqHv4h+fOb+/NPtSehm1Ul0BokqdRA1awrSpj0EgwSSNziiVe1NSmvdq7tMmASDe3xbgWFrbDphDXzNaoWJZhJ2G5vPoGvyvvgLjKG9G75UsOf6Kkv1TT8MlzStQClKgNP7oYzBMzAFwLXZY3AvfBlHtfmCNKttGm5OwHhkR4SRMECOuGnZenSpZfOvURO8amnd94Ee5e7DVcWNzPMzyxVM7n2NTUAoIaQ6iNSiwmIkRFowUXcbQGePHJxlpXdLxfpZY87xCpVouuYqszOSyrMKltIhdrEsL335k4reezjIDTpnSh5Dl1E8ybSeeDuOayi1ApFMkDVKwTpBgdd5ta+F2aE9zTBB8IY+bPePlpEYZdxS8mfIoqcuPa3XseZai8FizKOkkT64KaghEK5J5SSRiWpkKvwOUTYEFgb+m5N9sFL2dqgakYaYmPF/bSD5SQfzw1VHTMr+raHP2XgVc0Kd1JVg3kFgnkeYUXgXGD+01AVeIrlcugZxEIbLTCxAXpYCSOQ1ROK52G4wtDNio0KKqmmWv4SxHiteNSgHybDfJ8dFHjjZmoraIZANOkse60rAMQWaL9WwHZ2Pi3xoO4uuco1qxzJNZXoVKZqKPhEKZjcoCIPPxX2wpTiDVcvWpJdkHeWvIgAj2gYn4v2lzOactq7tlDPSCkeEhrgW8asGAMi63Ii2K7xHiFSnXavQJRaikaVOymJQ9REH/bEbuIyLWOd+pCK0qSwvJiPP/bEHD6kAdCYxKtMJ4plCD7iLf2xpkIABIJHMdPO1/cYyvsbYt8kNeG1DqqkbshB/1LI+QxFRKivrJAK0ahuQPusF9yWjEi5hFpqykB2qFTeZUiQw8wZU/wDbznCHilJtWrlsP388DitTsb1bTwcV3vZDmY7wjlb6DGasRogPliSBya/PGo4xBUHlhpwfhorBgXVYUmSDYjYe5t+eFjxywVw92BsYAZSfK9j6A4CQ3HVqxvQq1KB0VFlTaRtflOJkqVFbWGYbRe+GbAMgV4usMRz5SPlPvhVncm5UNTJN7CR1Pzxlx509S/o7vVfDZxipYraq68r7a7nUewX2htSApZolkmA9yVn9PTFwzn2nZGm7Jr1QYkGx9MfP2UztVRpdGBuBqEXO0TY4SNBPiVtXPljSq8HFmmn9S2WLLsGVlFMrFto+W3XEmUohZMRtb8v7Y2oNJLS0fhgQOW8X+eB88sHV4hBsFPxTHxdLzjB3dHq2lCCyPde366GeSzVMn4gQbGDNudhhdmeC0XqWc0kEFiQTaQIEDwkKCZNpiSJxFlqjBvhVAfwgX9T13+eCsyf874OLeN6ejNnUOpxXKO/Wq/sf5bKLWRBToDvaSlarltYU6mCpTid0CtO0ECSd6h2qyQNYODZhDGBuPTe30xZ/sv4jprVsofhrqShn4WTUYA6FWP8ApxH2i4ZpDK4EMCdyYIEz5chjoJ2jzMoOLKPSrFGBEwGDGROx3g8/LY4ufEOJAUtYcPqkoIYayZgADzInzF+UVQtMtJIiL72HPEFMhXRpAhgfSCDeN8XKNKwMdSkkyPJghksYDr9f8HFsr0nzdWmEX7yh2dbKI06mnkApPsMK0zNJdmVZcGRJ2DXvMbj542/4hpRgjAa/AdJ2DWYkBQZi3ucZfmSk0q0dhYMeCDakm2q9tp6Cu0FWk2Y73LqVUNKgTtcLI5lhdp3k9cAUXuIUkz8Jt1lL9UJWTyM4w5mmWYliAxSxkERIP6HfnjanmwN3TxEkEH+mALqYFo98MeaXiIldFidXk8v0flgudpaQQCbHSLRqH3WjzG/nONuHEQZtHPpiTNklQ6sAqMASpnRr52AP3SPl1xq9dW7zxGWI02mAu0nq2FtutodCONTdSuv31/nQS2XSA5mQxHr8PLkZt5+2IM1li4IBmADHrMfMgYlfMrqBDqAXkg6rgGRyIAO+2NqWYHdmCATsRa9z8vbC48rRoyRxU034b151/oRUTFjy+m364lFeRpCjriWtUUSDY7mIN/oRfkcDOyEnSWXoNyfXYD2xvetI8737o0dfMYmydVVa8kER6dSPOJjAerHga+FPYyOi38MzXf1gidDOq0nYEQYGwtgzLPdhEAHr84xVOE5kpVQgwNW8dbb7x5YtrEaG8INjK9cYM8FGkj1fwjqp5eTk+2/2PcwgIkrqK3Aib+XngSsjajBHyH9sR1sy0bxtbf2EDbzON/4teoP79MLSaN2TNjnJ+DzIV0ZZSCAbwI/c494goKehn9P1wiytQigYMEuAb8onnbfDDh3EC2lWJbVImIiOR5G31w6WNp2jmYesjkgsc9Nr8t69wooIx7UPnjYZWBZoHIHEFdCN74BbHzTgtoDyucahXo1KR8SVVYch6HyMkek4uH2jVQ1BatMHTUgqZ2BB1A+Y0lfnij1rMpO2tSfICZOGed4z/Kq0NQZJDUyPFHJhv4QR5bg9cdHF+A8z1L/5GacAai2YoGqQtPWNZPdkRBiRV/lxMDxWid8dSPCslXqZZqVPLVF7xl/5fL5VkJ7irU01AHLGoqrPOmWUQhtjhVa1ptyxDOLk7ZmiqO88X7P0Eq0dOXGp6VcI7ZPLwrBqPjqUxoSoAGKgaJmoTJiyLPcMoJnsppyBCvRzT9ytKjVYTVrikzoWCOUBpnSWMABZtjmuSp/y3crqJ8CzeLeIxzMERiTIZQQzuItCgiJnn5iPriKNluVHTH7NLSz1H+KND+Gp6zUq1MplcpSOqnCgFHJrHWyiCvhIJHM4Z9g+zlA0aS5jK0qtRaDB5Wk4BGZrrOq4ayqoImwF9scVqQJiB7Y9p0ue378v1xOJVnaU4Tlxxmrl0ytHQ2SVtDU6ehSHUltIBVjAiYBknpdrw3srlVzAT+Hy+unRFQu1JXUl61X4khQNPhA0kGIBMAY4ZwrLq4q6mOoBQg6ktF/IW26+xKSmrQ8QWWCOjpCv6TKN6semBY2EXJpep1vjHAsnSOaU0cqZpAsdCoKI7urUDwCCUNSjTSFhpYyzWGIs5wHLLVqCnQp1VqMKfdChlVFBgKDazULCpoKloUDm9tp5FnwvcMR/6oj0If8AsMJcUnZeSPB1ZYe2mXpLn82tHw01r1Ao0hYhiCoAJAUHUB5AWG2EigdDPl+zONKZ5HbBNETZff8Ayf0wxKxTIjQI3t6nEUYb1asAAKLdOeNMnlu9bTAv7EenX0xc4pEhcnQNk3Uap/AwHmSIH1OLQlSVJnfafn+uEuW4axqC0BWAY+am8ddo+vXDGhWApJMRABJMRA3/AH1xizU+x3PhvLG25aTX8GVc0iESTdulzAj5YUVeK+I+BT6i+CpAcEVFI5km4APKLzgCrSSTNS//AEz+c3xIRXkrqM+R/haW/t/k1y+YUBlKyrQd7iJuLb3w4yNKmQuhy2nxBTuOogRz/d8VvB2RqBGksQZAsfmTYyPLDJxtaMfS5+M1ySa/gsqVgyyJHkdx5HocDVXxmazCp4r+Iibn5gH9MQvUBEggg9MZox8nay5r+m9oBzrkTHpgWhBBMXH0/c4LqteSCfLrgRXAR4tJ29v843Yux57q9zBHqTc74jx7jzEEDZsxpKKR4FCyBzMAt7lrH0xFWrVFBRyZmfn/AJnHieKqIMjUWHoL/piHOVCzEk4PxZQOxwWH/ljAZxOT4BiokYRwekXrIikDUYv0i+HDZVf4g0qh1KxDzcAsB4j5Suo+oG4xXspXKOrjdTPr5e+2CszmtVQuvUEHqReTPM/rgQ09BHaDL9zUakshJDAEzaB+pYYTYa8azAqGm3PTHsDb3EkH0wrxCSds8wy4am+FuHmQhUg788NxK5C5diHcnE+TIDq+4BvG9yBccxfb6YAqVN4weuaFKisXZrjyj/f3xWSWhuFLlbdI34pnGTw65JuREwTdjM8yWO3P0wlqVCdz6D8voBjx3JJJNzjUYSo0My5nN67eEazjzGYzBCCdKLNMCYj89rc/bBdbIVKblQQSo1akM2tF9+YwRlqqIfEoBQAgLEs3VmNwB0GNszVaANSqD4mCiJJ2n8Ubb/nglG0XaiapkfBqc3ZZWSBHQxcsLjkOeJKNDx6NSgBJMqTsIY3E+YHtjfLVQy6i0CkgFtzBtFjAki/S2IMi/wDMLElhpYTN5I/O/PFqKot5HfoiWROq2lV3vfYSeXObYCrtqB8M+Ix6T/tgmnmQFcWmZJ535en98dL+yfP8MzAXK18lSaqlPUatSmjazqA3jVPjG9rYLJLjHQMbm97OP9w3Q/LGdw3Q/LH0H2J7PZB8nl6lTKUHY5iurFqakkBsxpBtsNKx6DpgbsoeG1c7mOHnh1E1aVSu5c0qZUqKp0qLSIV1UdIwixlL0/c4pwtGXvGg/BA9SR+gbGZPJI93bSZNpExG8Ha+O4cIbhma4o2TTh1JBQFcVJpUtNQoyKpAHSWifxYKzmT4dk8hXzVTh9Cr3deqCvdU5g5l6agEjYAgegxcm+KQWKUIy5ONr0s4WeG0/wD1LwOY6x/f0jEmZyFIaAXIUg3JHKI+px2ng3BKGffK104VRy+WK1GLEUG1hlhJRbmGvcWwxy3ZnJJSzTf8Po12p1WCotKnqYQvhSRAiScL2vJpefE1rGvHlnAK3DqYEgk7R03i5HPfG7cPp7Bzy5jeenSPO1sdT47xPK06bInAVp1oAGunQYqTN9IJJPS2KoeDUs1n8rROXfLUzSLVBCKamkuxYaBF7LtYDyGKp/8AYP5kHv5a3ryUbu2KbHw3Hod/0+ZxB3LfhPyx9AcP7NcJzNTNcPTLaKlFUJrAAEa1sUaZaJEhrHzwt7PdmssODI1TL0XrDMrTNQopYxm1QiSJIKyPS2D5GJxSZxSjQOoSDHpjeqXPI4+huO9heG1qiuvD6pGgD/ljSoKJJPiV6iHXfeNoE2wf2W+zzh1MuTw5xIH/AJo0awO/waXfSesxywSna0C4pd0z5jD4aV0VoEExAsY6bk+mF1e1RotDH64KNUaeYkxbmReT8xg0CuzC+4p20gBrAcgCbcx4mvO3LEZ4evdmCC24aTtMH284641SsrHS1jYgknfblgk1FUhdA0rsYBj8r4PimByoXfwdtyTGwGxJgCef+Rj0cPPOx9v74LzWeYsuppURG28b/wCcCaV5lj74BxL5B6VSRIVUBY8vbxf2xHmgknReDHijxR5Rb0vjTK1VKCZJWbC2552vgarp3EzzM4O9C/Iw4ZmlVWQKNTSSYBsNsB5zMkG1vS2B6FUqZU8ueNazSMUpfTQVWyN2PMzjqfAeMUMhk6GYNOXdNH8pERjOoy1SNRgopi4+E+Q5VOOgcO7T5L+Do0Mxl6lUpE+ERIm6+MSYaPbCZ7NWB037HXOynG6FbKZSrSpikpdhogC4WqCbWktLH1nnildjSRx7iVaQFU1Vv1aopA9YRj7Yr2U7YZdKdNFWtTCOfAgUKFIcEi/xSw9b4gzHbZVpFctSZaz1Hd6rKonUxIMXLHTAubeeA2NcMaptls7FHR2izRiA6VagnmKhR/1j2w74rxPI1clmcrnKlalSOYql6iUarAf8w7qBUFNqYvpG53jfFF4d28y4dK1TLulVUZGanBmY2kggSCY5TacMsp29yT5Z8vmMvXqUneo5AUR4qpqAzrFxb3xG35B+XHfEsfY3jXBsvUSnQ4rmn0qwVcxVqLSURtDIlMeXnh/lO0eTalmlXiOXoVHrOUqd5SJWyeIBjDCx3xzilxrgEweGVzET4fe/822EnGOKcMAJo5J0PeMy94ttMCF+Mz94x9eV2gFifnX3LdxHJL3nfLxygzaiW1HLSeUgiwJA2I6DCjg2qtxWh3ea79jRqaWK0wVs9op2EyTe9/TC7I8W4Tq/n5Go2kWCLo331gVLi9j5fOHiHaXL0c/QzfDso1FKaFXptK95q1B7gmJRonlAMWxVJjnzjXmvcuPZjNsnF8/pOokUlBA1CQFF42AgieWC+Fqx4VUJXw/xUSwt/wCcB25i5kgdRhBU+07K0zUrZbIFa9QAEsfCSFGlmIMnSw+HYgbg4h4J9olCnwtMpUSu1cVlqMwVSpjMLWJnUCTAPLf54lMCcl4Xr+5duIcYy1Op3enKk6oPhFoAN7WFwfnixcEqUa5ISllDAH3Nvyxx/tj2zymarNXpLmVYkEBkpjkBBIY2sT74C4d26akDpeuCegT+3tgFyTHOGOcFumUPMnxt/wBR+uN0bwg9G+o/xjStclupOPafwN6g/UfrjQYV6GVanLEyVAVglvziBgPGyDfF2BQecpaQdQ9ZwMwA54yuYiBbEWryxbZSQXlkhCep+n++Iaq2OJVqAIBPPEbva2L8FeSNTCn2H1/tiODj1rYeDgU6R3tjf4etvxeWADEONxUPU/PDQ8EYX1Lp1ATebmJjr5Tgip2dif5nOPh8wPxf1TiFptdhJ3zfiPzOM75vxH5nDml2fYm7wORiZixkTbfGHs/YnvNo+71IFjqvvitF2/UUJVN7nbrixcN1LQQgO5YMIFwLkTH754BrcFdQ5DKQIHMHkdr+m+CV4C0QKp2BjSeZj8XXAThyVGrpup+TJydvVe2xgyfzahANtExJ3FoCsDt64D4wC6pTAYnVuVIB9CxJxAnBm3703AO3/Vv4v6TjMzwNxEVC25MgiAN+ZvfC1haad9jbl+JxnFx41b37XYyNM97UbdWSxHkQDjcq3fT/ADIE7/DtywsPAyGIFUjaYU85/q/pxo/B6nKoSZIEyORJvJ5LivkP18UGvi0Krg+99/f7fcSmoZ3Pzx53zfiPzOGT8AqgxKc+Z5e2J8v2dLLJqARvAnnG8jGijiuT9RN3zfiPzOM75up+eG1TgkKrd58Wi2kW1GPxcsbVeA6f/wCnIn4Ryv8Ai6Ymicn6ixiNIwLh6OB+EHvPw/d21R/VynGDgMgHvDcBvg6+98EwRFjZMTZulocqDMc4jl0xCDiiGxqnGurHhOPMQh7OMnHmMxCHpOLRlihWmS5nRLS7i/h2vvZsVbFhyPF9FNVZHYqB6RJA9oMTiEDNNLUoLNphi0O++pSOdtycYVo+KahI1jSdb7Qs/e6gnA54xAJNNwDaYi4P+/yx7lOK6Fpr3VQkCAOsC8D5nEIEUjS1t4zECPG+8mfvbwFwOmjVSXWSI8fjax0kyRMi8e+CMrnS2p9EQTIYgGyrP0Pzxs1KoKquFCzIaCJbVJF45QN+mIQhLUiqjUwnTr8b7wd/FyMYxxSIMVGAmxDtO/mT0wSlVzXp0lTVUeVVdai8jdmgCy7m2GdTgOby1HvKmWIRWYN/Npm/ein+KfjdR88QgjFOl4QHYkEBvG20He9v841KJDxUcmGga2tHw8+Yi5OLNT7OZ4GDlrjTbvqNxopgv8XiQd6kuJUFgN8LavD69Ks1OqiU3ZZAqV6KTDPSsWYBvFTew6A4hARloiYqG8we8eTckR4r88CUmRqU+JGg2NR51RAO/MxiwtwHON3bDLTpZhC1abGUcUGsG2FSqoJ2EztjxOzWecArRVpYVFitROoU2QMRD+IaiLiR4hiEK9mqatVlKpCgD77HV1EzI2+mCwKQYjVykRUfqfMeXzwx4twvN5NRXr5dlplgoPeU2k1FLLAVidl6YRVc9VZqbojgAQ21wSJHl8OIQ3VU1KCTp8W7uBYjTztaYxO/cz8ZJESe8fqJ+9tE4HHGZMaGsCDcWM40XimkN/La7a9x5Wjp4RiEJs0aSxpLN4gNIqPte+5gAlflidFoyIdog/fe1xA+Lcf3xAc8+st/D1fh0xpNriOXUY1HFiKeo0306iuqwvIMesDbEIIc9HePG2oxztywNg3ipJquWUoSZ0ncSAb/ADwFiEMxmMxmIQzGYzGYhDMGJxGsBAqMALb4DxmIQJqZ2owIZ2IO4J3x5WzdR41OzRtJJjA+MxCBuW4jUpgqpsTJkA4mbjdc7sLbeEW/LCzGYhBnl89VaslQLramwcADoQbxymMWvi/bPN5jK1sqcqirWdnZl1z4qxrwJYiAxIHlig4zEIdHo/aBnFEDLKZakbmqRFIUQAF16QScuhLAA3b2GzXbniBr9/SpCiSi02VEkMFZ3vIN5dr4oOMxCHQanbzOtTKDLJJqirqIqMbVhXVTLSQGCrc/CAN743pfaBnU7rRlaVMUtQGlap8LEMVlnZgNao9jMqLxIPO8ZiELz2p7bZvNZdaVWgqIjq2pdYuJtvsSZMzcCIxWRxdpNp/76n/2wsxmIQJqZpyxbU0n+o/qZxo2YciC7EepxDjMQgSc5UO9R/8AUfX643GeYKEhYF9hv19fPAeMxCEteqWYsYk9MRYzGYhDMZjMZiEP/9k=');

insert into Content(label, info, canDownload, age, previewUrl, videoUrl, title, releasedAt, quality, thumbnail)
values ('시리즈', '최상류층 고객만 받는 결혼정보회사에서 결혼 상대를 찾는 사람들.', 1, 15, 'https://namu.wiki/w/%EB%B8%94%EB%9E%99%EC%9D%98%20%EC%8B%A0%EB%B6%80', 'https://namu.wiki/w/%EB%B8%94%EB%9E%99%EC%9D%98%20%EC%8B%A0%EB%B6%80','블랙의 신부', '2022', 'HD', 
'https://w.namu.la/s/8724a9c8892de2b646e9f60249f52e24da03cb3ff9d20182a9f15ded8b1ccffe21b73cc46f32c889558618272bd00184df0909a3d009bf7124b0eacf6e11f78246a044e07816b0abfbfff316bb44ec710d8cdacec402a1b1c7768fbbde6d2af82431d9090c2c8554bacbf45851b80e0c');

insert into Content(label, info, canDownload, age, previewUrl, videoUrl, title, releasedAt, quality, thumbnail)
values ('시리즈', '만인의 사랑을 받는 왕자와 두려움을 모르는 공주.', 1, 12, 'https://wetv.vip/ko/play/uvwdajywre9oli9/s0042ox0xqm','https://wetv.vip/ko/play/uvwdajywre9oli9/s0042ox0xqm', '차시천하', '2022', 'HD', 
'http://cdn.smartfile.co.kr/2022/05/04/7cb144d392dd91edf3a3a64f5cc5e4bd_203129.jpg');

insert into Content(label, info, canDownload, age, previewUrl,videoUrl,  title, releasedAt, quality, thumbnail)
values ('시리즈', '막 싱글이 된 이혼 남녀들. 다시 사랑을 만나러 돌싱 빌리지에 모였다.', 1, 15, 'https://www.youtube.com/watch?v=jtMSlmfsjKQ', 'https://www.youtube.com/watch?v=jtMSlmfsjKQ','돌싱글즈', '2022', 'HD', 
'https://newsimg.hankookilbo.com/cms/articlerelease/2021/07/07/e6cbb442-5b9f-4472-945c-eb08efcc4be9.jpg');

insert into Content(label, info, canDownload, age, previewUrl, videoUrl, title, releasedAt, quality, thumbnail)
values ('시리즈', '야구에 미친 아마추어 선수들.', 1, 15, 'https://namu.wiki/w/%EC%B5%9C%EA%B0%95%EC%95%BC%EA%B5%AC', 'https://namu.wiki/w/%EC%B5%9C%EA%B0%95%EC%95%BC%EA%B5%AC','최강야구', '2022', 'HD', 
'https://w.namu.la/s/3a88a86ca7a661e18db764d7ab95ef8d8dc214cc436111f6e0f10046a2bc9e5b9e3dec0f7b9390ae68b9da3b8a3686126f3cbdf71c67d79eb230f9e7954f891d552bf9185518f5253dc522be670a043c84e65fe54965e4f10fe5f294ebd34a0ec4e6ab988d506b14cd2c3a02d1da3db4');


insert into Content(label, info, canDownload, age, previewUrl, videoUrl, title, releasedAt, quality, thumbnail)
values ('영화', '747편 비행기를 납치한 테러리스트들.', 1, 15, 'https://namu.wiki/w/%ED%8C%8C%EC%9D%B4%EB%84%90%20%EB%94%94%EC%94%A8%EC%A0%84', 'https://namu.wiki/w/%ED%8C%8C%EC%9D%B4%EB%84%90%20%EB%94%94%EC%94%A8%EC%A0%84','화이널 디씨전', '1996', 'HD', 
'https://t1.daumcdn.net/cfile/tistory/273FB0365374FC400B');

insert into Content(label, info, canDownload, age, previewUrl, videoUrl,title, releasedAt, quality, thumbnail)
values ('영화', '수십 년 만에 모습을 드러낸 유골에는 어떤 비밀이 숨어 있었나.', 1, 15, 'https://namu.wiki/w/%EB%B8%94%EB%A0%88%EC%9D%B4%EB%93%9C%20%EB%9F%AC%EB%84%88%202049', 'https://namu.wiki/w/%EB%B8%94%EB%A0%88%EC%9D%B4%EB%93%9C%20%EB%9F%AC%EB%84%88%202049', '블레이드 러너 2049', '2017', 'HD', 
'https://upload.wikimedia.org/wikipedia/ko/0/00/%EB%B8%94%EB%A0%88%EC%9D%B4%EB%93%9C_%EB%9F%AC%EB%84%88_2049.jpg');

insert into Content(label, info, canDownload, age, previewUrl, videoUrl, title, releasedAt, quality, thumbnail)
values ('시리즈', '모르는 게 없고 용하기로 소문난 박수무당.', 1, 15, 'https://www.netflix.com/kr/title/81568217','https://www.netflix.com/kr/title/81568217', '미남당', '2022', 'HD', 
'https://programres.kbs.co.kr/t2022-0090/2022/6/10/1654842408288_388337.jpg');

insert into Content(label, info, canDownload, age, previewUrl,  videoUrl, title, releasedAt, quality, thumbnail)
values ('시리즈', '내가 직접 잡아넣은 사형수가 무죄라면?', 1, 15, 'https://namu.wiki/w/%EB%AA%A8%EB%B2%94%ED%98%95%EC%82%AC', 'https://namu.wiki/w/%EB%AA%A8%EB%B2%94%ED%98%95%EC%82%AC','모범형사', '2020', 'HD', 
'https://img.hankyung.com/photo/202006/20200604172537_5ed8b001642d5_1.jpg');

insert into Content(label, info, canDownload, age, previewUrl,  videoUrl,  title, releasedAt, quality, thumbnail)
values ('시리즈', '이별을 고민 중인 컾ㄹ들이 잠시 서로의 연인을 바꿔 자신들의 사랑을 시험해보는 리얼리티 시리즈.', 1, 15, 'https://www.youtube.com/watch?v=HNUV70fX7lw', 'https://www.youtube.com/watch?v=HNUV70fX7lw', '체인지데이즈', '2022', 'HD', 
'https://i.ytimg.com/vi/wXMiXyJiALM/maxresdefault.jpg');

insert into Content(label, info, canDownload, age, previewUrl, videoUrl, title, releasedAt, quality, thumbnail)
values ('시리즈', '꾹꾹 숨겨온 비밀과 상처가 하나둘 드러나는 가운데, 관계를 회복하려 애쓰는 가족의 감성 드라마.', 1, 15, 'https://namu.wiki/w/(%EC%95%84%EB%8A%94%20%EA%B1%B4%20%EB%B3%84%EB%A1%9C%20%EC%97%86%EC%A7%80%EB%A7%8C)%20%EA%B0%80%EC%A1%B1%EC%9E%85%EB%8B%88%EB%8B%A4', 'https://namu.wiki/w/(%EC%95%84%EB%8A%94%20%EA%B1%B4%20%EB%B3%84%EB%A1%9C%20%EC%97%86%EC%A7%80%EB%A7%8C)%20%EA%B0%80%EC%A1%B1%EC%9E%85%EB%8B%88%EB%8B%A4', '(아는 건 별로 없지만) 가족입니다', '2020', 'HD', 
'https://mblogthumb-phinf.pstatic.net/MjAyMDA2MDJfMTE2/MDAxNTkxMDUyMTQxOTEw.LTqMS9mgoILzHpQc-lk7BKS8zLJEmyjuqH62KqgUCLwg.sTaDsLGNL68uUUPPzTfRD2J4nhackeGbR_yofdfnvUIg.JPEG.jarlanlhd/EUS8WZNN6YCJX2VX27UI.jpg?type=w800');

insert into Content(label, info, canDownload, age, previewUrl,  videoUrl, title, releasedAt, quality, thumbnail)
values ('시리즈', '우리는 언제부터, 무슨 이유로 삶의 쳇바퀴에 갇히게 됐을까? 정확히 기억나지는 않는다. 하지만 이렇게 끝낼 순 없어. 뭔가 해야만 한다.', 1, 15, 'https://www.netflix.com/kr/title/81568411', 'https://www.netflix.com/kr/title/81568411','나의 해방일지', '2022', 'HD',
'https://www.kukinews.com/data/kuk/image/2022/05/30/kuk202205300066.680x.0.jpg');

insert into Content(label, info, canDownload, age, previewUrl,  videoUrl,title, releasedAt, quality, thumbnail)
values ('영화', '화려한 수상 경력의 감독이 <모나아>와 <빅 히어로>에 이어 선보이는 장대한 모험 이야기.', 1, 0, 'https://www.youtube.com/watch?v=WcgaOvaQVAM','https://www.youtube.com/watch?v=WcgaOvaQVAM', '씨 비스트', '2022', 'HD', 
'https://img1.daumcdn.net/thumb/R800x0/?scode=mtistory2&fname=https%3A%2F%2Fblog.kakaocdn.net%2Fdn%2FF9EIM%2FbtrGzdd61zi%2FhupAbDwqZVRx2KaC2L2wrK%2Fimg.png');

insert into Content(label, info, canDownload, age, previewUrl, videoUrl,title, releasedAt, quality, thumbnail)
values ('영화', '서로를 사랑하지도, 심지어 좋아하지도 않는 뮤지션과 해병대원.', 1, 15, 'https://www.netflix.com/kr/title/81043665', 'https://www.netflix.com/kr/title/81043665','퍼플 하트', '2022', 'HD', 
'https://w.namu.la/s/6a24086545542a1ee1e6427b76f360556025a0ca95d74c661bf5e09a4caabe72ddecc9f97277fc000da0dcf700b02fd0a2052acbc6a3e3bc2486f9ebd2ae3cd5760ed575ff09dd684490b8a51b3e61ae2bec4a72c950ae057ad8677d9ac57854');

insert into Content(label, info, canDownload, age, previewUrl, videoUrl, title, releasedAt, quality, thumbnail)
values ('영화', '<The Atlantic>이 평했듯이 할리우드도 부러워할 환상적인 탈리우드 블록버스터 대작', 1, 15, 'https://namu.wiki/w/RRR:%20%EB%9D%BC%EC%9D%B4%EC%A6%88%20%EB%A1%9C%EC%96%B4%20%EB%A6%AC%EB%B3%BC%ED%8A%B8?from=R.R.R.', 'https://namu.wiki/w/RRR:%20%EB%9D%BC%EC%9D%B4%EC%A6%88%20%EB%A1%9C%EC%96%B4%20%EB%A6%AC%EB%B3%BC%ED%8A%B8?from=R.R.R.', 'RRR: 라이즈 로어 리볼트', '2022', 'HD', 
'https://blog.kakaocdn.net/dn/6X2u0/btrGE00ERBs/UQRIXxvXI8ZlKESJ7Eo1T1/img.png');

insert into Content(label, info, canDownload, age, previewUrl,  videoUrl,title, releasedAt, quality, thumbnail)
values ('영화', '학업과 재정 측면에서 어려움을 겪고 있는 학생. 학교 경비원에게 수학을 가르쳐 달라고 요청한다.', 1, 12, 'https://namu.wiki/w/%EC%9D%B4%EC%83%81%ED%95%9C%20%EB%82%98%EB%9D%BC%EC%9D%98%20%EC%88%98%ED%95%99%EC%9E%90', 'https://namu.wiki/w/%EC%9D%B4%EC%83%81%ED%95%9C%20%EB%82%98%EB%9D%BC%EC%9D%98%20%EC%88%98%ED%95%99%EC%9E%90', '이상한 나라의 수학자', '2022', 'HD', 
'https://t1.daumcdn.net/movie/9ca21642451e2e68e3eec5b9691c2aba33b47d70');

insert into Content(label, info, canDownload, age, previewUrl,videoUrl, title, releasedAt, quality, thumbnail)
values ('영화', '버스터 문, 그리고 음악적 재능이 넘치는 그의 친구들.', 1, 0, 'https://namu.wiki/w/%EC%94%BD2%EA%B2%8C%EB%8D%94', 'https://namu.wiki/w/%EC%94%BD2%EA%B2%8C%EB%8D%94','씽2게더', '2021', 'HD', 
'http://www.ccoart.com/news/photo/202112/2979_5695_643.jpg');

insert into Content(label, info, canDownload, age, previewUrl,videoUrl, title, releasedAt, quality, thumbnail)
values ('영화', '어릴 때부터 전설적인 암살자의 제자로 키워진 애나. 이제는 세계 최고의 살인청부업자가 되었다.', 1, 15, 'https://www.youtube.com/watch?v=8sgd6gAetA0','https://www.youtube.com/watch?v=8sgd6gAetA0', '킬링 카인드: 킬러의 수제자', '2021', 'HD', 
'https://t1.daumcdn.net/movie/8d55127a05d1f18ba09a93de4c38ea64b9106762');

insert into Content(label, info, canDownload, age, previewUrl, videoUrl, title, releasedAt, quality, thumbnail)
values ('영화', '가수를 꿈꾸는 여자가 톱스타 뮤지션인 남자를 만나 열정적인 사랑에 빠져든다.', 1, 15, 'https://namu.wiki/w/%EC%8A%A4%ED%83%80%20%EC%9D%B4%EC%A6%88%20%EB%B3%B8', 'https://namu.wiki/w/%EC%8A%A4%ED%83%80%20%EC%9D%B4%EC%A6%88%20%EB%B3%B8', '스타 이즈 본', '2018', 'HD', 
'http://t1.daumcdn.net/movie/9936cfa7ee10d7b77a943c1a9d9b50f07f6753de');

insert into Content(label, info, canDownload, age, previewUrl, videoUrl, title, releasedAt, quality, thumbnail)
values ('영화', '기억을 잃은 채 깨어난 남자. 귀에 장착된 장치를 통해 의문의 목소리가 들려오고, 이제 이 목소리의 지시에 따라 위험천만한 인질 구조 작전에 뛰어들어야 한다.', 1, 18, 'https://namu.wiki/w/%EC%B9%B4%ED%84%B0(%EC%98%81%ED%99%94)', 'https://namu.wiki/w/%EC%B9%B4%ED%84%B0(%EC%98%81%ED%99%94)','카터', '2022', 'HD', 
'https://img.hankyung.com/photo/202207/BF.30565753.1.jpg');

insert into Content(label, info, canDownload, age, previewUrl,  videoUrl, title, releasedAt, quality, thumbnail)
values ('시리즈', '인생은 기쁨, 때로는 슬픔. 그리고 그 사이에 있는 모든 것. 이곳 제주에서 일어나는 이야기는 특별할 것 하나 없다.', 1, 15, 'https://namu.wiki/w/%EC%9A%B0%EB%A6%AC%EB%93%A4%EC%9D%98%20%EB%B8%94%EB%A3%A8%EC%8A%A4',  'https://namu.wiki/w/%EC%9A%B0%EB%A6%AC%EB%93%A4%EC%9D%98%20%EB%B8%94%EB%A3%A8%EC%8A%A4','우리들의 블루스', '2022', 'HD', 
'https://web-cf-image.cjenm.com/crop/660x950/public/share/metamng/programs/%EC%9A%B0%EB%A6%AC%EB%93%A4%EC%9D%98-%EB%B8%94%EB%A3%A8%EC%8A%A4-drama-poster-ko-001.jpg?v=1655366862');

insert into Content(label, info, canDownload, age, previewUrl, videoUrl,title, releasedAt, quality, thumbnail)
values ('시리즈', '박주미, 이가령, 전수경이 일, 시댁, 부부관계를 헤쳐나가는 세 여성이자 직장 동료를 연기한다.', 1, 15, 'https://namu.wiki/w/%EA%B2%B0%ED%98%BC%EC%9E%91%EC%82%AC%20%EC%9D%B4%ED%98%BC%EC%9E%91%EA%B3%A1', 'https://namu.wiki/w/%EA%B2%B0%ED%98%BC%EC%9E%91%EC%82%AC%20%EC%9D%B4%ED%98%BC%EC%9E%91%EA%B3%A1','결혼작사 이혼작곡', '2022', 'HD', 
'https://file2.nocutnews.co.kr/newsroom/image/2020/12/15/20201215152000645576_0_532_733.jpg');

insert into Content(label, info, canDownload, age, previewUrl,videoUrl, title, releasedAt, quality, thumbnail)
values ('시리즈', '친구 대신 맞선을 보러 간 그녀. 남자에게 겁을 줘 퇴짜를 놓게 할 작정이다.', 1, 15, 'https://www.youtube.com/watch?v=8jNShObvM38','https://www.youtube.com/watch?v=8jNShObvM38', '사내맞선', '2022', 'HD', 
'https://img2.sbs.co.kr/img/sbs_cms/WE/2022/02/22/4DY1645513296085.jpg');

insert into Content(label, info, canDownload, age, previewUrl, videoUrl,title, releasedAt, quality, thumbnail)
values ('영화', '스파이들 사이의 전쟁을 그린 2022년 액션 스릴러.', 1, 15, 'https://namu.wiki/w/%EC%95%BC%EC%B0%A8(%EC%98%81%ED%99%94)','https://namu.wiki/w/%EC%95%BC%EC%B0%A8(%EC%98%81%ED%99%94)','야차', '2022', 'HD', 
'https://t1.daumcdn.net/movie/4f71c6ce6a6e6ca5f72b3cf4de1a528a80f49df5');

insert into Content(label, info, canDownload, age, previewUrl, videoUrl,title, releasedAt, quality, thumbnail)
values ('시리즈', '죽음의 얼굴을 한 저승사자는 삶의 끝을 상징한다.', 1, 15, 'https://www.youtube.com/watch?v=F5Y55h5pzCg', 'https://www.youtube.com/watch?v=F5Y55h5pzCg', '내일', '2022', 'HD', 
'https://img.imbc.com/template/2022/04/program_7185649e-8cd3-4de4-8131-ed8590b936b8.jpg');

insert into Content(label, info, canDownload, age, previewUrl, videoUrl,title, releasedAt, quality, thumbnail)
values ('시리즈', '발로 차고, 소리 지르고, 울고. 부모가 다가가기 너무나 힘든 아이들.', 1, 15, 'https://www.youtube.com/watch?v=6xLFf3MOZnE', 'https://www.youtube.com/watch?v=6xLFf3MOZnE','금쪽같은 내새끼', '2022', 'HD', 
'https://image.tving.com/upload/cms/caip/CAIP2100/P001243851.png/dims/resize/1280');

insert into Content(label, info, canDownload, age, previewUrl, videoUrl,title, releasedAt, quality, thumbnail)
values ('시리즈', '1998년 서울에서 어른이 된다는 건?', 1, 15, 'https://namu.wiki/w/%EC%8A%A4%EB%AC%BC%EB%8B%A4%EC%84%AF%20%EC%8A%A4%EB%AC%BC%ED%95%98%EB%82%98', 'https://namu.wiki/w/%EC%8A%A4%EB%AC%BC%EB%8B%A4%EC%84%AF%20%EC%8A%A4%EB%AC%BC%ED%95%98%EB%82%98','스물다섯 스물하나', '2022', 'HD', 
'https://img.hankyung.com/photo/202201/01.28633239.1-1200x.jpg');

insert into Content(label, info, canDownload, age, previewUrl, videoUrl,title, releasedAt, quality, thumbnail)
values ('시리즈', '외로움은 겪을 만큼 겪었다!', 1, 15, 'https://www.youtube.com/watch?v=dlaci-nFXsw', 'https://www.youtube.com/watch?v=dlaci-nFXsw','나는 솔로', '2022', 'HD', 
'https://img2.sbs.co.kr/img/sbs_cms/WE/2021/10/08/o6y1633651830561-640-360.jpg');

insert into Content(label, info, canDownload, age, previewUrl, videoUrl, title, releasedAt, quality, thumbnail)
values ('시리즈', '신부를 찾아야 죽을 수 있는 남자.', 1, 15, 'https://namu.wiki/w/%EC%93%B8%EC%93%B8%ED%95%98%EA%B3%A0%20%EC%B0%AC%EB%9E%80%ED%95%98%E7%A5%9E%20-%20%EB%8F%84%EA%B9%A8%EB%B9%84', 'https://namu.wiki/w/%EC%93%B8%EC%93%B8%ED%95%98%EA%B3%A0%20%EC%B0%AC%EB%9E%80%ED%95%98%E7%A5%9E%20-%20%EB%8F%84%EA%B9%A8%EB%B9%84','도깨비', '2016', 'HD', 
'https://web-cf-image.cjenm.com/crop/660x950/public/share/metamng/programs/guardian-drama-poster-ko-001-01_1645666897593.jpg?v=1653466489');

insert into Content(label, info, canDownload, age, previewUrl, videoUrl,title, releasedAt, quality, thumbnail)
values ('시리즈', '평화로운 초원에 자리 잡은 보육원.', 1, 19, 'https://namu.wiki/w/%EC%95%BD%EC%86%8D%EC%9D%98%20%EB%84%A4%EB%B2%84%EB%9E%9C%EB%93%9C(%EC%95%A0%EB%8B%88%EB%A9%94%EC%9D%B4%EC%85%98%202%EA%B8%B0)', 'https://namu.wiki/w/%EC%95%BD%EC%86%8D%EC%9D%98%20%EB%84%A4%EB%B2%84%EB%9E%9C%EB%93%9C(%EC%95%A0%EB%8B%88%EB%A9%94%EC%9D%B4%EC%85%98%202%EA%B8%B0)', '약속의 네버랜드', '2021', 'HD', 
'https://mblogthumb-phinf.pstatic.net/MjAyMDAzMDFfMjM4/MDAxNTgzMDY5MjEzNDEx.4jAMqmezAtlA1y-5MJ0LbRdEePAO-6et4bWcQxRD8jMg.K_TD3WVsX2l2Bt3l8ePviz3eIwKOzufGfIDLVbwlrAIg.JPEG.jgk03088/IMG_3467.jpg?type=w800');

insert into Content(label, info, canDownload, age, previewUrl, videoUrl, title, releasedAt, quality, thumbnail)
values ('영화', '택시기사인 맥스는 600달러를 주겠다는 손님을 태우게 된다. 하지만 세상에 공짜는 없는 법.', 1, 15, 'https://namu.wiki/w/%EC%BD%9C%EB%9E%98%ED%8A%B8%EB%9F%B4', 'https://namu.wiki/w/%EC%BD%9C%EB%9E%98%ED%8A%B8%EB%9F%B4','콜래트럴', '2004', 'HD', 
'http://t1.daumcdn.net/cfile/1706D32B4ACE9EA506');

insert into Content(label, info, canDownload, age, previewUrl, videoUrl,title, releasedAt, quality, thumbnail)
values ('영화', '사냥을 나갔다가 마약 거래단의 총격전이 벌어졌던 현장에서 현금 2백만 달러를 챙긴 루엘린 모스.', 1, 18, 'https://namu.wiki/w/%EB%85%B8%EC%9D%B8%EC%9D%84%20%EC%9C%84%ED%95%9C%20%EB%82%98%EB%9D%BC%EB%8A%94%20%EC%97%86%EB%8B%A4', 'https://namu.wiki/w/%EB%85%B8%EC%9D%B8%EC%9D%84%20%EC%9C%84%ED%95%9C%20%EB%82%98%EB%9D%BC%EB%8A%94%20%EC%97%86%EB%8B%A4', '노인을 위한 나라는 없다', '2007', 'HD', 
'https://upload.wikimedia.org/wikipedia/ko/a/a9/%EB%85%B8%EC%9D%B8%EC%9D%84%EC%9C%84%ED%95%9C%EB%82%98%EB%9D%BC%EB%8A%94%EC%97%86%EB%8B%A4_%ED%8F%AC%EC%8A%A4%ED%84%B0.jpg');

insert into Content(label, info, canDownload, age, previewUrl, videoUrl,title, releasedAt, quality, thumbnail)
values ('영화', '경비행기가 캐나다 황야 한가운데에 추락하면서 홀로 살아남은 그녀.', 1, 18, 'https://www.netflix.com/kr/title/81276119','https://www.netflix.com/kr/title/81276119', '숨 쉬어라', '2022', 'HD', 
'https://img1.daumcdn.net/thumb/R800x0/?scode=mtistory2&fname=https%3A%2F%2Fblog.kakaocdn.net%2Fdn%2Fd2TJ0T%2FbtrIoJWf53J%2FOWT6WhHfLIagWuqtGUPKfK%2Fimg.png');

insert into Content(label, info, canDownload, age, previewUrl, videoUrl, title, releasedAt, quality, thumbnail)
values ('시리즈', '투자 증권 회사에서 일하는 3명의 미화원.', 1, 15, 'https://namu.wiki/w/%ED%81%B4%EB%A6%AC%EB%8B%9D%20%EC%97%85', 'https://namu.wiki/w/%ED%81%B4%EB%A6%AC%EB%8B%9D%20%EC%97%85','클리닝 업', '2022', 'HD', 
'http://file.mk.co.kr/meet/neds/2022/05/image_readtop_2022_417915_16522748195039542.jpg');

5. DetailContent 테이블

insert into DetailContent(season, episode, playtime, title, info, canDownload, quality, videoUrl, contentIdx)
values ('시즌 1', 1, '00:23:00.0', '1화', '초능력자라 좋겠다고? 흥, 대단한 착각. 뻔히 다 아니까 지루해. 능력을 숨겨야 하니까 왕피곤.', 1, 'HD',
'https://www.youtube.com/watch?v=87IkhpL1jVo', 2);

insert into DetailContent(season, episode, playtime, title, info, canDownload, quality, videoUrl, contentIdx)
values ('시즌 1', 2, '00:23:00.0', '2화', '제일 싫은 건 체육 시간. 운동 실력이 눈에 띄면 곤란하니까.', 1, 'HD',
'https://www.youtube.com/watch?v=87IkhpL1jVo', 2);

insert into DetailContent(season, episode, playtime, title, info, canDownload, quality, videoUrl, contentIdx)
values ('시즌 1', 3, '00:23:00.0', '3화', '노숙자 출신 마술사 초노가 어메이징한 기적을 보여준다는데.', 1, 'HD',
'https://www.youtube.com/watch?v=87IkhpL1jVo', 2);

insert into DetailContent(season, episode, playtime, title, info, canDownload, quality, videoUrl, contentIdx)
values ('시즌 1', 4, '00:23:00.0', '4화', '유령을 보는 영 능력자 레이타. 다짜고짜 쿠스오를 찾아와 제자로 받아달라고 생떼를 쓴다.', 1, 'HD',
'https://www.youtube.com/watch?v=87IkhpL1jVo', 2);

insert into DetailContent(season, episode, playtime, title, info, canDownload, quality, videoUrl, contentIdx)
values ('시즌 1', 5, '00:23:00.0', '5화', '본방 사수의 집념을 불태우는 쿠스오.', 1, 'HD',
'https://www.youtube.com/watch?v=87IkhpL1jVo', 2);

insert into DetailContent(season, episode, playtime, title, info, canDownload, quality, videoUrl, contentIdx)
values ('시즌 1', 6, '00:23:00.0', '6화', '내 사랑 커피 젤리! 어떤 걸 사야 할까.', 1, 'HD',
'https://www.youtube.com/watch?v=87IkhpL1jVo', 2);

insert into DetailContent(season, episode, playtime, title, info, canDownload, quality, videoUrl, contentIdx)
values ('시즌 1', 7, '00:23:00.0', '7화', '개와 고양이 중 뭐가 좋냐고? 둘 다 관심 노노.', 1, 'HD',
'https://www.youtube.com/watch?v=87IkhpL1jVo', 2);

insert into DetailContent(season, episode, playtime, title, info, canDownload, quality, videoUrl, contentIdx)
values ('시즌 2', 1, '00:23:00.0', '1화', '지난 시즌 이후 일주일이 흘렀다.', 1, 'HD',
'https://www.youtube.com/watch?v=87IkhpL1jVo', 2);

insert into DetailContent(season, episode, playtime, title, info, canDownload, quality, videoUrl, contentIdx)
values ('시즌 2', 2, '00:23:00.0', '2화', '지겨워, 또 시작인가?', 1, 'HD',
'https://www.youtube.com/watch?v=87IkhpL1jVo', 2);

insert into DetailContent(season, episode, playtime, title, info, canDownload, quality, videoUrl, contentIdx)
values ('시즌 2', 3, '00:23:00.0', '3화', '엄청난 한파다! 모진 추위를 이기고 등교한 쿠스오와 친구들.', 1, 'HD',
'https://www.youtube.com/watch?v=87IkhpL1jVo', 2);

insert into DetailContent(season, episode, playtime, title, info, canDownload, quality, videoUrl, contentIdx)
values ('시즌 2', 4, '00:23:00.0', '4화', '1학년에 슈퍼 미소녀가 나타났다!', 1, 'HD',
'https://www.youtube.com/watch?v=87IkhpL1jVo', 2);

insert into DetailContent(season, episode, playtime, title, info, canDownload, quality, videoUrl, contentIdx)
values ('시즌 2', 5, '00:23:00.0', '5화', '가장 귀여운 건 나야!', 1, 'HD',
'https://www.youtube.com/watch?v=87IkhpL1jVo', 2);

insert into DetailContent(season, episode, playtime, title, info, canDownload, quality, videoUrl, contentIdx)
values ('시즌 2', 6, '00:23:00.0', '6화', '호화 여객선을 타고 메토리네 무인도로!', 1, 'HD',
'https://www.youtube.com/watch?v=87IkhpL1jVo', 2);

insert into DetailContent(season, episode, playtime, title, info, canDownload, quality, videoUrl, contentIdx)
values ('시즌 2', 7, '00:23:00.0', '7화', '포기할 순 없어! 섬에 갇힌 상태에서 뗏목을 완성하는 친구들.', 1, 'HD',
'https://www.youtube.com/watch?v=87IkhpL1jVo', 2);

insert into DetailContent(season, episode, playtime, title, info, canDownload, quality, videoUrl, contentIdx)
values ('시즌 3', 1, '00:23:00.0', '1화', '진로 계획서를 쓰는 반 친구들. 눈을 번뜩이며 미래를 얘기한다.', 1, 'HD',
'https://www.youtube.com/watch?v=87IkhpL1jVo', 2);

insert into DetailContent(season, episode, playtime, title, info, canDownload, quality, videoUrl, contentIdx)
values ('시즌 3', 2, '00:23:00.0', '2화', '친구들과 함께 봄방학 여행지를 고르는 쿠스오. 오시마이현만은 안된다는데 이것들이 자꾸 우기네?', 1, 'HD',
'https://www.youtube.com/watch?v=87IkhpL1jVo', 2);

6. LikeContent 테이블

insert into LikeContent(contentIdx, profileIdx)
values (1, 1);

insert into LikeContent(contentIdx, profileIdx)
values (2, 1);

insert into LikeContent(contentIdx, profileIdx)
values (3, 1);

insert into LikeContent(contentIdx, profileIdx)
values (4, 1);

insert into LikeContent(contentIdx, profileIdx)
values (42, 1);

7. MostSearch 테이블

insert into MostSearch(contentIdx)
values (28);

insert into MostSearch(contentIdx)
values (29);

insert into MostSearch(contentIdx)
values (30);

insert into MostSearch(contentIdx)
values (31);

insert into MostSearch(contentIdx)
values (32);

insert into MostSearch(contentIdx)
values (33);

insert into MostSearch(contentIdx)
values (34);

insert into MostSearch(contentIdx)
values (35);

8. Category 테이블

insert into Category(type)
values ('한국');

insert into Category(type)
values ('외국');

insert into Category(type)
values ('아시아');

insert into Category(type)
values ('액션');

insert into Category(type)
values ('코미디');

insert into Category(type)
values ('어린이 & 가족');

insert into Category(type)
values ('로맨스');

insert into Category(type)
values ('드라마 장르');

insert into Category(type)
values ('호러');

insert into Category(type)
values ('스릴러');

insert into Category(type)
values ('SF');

insert into Category(type)
values ('판타지');

insert into Category(type)
values ('전 세계 예능이 한곳에!');

insert into Category(type)
values ('애니메이션');

insert into Category(type)
values ('다큐멘터리');

insert into Category(type)
values ('평단의 찬사를 받은');

insert into Category(type)
values ('할리우드');

insert into Category(type)
values ('음악 & 뮤지컬');

insert into Category(type)
values ('음성 지원');

insert into Category(type)
values ('한국 드라마');

insert into Category(type)
values ('미국 드라마');

insert into Category(type)
values ('영국 드라마');

insert into Category(type)
values ('아시아 드라마');

insert into Category(type)
values ('애니');

insert into Category(type)
values ('SF & 판타지');

insert into Category(type)
values ('키즈');

insert into Category(type)
values ('청소년');

insert into Category(type)
values ('다큐시리즈');

insert into Category(type)
values ('미국 영화');

insert into Category(type)
values ('해외');

insert into Category(type)
values ('어워드 수상');

insert into Category(type)
values ('인디');

insert into Category(type)
values ('범죄');

insert into Category(type)
values ('고전');

insert into Category(type)
values ('단편 영화');

9. MainCategory 테이블

insert into MainCategory(categoryIdx)
values (1), (2), (3), (4), (5), (6), (7), (8), (9), (10), (11), (12), (13), (14), (15), (16), (17), (18), (19);

10. SeriesCategory 테이블

insert into SeriesCategory(categoryIdx)
values (20), (21), (22), (23), (13), (24), (5), (7), (8), (4), (10), (25), (9), (26), (27), (28), (19);

11. MovieCategory 테이블

insert into MovieCategory(categoryIdx)
values (1), (29), (30), (31), (32), (6), (14), (4), (5), (7), (10), (9), (11), (12), (8), (33), (15), (18), (34), (35), (19);

12. Feature 테이블

insert into Feature(type)
values ('액션 대폭발');
insert into Feature(type)
values ('능수능란한');
insert into Feature(type)
values ('액션 스릴러');
insert into Feature(type)
values ('살인 청부업자');
insert into Feature(type)
values ('미국 작품');
insert into Feature(type)
values ('긴장감 넘치는');
insert into Feature(type)
values ('미스터리');
insert into Feature(type)
values ('서서히 조여오는 긴장감');
insert into Feature(type)
values ('부패 경찰');
insert into Feature(type)
values ('힐링');
insert into Feature(type)
values ('감명을 주는');
insert into Feature(type)
values ('드라마 장르');
insert into Feature(type)
values ('법정');
insert into Feature(type)
values ('한국 작품');
insert into Feature(type)
values ('진심 어린');
insert into Feature(type)
values ('역경을 넘어');
insert into Feature(type)
values ('거부할 수 없는 이끌림');
insert into Feature(type)
values ('로맨틱');
insert into Feature(type)
values ('사극');
insert into Feature(type)
values ('멀티캐스팅');
insert into Feature(type)
values ('어두운');
insert into Feature(type)
values ('액션');
insert into Feature(type)
values ('도박');
insert into Feature(type)
values ('위장경찰');
insert into Feature(type)
values ('스릴러');
insert into Feature(type)
values ('연쇄살인범');
insert into Feature(type)
values ('도서 원작');
insert into Feature(type)
values ('경찰, 형사, 탐정');
insert into Feature(type)
values ('리얼리티 시리즈');
insert into Feature(type)
values ('복수');
insert into Feature(type)
values ('결혼');
insert into Feature(type)
values ('시리즈');
insert into Feature(type)
values ('흥미진진');
insert into Feature(type)
values ('야구');
insert into Feature(type)
values ('감정을 파고드는');
insert into Feature(type)
values ('사기');
insert into Feature(type)
values ('서사극');
insert into Feature(type)
values ('중국 제국 배경');
insert into Feature(type)
values ('중국 본토 작품');
insert into Feature(type)
values ('감상적');
insert into Feature(type)
values ('음악');
insert into Feature(type)
values ('또 다른 주인공, OST');
insert into Feature(type)
values ('쇼비즈');
insert into Feature(type)
values ('키즈 콘텐츠');
insert into Feature(type)
values ('걸파워');
insert into Feature(type)
values ('동물은 우리의 친구');
insert into Feature(type)
values ('17세기');
insert into Feature(type)
values ('아드레날린 폭발');
insert into Feature(type)
values ('강렬한 비주얼');
insert into Feature(type)
values ('우정');
insert into Feature(type)
values ('1920년대');
insert into Feature(type)
values ('응원하고픈');
insert into Feature(type)
values ('항공기 납치');
insert into Feature(type)
values ('섬뜩한');
insert into Feature(type)
values ('피로 물든');
insert into Feature(type)
values ('영화, SF');
insert into Feature(type)
values ('좀비');
insert into Feature(type)
values ('청춘 영화');
insert into Feature(type)
values ('비운의 천재');
insert into Feature(type)
values ('서울 이야기');
insert into Feature(type)
values ('아이들을 위한 노래 콘텐츠');
insert into Feature(type)
values ('발상의 전환');
insert into Feature(type)
values ('디스토피아');
insert into Feature(type)
values ('사이버펑크');
insert into Feature(type)
values ('현상금 사냥꾼');
insert into Feature(type)
values ('폭력적인');
insert into Feature(type)
values ('사라진 기억');
insert into Feature(type)
values ('위트 있는');
insert into Feature(type)
values ('유쾌 발랄');
insert into Feature(type)
values ('시트콤');
insert into Feature(type)
values ('사랑스러운 루저');
insert into Feature(type)
values ('부패');
insert into Feature(type)
values ('백상예술대상 후보작');
insert into Feature(type)
values ('권력에 대한 저항');
insert into Feature(type)
values ('코미디');
insert into Feature(type)
values ('익살스러운');
insert into Feature(type)
values ('색다른');

13. NewHotFeature 테이블

insert into NewHotFeature(featureIdx, contentIdx)
values (1, 30), (66, 30), (3, 30), (67, 30), (14, 30), (68, 6), (69, 6), (70, 6), (20, 6), (71, 6), (5, 6), (12, 4), (72, 4), (14, 4), (73, 4), (74, 4),
(75, 3), (10, 1), (11, 1), (12, 1), (13, 1), (14, 1), (15, 1), (16, 1), (21, 7), (6, 7), (22, 7), (23, 7), (14, 7), (24, 7), (25, 7), (17, 5), (18, 5),
(19, 5), (10, 5), (16, 5), (14, 5), (6, 18), (25, 18), (26, 18), (14, 18), (27, 18), (28, 18), (29, 14), (14, 14), (6, 19), (25, 19), (8, 19), (28, 19),
(12, 12), (20, 12), (30, 12), (14, 12), (31, 12), (32, 12), (11, 15), (33, 15), (29, 15), (34, 15), (14, 15), (6, 44), (35, 44), (25, 44), (20, 44),
(36, 44), (14, 44), (33, 13), (18, 13), (37, 13), (38, 13), (39, 13), (27, 13), (1, 9), (2, 9), (3, 9), (4, 9), (5, 9), (40, 24), (35, 24), (41, 24),
(42, 24), (43, 24), (5, 24), (6, 10), (7, 10), (8, 10), (9, 10), (15, 23), (33, 23), (44, 23), (45, 23), (46, 23), (47, 23), (48, 25), (1, 25), (49, 25),
(50, 25), (51, 25), (52, 16), (6, 16), (3, 16), (53, 16), (5, 16), (54, 11), (55, 11), (56, 11), (20, 11), (57, 11), (5, 11), (10, 26), (11, 26), 
(58, 26), (59, 26), (60, 26), (14, 26), (61, 27), (42, 27), (43, 27), (5, 27), (62, 17), (63, 17), (64, 17), (49, 17), (65, 17);

14. Top10Series 테이블

insert into Top10Series(contentIdx, ranking)
values (1, 1);
insert into Top10Series(contentIdx, ranking)
values (7, 2);
insert into Top10Series(contentIdx, ranking)
values (5, 3);
insert into Top10Series(contentIdx, ranking)
values (18, 4);
insert into Top10Series(contentIdx, ranking)
values (14, 5);
insert into Top10Series(contentIdx, ranking)
values (19, 6);
insert into Top10Series(contentIdx, ranking)
values (12, 7);
insert into Top10Series(contentIdx, ranking)
values (15, 8);
insert into Top10Series(contentIdx, ranking)
values (44, 9);
insert into Top10Series(contentIdx, ranking)
values (13, 10);

15. Top10Movie 테이블

insert into Top10Movie(contentIdx, ranking)
values (9, 1);
insert into Top10Movie(contentIdx, ranking)
values (24, 2);
insert into Top10Movie(contentIdx, ranking)
values (10, 3);
insert into Top10Movie(contentIdx, ranking)
values (23, 4);
insert into Top10Movie(contentIdx, ranking)
values (25, 5);
insert into Top10Movie(contentIdx, ranking)
values (16, 6);
insert into Top10Movie(contentIdx, ranking)
values (11, 7);
insert into Top10Movie(contentIdx, ranking)
values (26, 8);
insert into Top10Movie(contentIdx, ranking)
values (27, 9);
insert into Top10Movie(contentIdx, ranking)
values (17, 10);

16. Hot 테이블

insert into Hot(contentIdx)
values (6);
insert into Hot(contentIdx)
values (4);

17. News 테이블

insert into News(contentIdx, openDate)
values(30, '8월 05 금요일');

18. Actor 테이블

insert into Actor(name)
values ('토미 리 존스'), ('하비에르 바르뎀'), ('조시 브롤린'), ('우디 해럴슨'),
('켈리 맥도널드'), ('개릿 딜라헌트'), ('테스 하퍼'), ('베리 코빈'), ('스티븐 루트'),
('로저 보이스'), ('베스 그랜트');

insert into Actor(name)
values ('카미야 히로시'), ('오노 다이스케'), ('시마자키 노부나가'), ('히노 사토시'),
('하나에 나츠키'), ('카야노 아이'), ('타무라 유카리'), ('우치다 마야야'), 
('이와타 미쓰오'), ('아이카와 리카코'), ('호소야 요시마사'), ('마에노 토모아키'),
('모리쿠보 쇼타로'), ('노지마 켄지'), ('야마데라 고이치'), ('타나카 리에'), 
('카지 유우키'), ('기타무라 에리'), ('MAO'), ('마츠카제 마사야'), ('아이자와 리사');

19. ContentActor 테이블

insert into ContentActor(actorIdx, contentIdx)
values (1, 42), (2, 42), (3, 42), (4, 42), (5, 42), (6, 42), (7, 42),
(8, 42), (9, 42), (10, 42), (11, 42);

insert into ContentActor(actorIdx, contentIdx)
values (12, 2), (13, 2), (14, 2), (15, 2), (16, 2), (17, 2), (18, 2),
(19, 2), (20, 2), (21, 2), (22, 2), (23, 2), (24, 2), (25, 2),
(26, 2), (27, 2), (28, 2), (29, 2), (30, 2), (31, 2), (32, 2);

20. Producer 테이블

insert into Producer(name)
values ('이선 코언'), ('조엘 코언');

21. ContentProducer 테이블

insert into ContentProducer(producerIdx, contentIdx)
values (1, 42), (2, 42);

22. Writer 테이블`

insert into Writer(name)
values ('이선 코언'), ('조엘 코언');

23. ContentWriter 테이블

insert into ContentWriter(writerIdx, contentIdx)
values (1, 42), (2, 42);

24. Genre 테이블

insert into Genre(type)
values ('미국 영화'), ('도서 원작 영화'), ('스릴러 영화');

insert into Genre(type)
values ('일본 작품'), ('망가 원작 시리즈'), ('학교 배경 애니'), 
('일본 소년 만화를 만나다'), ('SF & 판타지 애니'), ('애니 시리즈');

25. ContentGenre 테이블

insert into ContentGenre(genreIdx, contentIdx)
values (1, 42), (2, 42), (3, 42);

insert into ContentGenre(genreIdx, contentIdx)
values (4, 2), (5, 2), (6, 2), (7, 2), (8, 2), (9, 2);

26. MovieFeature 테이블

insert into MovieFeature(featureIdx, contentIdx)
values (66, 42), (21, 42), (6, 42);

27. VideoGrade 테이블

insert into VideoGrade(category)
values ('대사: 다소높음'), ('공포: 보통'), ('주제: 다소높음'), ('모방위험: 보통'),
('폭력성: 보통'), ('선정성: 보통');

28. ContentVideoGrade 테이블

insert into ContentVideoGrade(videoGradeIdx, contentIdx)
values (1, 2), (2, 2), (3, 2), (4, 2), (5, 2), (6, 2);

29. SeriesFeature 테이블

insert into SeriesFeature(featureIdx, contentIdx)
values (76, 2), (77, 2), (68, 2);

Netflix REST API 리스트업

1. /app/users : 회원가입 (POST)
2. /app/users/login : 로그인 (POST)
3. /app/users/:userIdx?keyword=profile : 프로필 생성 (POST)
4. /app/profiles/:profileIdx?keyword=pwd : 프로필 비밀번호 설정 (PATCH)
5. /app/profiles/:userIdx : 회원 전체 프로필 조회 (GET)
6. /app/profiles/:profileIdx : 프로필 비밀번호 검증 (POST)
7. /app/users/pwd : 회원 비밀번호 변경 (PATCH)
8. /app/profiles/:profileIdx : 프로필 설정 변경 (PUT)
9. /app/llikes/:profileIdx : 내가 찜한 콘텐츠 조회 (GET)
10. /app/searches : 최다 검색 조회 (GET)
11. /app/categories/main : 메인 카테고리 조회 (GET)
12. /app/categories/series : 시리즈 카테고리 조회 (GET)
13. /app/categories/movie : 영화 카테고리 조회 (GET)
14. /app/evaluations/:profileIdx : 콘텐츠 평가 및 취소 (POST)
15. /app/evaluations/:profileIdx?contentIdx : 콘텐츠 평가 조회 (GET)
16. /app/hot/:profileIdx : 모두의 인기 콘텐츠 조회 (GET)
17. /app/topSeries/:profileIdx : Top 10 시리즈 조회 (GET)
18. /app/topMovies/:profileIdx : Top 10 영화 조회 (GET)
19. /app/movies/:profileIdx : 영화 상세 페이지 조회 (GET)
20. /app/series/:profileIdx : 시리즈 상세 페이지 조회 (GET)

API 구현 (1개 완성 → 명세서 1개 작성)

※ spring boot로 개발하기 때문에 로컬환경에서 먼저 개발 (이유 : spring boot 무거움..)

• 로컬 환경에서도 포스트맨 확인해보기 -> 성공
  

1. 회원 가입 : [POST] /app/users
   [관련 화면]
   
   
   

• 포스트맨 성공 화면
  
• 이미 존재하는 이메일로 로그인 시도할 경우
  

2. 로그인 : [POST] /app/users/logIn
   [관련 화면]
   

• 포스트맨 성공 화면
  
• 없는 이메일 입력할 경우
  

3. 프로필 생성 : [POST] /app/users/:userIdx?keyword=profile
   [관련 화면]
   
   
   

• 포스트맨 Params 설정 화면
  
• 포스트맨 Body 설정 화면
  
• 포스트맨 성공 화면
  
• 닉네임을 입력하지 않은 경우
  

4. 프로필 비밀번호 설정 : [PATCH] /app/profiles/:profileIdx?keyword=pwd
   [관련 화면]
   
   

• 포스트맨 Params 설정 화면
  
• 포스트맨 Body 설정 화면
  
• 포스트맨 성공 화면
  
  → DB에 적용된 모습
  
• 비밀번호 4자리 보다 길게 입력한 경우
  

5. 회원 전체 프로필 조회 : [GET] /app/profiles/:userIdx
   [관련 화면]
   

• 포스트맨 성공 화면
  

6. 프로필 비밀번호 검증 : [POST] /app/profiles/:profileIdx
   [관련 화면]
   

• 포스트맨 Params 설정 화면
  
• 포스트맨 Body 설정 화면
  
• 포스트맨 성공 화면
  
• 비밀번호가 틀렸을 때
  

7. 회원 비밀번호 변경 : [PATCH] /app/users/pwd
   [관련 화면]
   

• 포스트맨 성공 화면
  
  → DB에서 변경된 비밀번호가 암호화돼서 저장된 것을 확인
  
• 이메일이 틀린 경우
  

8. 프로필 설정 변경 : [PUT] /app/profiles/:profileIdx
   [관련 화면]
   
   

• 변경 전 DB 상태
  
• 포스트맨 params 설정 화면
  
• 포스트맨 성공 화면 (프로필 이름, 프로필 이미지, 다음화 자동재생여부, 미리보기 재생여부, 설정 언어 변경)
  
• DB 변경된 모습
  

9. 내가 찜한 콘텐츠 조회 : [GET] /app/likes/:profileIdx
   [관련 화면]
   

• 포스트맨 params 설정 화면
  
• 포스트맨 성공 화면
  

10. 최다 검색 조회 : [GET] /app/searches
    [관련 화면]
    

• 포스트맨 성공 화면
  
  

11. 메인 카테고리 조회 : [GET] /app/categories/main
    [관련 화면]
    
    
    

• 포스트맨 성공 화면
  
  
  

12. 시리즈 카테고리 조회 : [GET] /app/categories/series
    [관련 화면]
    
    
    

• 포스트맨 성공 화면
  
  

13. 영화 카테고리 조회 : [GET] /app/categories/movie
    [관련 화면]
    
    
    

• 포스트맨 성공 화면
  
  
  

14. 콘텐츠 평가 및 취소 : [POST] /app/evaluations/:profileIdx (평가는 이런 식으로 합쳐주는 게 클라이언트 입장에서 편함)
    [관련 화면]
    1) 평가하기 전
    
    2) 평가하는 창
    
    3) 평가 완료 (최고예요로 평가)
    

• 포스트맨 params 설정 화면
  
• 포스트맨 성공 화면 (처음 해당 콘텐츠를 평가하는 경우 - likes가 3일 때 최고예요)
  
  • DB에 반영된 모습
    
• 포스트맨 성공 화면 (이미 평가했던 콘텐츠의 평가를 취소하는 경우 - likes가 0일 때 취소)
  
  • DB에 반영된 모습
    
• 포스트맨 성공 화면 (취소한 평가를 다시 좋아요로 평가하기 - likes가 2일 때 좋아요)
  
  • DB에 반영된 모습
    

15. 콘텐츠 평가 조회 : [GET] /app/evaluations/:profileIdx?contentIdx= -> 삭제 조치(시리즈 상세 페이지에서 한꺼번에 보내면 되기 떄문)
    [관련 화면]
    

• 포스트맨 성공 화면
  

16. 모두의 인기 콘텐츠 조회 : [GET] /app/hot/:profileIdx
    [관련 화면]
    
    

• 포스트맨 params 설정 화면
  
• 포스트맨 성공 화면
  
  

17. Top 10 시리즈 조회 : [GET] /app/topseries/:profileIdx
    [관련 화면]
    
    
    
    
    
    
    
    
    
    

• 포스트맨 params 설정 화면
  
• 포스트맨 성공 화면
  
  
  
  
  
  

18. Top 10 영화 조회 : [GET] /app/topmovies/:profileIdx
    [관련 화면]
    
    
    
    
    
    
    
    
    
    

• 포스트맨 params 설정 화면
  
• 포스트맨 성공 화면
  
  
  
  
  

19. 영화 상세 페이지 조회 : [GET] /app/movies/:profileIdx?contentIdx=
    [관련 화면]
    
    1) 더보기 눌렀을 때
    
    

• 포스트맨 params 설정 화면
  
• 포스트맨 성공 화면
  
  

20. 시리즈 상세 페이지 조회 : [GET] /app/series/:profileIdx?contentIdx=
    [관련 화면]
    
    1) 더보기 눌렀을 때
    
    
    2) 시즌 1 or 처음 들어왔을 때
    
    
    3) 시즌 2
    
    
    4) 시즌 3
    
    <몇 season인지 선택하지 않았을 때, 즉 상세 페이지 처음 들어왔을 때>

• 포스트맨 params 설정 화면
  
• 포스트맨 성공 화면
  
  
  
  

<몇 season인지 선택했을 때 - 시즌 2>

• 포스트맨 params 설정 화면
  
• 포스트맨 성공 화면
  
  
  
  

<몇 season인지 선택했을 때 - 시즌 3>

• 포스트맨 params 설정 화면
  
• 포스트맨 성공 화면
  
  
  

최종 쿼리 개수 : 45개

최종 API 명세서 (구글 스프레드시트)

https://docs.google.com/spreadsheets/d/1WjskdpspvkHjqqgWzxLSvAau8WobkimmFZqJTDu7kxs/edit#gid=0