List of tables

From Species File Help
(Difference between revisions)
Jump to: navigation, search
m
Line 1: Line 1:
 
The database contains the tables shown below.  (Security related items are not listed.)
 
The database contains the tables shown below.  (Security related items are not listed.)
  
*Data about taxa  
+
== Data about taxa ==
**[[Taxa|tblTaxa]], taxon names at all ranks, including synonyms.
+
 
**[[RelatedTaxa|tblRelatedTaxa]], linking table to record nomenclatural relationships between taxonomic names.
+
* [[Taxa|tblTaxa]], taxon names at all ranks, including synonyms.
**[[TaxonHistory|tblTaxonHistory]], history of concepts and nomenclature for protonyms
+
* [[RelatedTaxa|tblRelatedTaxa]], linking table to record nomenclatural relationships between taxonomic names.
        tblRelatedHistory, definition of values used in tblTaxonHistory.RelatedHistoryID
+
* [[TaxonHistory|tblTaxonHistory]], history of concepts and nomenclature for protonyms
        tblRanks, ranks in the taxonomic hierarchy
+
*      tblRelatedHistory, definition of values used in tblTaxonHistory.RelatedHistoryID
        tblSupplTaxonInfo, supplementary information about taxa.
+
*      tblRanks, ranks in the taxonomic hierarchy
        tblExperts, information about experts familiar with taxa.
+
*      tblSupplTaxonInfo, supplementary information about taxa.
        tblSources, references to sources of images, sound recordings and other data.
+
*      tblExperts, information about experts familiar with taxa.
        tblCommonNames, common names for taxa.
+
*      tblSources, references to sources of images, sound recordings and other data.
        tblLanguages, the language used for common names in a particular species file.
+
*      tblCommonNames, common names for taxa.
        tblLanguageList, standard information about languages.
+
*      tblLanguages, the language used for common names in a particular species file.
        tblTypeGenera, citation to genus that is type for a family-group name and to oldest use of a name based on the same genus.
+
*      tblLanguageList, standard information about languages.
        tblTypeSpecies, citation to species that is type for a genus-group name.
+
*      tblTypeGenera, citation to genus that is type for a family-group name and to oldest use of a name based on the same genus.
        tblTypeSpeciesReasons, reasons a type species has been validly designated.
+
*      tblTypeSpecies, citation to species that is type for a genus-group name.
        tblTypeInfo, effects of citations on types.
+
*      tblTypeSpeciesReasons, reasons a type species has been validly designated.
        tblDistribution, recorded occurences in geographic areas.   
+
*      tblTypeInfo, effects of citations on types.
*Data about specimens
+
*      tblDistribution, recorded occurences in geographic areas.   
        tblSpecimens, information about specimens.
+
== Data about specimens ==
        tblSpecimenCategories, categories of specimens (male, female, egg, etc.)
+
*      tblSpecimens, information about specimens.
        tblSpecimenCounts, counts for various specimen categories
+
*      tblSpecimenCategories, categories of specimens (male, female, egg, etc.)
        tblDepos, depositories that hold specimens.
+
*      tblSpecimenCounts, counts for various specimen categories
        tblSpecimenStatus, lost, lost?, missing, missing?, etc.
+
*      tblDepos, depositories that hold specimens.
        tblSexes, sex and maturity classification for specimens.
+
*      tblSpecimenStatus, lost, lost?, missing, missing?, etc.
        tblIdentifications, record of identifications on labels or in publications.
+
*      tblSexes, sex and maturity classification for specimens.
        tblTypeKinds, holotype, lectotype, neotype, etc.
+
*      tblIdentifications, record of identifications on labels or in publications.
        tblLocalities, information about localities where specimens were found including geologic time period.
+
*      tblTypeKinds, holotype, lectotype, neotype, etc.
        tblGeoLevel1, continent or other major part of the world.
+
*      tblLocalities, information about localities where specimens were found including geologic time period.
        tblGeoLevel2, region or large country.
+
*      tblGeoLevel1, continent or other major part of the world.
        tblGeoLevel3, country or portion of large country.
+
*      tblGeoLevel2, region or large country.
        tblGeoLevel4, county or other smaller area.
+
*      tblGeoLevel3, country or portion of large country.
        tblGazetteer, listing of names and the corresponding values in the preceding four tables, used with human data entry.
