paths_to_entries
2 rows where path_id = 120166
This data as json, CSV (advanced)
Link | path_id | entry_id |
---|---|---|
120166,18440 | main/linux-aarch64/_go_select-2.3.0-cgo.conda 120166 | 18440 18440 |
120166,18441 | main/linux-aarch64/_go_select-2.3.0-cgo.conda 120166 | 18441 18441 |
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);