console_information_schema_table_col_index (view) Content

console_information_schema_table_col_index (view) Schema


device	name	sqlite_autoindex_device_2
device	state	sqlite_autoindex_device_2
device	boundary	sqlite_autoindex_device_2
device	device_id	sqlite_autoindex_device_1
device_party_relationship	device_id	idx_device_party_relationship__device_id__party_id
device_party_relationship	party_id	idx_device_party_relationship__device_id__party_id
device_party_relationship	device_id	sqlite_autoindex_device_party_relationship_2
device_party_relationship	party_id	sqlite_autoindex_device_party_relationship_2
device_party_relationship	device_party_relationship_id	sqlite_autoindex_device_party_relationship_1
behavior	device_id	sqlite_autoindex_behavior_2
behavior	behavior_name	sqlite_autoindex_behavior_2
behavior	behavior_id	sqlite_autoindex_behavior_1
ur_ingest_resource_path_match_rule	namespace	sqlite_autoindex_ur_ingest_resource_path_match_rule_2
ur_ingest_resource_path_match_rule	regex	sqlite_autoindex_ur_ingest_resource_path_match_rule_2
ur_ingest_resource_path_match_rule	ur_ingest_resource_path_match_rule_id	sqlite_autoindex_ur_ingest_resource_path_match_rule_1
ur_ingest_resource_path_rewrite_rule	namespace	sqlite_autoindex_ur_ingest_resource_path_rewrite_rule_2
ur_ingest_resource_path_rewrite_rule	regex	sqlite_autoindex_ur_ingest_resource_path_rewrite_rule_2
ur_ingest_resource_path_rewrite_rule	replace	sqlite_autoindex_ur_ingest_resource_path_rewrite_rule_2
ur_ingest_resource_path_rewrite_rule	ur_ingest_resource_path_rewrite_rule_id	sqlite_autoindex_ur_ingest_resource_path_rewrite_rule_1
ur_ingest_session	device_id	sqlite_autoindex_ur_ingest_session_2
ur_ingest_session	created_at	sqlite_autoindex_ur_ingest_session_2
ur_ingest_session	ur_ingest_session_id	sqlite_autoindex_ur_ingest_session_1
ur_ingest_session_fs_path	ingest_session_id	idx_ur_ingest_session_fs_path__ingest_session_id__root_path
ur_ingest_session_fs_path	root_path	idx_ur_ingest_session_fs_path__ingest_session_id__root_path
ur_ingest_session_fs_path	ingest_session_id	sqlite_autoindex_ur_ingest_session_fs_path_2
ur_ingest_session_fs_path	root_path	sqlite_autoindex_ur_ingest_session_fs_path_2
ur_ingest_session_fs_path	created_at	sqlite_autoindex_ur_ingest_session_fs_path_2
ur_ingest_session_fs_path	ur_ingest_session_fs_path_id	sqlite_autoindex_ur_ingest_session_fs_path_1
uniform_resource	device_id	idx_uniform_resource__device_id__uri
uniform_resource	uri	idx_uniform_resource__device_id__uri
uniform_resource	device_id	sqlite_autoindex_uniform_resource_2
uniform_resource	content_digest	sqlite_autoindex_uniform_resource_2
uniform_resource	uri	sqlite_autoindex_uniform_resource_2
uniform_resource	size_bytes	sqlite_autoindex_uniform_resource_2
uniform_resource	uniform_resource_id	sqlite_autoindex_uniform_resource_1
uniform_resource_transform	uniform_resource_id	idx_uniform_resource_transform__uniform_resource_id__content_digest
uniform_resource_transform	content_digest	idx_uniform_resource_transform__uniform_resource_id__content_digest
uniform_resource_transform	uniform_resource_id	sqlite_autoindex_uniform_resource_transform_2
uniform_resource_transform	content_digest	sqlite_autoindex_uniform_resource_transform_2
uniform_resource_transform	nature	sqlite_autoindex_uniform_resource_transform_2
uniform_resource_transform	size_bytes	sqlite_autoindex_uniform_resource_transform_2
uniform_resource_transform	uniform_resource_transform_id	sqlite_autoindex_uniform_resource_transform_1
ur_ingest_session_fs_path_entry	ingest_session_id	idx_ur_ingest_session_fs_path_entry__ingest_session_id__file_path_abs
ur_ingest_session_fs_path_entry	file_path_abs	idx_ur_ingest_session_fs_path_entry__ingest_session_id__file_path_abs
ur_ingest_session_fs_path_entry	ur_ingest_session_fs_path_entry_id	sqlite_autoindex_ur_ingest_session_fs_path_entry_1
ur_ingest_session_task	ingest_session_id	idx_ur_ingest_session_task__ingest_session_id
ur_ingest_session_task	ur_ingest_session_task_id	sqlite_autoindex_ur_ingest_session_task_1
ur_ingest_session_imap_account	ingest_session_id	idx_ur_ingest_session_imap_account__ingest_session_id__email
ur_ingest_session_imap_account	email	idx_ur_ingest_session_imap_account__ingest_session_id__email
ur_ingest_session_imap_account	ingest_session_id	sqlite_autoindex_ur_ingest_session_imap_account_2

Error We are sorry, but an error occurred while generating this page. You should contact the site's administrator.

Error in query number 6:

Parsing failed: SQLPage couldn't understand the SQL file. Please check for syntax errors:

            SELECT 'text' AS component,
                (SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE ' END) || ' ' ||
                                                                                                                                                   ⬆️
                '(Page ' || $current_page || ' of ' || $total_pages || ') ' ||

Backtrace

sql parser error: Expected: END, found: ' ||
                ' at Line: 42, Column: 149

"console/content/view/console_information_schema_table_col_index.auto.sql" contains a syntax error preventing SQLPage from parsing and preparing its SQL statements.

You can hide error messages like this one from your users by setting the 'environment' configuration option to 'production'.