Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

What do the mysql workbench column icons mean

In MySQL Workbench, when you edit a table, by each column name, there is a colored diamond. Where can I find a document that explains what each color means?

like image 841
Di Zou Avatar asked May 28 '12 01:05

Di Zou


People also ask

What is B in MySQL Workbench?

Appendix B Keyboard Shortcuts Modifier in the tables stands for the platform-specific modifier key. This is Command on macOS, Control on other platforms. On macOS, the Alt key is Option.

What is PK nn UQ in MySQL?

PK - Primary Key. NN - Not Null. BIN - Binary (stores data as binary strings. There is no character set so sorting and comparison is based on the numeric values of the bytes in the values.) UN - Unsigned (non-negative numbers only.


2 Answers

enter image description hereenter image description hereKey: (Part of) Primary Key
enter image description hereenter image description hereFilled Diamond: NOT NULL
enter image description hereenter image description hereNot filled Diamond: NULL
enter image description hereenter image description hereenter image description hereRed colored: (Part of) Foreign key
enter image description hereenter image description hereBlue lined Diamond: Simple attribute (no key)

Can be combined for example:
enter image description here is a Red colored Key so it's a Primary Key which is also a Foreign Key
enter image description here is a Yellow (non Red) Key so it's only a Primary Key
enter image description here is a blue lined filled diamond so it's a NOT NULL simple attribute
enter image description here is a red colored filled diamond so it's a NOT NULL Foreign Key
enter image description here is a blue lined not filled diamond so it's a simple attribute which can be NULL
enter image description here is a red colored not filled diamond so it's a Foreign Key which can be NULL

On a sidenote:
Mind you that MySQL Workbench has a buggy Database > Reverse Engineer (Ctrl-R) option with which you can generate a ERD diagram and that uses these icons. In my experience the v6.x is better than v8.x but both have their quirks/bugs.

like image 199
Jan Avatar answered Sep 28 '22 03:09

Jan


To the left of the column name is an icon that indicates whether the column is a member of the primary key. If the icon is a small key, that column belongs to the primary key, otherwise the icon is a blue diamond or a white diamond. A blue diamond indicates the column has NN set. To add or remove a column from the primary key, double-click the icon. You can also add a primary key by checking the PRIMARY KEY check box in the Column Details section of the table editor.

Source: http://dev.mysql.com/doc/workbench/en/wb-table-editor.html Section: 7.7.1.3.2

like image 36
Andy Avatar answered Sep 28 '22 02:09

Andy