The Item_ID and Establishment_ID fields can provide connection between those tables as well as providing connections between those tables and the Allergen Category and Allergen tables.
Suggestions are welcome for additional Named Allergens.
Column | Type | Length | Description |
---|---|---|---|
Allergens_ID | Number (Long) |
4
|
Unique ID for each allergens type record |
Item_ID | Number (Long) |
4
|
The Record ID of the Item that this set of allergens is assocatied with. (May be Null) |
Establishment_ID | Number (Long) |
4
|
The Record ID of the Establishment that this set of allergens is assocatied with. (May be Null) |
Allergen_Category_ID | Number (Long) |
4
|
The Record ID of the general allergen category that these allergens are assocatied with. |
Allergen_ID | Number (Long) |
4
|
The Record ID of the a specific allergen that is associated with the Item or Establishment detailed above. |
Allergen_Is_Present | Yes/No |
1
|
Yes if this allergen is present in the associated Item or Estab. No if the allergen is not there. |
Comments_ID | Number (Long) |
4
|
Record ID of any comments regarding the nature of this allergen. (May be NULL) |
Modified | Date/Time |
8
|
Timestamp when this record was last modified. |
Modified_By | Number (Long) |
4
|
Record ID for the food detectivethat 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 thatcreated this record. |
Confirmed | Date/Time |
8
|
Timestamp when the information was confirmed by a second food detective. |
Confirmed_By | Number (Long) |
4
|
Record ID for the food detective that provided the second confirmation. |
Each of these records points to one record in the Allergen Category table and the Allergen table. That is a one to many relationship from those records to these records.
The Comments_ID field in this record can point to a record in the Comments table. This can be a one to one relationship between this table and to that table. If the user does not wish to add any comments about the Location, then this ID field will be NULL.
The Modified_By, Created_By and Confirmed_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.
Allergen Table,
Allergen Category Table,
Comments Table,
Establishment Table,
Food Detective Table,
Item Table,
Suggested Named Allergens.Send comments and suggestions to:
DBA@AllergyFreeFood.orgHome | Documentation Last updated on 12/12/00