Welcome to Software Development on Codidact!
Will you help us build our independent community of developers helping developers? We're small and trying to grow. We welcome questions about all aspects of software development, from design to code to QA and more. Got questions? Got answers? Got code you'd like someone to review? Please join us.
Post History
Let's say we have two tables A and B and a join table C that has foreign keys to both A and B and the combination of those foreign keys is unique. One could either do a unique constraint or a comp...
#19: Post edited
by
Alexei
·
2020-12-20T19:45:48Z (almost 4 years ago)
added relevant tags
#18: Post edited
by
pnuts
·
2020-12-20T19:44:42Z (almost 4 years ago)
[software-practices] as a tag here is just useless noise. [Ref](https://software.codidact.com/questions/277891#comment-3960))
What are the pros and cons of a composite primary key versus a unique constraint?
Let's say we have two tables A and B and a join table C that has foreign keys to both A and B and the combination of those foreign keys is unique. One could either do a unique constraint or a composite primary key on those columns. What would the pros and cons of either solution to this be?
#17: Post edited
by
ArtOfCode
·
2020-09-02T21:16:32Z (over 4 years ago)
#16: Post edited
by
Moshi
·
2020-09-02T21:15:47Z (over 4 years ago)
Let's say we have two tables A and B and a join table C that has foreign keys to both A and B and the combination of those foreign keys is unique. One could either do a unique constraint or a composite primary key on those columns. What would the pros and cons of either solution to this be?
#15: Post edited
by
Moshi
·
2020-09-02T21:15:12Z (over 4 years ago)
Let's say we have two tables A and B and a join table C that has foreign keys to both A and B and the combination of those foreign keys is unique. One could either do a unique constraint or a composite primary key on those columns. What would the pros and cons of either solution to this be?
#14: Post edited
by
Moshi
·
2020-09-02T21:15:05Z (over 4 years ago)
Let's say we have two tables A and B and a join table C that has foreign keys to both A and B and the combination of those foreign keys is unique. One could either do a unique constraint or a composite primary key on those columns. What would the pros and cons of either solution to this be?
#13: Post edited
by
Moshi
·
2020-09-02T21:13:02Z (over 4 years ago)
Let's say we have two tables A and B and a join table C that has foreign keys to both A and B and the combination of those foreign keys is unique. One could either do a unique constraint or a composite primary key on those columns. What would the pros and cons of either solution to this be?
#12: Post edited
by
Moshi
·
2020-09-02T21:07:57Z (over 4 years ago)
Let's say we have two tables A and B and a join table C that has foreign keys to both A and B and the combination of those foreign keys is unique. One could either do a unique constraint or a composite primary key on those columns. What would the pros and cons of either solution to this be?
#11: Post edited
by
Moshi
·
2020-09-02T21:07:57Z (over 4 years ago)
Let's say we have two tables A and B and a join table C that has foreign keys to both A and B and the combination of those foreign keys is unique. One could either do a unique constraint or a composite primary key on those columns. What would the pros and cons of either solution to this be?
#10: Post edited
by
Moshi
·
2020-09-02T21:07:56Z (over 4 years ago)
Let's say we have two tables A and B and a join table C that has foreign keys to both A and B and the combination of those foreign keys is unique. One could either do a unique constraint or a composite primary key on those columns. What would the pros and cons of either solution to this be?
#9: Post edited
by
Moshi
·
2020-09-02T21:07:56Z (over 4 years ago)
Let's say we have two tables A and B and a join table C that has foreign keys to both A and B and the combination of those foreign keys is unique. One could either do a unique constraint or a composite primary key on those columns. What would the pros and cons of either solution to this be?
#8: Post edited
by
Moshi
·
2020-09-02T21:07:56Z (over 4 years ago)
Let's say we have two tables A and B and a join table C that has foreign keys to both A and B and the combination of those foreign keys is unique. One could either do a unique constraint or a composite primary key on those columns. What would the pros and cons of either solution to this be?
#7: Post edited
by
Moshi
·
2020-09-02T21:07:56Z (over 4 years ago)
Let's say we have two tables A and B and a join table C that has foreign keys to both A and B and the combination of those foreign keys is unique. One could either do a unique constraint or a composite primary key on those columns. What would the pros and cons of either solution to this be?
#6: Post edited
by
Moshi
·
2020-09-02T21:07:56Z (over 4 years ago)
Let's say we have two tables A and B and a join table C that has foreign keys to both A and B and the combination of those foreign keys is unique. One could either do a unique constraint or a composite primary key on those columns. What would the pros and cons of either solution to this be?
#5: Post edited
by
Moshi
·
2020-09-02T21:07:55Z (over 4 years ago)
Let's say we have two tables A and B and a join table C that has foreign keys to both A and B and the combination of those foreign keys is unique. One could either do a unique constraint or a composite primary key on those columns. What would the pros and cons of either solution to this be?
#4: Post edited
by
Moshi
·
2020-09-02T21:07:55Z (over 4 years ago)
Let's say we have two tables A and B and a join table C that has foreign keys to both A and B and the combination of those foreign keys is unique. One could either do a unique constraint or a composite primary key on those columns. What would the pros and cons of either solution to this be?
#3: Post edited
by
Moshi
·
2020-09-02T21:07:53Z (over 4 years ago)
Let's say we have two tables A and B and a join table C that has foreign keys to both A and B and the combination of those foreign keys is unique. One could either do a unique constraint or a composite primary key on those columns. What would the pros and cons of either solution to this be?
#2: Post edited
by
Charlie Brumbaugh
·
2020-08-24T02:33:31Z (over 4 years ago)
Lets say we have two tables A and B and a join table C that has foreign keys to both A and B and the combination of those foreign keys are unique.One could either do a unique constraint on those foreign keys or a composite primary key on those columns.- What would the pros and cons of either solution to this be?
- Let's say we have two tables A and B and a join table C that has foreign keys to both A and B and the combination of those foreign keys is unique.
- One could either do a unique constraint or a composite primary key on those columns.
- What would the pros and cons of either solution to this be?
#1: Initial revision
by
Charlie Brumbaugh
·
2020-08-24T00:18:39Z (over 4 years ago)
What are the pros and cons of a composite primary key versus a unique constraint?
Lets say we have two tables A and B and a join table C that has foreign keys to both A and B and the combination of those foreign keys are unique. One could either do a unique constraint on those foreign keys or a composite primary key on those columns. What would the pros and cons of either solution to this be?