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?
Key: (Part of) Primary Key Filled Diamond: NOT NULL Not filled Diamond: NULL Red colored: (Part of) Foreign key Blue lined Diamond: Simple attribute (no key)
Can be combined for example: is a Red colored Key so it's a Primary Key which is also a Foreign Key is a Yellow (non Red) Key so it's only a Primary Key is a blue lined filled diamond so it's a NOT NULL simple attribute is a red colored filled diamond so it's a NOT NULL Foreign Key is a blue lined not filled diamond so it's a simple attribute which can be NULL 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.
1.4m articles
1.4m replys
5 comments
57.0k users