Sources
From Species File Help
(Difference between revisions)
(created page) |
|||
Line 1: | Line 1: | ||
'''tblSources''' contains sources of images, sound recordings and other data. | '''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 | |
− | + | ||
− | + | ||
[[Category:TaxaTables]] | [[Category:TaxaTables]] |
Revision as of 16:16, 29 August 2012
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