TaxonScrutinies

tblTaxonScrutinies, linking table to match taxa with scrutinies

TaxonNameID, integer, 4 bytes, = tblTaxa.TaxonNameID for the associated taxon, this plus SeqNum forms the primary key ScrutinyID, integer, 4 bytes, = tblScrutinies.ScrutinyID SeqNum, integer, 2 bytes, 1-based sequence number for scrutinies for an individual taxon 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