Sources
From Species File Help
(Difference between revisions)
(formatting, cat) |
|||
| 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]] | ||
| + | [[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
