Relationships

Each individual record in this table points to only one record in the Allergen
Category table, but multiple records here can point to the same record
in that table. This is a many to one relationship from these records to
those records.

Each record in the Allergens
table points to one record in this table. That is a one to many relationship
from these records to those records.

The Comments_ID field in this record can point to a record in the Comments
table. This can be a one to one relationship between this table and
to that table. If the user does not wish to add any comments about the
Location, then this ID field will be NULL.

The Modified_By and Created_By fields in these records each point to
single records in the Food
Detective table. Because a food detective can create multiple entries
in the database, this can produce a many to one relationship between these
records and the Food Detective records.