console_information_schema_table (view) Content
| code_notebook_state | transition_reason | TEXT | No | No | console/info-schema/table.sql?name=code_notebook_state&stats=yes | [Content](console/info-schema/table.sql?name=code_notebook_state&stats=yes) | [code_notebook_state (table) Schema](console/info-schema/table.sql?name=code_notebook_state&stats=yes) | console/content/table/code_notebook_state.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/code_notebook_state.sql?stats=yes) | [code_notebook_state (table) Content](console/content/table/code_notebook_state.sql?stats=yes) | CREATE TABLE "code_notebook_state" ( "code_notebook_state_id" VARCHAR PRIMARY KEY NOT NULL, "code_notebook_cell_id" VARCHAR NOT NULL, "from_state" TEXT NOT NULL, "to_state" TEXT NOT NULL, "transition_result" TEXT CHECK(json_valid(transition_result) OR transition_result IS NULL), "transition_reason" TEXT, "transitioned_at" TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP, "elaboration" TEXT CHECK(json_valid(elaboration) OR elaboration IS NULL), "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("code_notebook_cell_id") REFERENCES "code_notebook_cell"("code_notebook_cell_id"), UNIQUE("code_notebook_cell_id", "from_state", "to_state") ) | |
| code_notebook_state | transitioned_at | TIMESTAMPTZ | No | No | CURRENT_TIMESTAMP | console/info-schema/table.sql?name=code_notebook_state&stats=yes | [Content](console/info-schema/table.sql?name=code_notebook_state&stats=yes) | [code_notebook_state (table) Schema](console/info-schema/table.sql?name=code_notebook_state&stats=yes) | console/content/table/code_notebook_state.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/code_notebook_state.sql?stats=yes) | [code_notebook_state (table) Content](console/content/table/code_notebook_state.sql?stats=yes) | CREATE TABLE "code_notebook_state" ( "code_notebook_state_id" VARCHAR PRIMARY KEY NOT NULL, "code_notebook_cell_id" VARCHAR NOT NULL, "from_state" TEXT NOT NULL, "to_state" TEXT NOT NULL, "transition_result" TEXT CHECK(json_valid(transition_result) OR transition_result IS NULL), "transition_reason" TEXT, "transitioned_at" TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP, "elaboration" TEXT CHECK(json_valid(elaboration) OR elaboration IS NULL), "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("code_notebook_cell_id") REFERENCES "code_notebook_cell"("code_notebook_cell_id"), UNIQUE("code_notebook_cell_id", "from_state", "to_state") ) |
| code_notebook_state | elaboration | TEXT | No | No | console/info-schema/table.sql?name=code_notebook_state&stats=yes | [Content](console/info-schema/table.sql?name=code_notebook_state&stats=yes) | [code_notebook_state (table) Schema](console/info-schema/table.sql?name=code_notebook_state&stats=yes) | console/content/table/code_notebook_state.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/code_notebook_state.sql?stats=yes) | [code_notebook_state (table) Content](console/content/table/code_notebook_state.sql?stats=yes) | CREATE TABLE "code_notebook_state" ( "code_notebook_state_id" VARCHAR PRIMARY KEY NOT NULL, "code_notebook_cell_id" VARCHAR NOT NULL, "from_state" TEXT NOT NULL, "to_state" TEXT NOT NULL, "transition_result" TEXT CHECK(json_valid(transition_result) OR transition_result IS NULL), "transition_reason" TEXT, "transitioned_at" TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP, "elaboration" TEXT CHECK(json_valid(elaboration) OR elaboration IS NULL), "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("code_notebook_cell_id") REFERENCES "code_notebook_cell"("code_notebook_cell_id"), UNIQUE("code_notebook_cell_id", "from_state", "to_state") ) | |
| code_notebook_state | created_at | TIMESTAMPTZ | No | No | CURRENT_TIMESTAMP | console/info-schema/table.sql?name=code_notebook_state&stats=yes | [Content](console/info-schema/table.sql?name=code_notebook_state&stats=yes) | [code_notebook_state (table) Schema](console/info-schema/table.sql?name=code_notebook_state&stats=yes) | console/content/table/code_notebook_state.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/code_notebook_state.sql?stats=yes) | [code_notebook_state (table) Content](console/content/table/code_notebook_state.sql?stats=yes) | CREATE TABLE "code_notebook_state" ( "code_notebook_state_id" VARCHAR PRIMARY KEY NOT NULL, "code_notebook_cell_id" VARCHAR NOT NULL, "from_state" TEXT NOT NULL, "to_state" TEXT NOT NULL, "transition_result" TEXT CHECK(json_valid(transition_result) OR transition_result IS NULL), "transition_reason" TEXT, "transitioned_at" TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP, "elaboration" TEXT CHECK(json_valid(elaboration) OR elaboration IS NULL), "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("code_notebook_cell_id") REFERENCES "code_notebook_cell"("code_notebook_cell_id"), UNIQUE("code_notebook_cell_id", "from_state", "to_state") ) |
| code_notebook_state | created_by | TEXT | No | No | 'UNKNOWN' | console/info-schema/table.sql?name=code_notebook_state&stats=yes | [Content](console/info-schema/table.sql?name=code_notebook_state&stats=yes) | [code_notebook_state (table) Schema](console/info-schema/table.sql?name=code_notebook_state&stats=yes) | console/content/table/code_notebook_state.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/code_notebook_state.sql?stats=yes) | [code_notebook_state (table) Content](console/content/table/code_notebook_state.sql?stats=yes) | CREATE TABLE "code_notebook_state" ( "code_notebook_state_id" VARCHAR PRIMARY KEY NOT NULL, "code_notebook_cell_id" VARCHAR NOT NULL, "from_state" TEXT NOT NULL, "to_state" TEXT NOT NULL, "transition_result" TEXT CHECK(json_valid(transition_result) OR transition_result IS NULL), "transition_reason" TEXT, "transitioned_at" TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP, "elaboration" TEXT CHECK(json_valid(elaboration) OR elaboration IS NULL), "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("code_notebook_cell_id") REFERENCES "code_notebook_cell"("code_notebook_cell_id"), UNIQUE("code_notebook_cell_id", "from_state", "to_state") ) |
| code_notebook_state | updated_at | TIMESTAMPTZ | No | No | console/info-schema/table.sql?name=code_notebook_state&stats=yes | [Content](console/info-schema/table.sql?name=code_notebook_state&stats=yes) | [code_notebook_state (table) Schema](console/info-schema/table.sql?name=code_notebook_state&stats=yes) | console/content/table/code_notebook_state.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/code_notebook_state.sql?stats=yes) | [code_notebook_state (table) Content](console/content/table/code_notebook_state.sql?stats=yes) | CREATE TABLE "code_notebook_state" ( "code_notebook_state_id" VARCHAR PRIMARY KEY NOT NULL, "code_notebook_cell_id" VARCHAR NOT NULL, "from_state" TEXT NOT NULL, "to_state" TEXT NOT NULL, "transition_result" TEXT CHECK(json_valid(transition_result) OR transition_result IS NULL), "transition_reason" TEXT, "transitioned_at" TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP, "elaboration" TEXT CHECK(json_valid(elaboration) OR elaboration IS NULL), "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("code_notebook_cell_id") REFERENCES "code_notebook_cell"("code_notebook_cell_id"), UNIQUE("code_notebook_cell_id", "from_state", "to_state") ) | |
| code_notebook_state | updated_by | TEXT | No | No | console/info-schema/table.sql?name=code_notebook_state&stats=yes | [Content](console/info-schema/table.sql?name=code_notebook_state&stats=yes) | [code_notebook_state (table) Schema](console/info-schema/table.sql?name=code_notebook_state&stats=yes) | console/content/table/code_notebook_state.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/code_notebook_state.sql?stats=yes) | [code_notebook_state (table) Content](console/content/table/code_notebook_state.sql?stats=yes) | CREATE TABLE "code_notebook_state" ( "code_notebook_state_id" VARCHAR PRIMARY KEY NOT NULL, "code_notebook_cell_id" VARCHAR NOT NULL, "from_state" TEXT NOT NULL, "to_state" TEXT NOT NULL, "transition_result" TEXT CHECK(json_valid(transition_result) OR transition_result IS NULL), "transition_reason" TEXT, "transitioned_at" TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP, "elaboration" TEXT CHECK(json_valid(elaboration) OR elaboration IS NULL), "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("code_notebook_cell_id") REFERENCES "code_notebook_cell"("code_notebook_cell_id"), UNIQUE("code_notebook_cell_id", "from_state", "to_state") ) | |
| code_notebook_state | deleted_at | TIMESTAMPTZ | No | No | console/info-schema/table.sql?name=code_notebook_state&stats=yes | [Content](console/info-schema/table.sql?name=code_notebook_state&stats=yes) | [code_notebook_state (table) Schema](console/info-schema/table.sql?name=code_notebook_state&stats=yes) | console/content/table/code_notebook_state.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/code_notebook_state.sql?stats=yes) | [code_notebook_state (table) Content](console/content/table/code_notebook_state.sql?stats=yes) | CREATE TABLE "code_notebook_state" ( "code_notebook_state_id" VARCHAR PRIMARY KEY NOT NULL, "code_notebook_cell_id" VARCHAR NOT NULL, "from_state" TEXT NOT NULL, "to_state" TEXT NOT NULL, "transition_result" TEXT CHECK(json_valid(transition_result) OR transition_result IS NULL), "transition_reason" TEXT, "transitioned_at" TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP, "elaboration" TEXT CHECK(json_valid(elaboration) OR elaboration IS NULL), "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("code_notebook_cell_id") REFERENCES "code_notebook_cell"("code_notebook_cell_id"), UNIQUE("code_notebook_cell_id", "from_state", "to_state") ) | |
| code_notebook_state | deleted_by | TEXT | No | No | console/info-schema/table.sql?name=code_notebook_state&stats=yes | [Content](console/info-schema/table.sql?name=code_notebook_state&stats=yes) | [code_notebook_state (table) Schema](console/info-schema/table.sql?name=code_notebook_state&stats=yes) | console/content/table/code_notebook_state.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/code_notebook_state.sql?stats=yes) | [code_notebook_state (table) Content](console/content/table/code_notebook_state.sql?stats=yes) | CREATE TABLE "code_notebook_state" ( "code_notebook_state_id" VARCHAR PRIMARY KEY NOT NULL, "code_notebook_cell_id" VARCHAR NOT NULL, "from_state" TEXT NOT NULL, "to_state" TEXT NOT NULL, "transition_result" TEXT CHECK(json_valid(transition_result) OR transition_result IS NULL), "transition_reason" TEXT, "transitioned_at" TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP, "elaboration" TEXT CHECK(json_valid(elaboration) OR elaboration IS NULL), "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("code_notebook_cell_id") REFERENCES "code_notebook_cell"("code_notebook_cell_id"), UNIQUE("code_notebook_cell_id", "from_state", "to_state") ) | |
| code_notebook_state | activity_log | TEXT | No | No | console/info-schema/table.sql?name=code_notebook_state&stats=yes | [Content](console/info-schema/table.sql?name=code_notebook_state&stats=yes) | [code_notebook_state (table) Schema](console/info-schema/table.sql?name=code_notebook_state&stats=yes) | console/content/table/code_notebook_state.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/code_notebook_state.sql?stats=yes) | [code_notebook_state (table) Content](console/content/table/code_notebook_state.sql?stats=yes) | CREATE TABLE "code_notebook_state" ( "code_notebook_state_id" VARCHAR PRIMARY KEY NOT NULL, "code_notebook_cell_id" VARCHAR NOT NULL, "from_state" TEXT NOT NULL, "to_state" TEXT NOT NULL, "transition_result" TEXT CHECK(json_valid(transition_result) OR transition_result IS NULL), "transition_reason" TEXT, "transitioned_at" TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP, "elaboration" TEXT CHECK(json_valid(elaboration) OR elaboration IS NULL), "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("code_notebook_cell_id") REFERENCES "code_notebook_cell"("code_notebook_cell_id"), UNIQUE("code_notebook_cell_id", "from_state", "to_state") ) | |
| surveilr_function_doc | name | TEXT | Yes | No | console/info-schema/table.sql?name=surveilr_function_doc&stats=yes | [Content](console/info-schema/table.sql?name=surveilr_function_doc&stats=yes) | [surveilr_function_doc (table) Schema](console/info-schema/table.sql?name=surveilr_function_doc&stats=yes) | console/content/table/surveilr_function_doc.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/surveilr_function_doc.sql?stats=yes) | [surveilr_function_doc (table) Content](console/content/table/surveilr_function_doc.sql?stats=yes) | CREATE TABLE surveilr_function_doc ( name TEXT PRIMARY KEY, description TEXT, parameters JSON, return_type TEXT, version TEXT ) | |
| surveilr_function_doc | description | TEXT | No | No | console/info-schema/table.sql?name=surveilr_function_doc&stats=yes | [Content](console/info-schema/table.sql?name=surveilr_function_doc&stats=yes) | [surveilr_function_doc (table) Schema](console/info-schema/table.sql?name=surveilr_function_doc&stats=yes) | console/content/table/surveilr_function_doc.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/surveilr_function_doc.sql?stats=yes) | [surveilr_function_doc (table) Content](console/content/table/surveilr_function_doc.sql?stats=yes) | CREATE TABLE surveilr_function_doc ( name TEXT PRIMARY KEY, description TEXT, parameters JSON, return_type TEXT, version TEXT ) | |
| surveilr_function_doc | parameters | JSON | No | No | console/info-schema/table.sql?name=surveilr_function_doc&stats=yes | [Content](console/info-schema/table.sql?name=surveilr_function_doc&stats=yes) | [surveilr_function_doc (table) Schema](console/info-schema/table.sql?name=surveilr_function_doc&stats=yes) | console/content/table/surveilr_function_doc.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/surveilr_function_doc.sql?stats=yes) | [surveilr_function_doc (table) Content](console/content/table/surveilr_function_doc.sql?stats=yes) | CREATE TABLE surveilr_function_doc ( name TEXT PRIMARY KEY, description TEXT, parameters JSON, return_type TEXT, version TEXT ) | |
| surveilr_function_doc | return_type | TEXT | No | No | console/info-schema/table.sql?name=surveilr_function_doc&stats=yes | [Content](console/info-schema/table.sql?name=surveilr_function_doc&stats=yes) | [surveilr_function_doc (table) Schema](console/info-schema/table.sql?name=surveilr_function_doc&stats=yes) | console/content/table/surveilr_function_doc.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/surveilr_function_doc.sql?stats=yes) | [surveilr_function_doc (table) Content](console/content/table/surveilr_function_doc.sql?stats=yes) | CREATE TABLE surveilr_function_doc ( name TEXT PRIMARY KEY, description TEXT, parameters JSON, return_type TEXT, version TEXT ) | |
| surveilr_function_doc | version | TEXT | No | No | console/info-schema/table.sql?name=surveilr_function_doc&stats=yes | [Content](console/info-schema/table.sql?name=surveilr_function_doc&stats=yes) | [surveilr_function_doc (table) Schema](console/info-schema/table.sql?name=surveilr_function_doc&stats=yes) | console/content/table/surveilr_function_doc.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/surveilr_function_doc.sql?stats=yes) | [surveilr_function_doc (table) Content](console/content/table/surveilr_function_doc.sql?stats=yes) | CREATE TABLE surveilr_function_doc ( name TEXT PRIMARY KEY, description TEXT, parameters JSON, return_type TEXT, version TEXT ) | |
| sqlpage_files | path | VARCHAR | Yes | Yes | console/info-schema/table.sql?name=sqlpage_files&stats=yes | [Content](console/info-schema/table.sql?name=sqlpage_files&stats=yes) | [sqlpage_files (table) Schema](console/info-schema/table.sql?name=sqlpage_files&stats=yes) | console/content/table/sqlpage_files.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/sqlpage_files.sql?stats=yes) | [sqlpage_files (table) Content](console/content/table/sqlpage_files.sql?stats=yes) | CREATE TABLE "sqlpage_files" ( "path" VARCHAR PRIMARY KEY NOT NULL, "contents" TEXT NOT NULL, "last_modified" TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP ) | |
| sqlpage_files | contents | TEXT | No | Yes | console/info-schema/table.sql?name=sqlpage_files&stats=yes | [Content](console/info-schema/table.sql?name=sqlpage_files&stats=yes) | [sqlpage_files (table) Schema](console/info-schema/table.sql?name=sqlpage_files&stats=yes) | console/content/table/sqlpage_files.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/sqlpage_files.sql?stats=yes) | [sqlpage_files (table) Content](console/content/table/sqlpage_files.sql?stats=yes) | CREATE TABLE "sqlpage_files" ( "path" VARCHAR PRIMARY KEY NOT NULL, "contents" TEXT NOT NULL, "last_modified" TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP ) | |
| sqlpage_files | last_modified | TIMESTAMPTZ | No | No | CURRENT_TIMESTAMP | console/info-schema/table.sql?name=sqlpage_files&stats=yes | [Content](console/info-schema/table.sql?name=sqlpage_files&stats=yes) | [sqlpage_files (table) Schema](console/info-schema/table.sql?name=sqlpage_files&stats=yes) | console/content/table/sqlpage_files.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/sqlpage_files.sql?stats=yes) | [sqlpage_files (table) Content](console/content/table/sqlpage_files.sql?stats=yes) | CREATE TABLE "sqlpage_files" ( "path" VARCHAR PRIMARY KEY NOT NULL, "contents" TEXT NOT NULL, "last_modified" TIMESTAMPTZ DEFAULT CURRENT_TIMESTAMP ) |
| sqlpage_aide_navigation | path | TEXT | No | Yes | console/info-schema/table.sql?name=sqlpage_aide_navigation&stats=yes | [Content](console/info-schema/table.sql?name=sqlpage_aide_navigation&stats=yes) | [sqlpage_aide_navigation (table) Schema](console/info-schema/table.sql?name=sqlpage_aide_navigation&stats=yes) | console/content/table/sqlpage_aide_navigation.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/sqlpage_aide_navigation.sql?stats=yes) | [sqlpage_aide_navigation (table) Content](console/content/table/sqlpage_aide_navigation.sql?stats=yes) | CREATE TABLE sqlpage_aide_navigation ( path TEXT NOT NULL, -- the "primary key" within namespace caption TEXT NOT NULL, -- for human-friendly general-purpose name namespace TEXT NOT NULL, -- if more than one navigation tree is required parent_path TEXT, -- for defining hierarchy sibling_order INTEGER, -- orders children within their parent(s) url TEXT, -- for supplying links, if different from path title TEXT, -- for full titles when elaboration is required, default to caption if NULL abbreviated_caption TEXT, -- for breadcrumbs and other "short" form, default to caption if NULL description TEXT, -- for elaboration or explanation elaboration TEXT, -- optional attributes for e.g. { "target": "__blank" } -- TODO: figure out why Rusqlite does not allow this but sqlite3 does -- CONSTRAINT fk_parent_path FOREIGN KEY (namespace, parent_path) REFERENCES sqlpage_aide_navigation(namespace, path), CONSTRAINT unq_ns_path UNIQUE (namespace, parent_path, path) ) | |
| sqlpage_aide_navigation | caption | TEXT | No | Yes | console/info-schema/table.sql?name=sqlpage_aide_navigation&stats=yes | [Content](console/info-schema/table.sql?name=sqlpage_aide_navigation&stats=yes) | [sqlpage_aide_navigation (table) Schema](console/info-schema/table.sql?name=sqlpage_aide_navigation&stats=yes) | console/content/table/sqlpage_aide_navigation.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/sqlpage_aide_navigation.sql?stats=yes) | [sqlpage_aide_navigation (table) Content](console/content/table/sqlpage_aide_navigation.sql?stats=yes) | CREATE TABLE sqlpage_aide_navigation ( path TEXT NOT NULL, -- the "primary key" within namespace caption TEXT NOT NULL, -- for human-friendly general-purpose name namespace TEXT NOT NULL, -- if more than one navigation tree is required parent_path TEXT, -- for defining hierarchy sibling_order INTEGER, -- orders children within their parent(s) url TEXT, -- for supplying links, if different from path title TEXT, -- for full titles when elaboration is required, default to caption if NULL abbreviated_caption TEXT, -- for breadcrumbs and other "short" form, default to caption if NULL description TEXT, -- for elaboration or explanation elaboration TEXT, -- optional attributes for e.g. { "target": "__blank" } -- TODO: figure out why Rusqlite does not allow this but sqlite3 does -- CONSTRAINT fk_parent_path FOREIGN KEY (namespace, parent_path) REFERENCES sqlpage_aide_navigation(namespace, path), CONSTRAINT unq_ns_path UNIQUE (namespace, parent_path, path) ) | |
| sqlpage_aide_navigation | namespace | TEXT | No | Yes | console/info-schema/table.sql?name=sqlpage_aide_navigation&stats=yes | [Content](console/info-schema/table.sql?name=sqlpage_aide_navigation&stats=yes) | [sqlpage_aide_navigation (table) Schema](console/info-schema/table.sql?name=sqlpage_aide_navigation&stats=yes) | console/content/table/sqlpage_aide_navigation.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/sqlpage_aide_navigation.sql?stats=yes) | [sqlpage_aide_navigation (table) Content](console/content/table/sqlpage_aide_navigation.sql?stats=yes) | CREATE TABLE sqlpage_aide_navigation ( path TEXT NOT NULL, -- the "primary key" within namespace caption TEXT NOT NULL, -- for human-friendly general-purpose name namespace TEXT NOT NULL, -- if more than one navigation tree is required parent_path TEXT, -- for defining hierarchy sibling_order INTEGER, -- orders children within their parent(s) url TEXT, -- for supplying links, if different from path title TEXT, -- for full titles when elaboration is required, default to caption if NULL abbreviated_caption TEXT, -- for breadcrumbs and other "short" form, default to caption if NULL description TEXT, -- for elaboration or explanation elaboration TEXT, -- optional attributes for e.g. { "target": "__blank" } -- TODO: figure out why Rusqlite does not allow this but sqlite3 does -- CONSTRAINT fk_parent_path FOREIGN KEY (namespace, parent_path) REFERENCES sqlpage_aide_navigation(namespace, path), CONSTRAINT unq_ns_path UNIQUE (namespace, parent_path, path) ) | |
| sqlpage_aide_navigation | parent_path | TEXT | No | No | console/info-schema/table.sql?name=sqlpage_aide_navigation&stats=yes | [Content](console/info-schema/table.sql?name=sqlpage_aide_navigation&stats=yes) | [sqlpage_aide_navigation (table) Schema](console/info-schema/table.sql?name=sqlpage_aide_navigation&stats=yes) | console/content/table/sqlpage_aide_navigation.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/sqlpage_aide_navigation.sql?stats=yes) | [sqlpage_aide_navigation (table) Content](console/content/table/sqlpage_aide_navigation.sql?stats=yes) | CREATE TABLE sqlpage_aide_navigation ( path TEXT NOT NULL, -- the "primary key" within namespace caption TEXT NOT NULL, -- for human-friendly general-purpose name namespace TEXT NOT NULL, -- if more than one navigation tree is required parent_path TEXT, -- for defining hierarchy sibling_order INTEGER, -- orders children within their parent(s) url TEXT, -- for supplying links, if different from path title TEXT, -- for full titles when elaboration is required, default to caption if NULL abbreviated_caption TEXT, -- for breadcrumbs and other "short" form, default to caption if NULL description TEXT, -- for elaboration or explanation elaboration TEXT, -- optional attributes for e.g. { "target": "__blank" } -- TODO: figure out why Rusqlite does not allow this but sqlite3 does -- CONSTRAINT fk_parent_path FOREIGN KEY (namespace, parent_path) REFERENCES sqlpage_aide_navigation(namespace, path), CONSTRAINT unq_ns_path UNIQUE (namespace, parent_path, path) ) | |
| sqlpage_aide_navigation | sibling_order | INTEGER | No | No | console/info-schema/table.sql?name=sqlpage_aide_navigation&stats=yes | [Content](console/info-schema/table.sql?name=sqlpage_aide_navigation&stats=yes) | [sqlpage_aide_navigation (table) Schema](console/info-schema/table.sql?name=sqlpage_aide_navigation&stats=yes) | console/content/table/sqlpage_aide_navigation.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/sqlpage_aide_navigation.sql?stats=yes) | [sqlpage_aide_navigation (table) Content](console/content/table/sqlpage_aide_navigation.sql?stats=yes) | CREATE TABLE sqlpage_aide_navigation ( path TEXT NOT NULL, -- the "primary key" within namespace caption TEXT NOT NULL, -- for human-friendly general-purpose name namespace TEXT NOT NULL, -- if more than one navigation tree is required parent_path TEXT, -- for defining hierarchy sibling_order INTEGER, -- orders children within their parent(s) url TEXT, -- for supplying links, if different from path title TEXT, -- for full titles when elaboration is required, default to caption if NULL abbreviated_caption TEXT, -- for breadcrumbs and other "short" form, default to caption if NULL description TEXT, -- for elaboration or explanation elaboration TEXT, -- optional attributes for e.g. { "target": "__blank" } -- TODO: figure out why Rusqlite does not allow this but sqlite3 does -- CONSTRAINT fk_parent_path FOREIGN KEY (namespace, parent_path) REFERENCES sqlpage_aide_navigation(namespace, path), CONSTRAINT unq_ns_path UNIQUE (namespace, parent_path, path) ) | |
| sqlpage_aide_navigation | url | TEXT | No | No | console/info-schema/table.sql?name=sqlpage_aide_navigation&stats=yes | [Content](console/info-schema/table.sql?name=sqlpage_aide_navigation&stats=yes) | [sqlpage_aide_navigation (table) Schema](console/info-schema/table.sql?name=sqlpage_aide_navigation&stats=yes) | console/content/table/sqlpage_aide_navigation.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/sqlpage_aide_navigation.sql?stats=yes) | [sqlpage_aide_navigation (table) Content](console/content/table/sqlpage_aide_navigation.sql?stats=yes) | CREATE TABLE sqlpage_aide_navigation ( path TEXT NOT NULL, -- the "primary key" within namespace caption TEXT NOT NULL, -- for human-friendly general-purpose name namespace TEXT NOT NULL, -- if more than one navigation tree is required parent_path TEXT, -- for defining hierarchy sibling_order INTEGER, -- orders children within their parent(s) url TEXT, -- for supplying links, if different from path title TEXT, -- for full titles when elaboration is required, default to caption if NULL abbreviated_caption TEXT, -- for breadcrumbs and other "short" form, default to caption if NULL description TEXT, -- for elaboration or explanation elaboration TEXT, -- optional attributes for e.g. { "target": "__blank" } -- TODO: figure out why Rusqlite does not allow this but sqlite3 does -- CONSTRAINT fk_parent_path FOREIGN KEY (namespace, parent_path) REFERENCES sqlpage_aide_navigation(namespace, path), CONSTRAINT unq_ns_path UNIQUE (namespace, parent_path, path) ) | |
| sqlpage_aide_navigation | title | TEXT | No | No | console/info-schema/table.sql?name=sqlpage_aide_navigation&stats=yes | [Content](console/info-schema/table.sql?name=sqlpage_aide_navigation&stats=yes) | [sqlpage_aide_navigation (table) Schema](console/info-schema/table.sql?name=sqlpage_aide_navigation&stats=yes) | console/content/table/sqlpage_aide_navigation.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/sqlpage_aide_navigation.sql?stats=yes) | [sqlpage_aide_navigation (table) Content](console/content/table/sqlpage_aide_navigation.sql?stats=yes) | CREATE TABLE sqlpage_aide_navigation ( path TEXT NOT NULL, -- the "primary key" within namespace caption TEXT NOT NULL, -- for human-friendly general-purpose name namespace TEXT NOT NULL, -- if more than one navigation tree is required parent_path TEXT, -- for defining hierarchy sibling_order INTEGER, -- orders children within their parent(s) url TEXT, -- for supplying links, if different from path title TEXT, -- for full titles when elaboration is required, default to caption if NULL abbreviated_caption TEXT, -- for breadcrumbs and other "short" form, default to caption if NULL description TEXT, -- for elaboration or explanation elaboration TEXT, -- optional attributes for e.g. { "target": "__blank" } -- TODO: figure out why Rusqlite does not allow this but sqlite3 does -- CONSTRAINT fk_parent_path FOREIGN KEY (namespace, parent_path) REFERENCES sqlpage_aide_navigation(namespace, path), CONSTRAINT unq_ns_path UNIQUE (namespace, parent_path, path) ) | |
| sqlpage_aide_navigation | abbreviated_caption | TEXT | No | No | console/info-schema/table.sql?name=sqlpage_aide_navigation&stats=yes | [Content](console/info-schema/table.sql?name=sqlpage_aide_navigation&stats=yes) | [sqlpage_aide_navigation (table) Schema](console/info-schema/table.sql?name=sqlpage_aide_navigation&stats=yes) | console/content/table/sqlpage_aide_navigation.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/sqlpage_aide_navigation.sql?stats=yes) | [sqlpage_aide_navigation (table) Content](console/content/table/sqlpage_aide_navigation.sql?stats=yes) | CREATE TABLE sqlpage_aide_navigation ( path TEXT NOT NULL, -- the "primary key" within namespace caption TEXT NOT NULL, -- for human-friendly general-purpose name namespace TEXT NOT NULL, -- if more than one navigation tree is required parent_path TEXT, -- for defining hierarchy sibling_order INTEGER, -- orders children within their parent(s) url TEXT, -- for supplying links, if different from path title TEXT, -- for full titles when elaboration is required, default to caption if NULL abbreviated_caption TEXT, -- for breadcrumbs and other "short" form, default to caption if NULL description TEXT, -- for elaboration or explanation elaboration TEXT, -- optional attributes for e.g. { "target": "__blank" } -- TODO: figure out why Rusqlite does not allow this but sqlite3 does -- CONSTRAINT fk_parent_path FOREIGN KEY (namespace, parent_path) REFERENCES sqlpage_aide_navigation(namespace, path), CONSTRAINT unq_ns_path UNIQUE (namespace, parent_path, path) ) | |
| sqlpage_aide_navigation | description | TEXT | No | No | console/info-schema/table.sql?name=sqlpage_aide_navigation&stats=yes | [Content](console/info-schema/table.sql?name=sqlpage_aide_navigation&stats=yes) | [sqlpage_aide_navigation (table) Schema](console/info-schema/table.sql?name=sqlpage_aide_navigation&stats=yes) | console/content/table/sqlpage_aide_navigation.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/sqlpage_aide_navigation.sql?stats=yes) | [sqlpage_aide_navigation (table) Content](console/content/table/sqlpage_aide_navigation.sql?stats=yes) | CREATE TABLE sqlpage_aide_navigation ( path TEXT NOT NULL, -- the "primary key" within namespace caption TEXT NOT NULL, -- for human-friendly general-purpose name namespace TEXT NOT NULL, -- if more than one navigation tree is required parent_path TEXT, -- for defining hierarchy sibling_order INTEGER, -- orders children within their parent(s) url TEXT, -- for supplying links, if different from path title TEXT, -- for full titles when elaboration is required, default to caption if NULL abbreviated_caption TEXT, -- for breadcrumbs and other "short" form, default to caption if NULL description TEXT, -- for elaboration or explanation elaboration TEXT, -- optional attributes for e.g. { "target": "__blank" } -- TODO: figure out why Rusqlite does not allow this but sqlite3 does -- CONSTRAINT fk_parent_path FOREIGN KEY (namespace, parent_path) REFERENCES sqlpage_aide_navigation(namespace, path), CONSTRAINT unq_ns_path UNIQUE (namespace, parent_path, path) ) | |
| sqlpage_aide_navigation | elaboration | TEXT | No | No | console/info-schema/table.sql?name=sqlpage_aide_navigation&stats=yes | [Content](console/info-schema/table.sql?name=sqlpage_aide_navigation&stats=yes) | [sqlpage_aide_navigation (table) Schema](console/info-schema/table.sql?name=sqlpage_aide_navigation&stats=yes) | console/content/table/sqlpage_aide_navigation.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/sqlpage_aide_navigation.sql?stats=yes) | [sqlpage_aide_navigation (table) Content](console/content/table/sqlpage_aide_navigation.sql?stats=yes) | CREATE TABLE sqlpage_aide_navigation ( path TEXT NOT NULL, -- the "primary key" within namespace caption TEXT NOT NULL, -- for human-friendly general-purpose name namespace TEXT NOT NULL, -- if more than one navigation tree is required parent_path TEXT, -- for defining hierarchy sibling_order INTEGER, -- orders children within their parent(s) url TEXT, -- for supplying links, if different from path title TEXT, -- for full titles when elaboration is required, default to caption if NULL abbreviated_caption TEXT, -- for breadcrumbs and other "short" form, default to caption if NULL description TEXT, -- for elaboration or explanation elaboration TEXT, -- optional attributes for e.g. { "target": "__blank" } -- TODO: figure out why Rusqlite does not allow this but sqlite3 does -- CONSTRAINT fk_parent_path FOREIGN KEY (namespace, parent_path) REFERENCES sqlpage_aide_navigation(namespace, path), CONSTRAINT unq_ns_path UNIQUE (namespace, parent_path, path) ) | |
| party_type | party_type_id | ULID | Yes | Yes | console/info-schema/table.sql?name=party_type&stats=yes | [Content](console/info-schema/table.sql?name=party_type&stats=yes) | [party_type (table) Schema](console/info-schema/table.sql?name=party_type&stats=yes) | console/content/table/party_type.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/party_type.sql?stats=yes) | [party_type (table) Content](console/content/table/party_type.sql?stats=yes) | CREATE TABLE "party_type" ( "party_type_id" ULID PRIMARY KEY NOT NULL, "code" TEXT /* UNIQUE COLUMN */ NOT NULL, "value" TEXT NOT NULL, "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, UNIQUE("code") ) | |
| party_type | code | TEXT | No | Yes | console/info-schema/table.sql?name=party_type&stats=yes | [Content](console/info-schema/table.sql?name=party_type&stats=yes) | [party_type (table) Schema](console/info-schema/table.sql?name=party_type&stats=yes) | console/content/table/party_type.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/party_type.sql?stats=yes) | [party_type (table) Content](console/content/table/party_type.sql?stats=yes) | CREATE TABLE "party_type" ( "party_type_id" ULID PRIMARY KEY NOT NULL, "code" TEXT /* UNIQUE COLUMN */ NOT NULL, "value" TEXT NOT NULL, "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, UNIQUE("code") ) | |
| party_type | value | TEXT | No | Yes | console/info-schema/table.sql?name=party_type&stats=yes | [Content](console/info-schema/table.sql?name=party_type&stats=yes) | [party_type (table) Schema](console/info-schema/table.sql?name=party_type&stats=yes) | console/content/table/party_type.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/party_type.sql?stats=yes) | [party_type (table) Content](console/content/table/party_type.sql?stats=yes) | CREATE TABLE "party_type" ( "party_type_id" ULID PRIMARY KEY NOT NULL, "code" TEXT /* UNIQUE COLUMN */ NOT NULL, "value" TEXT NOT NULL, "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, UNIQUE("code") ) | |
| party_type | created_at | TIMESTAMPTZ | No | No | CURRENT_TIMESTAMP | console/info-schema/table.sql?name=party_type&stats=yes | [Content](console/info-schema/table.sql?name=party_type&stats=yes) | [party_type (table) Schema](console/info-schema/table.sql?name=party_type&stats=yes) | console/content/table/party_type.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/party_type.sql?stats=yes) | [party_type (table) Content](console/content/table/party_type.sql?stats=yes) | CREATE TABLE "party_type" ( "party_type_id" ULID PRIMARY KEY NOT NULL, "code" TEXT /* UNIQUE COLUMN */ NOT NULL, "value" TEXT NOT NULL, "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, UNIQUE("code") ) |
| party_type | created_by | TEXT | No | No | 'UNKNOWN' | console/info-schema/table.sql?name=party_type&stats=yes | [Content](console/info-schema/table.sql?name=party_type&stats=yes) | [party_type (table) Schema](console/info-schema/table.sql?name=party_type&stats=yes) | console/content/table/party_type.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/party_type.sql?stats=yes) | [party_type (table) Content](console/content/table/party_type.sql?stats=yes) | CREATE TABLE "party_type" ( "party_type_id" ULID PRIMARY KEY NOT NULL, "code" TEXT /* UNIQUE COLUMN */ NOT NULL, "value" TEXT NOT NULL, "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, UNIQUE("code") ) |
| party_type | updated_at | TIMESTAMPTZ | No | No | console/info-schema/table.sql?name=party_type&stats=yes | [Content](console/info-schema/table.sql?name=party_type&stats=yes) | [party_type (table) Schema](console/info-schema/table.sql?name=party_type&stats=yes) | console/content/table/party_type.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/party_type.sql?stats=yes) | [party_type (table) Content](console/content/table/party_type.sql?stats=yes) | CREATE TABLE "party_type" ( "party_type_id" ULID PRIMARY KEY NOT NULL, "code" TEXT /* UNIQUE COLUMN */ NOT NULL, "value" TEXT NOT NULL, "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, UNIQUE("code") ) | |
| party_type | updated_by | TEXT | No | No | console/info-schema/table.sql?name=party_type&stats=yes | [Content](console/info-schema/table.sql?name=party_type&stats=yes) | [party_type (table) Schema](console/info-schema/table.sql?name=party_type&stats=yes) | console/content/table/party_type.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/party_type.sql?stats=yes) | [party_type (table) Content](console/content/table/party_type.sql?stats=yes) | CREATE TABLE "party_type" ( "party_type_id" ULID PRIMARY KEY NOT NULL, "code" TEXT /* UNIQUE COLUMN */ NOT NULL, "value" TEXT NOT NULL, "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, UNIQUE("code") ) | |
| party_type | deleted_at | TIMESTAMPTZ | No | No | console/info-schema/table.sql?name=party_type&stats=yes | [Content](console/info-schema/table.sql?name=party_type&stats=yes) | [party_type (table) Schema](console/info-schema/table.sql?name=party_type&stats=yes) | console/content/table/party_type.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/party_type.sql?stats=yes) | [party_type (table) Content](console/content/table/party_type.sql?stats=yes) | CREATE TABLE "party_type" ( "party_type_id" ULID PRIMARY KEY NOT NULL, "code" TEXT /* UNIQUE COLUMN */ NOT NULL, "value" TEXT NOT NULL, "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, UNIQUE("code") ) | |
| party_type | deleted_by | TEXT | No | No | console/info-schema/table.sql?name=party_type&stats=yes | [Content](console/info-schema/table.sql?name=party_type&stats=yes) | [party_type (table) Schema](console/info-schema/table.sql?name=party_type&stats=yes) | console/content/table/party_type.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/party_type.sql?stats=yes) | [party_type (table) Content](console/content/table/party_type.sql?stats=yes) | CREATE TABLE "party_type" ( "party_type_id" ULID PRIMARY KEY NOT NULL, "code" TEXT /* UNIQUE COLUMN */ NOT NULL, "value" TEXT NOT NULL, "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, UNIQUE("code") ) | |
| party_type | activity_log | TEXT | No | No | console/info-schema/table.sql?name=party_type&stats=yes | [Content](console/info-schema/table.sql?name=party_type&stats=yes) | [party_type (table) Schema](console/info-schema/table.sql?name=party_type&stats=yes) | console/content/table/party_type.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/party_type.sql?stats=yes) | [party_type (table) Content](console/content/table/party_type.sql?stats=yes) | CREATE TABLE "party_type" ( "party_type_id" ULID PRIMARY KEY NOT NULL, "code" TEXT /* UNIQUE COLUMN */ NOT NULL, "value" TEXT NOT NULL, "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, UNIQUE("code") ) | |
| party | party_id | VARCHAR | Yes | Yes | console/info-schema/table.sql?name=party&stats=yes | [Content](console/info-schema/table.sql?name=party&stats=yes) | [party (table) Schema](console/info-schema/table.sql?name=party&stats=yes) | console/content/table/party.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/party.sql?stats=yes) | [party (table) Content](console/content/table/party.sql?stats=yes) | CREATE TABLE "party" ( "party_id" VARCHAR PRIMARY KEY NOT NULL, "party_type_id" ULID NOT NULL, "party_name" TEXT NOT NULL, "elaboration" TEXT CHECK(json_valid(elaboration) OR elaboration IS NULL), "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("party_type_id") REFERENCES "party_type"("party_type_id") ) | |
| party | party_type_id | ULID | No | Yes | console/info-schema/table.sql?name=party&stats=yes | [Content](console/info-schema/table.sql?name=party&stats=yes) | [party (table) Schema](console/info-schema/table.sql?name=party&stats=yes) | console/content/table/party.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/party.sql?stats=yes) | [party (table) Content](console/content/table/party.sql?stats=yes) | CREATE TABLE "party" ( "party_id" VARCHAR PRIMARY KEY NOT NULL, "party_type_id" ULID NOT NULL, "party_name" TEXT NOT NULL, "elaboration" TEXT CHECK(json_valid(elaboration) OR elaboration IS NULL), "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("party_type_id") REFERENCES "party_type"("party_type_id") ) | |
| party | party_name | TEXT | No | Yes | console/info-schema/table.sql?name=party&stats=yes | [Content](console/info-schema/table.sql?name=party&stats=yes) | [party (table) Schema](console/info-schema/table.sql?name=party&stats=yes) | console/content/table/party.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/party.sql?stats=yes) | [party (table) Content](console/content/table/party.sql?stats=yes) | CREATE TABLE "party" ( "party_id" VARCHAR PRIMARY KEY NOT NULL, "party_type_id" ULID NOT NULL, "party_name" TEXT NOT NULL, "elaboration" TEXT CHECK(json_valid(elaboration) OR elaboration IS NULL), "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("party_type_id") REFERENCES "party_type"("party_type_id") ) | |
| party | elaboration | TEXT | No | No | console/info-schema/table.sql?name=party&stats=yes | [Content](console/info-schema/table.sql?name=party&stats=yes) | [party (table) Schema](console/info-schema/table.sql?name=party&stats=yes) | console/content/table/party.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/party.sql?stats=yes) | [party (table) Content](console/content/table/party.sql?stats=yes) | CREATE TABLE "party" ( "party_id" VARCHAR PRIMARY KEY NOT NULL, "party_type_id" ULID NOT NULL, "party_name" TEXT NOT NULL, "elaboration" TEXT CHECK(json_valid(elaboration) OR elaboration IS NULL), "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("party_type_id") REFERENCES "party_type"("party_type_id") ) | |
| party | created_at | TIMESTAMPTZ | No | No | CURRENT_TIMESTAMP | console/info-schema/table.sql?name=party&stats=yes | [Content](console/info-schema/table.sql?name=party&stats=yes) | [party (table) Schema](console/info-schema/table.sql?name=party&stats=yes) | console/content/table/party.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/party.sql?stats=yes) | [party (table) Content](console/content/table/party.sql?stats=yes) | CREATE TABLE "party" ( "party_id" VARCHAR PRIMARY KEY NOT NULL, "party_type_id" ULID NOT NULL, "party_name" TEXT NOT NULL, "elaboration" TEXT CHECK(json_valid(elaboration) OR elaboration IS NULL), "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("party_type_id") REFERENCES "party_type"("party_type_id") ) |
| party | created_by | TEXT | No | No | 'UNKNOWN' | console/info-schema/table.sql?name=party&stats=yes | [Content](console/info-schema/table.sql?name=party&stats=yes) | [party (table) Schema](console/info-schema/table.sql?name=party&stats=yes) | console/content/table/party.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/party.sql?stats=yes) | [party (table) Content](console/content/table/party.sql?stats=yes) | CREATE TABLE "party" ( "party_id" VARCHAR PRIMARY KEY NOT NULL, "party_type_id" ULID NOT NULL, "party_name" TEXT NOT NULL, "elaboration" TEXT CHECK(json_valid(elaboration) OR elaboration IS NULL), "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("party_type_id") REFERENCES "party_type"("party_type_id") ) |
| party | updated_at | TIMESTAMPTZ | No | No | console/info-schema/table.sql?name=party&stats=yes | [Content](console/info-schema/table.sql?name=party&stats=yes) | [party (table) Schema](console/info-schema/table.sql?name=party&stats=yes) | console/content/table/party.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/party.sql?stats=yes) | [party (table) Content](console/content/table/party.sql?stats=yes) | CREATE TABLE "party" ( "party_id" VARCHAR PRIMARY KEY NOT NULL, "party_type_id" ULID NOT NULL, "party_name" TEXT NOT NULL, "elaboration" TEXT CHECK(json_valid(elaboration) OR elaboration IS NULL), "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("party_type_id") REFERENCES "party_type"("party_type_id") ) | |
| party | updated_by | TEXT | No | No | console/info-schema/table.sql?name=party&stats=yes | [Content](console/info-schema/table.sql?name=party&stats=yes) | [party (table) Schema](console/info-schema/table.sql?name=party&stats=yes) | console/content/table/party.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/party.sql?stats=yes) | [party (table) Content](console/content/table/party.sql?stats=yes) | CREATE TABLE "party" ( "party_id" VARCHAR PRIMARY KEY NOT NULL, "party_type_id" ULID NOT NULL, "party_name" TEXT NOT NULL, "elaboration" TEXT CHECK(json_valid(elaboration) OR elaboration IS NULL), "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("party_type_id") REFERENCES "party_type"("party_type_id") ) | |
| party | deleted_at | TIMESTAMPTZ | No | No | console/info-schema/table.sql?name=party&stats=yes | [Content](console/info-schema/table.sql?name=party&stats=yes) | [party (table) Schema](console/info-schema/table.sql?name=party&stats=yes) | console/content/table/party.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/party.sql?stats=yes) | [party (table) Content](console/content/table/party.sql?stats=yes) | CREATE TABLE "party" ( "party_id" VARCHAR PRIMARY KEY NOT NULL, "party_type_id" ULID NOT NULL, "party_name" TEXT NOT NULL, "elaboration" TEXT CHECK(json_valid(elaboration) OR elaboration IS NULL), "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("party_type_id") REFERENCES "party_type"("party_type_id") ) | |
| party | deleted_by | TEXT | No | No | console/info-schema/table.sql?name=party&stats=yes | [Content](console/info-schema/table.sql?name=party&stats=yes) | [party (table) Schema](console/info-schema/table.sql?name=party&stats=yes) | console/content/table/party.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/party.sql?stats=yes) | [party (table) Content](console/content/table/party.sql?stats=yes) | CREATE TABLE "party" ( "party_id" VARCHAR PRIMARY KEY NOT NULL, "party_type_id" ULID NOT NULL, "party_name" TEXT NOT NULL, "elaboration" TEXT CHECK(json_valid(elaboration) OR elaboration IS NULL), "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("party_type_id") REFERENCES "party_type"("party_type_id") ) | |
| party | activity_log | TEXT | No | No | console/info-schema/table.sql?name=party&stats=yes | [Content](console/info-schema/table.sql?name=party&stats=yes) | [party (table) Schema](console/info-schema/table.sql?name=party&stats=yes) | console/content/table/party.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/party.sql?stats=yes) | [party (table) Content](console/content/table/party.sql?stats=yes) | CREATE TABLE "party" ( "party_id" VARCHAR PRIMARY KEY NOT NULL, "party_type_id" ULID NOT NULL, "party_name" TEXT NOT NULL, "elaboration" TEXT CHECK(json_valid(elaboration) OR elaboration IS NULL), "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("party_type_id") REFERENCES "party_type"("party_type_id") ) | |
| party_relation_type | party_relation_type_id | ULID | Yes | Yes | console/info-schema/table.sql?name=party_relation_type&stats=yes | [Content](console/info-schema/table.sql?name=party_relation_type&stats=yes) | [party_relation_type (table) Schema](console/info-schema/table.sql?name=party_relation_type&stats=yes) | console/content/table/party_relation_type.sql?stats=yes | [Content]($SITE_PREFIX_URL/console/content/table/party_relation_type.sql?stats=yes) | [party_relation_type (table) Content](console/content/table/party_relation_type.sql?stats=yes) | CREATE TABLE "party_relation_type" ( "party_relation_type_id" ULID PRIMARY KEY NOT NULL, "code" TEXT /* UNIQUE COLUMN */ NOT NULL, "value" TEXT NOT NULL, "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, UNIQUE("code") ) |
Error We are sorry, but an error occurred while generating this page. You should contact the site's administrator.
Error in query number 6:
Parsing failed: SQLPage couldn't understand the SQL file. Please check for syntax errors:
SELECT 'text' AS component,
(SELECT CASE WHEN $current_page > 1 THEN '[Previous](?limit=' || $limit || '&offset=' || ($offset - $limit) || ')' ELSE ' END) || ' ' ||
⬆️
'(Page ' || $current_page || ' of ' || $total_pages || ') ' ||
Backtrace
sql parser error: Expected: END, found: ' ||
' at Line: 42, Column: 149"console/content/view/console_information_schema_table.auto.sql" contains a syntax error preventing SQLPage from parsing and preparing its SQL statements.You can hide error messages like this one from your users by setting the 'environment' configuration option to 'production'.