tables

9 rows where database_id = 1

View and edit SQL

Suggested facets: count, has_fts, is_hidden

id ▼ database_id name count has_fts is_hidden label_column
1 regmem 1 people 1421 0 0 name
2 regmem 1 members 2677 0 0  
3 regmem 1 categories 54 0 0  
4 regmem 1 items 1384575 1 0  
5 regmem 1 items_fts_segments 6223 0 1  
6 regmem 1 items_fts_segdir 1 0 1  
7 regmem 1 items_fts_docsize 1384575 0 1  
8 regmem 1 items_fts_stat 1 0 1 value
9 regmem 1 items_fts 0 1 1  

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE tables (
            id integer PRIMARY KEY,
            database_id integer,
            name text,
            count integer,
            has_fts integer,
            is_hidden integer,
            label_column text,
            FOREIGN KEY (database_id) REFERENCES databases(id)
        );
Powered by Datasette · Query took 12.258ms