cleanventory_chemicals
Data license: CC-BY-4.0 · Data source: ZeroPM GitHub · About: ZeroPM Website
20 rows where inchi_id = 55040
Download this data as a CSV Spreadsheet (All Rows)
| cleanventory_id ▼ | inventory_id | inchi_id |
|---|---|---|
| 157 | 161 161 | 55040 55040 |
| 4520 | 4792 4792 | 55040 55040 |
| 13946 | 14307 14307 | 55040 55040 |
| 32171 | 34241 34241 | 55040 55040 |
| 41328 | 45387 45387 | 55040 55040 |
| 55044 | 61516 61516 | 55040 55040 |
| 64637 | 72649 72649 | 55040 55040 |
| 65952 | 74031 74031 | 55040 55040 |
| 142377 | 153191 153191 | 55040 55040 |
| 179003 | 205947 205947 | 55040 55040 |
| 179004 | 205948 205948 | 55040 55040 |
| 189903 | 217666 217666 | 55040 55040 |
| 219386 | 253227 253227 | 55040 55040 |
| 248601 | 284045 284045 | 55040 55040 |
| 248602 | 284046 284046 | 55040 55040 |
| 257280 | 293295 293295 | 55040 55040 |
| 279082 | 319575 319575 | 55040 55040 |
| 427041 | 485898 485898 | 55040 55040 |
| 442208 | 501015 501015 | 55040 55040 |
| 466511 | 525521 525521 | 55040 55040 |
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)
);