cleanventory_chemicals
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
22 rows where inchi_id = 47897
Download this data as a CSV Spreadsheet (All Rows)
| cleanventory_id ▼ | inventory_id | inchi_id |
|---|---|---|
| 1301 | 1346 1346 | 47897 47897 |
| 1304 | 1349 1349 | 47897 47897 |
| 5707 | 5976 5976 | 47897 47897 |
| 46691 | 51473 51473 | 47897 47897 |
| 51575 | 57559 57559 | 47897 47897 |
| 72823 | 80859 80859 | 47897 47897 |
| 104879 | 112896 112896 | 47897 47897 |
| 146093 | 156888 156888 | 47897 47897 |
| 160462 | 173258 173258 | 47897 47897 |
| 181119 | 208054 208054 | 47897 47897 |
| 181120 | 208055 208055 | 47897 47897 |
| 181121 | 208056 208056 | 47897 47897 |
| 183102 | 210024 210024 | 47897 47897 |
| 183104 | 210025 210025 | 47897 47897 |
| 191455 | 219242 219242 | 47897 47897 |
| 195404 | 223233 223233 | 47897 47897 |
| 205639 | 237692 237692 | 47897 47897 |
| 217830 | 251626 251626 | 47897 47897 |
| 245758 | 281184 281184 | 47897 47897 |
| 245759 | 281185 281185 | 47897 47897 |
| 469346 | 528330 528330 | 47897 47897 |
| 477057 | 536235 536235 | 47897 47897 |
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)
);