On Fri, Oct 16, 2015 at 04:59:12PM -0500, Jim Nasby wrote:
> BTW, I found Karsten's idea of using 'pk' for the surrogate key, and
> fk_table_name interesting. It helps avoid ambiguity from externally
> generated ID values.
That's the point :-)
Here's a real live schema using (mostly) the above approach:
http://www.gnumed.de/~ncq/gnumed/schema/gnumed_v20/
in case anyone is interested in taking a look.
Karsten
--
GPG key ID E4071346 @ eu.pool.sks-keyservers.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346