Your feedback is highly appreciated! Let's make Vertabelo even better.
Схожі теми не знайдені.

0
Є відповідь
Multiple references
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.



0
Є відповідь
Insert Data into Tables and Optionality
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
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.
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?
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 ?
And also it seems like there is no n:m ?

0
Not a bug
Subject area names is sticking out of the region
Hello, I'm having troubles with the subject areas. If I use a longer name, it sticks out of the area's rectangle.


Відповідь
anonymous
10 років тому
You can move these labels. Just click and hold mouse button, move the label and release the mouse button.

0
Fixed
some bugs - keyboard shortcuts
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.
"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
Fixed
Canvas is not redrawing on bottom and side right
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
Is there a way to create a computed column, specifically for SQL Server? ex:
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.
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:
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.
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
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.
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.
Служба підтримки клієнтів працює на UserEcho