console_information_schema_table (view) Content
| sqlean_define | name | TEXT | Yes | No | console/info-schema/table.sql?name=sqlean_define&stats=yes | [Content](console/info-schema/table.sql?name=sqlean_define&stats=yes) | [sqlean_define (table) Schema](console/info-schema/table.sql?name=sqlean_define&stats=yes) | console/content/table/sqlean_define.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/sqlean_define.sql?stats=yes) | [sqlean_define (table) Content](console/content/table/sqlean_define.sql?stats=yes) | CREATE TABLE sqlean_define(name text primary key, type text, body text) | |
| sqlean_define | type | TEXT | No | No | console/info-schema/table.sql?name=sqlean_define&stats=yes | [Content](console/info-schema/table.sql?name=sqlean_define&stats=yes) | [sqlean_define (table) Schema](console/info-schema/table.sql?name=sqlean_define&stats=yes) | console/content/table/sqlean_define.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/sqlean_define.sql?stats=yes) | [sqlean_define (table) Content](console/content/table/sqlean_define.sql?stats=yes) | CREATE TABLE sqlean_define(name text primary key, type text, body text) | |
| sqlean_define | body | TEXT | No | No | console/info-schema/table.sql?name=sqlean_define&stats=yes | [Content](console/info-schema/table.sql?name=sqlean_define&stats=yes) | [sqlean_define (table) Schema](console/info-schema/table.sql?name=sqlean_define&stats=yes) | console/content/table/sqlean_define.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/sqlean_define.sql?stats=yes) | [sqlean_define (table) Content](console/content/table/sqlean_define.sql?stats=yes) | CREATE TABLE sqlean_define(name text primary key, type text, body text) | |
| assurance_schema | assurance_schema_id | VARCHAR | Yes | Yes | console/info-schema/table.sql?name=assurance_schema&stats=yes | [Content](console/info-schema/table.sql?name=assurance_schema&stats=yes) | [assurance_schema (table) Schema](console/info-schema/table.sql?name=assurance_schema&stats=yes) | console/content/table/assurance_schema.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/assurance_schema.sql?stats=yes) | [assurance_schema (table) Content](console/content/table/assurance_schema.sql?stats=yes) | CREATE TABLE `assurance_schema` ( `assurance_schema_id` VARCHAR PRIMARY KEY NOT NULL, `assurance_type` text NOT NULL, `code` text NOT NULL, `code_json` text, `governance` text, `created_at` TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP, `created_by` text DEFAULT 'UNKNOWN', `updated_at` TIMESTAMPTZ, `updated_by` text, `deleted_at` TIMESTAMPTZ, `deleted_by` text, `activity_log` text, CONSTRAINT "code_json_check_valid_json" CHECK(json_valid("assurance_schema"."code_json") OR "assurance_schema"."code_json" IS NULL), CONSTRAINT "governance_check_valid_json" CHECK(json_valid("assurance_schema"."governance") OR "assurance_schema"."governance" IS NULL) ) | |
| assurance_schema | assurance_type | TEXT | No | Yes | console/info-schema/table.sql?name=assurance_schema&stats=yes | [Content](console/info-schema/table.sql?name=assurance_schema&stats=yes) | [assurance_schema (table) Schema](console/info-schema/table.sql?name=assurance_schema&stats=yes) | console/content/table/assurance_schema.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/assurance_schema.sql?stats=yes) | [assurance_schema (table) Content](console/content/table/assurance_schema.sql?stats=yes) | CREATE TABLE `assurance_schema` ( `assurance_schema_id` VARCHAR PRIMARY KEY NOT NULL, `assurance_type` text NOT NULL, `code` text NOT NULL, `code_json` text, `governance` text, `created_at` TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP, `created_by` text DEFAULT 'UNKNOWN', `updated_at` TIMESTAMPTZ, `updated_by` text, `deleted_at` TIMESTAMPTZ, `deleted_by` text, `activity_log` text, CONSTRAINT "code_json_check_valid_json" CHECK(json_valid("assurance_schema"."code_json") OR "assurance_schema"."code_json" IS NULL), CONSTRAINT "governance_check_valid_json" CHECK(json_valid("assurance_schema"."governance") OR "assurance_schema"."governance" IS NULL) ) | |
| assurance_schema | code | TEXT | No | Yes | console/info-schema/table.sql?name=assurance_schema&stats=yes | [Content](console/info-schema/table.sql?name=assurance_schema&stats=yes) | [assurance_schema (table) Schema](console/info-schema/table.sql?name=assurance_schema&stats=yes) | console/content/table/assurance_schema.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/assurance_schema.sql?stats=yes) | [assurance_schema (table) Content](console/content/table/assurance_schema.sql?stats=yes) | CREATE TABLE `assurance_schema` ( `assurance_schema_id` VARCHAR PRIMARY KEY NOT NULL, `assurance_type` text NOT NULL, `code` text NOT NULL, `code_json` text, `governance` text, `created_at` TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP, `created_by` text DEFAULT 'UNKNOWN', `updated_at` TIMESTAMPTZ, `updated_by` text, `deleted_at` TIMESTAMPTZ, `deleted_by` text, `activity_log` text, CONSTRAINT "code_json_check_valid_json" CHECK(json_valid("assurance_schema"."code_json") OR "assurance_schema"."code_json" IS NULL), CONSTRAINT "governance_check_valid_json" CHECK(json_valid("assurance_schema"."governance") OR "assurance_schema"."governance" IS NULL) ) | |
| assurance_schema | code_json | TEXT | No | No | console/info-schema/table.sql?name=assurance_schema&stats=yes | [Content](console/info-schema/table.sql?name=assurance_schema&stats=yes) | [assurance_schema (table) Schema](console/info-schema/table.sql?name=assurance_schema&stats=yes) | console/content/table/assurance_schema.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/assurance_schema.sql?stats=yes) | [assurance_schema (table) Content](console/content/table/assurance_schema.sql?stats=yes) | CREATE TABLE `assurance_schema` ( `assurance_schema_id` VARCHAR PRIMARY KEY NOT NULL, `assurance_type` text NOT NULL, `code` text NOT NULL, `code_json` text, `governance` text, `created_at` TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP, `created_by` text DEFAULT 'UNKNOWN', `updated_at` TIMESTAMPTZ, `updated_by` text, `deleted_at` TIMESTAMPTZ, `deleted_by` text, `activity_log` text, CONSTRAINT "code_json_check_valid_json" CHECK(json_valid("assurance_schema"."code_json") OR "assurance_schema"."code_json" IS NULL), CONSTRAINT "governance_check_valid_json" CHECK(json_valid("assurance_schema"."governance") OR "assurance_schema"."governance" IS NULL) ) | |
| assurance_schema | governance | TEXT | No | No | console/info-schema/table.sql?name=assurance_schema&stats=yes | [Content](console/info-schema/table.sql?name=assurance_schema&stats=yes) | [assurance_schema (table) Schema](console/info-schema/table.sql?name=assurance_schema&stats=yes) | console/content/table/assurance_schema.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/assurance_schema.sql?stats=yes) | [assurance_schema (table) Content](console/content/table/assurance_schema.sql?stats=yes) | CREATE TABLE `assurance_schema` ( `assurance_schema_id` VARCHAR PRIMARY KEY NOT NULL, `assurance_type` text NOT NULL, `code` text NOT NULL, `code_json` text, `governance` text, `created_at` TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP, `created_by` text DEFAULT 'UNKNOWN', `updated_at` TIMESTAMPTZ, `updated_by` text, `deleted_at` TIMESTAMPTZ, `deleted_by` text, `activity_log` text, CONSTRAINT "code_json_check_valid_json" CHECK(json_valid("assurance_schema"."code_json") OR "assurance_schema"."code_json" IS NULL), CONSTRAINT "governance_check_valid_json" CHECK(json_valid("assurance_schema"."governance") OR "assurance_schema"."governance" IS NULL) ) | |
| assurance_schema | created_at | TIMESTAMPTZ | No | No | CURRENT_TIMESTAMP | console/info-schema/table.sql?name=assurance_schema&stats=yes | [Content](console/info-schema/table.sql?name=assurance_schema&stats=yes) | [assurance_schema (table) Schema](console/info-schema/table.sql?name=assurance_schema&stats=yes) | console/content/table/assurance_schema.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/assurance_schema.sql?stats=yes) | [assurance_schema (table) Content](console/content/table/assurance_schema.sql?stats=yes) | CREATE TABLE `assurance_schema` ( `assurance_schema_id` VARCHAR PRIMARY KEY NOT NULL, `assurance_type` text NOT NULL, `code` text NOT NULL, `code_json` text, `governance` text, `created_at` TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP, `created_by` text DEFAULT 'UNKNOWN', `updated_at` TIMESTAMPTZ, `updated_by` text, `deleted_at` TIMESTAMPTZ, `deleted_by` text, `activity_log` text, CONSTRAINT "code_json_check_valid_json" CHECK(json_valid("assurance_schema"."code_json") OR "assurance_schema"."code_json" IS NULL), CONSTRAINT "governance_check_valid_json" CHECK(json_valid("assurance_schema"."governance") OR "assurance_schema"."governance" IS NULL) ) |
| assurance_schema | created_by | TEXT | No | No | 'UNKNOWN' | console/info-schema/table.sql?name=assurance_schema&stats=yes | [Content](console/info-schema/table.sql?name=assurance_schema&stats=yes) | [assurance_schema (table) Schema](console/info-schema/table.sql?name=assurance_schema&stats=yes) | console/content/table/assurance_schema.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/assurance_schema.sql?stats=yes) | [assurance_schema (table) Content](console/content/table/assurance_schema.sql?stats=yes) | CREATE TABLE `assurance_schema` ( `assurance_schema_id` VARCHAR PRIMARY KEY NOT NULL, `assurance_type` text NOT NULL, `code` text NOT NULL, `code_json` text, `governance` text, `created_at` TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP, `created_by` text DEFAULT 'UNKNOWN', `updated_at` TIMESTAMPTZ, `updated_by` text, `deleted_at` TIMESTAMPTZ, `deleted_by` text, `activity_log` text, CONSTRAINT "code_json_check_valid_json" CHECK(json_valid("assurance_schema"."code_json") OR "assurance_schema"."code_json" IS NULL), CONSTRAINT "governance_check_valid_json" CHECK(json_valid("assurance_schema"."governance") OR "assurance_schema"."governance" IS NULL) ) |
| assurance_schema | updated_at | TIMESTAMPTZ | No | No | console/info-schema/table.sql?name=assurance_schema&stats=yes | [Content](console/info-schema/table.sql?name=assurance_schema&stats=yes) | [assurance_schema (table) Schema](console/info-schema/table.sql?name=assurance_schema&stats=yes) | console/content/table/assurance_schema.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/assurance_schema.sql?stats=yes) | [assurance_schema (table) Content](console/content/table/assurance_schema.sql?stats=yes) | CREATE TABLE `assurance_schema` ( `assurance_schema_id` VARCHAR PRIMARY KEY NOT NULL, `assurance_type` text NOT NULL, `code` text NOT NULL, `code_json` text, `governance` text, `created_at` TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP, `created_by` text DEFAULT 'UNKNOWN', `updated_at` TIMESTAMPTZ, `updated_by` text, `deleted_at` TIMESTAMPTZ, `deleted_by` text, `activity_log` text, CONSTRAINT "code_json_check_valid_json" CHECK(json_valid("assurance_schema"."code_json") OR "assurance_schema"."code_json" IS NULL), CONSTRAINT "governance_check_valid_json" CHECK(json_valid("assurance_schema"."governance") OR "assurance_schema"."governance" IS NULL) ) | |
| assurance_schema | updated_by | TEXT | No | No | console/info-schema/table.sql?name=assurance_schema&stats=yes | [Content](console/info-schema/table.sql?name=assurance_schema&stats=yes) | [assurance_schema (table) Schema](console/info-schema/table.sql?name=assurance_schema&stats=yes) | console/content/table/assurance_schema.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/assurance_schema.sql?stats=yes) | [assurance_schema (table) Content](console/content/table/assurance_schema.sql?stats=yes) | CREATE TABLE `assurance_schema` ( `assurance_schema_id` VARCHAR PRIMARY KEY NOT NULL, `assurance_type` text NOT NULL, `code` text NOT NULL, `code_json` text, `governance` text, `created_at` TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP, `created_by` text DEFAULT 'UNKNOWN', `updated_at` TIMESTAMPTZ, `updated_by` text, `deleted_at` TIMESTAMPTZ, `deleted_by` text, `activity_log` text, CONSTRAINT "code_json_check_valid_json" CHECK(json_valid("assurance_schema"."code_json") OR "assurance_schema"."code_json" IS NULL), CONSTRAINT "governance_check_valid_json" CHECK(json_valid("assurance_schema"."governance") OR "assurance_schema"."governance" IS NULL) ) | |
| assurance_schema | deleted_at | TIMESTAMPTZ | No | No | console/info-schema/table.sql?name=assurance_schema&stats=yes | [Content](console/info-schema/table.sql?name=assurance_schema&stats=yes) | [assurance_schema (table) Schema](console/info-schema/table.sql?name=assurance_schema&stats=yes) | console/content/table/assurance_schema.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/assurance_schema.sql?stats=yes) | [assurance_schema (table) Content](console/content/table/assurance_schema.sql?stats=yes) | CREATE TABLE `assurance_schema` ( `assurance_schema_id` VARCHAR PRIMARY KEY NOT NULL, `assurance_type` text NOT NULL, `code` text NOT NULL, `code_json` text, `governance` text, `created_at` TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP, `created_by` text DEFAULT 'UNKNOWN', `updated_at` TIMESTAMPTZ, `updated_by` text, `deleted_at` TIMESTAMPTZ, `deleted_by` text, `activity_log` text, CONSTRAINT "code_json_check_valid_json" CHECK(json_valid("assurance_schema"."code_json") OR "assurance_schema"."code_json" IS NULL), CONSTRAINT "governance_check_valid_json" CHECK(json_valid("assurance_schema"."governance") OR "assurance_schema"."governance" IS NULL) ) | |
| assurance_schema | deleted_by | TEXT | No | No | console/info-schema/table.sql?name=assurance_schema&stats=yes | [Content](console/info-schema/table.sql?name=assurance_schema&stats=yes) | [assurance_schema (table) Schema](console/info-schema/table.sql?name=assurance_schema&stats=yes) | console/content/table/assurance_schema.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/assurance_schema.sql?stats=yes) | [assurance_schema (table) Content](console/content/table/assurance_schema.sql?stats=yes) | CREATE TABLE `assurance_schema` ( `assurance_schema_id` VARCHAR PRIMARY KEY NOT NULL, `assurance_type` text NOT NULL, `code` text NOT NULL, `code_json` text, `governance` text, `created_at` TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP, `created_by` text DEFAULT 'UNKNOWN', `updated_at` TIMESTAMPTZ, `updated_by` text, `deleted_at` TIMESTAMPTZ, `deleted_by` text, `activity_log` text, CONSTRAINT "code_json_check_valid_json" CHECK(json_valid("assurance_schema"."code_json") OR "assurance_schema"."code_json" IS NULL), CONSTRAINT "governance_check_valid_json" CHECK(json_valid("assurance_schema"."governance") OR "assurance_schema"."governance" IS NULL) ) | |
| assurance_schema | activity_log | TEXT | No | No | console/info-schema/table.sql?name=assurance_schema&stats=yes | [Content](console/info-schema/table.sql?name=assurance_schema&stats=yes) | [assurance_schema (table) Schema](console/info-schema/table.sql?name=assurance_schema&stats=yes) | console/content/table/assurance_schema.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/assurance_schema.sql?stats=yes) | [assurance_schema (table) Content](console/content/table/assurance_schema.sql?stats=yes) | CREATE TABLE `assurance_schema` ( `assurance_schema_id` VARCHAR PRIMARY KEY NOT NULL, `assurance_type` text NOT NULL, `code` text NOT NULL, `code_json` text, `governance` text, `created_at` TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP, `created_by` text DEFAULT 'UNKNOWN', `updated_at` TIMESTAMPTZ, `updated_by` text, `deleted_at` TIMESTAMPTZ, `deleted_by` text, `activity_log` text, CONSTRAINT "code_json_check_valid_json" CHECK(json_valid("assurance_schema"."code_json") OR "assurance_schema"."code_json" IS NULL), CONSTRAINT "governance_check_valid_json" CHECK(json_valid("assurance_schema"."governance") OR "assurance_schema"."governance" IS NULL) ) | |
| behavior | behavior_id | VARCHAR | Yes | Yes | console/info-schema/table.sql?name=behavior&stats=yes | [Content](console/info-schema/table.sql?name=behavior&stats=yes) | [behavior (table) Schema](console/info-schema/table.sql?name=behavior&stats=yes) | console/content/table/behavior.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/behavior.sql?stats=yes) | [behavior (table) Content](console/content/table/behavior.sql?stats=yes) | CREATE TABLE `behavior` ( `behavior_id` VARCHAR PRIMARY KEY NOT NULL, `device_id` text NOT NULL, `behavior_name` text NOT NULL, `behavior_conf_json` text NOT NULL, `assurance_schema_id` text, `governance` text, `created_at` TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP, `created_by` text DEFAULT 'UNKNOWN', `updated_at` TIMESTAMPTZ, `updated_by` text, `deleted_at` TIMESTAMPTZ, `deleted_by` text, `activity_log` text, CONSTRAINT "behavior_conf_json_check_valid_json" CHECK(json_valid("behavior"."behavior_conf_json") OR "behavior"."behavior_conf_json" IS NULL), CONSTRAINT "governance_check_valid_json" CHECK(json_valid("behavior"."governance") OR "behavior"."governance" IS NULL) ) | |
| behavior | device_id | TEXT | No | Yes | console/info-schema/table.sql?name=behavior&stats=yes | [Content](console/info-schema/table.sql?name=behavior&stats=yes) | [behavior (table) Schema](console/info-schema/table.sql?name=behavior&stats=yes) | console/content/table/behavior.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/behavior.sql?stats=yes) | [behavior (table) Content](console/content/table/behavior.sql?stats=yes) | CREATE TABLE `behavior` ( `behavior_id` VARCHAR PRIMARY KEY NOT NULL, `device_id` text NOT NULL, `behavior_name` text NOT NULL, `behavior_conf_json` text NOT NULL, `assurance_schema_id` text, `governance` text, `created_at` TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP, `created_by` text DEFAULT 'UNKNOWN', `updated_at` TIMESTAMPTZ, `updated_by` text, `deleted_at` TIMESTAMPTZ, `deleted_by` text, `activity_log` text, CONSTRAINT "behavior_conf_json_check_valid_json" CHECK(json_valid("behavior"."behavior_conf_json") OR "behavior"."behavior_conf_json" IS NULL), CONSTRAINT "governance_check_valid_json" CHECK(json_valid("behavior"."governance") OR "behavior"."governance" IS NULL) ) | |
| behavior | behavior_name | TEXT | No | Yes | console/info-schema/table.sql?name=behavior&stats=yes | [Content](console/info-schema/table.sql?name=behavior&stats=yes) | [behavior (table) Schema](console/info-schema/table.sql?name=behavior&stats=yes) | console/content/table/behavior.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/behavior.sql?stats=yes) | [behavior (table) Content](console/content/table/behavior.sql?stats=yes) | CREATE TABLE `behavior` ( `behavior_id` VARCHAR PRIMARY KEY NOT NULL, `device_id` text NOT NULL, `behavior_name` text NOT NULL, `behavior_conf_json` text NOT NULL, `assurance_schema_id` text, `governance` text, `created_at` TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP, `created_by` text DEFAULT 'UNKNOWN', `updated_at` TIMESTAMPTZ, `updated_by` text, `deleted_at` TIMESTAMPTZ, `deleted_by` text, `activity_log` text, CONSTRAINT "behavior_conf_json_check_valid_json" CHECK(json_valid("behavior"."behavior_conf_json") OR "behavior"."behavior_conf_json" IS NULL), CONSTRAINT "governance_check_valid_json" CHECK(json_valid("behavior"."governance") OR "behavior"."governance" IS NULL) ) | |
| behavior | behavior_conf_json | TEXT | No | Yes | console/info-schema/table.sql?name=behavior&stats=yes | [Content](console/info-schema/table.sql?name=behavior&stats=yes) | [behavior (table) Schema](console/info-schema/table.sql?name=behavior&stats=yes) | console/content/table/behavior.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/behavior.sql?stats=yes) | [behavior (table) Content](console/content/table/behavior.sql?stats=yes) | CREATE TABLE `behavior` ( `behavior_id` VARCHAR PRIMARY KEY NOT NULL, `device_id` text NOT NULL, `behavior_name` text NOT NULL, `behavior_conf_json` text NOT NULL, `assurance_schema_id` text, `governance` text, `created_at` TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP, `created_by` text DEFAULT 'UNKNOWN', `updated_at` TIMESTAMPTZ, `updated_by` text, `deleted_at` TIMESTAMPTZ, `deleted_by` text, `activity_log` text, CONSTRAINT "behavior_conf_json_check_valid_json" CHECK(json_valid("behavior"."behavior_conf_json") OR "behavior"."behavior_conf_json" IS NULL), CONSTRAINT "governance_check_valid_json" CHECK(json_valid("behavior"."governance") OR "behavior"."governance" IS NULL) ) | |
| behavior | assurance_schema_id | TEXT | No | No | console/info-schema/table.sql?name=behavior&stats=yes | [Content](console/info-schema/table.sql?name=behavior&stats=yes) | [behavior (table) Schema](console/info-schema/table.sql?name=behavior&stats=yes) | console/content/table/behavior.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/behavior.sql?stats=yes) | [behavior (table) Content](console/content/table/behavior.sql?stats=yes) | CREATE TABLE `behavior` ( `behavior_id` VARCHAR PRIMARY KEY NOT NULL, `device_id` text NOT NULL, `behavior_name` text NOT NULL, `behavior_conf_json` text NOT NULL, `assurance_schema_id` text, `governance` text, `created_at` TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP, `created_by` text DEFAULT 'UNKNOWN', `updated_at` TIMESTAMPTZ, `updated_by` text, `deleted_at` TIMESTAMPTZ, `deleted_by` text, `activity_log` text, CONSTRAINT "behavior_conf_json_check_valid_json" CHECK(json_valid("behavior"."behavior_conf_json") OR "behavior"."behavior_conf_json" IS NULL), CONSTRAINT "governance_check_valid_json" CHECK(json_valid("behavior"."governance") OR "behavior"."governance" IS NULL) ) | |
| behavior | governance | TEXT | No | No | console/info-schema/table.sql?name=behavior&stats=yes | [Content](console/info-schema/table.sql?name=behavior&stats=yes) | [behavior (table) Schema](console/info-schema/table.sql?name=behavior&stats=yes) | console/content/table/behavior.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/behavior.sql?stats=yes) | [behavior (table) Content](console/content/table/behavior.sql?stats=yes) | CREATE TABLE `behavior` ( `behavior_id` VARCHAR PRIMARY KEY NOT NULL, `device_id` text NOT NULL, `behavior_name` text NOT NULL, `behavior_conf_json` text NOT NULL, `assurance_schema_id` text, `governance` text, `created_at` TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP, `created_by` text DEFAULT 'UNKNOWN', `updated_at` TIMESTAMPTZ, `updated_by` text, `deleted_at` TIMESTAMPTZ, `deleted_by` text, `activity_log` text, CONSTRAINT "behavior_conf_json_check_valid_json" CHECK(json_valid("behavior"."behavior_conf_json") OR "behavior"."behavior_conf_json" IS NULL), CONSTRAINT "governance_check_valid_json" CHECK(json_valid("behavior"."governance") OR "behavior"."governance" IS NULL) ) | |
| behavior | created_at | TIMESTAMPTZ | No | No | CURRENT_TIMESTAMP | console/info-schema/table.sql?name=behavior&stats=yes | [Content](console/info-schema/table.sql?name=behavior&stats=yes) | [behavior (table) Schema](console/info-schema/table.sql?name=behavior&stats=yes) | console/content/table/behavior.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/behavior.sql?stats=yes) | [behavior (table) Content](console/content/table/behavior.sql?stats=yes) | CREATE TABLE `behavior` ( `behavior_id` VARCHAR PRIMARY KEY NOT NULL, `device_id` text NOT NULL, `behavior_name` text NOT NULL, `behavior_conf_json` text NOT NULL, `assurance_schema_id` text, `governance` text, `created_at` TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP, `created_by` text DEFAULT 'UNKNOWN', `updated_at` TIMESTAMPTZ, `updated_by` text, `deleted_at` TIMESTAMPTZ, `deleted_by` text, `activity_log` text, CONSTRAINT "behavior_conf_json_check_valid_json" CHECK(json_valid("behavior"."behavior_conf_json") OR "behavior"."behavior_conf_json" IS NULL), CONSTRAINT "governance_check_valid_json" CHECK(json_valid("behavior"."governance") OR "behavior"."governance" IS NULL) ) |
| behavior | created_by | TEXT | No | No | 'UNKNOWN' | console/info-schema/table.sql?name=behavior&stats=yes | [Content](console/info-schema/table.sql?name=behavior&stats=yes) | [behavior (table) Schema](console/info-schema/table.sql?name=behavior&stats=yes) | console/content/table/behavior.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/behavior.sql?stats=yes) | [behavior (table) Content](console/content/table/behavior.sql?stats=yes) | CREATE TABLE `behavior` ( `behavior_id` VARCHAR PRIMARY KEY NOT NULL, `device_id` text NOT NULL, `behavior_name` text NOT NULL, `behavior_conf_json` text NOT NULL, `assurance_schema_id` text, `governance` text, `created_at` TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP, `created_by` text DEFAULT 'UNKNOWN', `updated_at` TIMESTAMPTZ, `updated_by` text, `deleted_at` TIMESTAMPTZ, `deleted_by` text, `activity_log` text, CONSTRAINT "behavior_conf_json_check_valid_json" CHECK(json_valid("behavior"."behavior_conf_json") OR "behavior"."behavior_conf_json" IS NULL), CONSTRAINT "governance_check_valid_json" CHECK(json_valid("behavior"."governance") OR "behavior"."governance" IS NULL) ) |
| behavior | updated_at | TIMESTAMPTZ | No | No | console/info-schema/table.sql?name=behavior&stats=yes | [Content](console/info-schema/table.sql?name=behavior&stats=yes) | [behavior (table) Schema](console/info-schema/table.sql?name=behavior&stats=yes) | console/content/table/behavior.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/behavior.sql?stats=yes) | [behavior (table) Content](console/content/table/behavior.sql?stats=yes) | CREATE TABLE `behavior` ( `behavior_id` VARCHAR PRIMARY KEY NOT NULL, `device_id` text NOT NULL, `behavior_name` text NOT NULL, `behavior_conf_json` text NOT NULL, `assurance_schema_id` text, `governance` text, `created_at` TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP, `created_by` text DEFAULT 'UNKNOWN', `updated_at` TIMESTAMPTZ, `updated_by` text, `deleted_at` TIMESTAMPTZ, `deleted_by` text, `activity_log` text, CONSTRAINT "behavior_conf_json_check_valid_json" CHECK(json_valid("behavior"."behavior_conf_json") OR "behavior"."behavior_conf_json" IS NULL), CONSTRAINT "governance_check_valid_json" CHECK(json_valid("behavior"."governance") OR "behavior"."governance" IS NULL) ) | |
| behavior | updated_by | TEXT | No | No | console/info-schema/table.sql?name=behavior&stats=yes | [Content](console/info-schema/table.sql?name=behavior&stats=yes) | [behavior (table) Schema](console/info-schema/table.sql?name=behavior&stats=yes) | console/content/table/behavior.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/behavior.sql?stats=yes) | [behavior (table) Content](console/content/table/behavior.sql?stats=yes) | CREATE TABLE `behavior` ( `behavior_id` VARCHAR PRIMARY KEY NOT NULL, `device_id` text NOT NULL, `behavior_name` text NOT NULL, `behavior_conf_json` text NOT NULL, `assurance_schema_id` text, `governance` text, `created_at` TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP, `created_by` text DEFAULT 'UNKNOWN', `updated_at` TIMESTAMPTZ, `updated_by` text, `deleted_at` TIMESTAMPTZ, `deleted_by` text, `activity_log` text, CONSTRAINT "behavior_conf_json_check_valid_json" CHECK(json_valid("behavior"."behavior_conf_json") OR "behavior"."behavior_conf_json" IS NULL), CONSTRAINT "governance_check_valid_json" CHECK(json_valid("behavior"."governance") OR "behavior"."governance" IS NULL) ) | |
| behavior | deleted_at | TIMESTAMPTZ | No | No | console/info-schema/table.sql?name=behavior&stats=yes | [Content](console/info-schema/table.sql?name=behavior&stats=yes) | [behavior (table) Schema](console/info-schema/table.sql?name=behavior&stats=yes) | console/content/table/behavior.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/behavior.sql?stats=yes) | [behavior (table) Content](console/content/table/behavior.sql?stats=yes) | CREATE TABLE `behavior` ( `behavior_id` VARCHAR PRIMARY KEY NOT NULL, `device_id` text NOT NULL, `behavior_name` text NOT NULL, `behavior_conf_json` text NOT NULL, `assurance_schema_id` text, `governance` text, `created_at` TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP, `created_by` text DEFAULT 'UNKNOWN', `updated_at` TIMESTAMPTZ, `updated_by` text, `deleted_at` TIMESTAMPTZ, `deleted_by` text, `activity_log` text, CONSTRAINT "behavior_conf_json_check_valid_json" CHECK(json_valid("behavior"."behavior_conf_json") OR "behavior"."behavior_conf_json" IS NULL), CONSTRAINT "governance_check_valid_json" CHECK(json_valid("behavior"."governance") OR "behavior"."governance" IS NULL) ) | |
| behavior | deleted_by | TEXT | No | No | console/info-schema/table.sql?name=behavior&stats=yes | [Content](console/info-schema/table.sql?name=behavior&stats=yes) | [behavior (table) Schema](console/info-schema/table.sql?name=behavior&stats=yes) | console/content/table/behavior.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/behavior.sql?stats=yes) | [behavior (table) Content](console/content/table/behavior.sql?stats=yes) | CREATE TABLE `behavior` ( `behavior_id` VARCHAR PRIMARY KEY NOT NULL, `device_id` text NOT NULL, `behavior_name` text NOT NULL, `behavior_conf_json` text NOT NULL, `assurance_schema_id` text, `governance` text, `created_at` TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP, `created_by` text DEFAULT 'UNKNOWN', `updated_at` TIMESTAMPTZ, `updated_by` text, `deleted_at` TIMESTAMPTZ, `deleted_by` text, `activity_log` text, CONSTRAINT "behavior_conf_json_check_valid_json" CHECK(json_valid("behavior"."behavior_conf_json") OR "behavior"."behavior_conf_json" IS NULL), CONSTRAINT "governance_check_valid_json" CHECK(json_valid("behavior"."governance") OR "behavior"."governance" IS NULL) ) | |
| behavior | activity_log | TEXT | No | No | console/info-schema/table.sql?name=behavior&stats=yes | [Content](console/info-schema/table.sql?name=behavior&stats=yes) | [behavior (table) Schema](console/info-schema/table.sql?name=behavior&stats=yes) | console/content/table/behavior.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/behavior.sql?stats=yes) | [behavior (table) Content](console/content/table/behavior.sql?stats=yes) | CREATE TABLE `behavior` ( `behavior_id` VARCHAR PRIMARY KEY NOT NULL, `device_id` text NOT NULL, `behavior_name` text NOT NULL, `behavior_conf_json` text NOT NULL, `assurance_schema_id` text, `governance` text, `created_at` TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP, `created_by` text DEFAULT 'UNKNOWN', `updated_at` TIMESTAMPTZ, `updated_by` text, `deleted_at` TIMESTAMPTZ, `deleted_by` text, `activity_log` text, CONSTRAINT "behavior_conf_json_check_valid_json" CHECK(json_valid("behavior"."behavior_conf_json") OR "behavior"."behavior_conf_json" IS NULL), CONSTRAINT "governance_check_valid_json" CHECK(json_valid("behavior"."governance") OR "behavior"."governance" IS NULL) ) | |
| code_notebook_kernel | code_notebook_kernel_id | VARCHAR | Yes | Yes | console/info-schema/table.sql?name=code_notebook_kernel&stats=yes | [Content](console/info-schema/table.sql?name=code_notebook_kernel&stats=yes) | [code_notebook_kernel (table) Schema](console/info-schema/table.sql?name=code_notebook_kernel&stats=yes) | console/content/table/code_notebook_kernel.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/code_notebook_kernel.sql?stats=yes) | [code_notebook_kernel (table) Content](console/content/table/code_notebook_kernel.sql?stats=yes) | CREATE TABLE `code_notebook_kernel` ( `code_notebook_kernel_id` VARCHAR PRIMARY KEY NOT NULL, `kernel_name` text NOT NULL, `description` text, `mime_type` text, `file_extn` text, `elaboration` text, `governance` text, `created_at` TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP, `created_by` text DEFAULT 'UNKNOWN', `updated_at` TIMESTAMPTZ, `updated_by` text, `deleted_at` TIMESTAMPTZ, `deleted_by` text, `activity_log` text, CONSTRAINT "elaboration_check_valid_json" CHECK(json_valid("code_notebook_kernel"."elaboration") OR "code_notebook_kernel"."elaboration" IS NULL), CONSTRAINT "governance_check_valid_json" CHECK(json_valid("code_notebook_kernel"."governance") OR "code_notebook_kernel"."governance" IS NULL) ) | |
| code_notebook_kernel | kernel_name | TEXT | No | Yes | console/info-schema/table.sql?name=code_notebook_kernel&stats=yes | [Content](console/info-schema/table.sql?name=code_notebook_kernel&stats=yes) | [code_notebook_kernel (table) Schema](console/info-schema/table.sql?name=code_notebook_kernel&stats=yes) | console/content/table/code_notebook_kernel.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/code_notebook_kernel.sql?stats=yes) | [code_notebook_kernel (table) Content](console/content/table/code_notebook_kernel.sql?stats=yes) | CREATE TABLE `code_notebook_kernel` ( `code_notebook_kernel_id` VARCHAR PRIMARY KEY NOT NULL, `kernel_name` text NOT NULL, `description` text, `mime_type` text, `file_extn` text, `elaboration` text, `governance` text, `created_at` TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP, `created_by` text DEFAULT 'UNKNOWN', `updated_at` TIMESTAMPTZ, `updated_by` text, `deleted_at` TIMESTAMPTZ, `deleted_by` text, `activity_log` text, CONSTRAINT "elaboration_check_valid_json" CHECK(json_valid("code_notebook_kernel"."elaboration") OR "code_notebook_kernel"."elaboration" IS NULL), CONSTRAINT "governance_check_valid_json" CHECK(json_valid("code_notebook_kernel"."governance") OR "code_notebook_kernel"."governance" IS NULL) ) | |
| code_notebook_kernel | description | TEXT | No | No | console/info-schema/table.sql?name=code_notebook_kernel&stats=yes | [Content](console/info-schema/table.sql?name=code_notebook_kernel&stats=yes) | [code_notebook_kernel (table) Schema](console/info-schema/table.sql?name=code_notebook_kernel&stats=yes) | console/content/table/code_notebook_kernel.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/code_notebook_kernel.sql?stats=yes) | [code_notebook_kernel (table) Content](console/content/table/code_notebook_kernel.sql?stats=yes) | CREATE TABLE `code_notebook_kernel` ( `code_notebook_kernel_id` VARCHAR PRIMARY KEY NOT NULL, `kernel_name` text NOT NULL, `description` text, `mime_type` text, `file_extn` text, `elaboration` text, `governance` text, `created_at` TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP, `created_by` text DEFAULT 'UNKNOWN', `updated_at` TIMESTAMPTZ, `updated_by` text, `deleted_at` TIMESTAMPTZ, `deleted_by` text, `activity_log` text, CONSTRAINT "elaboration_check_valid_json" CHECK(json_valid("code_notebook_kernel"."elaboration") OR "code_notebook_kernel"."elaboration" IS NULL), CONSTRAINT "governance_check_valid_json" CHECK(json_valid("code_notebook_kernel"."governance") OR "code_notebook_kernel"."governance" IS NULL) ) | |
| code_notebook_kernel | mime_type | TEXT | No | No | console/info-schema/table.sql?name=code_notebook_kernel&stats=yes | [Content](console/info-schema/table.sql?name=code_notebook_kernel&stats=yes) | [code_notebook_kernel (table) Schema](console/info-schema/table.sql?name=code_notebook_kernel&stats=yes) | console/content/table/code_notebook_kernel.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/code_notebook_kernel.sql?stats=yes) | [code_notebook_kernel (table) Content](console/content/table/code_notebook_kernel.sql?stats=yes) | CREATE TABLE `code_notebook_kernel` ( `code_notebook_kernel_id` VARCHAR PRIMARY KEY NOT NULL, `kernel_name` text NOT NULL, `description` text, `mime_type` text, `file_extn` text, `elaboration` text, `governance` text, `created_at` TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP, `created_by` text DEFAULT 'UNKNOWN', `updated_at` TIMESTAMPTZ, `updated_by` text, `deleted_at` TIMESTAMPTZ, `deleted_by` text, `activity_log` text, CONSTRAINT "elaboration_check_valid_json" CHECK(json_valid("code_notebook_kernel"."elaboration") OR "code_notebook_kernel"."elaboration" IS NULL), CONSTRAINT "governance_check_valid_json" CHECK(json_valid("code_notebook_kernel"."governance") OR "code_notebook_kernel"."governance" IS NULL) ) | |
| code_notebook_kernel | file_extn | TEXT | No | No | console/info-schema/table.sql?name=code_notebook_kernel&stats=yes | [Content](console/info-schema/table.sql?name=code_notebook_kernel&stats=yes) | [code_notebook_kernel (table) Schema](console/info-schema/table.sql?name=code_notebook_kernel&stats=yes) | console/content/table/code_notebook_kernel.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/code_notebook_kernel.sql?stats=yes) | [code_notebook_kernel (table) Content](console/content/table/code_notebook_kernel.sql?stats=yes) | CREATE TABLE `code_notebook_kernel` ( `code_notebook_kernel_id` VARCHAR PRIMARY KEY NOT NULL, `kernel_name` text NOT NULL, `description` text, `mime_type` text, `file_extn` text, `elaboration` text, `governance` text, `created_at` TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP, `created_by` text DEFAULT 'UNKNOWN', `updated_at` TIMESTAMPTZ, `updated_by` text, `deleted_at` TIMESTAMPTZ, `deleted_by` text, `activity_log` text, CONSTRAINT "elaboration_check_valid_json" CHECK(json_valid("code_notebook_kernel"."elaboration") OR "code_notebook_kernel"."elaboration" IS NULL), CONSTRAINT "governance_check_valid_json" CHECK(json_valid("code_notebook_kernel"."governance") OR "code_notebook_kernel"."governance" IS NULL) ) | |
| code_notebook_kernel | elaboration | TEXT | No | No | console/info-schema/table.sql?name=code_notebook_kernel&stats=yes | [Content](console/info-schema/table.sql?name=code_notebook_kernel&stats=yes) | [code_notebook_kernel (table) Schema](console/info-schema/table.sql?name=code_notebook_kernel&stats=yes) | console/content/table/code_notebook_kernel.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/code_notebook_kernel.sql?stats=yes) | [code_notebook_kernel (table) Content](console/content/table/code_notebook_kernel.sql?stats=yes) | CREATE TABLE `code_notebook_kernel` ( `code_notebook_kernel_id` VARCHAR PRIMARY KEY NOT NULL, `kernel_name` text NOT NULL, `description` text, `mime_type` text, `file_extn` text, `elaboration` text, `governance` text, `created_at` TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP, `created_by` text DEFAULT 'UNKNOWN', `updated_at` TIMESTAMPTZ, `updated_by` text, `deleted_at` TIMESTAMPTZ, `deleted_by` text, `activity_log` text, CONSTRAINT "elaboration_check_valid_json" CHECK(json_valid("code_notebook_kernel"."elaboration") OR "code_notebook_kernel"."elaboration" IS NULL), CONSTRAINT "governance_check_valid_json" CHECK(json_valid("code_notebook_kernel"."governance") OR "code_notebook_kernel"."governance" IS NULL) ) | |
| code_notebook_kernel | governance | TEXT | No | No | console/info-schema/table.sql?name=code_notebook_kernel&stats=yes | [Content](console/info-schema/table.sql?name=code_notebook_kernel&stats=yes) | [code_notebook_kernel (table) Schema](console/info-schema/table.sql?name=code_notebook_kernel&stats=yes) | console/content/table/code_notebook_kernel.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/code_notebook_kernel.sql?stats=yes) | [code_notebook_kernel (table) Content](console/content/table/code_notebook_kernel.sql?stats=yes) | CREATE TABLE `code_notebook_kernel` ( `code_notebook_kernel_id` VARCHAR PRIMARY KEY NOT NULL, `kernel_name` text NOT NULL, `description` text, `mime_type` text, `file_extn` text, `elaboration` text, `governance` text, `created_at` TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP, `created_by` text DEFAULT 'UNKNOWN', `updated_at` TIMESTAMPTZ, `updated_by` text, `deleted_at` TIMESTAMPTZ, `deleted_by` text, `activity_log` text, CONSTRAINT "elaboration_check_valid_json" CHECK(json_valid("code_notebook_kernel"."elaboration") OR "code_notebook_kernel"."elaboration" IS NULL), CONSTRAINT "governance_check_valid_json" CHECK(json_valid("code_notebook_kernel"."governance") OR "code_notebook_kernel"."governance" IS NULL) ) | |
| code_notebook_kernel | created_at | TIMESTAMPTZ | No | No | CURRENT_TIMESTAMP | console/info-schema/table.sql?name=code_notebook_kernel&stats=yes | [Content](console/info-schema/table.sql?name=code_notebook_kernel&stats=yes) | [code_notebook_kernel (table) Schema](console/info-schema/table.sql?name=code_notebook_kernel&stats=yes) | console/content/table/code_notebook_kernel.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/code_notebook_kernel.sql?stats=yes) | [code_notebook_kernel (table) Content](console/content/table/code_notebook_kernel.sql?stats=yes) | CREATE TABLE `code_notebook_kernel` ( `code_notebook_kernel_id` VARCHAR PRIMARY KEY NOT NULL, `kernel_name` text NOT NULL, `description` text, `mime_type` text, `file_extn` text, `elaboration` text, `governance` text, `created_at` TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP, `created_by` text DEFAULT 'UNKNOWN', `updated_at` TIMESTAMPTZ, `updated_by` text, `deleted_at` TIMESTAMPTZ, `deleted_by` text, `activity_log` text, CONSTRAINT "elaboration_check_valid_json" CHECK(json_valid("code_notebook_kernel"."elaboration") OR "code_notebook_kernel"."elaboration" IS NULL), CONSTRAINT "governance_check_valid_json" CHECK(json_valid("code_notebook_kernel"."governance") OR "code_notebook_kernel"."governance" IS NULL) ) |
| code_notebook_kernel | created_by | TEXT | No | No | 'UNKNOWN' | console/info-schema/table.sql?name=code_notebook_kernel&stats=yes | [Content](console/info-schema/table.sql?name=code_notebook_kernel&stats=yes) | [code_notebook_kernel (table) Schema](console/info-schema/table.sql?name=code_notebook_kernel&stats=yes) | console/content/table/code_notebook_kernel.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/code_notebook_kernel.sql?stats=yes) | [code_notebook_kernel (table) Content](console/content/table/code_notebook_kernel.sql?stats=yes) | CREATE TABLE `code_notebook_kernel` ( `code_notebook_kernel_id` VARCHAR PRIMARY KEY NOT NULL, `kernel_name` text NOT NULL, `description` text, `mime_type` text, `file_extn` text, `elaboration` text, `governance` text, `created_at` TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP, `created_by` text DEFAULT 'UNKNOWN', `updated_at` TIMESTAMPTZ, `updated_by` text, `deleted_at` TIMESTAMPTZ, `deleted_by` text, `activity_log` text, CONSTRAINT "elaboration_check_valid_json" CHECK(json_valid("code_notebook_kernel"."elaboration") OR "code_notebook_kernel"."elaboration" IS NULL), CONSTRAINT "governance_check_valid_json" CHECK(json_valid("code_notebook_kernel"."governance") OR "code_notebook_kernel"."governance" IS NULL) ) |
| code_notebook_kernel | updated_at | TIMESTAMPTZ | No | No | console/info-schema/table.sql?name=code_notebook_kernel&stats=yes | [Content](console/info-schema/table.sql?name=code_notebook_kernel&stats=yes) | [code_notebook_kernel (table) Schema](console/info-schema/table.sql?name=code_notebook_kernel&stats=yes) | console/content/table/code_notebook_kernel.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/code_notebook_kernel.sql?stats=yes) | [code_notebook_kernel (table) Content](console/content/table/code_notebook_kernel.sql?stats=yes) | CREATE TABLE `code_notebook_kernel` ( `code_notebook_kernel_id` VARCHAR PRIMARY KEY NOT NULL, `kernel_name` text NOT NULL, `description` text, `mime_type` text, `file_extn` text, `elaboration` text, `governance` text, `created_at` TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP, `created_by` text DEFAULT 'UNKNOWN', `updated_at` TIMESTAMPTZ, `updated_by` text, `deleted_at` TIMESTAMPTZ, `deleted_by` text, `activity_log` text, CONSTRAINT "elaboration_check_valid_json" CHECK(json_valid("code_notebook_kernel"."elaboration") OR "code_notebook_kernel"."elaboration" IS NULL), CONSTRAINT "governance_check_valid_json" CHECK(json_valid("code_notebook_kernel"."governance") OR "code_notebook_kernel"."governance" IS NULL) ) | |
| code_notebook_kernel | updated_by | TEXT | No | No | console/info-schema/table.sql?name=code_notebook_kernel&stats=yes | [Content](console/info-schema/table.sql?name=code_notebook_kernel&stats=yes) | [code_notebook_kernel (table) Schema](console/info-schema/table.sql?name=code_notebook_kernel&stats=yes) | console/content/table/code_notebook_kernel.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/code_notebook_kernel.sql?stats=yes) | [code_notebook_kernel (table) Content](console/content/table/code_notebook_kernel.sql?stats=yes) | CREATE TABLE `code_notebook_kernel` ( `code_notebook_kernel_id` VARCHAR PRIMARY KEY NOT NULL, `kernel_name` text NOT NULL, `description` text, `mime_type` text, `file_extn` text, `elaboration` text, `governance` text, `created_at` TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP, `created_by` text DEFAULT 'UNKNOWN', `updated_at` TIMESTAMPTZ, `updated_by` text, `deleted_at` TIMESTAMPTZ, `deleted_by` text, `activity_log` text, CONSTRAINT "elaboration_check_valid_json" CHECK(json_valid("code_notebook_kernel"."elaboration") OR "code_notebook_kernel"."elaboration" IS NULL), CONSTRAINT "governance_check_valid_json" CHECK(json_valid("code_notebook_kernel"."governance") OR "code_notebook_kernel"."governance" IS NULL) ) | |
| code_notebook_kernel | deleted_at | TIMESTAMPTZ | No | No | console/info-schema/table.sql?name=code_notebook_kernel&stats=yes | [Content](console/info-schema/table.sql?name=code_notebook_kernel&stats=yes) | [code_notebook_kernel (table) Schema](console/info-schema/table.sql?name=code_notebook_kernel&stats=yes) | console/content/table/code_notebook_kernel.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/code_notebook_kernel.sql?stats=yes) | [code_notebook_kernel (table) Content](console/content/table/code_notebook_kernel.sql?stats=yes) | CREATE TABLE `code_notebook_kernel` ( `code_notebook_kernel_id` VARCHAR PRIMARY KEY NOT NULL, `kernel_name` text NOT NULL, `description` text, `mime_type` text, `file_extn` text, `elaboration` text, `governance` text, `created_at` TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP, `created_by` text DEFAULT 'UNKNOWN', `updated_at` TIMESTAMPTZ, `updated_by` text, `deleted_at` TIMESTAMPTZ, `deleted_by` text, `activity_log` text, CONSTRAINT "elaboration_check_valid_json" CHECK(json_valid("code_notebook_kernel"."elaboration") OR "code_notebook_kernel"."elaboration" IS NULL), CONSTRAINT "governance_check_valid_json" CHECK(json_valid("code_notebook_kernel"."governance") OR "code_notebook_kernel"."governance" IS NULL) ) | |
| code_notebook_kernel | deleted_by | TEXT | No | No | console/info-schema/table.sql?name=code_notebook_kernel&stats=yes | [Content](console/info-schema/table.sql?name=code_notebook_kernel&stats=yes) | [code_notebook_kernel (table) Schema](console/info-schema/table.sql?name=code_notebook_kernel&stats=yes) | console/content/table/code_notebook_kernel.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/code_notebook_kernel.sql?stats=yes) | [code_notebook_kernel (table) Content](console/content/table/code_notebook_kernel.sql?stats=yes) | CREATE TABLE `code_notebook_kernel` ( `code_notebook_kernel_id` VARCHAR PRIMARY KEY NOT NULL, `kernel_name` text NOT NULL, `description` text, `mime_type` text, `file_extn` text, `elaboration` text, `governance` text, `created_at` TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP, `created_by` text DEFAULT 'UNKNOWN', `updated_at` TIMESTAMPTZ, `updated_by` text, `deleted_at` TIMESTAMPTZ, `deleted_by` text, `activity_log` text, CONSTRAINT "elaboration_check_valid_json" CHECK(json_valid("code_notebook_kernel"."elaboration") OR "code_notebook_kernel"."elaboration" IS NULL), CONSTRAINT "governance_check_valid_json" CHECK(json_valid("code_notebook_kernel"."governance") OR "code_notebook_kernel"."governance" IS NULL) ) | |
| code_notebook_kernel | activity_log | TEXT | No | No | console/info-schema/table.sql?name=code_notebook_kernel&stats=yes | [Content](console/info-schema/table.sql?name=code_notebook_kernel&stats=yes) | [code_notebook_kernel (table) Schema](console/info-schema/table.sql?name=code_notebook_kernel&stats=yes) | console/content/table/code_notebook_kernel.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/code_notebook_kernel.sql?stats=yes) | [code_notebook_kernel (table) Content](console/content/table/code_notebook_kernel.sql?stats=yes) | CREATE TABLE `code_notebook_kernel` ( `code_notebook_kernel_id` VARCHAR PRIMARY KEY NOT NULL, `kernel_name` text NOT NULL, `description` text, `mime_type` text, `file_extn` text, `elaboration` text, `governance` text, `created_at` TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP, `created_by` text DEFAULT 'UNKNOWN', `updated_at` TIMESTAMPTZ, `updated_by` text, `deleted_at` TIMESTAMPTZ, `deleted_by` text, `activity_log` text, CONSTRAINT "elaboration_check_valid_json" CHECK(json_valid("code_notebook_kernel"."elaboration") OR "code_notebook_kernel"."elaboration" IS NULL), CONSTRAINT "governance_check_valid_json" CHECK(json_valid("code_notebook_kernel"."governance") OR "code_notebook_kernel"."governance" IS NULL) ) | |
| code_notebook_cell | code_notebook_cell_id | VARCHAR | Yes | Yes | console/info-schema/table.sql?name=code_notebook_cell&stats=yes | [Content](console/info-schema/table.sql?name=code_notebook_cell&stats=yes) | [code_notebook_cell (table) Schema](console/info-schema/table.sql?name=code_notebook_cell&stats=yes) | console/content/table/code_notebook_cell.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/code_notebook_cell.sql?stats=yes) | [code_notebook_cell (table) Content](console/content/table/code_notebook_cell.sql?stats=yes) | CREATE TABLE `code_notebook_cell` ( `code_notebook_cell_id` VARCHAR PRIMARY KEY NOT NULL, `notebook_kernel_id` VARCHAR NOT NULL, `notebook_name` text NOT NULL, `cell_name` text NOT NULL, `cell_governance` text, `interpretable_code` text NOT NULL, `interpretable_code_hash` text NOT NULL, `description` text, `arguments` text, `created_at` TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP, `created_by` text DEFAULT 'UNKNOWN', `updated_at` TIMESTAMPTZ, `updated_by` text, `deleted_at` TIMESTAMPTZ, `deleted_by` text, `activity_log` text, FOREIGN KEY (`notebook_kernel_id`) REFERENCES `code_notebook_kernel`(`code_notebook_kernel_id`) ON UPDATE no action ON DELETE no action, CONSTRAINT "cell_governance_check_valid_json" CHECK(json_valid("code_notebook_cell"."cell_governance") OR "code_notebook_cell"."cell_governance" IS NULL), CONSTRAINT "arguments_check_valid_json" CHECK(json_valid("code_notebook_cell"."arguments") OR "code_notebook_cell"."arguments" IS NULL) ) | |
| code_notebook_cell | notebook_kernel_id | VARCHAR | No | Yes | console/info-schema/table.sql?name=code_notebook_cell&stats=yes | [Content](console/info-schema/table.sql?name=code_notebook_cell&stats=yes) | [code_notebook_cell (table) Schema](console/info-schema/table.sql?name=code_notebook_cell&stats=yes) | console/content/table/code_notebook_cell.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/code_notebook_cell.sql?stats=yes) | [code_notebook_cell (table) Content](console/content/table/code_notebook_cell.sql?stats=yes) | CREATE TABLE `code_notebook_cell` ( `code_notebook_cell_id` VARCHAR PRIMARY KEY NOT NULL, `notebook_kernel_id` VARCHAR NOT NULL, `notebook_name` text NOT NULL, `cell_name` text NOT NULL, `cell_governance` text, `interpretable_code` text NOT NULL, `interpretable_code_hash` text NOT NULL, `description` text, `arguments` text, `created_at` TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP, `created_by` text DEFAULT 'UNKNOWN', `updated_at` TIMESTAMPTZ, `updated_by` text, `deleted_at` TIMESTAMPTZ, `deleted_by` text, `activity_log` text, FOREIGN KEY (`notebook_kernel_id`) REFERENCES `code_notebook_kernel`(`code_notebook_kernel_id`) ON UPDATE no action ON DELETE no action, CONSTRAINT "cell_governance_check_valid_json" CHECK(json_valid("code_notebook_cell"."cell_governance") OR "code_notebook_cell"."cell_governance" IS NULL), CONSTRAINT "arguments_check_valid_json" CHECK(json_valid("code_notebook_cell"."arguments") OR "code_notebook_cell"."arguments" IS NULL) ) | |
| code_notebook_cell | notebook_name | TEXT | No | Yes | console/info-schema/table.sql?name=code_notebook_cell&stats=yes | [Content](console/info-schema/table.sql?name=code_notebook_cell&stats=yes) | [code_notebook_cell (table) Schema](console/info-schema/table.sql?name=code_notebook_cell&stats=yes) | console/content/table/code_notebook_cell.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/code_notebook_cell.sql?stats=yes) | [code_notebook_cell (table) Content](console/content/table/code_notebook_cell.sql?stats=yes) | CREATE TABLE `code_notebook_cell` ( `code_notebook_cell_id` VARCHAR PRIMARY KEY NOT NULL, `notebook_kernel_id` VARCHAR NOT NULL, `notebook_name` text NOT NULL, `cell_name` text NOT NULL, `cell_governance` text, `interpretable_code` text NOT NULL, `interpretable_code_hash` text NOT NULL, `description` text, `arguments` text, `created_at` TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP, `created_by` text DEFAULT 'UNKNOWN', `updated_at` TIMESTAMPTZ, `updated_by` text, `deleted_at` TIMESTAMPTZ, `deleted_by` text, `activity_log` text, FOREIGN KEY (`notebook_kernel_id`) REFERENCES `code_notebook_kernel`(`code_notebook_kernel_id`) ON UPDATE no action ON DELETE no action, CONSTRAINT "cell_governance_check_valid_json" CHECK(json_valid("code_notebook_cell"."cell_governance") OR "code_notebook_cell"."cell_governance" IS NULL), CONSTRAINT "arguments_check_valid_json" CHECK(json_valid("code_notebook_cell"."arguments") OR "code_notebook_cell"."arguments" IS NULL) ) | |
| code_notebook_cell | cell_name | TEXT | No | Yes | console/info-schema/table.sql?name=code_notebook_cell&stats=yes | [Content](console/info-schema/table.sql?name=code_notebook_cell&stats=yes) | [code_notebook_cell (table) Schema](console/info-schema/table.sql?name=code_notebook_cell&stats=yes) | console/content/table/code_notebook_cell.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/code_notebook_cell.sql?stats=yes) | [code_notebook_cell (table) Content](console/content/table/code_notebook_cell.sql?stats=yes) | CREATE TABLE `code_notebook_cell` ( `code_notebook_cell_id` VARCHAR PRIMARY KEY NOT NULL, `notebook_kernel_id` VARCHAR NOT NULL, `notebook_name` text NOT NULL, `cell_name` text NOT NULL, `cell_governance` text, `interpretable_code` text NOT NULL, `interpretable_code_hash` text NOT NULL, `description` text, `arguments` text, `created_at` TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP, `created_by` text DEFAULT 'UNKNOWN', `updated_at` TIMESTAMPTZ, `updated_by` text, `deleted_at` TIMESTAMPTZ, `deleted_by` text, `activity_log` text, FOREIGN KEY (`notebook_kernel_id`) REFERENCES `code_notebook_kernel`(`code_notebook_kernel_id`) ON UPDATE no action ON DELETE no action, CONSTRAINT "cell_governance_check_valid_json" CHECK(json_valid("code_notebook_cell"."cell_governance") OR "code_notebook_cell"."cell_governance" IS NULL), CONSTRAINT "arguments_check_valid_json" CHECK(json_valid("code_notebook_cell"."arguments") OR "code_notebook_cell"."arguments" IS NULL) ) | |
| code_notebook_cell | cell_governance | TEXT | No | No | console/info-schema/table.sql?name=code_notebook_cell&stats=yes | [Content](console/info-schema/table.sql?name=code_notebook_cell&stats=yes) | [code_notebook_cell (table) Schema](console/info-schema/table.sql?name=code_notebook_cell&stats=yes) | console/content/table/code_notebook_cell.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/code_notebook_cell.sql?stats=yes) | [code_notebook_cell (table) Content](console/content/table/code_notebook_cell.sql?stats=yes) | CREATE TABLE `code_notebook_cell` ( `code_notebook_cell_id` VARCHAR PRIMARY KEY NOT NULL, `notebook_kernel_id` VARCHAR NOT NULL, `notebook_name` text NOT NULL, `cell_name` text NOT NULL, `cell_governance` text, `interpretable_code` text NOT NULL, `interpretable_code_hash` text NOT NULL, `description` text, `arguments` text, `created_at` TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP, `created_by` text DEFAULT 'UNKNOWN', `updated_at` TIMESTAMPTZ, `updated_by` text, `deleted_at` TIMESTAMPTZ, `deleted_by` text, `activity_log` text, FOREIGN KEY (`notebook_kernel_id`) REFERENCES `code_notebook_kernel`(`code_notebook_kernel_id`) ON UPDATE no action ON DELETE no action, CONSTRAINT "cell_governance_check_valid_json" CHECK(json_valid("code_notebook_cell"."cell_governance") OR "code_notebook_cell"."cell_governance" IS NULL), CONSTRAINT "arguments_check_valid_json" CHECK(json_valid("code_notebook_cell"."arguments") OR "code_notebook_cell"."arguments" IS NULL) ) | |
| code_notebook_cell | interpretable_code | TEXT | No | Yes | console/info-schema/table.sql?name=code_notebook_cell&stats=yes | [Content](console/info-schema/table.sql?name=code_notebook_cell&stats=yes) | [code_notebook_cell (table) Schema](console/info-schema/table.sql?name=code_notebook_cell&stats=yes) | console/content/table/code_notebook_cell.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/code_notebook_cell.sql?stats=yes) | [code_notebook_cell (table) Content](console/content/table/code_notebook_cell.sql?stats=yes) | CREATE TABLE `code_notebook_cell` ( `code_notebook_cell_id` VARCHAR PRIMARY KEY NOT NULL, `notebook_kernel_id` VARCHAR NOT NULL, `notebook_name` text NOT NULL, `cell_name` text NOT NULL, `cell_governance` text, `interpretable_code` text NOT NULL, `interpretable_code_hash` text NOT NULL, `description` text, `arguments` text, `created_at` TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP, `created_by` text DEFAULT 'UNKNOWN', `updated_at` TIMESTAMPTZ, `updated_by` text, `deleted_at` TIMESTAMPTZ, `deleted_by` text, `activity_log` text, FOREIGN KEY (`notebook_kernel_id`) REFERENCES `code_notebook_kernel`(`code_notebook_kernel_id`) ON UPDATE no action ON DELETE no action, CONSTRAINT "cell_governance_check_valid_json" CHECK(json_valid("code_notebook_cell"."cell_governance") OR "code_notebook_cell"."cell_governance" IS NULL), CONSTRAINT "arguments_check_valid_json" CHECK(json_valid("code_notebook_cell"."arguments") OR "code_notebook_cell"."arguments" IS NULL) ) | |
| code_notebook_cell | interpretable_code_hash | TEXT | No | Yes | console/info-schema/table.sql?name=code_notebook_cell&stats=yes | [Content](console/info-schema/table.sql?name=code_notebook_cell&stats=yes) | [code_notebook_cell (table) Schema](console/info-schema/table.sql?name=code_notebook_cell&stats=yes) | console/content/table/code_notebook_cell.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/code_notebook_cell.sql?stats=yes) | [code_notebook_cell (table) Content](console/content/table/code_notebook_cell.sql?stats=yes) | CREATE TABLE `code_notebook_cell` ( `code_notebook_cell_id` VARCHAR PRIMARY KEY NOT NULL, `notebook_kernel_id` VARCHAR NOT NULL, `notebook_name` text NOT NULL, `cell_name` text NOT NULL, `cell_governance` text, `interpretable_code` text NOT NULL, `interpretable_code_hash` text NOT NULL, `description` text, `arguments` text, `created_at` TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP, `created_by` text DEFAULT 'UNKNOWN', `updated_at` TIMESTAMPTZ, `updated_by` text, `deleted_at` TIMESTAMPTZ, `deleted_by` text, `activity_log` text, FOREIGN KEY (`notebook_kernel_id`) REFERENCES `code_notebook_kernel`(`code_notebook_kernel_id`) ON UPDATE no action ON DELETE no action, CONSTRAINT "cell_governance_check_valid_json" CHECK(json_valid("code_notebook_cell"."cell_governance") OR "code_notebook_cell"."cell_governance" IS NULL), CONSTRAINT "arguments_check_valid_json" CHECK(json_valid("code_notebook_cell"."arguments") OR "code_notebook_cell"."arguments" IS NULL) ) | |
| code_notebook_cell | description | TEXT | No | No | console/info-schema/table.sql?name=code_notebook_cell&stats=yes | [Content](console/info-schema/table.sql?name=code_notebook_cell&stats=yes) | [code_notebook_cell (table) Schema](console/info-schema/table.sql?name=code_notebook_cell&stats=yes) | console/content/table/code_notebook_cell.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/code_notebook_cell.sql?stats=yes) | [code_notebook_cell (table) Content](console/content/table/code_notebook_cell.sql?stats=yes) | CREATE TABLE `code_notebook_cell` ( `code_notebook_cell_id` VARCHAR PRIMARY KEY NOT NULL, `notebook_kernel_id` VARCHAR NOT NULL, `notebook_name` text NOT NULL, `cell_name` text NOT NULL, `cell_governance` text, `interpretable_code` text NOT NULL, `interpretable_code_hash` text NOT NULL, `description` text, `arguments` text, `created_at` TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP, `created_by` text DEFAULT 'UNKNOWN', `updated_at` TIMESTAMPTZ, `updated_by` text, `deleted_at` TIMESTAMPTZ, `deleted_by` text, `activity_log` text, FOREIGN KEY (`notebook_kernel_id`) REFERENCES `code_notebook_kernel`(`code_notebook_kernel_id`) ON UPDATE no action ON DELETE no action, CONSTRAINT "cell_governance_check_valid_json" CHECK(json_valid("code_notebook_cell"."cell_governance") OR "code_notebook_cell"."cell_governance" IS NULL), CONSTRAINT "arguments_check_valid_json" CHECK(json_valid("code_notebook_cell"."arguments") OR "code_notebook_cell"."arguments" IS NULL) ) |
Error in query number 6
We are sorry, but an error occurred while generating this page. You should contact the site's administrator.
Parsing failed: SQLPage couldn't understand the SQL file. Please check for syntax errors:
SELECT 'text' AS component,
(SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE ' END) || ' ' ||
⬆️
'(Page ' || $current_page || ' of ' || $total_pages || ') ' ||
Backtrace
sql parser error: Expected: ), found: $current_page at Line: 42, Column: 35"console/content/view/console_information_schema_table.auto.sql" contains a syntax error preventing SQLPage from parsing and preparing its SQL statements.Note: You can hide error messages like this one from your users by setting the 'environment' configuration option to 'production'.