create table s2.allBibs ( citKey char(20) not null, primary key (citKey) )

 

create table s2.citForm \

            ( citKey char(20) not null, form  char(20), \

              primary key     (citKey), \

              foreign key      (citKey) references s2.allBibs      on delete cascade )

 

create table s2.authors \

            ( citKey char(20) not null, autNm char(100) not null, \

              primary key     (citKey, autNm), \

              foreign key      (citKey) references s2.allBibs      on delete cascade )

 

create table s2.editors \

            ( citKey char(20) not null, \

              edNm              char(100) not null, primary key    (citKey, edNm), \

              foreign key      (citKey) references s2.allBibs      on delete cascade )

 

create table s2.titles \

            ( citKey char(20) not null, title  char(200), \

              primary key     (citKey), \

              foreign key      (citKey) references s2.allBibs      on delete cascade )

 

create table s2.schools \

            ( citKey char(20) not null, schoolNm  char(100), \

              primary key     (citKey), \

              foreign key      (citKey) references s2.allBibs      on delete cascade )

 

create table s2.institutions \

            ( citKey char(20) not null, institNm  char(100), \

              primary key     (citKey), \

              foreign key      (citKey) references s2.allBibs      on delete cascade )

 

create table s2.addresses \

            ( citKey char(20) not null, address  char(100), \

              primary key     (citKey), \

              foreign key      (citKey) references s2.allBibs      on delete cascade )

 

create table s2.types \

            ( citKey char(20) not null, type  char(100), \

              primary key     (citKey), \

              foreign key      (citKey) references s2.allBibs      on delete cascade )

 

create table s2.ISBN \

            ( citKey char(20) not null, isbnNum  char(20), \

              primary key     (citKey), \

              foreign key      (citKey) references s2.allBibs      on delete cascade )

 

create table s2.notes \

            ( citKey char(20) not null, note  char(200) not null, \

              primary key     (citKey, note), \

              foreign key      (citKey) references s2.allBibs      on delete cascade )

 

create table s2.volumes \

            ( citKey char(20) not null, volNum  char(50), \

              primary key     (citKey), \

              foreign key      (citKey) references s2.allBibs      on delete cascade )

 

create table s2.numbers \

            ( citKey             char(20) not null, num  char(50), \

              primary key     (citKey), \

              foreign key      (citKey) references s2.allBibs      on delete cascade )

 

create table s2.months \

            ( citKey char(20) not null, mon  char(20), \

              primary key     (citKey), \

              foreign key      (citKey) references s2.allBibs      on delete cascade )

 

create table s2.years \

            ( citKey             char(20) not null, yr  char(20), \

              primary key     (citKey), \

              foreign key      (citKey) references s2.allBibs      on delete cascade )

 

create table s2.pages \

            ( citKey char(20) not null, pgRange  char(50), \

              primary key     (citKey), \

              foreign key      (citKey) references s2.allBibs      on delete cascade )

 

create table s2.abstracts \

            ( citKey char(20) not null, txt  varchar(3500), \

              primary key     (citKey), \

              foreign key      (citKey) references s2.allBibs      on delete cascade )

 

create table s2.publisher \

            ( pubNm  char(100), pubID  integer not null, \

              primary key     (pubID) )

 

create table s2.citPublisher \

            ( citKey char(20) not null, pubID  integer not null, \

              primary key     (citKey, pubID), \

              foreign key      (citKey) references s2.allBibs      on delete cascade, \

              foreign key      (pubID) references s2.publisher on delete cascade )

 

create table s2.journal \

            ( jrnlNm char(200), jrnlID integer not null, \

              primary key (jrnlID) )

 

create table s2.citJournal \

            ( citKey char(20) not null, jrnlID    integer not null, \

              primary key     (citKey, jrnlID), \

              foreign key      (citKey) references s2.allBibs      on delete cascade, \

              foreign key      (jrnlID) references s2.journal        on delete cascade )

 

create table s2.series \

            ( seriesNm        char(50), seriesID  integer not null, \

              primary key     (seriesID) )

 

create table s2.citSeries \

            ( citKey char(20) not null, seriesID  integer not null, \

              primary key     (citKey, seriesID), \

              foreign key      (citKey) references s2.allBibs      on delete cascade, \ 

              foreign key      (seriesID) references s2.series on delete cascade )

 

create table s2.booktitle \

            ( bkTitleNm        char(100), bktitleID  integer not null, \ 

              primary key     (bktitleID) )

 

create table s2.citBkTitle \

            ( citKey char(20) not null, bktitleID  integer not null, \

              primary key     (citKey, bktitleID), \

              foreign key      (citKey) references s2.allBibs      on delete cascade, \

              foreign key      (bktitleID) references s2.booktitle on delete cascade )

 

create table s2.keyWord \

            ( word   char(50), keyWdID  integer not null, \

              primary key     (keyWdID) )

 

create table s2.citKeyWd \

            ( citKey char(20) not null, keyWdID  integer not null, \

              primary key     (citKey, keyWdID), \

              foreign key      (citKey) references s2.allBibs      on delete cascade, \

              foreign key      (keyWdID) references s2.keyWord on delete cascade )