这是一个包含有17,688个菜品，菜系的菜谱大全。这些菜谱被分为以下6大类别：菜式菜品，菜系，时令食材，功效，场景和工艺口味。在每个菜谱记录中包含有标题，浏览次数，制作时间，准备时间，用餐人数，点赞人数，食物简介和小贴士。除此之外，在步骤表和食材表中分别包含有156,164个步骤和27,446食材记录。该菜肴数据库中还有170,526张图片，这些菜谱图片存储在8.81G菜谱媒体文件中。整个菜谱数据库共有10个表。
This is a recipes database with 17,688 records by 6 categories (dishes, style of cooking, seasonal ingredients, effect, scene and arts & tastes). Each recipe record consists of title, view times, make time, prepare time, number of diners, number of give the thumbs-up, food brief and tips. Besides, there are 156,164 steps and 27,446 food materials for these recipes. It also comes with 170,526 recipes images in the 8.81G media sets. There are 10 tables in the whole dishes database.
| Name | n3_chennan_CS_caipu_haodou_com |
|---|---|
| Data | 267.72M (+ 0B) |
| Tables | 10 (+ 0) |
| Columns | 46 (+ 0) |
| Table Rows | 697,909 (+ 0) |
| Media | 8.81G (+ 0B) |
| Files | 168,955 (+ 0) |
Data Samples
- By Table / Main (Desktop) / JSON / XML / Excel / CSV (Download)
- By Table / Main (Desktop) / JSON / XML / Excel / CSV (Download)
Database APIs
Media Files
- caipu_image Bytes: 8.81G / Files: 168,955
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| buzhou | 156,164 | value |
100%
|
| caipu | 17,688 | title |
100%
|
| liulan_cishu |
99.79%
|
||
| zhizuo_shijian |
99.79%
|
||
| zhunbei_shijian |
99.79%
|
||
| yongcan_renshu |
99.79%
|
||
| dianzan_renshu |
96.43%
|
||
| shiwu_jianjie |
96.38%
|
||
| xiaotieshi |
99.6%
|
||
| caipu_x_buzhou | 170,152 | caipu_id |
100%
|
| buzhou_id |
100%
|
||
| caipu_x_shicai | 136,330 | caipu_id |
100%
|
| shicai_id |
100%
|
||
| category_1 | 6 | title |
100%
|
| category_2 | 51 | title |
100%
|
| category_1_id |
100%
|
||
| category_2_x_caipu | 19,546 | category_2_id |
100%
|
| caipu_id |
100%
|
||
| image | 170,526 | caipu_id |
100%
|
| alt |
98.33%
|
||
| shicai | 27,446 | key |
100%
|
| value |
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
CAIPU_IMAGE
| Size (Bytes) | Files |
|---|---|
| 8.81G | 168,955 |
