Special Tables

Special tables share additional information or can be used in special cases. They are separated from connected database therefore you are not able to join them. But you can always query them exactly like any other table (techincal hint: they are sqlite tables in memory).

Special tables include underscore before table name.

_empty table

This table is an empty rowset. It can be used for templates that only do subqueries.

_schema

This table shows the database structure (tables and fields) in one table and also shows read, write and protect permissions. The data from this table comes either from the database (see "DB" field in the table below) or from Zazler's database configuration file (see "Zazler" field in the table below).

A format called "dashboard" comes bundled with Zazler and is meant to work with _schema table. This combination is the default index page of every database.

Fields that are configured to be hidden are not listed.

The _schema table contains following fields:

Field Meaning DB Zazler
name The name of a table or field. X
tablename The name of the table where a field belongs to. X
rawtype Type as described in database ("table" for tables). X
gentype General type ("str", "int", "float", "bool", "date", "datetime" or "time") that can be used in templates for building content depending on type. X
comment Field or table comment. X
read Boolean value, whether the field is readable or not. Note: if one field is readable, then the whole table is readable. If you want to hide something from a table, refer to "hide" parameter under section "Permissions". X
write Boolean value, whether the field is readable or not. Note: if one field is writable, then the whole table is writable. If you want to hide something from a table, refer to "hide" parameter under section "Permissions". X
protect Boolean value, whether the password is required or not. Note: if a query contains protected field then password is required. X

_meta

Shared configured metainfo about database.