Field name

The name of this field in the table.

Enumerated values (for enum and set types)

A list of possible values for this field.

Width and decimals (for float and decimal types)

The total width of this field, and the number of digits to the right of the decimal point.

Type width (for other types)

The maximum number of characters allowed for data in this field.

Type options

For numeric fields, this parameter allows you to choose whether the field is unsigned or left-padded with zeros. For character fields, you can choose whether case is taken into account when sorting or not.

Allow nulls?

Determines whether NULL values are allowed in this field

Default value

The default value for this field in new records