Locality

Description:

 Name                            Null?    Type
 ------------------------------- -------- ----
 LOCALITY_ID                     NOT NULL NUMBER
 NAMED_PLACE_ID                           NUMBER
 LOCALITY_NAME                            VARCHAR2(50)

Primary Key:

Locality_ID

Foreign Key:

Named_Place_ID

The Named_Place_ID leads to the geographical name portion of the database via the Named_Place table. The Locality_Name and the Place_Name in the Named_Place table may be identical, but not necessarily (for example, my backyard --a locality name-- in Columbus, Ohio --a place name).

The same value of Locality_ID serves as the primary key for the Geometric_Locality table.

• Return to the Collecting_Event Cluster page.
• Return to the first list of database table clusters.
• Return to the OSU Insect Collection home page.