Skip to main content

ColumnStructure

Type: Object

Represents a single column object used by Structure.

Example structure

{
Field: "Column name",
Type: "Column type",
Null: "YES",
Key: "PRI",
Default: "Some default value",
Extra: ""
}

Properties

.Field

String

The column name.


.Type

String

The column type (e.g., VARCHAR(255), INT, TEXT).


.Null

EnumYES/NO

Specifies whether the column allows NULL values.


.Key

Enum /PRI/MUL/UNI

Defines the key type for the column.

ValueMeaning
"" (empty)No key
PRIPrimary key
MULIndexed (multiple rows can have the same value)
UNIUnique (all values must be distinct)

.Default

String / null

THe default value for the column (if any).


.Extra

Enum""/auto_increment

Additional attributes for the column.

ValueMeaning
"" (empty)No extra properties
auto_incrementThe column value auto-increments (typically for primary keys)