PubRegDetail
From Species File Help
(Difference between revisions)
(created page) |
(formatting, cat) |
||
| Line 1: | Line 1: | ||
'''tblPubRegDetail''', items that may have multiple values for a single registry pub, for future development | '''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 | |
[[Category:CiteRelatedTables]] | [[Category:CiteRelatedTables]] | ||
| + | [[Category:Tables]] | ||
Latest revision as of 13:01, 8 September 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
