Sources
From Species File Help
(Difference between revisions)
(created page) |
(formatting, cat) |
||
| (One intermediate revision by one user not shown) | |||
| 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, | + | *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: | + | *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 | *Description, text, 600 bytes maximum | ||
| − | *LastUpdate, smalldatetime, date and time | + | *LinkID, integer, 4 bytes, = tblLinks.LinkID, link to website that provided source |
| − | *ModifiedBy, integer, | + | *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]] | ||
| + | [[Category:Tables]] | ||
Latest revision as of 10:13, 9 September 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
