Allergen_Category Table

This table holds the names of all the major food allergen or intolerance categories. Examples would include names such as Soy, Corn and Lactose.

Suggestions are welcome for additional Allergen Categories.

Table Layout

Column Type Length Description
Allergen_Category_ID Number (Long)
Unique ID for each allergen type record
Name Text
The general category name of this allergen
Comments_ID Number (Long)
Record ID of any comments regarding the nature of this allergen. (May be NULL)
Modified Date/Time
Timestamp when this record was last modified.
Modified_By Number (Long)
Record ID for the food detective that last updated this record.
Created Date/Time
Timestamp when this record was created.
Created_By Number (Long)
Record ID for the food detective that created this record


These records are used by the Allergen and Allergens tables.  Each record in those tables points to only one record in this table. This 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 the Allergen Category, 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.

See also:

Allergen Table,
Allergens Table,
Comments Table,
Food Detective Table,
Suggested Allergen Categories.
Send comments and suggestions to:

Home | Documentation

Last updated on 12/12/00