该药品数据库共有95个药理分类和31,673种药品。每个药品包含有标题，商品名称，属名，制造商，成分，提示，说明书，用法用量，不良反应，注意事项，包装，分类等字段。整个中国药品数据库共有3个表。
This is a medicine database with 31,673 drugs by 95 pharmacology categories. Each drug is comprised of title, trade name, generic name, maker, composition, indication, specification, usage and dosage, adverse reaction, attention, packet, category, etc. The whole China drugs database has 3 tables.
| Name | n3a2_yao_dxy_com_drug |
|---|---|
| Data | 74.27M (+ 0B) |
| Tables | 3 (+ 0) |
| Columns | 27 (+ 0) |
| Table Rows | 118,977 (+ 0) |
| Media | 0B (+ 0B) |
| Files | 0 (+ 0) |
Data Samples
Database APIs
Tables & Columns
| Tables | Rows | Columns | Non-empty |
|---|---|---|---|
| category_1 | 95 | title |
100%
|
| category_1_x_drug | 87,209 | category_1_id |
100%
|
| drug_id |
100%
|
||
| drug | 31,673 | title |
100%
|
| trade_name |
99.85%
|
||
| generic_name |
99.94%
|
||
| maker |
99.99%
|
||
| composition |
99.31%
|
||
| indication |
99.62%
|
||
| specification |
95.4%
|
||
| usage_and_dosage |
99.69%
|
||
| adverse_reaction |
96.44%
|
||
| taboo |
95.91%
|
||
| attention |
98.05%
|
||
| interaction |
73.47%
|
||
| packet |
97.28%
|
||
| category |
93.59%
|
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.
