cleanventory_chemicals
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
29 rows where inchi_id = 27769
Download this data as a CSV Spreadsheet (All Rows)
| cleanventory_id ▼ | inventory_id | inchi_id |
|---|---|---|
| 17278 | 17888 17888 | 27769 27769 |
| 36505 | 38750 38750 | 27769 27769 |
| 52378 | 58432 58432 | 27769 27769 |
| 105429 | 113436 113436 | 27769 27769 |
| 160776 | 173632 173632 | 27769 27769 |
| 195166 | 222996 222996 | 27769 27769 |
| 214155 | 247827 247827 | 27769 27769 |
| 238809 | 274107 274107 | 27769 27769 |
| 238810 | 274108 274108 | 27769 27769 |
| 238811 | 274109 274109 | 27769 27769 |
| 238812 | 274110 274110 | 27769 27769 |
| 289473 | 333305 333305 | 27769 27769 |
| 319944 | 370128 370128 | 27769 27769 |
| 319945 | 370129 370129 | 27769 27769 |
| 319946 | 370130 370130 | 27769 27769 |
| 319947 | 370131 370131 | 27769 27769 |
| 319948 | 370132 370132 | 27769 27769 |
| 363983 | 416972 416972 | 27769 27769 |
| 363984 | 416973 416973 | 27769 27769 |
| 363985 | 416974 416974 | 27769 27769 |
| 363986 | 416975 416975 | 27769 27769 |
| 363987 | 416976 416976 | 27769 27769 |
| 363988 | 416977 416977 | 27769 27769 |
| 363989 | 416978 416978 | 27769 27769 |
| 404726 | 460583 460583 | 27769 27769 |
| 404727 | 460584 460584 | 27769 27769 |
| 423736 | 482373 482373 | 27769 27769 |
| 448408 | 507163 507163 | 27769 27769 |
| 477231 | 536406 536406 | 27769 27769 |
CREATE TABLE [cleanventory_chemicals] (
[cleanventory_id] integer PRIMARY KEY,
[inventory_id] integer,
[inchi_id] integer,
FOREIGN KEY (inventory_id) REFERENCES inventories(inventory_id),
FOREIGN KEY (inchi_id) REFERENCES substances(inchi_id)
);