PubRegDetail

tblPubRegDetail, items that may have multiple values for a single registry pub, for future development

   PubRegID, integer, 4 bytes, = tblPubReg.PubRegID
   SeqNum, integer, 2 bytes, sequence number (zero based) ordered to the extent possible on StartYear.  When tblPubReg.PrefRegID > 0, then 0 is the only permitted value for SeqNum.  PubRegID and SeqNum constitute the primary key
   Publisher, text, nvarchar(300), publisher
   PlacePublished, text, nvarchar(200), place published
   StartYear, integer, 2 bytes, starting or only year of publication
   EndYear, integer, 2 bytes, ending year of publication, 0 = StartYear is the only year, -1 = publication has not terminated
   ISBN, text, 17 characters, ISBN number
   ISSN, text, 9 characters, ISSN number
   OCLC, integer, 4 bytes, number assigned by Online Computer Library Center
   Note, text, 500 characters maximum, miscellaneous information
   SourceID, integer, 4 bytes, = tblSources.SourceID, source of this row of data
   LastUpdate, smalldatetime, date and time row last updated
   ModifiedBy, integer, 4 bytes, FileUserID of the signon that made the change
   CreatedOn, smalldatetime, date and time row was created
   CreatedBy, integer, 4 bytes, FileUserID of the signon that created the row