Bug #42008 Virtual relation

• Submitted: 9 Jan 2009 23:47
• Modified: 4 Aug 2009 20:43
• Reporter: Martin Staael
• Status: Won't fix
• Category: MySQL Workbench
• Severity: S4 (Feature request)
• Version: 5.0.29
• OS: Windows
• CPU Architecture: Any
• Tags: CHECKED, Virtual relation

[9 Jan 2009 23:47] Martin Staael

Description:
Today it is only possible to add relations that will be stored as database relationship.

Most of our tables do not have foreign keys because we control this ourself.

Therefor we very much need to have virtual relation that is only visible in Workbench and will not be stored in MySQL. We want to use this to document our database. EMS have this feature but Workbench is so much better.

How to repeat:
Feature request

[12 Jan 2009 12:43] Susanne Ebrecht

Many thanks for writing a feature request.

We will discuss this.

[4 Aug 2009 20:43] Alfredo Kojima

In WB 5.1.17 you will be able to export the model with foreign keys skipped.
So you can still use normal relationships, but they will not be created in MySQL.