这是一个药品信息数据库，有8大分类下（西药，中成药，医疗机械，保健食品等）60个分类的214,902种药品。每种药品信息记录中有规格，形状，代码，治疗，价格，药品，批准号，包装，制造商和类型。在药品详情表中包含有1,978,762个药品详情， 每个详情记录中有药物信息重点和药物相关的具体内容。整个药品信息数据库共有6个表。
This medicines database has 214,902 records by 60 categories. Each medicine is comprised of unit, shape, code, treatment, price, medicine, approval number, packaging, maker, and type. It contains 1,978,762 medicine detail records with key and content in each. There are 199,162 files of medicine images in the 1.92G media set. The whole medicines API totally has 6 tables.
| Name | n3_chennan_CS_yaopin_315jiage_cn |
|---|---|
| Data | 385.50M (+ 125.62M) |
| Tables | 6 (+ 3) |
| Columns | 44 (+ 18) |
| Table Rows | 2,639,137 (+ 2,539,946) |
| Media | 1.92G (+ 1.92G) |
| Files | 199,162 (+ 199,162) |
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| medicine_detail | 1,978,762 | content |
100%
|
| key |
100%
|
||
| medicine_id |
100%
|
||
| medicine | 214,902 | unit |
87.98%
|
| shape |
50.77%
|
||
| code |
88.14%
|
||
| treatment |
53.46%
|
||
| price |
88.14%
|
||
| medicine |
100%
|
||
| approval_number |
99.95%
|
||
| packaging |
99.93%
|
||
| maker |
99.98%
|
||
| type |
42.89%
|
||
| category | 60 | top |
100%
|
| category |
100%
|
||
| category_x_medicine | 230,511 | category_id |
100%
|
| medicine_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
PHOTO_IMAGE
| Size (Bytes) | Files |
|---|---|
| 1.92G | 199,162 |
