This data as json, CSV (advanced)
id ▼ | table_id | name |
---|---|---|
29 | items_fts 9 | item |
30 | items_fts 9 | person_name |
JSON shape: default, array, newline-delimited, object
CREATE TABLE columns ( id integer PRIMARY KEY, table_id integer, name text, FOREIGN KEY (table_id) REFERENCES tables(id) );