cleanventory_chemicals
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
19 rows where inchi_id = 40743
Download this data as a CSV Spreadsheet (All Rows)
| cleanventory_id ▼ | inventory_id | inchi_id |
|---|---|---|
| 7758 | 8021 8021 | 40743 40743 |
| 31741 | 33716 33716 | 40743 40743 |
| 55315 | 61857 61857 | 40743 40743 |
| 71654 | 79703 79703 | 40743 40743 |
| 145749 | 156547 156547 | 40743 40743 |
| 192779 | 220587 220587 | 40743 40743 |
| 216506 | 250295 250295 | 40743 40743 |
| 243332 | 278743 278743 | 40743 40743 |
| 243333 | 278744 278744 | 40743 40743 |
| 288961 | 332537 332537 | 40743 40743 |
| 322678 | 372962 372962 | 40743 40743 |
| 322679 | 372963 372963 | 40743 40743 |
| 367330 | 420430 420430 | 40743 40743 |
| 367331 | 420431 420431 | 40743 40743 |
| 367332 | 420432 420432 | 40743 40743 |
| 406779 | 462715 462715 | 40743 40743 |
| 406780 | 462716 462716 | 40743 40743 |
| 424423 | 483122 483122 | 40743 40743 |
| 431300 | 490133 490133 | 40743 40743 |
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)
);