| console_information_schema_table |
sql_ddl |
TEXT |
/console/info-schema/view.sql?name=console_information_schema_table&stats=yes |
[Content](console/info-schema/view.sql?name=console_information_schema_table&stats=yes) |
[console_information_schema_table (view) Schema](console/info-schema/view.sql?name=console_information_schema_table&stats=yes) |
/console/content/view/console_information_schema_table.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/console_information_schema_table.sql?stats=yes) |
[console_information_schema_table (view) Content](console/content/view/console_information_schema_table.sql?stats=yes) |
CREATE VIEW console_information_schema_table AS
SELECT
tbl.name AS table_name,
col.name AS column_name,
col.type AS data_type,
CASE WHEN col.pk = 1 THEN 'Yes' ELSE 'No' END AS is_primary_key,
CASE WHEN col."notnull" = 1 THEN 'Yes' ELSE 'No' END AS is_not_null,
col.dflt_value AS default_value,
'console/info-schema/table.sql?name=' || tbl.name || '&stats=yes' as info_schema_web_ui_path,
'[Content](console/info-schema/table.sql?name=' || tbl.name || '&stats=yes)' as info_schema_link_abbrev_md,
'[' || tbl.name || ' (table) Schema](console/info-schema/table.sql?name=' || tbl.name || '&stats=yes)' as info_schema_link_full_md,
'console/content/table/' || tbl.name || '.sql?stats=yes' as content_web_ui_path,
'[Content]($SITE_PREFIX_URL/console/content/table/' || tbl.name || '.sql?stats=yes)' as content_web_ui_link_abbrev_md,
'[' || tbl.name || ' (table) Content](console/content/table/' || tbl.name || '.sql?stats=yes)' as content_web_ui_link_full_md,
tbl.sql as sql_ddl
FROM sqlite_master tbl
JOIN pragma_table_info(tbl.name) col
WHERE tbl.type = 'table' AND tbl.name NOT LIKE 'sqlite_%' |
| console_information_schema_view |
view_name |
TEXT |
/console/info-schema/view.sql?name=console_information_schema_view&stats=yes |
[Content](console/info-schema/view.sql?name=console_information_schema_view&stats=yes) |
[console_information_schema_view (view) Schema](console/info-schema/view.sql?name=console_information_schema_view&stats=yes) |
/console/content/view/console_information_schema_view.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/console_information_schema_view.sql?stats=yes) |
[console_information_schema_view (view) Content](console/content/view/console_information_schema_view.sql?stats=yes) |
CREATE VIEW console_information_schema_view AS
SELECT
vw.name AS view_name,
col.name AS column_name,
col.type AS data_type,
'/console/info-schema/view.sql?name=' || vw.name || '&stats=yes' as info_schema_web_ui_path,
'[Content](console/info-schema/view.sql?name=' || vw.name || '&stats=yes)' as info_schema_link_abbrev_md,
'[' || vw.name || ' (view) Schema](console/info-schema/view.sql?name=' || vw.name || '&stats=yes)' as info_schema_link_full_md,
'/console/content/view/' || vw.name || '.sql?stats=yes' as content_web_ui_path,
'[Content]($SITE_PREFIX_URL/console/content/view/' || vw.name || '.sql?stats=yes)' as content_web_ui_link_abbrev_md,
'[' || vw.name || ' (view) Content](console/content/view/' || vw.name || '.sql?stats=yes)' as content_web_ui_link_full_md,
vw.sql as sql_ddl
FROM sqlite_master vw
JOIN pragma_table_info(vw.name) col
WHERE vw.type = 'view' AND vw.name NOT LIKE 'sqlite_%' |
| console_information_schema_view |
column_name |
BLOB |
/console/info-schema/view.sql?name=console_information_schema_view&stats=yes |
[Content](console/info-schema/view.sql?name=console_information_schema_view&stats=yes) |
[console_information_schema_view (view) Schema](console/info-schema/view.sql?name=console_information_schema_view&stats=yes) |
/console/content/view/console_information_schema_view.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/console_information_schema_view.sql?stats=yes) |
[console_information_schema_view (view) Content](console/content/view/console_information_schema_view.sql?stats=yes) |
CREATE VIEW console_information_schema_view AS
SELECT
vw.name AS view_name,
col.name AS column_name,
col.type AS data_type,
'/console/info-schema/view.sql?name=' || vw.name || '&stats=yes' as info_schema_web_ui_path,
'[Content](console/info-schema/view.sql?name=' || vw.name || '&stats=yes)' as info_schema_link_abbrev_md,
'[' || vw.name || ' (view) Schema](console/info-schema/view.sql?name=' || vw.name || '&stats=yes)' as info_schema_link_full_md,
'/console/content/view/' || vw.name || '.sql?stats=yes' as content_web_ui_path,
'[Content]($SITE_PREFIX_URL/console/content/view/' || vw.name || '.sql?stats=yes)' as content_web_ui_link_abbrev_md,
'[' || vw.name || ' (view) Content](console/content/view/' || vw.name || '.sql?stats=yes)' as content_web_ui_link_full_md,
vw.sql as sql_ddl
FROM sqlite_master vw
JOIN pragma_table_info(vw.name) col
WHERE vw.type = 'view' AND vw.name NOT LIKE 'sqlite_%' |
| console_information_schema_view |
data_type |
BLOB |
/console/info-schema/view.sql?name=console_information_schema_view&stats=yes |
[Content](console/info-schema/view.sql?name=console_information_schema_view&stats=yes) |
[console_information_schema_view (view) Schema](console/info-schema/view.sql?name=console_information_schema_view&stats=yes) |
/console/content/view/console_information_schema_view.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/console_information_schema_view.sql?stats=yes) |
[console_information_schema_view (view) Content](console/content/view/console_information_schema_view.sql?stats=yes) |
CREATE VIEW console_information_schema_view AS
SELECT
vw.name AS view_name,
col.name AS column_name,
col.type AS data_type,
'/console/info-schema/view.sql?name=' || vw.name || '&stats=yes' as info_schema_web_ui_path,
'[Content](console/info-schema/view.sql?name=' || vw.name || '&stats=yes)' as info_schema_link_abbrev_md,
'[' || vw.name || ' (view) Schema](console/info-schema/view.sql?name=' || vw.name || '&stats=yes)' as info_schema_link_full_md,
'/console/content/view/' || vw.name || '.sql?stats=yes' as content_web_ui_path,
'[Content]($SITE_PREFIX_URL/console/content/view/' || vw.name || '.sql?stats=yes)' as content_web_ui_link_abbrev_md,
'[' || vw.name || ' (view) Content](console/content/view/' || vw.name || '.sql?stats=yes)' as content_web_ui_link_full_md,
vw.sql as sql_ddl
FROM sqlite_master vw
JOIN pragma_table_info(vw.name) col
WHERE vw.type = 'view' AND vw.name NOT LIKE 'sqlite_%' |
| console_information_schema_view |
info_schema_web_ui_path |
|
/console/info-schema/view.sql?name=console_information_schema_view&stats=yes |
[Content](console/info-schema/view.sql?name=console_information_schema_view&stats=yes) |
[console_information_schema_view (view) Schema](console/info-schema/view.sql?name=console_information_schema_view&stats=yes) |
/console/content/view/console_information_schema_view.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/console_information_schema_view.sql?stats=yes) |
[console_information_schema_view (view) Content](console/content/view/console_information_schema_view.sql?stats=yes) |
CREATE VIEW console_information_schema_view AS
SELECT
vw.name AS view_name,
col.name AS column_name,
col.type AS data_type,
'/console/info-schema/view.sql?name=' || vw.name || '&stats=yes' as info_schema_web_ui_path,
'[Content](console/info-schema/view.sql?name=' || vw.name || '&stats=yes)' as info_schema_link_abbrev_md,
'[' || vw.name || ' (view) Schema](console/info-schema/view.sql?name=' || vw.name || '&stats=yes)' as info_schema_link_full_md,
'/console/content/view/' || vw.name || '.sql?stats=yes' as content_web_ui_path,
'[Content]($SITE_PREFIX_URL/console/content/view/' || vw.name || '.sql?stats=yes)' as content_web_ui_link_abbrev_md,
'[' || vw.name || ' (view) Content](console/content/view/' || vw.name || '.sql?stats=yes)' as content_web_ui_link_full_md,
vw.sql as sql_ddl
FROM sqlite_master vw
JOIN pragma_table_info(vw.name) col
WHERE vw.type = 'view' AND vw.name NOT LIKE 'sqlite_%' |
| console_information_schema_view |
info_schema_link_abbrev_md |
|
/console/info-schema/view.sql?name=console_information_schema_view&stats=yes |
[Content](console/info-schema/view.sql?name=console_information_schema_view&stats=yes) |
[console_information_schema_view (view) Schema](console/info-schema/view.sql?name=console_information_schema_view&stats=yes) |
/console/content/view/console_information_schema_view.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/console_information_schema_view.sql?stats=yes) |
[console_information_schema_view (view) Content](console/content/view/console_information_schema_view.sql?stats=yes) |
CREATE VIEW console_information_schema_view AS
SELECT
vw.name AS view_name,
col.name AS column_name,
col.type AS data_type,
'/console/info-schema/view.sql?name=' || vw.name || '&stats=yes' as info_schema_web_ui_path,
'[Content](console/info-schema/view.sql?name=' || vw.name || '&stats=yes)' as info_schema_link_abbrev_md,
'[' || vw.name || ' (view) Schema](console/info-schema/view.sql?name=' || vw.name || '&stats=yes)' as info_schema_link_full_md,
'/console/content/view/' || vw.name || '.sql?stats=yes' as content_web_ui_path,
'[Content]($SITE_PREFIX_URL/console/content/view/' || vw.name || '.sql?stats=yes)' as content_web_ui_link_abbrev_md,
'[' || vw.name || ' (view) Content](console/content/view/' || vw.name || '.sql?stats=yes)' as content_web_ui_link_full_md,
vw.sql as sql_ddl
FROM sqlite_master vw
JOIN pragma_table_info(vw.name) col
WHERE vw.type = 'view' AND vw.name NOT LIKE 'sqlite_%' |
| console_information_schema_view |
info_schema_link_full_md |
|
/console/info-schema/view.sql?name=console_information_schema_view&stats=yes |
[Content](console/info-schema/view.sql?name=console_information_schema_view&stats=yes) |
[console_information_schema_view (view) Schema](console/info-schema/view.sql?name=console_information_schema_view&stats=yes) |
/console/content/view/console_information_schema_view.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/console_information_schema_view.sql?stats=yes) |
[console_information_schema_view (view) Content](console/content/view/console_information_schema_view.sql?stats=yes) |
CREATE VIEW console_information_schema_view AS
SELECT
vw.name AS view_name,
col.name AS column_name,
col.type AS data_type,
'/console/info-schema/view.sql?name=' || vw.name || '&stats=yes' as info_schema_web_ui_path,
'[Content](console/info-schema/view.sql?name=' || vw.name || '&stats=yes)' as info_schema_link_abbrev_md,
'[' || vw.name || ' (view) Schema](console/info-schema/view.sql?name=' || vw.name || '&stats=yes)' as info_schema_link_full_md,
'/console/content/view/' || vw.name || '.sql?stats=yes' as content_web_ui_path,
'[Content]($SITE_PREFIX_URL/console/content/view/' || vw.name || '.sql?stats=yes)' as content_web_ui_link_abbrev_md,
'[' || vw.name || ' (view) Content](console/content/view/' || vw.name || '.sql?stats=yes)' as content_web_ui_link_full_md,
vw.sql as sql_ddl
FROM sqlite_master vw
JOIN pragma_table_info(vw.name) col
WHERE vw.type = 'view' AND vw.name NOT LIKE 'sqlite_%' |
| console_information_schema_view |
content_web_ui_path |
|
/console/info-schema/view.sql?name=console_information_schema_view&stats=yes |
[Content](console/info-schema/view.sql?name=console_information_schema_view&stats=yes) |
[console_information_schema_view (view) Schema](console/info-schema/view.sql?name=console_information_schema_view&stats=yes) |
/console/content/view/console_information_schema_view.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/console_information_schema_view.sql?stats=yes) |
[console_information_schema_view (view) Content](console/content/view/console_information_schema_view.sql?stats=yes) |
CREATE VIEW console_information_schema_view AS
SELECT
vw.name AS view_name,
col.name AS column_name,
col.type AS data_type,
'/console/info-schema/view.sql?name=' || vw.name || '&stats=yes' as info_schema_web_ui_path,
'[Content](console/info-schema/view.sql?name=' || vw.name || '&stats=yes)' as info_schema_link_abbrev_md,
'[' || vw.name || ' (view) Schema](console/info-schema/view.sql?name=' || vw.name || '&stats=yes)' as info_schema_link_full_md,
'/console/content/view/' || vw.name || '.sql?stats=yes' as content_web_ui_path,
'[Content]($SITE_PREFIX_URL/console/content/view/' || vw.name || '.sql?stats=yes)' as content_web_ui_link_abbrev_md,
'[' || vw.name || ' (view) Content](console/content/view/' || vw.name || '.sql?stats=yes)' as content_web_ui_link_full_md,
vw.sql as sql_ddl
FROM sqlite_master vw
JOIN pragma_table_info(vw.name) col
WHERE vw.type = 'view' AND vw.name NOT LIKE 'sqlite_%' |
| console_information_schema_view |
content_web_ui_link_abbrev_md |
|
/console/info-schema/view.sql?name=console_information_schema_view&stats=yes |
[Content](console/info-schema/view.sql?name=console_information_schema_view&stats=yes) |
[console_information_schema_view (view) Schema](console/info-schema/view.sql?name=console_information_schema_view&stats=yes) |
/console/content/view/console_information_schema_view.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/console_information_schema_view.sql?stats=yes) |
[console_information_schema_view (view) Content](console/content/view/console_information_schema_view.sql?stats=yes) |
CREATE VIEW console_information_schema_view AS
SELECT
vw.name AS view_name,
col.name AS column_name,
col.type AS data_type,
'/console/info-schema/view.sql?name=' || vw.name || '&stats=yes' as info_schema_web_ui_path,
'[Content](console/info-schema/view.sql?name=' || vw.name || '&stats=yes)' as info_schema_link_abbrev_md,
'[' || vw.name || ' (view) Schema](console/info-schema/view.sql?name=' || vw.name || '&stats=yes)' as info_schema_link_full_md,
'/console/content/view/' || vw.name || '.sql?stats=yes' as content_web_ui_path,
'[Content]($SITE_PREFIX_URL/console/content/view/' || vw.name || '.sql?stats=yes)' as content_web_ui_link_abbrev_md,
'[' || vw.name || ' (view) Content](console/content/view/' || vw.name || '.sql?stats=yes)' as content_web_ui_link_full_md,
vw.sql as sql_ddl
FROM sqlite_master vw
JOIN pragma_table_info(vw.name) col
WHERE vw.type = 'view' AND vw.name NOT LIKE 'sqlite_%' |
| console_information_schema_view |
content_web_ui_link_full_md |
|
/console/info-schema/view.sql?name=console_information_schema_view&stats=yes |
[Content](console/info-schema/view.sql?name=console_information_schema_view&stats=yes) |
[console_information_schema_view (view) Schema](console/info-schema/view.sql?name=console_information_schema_view&stats=yes) |
/console/content/view/console_information_schema_view.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/console_information_schema_view.sql?stats=yes) |
[console_information_schema_view (view) Content](console/content/view/console_information_schema_view.sql?stats=yes) |
CREATE VIEW console_information_schema_view AS
SELECT
vw.name AS view_name,
col.name AS column_name,
col.type AS data_type,
'/console/info-schema/view.sql?name=' || vw.name || '&stats=yes' as info_schema_web_ui_path,
'[Content](console/info-schema/view.sql?name=' || vw.name || '&stats=yes)' as info_schema_link_abbrev_md,
'[' || vw.name || ' (view) Schema](console/info-schema/view.sql?name=' || vw.name || '&stats=yes)' as info_schema_link_full_md,
'/console/content/view/' || vw.name || '.sql?stats=yes' as content_web_ui_path,
'[Content]($SITE_PREFIX_URL/console/content/view/' || vw.name || '.sql?stats=yes)' as content_web_ui_link_abbrev_md,
'[' || vw.name || ' (view) Content](console/content/view/' || vw.name || '.sql?stats=yes)' as content_web_ui_link_full_md,
vw.sql as sql_ddl
FROM sqlite_master vw
JOIN pragma_table_info(vw.name) col
WHERE vw.type = 'view' AND vw.name NOT LIKE 'sqlite_%' |
| console_information_schema_view |
sql_ddl |
TEXT |
/console/info-schema/view.sql?name=console_information_schema_view&stats=yes |
[Content](console/info-schema/view.sql?name=console_information_schema_view&stats=yes) |
[console_information_schema_view (view) Schema](console/info-schema/view.sql?name=console_information_schema_view&stats=yes) |
/console/content/view/console_information_schema_view.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/console_information_schema_view.sql?stats=yes) |
[console_information_schema_view (view) Content](console/content/view/console_information_schema_view.sql?stats=yes) |
CREATE VIEW console_information_schema_view AS
SELECT
vw.name AS view_name,
col.name AS column_name,
col.type AS data_type,
'/console/info-schema/view.sql?name=' || vw.name || '&stats=yes' as info_schema_web_ui_path,
'[Content](console/info-schema/view.sql?name=' || vw.name || '&stats=yes)' as info_schema_link_abbrev_md,
'[' || vw.name || ' (view) Schema](console/info-schema/view.sql?name=' || vw.name || '&stats=yes)' as info_schema_link_full_md,
'/console/content/view/' || vw.name || '.sql?stats=yes' as content_web_ui_path,
'[Content]($SITE_PREFIX_URL/console/content/view/' || vw.name || '.sql?stats=yes)' as content_web_ui_link_abbrev_md,
'[' || vw.name || ' (view) Content](console/content/view/' || vw.name || '.sql?stats=yes)' as content_web_ui_link_full_md,
vw.sql as sql_ddl
FROM sqlite_master vw
JOIN pragma_table_info(vw.name) col
WHERE vw.type = 'view' AND vw.name NOT LIKE 'sqlite_%' |
| console_content_tabular |
tabular_nature |
|
/console/info-schema/view.sql?name=console_content_tabular&stats=yes |
[Content](console/info-schema/view.sql?name=console_content_tabular&stats=yes) |
[console_content_tabular (view) Schema](console/info-schema/view.sql?name=console_content_tabular&stats=yes) |
/console/content/view/console_content_tabular.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/console_content_tabular.sql?stats=yes) |
[console_content_tabular (view) Content](console/content/view/console_content_tabular.sql?stats=yes) |
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 |
| console_content_tabular |
tabular_name |
TEXT |
/console/info-schema/view.sql?name=console_content_tabular&stats=yes |
[Content](console/info-schema/view.sql?name=console_content_tabular&stats=yes) |
[console_content_tabular (view) Schema](console/info-schema/view.sql?name=console_content_tabular&stats=yes) |
/console/content/view/console_content_tabular.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/console_content_tabular.sql?stats=yes) |
[console_content_tabular (view) Content](console/content/view/console_content_tabular.sql?stats=yes) |
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 |
| console_content_tabular |
info_schema_web_ui_path |
|
/console/info-schema/view.sql?name=console_content_tabular&stats=yes |
[Content](console/info-schema/view.sql?name=console_content_tabular&stats=yes) |
[console_content_tabular (view) Schema](console/info-schema/view.sql?name=console_content_tabular&stats=yes) |
/console/content/view/console_content_tabular.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/console_content_tabular.sql?stats=yes) |
[console_content_tabular (view) Content](console/content/view/console_content_tabular.sql?stats=yes) |
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 |
| console_content_tabular |
info_schema_link_abbrev_md |
|
/console/info-schema/view.sql?name=console_content_tabular&stats=yes |
[Content](console/info-schema/view.sql?name=console_content_tabular&stats=yes) |
[console_content_tabular (view) Schema](console/info-schema/view.sql?name=console_content_tabular&stats=yes) |
/console/content/view/console_content_tabular.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/console_content_tabular.sql?stats=yes) |
[console_content_tabular (view) Content](console/content/view/console_content_tabular.sql?stats=yes) |
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 |
| console_content_tabular |
info_schema_link_full_md |
|
/console/info-schema/view.sql?name=console_content_tabular&stats=yes |
[Content](console/info-schema/view.sql?name=console_content_tabular&stats=yes) |
[console_content_tabular (view) Schema](console/info-schema/view.sql?name=console_content_tabular&stats=yes) |
/console/content/view/console_content_tabular.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/console_content_tabular.sql?stats=yes) |
[console_content_tabular (view) Content](console/content/view/console_content_tabular.sql?stats=yes) |
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 |
| console_content_tabular |
content_web_ui_path |
|
/console/info-schema/view.sql?name=console_content_tabular&stats=yes |
[Content](console/info-schema/view.sql?name=console_content_tabular&stats=yes) |
[console_content_tabular (view) Schema](console/info-schema/view.sql?name=console_content_tabular&stats=yes) |
/console/content/view/console_content_tabular.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/console_content_tabular.sql?stats=yes) |
[console_content_tabular (view) Content](console/content/view/console_content_tabular.sql?stats=yes) |
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 |
| console_content_tabular |
content_web_ui_link_abbrev_md |
|
/console/info-schema/view.sql?name=console_content_tabular&stats=yes |
[Content](console/info-schema/view.sql?name=console_content_tabular&stats=yes) |
[console_content_tabular (view) Schema](console/info-schema/view.sql?name=console_content_tabular&stats=yes) |
/console/content/view/console_content_tabular.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/console_content_tabular.sql?stats=yes) |
[console_content_tabular (view) Content](console/content/view/console_content_tabular.sql?stats=yes) |
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 |
| console_content_tabular |
content_web_ui_link_full_md |
|
/console/info-schema/view.sql?name=console_content_tabular&stats=yes |
[Content](console/info-schema/view.sql?name=console_content_tabular&stats=yes) |
[console_content_tabular (view) Schema](console/info-schema/view.sql?name=console_content_tabular&stats=yes) |
/console/content/view/console_content_tabular.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/console_content_tabular.sql?stats=yes) |
[console_content_tabular (view) Content](console/content/view/console_content_tabular.sql?stats=yes) |
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 |
| console_information_schema_table_col_fkey |
table_name |
TEXT |
/console/info-schema/view.sql?name=console_information_schema_table_col_fkey&stats=yes |
[Content](console/info-schema/view.sql?name=console_information_schema_table_col_fkey&stats=yes) |
[console_information_schema_table_col_fkey (view) Schema](console/info-schema/view.sql?name=console_information_schema_table_col_fkey&stats=yes) |
/console/content/view/console_information_schema_table_col_fkey.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/console_information_schema_table_col_fkey.sql?stats=yes) |
[console_information_schema_table_col_fkey (view) Content](console/content/view/console_information_schema_table_col_fkey.sql?stats=yes) |
CREATE VIEW console_information_schema_table_col_fkey AS
SELECT
tbl.name AS table_name,
f."from" AS column_name,
f."from" || ' references ' || f."table" || '.' || f."to" AS foreign_key
FROM sqlite_master tbl
JOIN pragma_foreign_key_list(tbl.name) f
WHERE tbl.type = 'table' AND tbl.name NOT LIKE 'sqlite_%' |
| console_information_schema_table_col_fkey |
column_name |
BLOB |
/console/info-schema/view.sql?name=console_information_schema_table_col_fkey&stats=yes |
[Content](console/info-schema/view.sql?name=console_information_schema_table_col_fkey&stats=yes) |
[console_information_schema_table_col_fkey (view) Schema](console/info-schema/view.sql?name=console_information_schema_table_col_fkey&stats=yes) |
/console/content/view/console_information_schema_table_col_fkey.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/console_information_schema_table_col_fkey.sql?stats=yes) |
[console_information_schema_table_col_fkey (view) Content](console/content/view/console_information_schema_table_col_fkey.sql?stats=yes) |
CREATE VIEW console_information_schema_table_col_fkey AS
SELECT
tbl.name AS table_name,
f."from" AS column_name,
f."from" || ' references ' || f."table" || '.' || f."to" AS foreign_key
FROM sqlite_master tbl
JOIN pragma_foreign_key_list(tbl.name) f
WHERE tbl.type = 'table' AND tbl.name NOT LIKE 'sqlite_%' |
| console_information_schema_table_col_fkey |
foreign_key |
|
/console/info-schema/view.sql?name=console_information_schema_table_col_fkey&stats=yes |
[Content](console/info-schema/view.sql?name=console_information_schema_table_col_fkey&stats=yes) |
[console_information_schema_table_col_fkey (view) Schema](console/info-schema/view.sql?name=console_information_schema_table_col_fkey&stats=yes) |
/console/content/view/console_information_schema_table_col_fkey.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/console_information_schema_table_col_fkey.sql?stats=yes) |
[console_information_schema_table_col_fkey (view) Content](console/content/view/console_information_schema_table_col_fkey.sql?stats=yes) |
CREATE VIEW console_information_schema_table_col_fkey AS
SELECT
tbl.name AS table_name,
f."from" AS column_name,
f."from" || ' references ' || f."table" || '.' || f."to" AS foreign_key
FROM sqlite_master tbl
JOIN pragma_foreign_key_list(tbl.name) f
WHERE tbl.type = 'table' AND tbl.name NOT LIKE 'sqlite_%' |
| console_information_schema_table_col_index |
table_name |
TEXT |
/console/info-schema/view.sql?name=console_information_schema_table_col_index&stats=yes |
[Content](console/info-schema/view.sql?name=console_information_schema_table_col_index&stats=yes) |
[console_information_schema_table_col_index (view) Schema](console/info-schema/view.sql?name=console_information_schema_table_col_index&stats=yes) |
/console/content/view/console_information_schema_table_col_index.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/console_information_schema_table_col_index.sql?stats=yes) |
[console_information_schema_table_col_index (view) Content](console/content/view/console_information_schema_table_col_index.sql?stats=yes) |
CREATE VIEW console_information_schema_table_col_index AS
SELECT
tbl.name AS table_name,
pi.name AS column_name,
idx.name AS index_name
FROM sqlite_master tbl
JOIN pragma_index_list(tbl.name) idx
JOIN pragma_index_info(idx.name) pi
WHERE tbl.type = 'table' AND tbl.name NOT LIKE 'sqlite_%' |
| console_information_schema_table_col_index |
column_name |
BLOB |
/console/info-schema/view.sql?name=console_information_schema_table_col_index&stats=yes |
[Content](console/info-schema/view.sql?name=console_information_schema_table_col_index&stats=yes) |
[console_information_schema_table_col_index (view) Schema](console/info-schema/view.sql?name=console_information_schema_table_col_index&stats=yes) |
/console/content/view/console_information_schema_table_col_index.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/console_information_schema_table_col_index.sql?stats=yes) |
[console_information_schema_table_col_index (view) Content](console/content/view/console_information_schema_table_col_index.sql?stats=yes) |
CREATE VIEW console_information_schema_table_col_index AS
SELECT
tbl.name AS table_name,
pi.name AS column_name,
idx.name AS index_name
FROM sqlite_master tbl
JOIN pragma_index_list(tbl.name) idx
JOIN pragma_index_info(idx.name) pi
WHERE tbl.type = 'table' AND tbl.name NOT LIKE 'sqlite_%' |
| console_information_schema_table_col_index |
index_name |
BLOB |
/console/info-schema/view.sql?name=console_information_schema_table_col_index&stats=yes |
[Content](console/info-schema/view.sql?name=console_information_schema_table_col_index&stats=yes) |
[console_information_schema_table_col_index (view) Schema](console/info-schema/view.sql?name=console_information_schema_table_col_index&stats=yes) |
/console/content/view/console_information_schema_table_col_index.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/console_information_schema_table_col_index.sql?stats=yes) |
[console_information_schema_table_col_index (view) Content](console/content/view/console_information_schema_table_col_index.sql?stats=yes) |
CREATE VIEW console_information_schema_table_col_index AS
SELECT
tbl.name AS table_name,
pi.name AS column_name,
idx.name AS index_name
FROM sqlite_master tbl
JOIN pragma_index_list(tbl.name) idx
JOIN pragma_index_info(idx.name) pi
WHERE tbl.type = 'table' AND tbl.name NOT LIKE 'sqlite_%' |
| rssd_statistics_overview |
db_size_mb |
|
/console/info-schema/view.sql?name=rssd_statistics_overview&stats=yes |
[Content](console/info-schema/view.sql?name=rssd_statistics_overview&stats=yes) |
[rssd_statistics_overview (view) Schema](console/info-schema/view.sql?name=rssd_statistics_overview&stats=yes) |
/console/content/view/rssd_statistics_overview.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/rssd_statistics_overview.sql?stats=yes) |
[rssd_statistics_overview (view) Content](console/content/view/rssd_statistics_overview.sql?stats=yes) |
CREATE VIEW rssd_statistics_overview AS
SELECT
(SELECT ROUND(page_count * page_size / (1024.0 * 1024), 2) FROM pragma_page_count(), pragma_page_size()) AS db_size_mb,
(SELECT ROUND(page_count * page_size / (1024.0 * 1024 * 1024), 4) FROM pragma_page_count(), pragma_page_size()) AS db_size_gb,
(SELECT COUNT(*) FROM sqlite_master WHERE type = 'table') AS total_tables,
(SELECT COUNT(*) FROM sqlite_master WHERE type = 'index') AS total_indexes,
(SELECT SUM(tbl_rows) FROM (
SELECT name,
(SELECT COUNT(*) FROM sqlite_master sm WHERE sm.type='table' AND sm.name=t.name) AS tbl_rows
FROM sqlite_master t WHERE type='table'
)) AS total_rows,
(SELECT page_size FROM pragma_page_size()) AS page_size,
(SELECT page_count FROM pragma_page_count()) AS total_pages |
| rssd_statistics_overview |
db_size_gb |
|
/console/info-schema/view.sql?name=rssd_statistics_overview&stats=yes |
[Content](console/info-schema/view.sql?name=rssd_statistics_overview&stats=yes) |
[rssd_statistics_overview (view) Schema](console/info-schema/view.sql?name=rssd_statistics_overview&stats=yes) |
/console/content/view/rssd_statistics_overview.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/rssd_statistics_overview.sql?stats=yes) |
[rssd_statistics_overview (view) Content](console/content/view/rssd_statistics_overview.sql?stats=yes) |
CREATE VIEW rssd_statistics_overview AS
SELECT
(SELECT ROUND(page_count * page_size / (1024.0 * 1024), 2) FROM pragma_page_count(), pragma_page_size()) AS db_size_mb,
(SELECT ROUND(page_count * page_size / (1024.0 * 1024 * 1024), 4) FROM pragma_page_count(), pragma_page_size()) AS db_size_gb,
(SELECT COUNT(*) FROM sqlite_master WHERE type = 'table') AS total_tables,
(SELECT COUNT(*) FROM sqlite_master WHERE type = 'index') AS total_indexes,
(SELECT SUM(tbl_rows) FROM (
SELECT name,
(SELECT COUNT(*) FROM sqlite_master sm WHERE sm.type='table' AND sm.name=t.name) AS tbl_rows
FROM sqlite_master t WHERE type='table'
)) AS total_rows,
(SELECT page_size FROM pragma_page_size()) AS page_size,
(SELECT page_count FROM pragma_page_count()) AS total_pages |
| rssd_statistics_overview |
total_tables |
|
/console/info-schema/view.sql?name=rssd_statistics_overview&stats=yes |
[Content](console/info-schema/view.sql?name=rssd_statistics_overview&stats=yes) |
[rssd_statistics_overview (view) Schema](console/info-schema/view.sql?name=rssd_statistics_overview&stats=yes) |
/console/content/view/rssd_statistics_overview.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/rssd_statistics_overview.sql?stats=yes) |
[rssd_statistics_overview (view) Content](console/content/view/rssd_statistics_overview.sql?stats=yes) |
CREATE VIEW rssd_statistics_overview AS
SELECT
(SELECT ROUND(page_count * page_size / (1024.0 * 1024), 2) FROM pragma_page_count(), pragma_page_size()) AS db_size_mb,
(SELECT ROUND(page_count * page_size / (1024.0 * 1024 * 1024), 4) FROM pragma_page_count(), pragma_page_size()) AS db_size_gb,
(SELECT COUNT(*) FROM sqlite_master WHERE type = 'table') AS total_tables,
(SELECT COUNT(*) FROM sqlite_master WHERE type = 'index') AS total_indexes,
(SELECT SUM(tbl_rows) FROM (
SELECT name,
(SELECT COUNT(*) FROM sqlite_master sm WHERE sm.type='table' AND sm.name=t.name) AS tbl_rows
FROM sqlite_master t WHERE type='table'
)) AS total_rows,
(SELECT page_size FROM pragma_page_size()) AS page_size,
(SELECT page_count FROM pragma_page_count()) AS total_pages |
| rssd_statistics_overview |
total_indexes |
|
/console/info-schema/view.sql?name=rssd_statistics_overview&stats=yes |
[Content](console/info-schema/view.sql?name=rssd_statistics_overview&stats=yes) |
[rssd_statistics_overview (view) Schema](console/info-schema/view.sql?name=rssd_statistics_overview&stats=yes) |
/console/content/view/rssd_statistics_overview.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/rssd_statistics_overview.sql?stats=yes) |
[rssd_statistics_overview (view) Content](console/content/view/rssd_statistics_overview.sql?stats=yes) |
CREATE VIEW rssd_statistics_overview AS
SELECT
(SELECT ROUND(page_count * page_size / (1024.0 * 1024), 2) FROM pragma_page_count(), pragma_page_size()) AS db_size_mb,
(SELECT ROUND(page_count * page_size / (1024.0 * 1024 * 1024), 4) FROM pragma_page_count(), pragma_page_size()) AS db_size_gb,
(SELECT COUNT(*) FROM sqlite_master WHERE type = 'table') AS total_tables,
(SELECT COUNT(*) FROM sqlite_master WHERE type = 'index') AS total_indexes,
(SELECT SUM(tbl_rows) FROM (
SELECT name,
(SELECT COUNT(*) FROM sqlite_master sm WHERE sm.type='table' AND sm.name=t.name) AS tbl_rows
FROM sqlite_master t WHERE type='table'
)) AS total_rows,
(SELECT page_size FROM pragma_page_size()) AS page_size,
(SELECT page_count FROM pragma_page_count()) AS total_pages |
| rssd_statistics_overview |
total_rows |
|
/console/info-schema/view.sql?name=rssd_statistics_overview&stats=yes |
[Content](console/info-schema/view.sql?name=rssd_statistics_overview&stats=yes) |
[rssd_statistics_overview (view) Schema](console/info-schema/view.sql?name=rssd_statistics_overview&stats=yes) |
/console/content/view/rssd_statistics_overview.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/rssd_statistics_overview.sql?stats=yes) |
[rssd_statistics_overview (view) Content](console/content/view/rssd_statistics_overview.sql?stats=yes) |
CREATE VIEW rssd_statistics_overview AS
SELECT
(SELECT ROUND(page_count * page_size / (1024.0 * 1024), 2) FROM pragma_page_count(), pragma_page_size()) AS db_size_mb,
(SELECT ROUND(page_count * page_size / (1024.0 * 1024 * 1024), 4) FROM pragma_page_count(), pragma_page_size()) AS db_size_gb,
(SELECT COUNT(*) FROM sqlite_master WHERE type = 'table') AS total_tables,
(SELECT COUNT(*) FROM sqlite_master WHERE type = 'index') AS total_indexes,
(SELECT SUM(tbl_rows) FROM (
SELECT name,
(SELECT COUNT(*) FROM sqlite_master sm WHERE sm.type='table' AND sm.name=t.name) AS tbl_rows
FROM sqlite_master t WHERE type='table'
)) AS total_rows,
(SELECT page_size FROM pragma_page_size()) AS page_size,
(SELECT page_count FROM pragma_page_count()) AS total_pages |
| rssd_statistics_overview |
page_size |
BLOB |
/console/info-schema/view.sql?name=rssd_statistics_overview&stats=yes |
[Content](console/info-schema/view.sql?name=rssd_statistics_overview&stats=yes) |
[rssd_statistics_overview (view) Schema](console/info-schema/view.sql?name=rssd_statistics_overview&stats=yes) |
/console/content/view/rssd_statistics_overview.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/rssd_statistics_overview.sql?stats=yes) |
[rssd_statistics_overview (view) Content](console/content/view/rssd_statistics_overview.sql?stats=yes) |
CREATE VIEW rssd_statistics_overview AS
SELECT
(SELECT ROUND(page_count * page_size / (1024.0 * 1024), 2) FROM pragma_page_count(), pragma_page_size()) AS db_size_mb,
(SELECT ROUND(page_count * page_size / (1024.0 * 1024 * 1024), 4) FROM pragma_page_count(), pragma_page_size()) AS db_size_gb,
(SELECT COUNT(*) FROM sqlite_master WHERE type = 'table') AS total_tables,
(SELECT COUNT(*) FROM sqlite_master WHERE type = 'index') AS total_indexes,
(SELECT SUM(tbl_rows) FROM (
SELECT name,
(SELECT COUNT(*) FROM sqlite_master sm WHERE sm.type='table' AND sm.name=t.name) AS tbl_rows
FROM sqlite_master t WHERE type='table'
)) AS total_rows,
(SELECT page_size FROM pragma_page_size()) AS page_size,
(SELECT page_count FROM pragma_page_count()) AS total_pages |
| rssd_statistics_overview |
total_pages |
BLOB |
/console/info-schema/view.sql?name=rssd_statistics_overview&stats=yes |
[Content](console/info-schema/view.sql?name=rssd_statistics_overview&stats=yes) |
[rssd_statistics_overview (view) Schema](console/info-schema/view.sql?name=rssd_statistics_overview&stats=yes) |
/console/content/view/rssd_statistics_overview.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/rssd_statistics_overview.sql?stats=yes) |
[rssd_statistics_overview (view) Content](console/content/view/rssd_statistics_overview.sql?stats=yes) |
CREATE VIEW rssd_statistics_overview AS
SELECT
(SELECT ROUND(page_count * page_size / (1024.0 * 1024), 2) FROM pragma_page_count(), pragma_page_size()) AS db_size_mb,
(SELECT ROUND(page_count * page_size / (1024.0 * 1024 * 1024), 4) FROM pragma_page_count(), pragma_page_size()) AS db_size_gb,
(SELECT COUNT(*) FROM sqlite_master WHERE type = 'table') AS total_tables,
(SELECT COUNT(*) FROM sqlite_master WHERE type = 'index') AS total_indexes,
(SELECT SUM(tbl_rows) FROM (
SELECT name,
(SELECT COUNT(*) FROM sqlite_master sm WHERE sm.type='table' AND sm.name=t.name) AS tbl_rows
FROM sqlite_master t WHERE type='table'
)) AS total_rows,
(SELECT page_size FROM pragma_page_size()) AS page_size,
(SELECT page_count FROM pragma_page_count()) AS total_pages |
| rssd_table_statistic |
table_name |
TEXT |
/console/info-schema/view.sql?name=rssd_table_statistic&stats=yes |
[Content](console/info-schema/view.sql?name=rssd_table_statistic&stats=yes) |
[rssd_table_statistic (view) Schema](console/info-schema/view.sql?name=rssd_table_statistic&stats=yes) |
/console/content/view/rssd_table_statistic.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/rssd_table_statistic.sql?stats=yes) |
[rssd_table_statistic (view) Content](console/content/view/rssd_table_statistic.sql?stats=yes) |
CREATE VIEW rssd_table_statistic AS
SELECT
m.name AS table_name,
(SELECT COUNT(*) FROM pragma_table_info(m.name)) AS total_columns,
(SELECT COUNT(*) FROM pragma_index_list(m.name)) AS total_indexes,
(SELECT COUNT(*) FROM pragma_foreign_key_list(m.name)) AS foreign_keys,
(SELECT COUNT(*) FROM pragma_table_info(m.name) WHERE pk != 0) AS primary_keys,
(SELECT table_size_mb FROM surveilr_table_size WHERE table_name = m.name) AS table_size_mb
FROM sqlite_master m
WHERE m.type = 'table' |
| rssd_table_statistic |
total_columns |
|
/console/info-schema/view.sql?name=rssd_table_statistic&stats=yes |
[Content](console/info-schema/view.sql?name=rssd_table_statistic&stats=yes) |
[rssd_table_statistic (view) Schema](console/info-schema/view.sql?name=rssd_table_statistic&stats=yes) |
/console/content/view/rssd_table_statistic.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/rssd_table_statistic.sql?stats=yes) |
[rssd_table_statistic (view) Content](console/content/view/rssd_table_statistic.sql?stats=yes) |
CREATE VIEW rssd_table_statistic AS
SELECT
m.name AS table_name,
(SELECT COUNT(*) FROM pragma_table_info(m.name)) AS total_columns,
(SELECT COUNT(*) FROM pragma_index_list(m.name)) AS total_indexes,
(SELECT COUNT(*) FROM pragma_foreign_key_list(m.name)) AS foreign_keys,
(SELECT COUNT(*) FROM pragma_table_info(m.name) WHERE pk != 0) AS primary_keys,
(SELECT table_size_mb FROM surveilr_table_size WHERE table_name = m.name) AS table_size_mb
FROM sqlite_master m
WHERE m.type = 'table' |
| rssd_table_statistic |
total_indexes |
|
/console/info-schema/view.sql?name=rssd_table_statistic&stats=yes |
[Content](console/info-schema/view.sql?name=rssd_table_statistic&stats=yes) |
[rssd_table_statistic (view) Schema](console/info-schema/view.sql?name=rssd_table_statistic&stats=yes) |
/console/content/view/rssd_table_statistic.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/rssd_table_statistic.sql?stats=yes) |
[rssd_table_statistic (view) Content](console/content/view/rssd_table_statistic.sql?stats=yes) |
CREATE VIEW rssd_table_statistic AS
SELECT
m.name AS table_name,
(SELECT COUNT(*) FROM pragma_table_info(m.name)) AS total_columns,
(SELECT COUNT(*) FROM pragma_index_list(m.name)) AS total_indexes,
(SELECT COUNT(*) FROM pragma_foreign_key_list(m.name)) AS foreign_keys,
(SELECT COUNT(*) FROM pragma_table_info(m.name) WHERE pk != 0) AS primary_keys,
(SELECT table_size_mb FROM surveilr_table_size WHERE table_name = m.name) AS table_size_mb
FROM sqlite_master m
WHERE m.type = 'table' |
| rssd_table_statistic |
foreign_keys |
|
/console/info-schema/view.sql?name=rssd_table_statistic&stats=yes |
[Content](console/info-schema/view.sql?name=rssd_table_statistic&stats=yes) |
[rssd_table_statistic (view) Schema](console/info-schema/view.sql?name=rssd_table_statistic&stats=yes) |
/console/content/view/rssd_table_statistic.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/rssd_table_statistic.sql?stats=yes) |
[rssd_table_statistic (view) Content](console/content/view/rssd_table_statistic.sql?stats=yes) |
CREATE VIEW rssd_table_statistic AS
SELECT
m.name AS table_name,
(SELECT COUNT(*) FROM pragma_table_info(m.name)) AS total_columns,
(SELECT COUNT(*) FROM pragma_index_list(m.name)) AS total_indexes,
(SELECT COUNT(*) FROM pragma_foreign_key_list(m.name)) AS foreign_keys,
(SELECT COUNT(*) FROM pragma_table_info(m.name) WHERE pk != 0) AS primary_keys,
(SELECT table_size_mb FROM surveilr_table_size WHERE table_name = m.name) AS table_size_mb
FROM sqlite_master m
WHERE m.type = 'table' |
| rssd_table_statistic |
primary_keys |
|
/console/info-schema/view.sql?name=rssd_table_statistic&stats=yes |
[Content](console/info-schema/view.sql?name=rssd_table_statistic&stats=yes) |
[rssd_table_statistic (view) Schema](console/info-schema/view.sql?name=rssd_table_statistic&stats=yes) |
/console/content/view/rssd_table_statistic.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/rssd_table_statistic.sql?stats=yes) |
[rssd_table_statistic (view) Content](console/content/view/rssd_table_statistic.sql?stats=yes) |
CREATE VIEW rssd_table_statistic AS
SELECT
m.name AS table_name,
(SELECT COUNT(*) FROM pragma_table_info(m.name)) AS total_columns,
(SELECT COUNT(*) FROM pragma_index_list(m.name)) AS total_indexes,
(SELECT COUNT(*) FROM pragma_foreign_key_list(m.name)) AS foreign_keys,
(SELECT COUNT(*) FROM pragma_table_info(m.name) WHERE pk != 0) AS primary_keys,
(SELECT table_size_mb FROM surveilr_table_size WHERE table_name = m.name) AS table_size_mb
FROM sqlite_master m
WHERE m.type = 'table' |
| rssd_table_statistic |
table_size_mb |
REAL |
/console/info-schema/view.sql?name=rssd_table_statistic&stats=yes |
[Content](console/info-schema/view.sql?name=rssd_table_statistic&stats=yes) |
[rssd_table_statistic (view) Schema](console/info-schema/view.sql?name=rssd_table_statistic&stats=yes) |
/console/content/view/rssd_table_statistic.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/rssd_table_statistic.sql?stats=yes) |
[rssd_table_statistic (view) Content](console/content/view/rssd_table_statistic.sql?stats=yes) |
CREATE VIEW rssd_table_statistic AS
SELECT
m.name AS table_name,
(SELECT COUNT(*) FROM pragma_table_info(m.name)) AS total_columns,
(SELECT COUNT(*) FROM pragma_index_list(m.name)) AS total_indexes,
(SELECT COUNT(*) FROM pragma_foreign_key_list(m.name)) AS foreign_keys,
(SELECT COUNT(*) FROM pragma_table_info(m.name) WHERE pk != 0) AS primary_keys,
(SELECT table_size_mb FROM surveilr_table_size WHERE table_name = m.name) AS table_size_mb
FROM sqlite_master m
WHERE m.type = 'table' |
| uniform_resource_file |
uniform_resource_id |
VARCHAR |
/console/info-schema/view.sql?name=uniform_resource_file&stats=yes |
[Content](console/info-schema/view.sql?name=uniform_resource_file&stats=yes) |
[uniform_resource_file (view) Schema](console/info-schema/view.sql?name=uniform_resource_file&stats=yes) |
/console/content/view/uniform_resource_file.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/uniform_resource_file.sql?stats=yes) |
[uniform_resource_file (view) Content](console/content/view/uniform_resource_file.sql?stats=yes) |
CREATE VIEW uniform_resource_file AS
SELECT ur.uniform_resource_id,
ur.nature,
p.root_path AS source_path,
pe.file_path_rel,
ur.size_bytes
FROM uniform_resource ur
LEFT JOIN uniform_resource_edge ure ON ur.uniform_resource_id = ure.uniform_resource_id AND ure.nature = 'ingest_fs_path'
LEFT JOIN ur_ingest_session_fs_path p ON ure.node_id = p.ur_ingest_session_fs_path_id
LEFT JOIN ur_ingest_session_fs_path_entry pe ON ur.uniform_resource_id = pe.uniform_resource_id |
| uniform_resource_file |
nature |
TEXT |
/console/info-schema/view.sql?name=uniform_resource_file&stats=yes |
[Content](console/info-schema/view.sql?name=uniform_resource_file&stats=yes) |
[uniform_resource_file (view) Schema](console/info-schema/view.sql?name=uniform_resource_file&stats=yes) |
/console/content/view/uniform_resource_file.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/uniform_resource_file.sql?stats=yes) |
[uniform_resource_file (view) Content](console/content/view/uniform_resource_file.sql?stats=yes) |
CREATE VIEW uniform_resource_file AS
SELECT ur.uniform_resource_id,
ur.nature,
p.root_path AS source_path,
pe.file_path_rel,
ur.size_bytes
FROM uniform_resource ur
LEFT JOIN uniform_resource_edge ure ON ur.uniform_resource_id = ure.uniform_resource_id AND ure.nature = 'ingest_fs_path'
LEFT JOIN ur_ingest_session_fs_path p ON ure.node_id = p.ur_ingest_session_fs_path_id
LEFT JOIN ur_ingest_session_fs_path_entry pe ON ur.uniform_resource_id = pe.uniform_resource_id |
| uniform_resource_file |
source_path |
TEXT |
/console/info-schema/view.sql?name=uniform_resource_file&stats=yes |
[Content](console/info-schema/view.sql?name=uniform_resource_file&stats=yes) |
[uniform_resource_file (view) Schema](console/info-schema/view.sql?name=uniform_resource_file&stats=yes) |
/console/content/view/uniform_resource_file.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/uniform_resource_file.sql?stats=yes) |
[uniform_resource_file (view) Content](console/content/view/uniform_resource_file.sql?stats=yes) |
CREATE VIEW uniform_resource_file AS
SELECT ur.uniform_resource_id,
ur.nature,
p.root_path AS source_path,
pe.file_path_rel,
ur.size_bytes
FROM uniform_resource ur
LEFT JOIN uniform_resource_edge ure ON ur.uniform_resource_id = ure.uniform_resource_id AND ure.nature = 'ingest_fs_path'
LEFT JOIN ur_ingest_session_fs_path p ON ure.node_id = p.ur_ingest_session_fs_path_id
LEFT JOIN ur_ingest_session_fs_path_entry pe ON ur.uniform_resource_id = pe.uniform_resource_id |
| uniform_resource_file |
file_path_rel |
TEXT |
/console/info-schema/view.sql?name=uniform_resource_file&stats=yes |
[Content](console/info-schema/view.sql?name=uniform_resource_file&stats=yes) |
[uniform_resource_file (view) Schema](console/info-schema/view.sql?name=uniform_resource_file&stats=yes) |
/console/content/view/uniform_resource_file.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/uniform_resource_file.sql?stats=yes) |
[uniform_resource_file (view) Content](console/content/view/uniform_resource_file.sql?stats=yes) |
CREATE VIEW uniform_resource_file AS
SELECT ur.uniform_resource_id,
ur.nature,
p.root_path AS source_path,
pe.file_path_rel,
ur.size_bytes
FROM uniform_resource ur
LEFT JOIN uniform_resource_edge ure ON ur.uniform_resource_id = ure.uniform_resource_id AND ure.nature = 'ingest_fs_path'
LEFT JOIN ur_ingest_session_fs_path p ON ure.node_id = p.ur_ingest_session_fs_path_id
LEFT JOIN ur_ingest_session_fs_path_entry pe ON ur.uniform_resource_id = pe.uniform_resource_id |
| uniform_resource_file |
size_bytes |
INTEGER |
/console/info-schema/view.sql?name=uniform_resource_file&stats=yes |
[Content](console/info-schema/view.sql?name=uniform_resource_file&stats=yes) |
[uniform_resource_file (view) Schema](console/info-schema/view.sql?name=uniform_resource_file&stats=yes) |
/console/content/view/uniform_resource_file.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/uniform_resource_file.sql?stats=yes) |
[uniform_resource_file (view) Content](console/content/view/uniform_resource_file.sql?stats=yes) |
CREATE VIEW uniform_resource_file AS
SELECT ur.uniform_resource_id,
ur.nature,
p.root_path AS source_path,
pe.file_path_rel,
ur.size_bytes
FROM uniform_resource ur
LEFT JOIN uniform_resource_edge ure ON ur.uniform_resource_id = ure.uniform_resource_id AND ure.nature = 'ingest_fs_path'
LEFT JOIN ur_ingest_session_fs_path p ON ure.node_id = p.ur_ingest_session_fs_path_id
LEFT JOIN ur_ingest_session_fs_path_entry pe ON ur.uniform_resource_id = pe.uniform_resource_id |
| uniform_resource_imap |
uniform_resource_id |
VARCHAR |
/console/info-schema/view.sql?name=uniform_resource_imap&stats=yes |
[Content](console/info-schema/view.sql?name=uniform_resource_imap&stats=yes) |
[uniform_resource_imap (view) Schema](console/info-schema/view.sql?name=uniform_resource_imap&stats=yes) |
/console/content/view/uniform_resource_imap.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/uniform_resource_imap.sql?stats=yes) |
[uniform_resource_imap (view) Content](console/content/view/uniform_resource_imap.sql?stats=yes) |
CREATE VIEW uniform_resource_imap AS
SELECT
ur.uniform_resource_id,
graph.name,
iac.ur_ingest_session_imap_account_id,
iac.email,
iac.host,
iacm.subject,
iacm."from",
iacm.message,
iacm.date,
iaf.ur_ingest_session_imap_acct_folder_id,
iaf.ingest_account_id,
iaf.folder_name,
ur.size_bytes,
ur.nature,
ur.content
FROM uniform_resource ur
INNER JOIN uniform_resource_edge edge ON edge.uniform_resource_id=ur.uniform_resource_id
INNER JOIN uniform_resource_graph graph ON graph.name=edge.graph_name
INNER JOIN ur_ingest_session_imap_acct_folder_message iacm ON iacm.ur_ingest_session_imap_acct_folder_message_id = edge.node_id
INNER JOIN ur_ingest_session_imap_acct_folder iaf ON iacm.ingest_imap_acct_folder_id = iaf.ur_ingest_session_imap_acct_folder_id
LEFT JOIN ur_ingest_session_imap_account iac ON iac.ur_ingest_session_imap_account_id = iaf.ingest_account_id
WHERE ur.nature = 'text' AND graph.name='imap' AND ur.ingest_session_imap_acct_folder_message IS NOT NULL |
| uniform_resource_imap |
name |
VARCHAR |
/console/info-schema/view.sql?name=uniform_resource_imap&stats=yes |
[Content](console/info-schema/view.sql?name=uniform_resource_imap&stats=yes) |
[uniform_resource_imap (view) Schema](console/info-schema/view.sql?name=uniform_resource_imap&stats=yes) |
/console/content/view/uniform_resource_imap.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/uniform_resource_imap.sql?stats=yes) |
[uniform_resource_imap (view) Content](console/content/view/uniform_resource_imap.sql?stats=yes) |
CREATE VIEW uniform_resource_imap AS
SELECT
ur.uniform_resource_id,
graph.name,
iac.ur_ingest_session_imap_account_id,
iac.email,
iac.host,
iacm.subject,
iacm."from",
iacm.message,
iacm.date,
iaf.ur_ingest_session_imap_acct_folder_id,
iaf.ingest_account_id,
iaf.folder_name,
ur.size_bytes,
ur.nature,
ur.content
FROM uniform_resource ur
INNER JOIN uniform_resource_edge edge ON edge.uniform_resource_id=ur.uniform_resource_id
INNER JOIN uniform_resource_graph graph ON graph.name=edge.graph_name
INNER JOIN ur_ingest_session_imap_acct_folder_message iacm ON iacm.ur_ingest_session_imap_acct_folder_message_id = edge.node_id
INNER JOIN ur_ingest_session_imap_acct_folder iaf ON iacm.ingest_imap_acct_folder_id = iaf.ur_ingest_session_imap_acct_folder_id
LEFT JOIN ur_ingest_session_imap_account iac ON iac.ur_ingest_session_imap_account_id = iaf.ingest_account_id
WHERE ur.nature = 'text' AND graph.name='imap' AND ur.ingest_session_imap_acct_folder_message IS NOT NULL |
| uniform_resource_imap |
ur_ingest_session_imap_account_id |
VARCHAR |
/console/info-schema/view.sql?name=uniform_resource_imap&stats=yes |
[Content](console/info-schema/view.sql?name=uniform_resource_imap&stats=yes) |
[uniform_resource_imap (view) Schema](console/info-schema/view.sql?name=uniform_resource_imap&stats=yes) |
/console/content/view/uniform_resource_imap.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/uniform_resource_imap.sql?stats=yes) |
[uniform_resource_imap (view) Content](console/content/view/uniform_resource_imap.sql?stats=yes) |
CREATE VIEW uniform_resource_imap AS
SELECT
ur.uniform_resource_id,
graph.name,
iac.ur_ingest_session_imap_account_id,
iac.email,
iac.host,
iacm.subject,
iacm."from",
iacm.message,
iacm.date,
iaf.ur_ingest_session_imap_acct_folder_id,
iaf.ingest_account_id,
iaf.folder_name,
ur.size_bytes,
ur.nature,
ur.content
FROM uniform_resource ur
INNER JOIN uniform_resource_edge edge ON edge.uniform_resource_id=ur.uniform_resource_id
INNER JOIN uniform_resource_graph graph ON graph.name=edge.graph_name
INNER JOIN ur_ingest_session_imap_acct_folder_message iacm ON iacm.ur_ingest_session_imap_acct_folder_message_id = edge.node_id
INNER JOIN ur_ingest_session_imap_acct_folder iaf ON iacm.ingest_imap_acct_folder_id = iaf.ur_ingest_session_imap_acct_folder_id
LEFT JOIN ur_ingest_session_imap_account iac ON iac.ur_ingest_session_imap_account_id = iaf.ingest_account_id
WHERE ur.nature = 'text' AND graph.name='imap' AND ur.ingest_session_imap_acct_folder_message IS NOT NULL |
| uniform_resource_imap |
email |
TEXT |
/console/info-schema/view.sql?name=uniform_resource_imap&stats=yes |
[Content](console/info-schema/view.sql?name=uniform_resource_imap&stats=yes) |
[uniform_resource_imap (view) Schema](console/info-schema/view.sql?name=uniform_resource_imap&stats=yes) |
/console/content/view/uniform_resource_imap.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/uniform_resource_imap.sql?stats=yes) |
[uniform_resource_imap (view) Content](console/content/view/uniform_resource_imap.sql?stats=yes) |
CREATE VIEW uniform_resource_imap AS
SELECT
ur.uniform_resource_id,
graph.name,
iac.ur_ingest_session_imap_account_id,
iac.email,
iac.host,
iacm.subject,
iacm."from",
iacm.message,
iacm.date,
iaf.ur_ingest_session_imap_acct_folder_id,
iaf.ingest_account_id,
iaf.folder_name,
ur.size_bytes,
ur.nature,
ur.content
FROM uniform_resource ur
INNER JOIN uniform_resource_edge edge ON edge.uniform_resource_id=ur.uniform_resource_id
INNER JOIN uniform_resource_graph graph ON graph.name=edge.graph_name
INNER JOIN ur_ingest_session_imap_acct_folder_message iacm ON iacm.ur_ingest_session_imap_acct_folder_message_id = edge.node_id
INNER JOIN ur_ingest_session_imap_acct_folder iaf ON iacm.ingest_imap_acct_folder_id = iaf.ur_ingest_session_imap_acct_folder_id
LEFT JOIN ur_ingest_session_imap_account iac ON iac.ur_ingest_session_imap_account_id = iaf.ingest_account_id
WHERE ur.nature = 'text' AND graph.name='imap' AND ur.ingest_session_imap_acct_folder_message IS NOT NULL |
| uniform_resource_imap |
host |
TEXT |
/console/info-schema/view.sql?name=uniform_resource_imap&stats=yes |
[Content](console/info-schema/view.sql?name=uniform_resource_imap&stats=yes) |
[uniform_resource_imap (view) Schema](console/info-schema/view.sql?name=uniform_resource_imap&stats=yes) |
/console/content/view/uniform_resource_imap.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/uniform_resource_imap.sql?stats=yes) |
[uniform_resource_imap (view) Content](console/content/view/uniform_resource_imap.sql?stats=yes) |
CREATE VIEW uniform_resource_imap AS
SELECT
ur.uniform_resource_id,
graph.name,
iac.ur_ingest_session_imap_account_id,
iac.email,
iac.host,
iacm.subject,
iacm."from",
iacm.message,
iacm.date,
iaf.ur_ingest_session_imap_acct_folder_id,
iaf.ingest_account_id,
iaf.folder_name,
ur.size_bytes,
ur.nature,
ur.content
FROM uniform_resource ur
INNER JOIN uniform_resource_edge edge ON edge.uniform_resource_id=ur.uniform_resource_id
INNER JOIN uniform_resource_graph graph ON graph.name=edge.graph_name
INNER JOIN ur_ingest_session_imap_acct_folder_message iacm ON iacm.ur_ingest_session_imap_acct_folder_message_id = edge.node_id
INNER JOIN ur_ingest_session_imap_acct_folder iaf ON iacm.ingest_imap_acct_folder_id = iaf.ur_ingest_session_imap_acct_folder_id
LEFT JOIN ur_ingest_session_imap_account iac ON iac.ur_ingest_session_imap_account_id = iaf.ingest_account_id
WHERE ur.nature = 'text' AND graph.name='imap' AND ur.ingest_session_imap_acct_folder_message IS NOT NULL |
| uniform_resource_imap |
subject |
TEXT |
/console/info-schema/view.sql?name=uniform_resource_imap&stats=yes |
[Content](console/info-schema/view.sql?name=uniform_resource_imap&stats=yes) |
[uniform_resource_imap (view) Schema](console/info-schema/view.sql?name=uniform_resource_imap&stats=yes) |
/console/content/view/uniform_resource_imap.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/uniform_resource_imap.sql?stats=yes) |
[uniform_resource_imap (view) Content](console/content/view/uniform_resource_imap.sql?stats=yes) |
CREATE VIEW uniform_resource_imap AS
SELECT
ur.uniform_resource_id,
graph.name,
iac.ur_ingest_session_imap_account_id,
iac.email,
iac.host,
iacm.subject,
iacm."from",
iacm.message,
iacm.date,
iaf.ur_ingest_session_imap_acct_folder_id,
iaf.ingest_account_id,
iaf.folder_name,
ur.size_bytes,
ur.nature,
ur.content
FROM uniform_resource ur
INNER JOIN uniform_resource_edge edge ON edge.uniform_resource_id=ur.uniform_resource_id
INNER JOIN uniform_resource_graph graph ON graph.name=edge.graph_name
INNER JOIN ur_ingest_session_imap_acct_folder_message iacm ON iacm.ur_ingest_session_imap_acct_folder_message_id = edge.node_id
INNER JOIN ur_ingest_session_imap_acct_folder iaf ON iacm.ingest_imap_acct_folder_id = iaf.ur_ingest_session_imap_acct_folder_id
LEFT JOIN ur_ingest_session_imap_account iac ON iac.ur_ingest_session_imap_account_id = iaf.ingest_account_id
WHERE ur.nature = 'text' AND graph.name='imap' AND ur.ingest_session_imap_acct_folder_message IS NOT NULL |
| uniform_resource_imap |
from |
TEXT |
/console/info-schema/view.sql?name=uniform_resource_imap&stats=yes |
[Content](console/info-schema/view.sql?name=uniform_resource_imap&stats=yes) |
[uniform_resource_imap (view) Schema](console/info-schema/view.sql?name=uniform_resource_imap&stats=yes) |
/console/content/view/uniform_resource_imap.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/uniform_resource_imap.sql?stats=yes) |
[uniform_resource_imap (view) Content](console/content/view/uniform_resource_imap.sql?stats=yes) |
CREATE VIEW uniform_resource_imap AS
SELECT
ur.uniform_resource_id,
graph.name,
iac.ur_ingest_session_imap_account_id,
iac.email,
iac.host,
iacm.subject,
iacm."from",
iacm.message,
iacm.date,
iaf.ur_ingest_session_imap_acct_folder_id,
iaf.ingest_account_id,
iaf.folder_name,
ur.size_bytes,
ur.nature,
ur.content
FROM uniform_resource ur
INNER JOIN uniform_resource_edge edge ON edge.uniform_resource_id=ur.uniform_resource_id
INNER JOIN uniform_resource_graph graph ON graph.name=edge.graph_name
INNER JOIN ur_ingest_session_imap_acct_folder_message iacm ON iacm.ur_ingest_session_imap_acct_folder_message_id = edge.node_id
INNER JOIN ur_ingest_session_imap_acct_folder iaf ON iacm.ingest_imap_acct_folder_id = iaf.ur_ingest_session_imap_acct_folder_id
LEFT JOIN ur_ingest_session_imap_account iac ON iac.ur_ingest_session_imap_account_id = iaf.ingest_account_id
WHERE ur.nature = 'text' AND graph.name='imap' AND ur.ingest_session_imap_acct_folder_message IS NOT NULL |