Recipe Attributes

Gourmet recipes have the following attributes:

RECIPE ATTRIBUTES
Column	Format	What it is	Notes
title	text	The title
instructions	text (with xml formatting markup)	The instructions.
modifications	text (with xml formatting markup)	"notes" field in interface
source	text	the author or source of the recipe
link	text ( a url)	a link to a webpage associated with the recipe
preptime	int	The time it takes to prepare the recipe (stored in seconds)	In the importer, you can use text here and Gourmet will try to convert from HH:MM:SS
cooktime	int	The time it takes to cook the recipe (total) (stored in seconds)	See preptime
servings	float	The number of people the recipe is designed to serve	This may be replaced in the future with two columns for "yield" and "yield unit". If it is, all current columns would be converted (we'd simply set yield_unit to servings.
FIELDS YOU PROBABLY SHOULDN'T MESS WITH
Column	Format	What it is	Notes
image	binary	An image of the recipe	basically, this is a jpeg file stored internally.
thumb	binary	the thumbnail of the recipe image	see image
deleted	bool		if True, the recipe is in the "Trash"
last_modified	int	a timestamp
FIELDS YOU DEFINITELY SHOULDN'T MESS WITH
Column	Format	What it is	Notes
id	int		The unique identifier for the recipe
recipe_hash	VARCHAR(32)		A hash for uniquely identifying the recipe information
ingredient_hash	VARCHAR(32)		A hash for uniquely identifying the ingredient information
last_modified
FIELDS DEFINED BUT NEVER USED
Column	Format	What it is	Notes
description	text		Presumably I had originally thought we might want the interface to show an overall "description" of the recipe in addition to the instructions and the notes. Seems like a good idea, but not yet implemented.