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
tblSciNames
, scientific taxon names (used for LSIDs),
development started, version not determined
SciNameID, int, primary key
TaxonNameID, int, 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, int, = tblNomenclator.NomenclatorID
Status, tinyint, (current, previous combination, superceded, deleted with no relationship, deleted by removal of nominotypical sub, deleted because protonym was duplicated, moved out of scope, other status?)
1 = valid
2 = original combination
3 = previous combination
4 = synonym
5 = moved outside scope of apex taxon
6 = inactive because tblTaxa.AccessCode changed to > 0
7 = junior homonym lacking nomen novum
8 = nomen nudum with indeterminate identification
9 = nomen dubium
21 = deleted because present only due to user error in entering data
22 = deleted by removal of nominotypical sub
23 = deleted because protonym was duplicated
24 = deleted because cite nomenclator information changed
25 = deleted because of change in hierarchy and previous valid name not supported by citation
LastUpdate, smalldatetime, date and time of last update
ModifiedBy, integer, 2 bytes, UserID of the signon that made the change
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