Forum OpenACS Q&A: Re: One to Many Relationship

Collapse
2: Re: One to Many Relationship (response to 1)
Posted by Peter Marklund on 08/27/03 04:09 PM
You may use a mapping table:

create table a_to_b_map (
  a_id integer references a_table(a_id) unique,
  b_id integer references b_table(b_id)
  unique(a_id, b_id)
);

This table lets you map one a object to many b objects.