On 10/13/2015 11:36 AM, droberts wrote:
> 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.
>
>
Pretty sure _all_ ER diagramming tools rely on the DDL of column
constraints not the names. And personally I would name the column
mydim_id. i.e don't inject the extra underscore which is not in your
table name. (And I assume the table names are fake: you don't really
want "table" in table name)