Tables involving relationships external to species files
Home     Manual

Fields are shown under each table.  Comments about future changes or unresolved design issues are shown in contrasting color.  Version specific features are noted by highlighted text.

• tblLinks, hyperlinks to other websites with information about a taxon
  • LinkID, integer, 2 bytes, identifier for link
  • TaxonNameID, integer, 4 bytes, = tblTaxa.TaxonNameID
  • WebsiteID, integer, 2 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 bytes maximum, hyperlink specification to add after tblWebsites.RootLink
  • LastUpdate, smalldatetime, date and time of last update
  • ModifiedBy, integer, 2 bytes, UserID of the signon that made the change
  • 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
• tblWebsites, information about other websites
  • WebsiteID, integer, 2 bytes, identifier for the website
  • Name, text, 100 bytes maximum
  • RootLink, text, 200 bytes maximum, root portion of the hyperlink
  • Flags, integer, 1 byte, bitwise flags
    • 1 = used for taxon specific links
    • 2 = used for reference links
    • 4 = used for specimen links
  • LastUpdate, smalldatetime, date and time of last update
  • ModifiedBy, integer, 2 bytes, UserID of the signon that made the change
• tblTxnNmLSIDs, infomation about LSIDs for scientific taxon names development started for version 4.0
  • TxnNmLSID, integer, 4 bytes, primary key, = ID portion of LSIDs
  • TaxonNameID, integer, 4 bytes, when row added = tblTaxa.TaxonNameID, but table relationship cannot be created because the row must remain here even if the row in tblTaxa is deleted
  • NomenclatorID, integer, 4 bytes, = tblNomenclator.NomenclatorID. TaxonNameID and NomenclatorID for a unique index
  • TrueTxnNmLSID, integer, 4 bytes, = TxnNmLSID, available for forwarding in case an LSID must be deleted
  • Status, integer, 1 byte
    • 0 = active
    • 1 = dormant, used for deleted nominotypical subs
    • 2 = artifact from rows erroneously added
    • 3 = moved to other species file identified in Note
    • 4 = moved out of scope
    • 5 = dormant, AccessCode changed to > 0
  • LastUpdate, smalldatetime, date and time of last update
  • ModifiedBy, integer, 2 bytes, UserID of the signon that made the change
  • Note, text, 100 bytes maximum, used to record that the value of TxnNmLSID in this row is reserved for future merge into this species file of an existing private species file named in this field. Other uses are likely in the future.
• tblTConcepts, taxon concepts future development
  • TConceptID, int, primary key
  • TaxonNameID, int
  • RefID, int, = tblRefs.RefID
  • Revision, smallint
  • Status, tinyint, (current, superceded, invalid, other states?)
  • LastUpdate, smalldatetime, date and time of last update
  • ModifiedBy, integer, 2 bytes, UserID of the signon that made the change
• tblDeletedTNameIDs, deleted taxon name IDs future development
  • OrphanSciNameID, int, = tblSciNames.SciNameID, primary key, ID in tblSciNames where tblSciNames.TaxonNameID is a value that no longer exists in tblTaxa
  • NewTNameID, int, = tblTaxa.TaxonNameID, when = 0 there is no related row in tblTaxa (happens only in some of the cases when tblSciNames.Status = 4)
  • LastUpdate, smalldatetime, date and time of last update
  • ModifiedBy, integer, 2 bytes, UserID of the signon that made the change
• tblForeignTNameIDs, LSIDs issued by other entities such as Species 2000 and ZooBank future development
  • SciNameID, int, = tblSciNames.SciNameID
  • ForeignURN, varchar(1000), text of a urn for an LSID provided by a database other than this one.
  • LastUpdate, smalldatetime
  • ModifiedBy, smallint, = tblAuthorizedUsers.UserID