24 Database Modeling Tips for Vertabelo

Tip #6 – How to Create a Multicolumn Primary Key

Vertabelo Team

Posted: December 6, 2015

Primary keys may contain more than one column. Multicolumn primary keys are frequently used for junction tables, which are used to model many-to-many relationships.

Select a table:

Select a table, junction table

In the Table properties panel on the right, check all the columns that you want inside the key:

In the ‘Table properties’ panel, check all the columns you want inside the key, Multicolumn primary key

Now, you have a multicolumn primary key created:

Now, you have your multicolumn primary key created

You can check out your SQL code by clicking the SQL preview button in the top right corner:

Your multicolumn primary key as seen in the SQL code preview


Try our online database modeler. No registration. No commitments.

Subscribe to our newsletter

If you find this article useful, join our weekly newsletter to be notified about the latest posts.

It's Time to Master Python Gain practical knowledge of Python or prepare for a coding interview. Let's Do This Other Python courses: