RefAuthors

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