create table s1.InProceedings \
  (inprocID char(35) not null, title char(254), bktitle char(250), year int, \
   month char(8), pages char(12), vol int, num int, loc char(150), \
   class char(150), note char(254), annote varchar(2800), \
   primary key(inprocID))

create table s1.Article \
  (articleID char(35) not null, title char(254), journal char(150), year int, \
   month char(8), pages char(12), vol int, num int, loc char(150), \
   class char(150), note char(254), annote varchar(2800), \
   primary key(articleID))

create table s1.TechReport \
  (techID char(35) not null, title char(254), inst char(200), year int, \
   month char(8), pages char(12), vol int, num int, loc char(150), \
   class char(150), note char(254), annote varchar(2800), \
   primary key(techID))

create table s1.Book \
  (bookID char(35) not null, title char(254), publisher char(200), year int, \
   month char(8), pages char(12), vol int, num int, loc char(150), \
   class char(150), note char(254), annote varchar(2800), \
   primary key(bookID))

create table s1.InCollection \
  (collID char(35) not null, title char(254), bktitle char(250), year int, \
   month char(8), pages char(12), vol int, num int, loc char(150), \
   class char(150), note char(254), annote varchar(2800), \
   primary key(collID))

create table s1.Misc \
  (miscID char(35) not null, title char(254), howpub char(200), \
   confloc char(100),  year int, \
   month char(8), pages char(12), vol int, num int, loc char(150), \
   class char(150), note char(254), annote varchar(2800), \
   primary key(miscID))

create table s1.Manual \
  (manID char(35) not null, title char(254), org char(200), year int, \
   month char(8), pages char(12), vol int, num int, loc char(150), \
   class char(150), note char(254), annote varchar(2800), \
   primary key(manID))

create table s1.Author \
   (AuthID int not null, name char(80) not null, \
    primary key (AuthID))

--RELATIONSHIP TABLES

create table s1.InprocPublished \
   (inprocID char(35) not null, AuthID int not null, \
    primary key(inprocID, AuthID), \
    foreign key (inprocID) references s1.InProceedings \
    on delete CASCADE, foreign key (AuthID) \
    references s1.Author on delete CASCADE)

create table s1.ArticlePublished \
   (articleID char(35) not null, AuthID int not null, \
    primary key(articleID, AuthID), \
    foreign key (articleID) references s1.Article \
    on delete CASCADE, foreign key (AuthID) \
    references s1.Author on delete CASCADE)

create table s1.TechPublished \
   (techID char(35) not null, AuthID int not null, \
    primary key(techID, AuthID), \
    foreign key (techID) references s1.TechReport \
    on delete CASCADE, foreign key (AuthID) \
    references s1.Author on delete CASCADE)

create table s1.BookPublished \
   (bookID char(35) not null, AuthID int not null, \
    primary key(bookID, AuthID), \
    foreign key (bookID) references s1.Book \
    on delete CASCADE, foreign key (AuthID) \
    references s1.Author on delete CASCADE)

create table s1.InCollPublished \
   (collID char(35) not null, AuthID int not null, \
    primary key(collID, AuthID), \
    foreign key (collID) references s1.InCollection \
    on delete CASCADE, foreign key (AuthID) \
    references s1.Author on delete CASCADE)

create table s1.MiscPublished \
   (miscID char(35) not null, AuthID int not null, \
    primary key(miscID, AuthID), \
    foreign key (miscID) references s1.Misc \
    on delete CASCADE, foreign key (AuthID) \
    references s1.Author on delete CASCADE)

create table s1.ManualPublished \
   (manID char(35) not null, AuthID int not null, \
    primary key (manID, AuthID), \
    foreign key (manID) references s1.Manual \
    on delete CASCADE, foreign key (AuthID) \
    references s1.Author on delete CASCADE)