Your feedback is highly appreciated! Let's make Vertabelo even better.
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."
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.
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.
CodeCommit -- Does Vertabelo support CodeCommit on AWS?
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
On update constraint is not generated in SQL
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.
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.
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
Take over hosting of Vertabelo JOOQ integration
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.
Visualize Field Names that are representing Primary or Foreign Keys
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
notes and description should support chinese
The generated document does not support Chinese.
Servicio de atención al cliente por UserEcho
