From Species File Help
Jump to: navigation, search

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
Personal tools

Species Files