cleanventory_chemicals
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
27 rows where inchi_id = 20317
Download this data as a CSV Spreadsheet (All Rows)
| cleanventory_id ▼ | inventory_id | inchi_id |
|---|---|---|
| 1767 | 1835 1835 | 20317 20317 |
| 16432 | 17022 17022 | 20317 20317 |
| 26979 | 28994 28994 | 20317 20317 |
| 52333 | 58379 58379 | 20317 20317 |
| 101889 | 109939 109939 | 20317 20317 |
| 158981 | 171467 171467 | 20317 20317 |
| 196655 | 224505 224505 | 20317 20317 |
| 205100 | 236886 236886 | 20317 20317 |
| 212874 | 246325 246325 | 20317 20317 |
| 236297 | 271572 271572 | 20317 20317 |
| 236298 | 271573 271573 | 20317 20317 |
| 290000 | 334115 334115 | 20317 20317 |
| 318334 | 368375 368375 | 20317 20317 |
| 318335 | 368376 368376 | 20317 20317 |
| 318336 | 368377 368377 | 20317 20317 |
| 318337 | 368378 368378 | 20317 20317 |
| 362146 | 414971 414971 | 20317 20317 |
| 362147 | 414972 414972 | 20317 20317 |
| 362148 | 414973 414973 | 20317 20317 |
| 362149 | 414974 414974 | 20317 20317 |
| 403571 | 459294 459294 | 20317 20317 |
| 403572 | 459295 459295 | 20317 20317 |
| 403573 | 459296 459296 | 20317 20317 |
| 403574 | 459297 459297 | 20317 20317 |
| 423353 | 481880 481880 | 20317 20317 |
| 447171 | 505948 505948 | 20317 20317 |
| 476531 | 535708 535708 | 20317 20317 |
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)
);