MySQL Extended Attributes

The following extended attributes are defined by default in the MySQL DBMS.

Columns

The following extended attributes are available on the MySQL tab:

Name

Description

Character set

Set of symbols and encodings.

Scripting name: CharSet

Collation

Set of rules for comparing characters in a character set.

Scripting name: Collate

National

A way to indicate that a CHAR column should use UTF8 character set.

Scripting name: National

Unsigned

Indicates negative values are not allowed for the column.

Scripting name: Unsigned

Retrieve with leading zeros

When displayed, the default padding of spaces is replaced with zeros. For example, for a column declared as INT(5) ZEROFILL, a value of 4 is retrieved as 00004.

If you specify ZEROFILL for a numeric column, MySQL automatically adds the UNSIGNED attribute to the column.

Scripting name: ZeroFill

Indexes

The following extended attributes are available on the MySQL tab:

Name

Description

Full text index

Indicates that the index is a full text index.

Scripting name: FullText

Keys

The following extended attributes are available on the MySQL tab:

Name

Description

Unique key

When set to True, indicates that the key is unique. False implies that the key allows duplicate values.

Scripting name: ExtUnique

Models

The following extended attributes are available on the MySQL tab:

Name

Description

Database type

Indicates the type of the database, as specified in the extended attribute type DatabaseType.

Scripting name: DatabaseType

References

The following extended attributes are available on the MySQL tab:

Name

Description

Reference match type

Indicates the reference match type, as specified in the extended attribute type ReferenceMatchType.

Scripting name: ReferenceMatch