该药品信息数据库共有20个分类下的26,410种药品。每种药品信息中有产品分类，英文名称，批准文号，主要规格，公司名称，联系人，联系电话，手机，传真，电子邮件，邮政编码，联系地址，包装，用法，产品说明，所在地区，所属行业，公司类型，邮政编码等。整个药品信息数据库共有3个表。
In the medicines database, it has 26,410 records by 20 categories. Each medicine is comprised of category, English name, approval number, main specification, company name, contact, mobile phone, telephone number, fax number, email, post code, address, packaging, usage, description, location, industry, company type, post code, etc. The whole medicines API totally has 3 tables.
| Name | n3_chennan_CS_yaopin_pharmnet_com_cn |
|---|---|
| Data | 16.56M (+ 0B) |
| Tables | 3 (+ 0) |
| Columns | 39 (+ 0) |
| Table Rows | 52,840 (+ 0) |
| Media | 0B (+ 0B) |
| Files | 0 (+ 0) |
Data Samples
Database APIs
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| category_1 | 20 | title |
100%
|
| category_1_x_yaopin | 26,410 | category_1_id |
100%
|
| yaopin_id |
100%
|
||
| yaopin | 26,410 | title |
100%
|
| chanpin_fenlei |
94.33%
|
||
| yingwen_mingcheng |
4.35%
|
||
| pizhun_wenhao |
94.3%
|
||
| zhuyao_guige |
93%
|
||
| gongsi_mingcheng |
91.33%
|
||
| lianxiren |
14.47%
|
||
| lianxi_dianhua |
89.2%
|
||
| shouji |
6.82%
|
||
| chuanzhen |
73.78%
|
||
| dianzi_youjian |
46.21%
|
||
| youzheng_bianma |
83.23%
|
||
| lianxi_dizhi |
90.92%
|
||
| keshi_fenlei |
0.28%
|
||
| baozhuang |
2.9%
|
||
| jiage |
0.01%
|
||
| yongfa |
0.48%
|
||
| yongtu |
2.61%
|
||
| chanpin_shuoming |
2.26%
|
||
| suozai_diqu |
3.1%
|
||
| suoshu_hangye |
0.38%
|
||
| gongsi_leixing |
2.83%
|
||
| lianxi_chuanzhen |
0.29%
|
||
| shangpinming |
0.02%
|
||
| suozhu_hangye |
2.72%
|
||
| youzhwng_bianma |
1.93%
|
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
No media sets.
