cleanventory_chemicals
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
27 rows where inchi_id = 47442
Download this data as a CSV Spreadsheet (All Rows)
| cleanventory_id ▼ | inventory_id | inchi_id |
|---|---|---|
| 11938 | 12234 12234 | 47442 47442 |
| 30181 | 32173 32173 | 47442 47442 |
| 54732 | 61103 61103 | 47442 47442 |
| 87787 | 95779 95779 | 47442 47442 |
| 152526 | 163480 163480 | 47442 47442 |
| 191555 | 219344 219344 | 47442 47442 |
| 217736 | 251527 251527 | 47442 47442 |
| 245555 | 280972 280972 | 47442 47442 |
| 245556 | 280973 280973 | 47442 47442 |
| 324157 | 374427 374427 | 47442 47442 |
| 324158 | 374428 374428 | 47442 47442 |
| 324159 | 374429 374429 | 47442 47442 |
| 324160 | 374430 374430 | 47442 47442 |
| 324161 | 374431 374431 | 47442 47442 |
| 324162 | 374432 374432 | 47442 47442 |
| 324163 | 374433 374433 | 47442 47442 |
| 324164 | 374434 374434 | 47442 47442 |
| 369067 | 422150 422150 | 47442 47442 |
| 369068 | 422151 422151 | 47442 47442 |
| 369069 | 422152 422152 | 47442 47442 |
| 369070 | 422153 422153 | 47442 47442 |
| 369071 | 422154 422154 | 47442 47442 |
| 407917 | 463846 463846 | 47442 47442 |
| 407918 | 463847 463847 | 47442 47442 |
| 424719 | 483420 483420 | 47442 47442 |
| 439678 | 498507 498507 | 47442 47442 |
| 472942 | 531940 531940 | 47442 47442 |
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)
);