Links

From Species File Help
(Difference between revisions)
Jump to: navigation, search
(cat)
(links)
 
Line 3: Line 3:
 
*LinkID, integer, 4 bytes, identifier for link
 
*LinkID, integer, 4 bytes, identifier for link
 
*FileID, integer, 4 bytes, = tblFiles.FileID
 
*FileID, integer, 4 bytes, = tblFiles.FileID
*TaxonNameID, integer, 4 bytes, = tblTaxa.TaxonNameID
+
*TaxonNameID, integer, 4 bytes, = [[Taxa|tblTaxa]].TaxonNameID
*WebsiteID, integer, 4 bytes, = tblWebsites.WebsiteID
+
*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
 
*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
 
*LinkSpecs, text, 500 characters maximum, hyperlink specification to add after tblWebsites.RootLink

Latest revision as of 08: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
Personal tools
Namespaces

Variants
Actions
Navigation
Species Files
Wiki
Toolbox