[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
Re: [Gnumed-devel] Questions re database schema - normalization
From: |
Karsten Hilbert |
Subject: |
Re: [Gnumed-devel] Questions re database schema - normalization |
Date: |
Fri, 3 Sep 2004 10:06:14 +0200 |
User-agent: |
Mutt/1.3.22.1i |
> Regarding the id vs fk debate:
There is no debate as of yet, thanks $DEITY :)
> I recommend that
> - any primary key of a table is named "id"
> - any reference to a foreign key is named id_<tablename>
"id" is customary in many schema but it also often carries
business meaning, eg. is a false friend. Think of "sample ID",
"patient ID". Hence I chose pk for primary key and fk for
foreign key which seem pretty intuitive.
Karsten
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
- Re: [Gnumed-devel] Gui-Designers was the id_name debate, (continued)
- [Gnumed-devel] Possible development opportunity (was Gui-Designers was the id_name debate), J Busser, 2004/09/12
- Re: [Gnumed-devel] Possible development opportunity (was Gui-Designers was the id_name debate), Karsten Hilbert, 2004/09/12
- Re: [Gnumed-devel] Possible development opportunity (was Gui-Designers was the id_name debate), Karsten Hilbert, 2004/09/12
- Re: [Gnumed-devel] the id_name debate, Karsten Hilbert, 2004/09/03
- Re: [Gnumed-devel] the id_name debate, Richard Terry, 2004/09/03
- Re: [Gnumed-devel] the id_name debate, Karsten Hilbert, 2004/09/03
- Re: [Gnumed-devel] Questions re database schema - normalization, J Busser, 2004/09/03
- Re: [Gnumed-devel] Questions re database schema - normalization, Karsten Hilbert, 2004/09/03
- Re: [Gnumed-devel] Questions re database schema - normalization,
Karsten Hilbert <=
Re: [Gnumed-devel] Questions re database schema - normalization, Karsten Hilbert, 2004/09/03