syscolumn system table

Each row in the syscolumn system table describes a column.

Column name Column type Description
table_id UNSIGNED INTEGER The identifier of the table to which the column belongs.
column_id UNSIGNED INTEGER A unique identifier for the column.
column_name VARCHAR(128) The name of the column. See Domain interface.
column_flags TINY

A bitwise combination of the following flags describing the attributes:

  • 0x01   Column is in the primary key.

  • 0x02   Column is nullable.

column_domain TINY The column domain, which is an enumerated value indicating the domain of the column in the low-order 6 bits. The remaining bits are used internally.
column_length UNSIGNED SHORT

The column length.

For VARCHAR and BINARY type columns, which are defined in the Domain interface, this is the maximum length in bytes. For NUMERIC type columns, the precision is stored in the first byte, and the scale is stored in the second byte.

column_default_value VARCHAR(128)

The default value for this column, which is specified by one of the COLUMN_DEFAULT values in the ColumnSchema interface. For example, COLUMN_DEFAULT_AUTOINC denotes an auto-incrementing default value.

If a varchar column has DEFAULT AUTOFILENAME specified, then it stores the parameters prefix and extension using the encoding prefix|extension.

filename_colid UNSIGNED INTEGER Stores the column id of the referenced file_name column in the schema definition; otherwise, this column is null.
 Constraints