drop database if exists covid_weekly;
create database covid_weekly;
use covid_weekly;

CREATE TABLE DT_SPACE
(
    COUNTRY    varchar(1000) PRIMARY KEY,
    CONTINENT  text,
    POPULATION text
);

CREATE TABLE DT_TIME
(
    WEEK  varchar(1000)  PRIMARY KEY,
    YEAR  text,
    MONTH text
);

CREATE TABLE FT
(
    WEEK    varchar(1000) references DT_TIME(WEEK),
    COUNTRY varchar(1000)  references DT_SPACE(COUNTRY),
    DEATHS  int,
    CASES   int,
    PRIMARY KEY (WEEK, COUNTRY)
);
