Page 1 of 1

primary key to primary key

Posted: Tue Aug 15, 2006 10:19 pm
by GeXus
Is it bad design to have the same primary key used in multiple tables?

For example, I have users and images tables... user_id is the primary for users, and I was going to have user_id be the primary for images as well, as the images are related to a specific user...

Posted: Tue Aug 15, 2006 10:22 pm
by feyd
it's done all the time.

Posted: Tue Aug 15, 2006 10:27 pm
by GeXus
Nice, thanks!