Establishment Table

This table holds information that helps to identify places where Items can be found.

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.

Table Layout

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.

Relationships

Each individual record in this table points to only one record in the Company table, but multiple records here can point to the same record in that table. This is a many to one relationship from these records to those records.

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.

See also:

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.org
Home | Documentation

Last updated on 12/12/00