CREATE VIEW console_content_tabular AS
SELECT 'table' as tabular_nature,
table_name as tabular_name,
info_schema_web_ui_path,
info_schema_link_abbrev_md,
info_schema_link_full_md,
content_web_ui_path,
content_web_ui_link_abbrev_md,
content_web_ui_link_full_md
FROM console_information_schema_table
UNION ALL
SELECT 'view' as tabular_nature,
view_name as tabular_name,
info_schema_web_ui_path,
info_schema_link_abbrev_md,
info_schema_link_full_md,
content_web_ui_path,
content_web_ui_link_abbrev_md,
content_web_ui_link_full_md
FROM console_information_schema_view