Data Model Introduction¶
Indicia’s database is a traditional relational database based on PostgreSQL with spatial extensions supported by PostGIS. Here’s an introduction to some key ares of the data model to get you started with querying the database. A detailed description of the principal tables is included here but use your database client to see a full description of the database tables and columns in the schema comments.
- websites > surveys > samples > occurrences
- taxon_lists > taxa_taxon_lists > taxa
- Cache tables
- Custom attribute tables
- People, users and groups
- Website agreements
- Locations and sites
- Detailed table descriptions
- websites
- surveys
- samples
- occurrences
- occurrence_comments
- determinations
- taxon_lists
- taxa_taxon_lists
- taxa
- taxon_groups
- languages
- cache_occurrences_functional
- cache_occurrences_nonfunctional
- cache_samples_functional
- cache_samples_nonfunctional
- cache_taxa_taxon_lists
- cache_taxon_searchterms
- location_attributes
- location_attributes_websites
- location_attribute_values
- occurrence_attributes
- occurrence_attributes_websites
- occurrence_attribute_values
- person_attributes
- person_attributes_websites
- person_attribute_values
- sample_attributes
- sample_attributes_websites
- sample_attribute_values
- survey_attributes
- survey_attributes_websites
- survey_attribute_values
- taxa_taxon_list_attributes
- taxon_lists_taxa_taxon_list_attributes
- taxa_taxon_list_attribute_values
- termlists_term_attributes
- termlists_termlists_term_attributes
- termlists_term_attribute_values
- people
- users
- users_websites
- groups
- groups_users
- group_pages
- filters
- locations