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