Ygthkb

Euler and minus sign

What is the reason behind this musical reference to Pinocchio in the Close Encounters main theme?

Isn't a semicolon (';') needed after a function declaration in C++?

Why do we divide Permutations to get to Combinations?

Why are `&array` and `array` pointing to the same address?

Now...where was I?

Why is Bernie Sanders maximum accepted donation on actblue $5600?

Spells that would be effective against a Modern Day army but would NOT destroy a fantasy one

Can I combine Divination spells with Arcane Eye?

Build ASCII Podiums

How Create a list of the first 10,000 digits of Pi and sum it?

Boss asked me to sign a resignation paper without a date on it along with my new contract

What does an unprocessed RAW file look like?

SQL Server 2017 crashes when backing up because filepath is wrong

Log to console in a Lightning Web Component

If I have Haste cast on me, does it reduce the casting time for my spells that normally take more than a turn to cast?

Given the mapping a = 1, b = 2, ... z = 26, and an encoded message, count the number of ways it can be decoded

When distributing a Linux kernel driver as source code, what's the difference between Proprietary and GPL license?

Are encryption algorithms with fixed-point free permutations inherently flawed?

Manager has noticed coworker's excessive breaks. Should I warn him?

What does @ mean in a hostname in DNS configuration?

Identical projects by students at two different colleges: still plagiarism?

Why do we interpret the accelerated expansion of the universe as the proof for the existence of dark energy?

Multiple null checks in Java 8

Have multiple foreign keys or one

Remove duplicates and connect relations to the first oneForeign Key NULL vs Foreign Key to an empty stringUsing a GIN index on an integer array to model sets of tagsWhat are the pros and cons of storing two values in an array instead of two columns?Could I use both UUID and Sequential ID or is it bad designIs there any sense in using Postgres array of JSONB values instead of only JSONB?naming a column differently then its original one in foreign data wrapper of PostgreSQLcan we create a view using SUM or AVG depends on a condition?Inheritance and foreign keys in PostgresShould we favor multiple INSERTs or multiple UPDATEs

0

I have 3 table:

brand: brand_id(pk), name

product: product_id(pk), name

brand_product: brand_product_id(pk), brand_id, product_id

And I have a report table, at the moment it looks like this:

product_report: product_report_id(pk), quantity, brand_id, product_id

My question is, what are the pros and cons of having the brand_product_id column instead of brand_id, product_id.

postgresql postgresql-9.3

share|improve this question

asked Oct 14 '14 at 8:58

RockNinjaRockNinja

3053920

bumped to the homepage by Community♦ 8 mins ago

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

add a comment | 

0

I have 3 table:

brand: brand_id(pk), name

product: product_id(pk), name

brand_product: brand_product_id(pk), brand_id, product_id

And I have a report table, at the moment it looks like this:

product_report: product_report_id(pk), quantity, brand_id, product_id

My question is, what are the pros and cons of having the brand_product_id column instead of brand_id, product_id.

postgresql postgresql-9.3

share|improve this question

asked Oct 14 '14 at 8:58

RockNinjaRockNinja

3053920

bumped to the homepage by Community♦ 8 mins ago

This question has answers that may be good or bad; the system has marked it active so that they can be reviewed.

add a comment | 

I have 3 table:

brand: brand_id(pk), name

product: product_id(pk), name

brand_product: brand_product_id(pk), brand_id, product_id

And I have a report table, at the moment it looks like this:

product_report: product_report_id(pk), quantity, brand_id, product_id

My question is, what are the pros and cons of having the brand_product_id column instead of brand_id, product_id.

postgresql postgresql-9.3

share|improve this question

asked Oct 14 '14 at 8:58

RockNinjaRockNinja

3053920

share|improve this question

asked Oct 14 '14 at 8:58

RockNinjaRockNinja

3053920

share|improve this question

asked Oct 14 '14 at 8:58

RockNinjaRockNinja

3053920

asked Oct 14 '14 at 8:58

RockNinjaRockNinja

3053920

asked Oct 14 '14 at 8:58

RockNinjaRockNinja

3053920

1 Answer
1

active

oldest

votes

0

In my opinion the pros are:

