Sources
From Species File Help
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