Allergens Table

Each Item or Establishment record can have a set of Allergens associated with it.  Those allergens are broken up into groups by major Allergen Categories.  Each record in this table represents a specific Allergen associated with the Allergen Categories of each Item or Establishment.

The Item_ID and Establishment_ID fields can provide connection between those tables as well as providing connections between those tables and the Allergen Category and Allergen tables.

Suggestions are welcome for additional Named Allergens.

Table Layout

Column Type Length Description
Allergens_ID Number (Long)
4
Unique ID for each allergens type record
Item_ID Number (Long)
4
The Record ID of the Item that this set of allergens is assocatied with. (May be Null)
Establishment_ID Number (Long)
4
The Record ID of the Establishment that this set of allergens is assocatied with. (May be Null)
Allergen_Category_ID Number (Long)
4
The Record ID of the general allergen category that these allergens are assocatied with.
Allergen_ID Number (Long)
4
The Record ID of the a specific allergen that is associated with the Item or Establishment detailed above.
Allergen_Is_Present Yes/No
1
Yes if this allergen is present in the associated Item or Estab. No if the allergen is not there.
Comments_ID Number (Long)
4
Record ID of any comments regarding the nature of this allergen. (May be NULL)
Modified Date/Time
8
Timestamp when this record was last modified.
Modified_By Number (Long)
4
Record ID for the food detectivethat last updated this record.
Created Date/Time
8
Timestamp when this record was created.
Created_By Number (Long)
4
Record ID for the food detective thatcreated this record.
Confirmed Date/Time
8
Timestamp when the information was confirmed by a second food detective.
Confirmed_By Number (Long)
4
Record ID for the food detective that provided the second confirmation.

Relationships

These records are used by the Item and Establishment tables.  Each record in those tables can point to one or more records in this table. That is a one to many relationship from those records to these records.

Each of these records points to one record in the Allergen Category table and the Allergen table.  That is a one to many relationship from those records to these 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, Created_By and Confirmed_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.

See also:

Allergen Table,
Allergen Category Table,
Comments Table,
Establishment Table,
Food Detective Table,
Item Table,
Suggested Named Allergens.
Send comments and suggestions to:
DBA@AllergyFreeFood.org
Home | Documentation

Last updated on 12/12/00