Vertabelo / Vertabelo SA

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

oder senden Sie eine nicht öffentliche Nachricht

Keine ähnlichen Beiträge gefunden.

0 Ähnliche Beiträge gefunden. Stimme dafür ab.

Not a bug

Don'tt update the column type PK-FK relationships

vor 11 Jahren • aktualisiert von vor 11 Jahren • 3

When I change the column type to another value in a table with PK in another table that contains the FK does not update.

It will correct this?

Sorry for my english, thanks.

Abstimmen

Antwort

vor 11 Jahren

Not updating the type of FK column is a desired behaviour. This is because you can have, for instance, "SERIAL" datatype for your PK and "INT" type for FK and this is perfectly valid structure (I'm talking about PostgreSQL now, but such cases exist in other RDBMSs as well).
If you change the PK type and the types of PK and FK don't match, you should get an error in the "Problems" section.

Beantwortet

mysql field description

vor 11 Jahren • aktualisiert von vor 11 Jahren • 3

Hi.

Mysql field description not have a sql script. Whats problem ?

Thanks.

Abstimmen

Beantwortet

Importing DMD files

vor 11 Jahren • aktualisiert von vor 11 Jahren • 1

Is there a way to import .dmd files(oracle plataform)? Because I have some db normalizations that I have to implant in my project. If not, that would be a great and useful idea! :)

Obs: Sorry for my english, I need to improve that.

Abstimmen

Antwort

vor 11 Jahren

The import of .dmd files is not possible yet. We're planning to add import from various database modeling tools in the future but certainly not in the next couple of months. For now, you can try our reverse engineering tool or import from SQL scripts.

Abgelehnt

Support for NoSQL databases (MongoDB)

vor 11 Jahren • aktualisiert von vor 11 Jahren • 3

I know if you expanded support for NoSQL DBs (MongoDB) our company would jump fully on board. You have the basics to do this already and really no competitors.

Is there plans for this?

Abstimmen

Abgelehnt

Bottom Panel Properties

vor 11 Jahren • aktualisiert von vor 11 Jahren • 3

It would be good to put the properties panel at the bottom

Abstimmen

Beantwortet

unique column

vor 11 Jahren • aktualisiert von vor 11 Jahren • 1

I looked around in the diagram editor but I'm not able to find where I can make a column unique. This would be helpful when generating SQL to inject into my database. Is this just a feature thats not implement or am I just missing it. Thanks for the help!

Abstimmen

Antwort

vor 11 Jahren

We support UNIQUE statement. This is called "alternate key" and you can find it in the table properties panel.

Fertiggestellt

Bool and or Tinyint (mysql)

vor 11 Jahren • aktualisiert von vor 11 Jahren • 2

Missing important data type for mysql BOOL which is actually TINYINT(1).
http://dev.mysql.com/doc/refman/5.0/en/numeric-type-overview.html

Abstimmen

Fertiggestellt

MySQL datetime support

vor 11 Jahren • aktualisiert von vor 11 Jahren • 2

In our Mysql application, we need to represent a future unknown date as 9999-12-31 00:00:00 and we use the DateTime datatype. Unfortunately, we find that Vertabelo did not support DateTime but only Timestamp, that cannot go beyond 2038.

So we have to manually, modified the SQL generated in Vertabelo to change Timestamp to DateTime.

This reduce the usability of designing big database with a lot of DateTime fields in Vertabelo.

We like to request the adding of Mysql DateTime support.

Abstimmen

Fertiggestellt

change column order

vor 11 Jahren • aktualisiert von vor 11 Jahren • 1

Need to provide a way to re-arranged the order of Columns in a table.
During iterative development process, new fields are added that is better position not at the end of the table.

Abstimmen

Antwort

vor 11 Jahren

You can re-arrange the order of columns in the Table properties panel on the right. Hold the mouse button down over the dotted area to the left of the column name (see the picture below).