DE_MOVIE_DW

Tables (10)

ACTORS

  • ACTOR_ID — INT — Primary key — NOT NULL
  • MOVIE_CODE — VARCHAR2(30 CHAR) — Foreign key → MOVIE_DETAIL.MOVIE_CODE — NOT NULL — 영화코드
  • ACTOR_NAME — VARCHAR2(30 CHAR) — 배우명

DAILY_BOXOFFICE

  • DBO_ID — INT — Primary key — NOT NULL
  • MOVIE_CODE — VARCHAR2(30 CHAR) — Foreign key → MOVIE_DETAIL.MOVIE_CODE — NOT NULL — 영화코드
  • MOVIE_NAME — VARCHAR2(100 CHAR) — 영화명
  • STD_DATE — VARCHAR2(30 CHAR) — 해당일
  • RANK — INT — 해당일_순위
  • SALES_AMT — INT — 해당일_매출액
  • SALES_SHARE — FLOAT — 해당일_상영작_매출총액대비_매출비율
  • AUDI_CNT — INT — 해당일_관객수
  • SCRN_CNT — INT — 해당일_상영_스크린수
  • SHOW_CNT — INT — 해당일_상영횟수

GENRE

  • GENRE_ID — INT — Primary key — NOT NULL
  • GENRE — VARCHAR2(30 CHAR) — 장르명

MOVIE_ACCUMULATE

  • MA_ID — INT — Primary key — NOT NULL
  • DBO_ID — INT — Foreign key → DAILY_BOXOFFICE.DBO_ID — NOT NULL
  • SALES_ACC — INT — 누적매출액
  • AUDI_ACC — INT — 누적관객수

MOVIE_COMPANY

  • MC_ID — INT — Primary key — NOT NULL
  • MOVIE_CODE — VARCHAR2(30 CHAR) — Foreign key → MOVIE_DETAIL.MOVIE_CODE — NOT NULL — 영화코드
  • COMPANY_CODE — VARCHAR2(30 CHAR) — 영화사코드
  • COMPANY_NAME — VARCHAR2(100 CHAR) — 영화사이름_국문
  • COMPANY_PART_NAME — VARCHAR2(30 CHAR) — 영화사분야명

MOVIE_DETAIL

  • MOVIE_CODE — VARCHAR2(30 CHAR) — Primary key — NOT NULL — 영화코드
  • MOVIE_NAME — VARCHAR2(100 CHAR) — 영화명
  • PRDT_YEAR — VARCHAR2(30 CHAR) — 제작연도
  • SHOW_TM — VARCHAR2(30 CHAR) — 상영시간
  • 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) — 관람등급명

MOVIE_GENRE

  • MG_ID — INT — Primary key — NOT NULL
  • MOVIE_CODE (MOVIE_CODE2) — VARCHAR2(30 CHAR) — Foreign key → MOVIE_DETAIL.MOVIE_CODE — NOT NULL — 영화코드
  • GENRE_ID — INT — Foreign key → GENRE.GENRE_ID — NOT NULL

MOVIE_SCORE

  • MS_ID — INT — Primary key — NOT NULL
  • MOVIE_CODE — VARCHAR2(30 CHAR) — Foreign key → MOVIE_DETAIL.MOVIE_CODE — NOT NULL — 영화코드
  • AUDI_SC — VARCHAR2(30 CHAR) — 관람객
  • EXPE_SC — VARCHAR2(30 CHAR) — 전문가
  • NETI_SC — VARCHAR2(30 CHAR) — 네티즌
  • STD_DATE — VARCHAR2(30 CHAR)

MOVIE_SEARCH_RATIO

  • MSR_ID — INT — Primary key — NOT NULL
  • MOVIE_CODE — VARCHAR2(30 CHAR) — Foreign key → MOVIE_DETAIL.MOVIE_CODE — NOT NULL — 영화코드
  • RATIO — FLOAT — 검색비율
  • WEEK — INT — 개봉주차
  • STD_DATE — VARCHAR2(30 CHAR)

MOVIE_URL

  • MU_ID — INT — Primary key — NOT NULL
  • MOVIE_CODE — VARCHAR2(30 CHAR) — Foreign key → MOVIE_DETAIL.MOVIE_CODE — NOT NULL — 영화코드
  • URL — VARCHAR2(100 CHAR) — 네이버_영화_URL