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

  1. Forum: Vertabelo
0
Answered

Canvas size is huge. How do I reduce it?.

Ronald Dantonio 9 years ago • updated by anonymous 9 years ago • 2
How do I reduce the size of the canvas. I have accidentally made it huge. Everything else is now microscopic.
Answer
anonymous 9 years ago
You're right, there are two kinds of zoom: Vertabelo zoom and a browser zoom. Vertabelo zoom affects only a diagram, while a browser zoom affects the whole page.
In Chrome you can edit the browser zoom in the menu or using mouse wheel together with Ctrl pressed.
0
Answered

How can I change my trial plan to the academic one?

taavi podzuks 9 years ago • updated 9 years ago • 3
How can i change my plan to an academic one? Im a student in the estonian information technology college. I think is a similar problem as in http://support.vertabelo.com/topic/818837-i-cannot-change-my-plan-to-academic-but-i-am-a-tafe-student/ thread.

0
Started

sqlite generate er diagram from sql

Martin Chiu 9 years ago • updated 9 years ago • 3
Hello Vertabelo,
I am using your student account so you may not find my bug report a high priority. I will tell you though I tried to generate tables and a lot of things were not marked properly or tables were not linked properly. Mainly, the many to many tables. I have posted my SQL below so you may recreate the problem. It is fairly easy to reproduce. Anyway, the specific bugs you'll see are things like the table "genre" not being linked to anything and it also created a NULL primary key and marked other things as NULL that it shouldn't. The data base used is SQLite 3.7.x Well I hope this helps!


SQL USED

CREATE TABLE IF NOT EXISTS movie(id INTEGER PRIMARY KEY, title VARCHAR(150) NOT NULL, language CHAR(20), tagline VARCHAR(500), release_date DATE);

CREATE TABLE IF NOT EXISTS country(id INTEGER PRIMARY KEY, name CHAR(75) NOT NULL);

CREATE TABLE IF NOT EXISTS genre(id INTEGER PRIMARY KEY, type CHAR(50) NOT NULL);

CREATE TABLE IF NOT EXISTS theater(id INTEGER PRIMARY KEY, in_business INTEGER, website_url VARCHAR(100), mantinee_endtime DATETIME, phone_number CHAR(20) );

CREATE TABLE IF NOT EXISTS showtime(id INTEGER PRIMARY KEY, expires DATE NOT NULL, showtime DATETIME NOT NULL, movie_id INTEGER, showingtype_id INTEGER, theater_id INTEGER, FOREIGN KEY(movie_id) REFERENCES movie(id), FOREIGN KEY(theater_id) REFERENCES theater(id), FOREIGN KEY(showingtype_id) REFERENCES showingtype(id) );

CREATE TABLE IF NOT EXISTS showingtype(id INTEGER PRIMARY KEY, type CHAR(40) NOT NULL);

CREATE TABLE IF NOT EXISTS price(id INTEGER PRIMARY KEY, enddate DATE NOT NULL,cost DOUBLE NOT NULL, mantinee INTEGER NOT NULL, showingtype_id INTEGER, theater_id INTEGER, FOREIGN KEY(theater_id) REFERENCES theater(id), FOREIGN KEY(showingtype_id) REFERENCES showingtype(id));

CREATE TABLE IF NOT EXISTS state(id INTEGER PRIMARY KEY, state CHAR(2));

CREATE TABLE IF NOT EXISTS zipcode(id INTEGER PRIMARY KEY, zipcode CHAR(5));

CREATE TABLE IF NOT EXISTS location(id INTEGER PRIMARY KEY, street VARCHAR(100), state_id INTEGER, zipcode_id INTEGER, country_id INTEGER, FOREIGN KEY(state_id) REFERENCES state(id), FOREIGN KEY(zipcode_id) REFERENCES zipcode(id), FOREIGN KEY(country_id) REFERENCES country(id));

CREATE TABLE IF NOT EXISTS reviewer(id INTEGER PRIMARY KEY, first_name CHAR(50), last_name CHAR(50));

CREATE TABLE IF NOT EXISTS review(review VARCHAR(255) NOT NULL, title VARCHAR(150) NOT NULL, rating INTEGER, last_updated TIMESTAMP, date_posted DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP, movie_id INTEGER, reviewer_id INTEGER, PRIMARY KEY(movie_id, reviewer_id), FOREIGN KEY(reviewer_id) REFERENCES reviewer(id), FOREIGN KEY(movie_id) REFERENCES movie(id));