+
*      tblGeoLevel4, county or other smaller area.
        tblSeaCoords, polygon lists for oceanic TDWG areas
+
*      tblGazetteer, listing of names and the corresponding values in the preceding four tables, used with human data entry.
        tblGeoConvert1, 2, 3, 3A and 4, data used to help convert localities to standardized codes in automated process.
+
*      tblSeaCoords, polygon lists for oceanic TDWG areas
        tblTDWGtoITIS, for conversion of the TDWG geo classification to the ITIS geo classification.
+
*      tblGeoConvert1, 2, 3, 3A and 4, data used to help convert localities to standardized codes in automated process.
        tblTimePeriods, geologic time period.
+
*      tblTDWGtoITIS, for conversion of the TDWG geo classification to the ITIS geo classification.
        tblCollectEvents, information about the date and collector.  
+
*      tblTimePeriods, geologic time period.
*Data about images, sounds and ecology  
+
*      tblCollectEvents, information about the date and collector.  
        tblImages, images of specimens and other items.
+
== Data about images, sounds and ecology ==
        tblMIME (Multipurpose Internet Mail Extension code), supported image types.
+
*      tblImages, images of specimens and other items.
        tblImageTypes, type of image.
+
*      tblMIME (Multipurpose Internet Mail Extension code), supported image types.
        tblSounds, sound recordings.
+
*      tblImageTypes, type of image.
        tblEcoRoles, ecological roles
+
*      tblSounds, sound recordings.
        tblEcoRelationships, ecological relationships
+
*      tblEcoRoles, ecological roles
        tblOtherEcoTaxa, taxa in ecological relationships but outside the primary scope  
+
*      tblEcoRelationships, ecological relationships
*Data about literature citations, etc.
+
*      tblOtherEcoTaxa, taxa in ecological relationships but outside the primary scope  
        tblAddrCountries, a list of countries used in the address book.
+
== Data about literature citations, etc. ==
        tblAddrStates, a list of states used in the address book.
+
*      tblAddrCountries, a list of countries used in the address book.
        tblCites, citations to a reference, associated with a specific taxon.
+
*      tblAddrStates, a list of states used in the address book.
        tblConceptChanges, kind of changes in taxon concepts.
+
*      tblCites, citations to a reference, associated with a specific taxon.
        tblNewNameStatus, types of status for names.
+
*      tblConceptChanges, kind of changes in taxon concepts.
        tblCiteInfoFlags, kind of information contained in citations
+
*      tblNewNameStatus, types of status for names.
        tblRefs, references found in publications.
+
*      tblCiteInfoFlags, kind of information contained in citations
        tblRefAuthors, linking table to match references with authors.
+
*      tblRefs, references found in publications.
        tblPeople, names of people (mainly authors) including misspellings, etc.
+
*      tblRefAuthors, linking table to match references with authors.
        tblPeopleReg, registry of data about authors, for future development
+
*      tblPeople, names of people (mainly authors) including misspellings, etc.
        tblPubs, names of publications including misspellings, etc.
+
*      tblPeopleReg, registry of data about authors, for future development
        tblPubReg, registry of data about publications, for future development
+
*      tblPubs, names of publications including misspellings, etc.
        tblPubRegDetail, items that may have multiple values for a single registry pub, for future development
+
*      tblPubReg, registry of data about publications, for future development
        tblPendingPubFiles, linking table used to track the reconciliation of data in tblPubReg and the separate tblPubs in different species files, for future development
+
*      tblPubRegDetail, items that may have multiple values for a single registry pub, for future development
        tblPubSuccession, relationship between preceding and succeeding publications, for future development
+
*      tblPendingPubFiles, linking table used to track the reconciliation of data in tblPubReg and the separate tblPubs in different species files, for future development
        tblNomenclator, name combinations at rank of genus or lower.
+
*      tblPubSuccession, relationship between preceding and succeeding publications, for future development
        tblGenusNames, generic name for lookup in tblNomenclator.
+
*      tblNomenclator, name combinations at rank of genus or lower.
        tblSpeciesNames, species name for lookup in tblNomenclator.
+
*      tblGenusNames, generic name for lookup in tblNomenclator.
        tblScrutinies, years and comments from persons working on this database.
