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