PubRegDetail
From Species File Help
(Difference between revisions)
(created page) |
Revision as of 10:20, 31 August 2012
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