Welcome to ShenZhenJia Knowledge Sharing Community for programmer and developer-Open, Learning and Share
menu search
person
Welcome To Ask or Share your Answers For Others

Categories

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?

See Question&Answers more detail:os

与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
thumb_up_alt 0 like thumb_down_alt 0 dislike
1.1k views
Welcome To Ask or Share your Answers For Others

1 Answer

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.


与恶龙缠斗过久,自身亦成为恶龙;凝视深渊过久,深渊将回以凝视…
thumb_up_alt 0 like thumb_down_alt 0 dislike
Welcome to ShenZhenJia Knowledge Sharing Community for programmer and developer-Open, Learning and Share
...