Received: from maia.hub.org (unknown [200.46.208.211]) by mail.postgresql.org (Postfix) with ESMTP id 6B42F632B6F for ; Tue, 9 Feb 2010 03:55:15 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.208.211]) (amavisd-maia, port 10024) with ESMTP id 91418-04 for ; Tue, 9 Feb 2010 07:55:01 +0000 (UTC) X-Greylist: delayed 00:05:49.160235 by SQLgrey-1.7.6 Received: from sargon.lncsa.com (mail.lncsa.com [213.215.28.11]) by mail.postgresql.org (Postfix) with ESMTP id A61CB6326C4 for ; Tue, 9 Feb 2010 03:55:04 -0400 (AST) Received: from localhost (localhost.localdomain [127.0.0.1]) by sargon.lncsa.com (Postfix) with ESMTP id 8185E301E6CB for ; Tue, 9 Feb 2010 08:49:13 +0100 (CET) X-Virus-Scanned: Debian amavisd-new at lncsa.com Received: from sargon.lncsa.com ([127.0.0.1]) by localhost (sargon.lncsa.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id Nwcb7lxhqb2t for ; Tue, 9 Feb 2010 08:49:13 +0100 (CET) Received: from zenon.apartia.fr (zenon.apartia.fr [10.0.3.1]) (using TLSv1 with cipher DHE-RSA-AES256-SHA (256/256 bits)) (Client CN "zenon.apartia.fr", Issuer "ca.apartia.fr" (verified OK)) by sargon.lncsa.com (Postfix) with ESMTP id 65CBD300E022 for ; Tue, 9 Feb 2010 08:49:13 +0100 (CET) Received: from delos.apartia.fr (delos.apartia.fr [10.0.3.107]) by zenon.apartia.fr (Postfix) with ESMTP id 22A6A5BBF25EF for ; Tue, 9 Feb 2010 08:49:10 +0100 (CET) Received: by delos.apartia.fr (Postfix, from userid 1000) id 01E4F201FED28; Tue, 9 Feb 2010 08:49:09 +0100 (CET) Date: Tue, 9 Feb 2010 08:49:09 +0100 From: Louis-David Mitterrand To: pgsql-sql@postgresql.org Subject: 'image' table with relationships to different objects Message-ID: <20100209074909.GA11838@apartia.fr> Mail-Followup-To: pgsql-sql@postgresql.org MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline User-Agent: Mutt/1.5.20 (2009-06-14) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.67 tagged_above=-10 required=5 tests=AWL=0.930, BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 201002/32 X-Sequence-Number: 33631 Hello, In my database I have different object types (person, location, event, etc.) all of which can have several images attached. What is the best way to manage a single 'image' table with relationships to (potentially) many different object types while keeping referrential integrity (foreign keys)? Thanks,