Your feedback is highly appreciated! Let's make Vertabelo even better.

0
Answered

No Logical Models for Individual Subscriptions?

jperry 6 months ago updated by Jarosław Błąd (CEO) 6 months ago 1

Do I understand that correctly?  The pricing page makes it seem like I'd have to purchase a "Team" subscription to get this ability.  That makes no sense, if that's the case.

Jason

0

ACTUAL Support for Conceptual Modeling

Jason Perry 6 months ago updated 6 months ago 1

Unfortunately, this post was closed by your CEO several years back claiming that conceptual modeling had already been added: https://support.vertabelo.com/communities/1/topics/207-support-for-conceptual-modeling#


Terry Halpin (and I) would disagree.  Would love to see ORM and Property Graph Schemas added to the current ER diagram capabilities, which might be sufficient for Logical modeling - but lacking in several area where Conceptual modeling is concerned.

0
Completed

Support for conceptual modeling

Chad Harper 10 years ago updated by Jason Perry 6 months ago 4

App would be complete for me if I could do true conceptual modeling (multivalue attributes and many-to-many relationships).

Conceptual modeling, by definition, is more abstract than logical modeling. Often, I need a conceptual model to communicate the business rules with nontechnical people. This is also something I teach my students to do. Vertabelo doesn't support conceptual modeling in this way, but if it did it would be a complete full data stack tool.

Answer

Conceptual/Logical modelling has been already intruduced in Vertabelo.

+2

Please update snowflake datatypes!

Bruno Cavestro 10 months ago updated by Philippe Maisonnave 7 months ago 1

TIMESTAMP_NTZ is not in standard data type nor
binary with precision ...
impossible to load SQL script from snowflake :(

0
Answered

Is the publish functionality still available?

Pavel Yeliseev 7 months ago updated 7 months ago 2

There's an article in the documentation mentioning that I can publish a model to be embeded in a website here -

https://vertabelo.com/blog/database-modeling-tip-14-how-to-create-a-model-preview-link-and-embed-the-model-in-a-website/

But I don't see these links anywhere in the UI. Is this feature still available? 

+3

CAPTCHA

koal 10 months ago 0

Image 1524

i have no idea what's wrong. i have tried with many codes, still not working :/

0

Temporal Tables

Eden Ravenwood 10 months ago 0

Is it possible to flag a table as a Temporal Table as defined in MS SQL Server 2016 and later?

Temporal tables are declared with the following syntax:

CREATE TABLE Department
(
DeptID INT NOT NULL PRIMARY KEY CLUSTERED,
DeptName VARCHAR(50) NOT NULL,
ManagerID INT NULL,
ParentDeptID INT NULL,
ValidFrom DATETIME2 GENERATED ALWAYS AS ROW START NOT NULL,
ValidTo DATETIME2 GENERATED ALWAYS AS ROW END NOT NULL,
PERIOD FOR SYSTEM_TIME (ValidFrom, ValidTo)
)
WITH (SYSTEM_VERSIONING = ON)
;

The bold elements define the table as a Temporal table (Temporal tables - SQL Server | Microsoft Learn)

I can get the WITH clause using the 'WITH options' under additional properties for the table, and I can create 'ValidFrom' and 'ValidTo' columns of type datetime2, but I can't see a way to set the properties of those columns to correctly apply GENERATED ALWAYS AS ROW START and GENERATED ALWAYS AS ROW END, or to apply the PERIOD FOR SYSTEM_TIME (ValidFrom, ValidTo) property.  I can probably use a text macro in notepad++ on the generated SQL to add this but it would be nice if it was supported in Vertabelo?

0
Answered

Team edition pricing

MaxA 1 year ago updated by Łukasz Kubicki 1 year ago 1

I’d like some clarity on your pricing model. Is the Team price listed on your pricing page (https://vertabelo.com/pricing/) - $83/month for a team of up to 5 (with a total annual payment of $996) - the total cost for all 5 seats, or is it the price per seat (per team member)? In other words, will purchasing a 5-seat Team license cost a total of $415/month, or $4,980 annually?

0

How to add Enum Types

Philipp Albrecht 1 year ago 0

How does one create an Enum in Vertabelo

https://www.postgresql.org/docs/current/datatype-enum.html