Item Table

This table holds information about things that can be classified under differing Item Categories. In addition, information can be collected regarding what Allergens are present or absent within the thing in question.

For example: Pizza could be a Frozen Prepared Food made by Pillsbury. It might contain Soy and Tomato allergens but be free of all types of Corn.

Table Layout

Column Type Length Description
Item_ID Number (Long)
4
 Unique ID for each item.
Company_ID Number (Long)
4
 Record ID of company record that this establishment relates to.
Name Text
25
 Name of establishment.
Item_Categories Set
8
 Set of item categories that this item fits into.
Allergens_Present Set
8
 The set of allergens categories that this item contains.
Allergens_Absent Set
8
 The set of allergens categories that this item is free of.
Is_GMO_Free Yes/No
1
 Yes if the item is free of all genetically modified ingredients. No if the item contains genetically modified ingredients. NULL if unknown.
Is_Certified_Organic Yes/No
1
 Yes if it has been certified that the item only contains organic ingredients. No if the item has not been certified. 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.

The Item_Categories field contains a set of values that represent entries in the Item 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 table.

Each Allergens_Present and Allergens_Absent field contains a set of values that represent entries in the Allergen Category table 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,
Food Detective Table,
Item Category Table,
Suggested Item Categories,
Suggested Named Allergens.
Send comments and suggestions to:
DBA@AllergyFreeFood.org
Home | Documentation

Last updated on 12/12/00