Mysql Workbench Symbol

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

Resource: https://stackoverflow.com/questions/10778561/what-do-the-mysql-workbench-column-icons-mean/28859886#28859886

Comments

Popular posts from this blog

Lab Network 2024

Step to publish your static html web page to GitHub

Tutorial OOP(reversion java)