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.
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. |
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.
Availability Table,
Establishment Table,
Food Detective Table,
Item Table,
Suggested Regions of the USA and the World.Send comments and suggestions to:
DBA@AllergyFreeFood.orgHome | Documentation Last updated on 12/2/00