| queries | ||||||||
| Key | Column name | Type | Size | Decimals | Unsigned | Nullable | Default | Auto increment |
| Pri | id | int | 11 | Yes | NULL | Yes | ||
| Index | user_id | int | 11 | Yes | Yes | NULL | ||
| ranking | tinyint | 1 | Yes | Yes | 3 | |||
| serving | tinyint | 1 | Yes | Yes | 3 | |||
| fridge | varchar | 100 | Yes | NULL | ||||
| appetite | varchar | 100 | Yes | NULL | ||||
| complexity | tinyint | 1 | Yes | Yes | 3 | |||
| settings | ||||||||
| Key | Column name | Type | Size | Decimals | Unsigned | Nullable | Default | Auto increment |
| Pri | id | int | 11 | Yes | NULL | Yes | ||
| allergy | varchar | 120 | Yes | NULL | ||||
| instrumente | varchar | 120 | Yes | NULL | ||||
| vegetarier | char | 1 | 0 | |||||
| kocherfahrung | tinyint | 1 | Yes | 3 | ||||
| Index | user_id | int | 11 | Yes | Yes | NULL | ||
| users | ||||||||
| Key | Column name | Type | Size | Decimals | Unsigned | Nullable | Default | Auto increment |
| Pri | id | int | 11 | Yes | NULL | Yes | ||
| Index | login | varchar | 80 | Yes | NULL | |||
| password | varchar | 40 | Yes | NULL | ||||