cleanventory_chemicals
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
28 rows where inchi_id = 195799
Download this data as a CSV Spreadsheet (All Rows)
| cleanventory_id ▼ | inventory_id | inchi_id |
|---|---|---|
| 14039 | 14463 14463 | 195799 195799 |
| 14040 | 14464 14464 | 195799 195799 |
| 14041 | 14465 14465 | 195799 195799 |
| 31779 | 33763 33763 | 195799 195799 |
| 31780 | 33764 33764 | 195799 195799 |
| 31781 | 33765 33765 | 195799 195799 |
| 48460 | 53721 53721 | 195799 195799 |
| 62336 | 69994 69994 | 195799 195799 |
| 62338 | 69996 69996 | 195799 195799 |
| 93299 | 101338 101338 | 195799 195799 |
| 154830 | 165854 165854 | 195799 195799 |
| 154831 | 165855 165855 | 195799 195799 |
| 184767 | 211871 211871 | 195799 195799 |
| 184768 | 211872 211872 | 195799 195799 |
| 224482 | 258863 258863 | 195799 195799 |
| 224483 | 258864 258864 | 195799 195799 |
| 224484 | 258865 258865 | 195799 195799 |
| 259330 | 295528 295528 | 195799 195799 |
| 259331 | 295529 295529 | 195799 195799 |
| 259332 | 295530 295530 | 195799 195799 |
| 259334 | 295532 295532 | 195799 195799 |
| 297179 | 344496 344496 | 195799 195799 |
| 442298 | 501173 501173 | 195799 195799 |
| 442299 | 501174 501174 | 195799 195799 |
| 442300 | 501175 501175 | 195799 195799 |
| 474342 | 533426 533426 | 195799 195799 |
| 474343 | 533427 533427 | 195799 195799 |
| 474344 | 533428 533428 | 195799 195799 |
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)
);