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

0
Résolu

add two foreing keys

Freddy Contreras il y a 8 ans mis à jour par anonymous il y a 8 ans 1

i need create two foreing keys in one table, for example in table PROFILE (id_user1, id_user2) add relations from table USER (id_user). i have a problem: reference name must be unique.

0
À l'étude

does not support xmltype datatype

Shantanu Kher il y a 8 ans mis à jour par anonymous il y a 8 ans 1

I am building a datamodel for Oracle 11g engine. I need to define a column type as xmltype that Oracle engine very well supports, but It is showing an error message saying 'the engine you chooses does not support the datatype you defined'.


Please assist.

0
Résolu

Unable to delete user

Daniel Sopher il y a 8 ans mis à jour par anonymous il y a 8 ans 3

Trying to delete a duplicate user but it is greyed out telling me I cannot because there are documents assigned.


I can't find any feature that allows me to remove documents from the user so I can delete them.


Please advise.

0
Résolu

No university domain

wolterlw il y a 8 ans mis à jour par Rafał Strzaliński (Senior Engineer) il y a 8 ans 3

I study at Igor Sikorsky Kyiv Polytechnic Institute (Ukraine) and we have no university domain as such, we use ukr.net domain for all the university communication though.

How do I create and academic account?

0
Corrigé

Migration script error - DROP NOT NULL versus SET NOT NULL

Stéphan Doucet il y a 8 ans mis à jour par anonymous il y a 8 ans 3

If I modify a column of a table to allow NULL, the migration script generate this :


ALTER TABLE "myTable"

ALTER "myColumn" SET NOT NULL;


Instead of :


ALTER TABLE "myTable"

ALTER "myColumn" DROP NOT NULL;

0
Écarté

Database normalization

seralalal il y a 8 ans mis à jour par anonymous il y a 8 ans 1

How i can check db. Check for normal form. Do you have templates of normal forms?

0
Terminé

Unable to access Vertableo with my account

Mayur Nayee il y a 9 ans mis à jour par anonymous il y a 8 ans 2

Hi, I had vertabelo account with mailid: mayur.17892@yahoo.com and i have laerned SQL queries course till Correlation Sub queries. Today i tried to open my account but couldn't open and it said that there is no account with my Mail id.

+1
À l'étude

Graphical representation of UNIQUE columns

Max il y a 8 ans mis à jour par Rafał Strzaliński (Senior Engineer) il y a 8 ans 1

Why isn't there a "U" on the right side next to type like there is a graphical representation for private and foreign keys? I know you can set a variable as unique but it doesn't show in the diagram.

0
Résolu

Importing New Tables Into Model Erases Existing Content

Matthew Evans il y a 8 ans mis à jour par Rafał Strzaliński (Senior Engineer) il y a 8 ans 1

I am attempting to import a number of new tables into an existing model, but when I do so (using the SQL Script Option) everything that was in the model previously is erased. Is there way to "merge" in these new tables and not have them simply overwrite what is in place?

0
Corrigé

SQL preview is not working for references

Alexander Yermachenko il y a 8 ans mis à jour il y a 8 ans 4

Actually it was working before new year and now is broken.


Steps to reproduce:

1) Add 2 tables

2) Add reference between then

3) Select reference

4) Press "SQL Preview" button.

Result:

Empty preview (no SQL code except for comments).