For example: Blimpie is a Restaurant that is run by Blimpie International, Inc. It serves Cuisine that can be classified as Sandwiches. The establishment can accomidate Soy allergies.
Column | Type | Length | Description |
---|---|---|---|
Establishment_ID | Number (Long) |
4
|
Unique ID for each retail establishment |
Company_ID | Number (Long) |
4
|
ID of company record that this establishment relates to. |
Type | Set |
8
|
Set of establishment categories that this place falls into. -- Restaurant, Grocery Store ect. |
Name | Text |
25
|
Name of establishment. |
Cuisine | Set |
8
|
Set of cuisine types that this establishment serves. (May be an empty set.) |
Can_Accommodate | Set |
8
|
The set of allergens categories that can be accommodated by this place. (May be an empty set.) |
Cant_Accommodate | Set |
8
|
The set of allergens categories that cannot be accommodated by this place. (May be an empty set.) |
Franchise | Yes/No |
1
|
Is this establishment a franchise? (NULL if unknown.) |
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. |
Each Type and Cuisine field contains a set of values that represent entries in the Establishment Type Table and Cuisine tables respectively. Because the sets do not contain record IDs, this creates an indirect one to many relationship from these records to the records in those tables.
Each Can_Accommodate and Cant_Accommodate field contains a set of values that represent entries in the Allergen Category table. Because the sets do not contain record IDs, this creates an indirect one to many relationship from these records to the records in that tables.
Records in the Allergens and Availability tables have pointers to records in this table. Each record in the Establishment table can be pointed to by one or more records in those two tables. That is a one to many relationship from these records to those records.
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.
Allergens Table,
Allergen_Category Table,
Availability Table,
Company Table,
Cuisine Table,
Establishment Type Table,
Food Detective Table,
Suggested Establishment Types.Send comments and suggestions to:
DBA@AllergyFreeFood.orgHome | Documentation Last updated on 12/12/00