Request a Demo
Home   >   mailing lists

'image' table with relationships to different objects - Mailing list pgsql-sql

From Louis-David Mitterrand
Subject 'image' table with relationships to different objects
Date
Msg-id 20100209074909.GA11838@apartia.fr
Whole thread Raw
Responses Re: 'image' table with relationships to different objects
Re: 'image' table with relationships to different objects
List pgsql-sql
Tree view 
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,

pgsql-sql by date:

Previous
From: Yeb Havinga
Date:
Subject: Re: Howto have a unique restraint on UPPER (textfield)
Next
From: Michael Lourant
Date:
Subject: Re: 'image' table with relationships to different objects