Column Editor

The Column Editor is placed within the Table Editor dialog. It allows you to modify the list of table columns as well as column properties. Click the Columns tab of the Table Editor to manage table columns.

The Column Editor consists of the following areas:

Column List
Properties Pane
Button Pane

Column List

The column list displays all the columns in the table and allows you to modify the following column properties:

Column name - the name of the column, which must be unique within the table;
Data type - the type of the column, which specifies data to store in the column; it can be one of integer types, which differ in data size (TINYINT, SMALLINT, MEDIUMINT, INT, BIGINT), decimal type (FLOAT, DOUBLE, DECIMAL), a type for storing date and time values (DATE, DATETIME, TIMESTAMP, TIME, YEAR), string type (CHAR, VARCHAR), a large binary type (TINYBLOB, BLOB, MEDUIMBLOB, LONGBLOB), a multi-line text (TINYTEXT, TEXT, MEDIUMTEXT, LONGTEXT), enumeration type, which can contain only values from the Set attribute (ENUM), or a set of values from the Set attribute (SET);
Domain - you can specify a column domain for faster modification of all column properties, see the Domains topic for detailed information;
Primary key - specify this option to include the field into the table primary key;
Comment - an arbitrary description for the column.

Properties Pane

The properties pane allows you to define the advanced properties of the column, selected in the Column List. The appearance of this pane changes according to the data type of the column. These properties are:

Length - this attribute defines the maximum allowed length of the stored values; it applies to all integer, decimal, and string types;
Decimals - this attribute defines the number of digits, which follow the decimal point in the FLOAT, DOUBLE, and DECIMAL types;
Not null - this option indicates that the stored column value cannot be NULL;
Binary - this attribute indicates that the string value is stored in a binary form within the column;
Unsigned - this option indicates that the stored integer or decimal value must be above zero;
Zerofill - with this attribute all unspecified digits of the field value are filled as zeros according to the column length and decimals; it applies to all integer and decimal types;
Autoinc - this attribute makes the column value auto increment, i.e. each new value is set automatically according to the previous value; it applies to all integer values;
Set - this attribute defines the list of permissible values for the field of the ENUM or SET type;
Default - this attribute defines the default value, which the column accepts if no other is specified.
Quote - this attribute defines the default value to be quoted or not.

Buttons Pane

The buttons under the list of columns allows you to perform the following actions:

Add - add a new column with the default properties to the end of the list;
Duplicate - add a new column with the same properties as the selected column to the end of the list;
Delete - remove the selected column from the list;
Up/Down - move the selected column along the list.

See Also

Diagram Objects: Domains | Table Editor | Indexes