CODEWITHSUNDEEP
mysqlmysql-workbench
Mike
Mike

Reputation: 235

Mysql Workbench composite key in diagram

I have a model i'm building in workbench, and one of the tables is a many-many relationship table with a composite key made up of 3 integer values: the two foreign keys that make up the many-many relationship, and an additional identifier whose details are not relevant to my question.

I can see how in the model tab of the workbench I can tick off the checkbox to make all 3 values a component of the primary key (and it's index) and that seems to be working just fine, but when I go to the EER Diagram tab - I only see one of the columns with a key icon next to it.

Is there an additional step here, or is there something I'm missing?

EDIT: see attached screenshot - sorry about the yellow obscuring boxes - my company would not be pleased if I posted details, even on something so simple.

Screenshot of Diagram

Upvotes: 6

Views: 5626

Answers (1)

dleerob
dleerob

Reputation: 5371

This is a bug that has been reported. See here: https://bugs.mysql.com/bug.php?id=92141

Upvotes: 1

Related Questions