On 2010-02-09, Louis-David Mitterrand <vindex+lists-pgsql-...@apartia.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. -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
