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













0















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?









share|improve this question




























    0















    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?









    share|improve this question


























      0












      0








      0








      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?









      share|improve this question
















      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






      share|improve this question















      share|improve this question













      share|improve this question




      share|improve this question








      edited 12 hours ago









      inetphantom

      1,28011943




      1,28011943










      asked 14 hours ago









      FerFer

      41




      41






















          2 Answers
          2






          active

          oldest

          votes


















          0














          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.






          share|improve this answer






























            0














            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.






            share|improve this answer






















              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
              );



              );













              draft saved

              draft discarded


















              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









              0














              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.






              share|improve this answer



























                0














                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.






                share|improve this answer

























                  0












                  0








                  0







                  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.






                  share|improve this answer













                  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.







                  share|improve this answer












                  share|improve this answer



                  share|improve this answer










                  answered 14 hours ago









                  AbdoAbdo

                  637




                  637























                      0














                      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.






                      share|improve this answer



























                        0














                        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.






                        share|improve this answer

























                          0












                          0








                          0







                          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.






                          share|improve this answer













                          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.







                          share|improve this answer












                          share|improve this answer



                          share|improve this answer










                          answered 13 hours ago









                          inetphantominetphantom

                          1,28011943




                          1,28011943



























                              draft saved

                              draft discarded
















































                              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.




                              draft saved


                              draft discarded














                              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





















































                              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







                              Popular posts from this blog

                              Kamusi Yaliyomo Aina za kamusi | Muundo wa kamusi | Faida za kamusi | Dhima ya picha katika kamusi | Marejeo | Tazama pia | Viungo vya nje | UrambazajiKuhusu kamusiGo-SwahiliWiki-KamusiKamusi ya Kiswahili na Kiingerezakuihariri na kuongeza habari

                              SQL error code 1064 with creating Laravel foreign keysForeign key constraints: When to use ON UPDATE and ON DELETEDropping column with foreign key Laravel error: General error: 1025 Error on renameLaravel SQL Can't create tableLaravel Migration foreign key errorLaravel php artisan migrate:refresh giving a syntax errorSQLSTATE[42S01]: Base table or view already exists or Base table or view already exists: 1050 Tableerror in migrating laravel file to xampp serverSyntax error or access violation: 1064:syntax to use near 'unsigned not null, modelName varchar(191) not null, title varchar(191) not nLaravel cannot create new table field in mysqlLaravel 5.7:Last migration creates table but is not registered in the migration table

                              은진 송씨 목차 역사 본관 분파 인물 조선 왕실과의 인척 관계 집성촌 항렬자 인구 같이 보기 각주 둘러보기 메뉴은진 송씨세종실록 149권, 지리지 충청도 공주목 은진현