• when using queries, you can select a specific row inside brand_product, by only using brand_product_id.


• if you want another table, connected to the brand_product table, you can specify the rows by just using the brand_product_id rather than the combination of brand_id and product_id (though, it's rare to connect a third table to a junction table like brand_product, but not impossible. I did it in my previous project)

cons:

• you can have a row with the same brand_id and product_id combination multiple times (but you can solve this by creating a unique index on the product_id and brand_id columns).

So it's not a bad idea to have a brand_product_id.

share|improve this answer

answered Oct 14 '14 at 9:43

Erik van de VenErik van de Ven

386316

add a comment | 

Your Answer

StackExchange.ready(function() {
var channelOptions = {
tags: "".split(" "),
id: "182"
};
initTagRenderer("".split(" "), "".split(" "), channelOptions);

StackExchange.using("externalEditor", function() {
// Have to fire editor after snippets, if snippets enabled
if (StackExchange.settings.snippets.snippetsEnabled) {
StackExchange.using("snippets", function() {
createEditor();
});
}
else {
createEditor();
}
});

function createEditor() {
StackExchange.prepareEditor({
heartbeatType: 'answer',
autoActivateHeartbeat: false,
convertImagesToLinks: false,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: null,
bindNavPrevention: true,
postfix: "",
imageUploader: {
brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
allowUrls: true
},
onDemand: true,
discardSelector: ".discard-answer"
,immediatelyShowMarkdownHelp:true
});


}
});

draft saved

draft discarded

Sign up or log in

StackExchange.ready(function () {
StackExchange.helpers.onClickDraftSave('#login-link');
});

Sign up using Google

Sign up using Facebook

Sign up using Email and Password

Post as a guest

Name

Email

Required, but never shown

StackExchange.ready(
function () {
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fdba.stackexchange.com%2fquestions%2f80115%2fhave-multiple-foreign-keys-or-one%23new-answer', 'question_page');
}
);

Post as a guest

Name

Email

Required, but never shown

0

In my opinion the pros are:

• when using queries, you can select a specific row inside brand_product, by only using brand_product_id.


• if you want another table, connected to the brand_product table, you can specify the rows by just using the brand_product_id rather than the combination of brand_id and product_id (though, it's rare to connect a third table to a junction table like brand_product, but not impossible. I did it in my previous project)

cons:

• you can have a row with the same brand_id and product_id combination multiple times (but you can solve this by creating a unique index on the product_id and brand_id columns).

So it's not a bad idea to have a brand_product_id.

share|improve this answer

answered Oct 14 '14 at 9:43

Erik van de VenErik van de Ven

386316

add a comment | 

0

In my opinion the pros are:

• when using queries, you can select a specific row inside brand_product, by only using brand_product_id.


• if you want another table, connected to the brand_product table, you can specify the rows by just using the brand_product_id rather than the combination of brand_id and product_id (though, it's rare to connect a third table to a junction table like brand_product, but not impossible. I did it in my previous project)

cons:

• you can have a row with the same brand_id and product_id combination multiple times (but you can solve this by creating a unique index on the product_id and brand_id columns).

So it's not a bad idea to have a brand_product_id.

share|improve this answer

answered Oct 14 '14 at 9:43

Erik van de VenErik van de Ven

386316

add a comment | 

In my opinion the pros are:

• when using queries, you can select a specific row inside brand_product, by only using brand_product_id.


• if you want another table, connected to the brand_product table, you can specify the rows by just using the brand_product_id rather than the combination of brand_id and product_id (though, it's rare to connect a third table to a junction table like brand_product, but not impossible. I did it in my previous project)

cons:

• you can have a row with the same brand_id and product_id combination multiple times (but you can solve this by creating a unique index on the product_id and brand_id columns).

So it's not a bad idea to have a brand_product_id.

share|improve this answer

answered Oct 14 '14 at 9:43

Erik van de VenErik van de Ven

386316

share|improve this answer

answered Oct 14 '14 at 9:43

Erik van de VenErik van de Ven

386316

answered Oct 14 '14 at 9:43

Erik van de VenErik van de Ven

386316

answered Oct 14 '14 at 9:43

Erik van de VenErik van de Ven

386316