cleanventory_chemicals
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
22 rows where inchi_id = 29879
Download this data as a CSV Spreadsheet (All Rows)
| cleanventory_id ▼ | inventory_id | inchi_id |
|---|---|---|
| 5 | 5 5 | 29879 29879 |
| 42887 | 47207 47207 | 29879 29879 |
| 63749 | 71694 71694 | 29879 29879 |
| 140601 | 149676 149676 | 29879 29879 |
| 183183 | 210100 210100 | 29879 29879 |
| 183184 | 210101 210101 | 29879 29879 |
| 194667 | 222503 222503 | 29879 29879 |
| 239793 | 275075 275075 | 29879 29879 |
| 239794 | 275076 275076 | 29879 29879 |
| 277417 | 317611 317611 | 29879 29879 |
| 320612 | 370897 370897 | 29879 29879 |
| 320613 | 370898 370898 | 29879 29879 |
| 320614 | 370899 370899 | 29879 29879 |
| 364733 | 417831 417831 | 29879 29879 |
| 364734 | 417832 417832 | 29879 29879 |
| 364735 | 417833 417833 | 29879 29879 |
| 405203 | 461141 461141 | 29879 29879 |
| 405204 | 461142 461142 | 29879 29879 |
| 405205 | 461143 461143 | 29879 29879 |
| 423896 | 482596 482596 | 29879 29879 |
| 449400 | 508143 508143 | 29879 29879 |
| 477564 | 536744 536744 | 29879 29879 |
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)
);