cleanventory_chemicals
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
18 rows where inchi_id = 27485
Download this data as a CSV Spreadsheet (All Rows)
| cleanventory_id ▼ | inventory_id | inchi_id |
|---|---|---|
| 187 | 191 191 | 27485 27485 |
| 17238 | 17847 17847 | 27485 27485 |
| 17628 | 18247 18247 | 27485 27485 |
| 36297 | 38538 38538 | 27485 27485 |
| 41147 | 45186 45186 | 27485 27485 |
| 64839 | 72877 72877 | 27485 27485 |
| 105305 | 113312 113312 | 27485 27485 |
| 106660 | 114659 114659 | 27485 27485 |
| 183139 | 210058 210058 | 27485 27485 |
| 194655 | 222491 222491 | 27485 27485 |
| 195217 | 223048 223048 | 27485 27485 |
| 214112 | 247784 247784 | 27485 27485 |
| 214592 | 248275 248275 | 27485 27485 |
| 238720 | 274021 274021 | 27485 27485 |
| 238721 | 274022 274022 | 27485 27485 |
| 277496 | 317715 317715 | 27485 27485 |
| 448748 | 507501 507501 | 27485 27485 |
| 477209 | 536385 536385 | 27485 27485 |
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)
);