CREATE TABLE IF NOT EXISTS cast_crew(id INTEGER PRIMARY KEY, first_name CHAR(50), last_name CHAR(50), date_death DATETIME, date_birth DATETIME, job_title VARCHAR(100));




CREATE TABLE IF NOT EXISTS movie_country(movie_id INTEGER, country_id INTEGER, PRIMARY KEY(movie_id, country_id) FOREIGN KEY(movie_id) REFERENCES movie(id),
FOREIGN KEY(country_id) REFERENCES country(id));

CREATE TABLE IF NOT EXISTS movie_genre(movie_id INTEGER, genre_id INTEGER, PRIMARY KEY(movie_id, genre_id) FOREIGN KEY(movie_id) REFERENCES movie(id), FOREIGN KEY(genre_id) REFERENCES genre(id));

CREATE TABLE IF NOT EXISTS movie_theater(movie_id INTEGER, theater_id INTEGER, PRIMARY KEY(movie_id, theater_id) FOREIGN KEY(movie_id) REFERENCES movie(id), FOREIGN KEY(theater_id) REFERENCES theater(id));

CREATE TABLE IF NOT EXISTS movie_cast_crew(movie_id INTEGER, cast_crew_id INTEGER, PRIMARY KEY(movie_id, cast_crew_id), FOREIGN KEY(movie_id) REFERENCES movie(id), FOREIGN KEY(cast_crew_id) REFERENCES cast_crew(id));




0
Answered

How to reopen closed account?

Sruthi Guvvala 9 years ago • updated by Jack Polkowski 9 years ago • 1
I just closed my account. How can i reopen it
0
Completed

"Open diagram" and "new diagram" to open in the current browser tab not in a new one.

Станислав Милев 9 years ago • updated by Jack Polkowski 9 years ago • 1
If i want a new tab, i would click the action with the scroll or right (mouse) click and "open in new tab".
0
Not a bug

Seems to be some issue with multi select functionality

Shantanu Kher 9 years ago • updated by anonymous 9 years ago • 2
If I select more than one objects while pressing / key, it selects all those objects for further processing. However it does not display all of them as SELECTED. Only last selected object appears as SELECTED. There seems to be some issue with multiple selection. Please advise.
0
Answered

I cannot see my model

Cloud Mason 9 years ago • updated by anonymous 9 years ago • 2
The graphical display of my model seems to have disappeared. I can click on the the tables and see all the columns and properties, but I cannot get the graph to display.
0
Completed

Export selected subset of Tables to .png

Gabe Gates 9 years ago • updated by anonymous 9 years ago • 1
Once a model becomes too big to export as .png there isn't much of an alternative (that I'm aware of) to share. It would be awesome to define a set of tables / areas to export. Currently I have to split up the main model and create smaller models in order to export and share.
Answer
anonymous 9 years ago
There already is such an option. You can just select multiple tables (and references or views) and click the button to export to PNG. Only these elements will be present on the image. The same applies to the subject area - just select an area and export it to PNG.

If it's about managing large diagrams, please watch this video tutorial:

It explains how to make the work with big diagrams easier using subject areas and table shortcuts.
+7
Under review

Option to hide all references and leave only tables displayed

Patrick Otin 9 years ago • updated by Gabe Gates 9 years ago • 2
My model is huge and it consists of over 100 tables and twice as more references. The jungle of lines was very confusing for me. Therefore, I deleted all references and used table colors, sizes and positions, as well as subject areas to visualize the structure of my database.
It would be great for me if Vertabelo had an option allowing user to hide all references without deleting them.
The other idea is to allow user to hide all references and show only these ones which are associated with the currently selected table. If no table is selected, all references are hidden but when the cursor is over the table, all references associated with that table are being displayed in gray. If user selects the table, all these references (associated with the table) are shown in normal color (black).
0
Answered

[PostgreSQL] Add quotes to generated SQL table names and columns

john palat 9 years ago • updated 9 years ago • 2
PostgreSQL does not require double quotes around table names and identifiers, it will just lower case them. However, I want them to remain in a certain case in the database. For example, if I add a table Team, I want it to show up as Team, not team. The generated sql will not add any quotes to the name unless it's a reserved keyword. Is there a way for me to add this? I only found this: http://support.vertabelo.com/topic/529465-postgresql-script-generated-ignore-double-quota-set-schema-and-tablespace-name/


but I don't think it's related.




Also with FK, if I have Team_id as a column, it will become team_id in the database w/o quotes. Help?
Answer
anonymous 9 years ago
Just check the "Quote all SQL identifiers" checkbox in "SQL generation settings" section:




All table and column names will be in double quotes.


Customer support service by UserEcho