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