PubReg
From Species File Help
tblPubReg, registry of data about publications, for future development
- PubRegID, integer, 4 bytes, primary key
- PrefRegID, integer, 4 bytes, if PrefRegID > 0, then this is a duplicate or misspelled name and PrefRegID = PubRegID for preferred name
- PubType, integer, 1 byte, 1 = journal, (2 not used), 3 = book or CD, 4 = unpublished
- ShortName, text, nvarchar(400), abbreviated journal name or book title or unpublished source
- FullName, text, nvarchar(400), full journal name or book title or unpublished source
- StartYear, integer, 2 bytes, minimum tblPubRegDetail.StartYear for the publication, for version 3.6
- EndYear, integer, 2 bytes, maximum tblPubRegDetail.EndYear for publication, for version 3.6
- BHL, integer, 4 bytes, ID from Biodiversity Heritage Libarary, for version 3.6
- 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