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