Marketing_Movie
Tables (11)
company
- company_code — int — Primary key — NOT NULL — SERIAL
- company_name — varchar(50) — NOT NULL
- collect_date — int — YYYYMMDD
daily_box_office
- box_office_id — int — Primary key — NOT NULL
- movie_code — varchar(30) — Foreign key → movie.movie_code — NOT NULL — 영화 상세 정보
- rank — smallint — NOT NULL
- rank_variance — smallint — NOT NULL
- rank_old_new — char(3) — NOT NULL — OLD or NEW
- sales_amount — bigint — NOT NULL
- sales_variance — bigint — NOT NULL
- sales_accumulation — bigint — NOT NULL
- audience_count — int — NOT NULL
- audience_variance — int — NOT NULL
- audience_change — int — NOT NULL
- audience_accumulation — int — NOT NULL
- screen_count — int — NOT NULL
- show_count — int — NOT NULL
- collect_date — int — NOT NULL — YYYYMMDD
- year — int — 파티션 키
- month — int — 파티션 키
- day — int — 파티션 키
movie
- movie_code — varchar(30) — Primary key — NOT NULL
- movie_name_ko — varchar(50) — NOT NULL
- movie_name_en — varchar(50) — NOT NULL
- production_year — int — NOT NULL — YYYY
- open_date — int — NOT NULL — YYYYMMDD
- type_name — varchar(20) — NOT NULL
- production_status_name — varchar(20) — NOT NULL
- representative_nation_name — varchar(20) — NOT NULL
- representative_genre_name — varchar(20) — NOT NULL
- collect_date — int — NOT NULL — YYYYMMDD
- year — int — NOT NULL — 파티션 키
- month — int — NOT NULL — 파티션 키
movie_Info
- movie_code — varchar(30) — Foreign key → movie.movie_code — NOT NULL — 영화 상세 정보
- show_time — smallint — NOT NULL
- show_type_group_name — varchar(20) — NOT NULL
- show_type_name — varchar(20) — NOT NULL
- audit_number — varchar(30) — NOT NULL
- watch_grade_name — varchar(20) — NOT NULL
- nations_sales_accumulation — bigint — NOT NULL
- nations_audience_count — int — NOT NULL
- nations_screen_count — int — NOT NULL
- collect_date — int — NOT NULL — YYYYMMDD
- year — int — NOT NULL — 파티션 키
- month — int — NOT NULL — 파티션 키
movie_company
- movie_code — varchar(30) — Foreign key → movie.movie_code — NOT NULL — 영화 상세 정보
- company_code — int — Foreign key → company.company_code — NOT NULL — SERIAL
movie_people
- movie_code — varchar(30) — Foreign key → movie.movie_code — NOT NULL — 영화 상세 정보
- people_code — varchar(20) — Foreign key → people.people_code — NOT NULL
people
- people_code — varchar(20) — Primary key — NOT NULL
- people_name_ko — varchar(30) — NOT NULL
- people_name_en — varchar(30)
- sex — varchar(5) — NOT NULL
- representative_role_name — varchar(20) — NOT NULL
- collect_date — int — YYYYMMDD
realtime_booking
- movie_code — varchar(30) — Foreign key → movie.movie_code — NOT NULL — 영화 상세 정보
- rank — tinyint — NOT NULL
- reservation_share — decimal(5, 1) — NOT NULL
- reservation_amount — bigint — NOT NULL
- sales_accumulation — bigint — NOT NULL
- reservation_count — int — NOT NULL
- audience_accumulation — int — NOT NULL
- collect_date — int — NOT NULL — YYYYMMDD
- year — int — 파티션 키
- month — int — 파티션 키
- day — int — 파티션 키
review
- review_id — int — Primary key — NOT NULL — SERIAL
- movie_code — varchar(30) — Foreign key → movie.movie_code — NOT NULL — 영화 상세 정보
- username — varchar(20) — NOT NULL
- gender — char(1) — NOT NULL
- rating — tinyint — NOT NULL
- content — text — NOT NULL
- like_count — int — NOT NULL
- review_date — int — NOT NULL — YYYYMMDD
- collect_date — int — NOT NULL — YYYYMMDD
- year — int — 파티션 키
- month — int — 파티션 키
- day — int — 파티션 키
youtube_channel
- channel_id — int — Primary key — NOT NULL — SERIAL 파티션 키
- handle — varchar(30) — NOT NULL
- channel_name — varchar(30) — NOT NULL
- collect_date — int — NOT NULL — YYYYMMDD 파티션 키
youtube_video
- video_id — varchar(30) — Primary key — NOT NULL
- channel_id — int — Foreign key → youtube_channel.channel_id — NOT NULL — SERIAL 파티션 키
- video_title — varchar(100) — NOT NULL
- published_date — int — NOT NULL — YYYYMMDD
- view_count — int — NOT NULL
- like_count — int — NOT NULL
- comment_count — int — NOT NULL
- collect_date — int — NOT NULL — YYYYMMDD 파티션 키