|
On 10/13/2015 11:36 AM, droberts wrote:
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)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. |
