cleanventory_chemicals
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
26 rows where inchi_id = 20
Download this data as a CSV Spreadsheet (All Rows)
| cleanventory_id ▼ | inventory_id | inchi_id |
|---|---|---|
| 5985 | 6253 6253 | 20 20 |
| 27123 | 29138 29138 | 20 20 |
| 43442 | 47870 47870 | 20 20 |
| 68036 | 76104 76104 | 20 20 |
| 143749 | 154554 154554 | 20 20 |
| 179874 | 206813 206813 | 20 20 |
| 203871 | 232217 232217 | 20 20 |
| 207100 | 239637 239637 | 20 20 |
| 225475 | 260001 260001 | 20 20 |
| 225476 | 260002 260002 | 20 20 |
| 296078 | 342645 342645 | 20 20 |
| 300965 | 351209 351209 | 20 20 |
| 300966 | 351210 351210 | 20 20 |
| 300967 | 351211 351211 | 20 20 |
| 300968 | 351212 351212 | 20 20 |
| 342133 | 395100 395100 | 20 20 |
| 342134 | 395101 395101 | 20 20 |
| 342135 | 395102 395102 | 20 20 |
| 342136 | 395103 395103 | 20 20 |
| 390950 | 446787 446787 | 20 20 |
| 390951 | 446788 446788 | 20 20 |
| 390952 | 446789 446789 | 20 20 |
| 390953 | 446790 446790 | 20 20 |
| 421285 | 479750 479750 | 20 20 |
| 428617 | 487465 487465 | 20 20 |
| 467463 | 526463 526463 | 20 20 |
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)
);