This recipes database has 1,444 records that are full of flavor, easy to prepare, and perfect for any time of day. There are title, image url, prep time, style, cook time and phase in each of the recipe. All these recipes are sorted into 8 categories, such as Fresh Low Carb Ingredients, Breakfast Recipes, Entree Recipes, Snack Recipes, Sides, Gluten Free Recipes, Dessert Recipes and Drink and Smoothie Recipes. In this recipes data, there are other 3 related tables with these recipes, they are ingredient with 3,976 records, direction with 4,498 records and 2,323 details. The whole recipes data set consists of 10 tables.
| Name | n3_chennan_recipe_atkins_com |
|---|---|
| Data | 10.09M (+ 0B) |
| Tables | 10 (+ 0) |
| Columns | 41 (+ 0) |
| Table Rows | 37,804 (+ 0) |
| Media | 56.64M (+ 0B) |
| Files | 1,400 (+ 0) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| category_1 | 8 | title |
100%
|
| category_1_x_recipe | 3,131 | category_1_id |
100%
|
| recipe_id |
100%
|
||
| detail | 2,323 | key |
100%
|
| value |
100%
|
||
| direction | 4,498 | value |
100%
|
| ingredient | 3,976 | value |
100%
|
| recipe | 1,444 | title |
100%
|
| image_url |
97.09%
|
||
| prep_time |
100%
|
||
| style |
100%
|
||
| cook_time |
100%
|
||
| phase |
100%
|
||
| recipe_x_detail | 5,776 | recipe_id |
100%
|
| detail_id |
100%
|
||
| recipe_x_direction | 4,722 | recipe_id |
100%
|
| direction_id |
100%
|
||
| recipe_x_ingredient | 11,926 | recipe_id |
100%
|
| ingredient_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
| Size (Bytes) | Files |
|---|---|
| 56.64M | 1,400 |
