FOOD_EVENTS

Each row represents a food eaten during a food bout recorded during a follow. When more than one food was eaten during a bout, this table contains one row for each food eaten.

The conversion of transcribed food-related text

The MS Access database recorded FoodPartWritten and FoodNameWritten in separate columns, but contained only one value for each no matter how many food items were consumed. Consequently, the conversion of the MS Access data into SokweDB placed each of these values into a single FOOD_EVENTS row, no matter how many foods were consumed during the related food bout – no matter how many FOOD_EVENTS rows are related to the EVENTS row representing the food bout.

The data in these columns was placed in the first FOOD_EVENTS row of the food bout, the row with a Seq value of 1. The FoodPartWritten and FoodNameWritten columns of converted rows with Seq values of 2 contain the empty string, even when there was transcribed text.

Note that there may be post-conversion data alterations and the situation described above may not persist.

The related EVENTS row must be a food event; it must have an EVENTS.Behavior value of FOOD. This related EVENTS row supplies the start and ending times of the food bout, relates to the follow, and relates to the ROLES row that identifies the individual who consumed the food.

The value of the Seq column must begin with 1 and increase, without gaps, with every additional FOOD_EVENTS row related to a given EVENTS row. This condition is checked on transaction commit.

For further information, including additional data integrity rules, see the documentation of the EVENTS table.

FEID (Food Event IDentifier)

A unique, automatically generated, positive integer which serves to identify the row. The value of this column cannot be changed. This column may not be NULL.

EID (Event ID)

The EVENTS.EID identifying the food bout event. The related event contains information on the start and stop times of the food bout and is related to the participant, the individual consuming the food.

This column may not be NULL.

FoodPart

A code indicating the part of the food source consumed. A FOOD_PARTS.Part value. This column may not be NULL.

FoodName

A code indicating the food source consumed. A FOOD_NAMES.Food value. This column may not be NULL.

FoodPartWritten

A transcription of the text written in the field that describes the food part. This column may not be NULL.

FoodNameWritten

A transcription of the text written in the field that describes the food part. This column may not be NULL.

Seq (written Sequencing)

A positive integer indicating the sequence in which the food consumed was recorded, when more than one food is consumed during a food bout.

The value of this column may not be useful, or have any real significance. This column exists so that information (the order in which the food consumed was written) is not lost in the conversion from written records to digitized records.

This column may not be NULL.

Page last generated: 2026-05-14 17:24:24 UTC