Would you like to make your database modeling faster and more convenient? Of course you would! One way to achieve this is to learn your database modeling tool’s keyboard shortcuts. To check them when working in Vertabelo, press Ctrl + I. Our favourite Vertabelo shortcuts Down arrow in the Columns section Did you know that you can move between columns in your table using arrow keys?

From today until Christmas Eve, we’re going to publish some tips & tricks for Vertabelo. Check our blog every day for a new one! List of all available tips: How to move a column up or down Use keyboard shortcuts in Vertabelo! How to copy tables between models How to make a column unique How to quote table names in generated SQL script How to create a multicolumn primary key How to include comments in SQL script How to name a primary key How to create multiple references between two tables How to use a data type that isn’t listed in the data types panel Vertabelo reports that my data type is not supported.

Have you ever changed your mind about the order of columns in your table? You probably have! Fortunately, changing the order of columns in Vertabelo is as easy as pie. Select the table that contains the column you want to move up or down. In Table properties on the right, you can see a list of the columns. On the left of each column’s name, there is a column selector:

We listened to your feedback and improved managing Vertabelo team accounts. No more confusing switching back and forth between personal and team accounts. And since Vertabelo is all about modeling, we couldn’t stop ourselves from using database models to explain the upcoming changes. In the next couple of days we will introduce major changes to the way we handle Vertabelo team accounts. After the changes are implemented, each user account will either be a personal account or be a member of a team account.

If you’ve ever had to design a database model with hundreds of tables, views and references, you know very well how difficult is to make such huge diagram readable and comprehensible. One of the possible solutions is to use some colors to distinguish different groups of tables or subject areas. See how Vertabelo allows you to do this quick and easy. To illustrate how you can color your entity relationship diagram to increase its readability, we will use a sample uncolored database model for a simple online store:

In this video you will learn how to start creating your database model. You will find out why nouns are important and how you should handle them when creating a database model. If you want to learn more, read our beginner tutorial on how to create a database model. iframe.video-plugin { width: 735px; height: 415px; border: 0px solid #CCC; margin: 0px; } @media all and (max-width: 767px) { iframe.

We're happy to announce that Vertabelo has a new feature we've been working on for some time: Photo Reverse Engineering. This is the quickest way to transfer your hand-written design sketches into Vertabelo. Draw your model on a piece of paper, a whiteboard, or a blackbord, take a photo, upload it into Vertabelo and you're done: your model is in Vertabelo. How it works Draw your model on a board, or a piece of paper.

It's already been 100 days since we launched Vertabelo and there are already 1000 satisfied Vertabelo users. Thank you for your trust and interaction! What did our journey look like? We had 18 years of experience in building big business applications. We knew that existing tools for designing databases didn't match the demands of the current digital world, so we took up the challenge to create a tool which supports collaborationand distributed teams, has a non-intrusive user interface, and enables you to work from your web browser.

In this video tutorial you will learn about references – how to create a relationship between the tables, how it affects their structure, and how it looks in the data. iframe.video-plugin { width: 735px; height: 415px; border: 0px solid #CCC; margin: 0px; } @media all and (max-width: 767px) { iframe.video-plugin { width: 250px; height: 141px; } }

Vertabelo presents part 2 of our Database Design 101 series that brings you easy-to-understand introduction to databases. This time we will focus on table columns and most commonly used data types. iframe.video-plugin { width: 735px; height: 415px; border: 0px solid #CCC; margin: 0px; } @media all and (max-width: 767px) { iframe.video-plugin { width: 250px; height: 141px; } }