+
*      tblSpeciesNames, species name for lookup in tblNomenclator.
        tblTaxonScrutinies, linking table to match taxa with scrutinies.
+
*      tblScrutinies, years and comments from persons working on this database.
        tblScrutinyAuthors, linking table to match scrutinies with persons.
+
*      tblTaxonScrutinies, linking table to match taxa with scrutinies.
*Data for keys  
+
*      tblScrutinyAuthors, linking table to match scrutinies with persons.
        tblKeyGroups, groups of one or more taxa that can be separated by using a key block.
+
== Data for keys ==
        tblGroupTaxa, subordinate to tblKeyGroups, included or excluded members of a group based on a taxon listed in tblKeyGroups.
+
* tblKeyGroups, groups of one or more taxa that can be separated by using a key block.
        tblKeyBlocks, decision blocks for working through keys.
+
* tblGroupTaxa, subordinate to tblKeyGroups, included or excluded members of a group based on a taxon listed in tblKeyGroups.
        tblKeyChars, pool of characters available for use in key blocks.
+
* tblKeyBlocks, decision blocks for working through keys.
        tblCharTypes, types of characters, for future development
+
* tblKeyChars, pool of characters available for use in key blocks.
        tblKeyCharStates, subordinate to tblKeyChars, description of each character state for each character.
+
* tblCharTypes, types of characters, for future development
        tblCharStateDetails, subordinate to tblKeyCharStates, display details for character states.
+
* tblKeyCharStates, subordinate to tblKeyChars, description of each character state for each character.
        tblKeyBlockChars, linking table to match blocks and characters.
+
* tblCharStateDetails, subordinate to tblKeyCharStates, display details for character states.
        tblKeyBlockBranches, subordinate to tblKeyBlocks, list giving group selected for each branch.
+
* tblKeyBlockChars, linking table to match blocks and characters.
        tblBlockCharStates, linking table to match block character (specific to block) with key character (pool of all characters).
+
* tblKeyBlockBranches, subordinate to tblKeyBlocks, list giving group selected for each branch.
        tblBranchCharStates, linking table for block to match branch with character state.
+
* tblBlockCharStates, linking table to match block character (specific to block) with key character (pool of all characters).
*Data about log entries
+
* tblBranchCharStates, linking table for block to match branch with character state.
        tblEditLog, log of entries that alter the content of tables in species file databases.
+
== Data about log entries ==
        tblEditLogTexts, text information used in log entries.
+
* tblEditLog, log of entries that alter the content of tables in species file databases.
        tblTestLog, log of test program runs and results.
+
* tblEditLogTexts, text information used in log entries.
*Data about relationships between ID values, currently used only for spinning off and merging species files
+
* tblTestLog, log of test program runs and results.
        tblIDrelationships, types of relationships between IDs
+
== Data about relationships between ID values, currently used only for spinning off and merging species files ==
        tblMatchingCharStateIDs, related values for tblKeyCharStates.KeyCharStateID
+
* tblIDrelationships, types of relationships between IDs
        tblMatchingCollectEventIDs, related values for tblCollectEvents.CollectEventID
+
* tblMatchingCharStateIDs, related values for tblKeyCharStates.KeyCharStateID
        tblMatchingDepoIDs, related values for tblDepos.DepoID
+
* tblMatchingCollectEventIDs, related values for tblCollectEvents.CollectEventID
        tblMatchingEcoRoleIDs, related values for tblEcoRoles.EcoRoleID
+
* tblMatchingDepoIDs, related values for tblDepos.DepoID
        tblMatchingImageIDs, related values for tblImages.ImageID
+
* tblMatchingEcoRoleIDs, related values for tblEcoRoles.EcoRoleID
        tblMatchingKeyBlockIDs, related values for tblKeyBlocks.KeyBlockID
+
* tblMatchingImageIDs, related values for tblImages.ImageID
        tblMatchingKeyCharIDs, related values for tblKeyChars.KeyCharID
+
* tblMatchingKeyBlockIDs, related values for tblKeyBlocks.KeyBlockID
        tblMatchingKeyGroupIDs, related values for tblKeyGroups.KeyGroupID
+
* tblMatchingKeyCharIDs, related values for tblKeyChars.KeyCharID
        tblMatchingLinkIDs, related values for tblLinks.LinkID
