Composite Primary Key on mysql workbenchShould I use the datetime or timestamp data type in MySQL?Setting up foreign keys in phpMyAdmin?Sqlite primary key on multiple columnsHow to find all tables that have foreign keys that reference particular table.column and have values for those foreign keys?Multiple-column foreign key in MySQL?How can I define a composite primary key in SQL?Mysql error 1452 - Cannot add or update a child row: a foreign key constraint failsALTER TABLE to add a composite primary keyMySQL error code: 1175 during UPDATE in MySQL Workbenchcomposite foreign key not working
Can I say "fingers" when referring to toes?
Shouldn’t conservatives embrace universal basic income?
Did the UK lift the requirement for registering SIM cards?
What is the difference between lands and mana?
Why can't the Brexit deadlock in the UK parliament be solved with a plurality vote?
15% tax on $7.5k earnings. Is that right?
Circuit Analysis: Obtaining Close Loop OP - AMP Transfer function
Multiplicative persistence
Is this toilet slogan correct usage of the English language?
What's the name of the logical fallacy where a debater extends a statement far beyond the original statement to make it true?
What are some good ways to treat frozen vegetables such that they behave like fresh vegetables when stir frying them?
Permission on Database
Will number of steps recorded on FitBit/any fitness tracker add up distance in PokemonGo?
Why is the Sun approximated as a black body at ~ 5800 K?
Why does Carol not get rid of the Kree symbol on her suit when she changes its colours?
Is it necessary to use pronouns with the verb "essere"?
Can I cause damage to electrical appliances by unplugging them when they are turned on?
Why is the "ls" command showing permissions of files in a FAT32 partition?
What is Cash Advance APR?
How to preserve electronics (computers, iPads and phones) for hundreds of years
Giving feedback to someone without sounding prejudiced
Can you use Vicious Mockery to win an argument or gain favours?
Creating two special characters
A Trivial Diagnosis
Composite Primary Key on mysql workbench
Should I use the datetime or timestamp data type in MySQL?Setting up foreign keys in phpMyAdmin?Sqlite primary key on multiple columnsHow to find all tables that have foreign keys that reference particular table.column and have values for those foreign keys?Multiple-column foreign key in MySQL?How can I define a composite primary key in SQL?Mysql error 1452 - Cannot add or update a child row: a foreign key constraint failsALTER TABLE to add a composite primary keyMySQL error code: 1175 during UPDATE in MySQL Workbenchcomposite foreign key not working
I am generating composite primary key on cart table product_Id
and User_Id
. Those are primary keys on the product
table and user
table accordingly.
So
- Do I need to do a reference to these primary keys (foreign keys so the only existing ids are the one existing in both tables)?
- Can I leave it as two primary keys ?
- How do I add them in MySqlWorkbench?
mysql mysql-workbench composite-primary-key
add a comment |
I am generating composite primary key on cart table product_Id
and User_Id
. Those are primary keys on the product
table and user
table accordingly.
So
- Do I need to do a reference to these primary keys (foreign keys so the only existing ids are the one existing in both tables)?
- Can I leave it as two primary keys ?
- How do I add them in MySqlWorkbench?
mysql mysql-workbench composite-primary-key
add a comment |
I am generating composite primary key on cart table product_Id
and User_Id
. Those are primary keys on the product
table and user
table accordingly.
So
- Do I need to do a reference to these primary keys (foreign keys so the only existing ids are the one existing in both tables)?
- Can I leave it as two primary keys ?
- How do I add them in MySqlWorkbench?
mysql mysql-workbench composite-primary-key
I am generating composite primary key on cart table product_Id
and User_Id
. Those are primary keys on the product
table and user
table accordingly.
So
- Do I need to do a reference to these primary keys (foreign keys so the only existing ids are the one existing in both tables)?
- Can I leave it as two primary keys ?
- How do I add them in MySqlWorkbench?
mysql mysql-workbench composite-primary-key
mysql mysql-workbench composite-primary-key
edited 12 hours ago
inetphantom
1,28011943
1,28011943
asked 14 hours ago
FerFer
41
41
add a comment |
add a comment |
2 Answers
2
active
oldest
votes
From what I've tried in the past, the best thing to do is to make product_id and user_id as foreign keys and reference them to their respective primary keys in tables product and user.
This way you can be sure that the data is not being filled wrong.
add a comment |
It depends on what you want to achieve with your database.
Most probably you want to add them as foreign keys to your n to n table. Easiest thing is to open the workbench in the modeling view and define a n to n relation between product and user.
This will make sure that you have data integrity on your tables.
You might want to have only one connection per user - product pair. You can achieve this by either creating a unique index no those two or making them primary key for that new table. I personally would not go for a composed key as your model might change and you then are way more flexible.
add a comment |
Your Answer
StackExchange.ifUsing("editor", function ()
StackExchange.using("externalEditor", function ()
StackExchange.using("snippets", function ()
StackExchange.snippets.init();
);
);
, "code-snippets");
StackExchange.ready(function()
var channelOptions =
tags: "".split(" "),
id: "1"
;
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: true,
noModals: true,
showLowRepImageUploadWarning: true,
reputationToPostImages: 10,
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
);
);
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
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55279809%2fcomposite-primary-key-on-mysql-workbench%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
2 Answers
2
active
oldest
votes
2 Answers
2
active
oldest
votes
active
oldest
votes
active
oldest
votes
From what I've tried in the past, the best thing to do is to make product_id and user_id as foreign keys and reference them to their respective primary keys in tables product and user.
This way you can be sure that the data is not being filled wrong.
add a comment |
From what I've tried in the past, the best thing to do is to make product_id and user_id as foreign keys and reference them to their respective primary keys in tables product and user.
This way you can be sure that the data is not being filled wrong.
add a comment |
From what I've tried in the past, the best thing to do is to make product_id and user_id as foreign keys and reference them to their respective primary keys in tables product and user.
This way you can be sure that the data is not being filled wrong.
From what I've tried in the past, the best thing to do is to make product_id and user_id as foreign keys and reference them to their respective primary keys in tables product and user.
This way you can be sure that the data is not being filled wrong.
answered 14 hours ago
AbdoAbdo
637
637
add a comment |
add a comment |
It depends on what you want to achieve with your database.
Most probably you want to add them as foreign keys to your n to n table. Easiest thing is to open the workbench in the modeling view and define a n to n relation between product and user.
This will make sure that you have data integrity on your tables.
You might want to have only one connection per user - product pair. You can achieve this by either creating a unique index no those two or making them primary key for that new table. I personally would not go for a composed key as your model might change and you then are way more flexible.
add a comment |
It depends on what you want to achieve with your database.
Most probably you want to add them as foreign keys to your n to n table. Easiest thing is to open the workbench in the modeling view and define a n to n relation between product and user.
This will make sure that you have data integrity on your tables.
You might want to have only one connection per user - product pair. You can achieve this by either creating a unique index no those two or making them primary key for that new table. I personally would not go for a composed key as your model might change and you then are way more flexible.
add a comment |
It depends on what you want to achieve with your database.
Most probably you want to add them as foreign keys to your n to n table. Easiest thing is to open the workbench in the modeling view and define a n to n relation between product and user.
This will make sure that you have data integrity on your tables.
You might want to have only one connection per user - product pair. You can achieve this by either creating a unique index no those two or making them primary key for that new table. I personally would not go for a composed key as your model might change and you then are way more flexible.
It depends on what you want to achieve with your database.
Most probably you want to add them as foreign keys to your n to n table. Easiest thing is to open the workbench in the modeling view and define a n to n relation between product and user.
This will make sure that you have data integrity on your tables.
You might want to have only one connection per user - product pair. You can achieve this by either creating a unique index no those two or making them primary key for that new table. I personally would not go for a composed key as your model might change and you then are way more flexible.
answered 13 hours ago
inetphantominetphantom
1,28011943
1,28011943
add a comment |
add a comment |
Thanks for contributing an answer to Stack Overflow!
- Please be sure to answer the question. Provide details and share your research!
But avoid …
- Asking for help, clarification, or responding to other answers.
- Making statements based on opinion; back them up with references or personal experience.
To learn more, see our tips on writing great answers.
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
Required, but never shown
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f55279809%2fcomposite-primary-key-on-mysql-workbench%23new-answer', 'question_page');
);
Post as a guest
Required, but never shown
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
Required, but never shown
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
Required, but never shown
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
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown
Required, but never shown