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