+
* tblMatchingKeyGroupIDs, related values for tblKeyGroups.KeyGroupID
        tblMatchingLocalityIDs, related values for tblLocalities.LocalityID
+
* tblMatchingLinkIDs, related values for tblLinks.LinkID
        tblMatchingOtherEcoIDs, related values for tblOtherEcoTaxa.OtherEcoTaxonID
+
* tblMatchingLocalityIDs, related values for tblLocalities.LocalityID
        tblMatchingPersonIDs, related values for tblPeople.PersonID
+
* tblMatchingOtherEcoIDs, related values for tblOtherEcoTaxa.OtherEcoTaxonID
        tblMatchingPubIDs, related values for tblPubs.PubID
+
* tblMatchingPersonIDs, related values for tblPeople.PersonID
        tblMatchingRefIDs, related values for tblRefs.RefID
+
* tblMatchingPubIDs, related values for tblPubs.PubID
        tblMatchingScrutinyIDs, related values for tblScrutinies.ScrutinyID
+
* tblMatchingRefIDs, related values for tblRefs.RefID
        tblMatchingSoundIDs, related values for tblSounds.SoundID
+
* tblMatchingScrutinyIDs, related values for tblScrutinies.ScrutinyID
        tblMatchingSourceIDs, related values for tblSources.SourceID
+
* tblMatchingSoundIDs, related values for tblSounds.SoundID
        tblMatchingSpecimenIDs, related values for tblSpecimens.SpecimenID
+
* tblMatchingSourceIDs, related values for tblSources.SourceID
        tblMatchingSpmnCategoryIDs, related values for tblSpecimenCategories.SpmnCategoryID
+
* tblMatchingSpecimenIDs, related values for tblSpecimens.SpecimenID
        tblMatchingSupplTaxonInfoIDs, related values for tblSupplTaxonInfo.SupplTaxonInfoID
+
* tblMatchingSpmnCategoryIDs, related values for tblSpecimenCategories.SpmnCategoryID
        tblMatchingTaxonHistoryIDs, related values for tblTaxonHistory.TaxonHistoryID
+
* tblMatchingSupplTaxonInfoIDs, related values for tblSupplTaxonInfo.SupplTaxonInfoID
        tblMatchingTaxonNameIDs, related values for tblTaxa.TaxonNameID
+
* tblMatchingTaxonHistoryIDs, related values for tblTaxonHistory.TaxonHistoryID
        tblMatchingTxnNmLSIDs, related values for tblTxnNmLSIDs.TxnNmLSID
+
* tblMatchingTaxonNameIDs, related values for tblTaxa.TaxonNameID
*Data for relationships outside of species files
+
* tblMatchingTxnNmLSIDs, related values for tblTxnNmLSIDs.TxnNmLSID
        tblLinks, hyperlinks to other websites with information about a taxon.
+
== Data for relationships outside of species files ==
        tblWebsites, information about other websites.
+
* tblLinks, hyperlinks to other websites with information about a taxon.
        tblTxnNmLSIDs, information about LSIDs for scientific taxon names
+
* tblWebsites, information about other websites.
        tblTConceptLSIDs, taxon concept LSIDs
+
* tblTxnNmLSIDs, information about LSIDs for scientific taxon names
        tblDeletedTNameIDs, deleted taxon name IDs
+
* tblTConceptLSIDs, taxon concept LSIDs
        tblForeignLSIDs, LSIDs issued by other entities such as Species 2000 and ZooBank
+
* tblDeletedTNameIDs, deleted taxon name IDs
*Miscellaneous
+
* tblForeignLSIDs, LSIDs issued by other entities such as Species 2000 and ZooBank
        tblConstants, constant values to be referenced by programs.
+
== Miscellaneous tables ==
        tblGlossary, words that are recognized in a glossary search.
+
* tblConstants, constant values to be referenced by programs.
        tblFiles, data about the status of various species files.
+
* tblGlossary, words that are recognized in a glossary search.
        tblFileTypes, types of database files based on how they are used.
+
* tblFiles, data about the status of various species files.
        tblSources, sources of data in tables in SFSdb.
+
* tblFileTypes, types of database files based on how they are used.
        Temporary tables used for export to the Catalogue of Life
+
* tblSources, sources of data in tables in SFSdb.
 +
* Temporary tables used for export to the Catalogue of Life
  
 
[[Category:Developers]]
 
