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