TABLE_(RECIPES)
INT_ (ID) PRIMARY_KEY AUTO_INCREMENT
STRING_ (TITLE, 1024)
STRING_ (DESCRIPTION, 4096)
STRING_ (SOURCE, 1024)
STRING_ (PREPARATION, 30000)
INT_ (RATING)
DOUBLE_ (SERVINGS)
INT_ (PREPTIME)
INT_ (COOKTIME)
BLOB_ (PHOTO)
BLOB_ (THUMB)
END_TABLE
TABLE_(INGREDIENTS)
INT (ID) PRIMARY_KEY AUTO_INCREMENT
STRING_ (HEADER, 1024)
INT_ (AMOUNT)
INT_ (POSITION)
INT (INGREDIENT_ID) REFERENCES(INGREDIENT_DICT)
INT (UNIT_ID) REFERENCES(UNIT_DICT)
END_TABLE
TABLE_(CATEGORIES)
INT (ID) PRIMARY_KEY AUTO_INCREMENT
INT (CAT_ID) REFERENCES(CATEGORIES_DICT) UNIQUE
END_TABLE
TABLE_(CATEGORY_DICT)
INT_ (CAT_ID) PRIMARY_KEY
STRING_ (CATEGORY, 64) UNIQUE
END_TABLE
TABLE_(UNIT_DICT)
INT_ (UNIT_ID) PRIMARY_KEY
STRING_ (UNIT, 64) UNIQUE
END_TABLE
TABLE_(INGREDIENT_DICT)
INT_ (INGREDIENT_ID) PRIMARY_KEY
STRING_ (INGREDIENT, 1024) UNIQUE
END_TABLE