ColumnInfo

A struct to hold column metadata

Members

Variables

charSet
string charSet;

Character set, "<NULL>" if not applicable.

charsMax
long charsMax;

Capacity in characters, -1L if not applicable

colType
string colType;

More detail about the column type, e.g. "int(10) unsigned".

collation
string collation;

Collation, "<NULL>" if not applicable.

comment
string comment;

Any comment that was set at table definition time.

defaultNull
bool defaultNull;

Is the default value NULL?

defaultValue
string defaultValue;

The default value as a string if not NULL

extra
string extra;

Extra information.

index
size_t index;

Zero based index of the column within a table row.

key
string key;

Information about the column's key status, blank if none.

name
string name;

The name of the column.

nullable
bool nullable;

Can the column value be set to NULL

numericPrecision
short numericPrecision;

Presentation information for numerics, -1L if not applicable.

numericScale
short numericScale;

Scale information for numerics or NULL, -1L if not applicable.

octetsMax
long octetsMax;

Capacity in bytes - same as chars if not a unicode table definition, -1L if not applicable.

privileges
string privileges;

Privileges for logged in user.

schema
string schema;

The database that the table having this column belongs to.

table
string table;

The table that this column belongs to.

type
string type;

What type is the column - tinyint, char, varchar, blob, date etc

Meta