Click to login

Diagram of specimen (part II) 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 tblGeoLevel2(Level1ID, Level2ID) acts like a primary key for tblLocalities(Level1ID, Level2ID).

tblGeoLevel4(Level3ID, Level4ID) acts like a primary key for tblLocalities(Level3ID, Level4ID).

tblTimePeriods.TimePeriodID acts like a primary key for tblLocalities.TimePeriodID.

Select a different diagram: