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) — 흥행등급