FIELDS System Table Description

Description

Contains information about every field in every persistent table in the database.

Fields

Field Name Type Description

FIELD

string

Name of field, which is also the name of the column.

TABLENAME

string

Table name for this field/column.

SCHEMA

string

Schema name for the table for this field/column.

DOMAINNAME

string

If this column is defined as a SQL DOMAIN, this is the DOMAIN name. Otherwise, null.

DOMAINSCHEMA

string

If this column is defined as a SQL DOMAIN, this is the name of the schema for the DOMAIN. Otherwise, null.

COLLATIONSEQUENCE

string

If this column is a string type and a collation was specified, this is the name of the collation. Otherwise, null.

FIELDPOSITION

integer

This is the position of the field specifying the order in which the field was given in the original CREATE TABLE command. IDs will continue to be incremented by one in ascending order for any columns added by ALTER TABLE, despite any columns dropped by ALTER TABLE.

FIELDID

integer

This is the same as FIELDPOSITION.

DATATYPE

integer

Integer from ID in SYSTEM.DATATYPES for this column’s data type.

LENGTH

integer

Length associated with the data type for this column. This is the precision assigned to a CHAR or BINARY type or the size in bytes of the type.

SCALE

integer

If the column is defined as a fixed precision numeric type, this is the scale. Otherwise, 0.

PRECISION

integer

If the column is defined as a fixed precision numeric, CHAR or BINARY type, this is the precision. Otherwise, this is the maximum precision possible for this type.

DISPLAY_SIZE

integer

Internal field used to help the nuosql client and other clients display data.

FLAGS

integer

Flags specifying additional information about this column:

1

column is NOT_NULL

2

reserved for future use to flag Searchable

4

reserved for future use to flag Case Insensitive

8

column is defined as GENERATED ALWAYS AS IDENTITY, as opposed to GENERATED BY DEFAULT AS IDENTITY

DEFAULTVALUE

string

A default value given for the column when it is created.

REMARKS

string

Unused.

GENERATOR_SEQUENCE

text

Contains the name of the sequence, if the column has been defined as “GENERATED…​AS IDENTITY”. See column FLAGS for type of generation, always or by default.

ENUMERATION

text

Contains the textual labels for fields defined as ENUM data type.

CHARACTER_SET

text

Unused.

DECLARED_TYPE

string

The actual string for the type of the column parsed from the command that created the column (CREATE TABLE or ALTER TABLE).

COMPUTEDEXPRESSION

string

The expression used to compute the value of the field. If the field is not a computed field, NULL is used.

Indexes

Primary Index: FIELDS..PRIMARY_KEY on fields: SCHEMA, TABLENAME, FIELD

Secondary Index: FIELDCOLLATIONSEQUENCENAME on field: COLLATIONSEQUENCE

Secondary Index: FIELDDOMAINNAME on fields: DOMAINNAME, DOMAINSCHEMA