| console_information_schema_table |
column_name |
BLOB |
/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_table |
data_type |
BLOB |
/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_table |
is_primary_key |
|
/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_table |
is_not_null |
|
/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_table |
default_value |
BLOB |
/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_table |
info_schema_web_ui_path |
|
/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_table |
info_schema_link_abbrev_md |
|
/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_table |
info_schema_link_full_md |
|
/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_table |
content_web_ui_path |
|
/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_table |
content_web_ui_link_abbrev_md |
|
/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_table |
content_web_ui_link_full_md |
|
/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_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' |
| orchestration_session_by_device |
device_id |
VARCHAR |
/console/info-schema/view.sql?name=orchestration_session_by_device&stats=yes |
[Content](console/info-schema/view.sql?name=orchestration_session_by_device&stats=yes) |
[orchestration_session_by_device (view) Schema](console/info-schema/view.sql?name=orchestration_session_by_device&stats=yes) |
/console/content/view/orchestration_session_by_device.sql?stats=yes |
[Content]($SITE_PREFIX_URL/console/content/view/orchestration_session_by_device.sql?stats=yes) |
[orchestration_session_by_device (view) Content](console/content/view/orchestration_session_by_device.sql?stats=yes) |
CREATE VIEW orchestration_session_by_device AS
SELECT
d.device_id,
d.name AS device_name,
COUNT(*) AS session_count
FROM orchestration_session os
JOIN device d ON os.device_id = d.device_id
GROUP BY d.device_id, d.name |