CREATE TABLE Items (  	

id 	INTEGER,
title 	CHAR(20),
rating 	CHAR(5),
PRIMARY KEY (id),

);

CREATE TABLE Games (
type 		CHAR(15),
description	CHAR(30),
id 		INTEGER,
PRIMARY KEY (id),
FOREIGN KEY (id) REFERENCES Items ON DELETE CASCADE ON UPDATE CASCADE,
);

CREATE TABLE Movies (
year		INTEGER,
director	CHAR(15),
genre		CHAR(10),
id 		INTEGER,
PRIMARY KEY (id),
FOREIGN KEY (id) REFERENCES Items ON DELETE CASCADE ON UPDATE CASCADE,
);

CREATE TABLE Customers (

phone 		CHAR(10),
name 		CHAR(30),
address 	CHAR(50),
birthdate 	DATE,
PRIMARY KEY (phone)

);

CREATE TABLE Rented (

phone 		CHAR(10),
id 		INTEGER, 
daterented 	DATE,
datedueback 	DATE,
PRIMARY KEY(id),
FOREIGN KEY (id) REFERENCES Items ON DELETE NO ACTION ON UPDATE NO ACTION,
FOREIGN KEY (phone) REFERENCES Customers ON DELETE NO ACTION ON UPDATE NO ACTION,
);

CREATE TABLE Employees (
sin		CHAR(11),
name		CHAR(20),
since		DATE,
salary		INTEGER,
PRIMARY KEY(sin),
);

CREATE TABLE Shifts (
shiftid		INTEGER,
starttime	DATE,
endtime		DATE,
PRIMARY KEY(shiftid),
);

CREATE TABLE Works (
sin		CHAR(11) NOT NULL,
shiftid		INTEGER,
PRIMARY KEY (sin, shiftid),
FOREIGN KEY (sin) REFERENCES Employees ON DELETE NO ACTION ON UPDATE NO ACTION, 
FOREIGN KEY (shiftid) REFERENCES Shifts ON DELETE NO ACTION ON UPDATE NO ACTION,
);