[[Category:Developers]]
 
[[Category:Lists]]
 
[[Category:Lists]]
 
[[Category:Tables]]
 
[[Category:Tables]]

Revision as of 10:01, 17 September 2012

The database contains the tables shown below. (Security related items are not listed.)

Contents

Data about taxa

  • tblTaxa, taxon names at all ranks, including synonyms.
  • tblRelatedTaxa, linking table to record nomenclatural relationships between taxonomic names.
  • tblTaxonHistory, history of concepts and nomenclature for protonyms
  • tblRelatedHistory, definition of values used in tblTaxonHistory.RelatedHistoryID
  • tblRanks, ranks in the taxonomic hierarchy
  • tblSupplTaxonInfo, supplementary information about taxa.
  • tblExperts, information about experts familiar with taxa.
  • tblSources, references to sources of images, sound recordings and other data.
  • tblCommonNames, common names for taxa.
  • tblLanguages, the language used for common names in a particular species file.
  • tblLanguageList, standard information about languages.
  • tblTypeGenera, citation to genus that is type for a family-group name and to oldest use of a name based on the same genus.
  • tblTypeSpecies, citation to species that is type for a genus-group name.
  • tblTypeSpeciesReasons, reasons a type species has been validly designated.
  • tblTypeInfo, effects of citations on types.
  • tblDistribution, recorded occurences in geographic areas.

Data about specimens

  • tblSpecimens, information about specimens.
  • tblSpecimenCategories, categories of specimens (male, female, egg, etc.)
  • tblSpecimenCounts, counts for various specimen categories
  • tblDepos, depositories that hold specimens.
  • tblSpecimenStatus, lost, lost?, missing, missing?, etc.
  • tblSexes, sex and maturity classification for specimens.
  • tblIdentifications, record of identifications on labels or in publications.
  • tblTypeKinds, holotype, lectotype, neotype, etc.
  • tblLocalities, information about localities where specimens were found including geologic time period.
  • tblGeoLevel1, continent or other major part of the world.
  • tblGeoLevel2, region or large country.
  • tblGeoLevel3, country or portion of large country.
  • tblGeoLevel4, county or other smaller area.
  • tblGazetteer, listing of names and the corresponding values in the preceding four tables, used with human data entry.
  • tblSeaCoords, polygon lists for oceanic TDWG areas
  • tblGeoConvert1, 2, 3, 3A and 4, data used to help convert localities to standardized codes in automated process.
  • tblTDWGtoITIS, for conversion of the TDWG geo classification to the ITIS geo classification.
  • tblTimePeriods, geologic time period.
  • tblCollectEvents, information about the date and collector.

Data about images, sounds and ecology

  • tblImages, images of specimens and other items.
  • tblMIME (Multipurpose Internet Mail Extension code), supported image types.
  • tblImageTypes, type of image.
  • tblSounds, sound recordings.
  • tblEcoRoles, ecological roles
  • tblEcoRelationships, ecological relationships
  • tblOtherEcoTaxa, taxa in ecological relationships but outside the primary scope

Data about literature citations, etc.

  • tblAddrCountries, a list of countries used in the address book.
  • tblAddrStates, a list of states used in the address book.
  • tblCites, citations to a reference, associated with a specific taxon.
  • tblConceptChanges, kind of changes in taxon concepts.
  • tblNewNameStatus, types of status for names.
  • tblCiteInfoFlags, kind of information contained in citations
  • tblRefs, references found in publications.
  • tblRefAuthors, linking table to match references with authors.
  • tblPeople, names of people (mainly authors) including misspellings, etc.
  • tblPeopleReg, registry of data about authors, for future development
  • tblPubs, names of publications including misspellings, etc.
  • tblPubReg, registry of data about publications, for future development
  • tblPubRegDetail, items that may have multiple values for a single registry pub, for future development
  • tblPendingPubFiles, linking table used to track the reconciliation of data in tblPubReg and the separate tblPubs in different species files, for future development
  • tblPubSuccession, relationship between preceding and succeeding publications, for future development
  • tblNomenclator, name combinations at rank of genus or lower.
  • tblGenusNames, generic name for lookup in tblNomenclator.
  • tblSpeciesNames, species name for lookup in tblNomenclator.
  • tblScrutinies, years and comments from persons working on this database.
  • tblTaxonScrutinies, linking table to match taxa with scrutinies.
  • tblScrutinyAuthors, linking table to match scrutinies with persons.

