cleanventory_chemicals
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
20 rows where inchi_id = 27770
Download this data as a CSV Spreadsheet (All Rows)
| cleanventory_id ▼ | inventory_id | inchi_id |
|---|---|---|
| 14827 | 15373 15373 | 27770 27770 |
| 17279 | 17889 17889 | 27770 27770 |
| 34357 | 36451 36451 | 27770 27770 |
| 36507 | 38752 38752 | 27770 27770 |
| 52376 | 58430 58430 | 27770 27770 |
| 60278 | 67650 67650 | 27770 27770 |
| 105430 | 113437 113437 | 27770 27770 |
| 195165 | 222995 222995 | 27770 27770 |
| 209418 | 242177 242177 | 27770 27770 |
| 214156 | 247828 247828 | 27770 27770 |
| 230234 | 265013 265013 | 27770 27770 |
| 230235 | 265014 265014 | 27770 27770 |
| 238813 | 274111 274111 | 27770 27770 |
| 238814 | 274112 274112 | 27770 27770 |
| 238815 | 274113 274113 | 27770 27770 |
| 282473 | 323727 323727 | 27770 27770 |
| 289469 | 333296 333296 | 27770 27770 |
| 448409 | 507164 507164 | 27770 27770 |
| 475100 | 534259 534259 | 27770 27770 |
| 477232 | 536407 536407 | 27770 27770 |
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)
);