cleanventory_chemicals
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
21 rows where inchi_id = 147884
Download this data as a CSV Spreadsheet (All Rows)
| cleanventory_id ▼ | inventory_id | inchi_id |
|---|---|---|
| 9709 | 9989 9989 | 147884 147884 |
| 14616 | 15075 15075 | 147884 147884 |
| 39747 | 42225 42225 | 147884 147884 |
| 48266 | 53519 53519 | 147884 147884 |
| 78835 | 86839 86839 | 147884 147884 |
| 94576 | 102746 102746 | 147884 147884 |
| 95105 | 103253 103253 | 147884 147884 |
| 199985 | 228104 228104 | 147884 147884 |
| 201304 | 229619 229619 | 147884 147884 |
| 201850 | 230134 230134 | 147884 147884 |
| 210198 | 243244 243244 | 147884 147884 |
| 231778 | 266713 266713 | 147884 147884 |
| 231779 | 266714 266714 | 147884 147884 |
| 292164 | 337169 337169 | 147884 147884 |
| 313088 | 363080 363080 | 147884 147884 |
| 355907 | 408664 408664 | 147884 147884 |
| 399679 | 455358 455358 | 147884 147884 |
| 422575 | 481052 481052 | 147884 147884 |
| 435233 | 494079 494079 | 147884 147884 |
| 470896 | 529887 529887 | 147884 147884 |
| 474823 | 533962 533962 | 147884 147884 |
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)
);