This topic describes the database table names and descriptions in Specify.
Each table name is clickable and will bring you to the demo instance data model viewer. If you have any questions, feel free to send a message to support@specifysoftware.org!
| Table Name | Table Description |
|---|---|
| Absolute Age | Records a numerical age determination for a Collection Object, such as a radiocarbon or potassium-argon date. Includes the age value, uncertainty, dating method, and agent who performed the analysis. |
| Absolute Age Attachment | Links an Attachment (e.g., a lab report or data sheet) to an Absolute Age record, with an ordinal for ordering multiple attachments. |
| Absolute Age Citation | Links a Reference Work (publication) to an Absolute Age record, capturing details like figure, plate, and page numbers where the age is reported. |
| Accession | Also called an acquisition. A consignment of specimens acquired either by field collecting of staff members, gifts, purchases, or exchange with another institution. Tracks the source, date received, status, and total value of the acquisition. |
| Accession Agent | Links an Agent (person, group, or organization) to an Accession and defines their role in the accession process (e.g., donor, collector, requester). |
| Accession Attachment | Links digital files (PDFs, photos, etc.) to an Accession record, such as scanned import permits, deeds of gift, or correspondence. |
| Accession Authorization | Records authorization for an Accession, linking it to a Permit and optionally a Repository Agreement. Tracks who authorized the acquisition. |
| Accession Citations | Links a Reference Work (publication) to an Accession, with optional figure, plate, and page numbers for citation details. |
| Address | Stores the postal address of an Agent (person or organization), including street, city, state, country, postal code, phone, and fax. Also captures the date range the agent was at that address and the position they held there. |
| Address of Record | Captures the legal address associated with an Accession, Loan, Exchange, or Repository Agreement at the time the transaction took place. |
| Agent | Central directory of people, groups, and organizations involved in the collection process. Roles include collector, determiner, preparer, cataloger, donor, permit issuer, and more. Supports both individuals (with name components) and organizations. |
| Agent Attachment | Links digital files (photos, documents) to an Agent record, such as a portrait of a collector or a researcher’s CV. |
| Agent Geography | Records the geographic region(s) an Agent was known for collecting in or specializing on, with an optional role (e.g., author, collector). |
| Agent Identifier | Stores external identifiers for an Agent, such as ORCID, ResearcherID, Scopus ID, or Wikidata ID, enabling integration with external authority systems. |
| Agent Specialty | Records the taxonomic or disciplinary specialty of an Agent (e.g., ‘Coleoptera’, ‘Marine Invertebrates’), with an order number for ranking primary vs. secondary specialties. |
| Agent Variant | Captures variant and vernacular names for an Agent, primarily used by botanists. Includes language, country, and a type flag distinguishing variants from vernacular names. |
| Appraisal | Records the monetary appraisal value of an Accession or Collection Object, including the appraiser (Agent), appraisal date, and monetary unit. |
| Attachment | A digital file (image, PDF, audio, etc.) linked to a data record. Instead of storing the file in the database, Specify stores it on a Web Asset Server and keeps a reference (location, MIME type, original filename, metadata) in this table. Supports licensing, copyright, and visibility controls. |
| Attachment Image Attribute | Stores image-specific metadata for an Attachment, such as height, width, resolution, magnification, image type, and view description. Used primarily for specimen images. |
| Attachment Metadata | Key-value metadata pairs associated with an Attachment, allowing flexible storage of custom metadata fields (e.g., EXIF data, capture device info). |
| Attachment Tag | User-defined keyword tags for Attachments, enabling search and categorization of digital media files. |
| Attribute Definition | Defines a custom attribute field that can be applied to Collection Objects, Collecting Events, or Preparations. Specifies the data type, field name, and which Prep Type it applies to. |
| Author | Links an Agent as an author to a Reference Work, with an order number to specify the author sequence (first author, second author, etc.). |
| Auto Numbering Scheme | Internal configuration table that defines auto-numbering formats for catalog numbers, accessions, or other identifiers. Groups collections, disciplines, or divisions that share the same numbering scheme. |
| Borrow | Tracks incoming loans (borrows) from other institutions. Records the lender, dates (borrow date, due date, received date, closed date), invoice number, and status of the borrowed material. |
| Borrow Agent | Links an Agent to a Borrow record and defines their role (e.g., lender, contact person, shipper) in the borrowing transaction. |
| Borrow Attachment | Links digital files (e.g., loan agreements, shipping documents) to a Borrow record. |
| Borrow Material | Describes individual items or lots included in a Borrow, with material number, description, quantity, and tracking of quantities returned or resolved. |
| Borrow Return Material | Tracks the return of borrowed material, recording the return date, quantity returned, and the Agent who received the return. |
| Collecting Event | Captures the ‘when’ and ‘how’ of a collection: the date(s), time, method, collectors, and field number. Links to a Locality for the ‘where’. Some disciplines identify events by field number, others by locality+date combination. |
| Collecting Event Attachment | Links digital files (field photos, maps, audio recordings) to a Collecting Event, with ordinal for ordering. |
Collecting Event Attribute (collectingeventattr) |
Stores values for user-customizable attributes defined by an AttributeDef, linked to a Collecting Event. Supports string and numeric value types. |
Collecting Event Attribute (collectingeventattribute) |
A one-to-one extension table for Collecting Events, providing additional user-customizable attribute fields beyond the standard schema. |
| Collecting Event Authorization | Records authorization for a Collecting Event, typically linking to a Permit that grants permission to collect at a specific time and place. |
| Collecting Trip | Groups multiple Collecting Events into an expedition or field trip. Tracks the trip’s start/end dates, participants, and purpose. |
| Collecting Trip Attachment | Links digital files (trip reports, maps, permits) to a Collecting Trip record. |
| Collecting Trip Attribute | Stores values for user-customizable attributes linked to a Collecting Trip, supporting flexible data capture beyond the standard schema. |
| Collecting Trip Authorization | Records authorization for a Collecting Trip, linking to a Permit that authorizes the overall expedition. |
| Collection | Defines a collection within a Discipline, grouping Collection Objects of the same type (e.g., ‘Birds’, ‘Insects’, ‘Paleobotany’). Each collection has its own catalog numbering and default preparation types. |
| Collection Object | The central record in Specify, representing any item in a collection: physical specimen, lot, observation, sound recording, slide, tissue sample, or extract. Ties together all related information (determinations, preparations, locality, collecting event, etc.). |
| Collection Object Attachment | Links digital files (specimen photos, X-rays, field notes) to a Collection Object, with ordinal for ordering. |
Collection Object Attribute (collectionobjectattr) |
Stores values for user-customizable attributes defined by an AttributeDef, linked to a Collection Object. Supports string and numeric value types. |
Collection Object Attribute (collectionobjectattribute) |
A one-to-one extension table for Collection Objects, providing additional user-customizable attribute fields beyond the standard schema. |
| Collection Object Citation | Links a Reference Work (publication) to a Collection Object, with optional figure, plate, and page numbers for citation details. |
| Collection Object Group | Groups multiple Collection Objects together for a specific purpose (e.g., a type series, a teaching collection, or a loan set). Uses CollectionObjectGroupType to define the grouping category. |
| Collection Object Group Join | Join table linking Collection Objects to Collection Object Groups, enabling many-to-many relationships between objects and groups. |
| Collection Object Group Type | Defines the types or categories of Collection Object Groups (e.g., ‘Type Series’, ‘Teaching Collection’, ‘Exhibit’). |
| Collection Object Property | Stores additional properties or measurements for a Collection Object, such as weight, length, or other quantitative attributes. |
| Collection Object Type | Categorizes Collection Objects by their type (e.g., ‘Fish’, ‘Observation’, ‘Tissue Sample’, ‘DNA Extract’, ‘Sound Recording’). |
| Collection Relationship | Links two Collection Objects to each other, defining a relationship between them (e.g., voucher specimen to tissue sample, host to parasite, parent to offspring). |
| Collection Relationship Type | Defines the types of relationships that can exist between Collection Objects (e.g., ‘voucher for’, ‘parasite of’, ‘host to’, ‘derived from’). |
| Collector | Join table linking an Agent (as collector) to a Collecting Event, with an order field for listing multiple collectors in sequence. |
| Common Name | Stores common (vernacular) names for a Taxon, with localization support including language, country, and variant information. |
| Common Name Tx Citation | Links a Reference Work to a Common Name record, citing the source where the common name was published or used. |
| Conservator Description | Describes the conservation status and treatment history of a Collection Object. Each Collection Object can have at most one Conservation Description, which groups multiple treatment events. |
| Conservator Description Attachment | Links digital files (condition reports, treatment photos) to a Conservation Description. |
| Conservator Event | Records a specific conservation or restoration action performed on a Collection Object as part of a Conservation Description. Multiple events can occur over time (e.g., cleaning, repair, pest treatment). |
| Conservator Event Attachment | Links digital files (treatment photos, before/after images) to a specific Conservation Event. |
| Container | Represents a physical or logical container that can hold Collection Objects (e.g., a drawer, cabinet, box, or freezer rack). Containers can optionally be cataloged as Collection Objects themselves. |
| Data Type | Defines the core data types used in the Specify data model (e.g., String, Number, Date, Boolean), used for schema and attribute definitions. |
| Deaccession | Records the permanent removal of Collection Objects from the collection, whether by transfer, exchange, gift, destruction, or loss. Tracks the reason, date, and method of deaccession. |
| Deaccession Agent | Links an Agent to a Deaccession and defines their role (e.g., recipient, authorizer, witness) in the deaccession process. |
| Deaccession Attachment | Links digital files (transfer agreements, disposal certificates) to a Deaccession record. |
| Determination | Also called an Identification. Records the taxonomic name assigned to a Collection Object, including the determiner, determination date, confidence qualifiers (cf., aff., ?), type status, and remarks. A Collection Object can have a history of multiple determinations over time. |
| Determination Citation | Links a Reference Work to a Determination, citing the publication used to make the identification. |
| Determiner | Join table linking an Agent (as determiner) to a Determination, with an order field for listing multiple determiners in sequence. |
| Discipline | Organizational unit that may contain one or more Collections sharing the same Taxon, Geography, Lithostratigraphy, and Chronostratigraphy trees, as well as shared Localities, Agents, and Determination statuses. |
| Disposal | Records the physical removal or destruction of a specific Preparation during deaccession (e.g., tissue consumed for DNA extraction, specimen lost in transit, or destroyed). Linked to Preparations. |
| Disposal Agent | Links an Agent to a Disposal record and defines their role (e.g., authorizer, witness) in the disposal process. |
| Disposal Attachment | Links digital files (disposal certificates, destruction records) to a Disposal record. |
| Disposal Preparation | Join table linking a Preparation to a Disposal, recording which specific preparations were disposed of and in what quantity. |
| Division | A division or department within an Institution (e.g., ‘Vertebrate Zoology’, ‘Botany’). Contains Agents and may oversee multiple Disciplines. |
| Dna Primer | Stores DNA primer sequences used in molecular work, including the primer name, sequence, and direction (forward/reverse). |
| Dna Sequence | Stores DNA sequence data associated with a Collection Object, including the sequence itself, GenBank accession number, and primer information. |
| Dna Sequence Attachment | Links digital files (chromatograms, sequence alignments) to a DNA Sequence record. |
| Dna Sequencing Run | Records a DNA sequencing run, including the run date, protocol, machine used, and links to the resulting DNA sequences. |
| Dnasequencingrunattachment | Links digital files (run logs, quality reports) to a DNA Sequencing Run. |
| Dna Sequencing Run Citation | Links a Reference Work to a DNA Sequencing Run, citing the publication where the sequence data was reported. |
| Exchange In | Tracks specimens received from another institution as part of an exchange agreement. Records the sender, date received, and associated terms. |
| Exchange in Attachment | Links digital files (exchange agreements, shipping documents) to an incoming Exchange record. |
| Exchange in Prep | Links specific Preparations received as part of an incoming exchange, with quantity information. |
| Exchange Out | Tracks specimens sent to another institution as part of an exchange agreement. Records the recipient, date sent, and associated terms. |
| Exchange Out Attachment | Links digital files (exchange agreements, shipping documents) to an outgoing Exchange record. |
| Exchange Out Prep | Links specific Preparations sent as part of an outgoing exchange, with quantity information. |
| Exsiccata | Records an exsiccata series—a published, numbered set of preserved specimens distributed to institutions. Common in botany and mycology. |
| Exsiccata Item | Links a specific Collection Object to an Exsiccata series, recording its number within the series. |
| Extractor | Links an Agent to a DNA Sequence record as the person who performed the extraction, with an order field for multiple extractors. |
| Field Notebook | Describes a physical field notebook, including its identifier, owner, and storage location. |
| Field Notebook Attachment | Links digital files (scanned notebook pages, covers) to a Field Notebook record. |
| Field Notebook Page | Describes an individual page within a Field Notebook, capturing the page number and date. |
| Field Notebook Page Attachment | Links digital files (scanned images) to a specific Field Notebook Page. |
| Field Notebook Page Set | Groups multiple Field Notebook Pages together, typically representing pages that were scanned together as a batch. |
| Field Notebook Page Set Attachment | Links digital files to a Field Notebook Page Set. |
| Funding Agent | Links a funding agency (Agent) to a Collecting Trip or Project, recording the grant or funding source that supported the work. |
| Geo Coord Detail | Stores additional georeferencing details for a Locality, originally designed for MANIS (Mammal Networked Information System) data compatibility. |
| Geography | Hierarchical tree representing political boundaries (Country, State, Province, County, Township, etc.). Used to classify localities and agent collecting regions. |
| Geography Tree Definition | Defines the number, names, and hierarchy of levels in the Geography tree (e.g., Continent > Country > State > County). |
| Geography Tree Definition Item | Describes a single level in the Geography tree definition, specifying its name, rank, and position in the hierarchy. |
| Chronostratigraphy | Hierarchical tree representing chronostratigraphic/geologic time units (Eon > Era > Period > Epoch > Age). Used for dating paleontological specimens. |
| Geological Time Period Tree Definition | Defines the levels and hierarchy of the Geologic Time Period tree. |
| Geological Time Period Tree Definition Item | Describes a single level in the Geologic Time Period tree definition. |
| Gift | Records specimens given as gifts to other institutions or individuals. Tracks the recipient, date, and purpose of the gift. |
| Gift Agent | Links an Agent to a Gift record and defines their role (e.g., donor, recipient, authorizer) in the gift transaction. |
| Gift Attachment | Links digital files (gift agreements, correspondence) to a Gift record. |
| Gift Preparation | Links specific Preparations included in a Gift, with quantity information. |
| Group Person | Join table for hierarchical Agent relationships, linking member Agents to parent organization Agents (e.g., a department within a university). Provides ordering. |
| Information Request | Records a request for information about Collection Objects, linking to a set of records and tracking the requester, date, and purpose. |
| Institution | The top-level organization (e.g., museum, university) that owns the collections. An Institution contains one or more Divisions. |
| Institution Network | Records affiliations or partnerships between Institutions (e.g., consortium memberships, collaborative agreements). |
| Journal | Stores metadata about academic journals, used for citing Reference Works that are journal articles. |
| Lat Lon Polygon | Stores a geographic polygon (e.g., a collecting area boundary or protected area) defined by a series of latitude/longitude points. |
| Lat Lon Polygon Pnt | Stores individual latitude/longitude points that make up a LatLonPolygon, with sequence order. |
| Library Role | System table: Stores predefined (library/default) roles that can be assigned to users within any collection. Defines the base set of permissions available. |
| Library Role Policy | System table: Stores resource and action permissions associated with library (default) roles within a collection. |
| Lithostratigraphy | Hierarchical tree representing lithostratigraphic units (Supergroup > Group > Formation > Member > Bed). Used for geological context of specimens. |
| Lithostratigraphy Tree Definition | Defines the levels and hierarchy of the Lithostratigraphy tree. |
| Lithostratigraphy Tree Definition Item | Describes a single level in the Lithostratigraphy tree definition. |
| Loan | Tracks specimens loaned out to other institutions. Manages all aspects including loan date, due date, return tracking, and shipping. Each loan can include multiple preparations. |
| Loan Agent | Links an Agent to a Loan and defines their role (e.g., Borrower, Benefactor, Sponsor, Preparer) in the loan transaction. |
| Loan Attachment | Links digital files (loan agreements, shipping labels, insurance documents) to a Loan record. |
| Loan Preparation | Join table linking a Preparation to a Loan, recording which specimens were loaned and in what quantity. |
| Loan Return Preparation | Tracks the return of loaned Preparations, recording the return date, condition, and quantity returned. |
| Locality | Defines the ‘where’ of a collection: the specific place name, geographic coordinates (point, line, or polygon), coordinate determination method, datum, and elevation/depth. The foundation for georeferencing specimens. |
| Locality Attachment | Links digital files (maps, site photos) to a Locality record. |
| Locality Citation | Links a Reference Work to a Locality, citing a publication that describes or mentions the locality. |
| Locality Detail | Stores additional locality information such as water body, island group, UTM coordinates, and other supplementary geographic details. |
| Locality Name Alias | Stores alternate names or spellings for a Locality (e.g., historical names, variant spellings in different languages). |
| Material Sample | Records a material sample taken from a Collection Object for analysis (e.g., a tissue sample for DNA, a rock sample for geochemistry). |
| Message | System table: Stores user notifications and messages within the application. |
| Morph Bank View | Links to MorphBank (a morphological image database) views, providing integration with external image repositories. |
| Other Identifier | Stores an identifier (catalog number or other ID) assigned to a Collection Object by another institution, enabling cross-referencing between collections. |
| Paleo Context | Provides paleontological context for a Collection Object, Collecting Event, or Locality, linking to chronostratigraphy, lithostratigraphy, and biostratigraphy data. |
| Pcr Persons | Links an Agent to a DNA Sequencing Run as the person who performed the PCR (polymerase chain reaction) amplification. |
| Permit | Records legal permits and licenses for collecting specimens, including the issuing authority, permit number, date range, and terms. Links to Accessions, Collecting Events, and Loans. |
| Permit Attachment | Links digital files (scanned permits, letters of authorization) to a Permit record. |
| Pick List | System table: Defines a controlled vocabulary (picklist) for a field, providing a dropdown list of selectable values to ensure data consistency. |
| Pick List Item | System table: An individual value within a Picklist, representing one selectable option in a controlled vocabulary. |
| Preparation | Represents the distinct physical components of a Collection Object (e.g., skin, skeleton, tissue, slide, fluid-preserved jar). Supports extensible attributes and properties. A single Collection Object can have multiple Preparations. |
| Preparation Attachment | Links digital files (preparation photos, X-rays) to a Preparation record. |
Preparation Attribute (preparationattr) |
Stores values for user-customizable attributes defined by an AttributeDef, linked to a Preparation. Supports string and numeric value types. |
Preparation Attribute (preparationattribute) |
A one-to-one extension table for Preparations, providing additional user-customizable attribute fields beyond the standard schema. |
| Preparation Property | Stores additional properties or measurements for a Preparation, such as weight, dimensions, or preservation method. |
| Preparation Type | Defines the types of Preparations available in a collection (e.g., ‘Cleared and Stained’, ‘Mounted’, ‘Frozen Tissue’, ‘Microscope Slide’, ‘Skeleton’). |
| Project | Groups Collection Objects together under a research project or study, enabling project-level organization and reporting. |
| Record Set | System table: Stores a set of record IDs of any type, used for batch operations, query results, and temporary selections within the application. |
| Record Set Item | System table: An individual record ID within a Record Set. |
| Reference Work | Stores bibliographic references (publications, books, articles, theses) that can be cited from Determinations, Localities, Taxa, and other records. |
| Reference Work Attachment | Links digital files (PDFs, scans) to a Reference Work record. |
| Relative Age | Records a relative age determination (e.g., ‘Early Miocene’, ‘Late Cretaceous’) for a Collection Object, based on biostratigraphy or other relative dating methods. |
| Relative Age Attachment | Links digital files to a Relative Age record. |
| Relative Age Citation | Links a Reference Work to a Relative Age record, citing the publication where the age determination was reported. |
| Repository Agreement | Records a legal agreement that permits an Accession to occur without transferring ownership (e.g., a loan for study, a field repository agreement). |
| Repository Agreement Attachment | Links digital files (signed agreements, terms of deposit) to a Repository Agreement. |
| Role | System table: Stores user-defined roles with associated permissions for access control within a collection. |
| Role Policy | System table: Stores resource and action permissions for user-defined roles within a collection. |
| Shipment | Tracks the physical shipment of specimens for Loans, Exchanges, or Borrows, including carrier, tracking number, date sent, and date received. |
| App Resource | System table: Stores application resources (typically XML configuration) used by Specify at runtime for forms, views, and other UI components. |
| App Resource Data | System table: Stores the data content associated with an application resource. |
| App Resource Default | System table: Defines the directory structure for organizing application resources. |
| Spattachmentdataset | System table: Groups attachments into datasets for batch processing or export. |
| Sp Audit Log | System table: Records audit log entries tracking data changes (create, update, delete) for data entry tables. |
| Sp Audit Log Field | System table: Records individual field-level changes within an audit log entry. |
| Spdataset | Stores data sets created during bulk import via the Specify 7 WorkBench, typically from spreadsheet uploads. Contains the mapping between spreadsheet columns and database fields. |
| Sp Data Set Attachment | Links digital files (specimen images, field notes) temporarily associated with a Specify 7 WorkBench data set during import. |
| Specify User | System table: Represents a user account in Specify. |
| Sp Export Schema | System table: Defines export schemas for data export/import operations. |
| Sp Export Schema Item | System table: Defines individual fields within an export schema. |
| Sp Export Schema Item Mapping | System table: Maps export schema items to database fields for data transformation. |
| Sp Export Schema Mapping | System table: Defines the mapping between export schemas and database tables. |
| Sp Field Value Default | System table: Stores default values for form fields, used to pre-populate data entry forms. |
| Locale Container | System table: Stores localized names and descriptions for database tables (schema containers), enabling multi-language support in the user interface. |
| Locale Container Item | System table: Stores localized names and descriptions for individual database fields (schema container items), enabling multi-language support. |
| Locale Item String | System table: Stores localized string values with language, country, and variant identifiers for internationalization. |
| Sp Merging | System table: Tracks records that are being merged, storing record IDs and task IDs for the merge process. |
| Sp Permission | Deprecated Specify 6 table: Stores individual permission records defining access rights to resources and actions. |
| Sp Principal | Deprecated Specify 6 table: Stores security principals (users and groups) for the permission system. |
| Sp Query | System table: Stores saved queries, including the query definition and configuration. |
| Sp Query Field | System table: Stores individual field definitions within a saved query. |
| Sp Report | System table: Stores saved report definitions and configurations. |
| Sp Symbiota Instance | Deprecated Specify 6 table: Stores configuration for Symbiota integration instances, enabling data sharing with the Symbiota biodiversity platform. |
| Sp Task Semaphore | System table: Internal semaphore mechanism for coordinating background tasks and preventing concurrent execution. |
| Spuserexternalid | Stores external provider identifiers and authentication tokens for users who sign in using Single Sign-On (SSO) providers (e.g., Entra ID/Azure AD, Keycloak, Google). |
| Sp Version | System table: Tracks the Specify and database schema version. |
| View Set Object | System table: Stores view set definitions used by the Specify form system to define data entry forms and layouts. |
| Sp Visual Query | System table: Stores visual query builder configurations. |
| Storage | Hierarchical tree representing the physical storage locations in the collection (e.g., Building > Room > Cabinet > Drawer > Tray). Used to track where Preparations are physically housed. |
| Storage Attachment | Links digital files (storage maps, shelf photos) to a Storage location record. |
| Storage Tree Definition | Defines the levels and hierarchy of the Storage tree. |
| Storage Tree Definition Item | Describes a single level in the Storage tree definition. |
| Taxon | Hierarchical tree representing the taxonomic classification of organisms (Kingdom > Phylum > Class > Order > Family > Genus > Species). Used for determinations and organizing collection objects. |
| Taxon Attachment | Links digital files (illustrations, distribution maps) to a Taxon record. |
| Taxon Attribute | Stores additional attributes or properties for a Taxon (e.g., author citation, publication year, common characteristics). |
| Taxon Citation | Links a Reference Work to a Taxon record, citing the publication where the taxon was described or revised. |
| Taxon Tree Definition | Defines the levels and hierarchy of the Taxon tree (e.g., Kingdom, Phylum, Class, Order, Family, Genus, Species). |
| Taxon Tree Definition Item | Describes a single level in the Taxon tree definition, specifying its name, rank, and position in the hierarchy. |
| Tectonic Unit | Hierarchical tree representing tectonic/terrane units used in geology and paleontology for describing the tectonic setting of specimens. |
| Tectonic Unit Tree Def | Defines the levels and hierarchy of the Tectonic Unit tree. |
| Tectonic Unit Tree Def Item | Describes a single level in the Tectonic Unit tree definition. |
| Treatment Event | Records a specific conservation treatment action performed on a Collection Object (e.g., pest eradication, cleaning, repair, stabilization). Part of a Conservation Description. |
| Treatment Event Attachment | Links digital files (treatment reports, before/after photos) to a Treatment Event. |
| Uniqueness Rule | Stores table names that have uniqueness constraints configured per discipline, defining which tables require unique field combinations. |
| Uniqueness Rule Field | Stores field names that participate in uniqueness constraints per discipline, linked to UniquenessRule records. |
| User Policy | Records specific resource and action permissions granted to a user within a collection. |
| User Role | Records the roles assigned to a user within a collection, linking users to their role-based permissions. |
| Voucher Relationship | Links a voucher specimen (Collection Object) to a taxon concept or DNA sequence, establishing the specimen as the physical voucher for that identification or genetic data. |
| Workbench | Deprecated table: Represents a Specify 6 WorkBench data set created during bulk data import, typically from a spreadsheet. Contains the import configuration and mapping metadata. |
| Workbench Data Item | Deprecated table: Stores the value of a single cell in a Specify 6 WorkBench data set row. |
| Workbench Row | Deprecated table: Represents a single row of data in a Specify 6 WorkBench data set, containing multiple data items. |
| Workbench Row Exported Relationship | Deprecated table: Tracks relationships created between records during Specify 6 WorkBench data export/import operations. |
| Workbench Row Image | Deprecated table: Links an image file to a specific row in a Specify 6 WorkBench data set, used for associating media during import. |
| Workbench Template | Deprecated table: Defines the column mapping template for a Specify 6 WorkBench data set, specifying how spreadsheet columns map to database fields. |
| Workbench Template Mapping Item | Deprecated table: Defines the mapping for a single column in a Specify 6 WorkBench template, specifying the target database field and transformation rules. |