Re: MCPK and sequences

[prev] [thread] [next] [Date index for 2004/09/21]

MCPK comes up all the time in many-many. The mapping table one uses to 
decompose the relationship into two 1:n relationships has  MCPK : 
the PK of each of the component tables of the relationship is a column and 
one would normally use that as a key. Is uppose you could instead assign a 
serial to each and use a single PK but you're going to be doing retrievals
on the component PK's....so its a bit silly.