cleanventory_chemicals
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
21 rows where inchi_id = 49797
Download this data as a CSV Spreadsheet (All Rows)
| cleanventory_id ▼ | inventory_id | inchi_id |
|---|---|---|
| 31479 | 33454 33454 | 49797 49797 |
| 56931 | 63591 63591 | 49797 49797 |
| 73219 | 81250 81250 | 49797 49797 |
| 146254 | 157047 157047 | 49797 49797 |
| 191041 | 218822 218822 | 49797 49797 |
| 218235 | 252043 252043 | 49797 49797 |
| 246498 | 281935 281935 | 49797 49797 |
| 246499 | 281936 281936 | 49797 49797 |
| 263470 | 299990 299990 | 49797 49797 |
| 324951 | 375214 375214 | 49797 49797 |
| 324952 | 375215 375215 | 49797 49797 |
| 369847 | 422921 422921 | 49797 49797 |
| 369848 | 422922 422922 | 49797 49797 |
| 369849 | 422923 422923 | 49797 49797 |
| 369850 | 422924 422924 | 49797 49797 |
| 369851 | 422925 422925 | 49797 49797 |
| 369852 | 422926 422926 | 49797 49797 |
| 408417 | 464340 464340 | 49797 49797 |
| 424850 | 483549 483549 | 49797 49797 |
| 432052 | 490880 490880 | 49797 49797 |
| 469464 | 528448 528448 | 49797 49797 |
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)
);