On 2010-02-09, Louis-David Mitterrand <vindex+lists-pgsql-sql(at)apartia(dot)org> wrote:
> Hello,
>
> In my database I have different object types (person, location, event,
> etc.) all of which can have several images attached.
can one image be several people?
can one image be both event and location?
> 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)?
probably several join tables
image_location image_person image_event
with uniques and cascades where needed.