Click to login

Diagram of specimen (part I) related tables
Home     Manual

Tables containing static information (e.g., the names of taxonomic ranks) have been moved to the SFS database, which is available to all species files.  The SFS database tables that are relevant to this diagram (if any) are displayed below the main diagram.
This diagram omits tblImages and tblSounds, both of which have relationships to tblSpecimens.  Click on the table names to display the related tables.
TableDiagram
The following SFS database table(s) relate to the above diagram:
TableDiagramSuppl tblSpecimenStatus.SpecimenStatusID acts like a primary key for tblSpecimens.SpecimenStatusID.

tblTypeKinds.TypeKindID acts like a primary key for tblIdentifications.TypeKindID.

Select a different diagram: