On 2010-02-09, Louis-David Mitterrand <[email protected]> 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql
