Region Table

The records in this table detail general areas where Items and Establishments can be found.  If a user finds an item that they wish to purchase or a place they want to patronize, the information in these records should give them a general idea where the things can be found.

As examples: Popeye's Chicken can be found in the South and Tom Thumb grocery stores can be found in Texas.

Suggestions are welcome for additional regions of the USA and the World.

Table Layout

Column Type Length Description
Region_ID Number (Long)
4
Unique ID for this region of availability
Country Text
25
Name of the country where something is available.
State Text
15
Name of State in the country where something is available.
City Text
20
Name of City where something is available.
Region Text
25
Name of the general region or State where something is.
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

These records are used by the Availability table.  Each record in that table can point to one record in this table. That is a one to one relationship from those records to these records.

By way of the Availability table, these records are used indirectly by the Item and Establishment tables.  Each record in those tables can point to one or more records in this table via the Availability table. That is a one to many relationship from those records to these 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:

Availability Table,
Establishment Table,
Food Detective Table,
Item Table,
Suggested Regions of the USA and the World.

Send comments and suggestions to:
DBA@AllergyFreeFood.org

Home | Documentation

Last updated on 12/2/00