Sources

Revision as of 11:16, 27 August 2012

tblSources contains sources of images, sound recordings and other data.

• SourceID, integer, 2 bytes, identifier for the source
• RefID, integer, 2 bytes, = tblRefs.RefID
• PersonID, integer, 2 bytes, = tblPeople.PersonID Not yet in use.
• LinkID, integer, 2 bytes, = tblLinks.LinkID Not yet in use.
• Date, smalldatetime Not yet in use.
• DataFlags, integer, 2 bytes, bitwise flags for type of data present:
  • 1 = image
  • 2 = sound
  • 4 = specimen
  • 8 = key block
  • 16 = SupplTaxonInfo
  • 32 = ecological relationship
• Description, text, 600 bytes maximum
• LastUpdate, smalldatetime, date and time of last update
• ModifiedBy, integer, 2 bytes, UserID of the signon that made the change