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

0
Z odpowiedzią

Multiple references

Martin Mocko 10 lat temu Ostatnio zmodyfikowane przez Rafał Strzaliński (Senior Engineer) 10 lat temu 3
Hello, I would like to know how to create multiple foreign key references to only one primary key value in a different table. What I'm trying to accomplish is something like this - I have two tables - Team and Match. A match is always played between two teams, so I would like to have two foreign keys that reference a Team primary key (an id). However I seem to have a problem doing this because I'm getting an error which you can see in the image included. How can I avoid this error or what should I be doing differently ? The error arises as soon as I add the Team2_id foreign key. Thanks very much for the help.
Image 53
0
Z odpowiedzią

Insert Data into Tables and Optionality

Rob Doyle 10 lat temu Ostatnio zmodyfikowane przez John Bonifas 10 lat temu 3
I'm very new to relational databases and just getting my feet wet with oracle so my questions may seem obvious. I thought learning a data modelling tool may help me understand what has been a difficult subject.
I am trying to build a simple database in oracle of 12 tables and for example 1 table is customers. I have 10 different people I want to add to that table which would be done using insert in Oracle.
Can I add this data in Vertabelo or does it only create the columns?
Also can optionality be display in the relationships using broken lines like oracles notation?
Thanks
Rob
Odpowiedź
anonymous 10 lat temu
You cannot store your data in Vertabelo. Here you create database structure only.

Vertabelo supports only "crow's feet" notation of references. There is a topic regarding other notations: http://support.vertabelo.com/topic/532861-how-do-i-change-notations/ Please upvote and/or comment it if you'd like it to be implemented.
+9
W trakcie analizy

How do I change notations?

Michael Winkler 11 lat temu Ostatnio zmodyfikowane przez Rob Doyle 10 lat temu 3
Are any other notations than crow's foot supported? If so how do I switch to the other notations?

And also it seems like there is no n:m ?
0
To nie jest błąd

Subject area names is sticking out of the region

Cristian Vasile 10 lat temu Ostatnio zmodyfikowane przez anonymous 10 lat temu 1
Hello, I'm having troubles with the subject areas. If I use a longer name, it sticks out of the area's rectangle.Image 52
Odpowiedź
anonymous 10 lat temu
You can move these labels. Just click and hold mouse button, move the label and release the mouse button.
0
Z odpowiedzią

Executing sql quires

hussain reddy 10 lat temu Ostatnio zmodyfikowane przez Agnieszka Kozubek-Krycuń (Chief Scientist) 10 lat temu 2
0
Naprawione

some bugs - keyboard shortcuts

koch 10 lat temu Ostatnio zmodyfikowane przez Agnieszka Kozubek-Krycuń (Chief Scientist) 10 lat temu 2
In keyboard shortcuts screen, there are some bugs.

"Ctrl + Alt + P : Toggle navigation, Ctrl + Alt + N : Toggle properties" may be exchanged.

Ctrl + Alt + N : Toggle navigation
Ctrl + Alt + P : Toggle properties

I think that the above is right and it works with the given explaination.
0
Ukończony

How to connect my project to vertabelo database?

Huyền Huỳnh 10 lat temu Ostatnio zmodyfikowane przez Jan Grzegorek 10 lat temu 2
Please help me!
0
Naprawione

Canvas is not redrawing on bottom and side right

Hans Rattink 10 lat temu Ostatnio zmodyfikowane przez anonymous 10 lat temu 5
When panning or zooming, the bottom of the canvas gets all messy, about the height of the little pan-box. This one also can't be minimized, allthough the arrow is still there. This is happening since this noon. Restarting the browser doesn't help
0
Ukończony

Define a computed column

Kindler Chase 10 lat temu Ostatnio zmodyfikowane przez anonymous 10 lat temu 1
Is there a way to create a computed column, specifically for SQL Server? ex:

create table Entries
(
    Id int identity (1,1) not null,
    Process varchar(50) not null,
    ProcessDate datetime not null,
    Date as convert(date, ProcessDate),
    Time as convert(time, ProcessDate)
)

The last 2 columns are computed and I'd like to be able to define them with Vertabelo. Is that possible? If not, I'd like to suggest it as a feature.
Odpowiedź
anonymous 10 lat temu
Well, you can define do this, but not straight. In "Table properties" you have a section called "Additional SQL scripts." You can add "After create table" statement like this:
ALTER TABLE Entries 
DROP COLUMN Date;

ALTER TABLE Entries
ADD Date AS convert(date, ProcessDate);

This way you'll have both visual representation on the diagram and the proper behavior (a computed column).
I know it's a kind of workaround but adding tons of options like this to our UI would make Vertabelo unusable.
0
Z odpowiedzią

Can not see model

Hans Rattink 10 lat temu Ostatnio zmodyfikowane przez anonymous 10 lat temu 3
A user from my organisation has created a model (after accepting my invitation on vertabello) but i can't see it. When i click on the user (Koen), i can see he created it but then i still can't open it. How can i see the model?
Odpowiedź
anonymous 10 lat temu
The model must be shared with you by its owner (the user who created the model). This way the owner has control over who is an editor or just a viewer of the model.

I've looked at your case and it looks like you've already figured it out yourself. If you have any other questions or ideas, feel free to contact us.