columns

8 rows where table_id = 4

descending

id ▼	table_id	name
9	items 4	hash
10	items 4	item
11	items 4	category_id
12	items 4	date
13	items 4	member_id
14	items 4	person_id
15	items 4	sort_order
16	items 4	record_id

Advanced export

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