CREATE TABLE dblpDoc(
title VARCHAR(100) NOT NULL PRIMARY KEY,
booktitle VARCHAR(100),
pages VARCHAR(50),
year VARCHAR(50),
address VARCHAR(50),
journal VARCHAR(50),
volume VARCHAR(50),
number VARCHAR(50),
month VARCHAR(50),
url VARCHAR(50),
ee VARCHAR(50),
cdrom VARCHAR(100),
publisher VARCHAR(200),
note VARCHAR(200),
crossref VARCHAR(100),
isbn VARCHAR(100),
series VARCHAR(100),
school VARCHAR(200),
chapter VARCHAR(100),
FOREIGN KEY (journal) REFERENCES dblpDoc (title),
FOREIGN KEY (publisher) REFERENCES dblpPublisher (publisherName)
);

CREATE TABLE dblpAuthor(
authorName VARCHAR(100) NOT NULL PRIMARY KEY,
authorAddress VARCHAR(100)
);

CREATE TABLE dblpPublisher(
publisherName VARCHAR(100) NOT NULL PRIMARY KEY,
publisherAddress VARCHAR(100)
);

CREATE TABLE dblpCites(
citingDoc VARCHAR(100) NOT NULL,
citedDoc VARCHAR(100) NOT NULL,
PRIMARY KEY (citingDoc,citedDoc),
FOREIGN KEY (citingDoc) REFERENCES dblpDoc (title),
FOREIGN KEY (citedDoc) REFERENCES dblpDoc (title)
);

CREATE TABLE dblpWrites(
author VARCHAR(100) NOT NULL,
doc VARCHAR(100) NOT NULL,
PRIMARY KEY (author,doc),
FOREIGN KEY (author) REFERENCES dblpAuthor (authorName),
FOREIGN KEY (doc) REFERENCES dblpDoc (title)
);