> Ick... this product is *so* the poster child of the MySQL generation:
...
> No foreign keys! Look at all those "DEFAULT '' NOT NULL" columns! What
> are they thinking?
You'd be surprised what the schema of most MEDICAL apps looks
like (if they aren't built off MS ACCESS, that is...). And one
would think medical DB designers are wont to be paranoid about
quality/integrity of data ...
Karsten Hilbert, MD
www.gnumed.org
(we do try to do a better job and this list is invaluable for it)
--
GPG key ID E4071346 @ wwwkeys.pgp.net
E167 67FD A291 2BEA 73BD 4537 78B9 A9F9 E407 1346
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match
