Quick Links

'image' table with relationships to different objects

From:	Louis-David Mitterrand <vindex+lists-pgsql-sql(at)apartia(dot)org>
To:	pgsql-sql(at)postgresql(dot)org
Subject:	'image' table with relationships to different objects
Date:	2010-02-09 07:49:09
Message-ID:	20100209074909.GA11838@apartia.fr
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-sql

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,

Responses

Re: 'image' table with relationships to different objects at 2010-02-09 11:34:10 from Michael Lourant
Re: 'image' table with relationships to different objects at 2010-02-09 11:59:14 from Richard Huxton
Re: 'image' table with relationships to different objects at 2010-02-11 11:05:38 from Jasen Betts

Browse pgsql-sql by date

	From	Date	Subject
Next Message	Michael Lourant	2010-02-09 11:34:10	Re: 'image' table with relationships to different objects
Previous Message	Yeb Havinga	2010-02-05 20:57:10	Re: Howto have a unique restraint on UPPER (textfield)