Allergen Category Table

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)	4	Unique ID for each allergen type record
Name	Text	25	The general category name of this allergen
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 detective that 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 that created this record

Relationships

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.