PubReg
From Species File Help
(Difference between revisions)
(created page) |
(formatting, cat) |
||
Line 1: | Line 1: | ||
'''tblPubReg''', registry of data about publications, for future development | '''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 | |
[[Category:CiteRelatedTables]] | [[Category:CiteRelatedTables]] | ||
+ | [[Category:Tables]] |
Latest revision as of 13:00, 8 September 2012
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