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

+2
En revisión

Bulk update table properties

Grzegorz Kaczor hace 9 años actualizado por anonymous hace 9 años 1
I would like to be able to bulk update properties of selected tables. For example, set tablespace for all tables except one. Or change initial value of multiple sequences. Now I have to click all the tables, one by one.
0
Respuestas

How to add and hide references on diagram?

Grzegorz Kaczor hace 9 años actualizado por anonymous hace 9 años 3
I have table A which is connected to many other entities, and I want to organize my diagram better.

So I drag the second copy of table A (the one with dashed borders) to the diagram. And I drag table B next to it. How can I draw an existing reference between these tables?

And how can I hide reference between original table A and table B? I don't want to delete the reference, I just want to hide its particular instance in the picture.
Respuesta
anonymous hace 9 años
So I drag the second copy of table A (the one with dashed borders) to the diagram. And I drag table B next to it. How can I draw an existing reference between these tables?
OK, you can do this with exactly 4 mouse clicks. First, select those tables (2 clicks). Then click on the reference symbol in the menu and choose "Show all references" option:




The reference will show up.

And how can I hide reference between original table A and table B? I don't want to delete the reference, I just want to hide its particular instance in the picture.
If an object (table or reference) has more than one visual representation (has dashed borders), it's deletion is deletion of visual representation only. The model object is deleted when its last visual representation is deleted.
0
Respuestas

How are anonymous models saved between browser sessions?

Timothy Duch hace 9 años actualizado por anonymous hace 9 años 2
I'm curious as to how Vertabelo is remembering my (anonymous) model between my browser sessions. I have cookies turned off, so where is Vertabelo storing this information? I cleared my history, and the model is magically no longer saved (I figured it was done via cookies... so why is it gone now even though cookies were turned off earlier?). There are obvious reasons as to why this question is important.
0
Respuestas

How can you export the schema so as to import the schema into MS Access?

Marco Naylon hace 9 años actualizado por anonymous hace 9 años 1
I want to be able to have all the tables and relationships imported so I can test queries.
Respuesta
anonymous hace 9 años
Vertabelo does not support MS Access in any special way.

If you want to test queries using a DBMS you chose when creating a model, I'd recommend you SQL Fiddle. It supports MySQL, Oracle, PostgreSQL, MS SQL Server and SQLite.
0
Respuestas

Do high schools count under the educational plans?

Kenny Cohen hace 9 años actualizado por Jack Polkowski hace 9 años 2
I was just wondering if there was any way that my high school friend could register for vertabelo using his high school id and email as he is not in college yet. We are teaching each other how to build database systems.

Thanks
0
Respuestas

Vilnius University Mathematical and Informatics faculty email address. Cannot get Academic plan. Possible to be fixed?

Tomas Juodokas hace 9 años actualizado por Agnieszka Kozubek-Krycuń (Chief Scientist) hace 9 años 1
Can you add this email to whitelist? Need vertabelo for learning and academic purposes.
University email: name.surname@mif.stud.vu.lt
Faculty website: http://mif.vu.lt/lt3/
0
Iniciado

Check with newline generated to SQL without spaces

Grzegorz Kaczor hace 9 años actualizado por Agnieszka Kozubek-Krycuń (Chief Scientist) hace 9 años 3
I have a check:

CONDITION
OR
CONDITION

written in 3 lines. In generated SQL the check looks like:

CONDITIONORCONDITION

but it should be

CONDITION OR CONDITION
0
Respuestas

How to control order of views in generated SQL?

Grzegorz Kaczor hace 9 años actualizado por anonymous hace 9 años 1
How can I control the order in which views are written to generated SQL file?

I have 2 views - A and B that uses A. So I need A to be defined before I can define B. But Vertabelo defines B first, and the SQL fails.

Could you please help?
Respuesta
anonymous hace 9 años
In the "View properties" (on the right-hand side after selecting a view) there's a section called "Dependencies." Just add A as a dependency to the view B.
+1
En revisión

PDF generation problems

Nuo Xu hace 10 años actualizado por Agnieszka Kozubek-Krycuń (Chief Scientist) hace 9 años 4
when i use print to generate pdf version i came across 2 problems. first one is , when i go back to the edit model, i lost my previous work which i believed it should be aotu saved. Second is , it always breaks my design into several pages which i wanted it to be in one page. Since it beaks my design into several pages, it breaks my tables and references into different pages and makes it hard to read
0
Respuestas

Couldnt share my data model to my team.

Thullimalli Chandrika hace 9 años actualizado por Jack Polkowski hace 9 años 3
I Couldnt Share my data model to all members in my team.I could share to a single person.:(