DE_MOVIE_DM

Tables (12)

ACTOR

  • ACTOR_ID — INT — Primary key — NOT NULL
  • MOVIE_CODE — VARCHAR2(30 CHAR) — Foreign key → MOVIE.MOVIE_CODE — NOT NULL
  • MOVIE_NAME — VARCHAR2(100 CHAR) — 영화이름
  • ACTOR_NAME — VARCHAR2(30 CHAR) — 배우이름
  • HIT_GRADE — CHAR(2 CHAR) — 흥행등급

COMPANY

  • COMPANY_ID — INT — Primary key — NOT NULL
  • MOVIE_CODE — VARCHAR2(30 CHAR) — Foreign key → MOVIE.MOVIE_CODE — NOT NULL
  • COMPANY_NAME — VARCHAR2(100 CHAR) — 영화사이름
  • COMPANY_TYPE — VARCHAR2(30 CHAR) — 영화사종류
  • HIT_GRADE — CHAR(2 CHAR) — 흥행등급

GENRE

  • GENRE_ID — INT — Primary key — NOT NULL
  • MOVIE_CODE — VARCHAR2(30 CHAR) — Foreign key → MOVIE.MOVIE_CODE — NOT NULL
  • GENRE_NAME — VARCHAR2(30 CHAR) — 장르이름
  • HIT_GRADE — CHAR(2 CHAR) — 흥행등급

MOVIE

  • MOVIE_CODE — VARCHAR2(30 CHAR) — Primary key — NOT NULL
  • MOVIE_NAME — VARCHAR2(100 CHAR) — 영화제목
  • SHOW_TM — INT — 상영시간
  • OPEN_DATE — VARCHAR2(30 CHAR) — 개봉일
  • TYPE_NAME — VARCHAR2(30 CHAR) — 영화유형명
  • NATION_NAME — VARCHAR2(30 CHAR) — 제작국가
  • DIRECTOR — VARCHAR2(30 CHAR) — 영화감독명
  • WATCH_GRADE_NAME — VARCHAR2(30 CHAR) — 관람등급명
  • DIST_NAME — VARCHAR2(100 CHAR) — 배급사
  • PEAK_YN — CHAR(2 CHAR) — 성수기여부
  • GENRE — VARCHAR2(30 CHAR) — 대표장르
  • HIT_GRADE — CHAR(2 CHAR) — 흥행등급

MOVIE_AUDI

  • AUDI_ID — INT — Primary key — NOT NULL
  • MOVIE_CODE — VARCHAR2(30 CHAR) — Foreign key → MOVIE.MOVIE_CODE — NOT NULL
  • MOVIE_NAME — VARCHAR2(100 CHAR) — 영화제목
  • OPEN_AUDI_CNT — INT — 게봉일관객수
  • SEC_AUDI_INCREASE — FLOAT — 2주차관객수증가율
  • HIT_GRADE — CHAR(2) — 흥행등급

MOVIE_HIT

  • MOVIE_CODE — VARCHAR2(30 CHAR) — Primary key — NOT NULL — 영화코드
  • MOVIE_NAME — VARCHAR2(30 CHAR) — 영화제목
  • TOT_AUDI_CNT — INT — 총관객수
  • HIT_GRADE — CHAR(2 CHAR) — 흥행등급

MOVIE_RANK

  • RANK_ID — INT — Primary key — NOT NULL
  • MOVIE_CODE — VARCHAR2(30 CHAR) — Foreign key → MOVIE.MOVIE_CODE — NOT NULL
  • MOVIE_NAME — VARCHAR2(100 CHAR) — 영화제목
  • OPEN_FIRST_RANK_YN — CHAR(2 CHAR) — 개봉일1위여부
  • SEC_WEEK_RANK_DROP — CHAR(2 CHAR) — 2주차순위하락여부
  • HIT_GRADE — CHAR(2 CHAR) — 흥행등급

MOVIE_SALES

  • SALES_ID — INT — Primary key — NOT NULL
  • MOVIE_CODE — VARCHAR2(30 CHAR) — Foreign key → MOVIE.MOVIE_CODE — NOT NULL
  • MOVIE_NAME — VARCHAR2(100 CHAR) — 영화제목
  • OPEN_SALES_SHARE — FLOAT — 개봉일매출점유율
  • AVG_SALES_SHARE — FLOAT — 평균매출점유율
  • TOT_SALES — INT — 총매출액
  • HIT_GRADE — CHAR(2) — 흥행등급

MOVIE_SCORE

  • SCORE_ID — INT — Primary key — NOT NULL
  • MOVIE_CODE — VARCHAR2(30 CHAR) — Foreign key → MOVIE.MOVIE_CODE — NOT NULL
  • MOVIE_NAME — VARCHAR2(100 CHAR) — 영화제목
  • EXPE_SCORE — FLOAT — 전문가평점
  • AUDI_SCORE — FLOAT — 관람객평점
  • NETI_SCORE — FLOAT — 네티즌평점
  • HIT_GRADE — CHAR(2 CHAR) — 흥행등급

MOVIE_SCRN

  • SCRN_ID — INT — Primary key — NOT NULL
  • MOVIE_CODE — VARCHAR2(30 CHAR) — Foreign key → MOVIE.MOVIE_CODE — NOT NULL
  • MOVIE_NAME — VARCHAR2(100 CHAR) — 영화제목
  • OPEN_SCRN_CNT — INT — 개봉일스크린수
  • AVG_SCRN_CNT — FLOAT — 평균스크린수
  • HIT_GRADE — CHAR(2 CHAR) — 흥행등급

MOVIE_SEARCH

  • SEARCH_ID — INT — Primary key — NOT NULL
  • MOVIE_CODE — VARCHAR2(30 CHAR) — Foreign key → MOVIE.MOVIE_CODE — NOT NULL
  • MOVIE_NAME — VARCHAR2(100 CHAR) — 영화제목
  • FIRST_SEARCH_RATIO — FLOAT — 1주차검색비율
  • SECOND_SEARCH_RATIO — FLOAT — 2주차검색비율
  • THIRD_SEARCH_RATIO — FLOAT — 3주차검색비율
  • HIT_GRADE — CHAR(2 CHAR) — 흥행등급

MOVIE_SHOW

  • SHOW_ID — INT — Primary key — NOT NULL
  • MOVIE_CODE — VARCHAR2(30 CHAR) — Foreign key → MOVIE.MOVIE_CODE — NOT NULL
  • MOVIE_NAME — VARCHAR2(100 CHAR) — 영화제목
  • OPEN_SHOW_CNT — INT — 개봉일상영횟수
  • AVG_SHOW_CNT — FLOAT — 평균상영횟수
  • HIT_GRADE — CHAR(2) — 흥행등급