Re: [GENERAL] Am I supposed to be all scared of compound primary keys?

2010-05-04 Thread Chris Browne
m...@kitchenpc.com (Mike Christensen) writes: > I have a table that stores a user ID and a subscription type, and this is > really all it needs to store and any pair of values will always be unique.  In > fact, I think this pair should be the primary key on the table.  However, I'm > using Castle A

Re: [GENERAL] Am I supposed to be all scared of compound primary keys?

2010-05-01 Thread jus...@magwerks.com
On Sat, 2010-05-01 at 19:25 -0700, Mike Christensen wrote: -->I have a table that stores a user ID and a subscription type, and this is really all it needs to store and any pair of values will always be unique. In fact, I think this pair should be the primary key on the table. However, I'm

Re: [GENERAL] Am I supposed to be all scared of compound primary keys?

2010-05-01 Thread Christophe Pettus
On May 1, 2010, at 7:25 PM, Mike Christensen wrote: \And I quote: Quick Note: Composite keys are highly discouraged. Use only when you have no other alternative. I get the feeling they're discouraged from a SQL point of view, but it doesn't actually say why anywhere. Is there any good r

Re: [GENERAL] Am I supposed to be all scared of compound primary keys?

2010-05-01 Thread Scott Marlowe
On Sat, May 1, 2010 at 8:25 PM, Mike Christensen wrote: > I have a table that stores a user ID and a subscription type, and this is > really all it needs to store and any pair of values will always be unique. > In fact, I think this pair should be the primary key on the table.  However, > I'm usin

[GENERAL] Am I supposed to be all scared of compound primary keys?

2010-05-01 Thread Mike Christensen
I have a table that stores a user ID and a subscription type, and this is really all it needs to store and any pair of values will always be unique. In fact, I think this pair should be the primary key on the table. However, I'm using Castle ActiveRecord which says at: http://www.castleproject.or