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​

→ Enum → YES/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)