Sources

From Species File Help
Revision as of 16:16, 29 August 2012 by Maehr (Talk | contribs)

Jump to: navigation, search

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

   SourceID, integer, 4 bytes, identifier for the source
   FileID, integer, 4 bytes, = tblFiles.FileID, file that used the source
   SourceFileID, integer, 4 bytes, = tblFiles.FileID, file that provided the source
   RefID, integer, 4 bytes, = tblRefs.RefID
   PersonID, integer, 4 bytes, = tblPeople.PersonID 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
   LinkID, integer, 4 bytes, = tblLinks.LinkID, link to website that provided source
   DateReceived, date, date when source was received, may be null
   LastUpdate, smalldatetime, date and time row last updated
   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
Personal tools
Namespaces

Variants
Actions
Navigation
Species Files
Wiki
Toolbox