File contents

CREATE TABLE Articles (accessionNumber CHAR(12) Primary Key, title TEXT, abstract TEXT, isOnPageNo VARCHAR(20));

CREATE TABLE person (personName VARCHAR(255), affiliation VARCHAR(255), id
VARCHAR(255));

CREATE TABLE organisations (ordID INT, organisationName VARCHAR(255));

CREATE TABLE isAuthorOf (authorID VARCHAR(255), docID CHAR(12));

CREATE TABLE BookChapters (accessionNumber CHAR(12), inBook VARCHAR(255));

CREATE TABLE Books (accessionNumber CHAR(12));

CREATE TABLE JournalArticles (accessionNumber CHAR(12), inMagazineIssue VARCHAR(255));

CREATE TABLE MagazineIssues (accessionNumber CHAR(12), inMagazine VARCHAR(255));

CREATE TABLE Magazines (magazine_ID VARCHAR(255));

CREATE TABLE ConferencePapers (accessionNumber CHAR(12), atConference VARCHAR(255));

CREATE TABLE ConferenceProceedings (accessionNumber CHAR(12));

CREATE TABLE Conferences (conferenceID VARCHAR(255));

CREATE TABLE isAbout (docID CHAR(12), topicID VARCHAR(255));

CREATE TABLE topics (topicName VARCHAR(255));

CREATE TABLE topicOrder (topicName VARCHAR(255), sequence INT, depth INT, frequency INT);

CREATE TABLE controlledTerms (topicName VARCHAR(255), controlledTermName VARCHAR(255), controlledTermWeight FLOAT);

CREATE TABLE uncontrolledTerms (topicName VARCHAR(255), uncontrolledTermName VARCHAR(255), uncontrolledTermWeight FLOAT);

CREATE TABLE thesaurusNarrowerTopics (topicName VARCHAR(255), narrowerTopicName VARCHAR(255));

CREATE TABLE thesaurusBroaderTopics (topicName VARCHAR(255), broaderTopicName VARCHAR(255));

CREATE TABLE thesaurusRelatedTopics (topicName VARCHAR(255), relatedTopicName VARCHAR(255));

CREATE TABLE thesaurusTopTopics (topicName VARCHAR(255), topTopicName VARCHAR(255));