Suggestions are welcome for additional Establishment Types.
|Unique ID for each establishment type record|
|A title or name for a type of cuisine|
|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 types of establishments. If this ends up being true, I will only have to restructure the Establishment table so that it has a more direct relationship to this table.
Food Detective Table,
Suggested Establishment Types.
Send comments and suggestions to:
Home | Documentation
Last updated on 12/12/00