paths_to_entries

Table actions

6 rows where entry_id = 13778580

✎ View and edit SQL

This data as json, CSV (advanced)

Link path_id entry_id
106818,13778580 main/noarch/jupyterlab-2.1.4-py_1.conda 106818 13778580 13778580
106819,13778580 main/noarch/jupyterlab-2.1.5-py_0.conda 106819 13778580 13778580
106820,13778580 main/noarch/jupyterlab-2.2.10-pyhd3eb1b0_0.conda 106820 13778580 13778580
106821,13778580 main/noarch/jupyterlab-2.2.6-py_0.conda 106821 13778580 13778580
106822,13778580 main/noarch/jupyterlab-2.2.6-pyhd3eb1b0_1.conda 106822 13778580 13778580
106823,13778580 main/noarch/jupyterlab-2.3.1-pyhd3eb1b0_0.conda 106823 13778580 13778580

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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);