#Aneto data repository 

CREATE TABLE ref(
title VARCHAR(100) NOT NULL PRIMARY KEY,
collaborators VARCHAR(100),
allAuthors VARCHAR(200),
publishing VARCHAR(100),
edition VARCHAR(100),
formatPages VARCHAR(50),
titleCollection VARCHAR(200),
otherTCollection VARCHAR(200),
subject VARCHAR(100),
sign VARCHAR(100),
abreviateTitle VARCHAR(20),
isbnNrContr VARCHAR(30),
classification VARCHAR(20),
note VARCHAR(20),
notes VARCHAR(200),
periodicity VARCHAR(10),
beginingCession VARCHAR(10),
library VARCHAR(50),
place VARCHAR(20),
numberCopies VARCHAR(20),
numberLent VARCHAR(20),
kind VARCHAR(20),
language VARCHAR(20),
data VARCHAR(20),
state VARCHAR(20),
authorFirm VARCHAR(50),
otherFirms VARCHAR(50),
collaborator VARCHAR(50),
country VARCHAR(50)
);

CREATE TABLE ref(
id VARCHAR(200) NOT NULL PRIMARY KEY,
address VARCHAR(200),
annote VARCHAR(200),
author VARCHAR(200),
booktitle VARCHAR(200),
chapter VARCHAR(200),
crossref VARCHAR(100),
edition VARCHAR(200),
editor VARCHAR(200),
howpublished VARCHAR(200),
institution VARCHAR(200),
keywords VARCHAR(200),
journal VARCHAR(100),
month VARCHAR(200),
number VARCHAR(200),
organization VARCHAR(200),
pages VARCHAR(100),
publisher VARCHAR(100),
school VARCHAR(200),
series VARCHAR(100),
title VARCHAR(100),
type VARCHAR(100),
volume VARCHAR(100),
year VARCHAR(100)
);

CREATE TABLE doc(
docAuthor VARCHAR(100),
docSubject VARCHAR(100),
docNotes VARCHAR(200),
docOtherAuthors VARCHAR(200),
docTitle VARCHAR(200) NOT NULL PRIMARY KEY,
docOtherTitles VARCHAR(200),
docSeries VARCHAR(200),
docCorporateName VARCHAR(200),
docDescription VARCHAR(200)
);

CREATE TABLE pub(
pubId VARCHAR(100) NOT NULL PRIMARY KEY,
pubSubjects VARCHAR(200),
pubAuthors VARCHAR(200),
putTitle VARCHAR(200),
pubPublishIn VARCHAR(200),
pubType VARCHAR(200),
pubDocument VARCHAR(200)
);

CREATE TABLE conference(
conferenceName VARCHAR(200) NOT NULL PRIMARY KEY,
conferenceDate VARCHAR(100),
conferenceAddress VARCHAR(200)
);

CREATE TABLE agent(
agentName VARCHAR(200) NOT NULL PRIMARY KEY,
agentPublisherAddress VARCHAR(200)
);

CREATE TABLE document(
documentLoc VARCHAR(50),
documentIsbn VARCHAR(50),
documentAuthor VARCHAR(50),
documentConference VARCHAR(50),
documentEdition VARCHAR(50),
documentPages VARCHAR(50),
documentDate VARCHAR(50),
documentPublisher VARCHAR(50),
documentSeriesTitle VARCHAR(50),
documentTitle VARCHAR(50) NOT NULL PRIMARY KEY,
documentType VARCHAR(50),
FOREIGN KEY (documentAuthor) REFERENCES agent (agentName),
FOREIGN KEY (documentConference) REFERENCES conference (conferenceName),
FOREIGN KEY (documentPublisher) REFERENCES agent (agentName)
);

#UGA-library Data repository

CREATE TABLE record(
type VARCHAR(50),
dateOfPublication VARCHAR(50),
illustration VARCHAR(50),
targetAudience VARCHAR(50),
brailler VARCHAR(50),
fiction VARCHAR(50),
biography VARCHAR(50),
natureOfContents VARCHAR(50),
language VARCHAR(50),
ISBN VARCHAR(50),
ISSN VARCHAR(50),
catalogingSource VARCHAR(50),
author VARCHAR(50),
authorDates VARCHAR(50),
corporateName VARCHAR(100),
conferenceName VARCHAR(100),
conferenceDate VARCHAR(20),
title VARCHAR(100) NOT NULL PRIMARY KEY,
edition VARCHAR(50),
publication VARCHAR(50),
publisher VARCHAR(50),
publicationDate VARCHAR(50),
phyDescription VARCHAR(50),
pages VARCHAR(10),
dimensions VARCHAR(10),
abstract VARCHAR(200),
awards VARCHAR(200),
subject VARCHAR(100),
generalTopics VARCHAR(200),
price VARCHAR(20)
);