Suggestions are welcome for additional Item Categories.
Column | Type | Length | Description |
---|---|---|---|
Item_Category_ID | Number (Long) |
4
|
Unique ID for the food category record |
Name | Text |
25
|
Text description for the food category |
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. |
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.
Item Table,
Food Detective Table,
Suggested Item Categories.Send comments and suggestions to:
DBA@AllergyFreeFood.orgHome | Documentation Last updated on 12/12/00