CREATE TABLE conference(
title VARCHAR(200) NOT NULL PRIMARY KEY,
orderNumber VARCHAR(100),
venue VARCHAR(200),
year VARCHAR(100)
);

CREATE TABLE paper(
title VARCHAR(200) NOT NULL PRIMARY KEY,
abstract VARCHAR(200),
keywords VARCHAR(200),
contactAuthor VARCHAR(200),
contactEmail VARCHAR(200),
accepted VARCHAR(10)
);

CREATE TABLE paperAuthors(
paperTitle VARCHAR(200) NOT NULL,
authorName VARCHAR(200) NOT NULL,
PRIMARY KEY (paperTitle,authorName),
FOREIGN KEY (paperTitle) REFERENCES paper (title),
FOREIGN KEY (authorName) REFERENCES person (name)
);

CREATE TABLE person(
name VARCHAR(200) NOT NULL PRIMARY KEY,
title VARCHAR(200),
affiliation VARCHAR(200),
email VARCHAR(200)
);

CREATE TABLE registration(
name VARCHAR(200) NOT NULL PRIMARY KEY,
student VARCHAR(10),
inConference VARCHAR(10),
inWorkshop VARCHAR(10),
FOREIGN KEY (name) REFERENCES person (name)
);

CREATE TABLE workshopRegistration(
name VARCHAR(200) NOT NULL,
workshop VARCHAR(200) NOT NULL,
PRIMARY KEY (name,workshop),
FOREIGN KEY (name) REFERENCES person (name),
FOREIGN KEY (workshop) REFERENCES event (title)
);

CREATE TABLE event(
title VARCHAR(200) NOT NULL PRIMARY KEY,
room VARCHAR(100),
type VARCHAR(100),
website VARCHAR(200),
description VARCHAR(200),
startingTime VARCHAR(200),
endTime VARCHAR(200)
);

CREATE TABLE chair(
name VARCHAR(200) NOT NULL,
eventTitle VARCHAR(200) NOT NULL,
startingTime VARCHAR(200),
endTime VARCHAR(200),
PRIMARY KEY (name,eventTitle),
FOREIGN KEY (name) REFERENCES person (name),
FOREIGN KEY (eventTitle) REFERENCES event (title)
);

CREATE TABLE presentation(
name VARCHAR(200) NOT NULL,
event VARCHAR(100) NOT NULL,
title VARCHAR(200) NOT NULL,
startingTime VARCHAR(200) NOT NULL,
endTime VARCHAR(200) NOT NULL,
PRIMARY KEY (name,event,title),
FOREIGN KEY (name) REFERENCES person (name),
FOREIGN KEY (event) REFERENCES event (title),
FOREIGN KEY (title) REFERENCES paper (title)
);