In the recipes database, there are 593,068 records with title, author, introduction, ingredient, direction and nutritional information in each. All these recipes are categorized into 59 classifications, such as poultry, fish, Asian, dessert, salad, etc. The whole recipes database consists of 4 tables.
| Name | n3zm_Recipe_sparkpeople_com |
|---|---|
| Data | 263.52M (+ 0B) |
| Tables | 4 (+ 0) |
| Columns | 20 (+ 0) |
| Table Rows | 1,956,240 (+ 0) |
| Media | 17.92M (+ 0B) |
| Files | 500 (+ 0) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| category_1 | 59 | title |
100%
|
| category_1_x_recipe | 1,363,113 | category_1_id |
100%
|
| recipe_id |
100%
|
||
| recipe | 593,068 | title |
100%
|
| author |
2.62%
|
||
| introduction |
2.02%
|
||
| ingredients |
2.68%
|
||
| directions |
0%
|
||
| nutritional_info |
2.68%
|
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 |
|---|---|
| 17.92M | 500 |
