Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id F05842E008E for ; Tue, 11 Dec 2007 15:48:20 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 37813-05 for ; Tue, 11 Dec 2007 15:48:14 -0400 (AST) Received: from moutng.kundenserver.de (moutng.kundenserver.de [212.227.126.179]) by postgresql.org (Postfix) with ESMTP id 67B962E006D for ; Tue, 11 Dec 2007 15:48:16 -0400 (AST) Received: from webserv.wug.de ([194.25.154.138]) by mrelayeu.kundenserver.de (node=mrelayeu5) with ESMTP (Nemesis) id 0ML25U-1J2B5S2ynr-00058H; Tue, 11 Dec 2007 20:48:15 +0100 Received: from kretschmer by webserv.wug.de with local (Exim 3.36 #1) id 1J2B5R-0004Wg-00 for pgsql-sql@postgresql.org; Tue, 11 Dec 2007 20:48:13 +0100 Date: Tue, 11 Dec 2007 20:48:13 +0100 From: "A. Kretschmer" To: pgsql-sql@postgresql.org Subject: Re: Foreign Key for multi PK or design question Message-ID: <20071211194813.GA17301@a-kretschmer.de> References: <863ECFDF04C8804ABDF3559D87F157C638E5D9@MAGPTCPEXC02.na.mag-ias.net> <475ED504.7080006@productivitymedia.com> <20071211185330.GA16159@a-kretschmer.de> <475EE126.5030302@productivitymedia.com> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <475EE126.5030302@productivitymedia.com> X-OS: Debian/GNU Linux - weil ich es mir Wert bin! User-Agent: Mutt/1.5.9i X-Provags-ID: V01U2FsdGVkX1+ScjFtvuWKNd2OuKtI+O+d42sxGJevChhNX6h RrAUj7KZWR5DdBYifs3prqskq5ux/T6Jww7wHj1SesURHDjJiT CWRU/cb1aX0i2BjsyPIpyu4fWJJtMWM X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200712/57 X-Sequence-Number: 29749 am Tue, dem 11.12.2007, um 14:12:38 -0500 mailte PostgreSQL Admin folgendes: > This is my layout so far: > [ table-layout] > ... > Does this look correct? Yes, why not? Do you have problems? Which? I can't see problems, it's a normalized design IMHO. Andreas -- Andreas Kretschmer Kontakt: Heynitz: 035242/47150, D1: 0160/7141639 (mehr: -> Header) GnuPG-ID: 0x3FFF606C, privat 0x7F4584DA http://wwwkeys.de.pgp.net