Data for keys

  • tblKeyGroups, groups of one or more taxa that can be separated by using a key block.
  • tblGroupTaxa, subordinate to tblKeyGroups, included or excluded members of a group based on a taxon listed in tblKeyGroups.
  • tblKeyBlocks, decision blocks for working through keys.
  • tblKeyChars, pool of characters available for use in key blocks.
  • tblCharTypes, types of characters, for future development
  • tblKeyCharStates, subordinate to tblKeyChars, description of each character state for each character.
  • tblCharStateDetails, subordinate to tblKeyCharStates, display details for character states.
  • tblKeyBlockChars, linking table to match blocks and characters.
  • tblKeyBlockBranches, subordinate to tblKeyBlocks, list giving group selected for each branch.
  • tblBlockCharStates, linking table to match block character (specific to block) with key character (pool of all characters).
  • tblBranchCharStates, linking table for block to match branch with character state.

Data about log entries

  • tblEditLog, log of entries that alter the content of tables in species file databases.
  • tblEditLogTexts, text information used in log entries.
  • tblTestLog, log of test program runs and results.

Data about relationships between ID values, currently used only for spinning off and merging species files

  • tblIDrelationships, types of relationships between IDs
  • tblMatchingCharStateIDs, related values for tblKeyCharStates.KeyCharStateID
  • tblMatchingCollectEventIDs, related values for tblCollectEvents.CollectEventID
  • tblMatchingDepoIDs, related values for tblDepos.DepoID
  • tblMatchingEcoRoleIDs, related values for tblEcoRoles.EcoRoleID
  • tblMatchingImageIDs, related values for tblImages.ImageID
  • tblMatchingKeyBlockIDs, related values for tblKeyBlocks.KeyBlockID
  • tblMatchingKeyCharIDs, related values for tblKeyChars.KeyCharID
  • tblMatchingKeyGroupIDs, related values for tblKeyGroups.KeyGroupID
  • tblMatchingLinkIDs, related values for tblLinks.LinkID
  • tblMatchingLocalityIDs, related values for tblLocalities.LocalityID
  • tblMatchingOtherEcoIDs, related values for tblOtherEcoTaxa.OtherEcoTaxonID
  • tblMatchingPersonIDs, related values for tblPeople.PersonID
  • tblMatchingPubIDs, related values for tblPubs.PubID
  • tblMatchingRefIDs, related values for tblRefs.RefID
  • tblMatchingScrutinyIDs, related values for tblScrutinies.ScrutinyID
  • tblMatchingSoundIDs, related values for tblSounds.SoundID
  • tblMatchingSourceIDs, related values for tblSources.SourceID
  • tblMatchingSpecimenIDs, related values for tblSpecimens.SpecimenID
  • tblMatchingSpmnCategoryIDs, related values for tblSpecimenCategories.SpmnCategoryID
  • tblMatchingSupplTaxonInfoIDs, related values for tblSupplTaxonInfo.SupplTaxonInfoID
  • tblMatchingTaxonHistoryIDs, related values for tblTaxonHistory.TaxonHistoryID
  • tblMatchingTaxonNameIDs, related values for tblTaxa.TaxonNameID
  • tblMatchingTxnNmLSIDs, related values for tblTxnNmLSIDs.TxnNmLSID

Data for relationships outside of species files

  • tblLinks, hyperlinks to other websites with information about a taxon.
  • tblWebsites, information about other websites.
  • tblTxnNmLSIDs, information about LSIDs for scientific taxon names
  • tblTConceptLSIDs, taxon concept LSIDs
  • tblDeletedTNameIDs, deleted taxon name IDs
  • tblForeignLSIDs, LSIDs issued by other entities such as Species 2000 and ZooBank

Miscellaneous tables

  • tblConstants, constant values to be referenced by programs.
  • tblGlossary, words that are recognized in a glossary search.
  • tblFiles, data about the status of various species files.
  • tblFileTypes, types of database files based on how they are used.
  • tblSources, sources of data in tables in SFSdb.
  • Temporary tables used for export to the Catalogue of Life
Personal tools
Namespaces

Variants
Actions
Navigation
Species Files
Wiki
Toolbox