CREATE TABLE Party ( 
	size INTEGER,
	dateEntered DATE,
	id VARCHAR(30) NOT NULL,
	name VARCHAR(30),
	Restaurant_id VARCHAR(30));


CREATE TABLE Restaurant ( 
	id VARCHAR(30) NOT NULL,
	name VARCHAR(30),
	open SMALLINT);


CREATE TABLE Server ( 
	clockinTime DATE,
	name VARCHAR(30),
	guestsServed INTEGER,
	id VARCHAR(30) NOT NULL,
	isAtWork SMALLINT,
	hoursWorked INTEGER,
	Restaurant_id VARCHAR(30) NOT NULL);


CREATE TABLE Table ( 
	clean SMALLINT,
	id VARCHAR(30) NOT NULL,
	capacity INTEGER,
	name VARCHAR(30),
	Party_id VARCHAR(30),
	Restaurant_id VARCHAR(30) NOT NULL,
	Server_id VARCHAR(30));

ALTER TABLE Party ADD CONSTRAINT PartyPK PRIMARY KEY ( id);

ALTER TABLE Restaurant ADD CONSTRAINT RestaurantPK PRIMARY KEY ( id);

ALTER TABLE Server ADD CONSTRAINT ServerPK PRIMARY KEY ( id);

ALTER TABLE Table ADD CONSTRAINT TablePK PRIMARY KEY ( id);

ALTER TABLE Table
 ADD CONSTRAINT Seating  FOREIGN KEY (Party_id)
	 REFERENCES Party;

ALTER TABLE Table
 ADD CONSTRAINT AllTables  FOREIGN KEY (Restaurant_id)
	 REFERENCES Restaurant;

ALTER TABLE Table
 ADD CONSTRAINT ServerResponsibility  FOREIGN KEY (Server_id)
	 REFERENCES Server;

ALTER TABLE Server
 ADD CONSTRAINT ServerStaff  FOREIGN KEY (Restaurant_id)
	 REFERENCES Restaurant;

ALTER TABLE Party
 ADD CONSTRAINT WaitingList  FOREIGN KEY (Restaurant_id)
	 REFERENCES Restaurant;