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