PubRegDetail
From Species File Help
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
