Domains

Domains are used for creating table columns in Table Designer or Table Wizard with a set of pre-defined properties (data type, length, etc.). Currently domains are not supported by MySQL, so it is a unique extension to the MySQL functionality of DBACentral for MySQL. Domains are stored in profile files along with profile connection information, relations,

queries, forms, etc.

For your convenience DBACentral for MySQL provides a number of default domains, which are listed below. These domains are present in each newly created profile, but can be modified later through the Domain Designer. Using this tool, you can also create your own domains according to your wishes and requirements.

Built-in Domains

AutoNumber

TINYINT (4), PRIMARY KEY, NOT NULL, UNSIGNED, AUTOINC

Number

INTEGER (11)

Text

VARCHAR (25)

Float

DOUBLE (4, 4)

Date

DATE

Time

TIME

Boolean

ENUM ('n','y') DEFAULT 'n'

Memo

TEXT

Blob

BLOB