ID column naming convention

From: droberts <david(dot)roberts(at)riverbed(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: ID column naming convention
Date: 2015-10-13 17:36:21
Message-ID: 1444757781856-5869844.post@n5.nabble.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi, is there a problem calling ID's different when used as a FK vs table ID?
For example

mydimtable ()
ID
name
description

myfacttable ()
my_dim_id # FK to ID above
total_sales

I 'think' if I don't enforce foreign key constraints, then this practice
prevents tools from being able to generate ERD diagrams right?

--
View this message in context: http://postgresql.nabble.com/ID-column-naming-convention-tp5869844.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rob Sargent 2015-10-13 17:43:55 Re: ID column naming convention
Previous Message Alvaro Herrera 2015-10-13 16:54:52 Re: Understanding "seq scans"