catalog_tables

34 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: database_name

Link database_name table_name rootpage sql
_internal,_sqlite_migrations _internal _sqlite_migrations 2 CREATE TABLE [_sqlite_migrations] ( [migration_set] TEXT, [name] TEXT, [applied_at] TEXT, PRIMARY KEY ([migration_set], [name]) )
_internal,catalog_columns _internal catalog_columns 11 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) )
_internal,catalog_databases _internal catalog_databases 7 CREATE TABLE catalog_databases ( database_name TEXT PRIMARY KEY, path TEXT, is_memory INTEGER, schema_version INTEGER )
_internal,catalog_foreign_keys _internal catalog_foreign_keys 15 CREATE TABLE catalog_foreign_keys ( database_name TEXT, table_name TEXT, id INTEGER, seq INTEGER, "table" TEXT, "from" TEXT, "to" TEXT, on_update TEXT, on_delete TEXT, match TEXT, PRIMARY KEY (database_name, table_name, id, seq), FOREIGN KEY (database_name) REFERENCES databases(database_name), FOREIGN KEY (database_name, table_name) REFERENCES tables(database_name, table_name) )
_internal,catalog_indexes _internal catalog_indexes 13 CREATE TABLE catalog_indexes ( database_name TEXT, table_name TEXT, seq INTEGER, name TEXT, "unique" INTEGER, origin TEXT, partial 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) )
_internal,catalog_tables _internal catalog_tables 9 CREATE TABLE catalog_tables ( database_name TEXT, table_name TEXT, rootpage INTEGER, sql TEXT, PRIMARY KEY (database_name, table_name), FOREIGN KEY (database_name) REFERENCES databases(database_name) )
_internal,datasette_events _internal datasette_events 6 CREATE TABLE datasette_events ( id integer primary key, event text, created text, actor_id text, database_name text, table_name text, properties text -- JSON other properties )
_internal,datasette_pins_global_pinned_items _internal datasette_pins_global_pinned_items 4 CREATE TABLE datasette_pins_global_pinned_items( id integer primary key autoincrement, --- Datasette actor ID of the user who pinned the item pinner_actor_id text, -- 'home' or 'database' pin_location text, -- 'database', 'table', 'canned_query', or plugin-defined string item_type text, --- origin_database text, --- origin_table text, identifier text, --- order_idx integer )
_internal,metadata_columns _internal metadata_columns 25 CREATE TABLE metadata_columns ( database_name text, resource_name text, column_name text, key text, value text, unique(database_name, resource_name, column_name, key) )
_internal,metadata_databases _internal metadata_databases 19 CREATE TABLE metadata_databases ( database_name text, key text, value text, unique(database_name, key) )
_internal,metadata_instance _internal metadata_instance 17 CREATE TABLE metadata_instance ( key text, value text, unique(key) )
_internal,metadata_resources _internal metadata_resources 21 CREATE TABLE metadata_resources ( database_name text, resource_name text, key text, value text, unique(database_name, resource_name, key) )
_internal,sqlite_sequence _internal sqlite_sequence 5 CREATE TABLE sqlite_sequence(name,seq)
data,FormDiffs data FormDiffs 2617 CREATE TABLE "FormDiffs" ( [role_id] TEXT, [role_name] TEXT, [preference_type] TEXT, [Form Name] TEXT, [sb_enabled] TEXT, [prod_enabled] TEXT, [sp_preferred] TEXT, [prod_preferred] TEXT, [sb_restricted] TEXT, [prod_restricted] TEXT, [sb_stored] TEXT, [prod_stored] TEXT, [has_difference] INTEGER, [line_no_order] INTEGER )
data,customrecordtypes data customrecordtypes 29 CREATE TABLE "customrecordtypes" ( [id] INTEGER PRIMARY KEY, [name] TEXT )
data,customsearchprefs data customsearchprefs 11 CREATE TABLE [customsearchprefs] ( [listview] TEXT, [listview_display] TEXT, [machineview] TEXT, [machineview_display] TEXT, [portletview] TEXT, [portletview_display] TEXT, [recordtype] TEXT, [restrictlistview] TEXT, [restrictmachineview] TEXT, [restrictportletview] TEXT, [searchform] TEXT, [searchform_display] TEXT, [searchresults] TEXT, [searchresults_display] TEXT, [sys_id] TEXT, [sys_parentid] TEXT, [env] TEXT, [role_id] TEXT, [line_key] TEXT, [line_no] TEXT, PRIMARY KEY ([env], [role_id], [line_key]) )
data,custrecordmach data custrecordmach 2656 CREATE TABLE "custrecordmach" ( [custrecord] INTEGER, [permittedlevel] TEXT, [restriction] TEXT, [sys_id] TEXT, [sys_parentid] TEXT, [env] TEXT, [role_id] TEXT, [line_key] TEXT, [line_no] TEXT, PRIMARY KEY ([env], [role_id], [line_key]) )
data,custrecordmach_new_abae96cecbd8 data custrecordmach_new_abae96cecbd8 27 CREATE TABLE [custrecordmach_new_abae96cecbd8] ( [custrecord] INTEGER REFERENCES [customrecordtypes]([id]), [permittedlevel] TEXT, [restriction] TEXT, [sys_id] TEXT, [sys_parentid] TEXT, [env] TEXT, [role_id] TEXT, [line_key] TEXT, [line_no] TEXT, PRIMARY KEY ([env], [role_id], [line_key]) )
data,entityformprefs data entityformprefs 68 CREATE TABLE [entityformprefs] ( [entityenabled] TEXT, [entitypreferred] TEXT, [entityrecordtype] TEXT, [entityrestricted] TEXT, [entitystored] TEXT, [entitytemplate] TEXT, [entitytemplatename] TEXT, [entitytype] TEXT, [entitytypename] TEXT, [sys_id] TEXT, [sys_parentid] TEXT, [env] TEXT, [role_id] TEXT, [line_key] TEXT, [line_no] TEXT, PRIMARY KEY ([env], [role_id], [line_key]) )
data,eventformprefs data eventformprefs 116 CREATE TABLE [eventformprefs] ( [eventenabled] TEXT, [eventpreferred] TEXT, [eventrecordtype] TEXT, [eventrestricted] TEXT, [eventstored] TEXT, [eventtemplate] TEXT, [eventtemplatename] TEXT, [eventtype] TEXT, [eventtypename] TEXT, [sys_id] TEXT, [sys_parentid] TEXT, [env] TEXT, [role_id] TEXT, [line_key] TEXT, [line_no] TEXT, PRIMARY KEY ([env], [role_id], [line_key]) )
data,itemformprefs data itemformprefs 140 CREATE TABLE [itemformprefs] ( [itemenabled] TEXT, [itempreferred] TEXT, [itemrecordtype] TEXT, [itemrestricted] TEXT, [itemstored] TEXT, [itemtemplate] TEXT, [itemtemplatename] TEXT, [itemtype] TEXT, [itemtypename] TEXT, [sys_id] TEXT, [sys_parentid] TEXT, [env] TEXT, [role_id] TEXT, [line_key] TEXT, [line_no] TEXT, PRIMARY KEY ([env], [role_id], [line_key]) )
data,listsmach data listsmach 162 CREATE TABLE [listsmach] ( [permkey3] TEXT, [permlevel3] TEXT, [permlevel3_display] TEXT, [sys_id] TEXT, [sys_parentid] TEXT, [env] TEXT, [role_id] TEXT, [line_key] TEXT, [line_no] TEXT, PRIMARY KEY ([env], [role_id], [line_key]) )
data,otherformprefs data otherformprefs 235 CREATE TABLE [otherformprefs] ( [otherenabled] TEXT, [otherpreferred] TEXT, [otherrecordtype] TEXT, [otherrestricted] TEXT, [otherstored] TEXT, [othertemplate] TEXT, [othertemplatename] TEXT, [othertype] TEXT, [othertypename] TEXT, [sys_id] TEXT, [sys_parentid] TEXT, [env] TEXT, [role_id] TEXT, [line_key] TEXT, [line_no] TEXT, PRIMARY KEY ([env], [role_id], [line_key]) )
data,preferences data preferences 270 CREATE TABLE [preferences] ( [preference] TEXT, [preftext] TEXT, [prefvalue] TEXT, [sys_id] TEXT, [sys_parentid] TEXT, [env] TEXT, [role_id] TEXT, [line_key] TEXT, [line_no] TEXT, PRIMARY KEY ([env], [role_id], [line_key]) )
data,recordformprefs data recordformprefs 284 CREATE TABLE [recordformprefs] ( [recordenabled] TEXT, [recordpreferred] TEXT, [recordrecordtype] TEXT, [recordrestricted] TEXT, [recordstored] TEXT, [recordtemplate] TEXT, [recordtemplatename] TEXT, [recordtype] TEXT, [recordtypename] TEXT, [sys_id] TEXT, [sys_parentid] TEXT, [env] TEXT, [role_id] TEXT, [line_key] TEXT, [line_no] TEXT, PRIMARY KEY ([env], [role_id], [line_key]) )
data,recordrestrictions data recordrestrictions 1079 CREATE TABLE [recordrestrictions] ( [itemsrestricted] TEXT, [restriction] TEXT, [segment] TEXT, [sys_id] TEXT, [sys_parentid] TEXT, [viewingallowed] TEXT, [env] TEXT, [role_id] TEXT, [line_key] TEXT, [line_no] TEXT, PRIMARY KEY ([env], [role_id], [line_key]) )
data,repomach data repomach 1081 CREATE TABLE [repomach] ( [permkey2] TEXT, [permlevel2] TEXT, [permlevel2_display] TEXT, [sys_id] TEXT, [sys_parentid] TEXT, [env] TEXT, [role_id] TEXT, [line_key] TEXT, [line_no] TEXT, PRIMARY KEY ([env], [role_id], [line_key]) )
data,roles_fields data roles_fields 4 CREATE TABLE [roles_fields] ( [env] TEXT, [role_id] TEXT, [rolenameorig] TEXT, [issalesrole] TEXT, [_eml_nkey_] TEXT, [type] TEXT, [nsapiCT] TEXT, [subsidiaryoption] TEXT, [sys_id] TEXT, [tfaduration] TEXT, [id] TEXT, [issupportrole] TEXT, [employeeselectionunrestricted] TEXT, [centertype] TEXT, [parentrolelink] TEXT, [restrictbydevice] TEXT, [issinglesignononly] TEXT, [subsidiaryviewingallowed] TEXT, [entryformquerystring] TEXT, [tfarequired] TEXT, [cr] TEXT, [coreadminpermission] TEXT, [external] TEXT, [restricttimeandexpenses] TEXT, [name] TEXT, [iswebserviceonly] TEXT, [employeerestriction] TEXT, [origid] TEXT, [employeeviewingallowed] TEXT, [isinactive] TEXT, [scriptid] TEXT, [savedash] TEXT, [parentrolescriptid] TEXT, [package] TEXT, [roletype] TEXT, [internalid] TEXT, PRIMARY KEY ([env], [role_id]) )
data,roles_to_compare data roles_to_compare 2 CREATE TABLE [roles_to_compare] ( [role_id] TEXT PRIMARY KEY, [role_name] TEXT )
data,searchprefs data searchprefs 1104 CREATE TABLE [searchprefs] ( [listview] TEXT, [listview_display] TEXT, [machineview] TEXT, [machineview_display] TEXT, [portletview] TEXT, [portletview_display] TEXT, [restrictlistview] TEXT, [restrictmachineview] TEXT, [restrictportletview] TEXT, [searchform] TEXT, [searchform_display] TEXT, [searchresults] TEXT, [searchresults_display] TEXT, [searchtype] TEXT, [sys_id] TEXT, [sys_parentid] TEXT, [env] TEXT, [role_id] TEXT, [line_key] TEXT, [line_no] TEXT, PRIMARY KEY ([env], [role_id], [line_key]) )
data,setupmach data setupmach 1112 CREATE TABLE [setupmach] ( [permkey4] TEXT, [permlevel4] TEXT, [permlevel4_display] TEXT, [sys_id] TEXT, [sys_parentid] TEXT, [env] TEXT, [role_id] TEXT, [line_key] TEXT, [line_no] TEXT, PRIMARY KEY ([env], [role_id], [line_key]) )
data,timeformprefs data timeformprefs 1142 CREATE TABLE [timeformprefs] ( [sys_id] TEXT, [sys_parentid] TEXT, [timeenabled] TEXT, [timepreferred] TEXT, [timerecordtype] TEXT, [timerestricted] TEXT, [timestored] TEXT, [timetemplate] TEXT, [timetemplatename] TEXT, [timetype] TEXT, [timetypename] TEXT, [env] TEXT, [role_id] TEXT, [line_key] TEXT, [line_no] TEXT, PRIMARY KEY ([env], [role_id], [line_key]) )
data,tranformprefs data tranformprefs 1158 CREATE TABLE [tranformprefs] ( [sys_id] TEXT, [sys_parentid] TEXT, [tranenabled] TEXT, [tranpreferred] TEXT, [tranrestricted] TEXT, [transtored] TEXT, [trantemplate] TEXT, [trantemplatename] TEXT, [trantype] TEXT, [trantypename] TEXT, [env] TEXT, [role_id] TEXT, [line_key] TEXT, [line_no] TEXT, PRIMARY KEY ([env], [role_id], [line_key]) )
data,tranmach data tranmach 1266 CREATE TABLE [tranmach] ( [permkey1] TEXT, [permlevel1] TEXT, [permlevel1_display] TEXT, [sys_id] TEXT, [sys_parentid] TEXT, [env] TEXT, [role_id] TEXT, [line_key] TEXT, [line_no] TEXT, PRIMARY KEY ([env], [role_id], [line_key]) )

Advanced export

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

CSV options: 

CREATE TABLE catalog_tables (
    database_name TEXT,
    table_name TEXT,
    rootpage INTEGER,
    sql TEXT,
    PRIMARY KEY (database_name, table_name),
    FOREIGN KEY (database_name) REFERENCES databases(database_name)
);