Suggestions are welcome for additional Allergen Categories.
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 |
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.
Allergen Table,
Allergens Table,
Comments Table,
Food Detective Table,
Suggested Allergen Categories.Send comments and suggestions to:
DBA@AllergyFreeFood.orgLast updated on 12/12/00