List of tables
From Species File Help
(Difference between revisions)
(created page) |
(cat) |
||
Line 123: | Line 123: | ||
tblSources, sources of data in tables in SFSdb. | 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 | ||
+ | |||
+ | [[Category:Developers]] | ||
+ | [[Category:Lists]] |
Revision as of 15:49, 30 August 2012
The database contains the tables shown below. (Security related items are not listed.)
- 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
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