paths_to_entries
2 rows where path_id = 72959
This data as json, CSV (advanced)
Link | path_id | entry_id |
---|---|---|
72959,18442 | main/osx-64/_ipyw_jlab_nb_ext_conf-0.1.0-py37_0.conda 72959 | 18442 18442 |
72959,18443 | main/osx-64/_ipyw_jlab_nb_ext_conf-0.1.0-py37_0.conda 72959 | 18443 18443 |
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);