RefAuthors
From Species File Help
(Difference between revisions)
(created page) |
(formatting, cat) |
||
| Line 1: | Line 1: | ||
'''tblRefAuthors''', linking table to match references with authors (Every reference must have an entry in the linking table to make the views work correctly. For references without any author, use person "Unknown", PersonID = 0.) | '''tblRefAuthors''', linking table to match references with authors (Every reference must have an entry in the linking table to make the views work correctly. For references without any author, use person "Unknown", PersonID = 0.) | ||
| − | + | *RefID, integer, 4 bytes, = tblRefs.RefID | |
| − | + | *PersonID, integer, 4 bytes, = tblPeople.PersonID | |
| − | + | *SeqNum, integer, 2 bytes, position for this author in sequence of names | |
| − | + | *AuthorCount, integer, 2 bytes, number of co-authors for this reference | |
| − | + | *LastUpdate, smalldatetime, date and time of last update | |
| − | + | *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:03, 8 September 2012
tblRefAuthors, linking table to match references with authors (Every reference must have an entry in the linking table to make the views work correctly. For references without any author, use person "Unknown", PersonID = 0.)
- RefID, integer, 4 bytes, = tblRefs.RefID
- PersonID, integer, 4 bytes, = tblPeople.PersonID
- SeqNum, integer, 2 bytes, position for this author in sequence of names
- AuthorCount, integer, 2 bytes, number of co-authors for this reference
- LastUpdate, smalldatetime, date and time of last update
- 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
