September 11, 2021 - 1 minutes read

Vertabelo Document Types

Dominika is a Python software developer. She graduated from the Warsaw University of Technology with a degree in computer science. At Vertabelo, she creates content as a technical writer. In her free time, she runs, practices yoga, and learns foreign languages.

There are various document types in Vertabelo: folders, physical data models, logical data models, and SQL scripts. What do they do, and how can you tell them apart visually?

Go to your drive. In the right panel, you’ll find folders, which are designated by this icon . Folders can contain documents or other folders.

Inside folders you can place: logical data models, physical data models and SQL scripts.

Logical data models include all entities and their relationships. They also show attribute optionality as well as relationship optionality and cardinality.

Physical data models represent how the objects should be implemented. They define specific tables, data types, views, indexes, and other database objects. They also include all table structures, e.g. columns, primary keys, and foreign keys.

SQL scripts are additional SQL scripts that you may want to keep in Vertabelo.