cleanventory_chemicals
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
21 rows where inchi_id = 54278
Download this data as a CSV Spreadsheet (All Rows)
| cleanventory_id ▼ | inventory_id | inchi_id |
|---|---|---|
| 1950 | 2029 2029 | 54278 54278 |
| 2244 | 2330 2330 | 54278 54278 |
| 49989 | 55662 55662 | 54278 54278 |
| 73957 | 81983 81983 | 54278 54278 |
| 105882 | 113889 113889 | 54278 54278 |
| 146617 | 157410 157410 | 54278 54278 |
| 161034 | 173943 173943 | 54278 54278 |
| 161694 | 174742 174742 | 54278 54278 |
| 164992 | 179152 179152 | 54278 54278 |
| 181269 | 208204 208204 | 54278 54278 |
| 190084 | 217850 217850 | 54278 54278 |
| 194975 | 222806 222806 | 54278 54278 |
| 214324 | 248008 248008 | 54278 54278 |
| 219167 | 253001 253001 | 54278 54278 |
| 239217 | 274505 274505 | 54278 54278 |
| 239218 | 274506 274506 | 54278 54278 |
| 272865 | 312312 312312 | 54278 54278 |
| 294435 | 340434 340434 | 54278 54278 |
| 449026 | 507775 507775 | 54278 54278 |
| 469690 | 528674 528674 | 54278 54278 |
| 477353 | 536529 536529 | 54278 54278 |
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)
);