cleanventory_chemicals
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
27 rows where inchi_id = 10097
Download this data as a CSV Spreadsheet (All Rows)
| cleanventory_id ▼ | inventory_id | inchi_id |
|---|---|---|
| 7342 | 7604 7604 | 10097 10097 |
| 27464 | 29475 29475 | 10097 10097 |
| 49821 | 55483 55483 | 10097 10097 |
| 70223 | 78280 78280 | 10097 10097 |
| 109481 | 117456 117456 | 10097 10097 |
| 145226 | 156029 156029 | 10097 10097 |
| 162919 | 176358 176358 | 10097 10097 |
| 180812 | 207750 207750 | 10097 10097 |
| 180813 | 207751 207751 | 10097 10097 |
| 199319 | 227431 227431 | 10097 10097 |
| 210681 | 243795 243795 | 10097 10097 |
| 232720 | 267715 267715 | 10097 10097 |
| 232721 | 267716 267716 | 10097 10097 |
| 232722 | 267717 267717 | 10097 10097 |
| 272247 | 311167 311167 | 10097 10097 |
| 315301 | 365314 365314 | 10097 10097 |
| 315302 | 365315 365315 | 10097 10097 |
| 358715 | 411494 411494 | 10097 10097 |
| 358716 | 411495 411495 | 10097 10097 |
| 358717 | 411496 411496 | 10097 10097 |
| 358718 | 411497 411497 | 10097 10097 |
| 401286 | 456978 456978 | 10097 10097 |
| 401287 | 456979 456979 | 10097 10097 |
| 422730 | 481212 481212 | 10097 10097 |
| 430532 | 489370 489370 | 10097 10097 |
| 468619 | 527615 527615 | 10097 10097 |
| 478101 | 537296 537296 | 10097 10097 |
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)
);