Comments are optional on the records where they are allowed. By putting the comments in a separate table, space should be saved in the other tables and searching will be more efficient.
|Unique ID for each comment record|
|Timestamp when this record was last modified.|
|Record ID for the food detective that last updated this record.|
|Timestamp when this record was created.|
|Record ID for the food detective that created this record.|
|Comment_Text||Text||variable||The text of the comments.|
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 Category Table,
Food Detective Table,
Send comments and suggestions to:
Home | Documentation
Last updated on 12/11/00