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

0
Respuestas

how to create ENUM in mysql

Markemark hace 11 años actualizado por Mariusz Zakrzewski hace 7 años 10
How can I create enumerated type.
For simplicity sake, say Male and Female

many thanks

Mark
Respuesta
anonymous hace 11 años
Just insert your desired type into "Type" input. The selector (layer) with types contains only the most common datatypes. You can change it to whatever type you want. It looks like this:



This will rise a validation error saying that the type is not supported. This is our bug (not a critical one, I think). You can turn this validation off in "Model validation settings" which you can find in the menu on the top left, just below the Vertabelo logo. This validation rule is called "Supported database type (warnings)" in "Table column" section.
0
Respuestas

reference name seems to be invalid

Obiora Nwosu hace 7 años actualizado por anonymous hace 7 años 4
0
COMPLETADO

Need to change to a student account

John Daroch hace 7 años actualizado por Rafał Strzaliński (Senior Engineer) hace 7 años 1

i have signed up for a normal account and i needed to set up a student account. how do i do this as i have already done complete work on here and i dont want to lose it.

0
Solucionado

The Oracle SQL generator dont add the comments associate to the tables and columns.

Erika Valerio hace 7 años actualizado por Mariusz Zakrzewski hace 7 años 3

A couple of days ago I used the sql generator and the comments were associated without problems. However, today I try to generate the Oracle SQL of my model and it does not add any comments to the objects. My account is free for the moment. I would appreciate your quick response and attention. Greetings.

0
COMPLETADO

pg_dump and pg_dump all tools backup create zero size backup file from linux putty terminal

nigersultana10 hace 7 años actualizado hace 7 años 2

I have install postgres database version 9.6 , 10  on OS Centos 7 64 bit. trying to taken backup with this command

-bash-4.2$ pg_dump -h localhost -Fc backupdb > /var/lib/pgsql/niger_pgbackup/nigerpg_bkp.sql.

but problem is the backup file size had zero . I have tried many time. Kindly help where i have wrong.

-bash-4.2$ pg_dump -h localhost -Fc backupdb > /var/lib/pgsql/niger_pgbackup/nig erpg_bkp.sql
-bash-4.2$ cd niger_pgbackup/
-bash-4.2$ ls -ltr
total 0
-rwxrwxrwx 1 postgres postgres 0 Oct 7 23:38 nigerpg_bkp.sql

Regards

Niger

0
COMPLETADO

how can i sql execute queary

Yash Sharma hace 7 años actualizado por Rafał Strzaliński (Senior Engineer) hace 7 años 1
0
Respuestas

Made a foreign key, but this relationship is not shown in SQL preview

le_univers hace 7 años actualizado por Rafał Strzaliński (Senior Engineer) hace 7 años 1

Apology if this is too basic, but I'm really new to everything and struggling.

So I know how to make a foreign key 

: When there are 2 entities, A and B, you draw a reference from A to B and voila,

the primary keys of A are shown in the B entity boxes as foreign keys, with some names like "A_id".

But when I actually check the SQL preview of B, I don't see any such information as that this data is coming from A.

Am I missing something? How can I make a SQL code like below show up?


PRIMARY KEY (sid, cid), FOREIGN KEY (sid) REFERENCES Students

0
COMPLETADO

External Connection?

mbilliodeaux+vertabelo hace 7 años actualizado hace 7 años 4

Is there a way that I can create and edit tables and records using either:

  • MySQL WorkBench or 
  • PGAdmin?

Thanks in advance

Respuesta
Adam Mościcki hace 7 años

Hello,

Vertabelo is a database modeling tool. You can create a database model, generate an SQL script and then apply it with WorkBench or PGAdmin.
We don't have any integration with those tools per se.

Best regards,
Adam Mościcki

+13
COMPLETADO

Allow multiple imports to one model

Kent Graziano hace 10 años actualizado por Adam Mościcki hace 7 años 5
It would be nice to allow us to run the import or reverse engineering utility multiple times for one model. Then we can incrementally build out a design based on other databases.

I tried to import a second DDL file (with additional views) to my model and that over wrote my entire existing model. Not good.

Thankfully I was able to use the restore feature to bring back the previous version from before the import.
0
Respuestas

Wrong sign up option

Matthew Powell hace 10 años actualizado por Marco Sepp hace 7 años 8

I have signed up to vertabelo wrong, I was supposed to sign up through my University and use Vertabelo for education purposes only. However, i've signed up to a basic account and now I'm being asked to upgrade my account. Is there any way I can get my models from this account to a new account for academic purposes?