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