_internal: catalog_indexes: 29 rows

29 rows

descending

Link	database_name	table_name	name	unique	origin
_internal,_sqlite_migrations,sqlite_autoindex__sqlite_migrations_1	_internal	_sqlite_migrations	sqlite_autoindex__sqlite_migrations_1	1	pk
_internal,catalog_columns,sqlite_autoindex_catalog_columns_1	_internal	catalog_columns	sqlite_autoindex_catalog_columns_1	1	pk
_internal,catalog_databases,sqlite_autoindex_catalog_databases_1	_internal	catalog_databases	sqlite_autoindex_catalog_databases_1	1	pk
_internal,catalog_foreign_keys,sqlite_autoindex_catalog_foreign_keys_1	_internal	catalog_foreign_keys	sqlite_autoindex_catalog_foreign_keys_1	1	pk
_internal,catalog_indexes,sqlite_autoindex_catalog_indexes_1	_internal	catalog_indexes	sqlite_autoindex_catalog_indexes_1	1	pk
_internal,catalog_tables,sqlite_autoindex_catalog_tables_1	_internal	catalog_tables	sqlite_autoindex_catalog_tables_1	1	pk
_internal,metadata_columns,sqlite_autoindex_metadata_columns_1	_internal	metadata_columns	sqlite_autoindex_metadata_columns_1	1	u
_internal,metadata_databases,sqlite_autoindex_metadata_databases_1	_internal	metadata_databases	sqlite_autoindex_metadata_databases_1	1	u
_internal,metadata_instance,sqlite_autoindex_metadata_instance_1	_internal	metadata_instance	sqlite_autoindex_metadata_instance_1	1	u
_internal,metadata_resources,sqlite_autoindex_metadata_resources_1	_internal	metadata_resources	sqlite_autoindex_metadata_resources_1	1	u
data,customsearchprefs,sqlite_autoindex_customsearchprefs_1	data	customsearchprefs	sqlite_autoindex_customsearchprefs_1	1	pk
data,custrecordmach,sqlite_autoindex_custrecordmach_1	data	custrecordmach	sqlite_autoindex_custrecordmach_1	1	pk
data,custrecordmach_new_abae96cecbd8,sqlite_autoindex_custrecordmach_new_abae96cecbd8_1	data	custrecordmach_new_abae96cecbd8	sqlite_autoindex_custrecordmach_new_abae96cecbd8_1	1	pk
data,entityformprefs,sqlite_autoindex_entityformprefs_1	data	entityformprefs	sqlite_autoindex_entityformprefs_1	1	pk
data,eventformprefs,sqlite_autoindex_eventformprefs_1	data	eventformprefs	sqlite_autoindex_eventformprefs_1	1	pk
data,itemformprefs,sqlite_autoindex_itemformprefs_1	data	itemformprefs	sqlite_autoindex_itemformprefs_1	1	pk
data,listsmach,sqlite_autoindex_listsmach_1	data	listsmach	sqlite_autoindex_listsmach_1	1	pk
data,otherformprefs,sqlite_autoindex_otherformprefs_1	data	otherformprefs	sqlite_autoindex_otherformprefs_1	1	pk
data,preferences,sqlite_autoindex_preferences_1	data	preferences	sqlite_autoindex_preferences_1	1	pk
data,recordformprefs,sqlite_autoindex_recordformprefs_1	data	recordformprefs	sqlite_autoindex_recordformprefs_1	1	pk
data,recordrestrictions,sqlite_autoindex_recordrestrictions_1	data	recordrestrictions	sqlite_autoindex_recordrestrictions_1	1	pk
data,repomach,sqlite_autoindex_repomach_1	data	repomach	sqlite_autoindex_repomach_1	1	pk
data,roles_fields,sqlite_autoindex_roles_fields_1	data	roles_fields	sqlite_autoindex_roles_fields_1	1	pk
data,roles_to_compare,sqlite_autoindex_roles_to_compare_1	data	roles_to_compare	sqlite_autoindex_roles_to_compare_1	1	pk
data,searchprefs,sqlite_autoindex_searchprefs_1	data	searchprefs	sqlite_autoindex_searchprefs_1	1	pk
data,setupmach,sqlite_autoindex_setupmach_1	data	setupmach	sqlite_autoindex_setupmach_1	1	pk
data,timeformprefs,sqlite_autoindex_timeformprefs_1	data	timeformprefs	sqlite_autoindex_timeformprefs_1	1	pk
data,tranformprefs,sqlite_autoindex_tranformprefs_1	data	tranformprefs	sqlite_autoindex_tranformprefs_1	1	pk
data,tranmach,sqlite_autoindex_tranmach_1	data	tranmach	sqlite_autoindex_tranmach_1	1	pk

Advanced export

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

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)
);