In general, a database schema refers to the logical structure of a database, which defines how data is organized, stored, and accessed in a database system.
The Specify database schema defines the tables, fields, relationships, and constraints that make up the database, as well as the rules and procedures for data entry, storage, retrieval, and manipulation. Not all components are customizable, but field and table labels, visibility, field formats, and controlled vocabularies (pick lists) can be!
Specify’s schema is designed to be flexible and customizable, allowing users to add or modify the visibility and labels of fields and tables as needed to accommodate their specific collection management needs. It provides a user-friendly interface for customizing and managing the schema.
Take a look at the most up-to-date interactive schema below:
Interactive Specify Schema
This is a static webpage that allows you to navigate between all of the tables and fields in the Specify schema. This is fast and supports English, Portuguese, Russian, and Ukrainian languages, but it does not have information about your customized schema within your installation.
Specify Data Model Viewer
Within your Specify 7 installation, you can explore the data model for your current schema configuration by navigating to:
From here, you can see all of the tables available, the assigned labels, whether they are hidden or system, and view if table records are “dependent” or “independent” on the base record they were created on.
Scoping in Specify
Also important is understanding Institutional Scoping and how data from a variety of collections, disciplines, and divisions can exist within a single database.
You can see previous versions of the database schema here.
Specify Schema 2.7 Poster
Full Size Poster PDF – A1 Size (23-3/8 x 33-1/8 in)
You can check out our visualized schema as well! This is not the latest version but it may be helpful in explaining the relationship between tables and for introducing & training users.