In the recipes database, there are 603,704 records with title, mark, star, introduce, ratings, minutes to prepare, minutes to cook, number servings, ingredients, direction and nutritional info in each.
All these recipes are grouped into 7 categories and they are category, cuisine, course, occasion, dietary needs, time to make and recent searches. In addtion to this, there are 63,915 reviews with content, star, mark, like, hot and time in each; 51,947 image slug records and 45,786 image sum records for these recipes. In the 1.86G media set, there are 51,681 files of these food images.
The whole recipes database consists of 8 tables.
| Name | n3zm_Recipe_sparkpeople_com |
|---|---|
| Data | 1.62G (+ 239.39M) |
| Tables | 8 (- 3) |
| Columns | 48 (- 18) |
| Table Rows | 2,123,349 (- 1,843,624) |
| Media | 1.86G (+ 1.85G) |
| Files | 51,681 (+ 51,180) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| category | 7 | category |
100%
|
| image_slug | 51,947 | recipe_id |
100%
|
| image_sum | 45,786 | total |
100%
|
| recipe | 603,704 | title |
99.99%
|
| mark |
100%
|
||
| star |
10.37%
|
||
| introduce |
61.44%
|
||
| ratings |
100%
|
||
| minutes_to_prepare |
70.26%
|
||
| minutes_to_cook |
61.54%
|
||
| number_servings |
98.39%
|
||
| ingredients |
98.43%
|
||
| tip |
11.92%
|
||
| direction |
98.4%
|
||
| nutritional_info |
98.43%
|
||
| recipe_x_subcategory | 1,357,931 | recipe_id |
100%
|
| subcategory_id |
100%
|
||
| review | 63,915 | content |
95.62%
|
| recipe_id |
100%
|
||
| star |
100%
|
||
| mark |
68.77%
|
||
| like |
41.07%
|
||
| hot |
41.07%
|
||
| time |
100%
|
||
| subcategory | 59 | subcategory |
100%
|
| category |
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
FOOD_IMAGE
| Size (Bytes) | Files |
|---|---|
| 1.86G | 51,681 |
