tables

479 rows

View and edit SQL

id ▼ database_id name count has_fts is_hidden label_column
101 sf-trees 9 qCaretaker 21 0 0 value
102 sf-trees 9 qSiteInfo 31 0 0 value
103 sf-trees 9 qSpecies 562 0 0 value
104 sf-trees 9 qCareAssistant 15 0 0 value
105 sf-trees 9 qLegalStatus 9 0 0 value
106 sf-trees 9 Street_Tree_List 189144 1 0  
107 sf-trees 9 Street_Tree_List_fts 189144 1 1  
108 sf-trees 9 Street_Tree_List_fts_segments 1570 0 1  
109 sf-trees 9 Street_Tree_List_fts_segdir 5 0 1  
110 sf-trees 9 Street_Tree_List_fts_docsize 189144 0 1  
111 sf-trees 9 Street_Tree_List_fts_stat 1 0 1 value
112 timezones 10 spatial_ref_sys 4924 0 1  
113 timezones 10 spatialite_history 14 0 1  
114 timezones 10 sqlite_sequence 3 0 1  
115 timezones 10 geometry_columns 1 0 1  
116 timezones 10 spatial_ref_sys_aux 4873 0 1  
117 timezones 10 views_geometry_columns 0 0 1  
118 timezones 10 virts_geometry_columns 0 0 1  
119 timezones 10 geometry_columns_statistics 1 0 1  
120 timezones 10 views_geometry_columns_statistics 0 0 1  
121 timezones 10 virts_geometry_columns_statistics 0 0 1  
122 timezones 10 geometry_columns_field_infos 0 0 1  
123 timezones 10 views_geometry_columns_field_infos 0 0 1  
124 timezones 10 virts_geometry_columns_field_infos 0 0 1  
125 timezones 10 geometry_columns_time 1 0 1  
126 timezones 10 geometry_columns_auth 1 0 1  
127 timezones 10 views_geometry_columns_auth 0 0 1  
128 timezones 10 virts_geometry_columns_auth 0 0 1  
129 timezones 10 sql_statements_log 1 0 1  
130 timezones 10 SpatialIndex 0 0 1  
131 timezones 10 ElementaryGeometries 0 0 1  
132 timezones 10 timezones 439 0 0  
133 timezones 10 idx_timezones_Geometry 439 0 1  
134 timezones 10 idx_timezones_Geometry_node 13 0 1  
135 timezones 10 idx_timezones_Geometry_rowid 439 0 1  
136 timezones 10 idx_timezones_Geometry_parent 12 0 1  
137 MetObjects 11 Department 20 1 0 value
138 MetObjects 11 Department_value_fts 20 1 1  
139 MetObjects 11 Department_value_fts_segments 0 0 1  
140 MetObjects 11 Department_value_fts_segdir 1 0 1  
141 MetObjects 11 Department_value_fts_docsize 20 0 1  
142 MetObjects 11 Department_value_fts_stat 1 0 1 value
143 MetObjects 11 Object Name 27381 1 0 value
144 MetObjects 11 Object Name_value_fts 27381 1 1  
145 MetObjects 11 Object Name_value_fts_segments 97 0 1  
146 MetObjects 11 Object Name_value_fts_segdir 1 0 1  
147 MetObjects 11 Object Name_value_fts_docsize 27381 0 1  
148 MetObjects 11 Object Name_value_fts_stat 1 0 1 value
149 MetObjects 11 Culture 7132 1 0 value
150 MetObjects 11 Culture_value_fts 7132 1 1  
151 MetObjects 11 Culture_value_fts_segments 27 0 1  
152 MetObjects 11 Culture_value_fts_segdir 1 0 1  
153 MetObjects 11 Culture_value_fts_docsize 7132 0 1  
154 MetObjects 11 Culture_value_fts_stat 1 0 1 value
155 MetObjects 11 Dynasty 348 1 0 value
156 MetObjects 11 Dynasty_value_fts 348 1 1  
157 MetObjects 11 Dynasty_value_fts_segments 2 0 1  
158 MetObjects 11 Dynasty_value_fts_segdir 1 0 1  
159 MetObjects 11 Dynasty_value_fts_docsize 348 0 1  
160 MetObjects 11 Dynasty_value_fts_stat 1 0 1 value
161 MetObjects 11 Reign 366 1 0 value
162 MetObjects 11 Reign_value_fts 366 1 1  
163 MetObjects 11 Reign_value_fts_segments 2 0 1  
164 MetObjects 11 Reign_value_fts_segdir 1 0 1  
165 MetObjects 11 Reign_value_fts_docsize 366 0 1  
166 MetObjects 11 Reign_value_fts_stat 1 0 1 value
167 MetObjects 11 Portfolio 3044 1 0 value
168 MetObjects 11 Portfolio_value_fts 3044 1 1  
169 MetObjects 11 Portfolio_value_fts_segments 27 0 1  
170 MetObjects 11 Portfolio_value_fts_segdir 1 0 1  
171 MetObjects 11 Portfolio_value_fts_docsize 3044 0 1  
172 MetObjects 11 Portfolio_value_fts_stat 1 0 1 value
173 MetObjects 11 Artist Role 6090 1 0 value
174 MetObjects 11 Artist Role_value_fts 6090 1 1  
175 MetObjects 11 Artist Role_value_fts_segments 17 0 1  
176 MetObjects 11 Artist Role_value_fts_segdir 1 0 1  
177 MetObjects 11 Artist Role_value_fts_docsize 6090 0 1  
178 MetObjects 11 Artist Role_value_fts_stat 1 0 1 value
179 MetObjects 11 Artist Alpha Sort 59247 1 0 value
180 MetObjects 11 Artist Alpha Sort_value_fts 59247 1 1  
181 MetObjects 11 Artist Alpha Sort_value_fts_segments 405 0 1  
182 MetObjects 11 Artist Alpha Sort_value_fts_segdir 4 0 1  
183 MetObjects 11 Artist Alpha Sort_value_fts_docsize 59247 0 1  
184 MetObjects 11 Artist Alpha Sort_value_fts_stat 1 0 1 value
185 MetObjects 11 Artist Nationality 3806 1 0 value
186 MetObjects 11 Artist Nationality_value_fts 3806 1 1  
187 MetObjects 11 Artist Nationality_value_fts_segments 14 0 1  
188 MetObjects 11 Artist Nationality_value_fts_segdir 1 0 1  
189 MetObjects 11 Artist Nationality_value_fts_docsize 3806 0 1  
190 MetObjects 11 Artist Nationality_value_fts_stat 1 0 1 value
191 MetObjects 11 Medium 63888 1 0 value
192 MetObjects 11 Medium_value_fts 63888 1 1  
193 MetObjects 11 Medium_value_fts_segments 341 0 1  
194 MetObjects 11 Medium_value_fts_segdir 2 0 1  
195 MetObjects 11 Medium_value_fts_docsize 63888 0 1  
196 MetObjects 11 Medium_value_fts_stat 1 0 1 value
197 MetObjects 11 Geography Type 128 1 0 value
198 MetObjects 11 Geography Type_value_fts 128 1 1  
199 MetObjects 11 Geography Type_value_fts_segments 0 0 1  
200 MetObjects 11 Geography Type_value_fts_segdir 1 0 1  

Next page

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 5.736ms