In the recipes database, there are 23,061 records by 35 categories. Each record consists of title, description, direction, ingredient and nutrition. Beside, it also has 831 recipe images in the 33.91M media set and 186 recipe videos in the data.
The whole recipes database consists of 11 tables.
| Name | n3zm_Recipe_bhg_com |
|---|---|
| Data | 38.16M (+ 0B) |
| Tables | 11 (+ 0) |
| Columns | 46 (+ 0) |
| Table Rows | 284,256 (+ 0) |
| Media | 33.91M (+ 0B) |
| Files | 417 (+ 0) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| category_1 | 35 | title |
100%
|
| category_2 | 358 | title |
100%
|
| category_1_id |
100%
|
||
| category_1 |
100%
|
||
| category_2_x_recipe | 257,988 | category_2_id |
100%
|
| recipe_id |
100%
|
||
| recipe | 23,061 | title |
100%
|
| description |
2.38%
|
||
| directions |
2.84%
|
||
| ingredients |
2.84%
|
||
| nutrition |
2.73%
|
||
| recipe_from_the_kitchen | 368 | key |
75.82%
|
| value |
100%
|
||
| recipe_x_recipe_from_the_kitchen | 400 | recipe_id |
100%
|
| recipe_from_the_kitchen_id |
100%
|
||
| recipe_x_recipe_image | 834 | recipe_id |
100%
|
| recipe_image_id |
100%
|
||
| recipe_x_recipe_vedio | 195 | recipe_id |
100%
|
| recipe_vedio_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 |
|---|---|
| 33.91M | 417 |
