Suggestions are welcome for additional Item Categories.
|Unique ID for the food category record|
|Text description for the food category|
|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.|
1. By maintaining the names it will help me to build the UI for user queries and reports.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.
2. Since fields of the Set type have a maximum of 64 total members, a Set might prove to be inadequate to hold all the types of specific item categories. If this ends up being true, I will only have to restructure the Item table so that it has a more direct relationship to this table.
Food Detective Table,
Suggested Item Categories.
Send comments and suggestions to:
Home | Documentation
Last updated on 12/12/00