Domains

Database Designer for MySQL provides a unique extension for the MySQL server functionality -- column domains, which make the process of managing table columns as easy as possible.

A domain is a storage for some column attributes. Using domains you can create a column with all the required properties already defined (e.g. data type, length, precision, etc.), and modify a number of columns at once. 

To create a domain and set all the domain properties use the Domain Manager. This tool allows you to add, modify, and remove domains from your diagram.

After you have created diagram domains, it becomes much easier to add columns to the diagram tables - you can simply select the appropriate domain for the column within the Column Editor, and this assigns all domain attributes to the corresponding column attributes. It is also much more convenient to modify the domain-based columns than usual columns. Modifying any of the domain attribute updates all the columns, based on this domain.

Deleting a domain does not delete the dependent columns. See the Domain Tutorial and the Domain Manager topics to learn more about working with diagram domains.

Diagram Objects: Column Editor | Domain Manager

Tutorials: Tutorial - Using Domains

©2005 MicroOLAP Technologies LTD. All Rights Reserved. All trademarks are the sole property of their respective owners.