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.
| Value | Meaning |
|---|---|
"" (empty) | No key |
PRI | Primary key |
MUL | Indexed (multiple rows can have the same value) |
UNI | Unique (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.
| Value | Meaning |
|---|---|
"" (empty) | No extra properties |
auto_increment | The column value auto-increments (typically for primary keys) |