Re: ID column naming convention

On Tue, Oct 13, 2015 at 03:44:15PM -0700, John R Pierce wrote:

> On 10/13/2015 3:27 PM, droberts wrote:
> >Thanks.   My only question is how do you create a schema diagram (ERD) then?
> >The tool won't know what the relationships are unless maybe you put foreign
> >key constraints on.  BTW does anyone recommend a tool to to that?  I've been
> >playing with DbVisualizer.
>
>
> I don't know of any ERD tool that will recognize foreign key references
> without FK constraint definitions, regardless of what things are named.

Also, there wouldn't be anything to recognize. Only to assume.

Karsten
--
GPG key ID E4071346 @ eu.pool.sks-keyservers.net
E167 67FD A291 2BEA 73BD  4537 78B9 A9F9 E407 1346