List of tables

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

Latest revision as of 15:20, 8 September 2014

See a categorized list of all tables in the database. The list below is being transformed into the categorized list.

Contents

[edit] 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.

[edit] 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.

[edit] Data about images, sounds and ecology

[edit] 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.

[edit] 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.

[edit] 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.

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

[edit] Data for relationships outside of species files

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

[edit] 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