catalog_columns

200 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Link database_name table_name cid name type notnull default_value is_pk hidden
declaration250,app_access,action declaration250 app_access 2 action TEXT 1   0 0
declaration250,app_access,allow declaration250 app_access 5 allow INTEGER 1 1 0 0
declaration250,app_access,app_id declaration250 app_access 1 app_id TEXT 0   0 0
declaration250,app_access,created_at declaration250 app_access 6 created_at TEXT 1   0 0
declaration250,app_access,id declaration250 app_access 0 id INTEGER 0   1 0
declaration250,app_access,subject_id declaration250 app_access 4 subject_id TEXT 0   0 0
declaration250,app_access,subject_type declaration250 app_access 3 subject_type TEXT 1   0 0
declaration250,app_access,updated_at declaration250 app_access 7 updated_at TEXT 1   0 0
declaration250,app_csp_origins,app_id declaration250 app_csp_origins 1 app_id TEXT 1   0 0
declaration250,app_csp_origins,created_at declaration250 app_csp_origins 4 created_at TEXT 1   0 0
declaration250,app_csp_origins,directive declaration250 app_csp_origins 2 directive TEXT 1 'connect-src' 0 0
declaration250,app_csp_origins,id declaration250 app_csp_origins 0 id INTEGER 0   1 0
declaration250,app_csp_origins,origin declaration250 app_csp_origins 3 origin TEXT 1   0 0
declaration250,app_csp_origins,updated_at declaration250 app_csp_origins 5 updated_at TEXT 1   0 0
declaration250,app_revisions,actor_id declaration250 app_revisions 2 actor_id TEXT 0   0 0
declaration250,app_revisions,app_id declaration250 app_revisions 0 app_id TEXT 1   1 0
declaration250,app_revisions,changed_fields declaration250 app_revisions 10 changed_fields TEXT 1 '[]' 0 0
declaration250,app_revisions,created_at declaration250 app_revisions 11 created_at TEXT 1   0 0
declaration250,app_revisions,csp_origins declaration250 app_revisions 9 csp_origins TEXT 0   0 0
declaration250,app_revisions,description declaration250 app_revisions 4 description TEXT 0   0 0
declaration250,app_revisions,html declaration250 app_revisions 5 html TEXT 0   0 0
declaration250,app_revisions,is_private declaration250 app_revisions 6 is_private INTEGER 0   0 0
declaration250,app_revisions,name declaration250 app_revisions 3 name TEXT 0   0 0
declaration250,app_revisions,sql_databases declaration250 app_revisions 7 sql_databases TEXT 0   0 0
declaration250,app_revisions,stored_queries declaration250 app_revisions 8 stored_queries TEXT 0   0 0
declaration250,app_revisions,version declaration250 app_revisions 1 version INTEGER 1   2 0
declaration250,app_sql_databases,app_id declaration250 app_sql_databases 0 app_id TEXT 1   1 0
declaration250,app_sql_databases,created_at declaration250 app_sql_databases 2 created_at TEXT 1   0 0
declaration250,app_sql_databases,database_name declaration250 app_sql_databases 1 database_name TEXT 1   2 0
declaration250,app_sql_databases,updated_at declaration250 app_sql_databases 3 updated_at TEXT 1   0 0
declaration250,app_user_state,access_count declaration250 app_user_state 4 access_count INTEGER 1 0 0 0
declaration250,app_user_state,actor_id declaration250 app_user_state 0 actor_id TEXT 1   1 0
declaration250,app_user_state,app_id declaration250 app_user_state 1 app_id TEXT 1   2 0
declaration250,app_user_state,last_accessed_at declaration250 app_user_state 2 last_accessed_at TEXT 0   0 0
declaration250,app_user_state,pinned_at declaration250 app_user_state 3 pinned_at TEXT 0   0 0
declaration250,apps,actor_id declaration250 apps 7 actor_id TEXT 0   0 0
declaration250,apps,created_at declaration250 apps 13 created_at TEXT 1   0 0
declaration250,apps,current_version declaration250 apps 10 current_version INTEGER 0   0 0
declaration250,apps,deleted_actor_id declaration250 apps 12 deleted_actor_id TEXT 0   0 0
declaration250,apps,deleted_at declaration250 apps 11 deleted_at TEXT 0   0 0
declaration250,apps,description declaration250 apps 3 description TEXT 1 '' 0 0
declaration250,apps,external declaration250 apps 1 external INTEGER 1 0 0 0
declaration250,apps,id declaration250 apps 0 id TEXT 0   1 0
declaration250,apps,is_private declaration250 apps 8 is_private INTEGER 1 1 0 0
declaration250,apps,metadata declaration250 apps 6 metadata TEXT 1 '{}' 0 0
declaration250,apps,name declaration250 apps 2 name TEXT 1   0 0
declaration250,apps,path declaration250 apps 4 path TEXT 1   0 0
declaration250,apps,source declaration250 apps 5 source TEXT 1 '' 0 0
declaration250,apps,stored_queries declaration250 apps 9 stored_queries TEXT 1 '[]' 0 0
declaration250,apps,updated_at declaration250 apps 14 updated_at TEXT 1   0 0
declaration250,apps_fts,apps_fts declaration250 apps_fts 3 apps_fts   0   0 1
declaration250,apps_fts,description declaration250 apps_fts 1 description   0   0 0
declaration250,apps_fts,name declaration250 apps_fts 0 name   0   0 0
declaration250,apps_fts,rank declaration250 apps_fts 4 rank   0   0 1
declaration250,apps_fts,source declaration250 apps_fts 2 source   0   0 0
declaration250,apps_fts_config,k declaration250 apps_fts_config 0 k   1   1 0
declaration250,apps_fts_config,v declaration250 apps_fts_config 1 v   0   0 0
declaration250,apps_fts_data,block declaration250 apps_fts_data 1 block BLOB 0   0 0
declaration250,apps_fts_data,id declaration250 apps_fts_data 0 id INTEGER 0   1 0
declaration250,apps_fts_docsize,id declaration250 apps_fts_docsize 0 id INTEGER 0   1 0
declaration250,apps_fts_docsize,sz declaration250 apps_fts_docsize 1 sz BLOB 0   0 0
declaration250,apps_fts_idx,pgno declaration250 apps_fts_idx 2 pgno   0   0 0
declaration250,apps_fts_idx,segid declaration250 apps_fts_idx 0 segid   1   1 0
declaration250,apps_fts_idx,term declaration250 apps_fts_idx 1 term   1   2 0
declaration250,catalog_columns,cid declaration250 catalog_columns 2 cid INTEGER 0   0 0
declaration250,catalog_columns,database_name declaration250 catalog_columns 0 database_name TEXT 0   1 0
declaration250,catalog_columns,default_value declaration250 catalog_columns 6 default_value TEXT 0   0 0
declaration250,catalog_columns,hidden declaration250 catalog_columns 8 hidden INTEGER 0   0 0
declaration250,catalog_columns,is_pk declaration250 catalog_columns 7 is_pk INTEGER 0   0 0
declaration250,catalog_columns,name declaration250 catalog_columns 3 name TEXT 0   3 0
declaration250,catalog_columns,notnull declaration250 catalog_columns 5 notnull INTEGER 0   0 0
declaration250,catalog_columns,table_name declaration250 catalog_columns 1 table_name TEXT 0   2 0
declaration250,catalog_columns,type declaration250 catalog_columns 4 type TEXT 0   0 0
declaration250,catalog_databases,database_name declaration250 catalog_databases 0 database_name TEXT 0   1 0
declaration250,catalog_databases,is_memory declaration250 catalog_databases 2 is_memory INTEGER 0   0 0
declaration250,catalog_databases,path declaration250 catalog_databases 1 path TEXT 0   0 0
declaration250,catalog_databases,schema_version declaration250 catalog_databases 3 schema_version INTEGER 0   0 0
declaration250,catalog_foreign_keys,database_name declaration250 catalog_foreign_keys 0 database_name TEXT 0   1 0
declaration250,catalog_foreign_keys,from declaration250 catalog_foreign_keys 5 from TEXT 0   0 0
declaration250,catalog_foreign_keys,id declaration250 catalog_foreign_keys 2 id INTEGER 0   3 0
declaration250,catalog_foreign_keys,match declaration250 catalog_foreign_keys 9 match TEXT 0   0 0
declaration250,catalog_foreign_keys,on_delete declaration250 catalog_foreign_keys 8 on_delete TEXT 0   0 0
declaration250,catalog_foreign_keys,on_update declaration250 catalog_foreign_keys 7 on_update TEXT 0   0 0
declaration250,catalog_foreign_keys,seq declaration250 catalog_foreign_keys 3 seq INTEGER 0   4 0
declaration250,catalog_foreign_keys,table declaration250 catalog_foreign_keys 4 table TEXT 0   0 0
declaration250,catalog_foreign_keys,table_name declaration250 catalog_foreign_keys 1 table_name TEXT 0   2 0
declaration250,catalog_foreign_keys,to declaration250 catalog_foreign_keys 6 to TEXT 0   0 0
declaration250,catalog_indexes,database_name declaration250 catalog_indexes 0 database_name TEXT 0   1 0
declaration250,catalog_indexes,name declaration250 catalog_indexes 3 name TEXT 0   3 0
declaration250,catalog_indexes,origin declaration250 catalog_indexes 5 origin TEXT 0   0 0
declaration250,catalog_indexes,partial declaration250 catalog_indexes 6 partial INTEGER 0   0 0
declaration250,catalog_indexes,seq declaration250 catalog_indexes 2 seq INTEGER 0   0 0
declaration250,catalog_indexes,table_name declaration250 catalog_indexes 1 table_name TEXT 0   2 0
declaration250,catalog_indexes,unique declaration250 catalog_indexes 4 unique INTEGER 0   0 0
declaration250,catalog_tables,database_name declaration250 catalog_tables 0 database_name TEXT 0   1 0
declaration250,catalog_tables,rootpage declaration250 catalog_tables 2 rootpage INTEGER 0   0 0
declaration250,catalog_tables,sql declaration250 catalog_tables 3 sql TEXT 0   0 0
declaration250,catalog_tables,table_name declaration250 catalog_tables 1 table_name TEXT 0   2 0
declaration250,catalog_views,database_name declaration250 catalog_views 0 database_name TEXT 0   1 0
declaration250,catalog_views,rootpage declaration250 catalog_views 2 rootpage INTEGER 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 catalog_databases(database_name),
    FOREIGN KEY (database_name, table_name) REFERENCES catalog_tables(database_name, table_name)
);