TaxonScrutinies
From Species File Help
(Difference between revisions)
(created page) |
Revision as of 10:27, 31 August 2012
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