searchable_tags

2 rows

View and edit SQL
searchable_tags

All rows in this table

TSV All 2 rows
Tab-separated values, for pasting into Excel or Google Sheets
CSV All 2 rows
Comma-separated values, for spreadsheets and other tools
  • JSON All 2 rows
    Rows inside an object, with extra details
    View Download
  • JSON array All 2 rows
    Just the rows, as an array of objects
    View Download
  • Newline-delimited JSON All 2 rows
    One JSON object per line
    View Download
  • JSON object All 2 rows
    Rows keyed by their primary key
    View Download
  • testall All 2 rows
    View Download
  • testnone All 2 rows
    View Download
  • testresponse All 2 rows
    View Download

Link searchable_id tag
1,feline 1 1 feline
2,canine 2 2 canine
Table schema 
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)
);