paths_to_entries

Table actions

4 rows where entry_id = 5008365

✎ View and edit SQL

This data as json, CSV (advanced)

Link path_id entry_id
28750,5008365 main/linux-64/spacy-2.3.1-py36hfd86e86_0.conda 28750 5008365 5008365
28753,5008365 main/linux-64/spacy-2.3.2-py36hfd86e86_0.conda 28753 5008365 5008365
100501,5008365 main/osx-64/spacy-2.3.1-py36h879752b_0.conda 100501 5008365 5008365
100504,5008365 main/osx-64/spacy-2.3.2-py36h879752b_0.conda 100504 5008365 5008365

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