开发者

mysql DBvisualizer cannot show link between tables in schema diagram

开发者 https://www.devze.com 2023-02-20 05:31 出处:网络
HI guys: I am using DBvisualizer to manager Mediawiki mysql database. But i try to view schema diagram from DBvisualizer reference tab. But the graph displays no arcs between tables.

HI guys:

I am using DBvisualizer to manager Mediawiki mysql database. But i try to view schema diagram from DBvisualizer reference tab. But the graph displays no arcs between tables.

I have checked FAQ. it said:

The 开发者_StackOverflowgraph displays no arcs between tables if the database do no support primary/foreign key mapping or if mappings has not been defined.

Any solution for this?


Any solution for this?

Sure. Add foreign keys to the appropriate tables, as it sounds like they're missing.

Mediawiki mysql database

You might want to review Mediawiki's own page on their database layout, which happens to include a pretty graph with the arrows you're expecting.

Judging from the table descriptions on the sub-pages, it looks like Mediawiki does not enforce foreign keys at the database level.

0

精彩评论

暂无评论...
验证码 换一张
取 消