paths_to_entries

10 rows where entry_id = 1970017

✎ View and edit SQL

This data as json, CSV (advanced)

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