Field
Put field names here. For details on legal names, please refer to mySQL online manual at
http://www.mysql.com/Manual_chapter/manual_Reference.html#Legal_names
Type
Specify the column types here from the list. For details on column types, please refer to
http://www.mysql.com/Manual_chapter/manual_Reference.html#Column_types
Length/Set
For types like CHAR or INT, you will need to specify lengths for them. To have INT(10),
you should have 'INT' selected under column Type and '10' under column Length/Set.
If a field is given a type SET or ENUM, then you need to specify the options here as well. You must quote
each option with single quotes and escape characters with a back-slashes (\). In addition. the options should be separated by commas. Please refer to the end of the page for an example.
Attributes
Attributes for numeric types
Null
NUll if null values are allowed in the field, NOT NULL otherwise.
Default
Default value for the field.
Extra
Set the field auto_increment.
Primary/Index/Unique
Check the checkboxes to make the fields primary/index/unique keys.