cleanventory_chemicals
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
21 rows where inchi_id = 43245
Download this data as a CSV Spreadsheet (All Rows)
| cleanventory_id ▼ | inventory_id | inchi_id |
|---|---|---|
| 28273 | 30289 30289 | 43245 43245 |
| 57753 | 64567 64567 | 43245 43245 |
| 86745 | 94742 94742 | 43245 43245 |
| 216900 | 250692 250692 | 43245 43245 |
| 244066 | 279488 279488 | 43245 43245 |
| 244067 | 279489 279489 | 43245 43245 |
| 293917 | 339756 339756 | 43245 43245 |
| 323043 | 373309 373309 | 43245 43245 |
| 323044 | 373310 373310 | 43245 43245 |
| 367760 | 420837 420837 | 43245 43245 |
| 367761 | 420838 420838 | 43245 43245 |
| 367762 | 420839 420839 | 43245 43245 |
| 367763 | 420840 420840 | 43245 43245 |
| 367764 | 420841 420841 | 43245 43245 |
| 367765 | 420842 420842 | 43245 43245 |
| 367766 | 420843 420843 | 43245 43245 |
| 367767 | 420844 420844 | 43245 43245 |
| 407080 | 463005 463005 | 43245 43245 |
| 407081 | 463006 463006 | 43245 43245 |
| 424538 | 483237 483237 | 43245 43245 |
| 439210 | 498040 498040 | 43245 43245 |
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)
);