Pubs
From Species File Help
(Difference between revisions)
(created page) |
|||
| Line 1: | Line 1: | ||
'''tblPubs''', publications, including duplicate and misspelled names | '''tblPubs''', publications, including duplicate and misspelled names | ||
| − | + | * PubID, integer, 4 bytes, identifier for the publication | |
| − | + | * PrefID, integer, 4 bytes, if PrefID > 0, then this is a duplicate or misspelled name and PrefID = PubID for preferred name | |
| − | + | * [[Files|FileID]], integer, 4 bytes, identifier for the file | |
| − | + | * PubType, 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 | |
| − | + | * Note, text, 500 characters maximum, miscellaneous information | |
| − | + | * Publisher, text, nvarchar(300), publisher for PubType = 3 (otherwise = "") | |
| − | + | * PlacePublished, text, nvarchar(200), place published for PubType = 3 (otherwise = "") | |
| − | + | * PubRegID, integer, 4 bytes = tblPubReg.PubRegID, = 0 except when Status = 4, for future development | |
| − | + | * Status, integer, 1 byte, status of reconciliation with tblPubReg, for future development | |
| − | + | ** 0 = reconciliation not attempted, this value should not continue after future development | |
| − | + | ** 1 = Waiting for a response from species file editor | |
| − | + | ** 2 = Waiting for a response from registry editor | |
| − | + | ** 3 = Species file editor has decided it does not belong in registry | |
| − | + | ** 4 = Fully reconciled with the registry | |
| − | + | * StartYear, integer, 2 bytes, minimum tblPubRegDetail.StartYear for the publication, for future development | |
| − | + | * EndYear, integer, 2 bytes, maximum tblPubRegDetail.EndYear for publication, for future development | |
| − | + | * BHL, integer, 4 bytes, ID from Biodiversity Heritage Libarary, for future development | |
| − | + | * 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 09:16, 7 September 2012
tblPubs, publications, including duplicate and misspelled names
- PubID, integer, 4 bytes, identifier for the publication
- PrefID, integer, 4 bytes, if PrefID > 0, then this is a duplicate or misspelled name and PrefID = PubID for preferred name
- FileID, integer, 4 bytes, identifier for the file
- PubType, 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
- Note, text, 500 characters maximum, miscellaneous information
- Publisher, text, nvarchar(300), publisher for PubType = 3 (otherwise = "")
- PlacePublished, text, nvarchar(200), place published for PubType = 3 (otherwise = "")
- PubRegID, integer, 4 bytes = tblPubReg.PubRegID, = 0 except when Status = 4, for future development
- Status, integer, 1 byte, status of reconciliation with tblPubReg, for future development
- 0 = reconciliation not attempted, this value should not continue after future development
- 1 = Waiting for a response from species file editor
- 2 = Waiting for a response from registry editor
- 3 = Species file editor has decided it does not belong in registry
- 4 = Fully reconciled with the registry
- StartYear, integer, 2 bytes, minimum tblPubRegDetail.StartYear for the publication, for future development
- EndYear, integer, 2 bytes, maximum tblPubRegDetail.EndYear for publication, for future development
- BHL, integer, 4 bytes, ID from Biodiversity Heritage Libarary, for future development
- 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
