cleanventory_chemicals
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
27 rows where inchi_id = 2847
Download this data as a CSV Spreadsheet (All Rows)
| cleanventory_id ▼ | inventory_id | inchi_id |
|---|---|---|
| 2152 | 2236 2236 | 2847 2847 |
| 6367 | 6634 6634 | 2847 2847 |
| 36543 | 38799 38799 | 2847 2847 |
| 50746 | 56479 56479 | 2847 2847 |
| 63970 | 71919 71919 | 2847 2847 |
| 68614 | 76680 76680 | 2847 2847 |
| 144155 | 154959 154959 | 2847 2847 |
| 180156 | 207095 207095 | 2847 2847 |
| 180157 | 207096 207096 | 2847 2847 |
| 202874 | 231185 231185 | 2847 2847 |
| 204309 | 235506 235506 | 2847 2847 |
| 208108 | 240674 240674 | 2847 2847 |
| 227563 | 262150 262150 | 2847 2847 |
| 227564 | 262151 262151 | 2847 2847 |
| 291519 | 336127 336127 | 2847 2847 |
| 304249 | 354486 354486 | 2847 2847 |
| 304250 | 354487 354487 | 2847 2847 |
| 304251 | 354488 354488 | 2847 2847 |
| 345483 | 398444 398444 | 2847 2847 |
| 345484 | 398445 398445 | 2847 2847 |
| 345485 | 398446 398446 | 2847 2847 |
| 393228 | 449057 449057 | 2847 2847 |
| 393229 | 449058 449058 | 2847 2847 |
| 393230 | 449059 449059 | 2847 2847 |
| 421672 | 480138 480138 | 2847 2847 |
| 429422 | 488266 488266 | 2847 2847 |
| 467780 | 526779 526779 | 2847 2847 |
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)
);