CollectEvents

tblCollectEvents, information about the date and collector

CollectEventID, integer, 4 bytes, identifier for the collecting event CollectorName, text, 100 bytes maximum. To be deleted when CollectorID is implemented and linking table to tblPeople is available. Year, integer, 2 bytes, year collecting started. There is a special case of Year = 1000, used to signify that no year is available for the collection event, but month (and perhaps day) are significant to the event. Month, integer, 1 byte, month collecting started Day, integer, 1 byte, day of month collecting started DaysToEnd, integer, 2 bytes, additional days in collecting period (usually 0) LastUpdate, smalldatetime, date and time of last update ModifiedBy, integer, 2 bytes, UserID of the signon that made the change