What do the mysql workbench column icons mean in ER Diagram?

database icons mysql-workbench er-diagrams
danyal1990 picture danyal1990 · Aug 9, 2014 · Viewed 8.8k times · Source

Can any one help me in explaining about the icons in the ER Diagram of Database created in MySQL Workbench.

x

  • Blue Diamond (Filled);
  • Blue Diamond (unfilled);
  • Red Diamond, et cetera;
    Thanks!

Answer

Damien Wilson picture Damien Wilson · Aug 10, 2014

I've found these resources on MySQL's website:

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.

In addition to the text above, a red diamond indicates a Foreign Key association.

To answer your question:

  • Blue Diamond (Filled) = indicates NOT NULL
  • Blue Diamond (unfilled) = indicates NULL
  • Red Diamond, et cetera = indicates a foreign key {filled: NOT NULL, unfilled: NULL}

Related questions

Insert into ... values ( SELECT ... FROM ... )

I am trying to INSERT INTO a table using the input from another table. Although this is entirely feasible for many database engines, I always seem to struggle to remember the correct syntax for the SQL engine of the day (…

Read More
What is the difference between "INNER JOIN" and "OUTER JOIN"?

Also how do LEFT JOIN, RIGHT JOIN and FULL JOIN fit in?

Read More
'IF' in 'SELECT' statement - choose output value based on column values

SELECT id, amount FROM report I need amount to be amount if report.type='P' and -amount if report.type='N'. How do I add this to the above query?

Read More