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.

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

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.

The generated document does not support Chinese.

What is the meaning of the different user roles you have defined and finctions.

Is there an option of signing up using PayPal?

My model have been created under the Oracle 11g. So, could you please describe how I can add triggers, synonyms for a tables? Also i'm interested in how a comments could be added for a tables and columns.

Would like to say thank you for that great project! It will be great to have such an instrument. I like it simple approach to work with a team of developers.

Thank you in advance.