eda_project_1

테이블 (5)

OTT_after_COVID19 (Untitled2)

  • ott_key (Key) — int — 기본 키 — NOT NULL
  • ott_name (Field) — char
  • ott_year (Field4) — year
  • ott_sales (Field2) — int
  • ott_take (Field3) — int
  • before_key (Key2) — int — 외래 키 → movie_after_COVID19.before_key — NOT NULL
  • movie_Key (Key22) — 외래 키 → movie_after_COVID19.movie_Key — NOT NULL

movie_after_COVID19 (CopyOfUntitled)

  • before_key (Key) — int — 기본 키 — NOT NULL
  • movie_Key (Key2) — 외래 키 → movie_chart.movie_Key — NOT NULL
  • after_rank (Field8) — int
  • after_name (Field5) — char
  • after_year (Field2) — year
  • after_take (Field3) — int
  • after_audience (Field) — int
  • after_screen (Field6) — int
  • after_screening_number (Field4) — int
  • after_genre (Field7) — varchar

movie_before_COVID19 (Untitled)

  • after_Key (Key) — 기본 키 — NOT NULL
  • movie_Key (Key2) — 외래 키 → movie_chart.movie_Key — NOT NULL
  • before_rank (rank) — int
  • before_name (Field5) — char
  • before_year (Field2) — year
  • before_take (Field3) — int
  • before_audience (Field) — int
  • before_screen (Field6) — int
  • before_screening_number (Field4) — int
  • before_genre (Field7) — varchar

movie_chart (CopyOfUntitled2)

  • movie_Key (Key) — 기본 키 — NOT NULL
  • movie_rank (rank) — int
  • movie_name (Field5) — char
  • movie_date (Field2) — date
  • movie_take (Field3) — int
  • movie_audience (Field) — int
  • movie_screen (Field6) — int
  • movie_screening_number (Field4) — int
  • movie_genre (Field7) — varchar

코로나 이후 OTT 매출액과 영화 (OTT_movie_info)

  • ott_movie_Key (Key) — int — 기본 키 — NOT NULL
  • before_key (Key2) — int — 외래 키 → movie_after_COVID19.before_key — NOT NULL
  • movie_Key (Key22) — 외래 키 → movie_after_COVID19.movie_Key — NOT NULL
  • ott_key (Key3) — int — 외래 키 → OTT_after_COVID19.ott_key — NOT NULL
  • covid_movie_rank (Field8) — int
  • covid_movie_name (Field5) — char
  • covid_movie_year (Field2) — year
  • covid_movie_take (Field3) — int
  • covid_movie_audience (Field) — int
  • covid_movie_screen (Field6) — int
  • covid_movie_number (Field4) — int
  • covid_movie_genre (Field7) — varchar
  • covid_ott_name (Field9) — char
  • covid_ott_sales (Field10) — int
  • covid_ott_take (Field11) — int