ER 图未在 Datagrip 中显示关系

2022-01-15 00:00:00 database mariadb mysql

datagrip 中的 ER 图不会显示表之间的关系，只会显示表.我正在使用 MYSQL.我也尝试过使用 MariaDB.在此处输入图片说明

ER diagrams in datagrip won't display the relationsships between tables, only the tables. I'm using MYSQL. I've also tried to use MariaDB. enter image description here

推荐答案

好的，我遇到了这个问题，发现这可能取决于你如何声明外键，至少使用MySql.

Ok, I ran across this problem, and found that it may depend on how you declare the foreign keys at least using MySql.

图表不显示使用此语法创建的表的关系，内联外键声明:

The diagram does not display relationship for tables created using this syntax, with inline foreign key declaration:

CREATE TABLE table(
  my_pk int primary key,
  fkrow int references other_table(fkrefrow)
);

但是如果表是用这种语法创建的，图表会显示关系箭头，在自己的行上声明外键约束:

But the diagram DOES show relationship arrow if the table is created with this syntax, declaring the foreign key constraint on its own line:

CREATE TABLE table(
  my_pk int primary key,
  fkrow int not null,
  foreign key (fkrow) references other_table(fkrefrow)
)

相关文章