Tag: Vertabelo Feature

What Are Document Types in Vertabelo?

Create logical data model documents, physical data model documents, and SQL script documents using Vertabelo. Vertabelo allows you to create and import your models with three different types of documents. This article takes you through all three Vertabelo document types: the logical data model, the physical data model, and the SQL script. These documents let you start modeling from scratch or import your existing progress into Vertabelo. The different representations of the same data model help a variety of people understand the model.

How to Add a Table to Your ER Diagram in Vertabelo

Find out how to add a table to your ER Diagram in Vertabelo. A table in a database is where some data about something is stored and organized logically in rows and columns. The columns in a table represent data and its types. For instance, a database for an e-commerce website would likely have a client table where data about each client is stored. It will very likely have a name column of type string.

Database Sequences and How to Define Them in Vertabelo

All rows in a database need to have a unique identifier. But what if you need to have unique identifiers for all of the rows in all of your tables? We know GUIDs are problematic when indexing, so what other options are there? A database sequence might be a great option.   What Is a Database Sequence? A database sequence is a type of object created in a database that allows developers to generate unique values.

Constraints in PostgreSQL and How to Model Them in Vertabelo

Database constraints allow you to give a certain shape to your data, tables, and columns. Are you planning to use PostgreSQL as your database? Check out what PostgreSQL constraints can do! In this article, we will go over PostgreSQL’s database constraints and see how to model them in Vertabelo. For each of the constraints, I’ll provide: A definition of the constraint. A usage example. Instructions on how to model the constraint in Vertabelo.

Vertabelo Feature: Live Model Validation

A data model is more than just a pretty drawing that impresses users and stakeholders. When you add model validation to the design process, your data model can save you many hours of database-related work. When you design a data model, your ultimate goal is for the model to become a functional database. However, your model is basically a drawing, while the database is a not-so-flexible structure that holds information.

How to Import an Existing Database into Vertabelo

Find out how to easily import an existing database into the Vertabelo data modeler. If you're reading this article, you probably know you need to import your database into Vertabelo. Or maybe you’re wondering if you should do it. Here are some reasons that can convince you if you’re hesitating. And we’ll also explain how to import a database into Vertabelo. Why Import an Existing Database into Vertabelo? 1. You'd like to analyze the database structure.

Our website uses cookies. By using this website, you agree to their use in accordance with the browser settings. You can modify your browser settings on your own. For more information see our Privacy Policy.