CREATE TABLE Date (
dateRep TEXT NOT NULL PRIMARY KEY, day INTEGER, month INTEGER, year INTEGER
);

CREATE TABLE Country (
geoId TEXT NOT NULL PRIMARY KEY, countriesAndTerritories TEXT, countryterritoryCode TEXT,
continentExp TEXT, popData2018 INTEGER
);

CREATE TABLE [Virus] (
dateRep TEXT, geoId TEXT, cases TEXT, deaths INTEGER,
PRIMARY KEY(dateRep, geoId),
CONSTRAINT fk_date
	FOREIGN KEY (dateRep)
	REFERENCES date(dateRep),
CONSTRAINT fk_country_id
	FOREIGN KEY (geoId)
	REFERENCES country(geoId)
);

CREATE INDEX dateIndex ON Date(dateRep);
CREATE INDEX dateLocation ON Virus(dateRep, geoId);
CREATE INDEX locationName ON Country(countriesAndTerritories);
CREATE INDEX locationId ON Country(geoId);