Differences

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

--- qookie:database [2008/11/23 09:56] – deva
+++ qookie:database [2009/01/04 17:21] – 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                                                 ^
-| ''name''        | String | The name or title of the ingredient. |
+| ''unit''        | Unit    | The unit in which the ingredient is measured                |
-| ''description'' | String | A description of the ingredient. |
+| ''season''      | Season  | The season in which this ingredient can be acquired.        |
-| ''image''       | Binary | An image showing the ingredient. |
+| ''quantity''    | Integer | The usual quantity in which the ingredient can be acquired. |
+| ''density''     | Integer | Units/pr gram.                                              |
+| ''category''    | String  | To what category does this ingredient belong.               |
 ====Dish====
 A single dish is an atomic component of a dish, i.e. cheese sauce, fried potatoes, meat balls.
+^ Attribute       ^ Type    ^ Description ^
+| ''ingredients'' | List<Integer> | A list of ingredient uids, used in the dish. |
 ====Course====
 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 ^
+| ''dishes''      | List<Integer> | A list of dish uids, used in the course. |
 ====Menu====
 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 ^
+| ''courses''     | List<Integer> | A list of course uids, used in the menu. |