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

0
Fertiggestellt

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

Gordon Wong vor 8 Jahren aktualisiert von anonymous vor 8 Jahren 1
Antwort
anonymous vor 8 Jahren

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
Beantwortet

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

Gordon Wong vor 8 Jahren aktualisiert von anonymous vor 8 Jahren 1
Antwort
anonymous vor 8 Jahren

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
Fertiggestellt

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

Gordon Wong vor 8 Jahren aktualisiert von anonymous vor 8 Jahren 1
Antwort
anonymous vor 8 Jahren

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
Beantwortet

CodeCommit -- Does Vertabelo support CodeCommit on AWS?

fgallego123 vor 8 Jahren aktualisiert von Rafał Strzaliński (Senior Engineer) vor 8 Jahren 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 vor 8 Jahren aktualisiert von Rafał Strzaliński (Senior Engineer) vor 8 Jahren 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.


Antwort

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
Beantwortet

database

mukkaram waheed vor 8 Jahren aktualisiert von Rafał Strzaliński (Senior Engineer) vor 8 Jahren 2

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

Antwort

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
Fertiggestellt

Take over hosting of Vertabelo JOOQ integration

Aner Perez vor 9 Jahren aktualisiert von Rafał Strzaliński (Senior Engineer) vor 8 Jahren 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
Wird überprüft

Visualize Field Names that are representing Primary or Foreign Keys

Ivan Morozov vor 8 Jahren aktualisiert von anonymous vor 8 Jahren 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
Geplant

notes and description should support chinese

gao yang vor 8 Jahren aktualisiert von Adam Mościcki vor 8 Jahren 1

The generated document does not support Chinese.

Image 317

+3
Fertiggestellt

How do I generate my database doucumentation

Glory Igboanugo vor 10 Jahren aktualisiert von anonymous vor 9 Jahren 5