Tag: Vertabelo Feature

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.