Hibernate Community • View topic - Many-to-Many Join Table Primary Key Recommendation

View unanswered posts | View active topics

Board index » Hibernate & Java Persistence » NHibernate Users

All times are UTC - 5 hours [ DST ]

Many-to-Many Join Table Primary Key Recommendation

Page 1 of 1

[ 1 post ]

Previous topic | Next topic

Author

Message

IceCactus

Post subject: Many-to-Many Join Table Primary Key Recommendation

Posted: Thu Sep 22, 2005 1:28 pm

Newbie

Joined: Tue Sep 20, 2005 10:22 pm
Posts: 6

Hi,

I currenly am using Composite primary key for a many to many join table. Is this recommend? Or should i use a auto-incretmenting ID column and create a unique key (composite) on the two foreign key columns?

im using MSSQL and Firebird

Currently table looks like this

ProductID -primary key 1
CategoryID -primary key 2
Notes

it appears that by NOT using composite keys it will make my life easier :)

Thanks

Top

Page 1 of 1

[ 1 post ]

Board index » Hibernate & Java Persistence » NHibernate Users

All times are UTC - 5 hours [ DST ]

You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum