Differences

This shows you the differences between two versions of the page.

--- qookie:database [2008/11/23 12:39] – deva
+++ qookie:database [2009/01/04 19:09] (current) – deva
@@ Line 15: / Line 15: @@
 =====Data definitions=====
+====Component====
+A component is the super class of all data components in Qookie. It contain all common attributes:\\
+^ Attribute       ^ Type    ^ Description ^
+| ''uid''         | Integer | A unique number defining this component. |
+| ''name''        | String  | The name or title of the component. |
+| ''description'' | String  | A short description of the component. |
+| ''image''       | Binary  | An image of the component. |
+===Preparation sequence===
+A named sequence of text blobs or images with a text blob, containing the atomic steps in a preparation procedure.
 ====Ingredient====
 A basic ingredient, such as flour, an egg or a tomato.\\
 An ingredient is made out of the following attributes:
-^ Attribute       ^ Type    ^ Description ^
+^ Attribute       ^ Type    ^ Description                                                 ^
-| ''uid''         | Integer | A unique number defining this ingredient. |
+| ''unit''        | Unit    | The unit in which the ingredient is measured                |
-| ''name''        | String  | The name or title of the ingredient. |
+| ''season''      | Season  | The season in which this ingredient can be acquired.        |
-| ''description'' | String  | A description of the ingredient. |
+| ''quantity''    | Integer | The usual quantity in which the ingredient can be acquired. |
-| ''image''       | Binary  | An image showing the ingredient. |
+| ''density''     | Integer | Units/pr gram.                                              |
+| ''category''    | String  | To what category does this ingredient belong.               |
-====Dish====
+====Recipe====
-A single dish is an atomic component of a dish, i.e. cheese sauce, fried potatoes, meat balls.
+A recipe is an atomic component of a dish, i.e. cheese sauce, fried potatoes, meat balls.
 ^ Attribute       ^ Type    ^ Description ^
-| ''uid''         | Integer | A unique number defining this dish. |
-| ''name''        | String  | The name or title of the dish. |
-| ''description'' | String  | A description of the dish. |
-| ''image''       | Binary  | An image showing the dish. |
 | ''ingredients'' | List<Integer> | A list of ingredient uids, used in the dish. |
@@ Line 36: / Line 47: @@
 A course is a combination of several dishes all served together at the same time, i.e. fried potatoes with meat balls and cheese sauce.
 ^ Attribute       ^ Type    ^ Description ^
-| ''uid''         | Integer | A unique number defining this course. |
-| ''name''        | String  | The name or title of the course. |
-| ''description'' | String  | A description of the course. |
-| ''image''       | Binary  | An image showing the course. |
 | ''dishes''      | List<Integer> | A list of dish uids, used in the course. |
@@ Line 45: / Line 52: @@
 A menu is a combination of dishes to be served together or after each other. A standard menu is aperitif, starter, main course and desert.
 ^ Attribute       ^ Type    ^ Description ^
-| ''uid''         | Integer | A unique number defining this menu. |
-| ''name''        | String  | The name or title of the menu. |
-| ''description'' | String  | A description of the menu. |
-| ''image''       | Binary  | An image showing the menu. |
 | ''courses''     | List<Integer> | A list of course uids, used in the menu. |