***************************************************** CPE 366 Alex Dekhtyar Cal Poly Computer Science Department San Luis Obispo College of Engineering California dekhtyar@csc.calpoly.edu ***************************************************** Mark Edwards Cal Poly Animal Science Department San Luis Obispo College of Agriculture California msedward@calpoly.edu ***************************************************** NUTRITION DATASET Version 1.0 February 2, 2008 ***************************************************** Sources: The data is provided by Dr. Mark Edwards (Animal Science, Cal Poly). The dataset contains both real data, describing the animal units on Cal Poly campus, and the animal nutrition information, and simulated data. ****************************************************** This file describes the contents of the NUTRITION dataset developed for the CPE 366, Database Design, Modeling and Implementation course at Cal Poly. The dataset contains information about a large half-marathon race that took place at some point somewhere in New England. Each row represents information about one race participant, and his/her achievements in the race. General Conventions. 1. All files in the dataset are CSV (comma-separated values) files. 2. First line of each file provides the names of columns. Second line may be empty, or may contain the first row of the data. 3. All string values are enclosed in single quotes (') The dataset contains the following files: - animals.csv : information about animals - taxon.csv : information about animal taxonomy - locations.csv : information about farm locations for animal hosting - ingredient_categories.csv: information about categories of ingredients (feed) used by the nutritionists in creating diets - ingredients.csv : information about ingredients used in creating diets - diets.csv : information about animal diets - diet_assignments.csv : infromation about assignment of diets to animals - location_assignment.csv: information about of animal placement in various farm locations - inventory.csv : information about the quantity of ingredient stock - withdrawls.csv : information about the ingredient stock depletion - users.csv : information about user accounts associated with the database application Individual files have the following formats. ************************************************************************** animals.csv HouseName : Name of the animal Color_NeckBand: color of the neck band worn by the animal ID_NeckBand: ID number on the animal's neckband ID_UELN Transponder: ID number of the RFID transponder of the animal ID_Other: any other form of identification of the animal (optional) Date_Birth: Date of birth of the animal OwnerName: name of the animal's owner Date_In: date the animal arrived to the unit Note: current dataset does not include animal gender. This may change in future versions. Note: current dataset does not include animal species/breed (from taxon) for each animal. This may change in future versions. ************************************************************************** taxon.csv GroupName : common name of the species group (e.g., "cow") Scientific Name: scientific name of the species/breed Common Name : common name of the species/breed ************************************************************************** locations.csv LocationID : Unique identifier of each location (internal) Destination_Hx : Another unique identifier of each location (used by the nutrition program) Name_Hx : name of the location (not unique) Space_Type : Type of space (Barn, Paddock, Pasture, ...) Capacity : Maximum allowed number of animals that can be hosted in the space Space_Designation_New : color code for the space Subspace_Designation_New: subspace identifier (stall number for barns) Size_acres : size of the space in acres (only for pastures) Size_sqft : size of the space in square feet (unavailable for current data) ************************************************************************** ingredient_categories.csv Category_Id : unique identifier of ingredient categories (internal) Forage_category: main category of the ingredient (number) Forage_SubCategory: subcategory of the ingredient (number) Category Description: description of the category (string) ************************************************************************** ingredients.csv Ingredient ID: unique identifier of ingredients (internal) Ingredient Category: category of the ingredient (see ingredient_categories.Category_ID) Ingredient Description: description of the ingredient ORDER UNIT: unit of measurement in which the ingredient is typically purchased Order Unit Weight: weight of one order unit of ingredient Order Unit Measure: the unit in which the order unit is weighted Order Unit Case: unit in which the ingredient is delivered/ stocked (usually same as order unit, on occasion, differs) Order Unit/Case: number of order units of ingredient per case. ISSUE UNIT: unit of measurement in which the ingredient is depleted from the inventory (typically) Issue Unit Weight: weight of one issue unit of ingredient Issue Unit Measure: the unit in which the issue unit is weighted Unit : additional unit of ingredient measurement WGT : weight of one additional unit of ingredient MEASURE : unit of measure of additional units of ingredient UNIT : another additional unit of ingredient measurement WGT : weight of UNIT MEASURE : unit of measure $/UNIT: price per unit of ingredient $/LB: price per 1 LB of ingredient $/KG: price per 1 KG of ingredient SOURCE: ingredient supplier MANUFAC_ID: id of the manufacturer of the ingredient Note: UNIT, WGT (second column with this name) and MEASURE (second column with this name) are all G (for gramm), 1.0 and G (for gramm) respectively. Note: $/UNIT, $/LB, $/KG are missing for all ingredients in the dataset. Note: when converting, measurement information needs to be stored elsewhere. Note: MANUFAC_ID is not used in the dataset ************************************************************************** diets.csv Note: this file has two types of rows. Rows of type 1 include information about the type of diet (and its category/subcategory), AS WELL as information about one ingredient assignment within the diet. Rows of type 0 include only information about ingredient assignments for the diet described in the closest (from the top) row of type 1. Row_Type : type of row. 1 - contains general diet information + ingredient assignment. 0 - contains ingredient assignment. Diet_ID : unique ID of the diet (Row_Type = 1) Diet_Type: type of the diet (e.g., "Standard") (Row_Type=1) Diet_SubType: subtype of the diet (Row_Type=1) Diet_Subsubtype: subsubtype of the diet (Row_Type=1) Feeding: meal number within a single diet (all Row_Type values) Food_Item: ordinal of a food item (ingredient) within the meal (all Row_Type values) (see ingredients.Ingredient ID) Ingredient_Description: description of the ingredient (see Ingredients.Ingredient Description) Amount: quantity of ingredient to be administered during the given meal Issue_Unit: unit of the amount Issue_Weight: weight of the unit of the amount Issue_Measure: measure of the weight of the unit of the amount S: whether the meal is administered on Sunday (Y/N) M: whether the meal is administered on Monday (Y/N) T: whether the meal is administered on Tuesday (Y/N) W: whether the meal is administered on Wednsday (Y/N) R: whether the meal is administered on Thursday (Y/N) F: whether the meal is administered on Friday (Y/N) St: whether the meal is administered on Saturday (Y/N) Meal_Note: note on the meal Diet_Note: note on the diet Note: There is no column indicating the time of each meal. However, this information is found inside the Meal_Note column in the form of "AM" or "PM". ************************************************************************** diet_assignments.csv ID_NeckBand : Neckband id of an animal (see animals.ID_NeckBand and Note below) DietId : unique identifier of the diet (see diets.Diet_ID) Date_Assigned: date the diet was assigned to the specimen Assigned_By: userId of the user who completed the diet assignment (see users.userId) Note: Neckband ID is used as a unique identifier of the animal for this dataset, because all Neckband IDs in the dataset are unique. This shall be treated as internal affair. That is, this was done for convenience sake and it SHALL NOT affect YOUR choice of the primary key for the specimens (animals) table. Note: Only the assignment date is recorded in each row. ************************************************************************** location_assignment.csv ID_NeckBand : Neckband id of an animal (see animals.ID_NeckBand and Note below) LocationId : unique identifier of the loction (see locations.LocationID) Date_Assigned: date the location assignment is made UserID: userId of the user who authorized the assignment (see users.userID) Note: Neckband ID is used as a unique identifier of the animal for this dataset, because all Neckband IDs in the dataset are unique. This shall be treated as internal affair. That is, this was done for convenience sake and it SHALL NOT affect YOUR choice of the primary key for the specimens (animals) table. Note: Only the destination location is recorded in each row. ************************************************************************** inventory.csv Ingredient ID : unique id of the ingredient (see ingredients.Ingredient ID) Ingredient Description: description of the ingredient (see ingredients.Ingredient Description) Unit : unit in which the inventory is specified Quantity: quantity of the ingredient in stock date: date of the inventory entry user: userID of the user who recorded the inventory (see users.userID) ************************************************************************** withdrawls.csv Date : date of the ingredient withdrawl Time : time of the ingredient withdrawl IngredientID: unique identifier of the ingredient withdrawn (see ingredients.Ingredient ID) Quantity: amount of the withdrawn ingredient Unit: unit in which the amount is measuered UserId: userId of the user who recorded (and performed?) the withdrawl ************************************************************************** users.csv UserId : unique id of the user of the application Name: Name of the user User Category: category of the user (string), defines permissions User Category Numeric : category of the user (number) Note: User Category -> User Category Numeric and User Category Numeric -> User Category are asserted on this table. ************************************************************************** ************************************************************************** ************************************************************************** **************************************************************************