catalog_columns

339 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: database_name, type, is_pk

Link database_name table_name cid name type notnull default_value is_pk hidden
_internal,_sqlite_migrations,applied_at _internal _sqlite_migrations 2 applied_at TEXT 0   0 0
_internal,_sqlite_migrations,migration_set _internal _sqlite_migrations 0 migration_set TEXT 0   1 0
_internal,_sqlite_migrations,name _internal _sqlite_migrations 1 name TEXT 0   2 0
_internal,catalog_columns,cid _internal catalog_columns 2 cid INTEGER 0   0 0
_internal,catalog_columns,database_name _internal catalog_columns 0 database_name TEXT 0   1 0
_internal,catalog_columns,default_value _internal catalog_columns 6 default_value TEXT 0   0 0
_internal,catalog_columns,hidden _internal catalog_columns 8 hidden INTEGER 0   0 0
_internal,catalog_columns,is_pk _internal catalog_columns 7 is_pk INTEGER 0   0 0
_internal,catalog_columns,name _internal catalog_columns 3 name TEXT 0   3 0
_internal,catalog_columns,notnull _internal catalog_columns 5 notnull INTEGER 0   0 0
_internal,catalog_columns,table_name _internal catalog_columns 1 table_name TEXT 0   2 0
_internal,catalog_columns,type _internal catalog_columns 4 type TEXT 0   0 0
_internal,catalog_databases,database_name _internal catalog_databases 0 database_name TEXT 0   1 0
_internal,catalog_databases,is_memory _internal catalog_databases 2 is_memory INTEGER 0   0 0
_internal,catalog_databases,path _internal catalog_databases 1 path TEXT 0   0 0
_internal,catalog_databases,schema_version _internal catalog_databases 3 schema_version INTEGER 0   0 0
_internal,catalog_foreign_keys,database_name _internal catalog_foreign_keys 0 database_name TEXT 0   1 0
_internal,catalog_foreign_keys,from _internal catalog_foreign_keys 5 from TEXT 0   0 0
_internal,catalog_foreign_keys,id _internal catalog_foreign_keys 2 id INTEGER 0   3 0
_internal,catalog_foreign_keys,match _internal catalog_foreign_keys 9 match TEXT 0   0 0
_internal,catalog_foreign_keys,on_delete _internal catalog_foreign_keys 8 on_delete TEXT 0   0 0
_internal,catalog_foreign_keys,on_update _internal catalog_foreign_keys 7 on_update TEXT 0   0 0
_internal,catalog_foreign_keys,seq _internal catalog_foreign_keys 3 seq INTEGER 0   4 0
_internal,catalog_foreign_keys,table _internal catalog_foreign_keys 4 table TEXT 0   0 0
_internal,catalog_foreign_keys,table_name _internal catalog_foreign_keys 1 table_name TEXT 0   2 0
_internal,catalog_foreign_keys,to _internal catalog_foreign_keys 6 to TEXT 0   0 0
_internal,catalog_indexes,database_name _internal catalog_indexes 0 database_name TEXT 0   1 0
_internal,catalog_indexes,name _internal catalog_indexes 3 name TEXT 0   3 0
_internal,catalog_indexes,origin _internal catalog_indexes 5 origin TEXT 0   0 0
_internal,catalog_indexes,partial _internal catalog_indexes 6 partial INTEGER 0   0 0
_internal,catalog_indexes,seq _internal catalog_indexes 2 seq INTEGER 0   0 0
_internal,catalog_indexes,table_name _internal catalog_indexes 1 table_name TEXT 0   2 0
_internal,catalog_indexes,unique _internal catalog_indexes 4 unique INTEGER 0   0 0
_internal,catalog_tables,database_name _internal catalog_tables 0 database_name TEXT 0   1 0
_internal,catalog_tables,rootpage _internal catalog_tables 2 rootpage INTEGER 0   0 0
_internal,catalog_tables,sql _internal catalog_tables 3 sql TEXT 0   0 0
_internal,catalog_tables,table_name _internal catalog_tables 1 table_name TEXT 0   2 0
_internal,datasette_events,actor_id _internal datasette_events 3 actor_id text 0   0 0
_internal,datasette_events,created _internal datasette_events 2 created text 0   0 0
_internal,datasette_events,database_name _internal datasette_events 4 database_name text 0   0 0
_internal,datasette_events,event _internal datasette_events 1 event text 0   0 0
_internal,datasette_events,id _internal datasette_events 0 id integer 0   1 0
_internal,datasette_events,properties _internal datasette_events 6 properties text 0   0 0
_internal,datasette_events,table_name _internal datasette_events 5 table_name text 0   0 0
_internal,datasette_pins_global_pinned_items,id _internal datasette_pins_global_pinned_items 0 id integer 0   1 0
_internal,datasette_pins_global_pinned_items,identifier _internal datasette_pins_global_pinned_items 6 identifier text 0   0 0
_internal,datasette_pins_global_pinned_items,item_type _internal datasette_pins_global_pinned_items 3 item_type text 0   0 0
_internal,datasette_pins_global_pinned_items,order_idx _internal datasette_pins_global_pinned_items 7 order_idx integer 0   0 0
_internal,datasette_pins_global_pinned_items,origin_database _internal datasette_pins_global_pinned_items 4 origin_database text 0   0 0
_internal,datasette_pins_global_pinned_items,origin_table _internal datasette_pins_global_pinned_items 5 origin_table text 0   0 0
_internal,datasette_pins_global_pinned_items,pin_location _internal datasette_pins_global_pinned_items 2 pin_location text 0   0 0
_internal,datasette_pins_global_pinned_items,pinner_actor_id _internal datasette_pins_global_pinned_items 1 pinner_actor_id text 0   0 0
_internal,metadata_columns,column_name _internal metadata_columns 2 column_name text 0   0 0
_internal,metadata_columns,database_name _internal metadata_columns 0 database_name text 0   0 0
_internal,metadata_columns,key _internal metadata_columns 3 key text 0   0 0
_internal,metadata_columns,resource_name _internal metadata_columns 1 resource_name text 0   0 0
_internal,metadata_columns,value _internal metadata_columns 4 value text 0   0 0
_internal,metadata_databases,database_name _internal metadata_databases 0 database_name text 0   0 0
_internal,metadata_databases,key _internal metadata_databases 1 key text 0   0 0
_internal,metadata_databases,value _internal metadata_databases 2 value text 0   0 0
_internal,metadata_instance,key _internal metadata_instance 0 key text 0   0 0
_internal,metadata_instance,value _internal metadata_instance 1 value text 0   0 0
_internal,metadata_resources,database_name _internal metadata_resources 0 database_name text 0   0 0
_internal,metadata_resources,key _internal metadata_resources 2 key text 0   0 0
_internal,metadata_resources,resource_name _internal metadata_resources 1 resource_name text 0   0 0
_internal,metadata_resources,value _internal metadata_resources 3 value text 0   0 0
_internal,sqlite_sequence,name _internal sqlite_sequence 0 name   0   0 0
_internal,sqlite_sequence,seq _internal sqlite_sequence 1 seq   0   0 0
data,FormDiffs,Form Name data FormDiffs 3 Form Name TEXT 0   0 0
data,FormDiffs,has_difference data FormDiffs 12 has_difference INTEGER 0   0 0
data,FormDiffs,line_no_order data FormDiffs 13 line_no_order INTEGER 0   0 0
data,FormDiffs,preference_type data FormDiffs 2 preference_type TEXT 0   0 0
data,FormDiffs,prod_enabled data FormDiffs 5 prod_enabled TEXT 0   0 0
data,FormDiffs,prod_preferred data FormDiffs 7 prod_preferred TEXT 0   0 0
data,FormDiffs,prod_restricted data FormDiffs 9 prod_restricted TEXT 0   0 0
data,FormDiffs,prod_stored data FormDiffs 11 prod_stored TEXT 0   0 0
data,FormDiffs,role_id data FormDiffs 0 role_id TEXT 0   0 0
data,FormDiffs,role_name data FormDiffs 1 role_name TEXT 0   0 0
data,FormDiffs,sb_enabled data FormDiffs 4 sb_enabled TEXT 0   0 0
data,FormDiffs,sb_restricted data FormDiffs 8 sb_restricted TEXT 0   0 0
data,FormDiffs,sb_stored data FormDiffs 10 sb_stored TEXT 0   0 0
data,FormDiffs,sp_preferred data FormDiffs 6 sp_preferred TEXT 0   0 0
data,customrecordtypes,id data customrecordtypes 0 id INTEGER 0   1 0
data,customrecordtypes,name data customrecordtypes 1 name TEXT 0   0 0
data,customsearchprefs,env data customsearchprefs 16 env TEXT 0   1 0
data,customsearchprefs,line_key data customsearchprefs 18 line_key TEXT 0   3 0
data,customsearchprefs,line_no data customsearchprefs 19 line_no TEXT 0   0 0
data,customsearchprefs,listview data customsearchprefs 0 listview TEXT 0   0 0
data,customsearchprefs,listview_display data customsearchprefs 1 listview_display TEXT 0   0 0
data,customsearchprefs,machineview data customsearchprefs 2 machineview TEXT 0   0 0
data,customsearchprefs,machineview_display data customsearchprefs 3 machineview_display TEXT 0   0 0
data,customsearchprefs,portletview data customsearchprefs 4 portletview TEXT 0   0 0
data,customsearchprefs,portletview_display data customsearchprefs 5 portletview_display TEXT 0   0 0
data,customsearchprefs,recordtype data customsearchprefs 6 recordtype TEXT 0   0 0
data,customsearchprefs,restrictlistview data customsearchprefs 7 restrictlistview TEXT 0   0 0
data,customsearchprefs,restrictmachineview data customsearchprefs 8 restrictmachineview TEXT 0   0 0
data,customsearchprefs,restrictportletview data customsearchprefs 9 restrictportletview TEXT 0   0 0
data,customsearchprefs,role_id data customsearchprefs 17 role_id TEXT 0   2 0
data,customsearchprefs,searchform data customsearchprefs 10 searchform TEXT 0   0 0
data,customsearchprefs,searchform_display data customsearchprefs 11 searchform_display TEXT 0   0 0

Next page

Advanced export

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

CSV options: 

CREATE TABLE catalog_columns (
    database_name TEXT,
    table_name TEXT,
    cid INTEGER,
    name TEXT,
    type TEXT,
    "notnull" INTEGER,
    default_value TEXT, -- renamed from dflt_value
    is_pk INTEGER, -- renamed from pk
    hidden INTEGER,
    PRIMARY KEY (database_name, table_name, name),
    FOREIGN KEY (database_name) REFERENCES databases(database_name),
    FOREIGN KEY (database_name, table_name) REFERENCES tables(database_name, table_name)
);