paths_to_entries
10 rows where entry_id = 1596428
This data as json, CSV (advanced)
Link | path_id | entry_id |
---|---|---|
12936,1596428 | main/linux-64/jupyterlab-0.27.0-py35h29561ed_2.conda 12936 | 1596428 1596428 |
12939,1596428 | main/linux-64/jupyterlab-0.30.4-py35_0.conda 12939 | 1596428 1596428 |
12942,1596428 | main/linux-64/jupyterlab-0.30.5-py35_0.conda 12942 | 1596428 1596428 |
12945,1596428 | main/linux-64/jupyterlab-0.30.6-py35h2f9c1c0_0.conda 12945 | 1596428 1596428 |
85192,1596428 | main/osx-64/jupyterlab-0.30.4-py35_0.conda 85192 | 1596428 1596428 |
85195,1596428 | main/osx-64/jupyterlab-0.30.5-py35_0.conda 85195 | 1596428 1596428 |
85198,1596428 | main/osx-64/jupyterlab-0.30.6-py35h2f9c1c0_0.conda 85198 | 1596428 1596428 |
113212,1596428 | main/linux-32/jupyterlab-0.30.4-py35_0.conda 113212 | 1596428 1596428 |
113215,1596428 | main/linux-32/jupyterlab-0.30.5-py35_0.conda 113215 | 1596428 1596428 |
113218,1596428 | main/linux-32/jupyterlab-0.30.6-py35h2f9c1c0_0.conda 113218 | 1596428 1596428 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE paths_to_entries ( path_id INTEGER NOT NULL, entry_id INTEGER NOT NULL, PRIMARY KEY (path_id, entry_id), FOREIGN KEY(path_id) REFERENCES paths (id), FOREIGN KEY(entry_id) REFERENCES paths_entries (id) ); CREATE INDEX ix_paths_to_entries_entry_id ON paths_to_entries (entry_id);