Vertabelo / Vertabelo SA

0

To nie jest błąd

Don'tt update the column type PK-FK relationships

11 lat temu • Ostatnio zmodyfikowane przez 11 lat temu • 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.

Głosuj

Odpowiedź

11 lat temu

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.

0

Z odpowiedzią

mysql field description

11 lat temu • Ostatnio zmodyfikowane przez 11 lat temu • 3

Hi.

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

Thanks.

Głosuj

0

Z odpowiedzią

Importing DMD files

11 lat temu • Ostatnio zmodyfikowane przez 11 lat temu • 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.

Głosuj

Odpowiedź

11 lat temu

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.

0

Odrzucone

Support for NoSQL databases (MongoDB)

11 lat temu • Ostatnio zmodyfikowane przez 11 lat temu • 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?

Głosuj

0

Odrzucone

Bottom Panel Properties

11 lat temu • Ostatnio zmodyfikowane przez 11 lat temu • 3

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

Głosuj

0

Z odpowiedzią

unique column

11 lat temu • Ostatnio zmodyfikowane przez 11 lat temu • 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!

Głosuj

Odpowiedź

11 lat temu

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

0

Ukończony

Bool and or Tinyint (mysql)

11 lat temu • Ostatnio zmodyfikowane przez 11 lat temu • 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

Głosuj

0

Ukończony

MySQL datetime support

11 lat temu • Ostatnio zmodyfikowane przez 11 lat temu • 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.

Głosuj

0

Ukończony

change column order

11 lat temu • Ostatnio zmodyfikowane przez 11 lat temu • 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.

Głosuj

Odpowiedź

11 lat temu

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).