L0 ERD

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
  • 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
  • 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 — string — 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 — string — NOT NULL — YYYYMMDD
  • collect_hour — string — 파티션 키

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 — string — NOT NULL — YYYYMMDD
  • collect_hour — string — 파티션 키

youtube_channel

  • channel_id — int — Primary key — NOT NULL — SERIAL 파티션 키
  • handle — varchar(30) — NOT NULL
  • channel_name — varchar(30) — NOT NULL
  • collect_date — string — 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 — string — NOT NULL — YYYYMMDD 파티션 키