Vertabelo / Vertabelo SA

0

Respuestas

Please, switch my trial account to academic account

hace 9 años • actualizado por hace 9 años • 2

I am not able to convert my account to an academic one. Please help me.

Voto

0

No es un bug

Copy relationships along with table shortcut

hace 9 años • actualizado por hace 9 años • 5

When I do a copy and past shortcut for multiple tables that are related, it should automatically show the relationships between those tables. Now it looks like I must create a 2nd relationship between the shortcut tables.

Voto

0

Respuestas

Share button is not active

hace 9 años • actualizado por hace 9 años • 2

I have an academic plan, and the share button is not active. Does academic plans not able to share the model?

I do believe this button was active at some point time ago

Voto

Respuesta

hace 9 años

Hi!
Inactive "share" button means that you are not the owner of the model and you can't invite new persons to share it.
If you'd like to check your role in the model, go to the "Model details" panel. For that particular model, your role is set as an editor.

I noticed that in your case the model had been shared with you by the owner who then closed his/her account. So at the moment the model doesn't have its owner.

If you would like to share it with other persons, first you must clone it. Once again, go to the "Model details" panel, then click the button "Clone model" on the right. Since you are the owner of the cloned model, you can share it with other persons.

I hope I helped you.

Best regards and enjoy Vertabelo!

0

En revisión

Error in view builder using LEAD function

hace 9 años • actualizado por hace 9 años • 3

When I try to create a view using this SQL I get a parsing error:
SELECT

dbms_obfuscation_toolkit.md5(upper(trim(HC.COUNTRY_ABBRV))

|| '^'

|| TO_CHAR(SC.SAT_Load_DTS, 'YYYY-MM-DD')) AS DIM2_COUNTRY_KEY,

HC.COUNTRY_ABBRV,

SC.COUNTRY_NAME,

SC.SAT_Load_DTS AS EFFECTIVE_DTS,

LEAD(SC.SAT_Load_DTS) OVER (PARTITION BY SC.HUB_COUNTRY_KEY ORDER BY

SC.SAT_Load_DTS) AS EXPIRE_DTS,

SC.SAT_Rec_SRC AS REC_SRC

FROM

HUB_COUNTRY HC,

SAT_COUNTRIES SC

WHERE

HC.HUB_COUNTRY_KEY = SC.HUB_COUNTRY_KEY

Voto

0

Respuestas

request for switching my account to the academic one

hace 9 años • actualizado por hace 9 años • 1

Voto

Respuesta

hace 9 años

Hi! Your account has been switched to the academic one. After logging in, you'll be requested to complete the registration form.
Best regards and enjoy Vertabelo!

0

Respuestas

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

hace 9 años • actualizado por hace 9 años • 2

How do I reduce the size of the canvas. I have accidentally made it huge. Everything else is now microscopic.

Voto

Respuesta

hace 9 años

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

Respuestas

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

hace 9 años • actualizado hace 9 años • 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.

Voto

0

Iniciado

sqlite generate er diagram from sql

hace 9 años • actualizado hace 9 años • 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));