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

0
Completed

I need to cancel my account. How do I do this?

Gordon Wong 8 years ago updated by anonymous 8 years ago 1
Answer
anonymous 8 years ago

You can "cancel" an account in two ways:


- cancel subscription - it means that you stop paying a monthly fee, but the team account, user accounts and documents stay in our DB. Users may log into Vertabelo, but documents are not accessible. Sometime in the future you may just purchase another subscription and everything is up and ready for use.


- close account - in case of personal account it causes deletion of user account and documents (or unsharing them if they were shared); in case of team, it deletes the team account: all users are disassembled to private accounts, documents are unshared, and user which closes account is deleted.



In either case you do this by going to "My account" (in the top bar), then "Manage account plan." You'll then see two buttons: "Cancel subscription" and "Close account."

0
Answered

How do I delete a user if they own an object?

Gordon Wong 8 years ago updated by anonymous 8 years ago 1
Answer
anonymous 8 years ago

There's no such possibility right now. We're now in the process of rethinking users management in team accounts.


I can do this for you if necessary. Please note that this topic is public - a private ticket might be better for this.

0
Completed

How do I delete a model owned by someone else if I am admin?

Gordon Wong 8 years ago updated by anonymous 8 years ago 1
Answer
anonymous 8 years ago

There's no way to delete a document that belongs to another user. A permission to manage document must be granted explicitly - by sharing the document.

0
Answered

CodeCommit -- Does Vertabelo support CodeCommit on AWS?

fgallego123 8 years ago updated by Rafał Strzaliński (Senior Engineer) 8 years ago 1

I'm an analyst at Coca-Cola deciding whether or not to use Vertabelo. I need to know if Vertabelo supports CodeCommit on AWS.


Thanks

0
Not a bug

On update constraint is not generated in SQL

Saeed Rahimi 8 years ago updated by Rafał Strzaliński (Senior Engineer) 8 years ago 2

I am testing the tool and have created two tables (Customer and Project) with one reference (1-m) from customer to project. I also have 2 constraints - one on delete and one for on update. The generated SQL statement does not have the on update constraint clause. Why? Here is the SQL generated.

-- Created by Vertabelo (http://vertabelo.com)

-- Last modification date: 2016-07-18 18:28:56.15

-- tables
-- Table: Customer
CREATE TABLE Customer (
    Cname varchar2(20)  NOT NULL,
    Rating number(2)  NULL,
    CONSTRAINT Customer_pk PRIMARY KEY (Cname)
) ;

-- Table: Project
CREATE TABLE Project (
    PNo number(5)  NOT NULL,
    Pname varchar2(15)  NULL,
    Customer_Cname varchar2(20)  NOT NULL,
    CONSTRAINT Project_pk PRIMARY KEY (PNo)
) ;

-- foreign keys
-- Reference: Project_Customer (table: Project)
ALTER TABLE Project ADD CONSTRAINT Project_Customer
    FOREIGN KEY (Customer_Cname)
    REFERENCES Customer (Cname)
    ON DELETE CASCADE;

-- End of file.


Answer

Hello,


Oracle 11g does not support ON UPDATE clause. Please see documentation on REFERENCES: https://docs.oracle.com/cd/B28359_01/server.111/b28286/clauses002.htm#CJAIHHGC

You can emulate this behaviour, tutorial: http://www.dba-oracle.com/oracle_tips_cascade_update.htm


We don't disable 'on update' select for Oracle in UI so it might be confusing...


Note: If you choose another DB engine (for example Postgres), Vertabelo will generate ON UPDATE clause.



0
Answered

database

mukkaram waheed 8 years ago updated by Rafał Strzaliński (Senior Engineer) 8 years ago 2

i can add my database to your site for creating relationship in our database

Answer

Hello,


You can import an existing database into Vertabelo with help of our Reverse Engineering tool. An article about it: http://www.vertabelo.com/blog/documentation/reverse-engineering


You can also import an sql file when creating new model, screenshot:



I hope this helps

0
Completed

Take over hosting of Vertabelo JOOQ integration

Aner Perez 9 years ago updated by Rafał Strzaliński (Senior Engineer) 8 years ago 7

The recent schema changes to the Vertabelo model XML cause the jOOQ code generator to fail to detect primary keys on tables in the model. Furthermore, jOOQ issue #5113 was created to remove the jOOQ-Vertabelo integration from jOOQ in the upcoming version 3.8.


It would be highly beneficial if Vertabelo could take over the maintenance of this plugin in their own repository as suggested in the GitHub issue. As it currently stands the generated code is missing update functionality because of the inability to detect primary keys.

0
Under review

Visualize Field Names that are representing Primary or Foreign Keys

Ivan Morozov 8 years ago updated by anonymous 8 years ago 2

Hi,

we are planning to print our database shema as a poster in our office. However, it would be a really nice feature to explicitly see the field names that are representing the primary or foreign keys in the table. For example above or under the line (which is connection the particular tables).


Is that possible somehow?


Ivan

0
Planned

notes and description should support chinese

gao yang 8 years ago updated by Adam Mościcki 8 years ago 1

The generated document does not support Chinese.

Image 317

+3
Completed

How do I generate my database doucumentation

Glory Igboanugo 10 years ago updated by anonymous 9 years ago 5