searchable_tags
1 row where searchable_id = 2
This data as json, CSV (advanced)
| Link | searchable_id | tag |
|---|---|---|
| 2,canine | 2 2 | canine |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE searchable_tags (
searchable_id integer,
tag text,
PRIMARY KEY (searchable_id, tag),
FOREIGN KEY (searchable_id) REFERENCES searchable(pk),
FOREIGN KEY (tag) REFERENCES tags(tag)
);