mysql workbench列图标是什么意思 [英] What do the mysql workbench column icons mean

问题描述

在MySQL Workbench中，当您编辑表时，每个列名旁都有一个彩色菱形.在哪里可以找到说明每种颜色含义的文档?

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?

推荐答案

关键字:(部分)主键
钻石满:NOT NULL
未填充的菱形:NULL
红色:(部分)外键
蓝色菱形:简单属性(无键)

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)

可以组合，例如:
是红色的键，因此它是主键，它也是外键
是一个黄色(非红色)键，因此它只是一个主键
是蓝色填充菱形菱形，因此它是一个非空的简单属性
是红色填充的菱形，因此不是NOT NULL外键
是蓝色的未填充菱形菱形，因此它是一个简单的属性，可以为NULL
是红色的未填充菱形，因此它是一个外键，可以为

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

在旁注:
请注意，MySQL Workbench具有错误的数据库>逆向工程师(Ctrl-R)选项，您可以使用该选项生成ERD图并使用这些图标.以我的经验，v6.x优于v8.x，但是两者都有其怪癖/错误.

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.

这篇关于mysql workbench列图标是什么意思的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！