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

+2

Adding columns: batch add and paste

Nicholas Hohman 9 year бұрын 0

Be able to add X number of columns instead of one at a time. Then, can also paste them in if they're on the clipboard, one NBSP per time (e.g. from Excel, etc.).

+1

When importing, give option to add to existing model or new one

Nicholas Hohman 9 year бұрын 0

When you're on the model and import SQL, it overwrites whatevers in the model with what's imported from the SQL file. It would be neat if it added or gave you the option to overwrite model vs. add.

0
Answered

INT type for Year value throws Warning message

Marvin Abarca 9 year бұрын updated by Rafał Strzaliński (Senior Engineer) 9 year бұрын 2

Don't know why this is happening, I would like to create a column with the year value for example 2016,2015, 2014 etc... however the Table Problems is showing Warning

Image 292

0
Not a bug

vertabelo community

ahmed mohamed 9 year бұрын updated by Adam Mościcki 9 year бұрын 2

when i try to access the Catalog of database models by Vertabelo's community i get 404

did you remove it ?

Answer
Adam Mościcki 9 year бұрын

Hello,


This feature is unavailable right now, but we are going to restore it. I will keep you posted.

0

error in documentation: postgres sequences - nextval()

Josef Steppan 9 year бұрын жаңартылды 9 year бұрын 0

Hi,


just a minor error in one of your documentation pages:

http://www.vertabelo.com/documentation/database-model-elements/sequences


nextval(sequence_name) should be nextval('sequence_name') :


for reference:

http://www.postgresql.org/docs/current/static/functions-sequence.html



Also, thanks for providing such a great service, helped me a lot with my relational databases course :-)

+1
Started

Database type of model copy defaults to PostgreSQL

Adam Stojanowski 9 year бұрын updated by Adam Mościcki 9 year бұрын 2

I made a copy of DB2 model using "Make a copy" option in right-click menu on Documents screen.

Result: Copy defaulted to PostgreSQL db type.


Tested also for Oracle - same effect, db type of copy is PostgreSQL.

0

provide an option to add relation (the diamond shaped box)..which can be changed to a table with a click .Useful in case of many to many relationships

sravani singirikonda 9 year бұрын жаңартылды 9 year бұрын 0

provide an option to add relation (the diamond shaped box)..which can be changed to a table with a click .Useful in case of many to many relationships.

Also an option to show the kind of relation is useful(like many to many ,one to one ,many to one)

0

Foreign key order in the output SQL file

Michał Majcher 9 year бұрын 0

Foreign key DDL commands in the SQL output file from Vertabelo are ordered by constraint name. It would be more useful if they were ordered by table name first and later by constraint name or even better by referenced table name.


Current solution results in an unpleasant diff on the SQL file.

+1
Answered

how to specify schema for a reference ?

Ali Tabrizi 9 year бұрын updated by Rafał Strzaliński (Senior Engineer) 9 year бұрын 6

In SQL Model , please note that we are using 5 different schema in our model so we will need to specify each reference `s schema

0
Answered

How to install Vertabelo Client on Ubuntu server 14.04 ?

PRODHOMME Sébastien 9 year бұрын updated by Rafał Strzaliński (Senior Engineer) 9 year бұрын 3

I read this article https://my.vertabelo.com/db-connection to install Vertabelo Client. I download the Linux File but it hasn't a type format for this file like .deb or others. I tried to use dpkg command but it doesn't work.

Answer
anonymous 9 year бұрын

It's a binary file. You need to chmod +x and just run it.