Re: ID column naming convention

Поиск
Список
Период
Сортировка
От Karsten Hilbert
Тема Re: ID column naming convention
Дата
Msg-id 20151014084944.GA2522@hermes.hilbert.loc
обсуждение исходный текст
Ответ на Re: ID column naming convention  (John R Pierce <pierce@hogranch.com>)
Список pgsql-general
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


В списке pgsql-general по дате отправления:

Предыдущее
От: dinesh kumar
Дата:
Сообщение: Re: Creating Report for PieChart
Следующее
От: Merlin Moncure
Дата:
Сообщение: Re: Understanding "seq scans"