Links
From Species File Help
(Difference between revisions)
(created page) |
(links) |
||
(2 intermediate revisions by one user not shown) | |||
Line 1: | Line 1: | ||
'''tblLinks''' contains hyperlinks to other websites with information about a taxon. | '''tblLinks''' contains hyperlinks to other websites with information about a taxon. | ||
− | + | *LinkID, integer, 4 bytes, identifier for link | |
− | + | *FileID, integer, 4 bytes, = tblFiles.FileID | |
− | + | *TaxonNameID, integer, 4 bytes, = [[Taxa|tblTaxa]].TaxonNameID | |
− | + | *WebsiteID, integer, 4 bytes, = [[Websites|tblWebsites]].WebsiteID | |
− | + | *DataTypes, integer, 2 bytes, bitwise flags for type of information: 0 = undefined, 1 = general information, 2 = key, 4 = distribution map, 8 = specimen level information | |
− | + | *LinkSpecs, text, 500 characters maximum, hyperlink specification to add after tblWebsites.RootLink | |
− | + | *TaxonHyperlink, bit, used as ordinary hyperlink for a taxon | |
− | + | *TaxonAutolink, bit, used as automatic hyperlink from one species file to the same taxon in a different species file | |
− | + | *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:ForeignRelatedTables]] | [[Category:ForeignRelatedTables]] | ||
+ | [[Category:Tables]] |
Latest revision as of 09:44, 23 April 2013
tblLinks contains hyperlinks to other websites with information about a taxon.
- LinkID, integer, 4 bytes, identifier for link
- FileID, integer, 4 bytes, = tblFiles.FileID
- TaxonNameID, integer, 4 bytes, = tblTaxa.TaxonNameID
- WebsiteID, integer, 4 bytes, = tblWebsites.WebsiteID
- DataTypes, integer, 2 bytes, bitwise flags for type of information: 0 = undefined, 1 = general information, 2 = key, 4 = distribution map, 8 = specimen level information
- LinkSpecs, text, 500 characters maximum, hyperlink specification to add after tblWebsites.RootLink
- TaxonHyperlink, bit, used as ordinary hyperlink for a taxon
- TaxonAutolink, bit, used as automatic hyperlink from one species file to the same taxon in a different species file
- 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