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

0
Є відповідь

Multiple references

Martin Mocko 10 років тому оновлено Rafał Strzaliński (Senior Engineer) 10 років тому 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
Є відповідь

Insert Data into Tables and Optionality

Rob Doyle 10 років тому оновлено John Bonifas 10 років тому 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
Відповідь
anonymous 10 років тому
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
Under review

How do I change notations?

Michael Winkler 11 років тому оновлено Rob Doyle 10 років тому 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
Not a bug

Subject area names is sticking out of the region

Cristian Vasile 10 років тому оновлено anonymous 10 років тому 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
Відповідь
anonymous 10 років тому
You can move these labels. Just click and hold mouse button, move the label and release the mouse button.
0
Є відповідь

Executing sql quires

hussain reddy 10 років тому оновлено Agnieszka Kozubek-Krycuń (Chief Scientist) 10 років тому 2
0
Fixed

some bugs - keyboard shortcuts

koch 10 років тому оновлено Agnieszka Kozubek-Krycuń (Chief Scientist) 10 років тому 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
Виконано

How to connect my project to vertabelo database?

Huyền Huỳnh 10 років тому оновлено Jan Grzegorek 10 років тому 2
Please help me!
0
Fixed

Canvas is not redrawing on bottom and side right

Hans Rattink 10 років тому оновлено anonymous 10 років тому 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
Виконано

Define a computed column

Kindler Chase 10 років тому оновлено anonymous 10 років тому 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.
Відповідь
anonymous 10 років тому
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
Є відповідь

Can not see model

Hans Rattink 10 років тому оновлено anonymous 10 років тому 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?
Відповідь
anonymous 10 років тому
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.