This is a recipes by meal plan database with 524 records by 6 categories. Each record is comprised of title, ingredient, description, prep time and cook time. In the recipes database, there are 2 important related tables of recipes, they are recipe instructions with 522 records and recipe nutrition facts with 722 records. There are 514 recipe images in the 19.84M media set.
The whole meal plan recipes database consists of 10 tables.
| Name | n3zm_Recipe_diabetes_org |
|---|---|
| Data | 2.73M (+ 0B) |
| Tables | 10 (+ 0) |
| Columns | 41 (+ 0) |
| Table Rows | 9,283 (+ 0) |
| Media | 19.84M (+ 0B) |
| Files | 514 (+ 0) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| category_1 | 6 | title |
100%
|
| category_1_x_recipe | 794 | category_1_id |
100%
|
| recipe_id |
100%
|
||
| recipe | 524 | title |
100%
|
| description |
0.76%
|
||
| prep_time |
61.64%
|
||
| cook_time |
23.09%
|
||
| ingredients |
100%
|
||
| recipe_instructions | 522 | instructions |
100%
|
| choices_exchanges |
28.16%
|
||
| recipe_nutrition_facts | 722 | key |
100%
|
| value |
99.86%
|
||
| recipe_x_recipe_image | 517 | recipe_id |
100%
|
| recipe_image_id |
100%
|
||
| recipe_x_recipe_instructions | 523 | recipe_id |
100%
|
| recipe_instructions_id |
100%
|
||
| recipe_x_recipe_nutrition_facts | 5,161 | recipe_id |
100%
|
| recipe_nutrition_facts_id |
100%
|
Notes:
- Meta columns id and ts are not shown here, but included in columns total.
- Some statistical or memo columns are not shown here, but included in columns total.
- Non-empty percentage indicates the percent of values that are non-empty for that particular column.
Media Sets
RECIPE_IMAGE_DOWNLOAD
| Size (Bytes) | Files |
|---|---|
| 19.84M | 514 |
