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

0
Завершен

Is there any option to show my Database schema in website? like embedded?

Siddhu Php 7 лет назад обновлен 7 лет назад 3
0
Не ошибка

Confirmation link doesn't work

Steve Klett 10 лет назад обновлен Molly VanderVelde 7 лет назад 3
I signed up, received the email but when I click link (or copy and paste) I receive a message:
"

Your confirmation link is not valid.

"
0
На рассмотрении

'Show More' button at bottom of blog page very slow

ConorJ 7 лет назад обновлен Adam Mościcki 7 лет назад 1

Loading more blog items via 'Show More' button at bottom of page is slow to respond - 11.63s to fetch http://www.vertabelo.com/blog/technical-articles?action=blogArticlesListActions.changeArticlesCount&componentId=1883498¤tArticlesCount=90

This doesn't look good for a website selling DB expertise!

0
Отвечен

how to create ENUM in mysql

Markemark 11 лет назад обновлен Mariusz Zakrzewski 7 лет назад 10
How can I create enumerated type.
For simplicity sake, say Male and Female

many thanks

Mark
Ответ
anonymous 11 лет назад
Just insert your desired type into "Type" input. The selector (layer) with types contains only the most common datatypes. You can change it to whatever type you want. It looks like this:



This will rise a validation error saying that the type is not supported. This is our bug (not a critical one, I think). You can turn this validation off in "Model validation settings" which you can find in the menu on the top left, just below the Vertabelo logo. This validation rule is called "Supported database type (warnings)" in "Table column" section.
0
Отвечен

reference name seems to be invalid

Obiora Nwosu 7 лет назад обновлен anonymous 7 лет назад 4
0
Завершен

Need to change to a student account

John Daroch 7 лет назад обновлен Rafał Strzaliński (Senior Engineer) 7 лет назад 1

i have signed up for a normal account and i needed to set up a student account. how do i do this as i have already done complete work on here and i dont want to lose it.

0
Исправлен

The Oracle SQL generator dont add the comments associate to the tables and columns.

Erika Valerio 7 лет назад обновлен Mariusz Zakrzewski 7 лет назад 3

A couple of days ago I used the sql generator and the comments were associated without problems. However, today I try to generate the Oracle SQL of my model and it does not add any comments to the objects. My account is free for the moment. I would appreciate your quick response and attention. Greetings.

0
Завершен

pg_dump and pg_dump all tools backup create zero size backup file from linux putty terminal

nigersultana10 7 лет назад обновлен 7 лет назад 2

I have install postgres database version 9.6 , 10  on OS Centos 7 64 bit. trying to taken backup with this command

-bash-4.2$ pg_dump -h localhost -Fc backupdb > /var/lib/pgsql/niger_pgbackup/nigerpg_bkp.sql.

but problem is the backup file size had zero . I have tried many time. Kindly help where i have wrong.

-bash-4.2$ pg_dump -h localhost -Fc backupdb > /var/lib/pgsql/niger_pgbackup/nig erpg_bkp.sql
-bash-4.2$ cd niger_pgbackup/
-bash-4.2$ ls -ltr
total 0
-rwxrwxrwx 1 postgres postgres 0 Oct 7 23:38 nigerpg_bkp.sql

Regards

Niger

0
Завершен

how can i sql execute queary

Yash Sharma 7 лет назад обновлен Rafał Strzaliński (Senior Engineer) 7 лет назад 1
0
Отвечен

Made a foreign key, but this relationship is not shown in SQL preview

le_univers 7 лет назад обновлен Rafał Strzaliński (Senior Engineer) 7 лет назад 1

Apology if this is too basic, but I'm really new to everything and struggling.

So I know how to make a foreign key 

: When there are 2 entities, A and B, you draw a reference from A to B and voila,

the primary keys of A are shown in the B entity boxes as foreign keys, with some names like "A_id".

But when I actually check the SQL preview of B, I don't see any such information as that this data is coming from A.

Am I missing something? How can I make a SQL code like below show up?


PRIMARY KEY (sid, cid), FOREIGN KEY (sid) REFERENCES Students

Сервис поддержки клиентов работает на платформе UserEcho