Hello,

does anyone use Er-Win to project schema databases? I would to know how to create relations automatically, if it possible.

For example: I created in Er-Win two tables 'Customer' and 'Order' with a one-to-one relationship (a customer can make one order only) and the script generated is:

_______________

CREATE TABLE customer (id_cust integer, name varchar(20));

CREATE UNIQUE INDEX XPKcliente ON customer (id_cust);

CREATE TABLE order (id_order integer,id_c integer,date_order date);

CREATE UNIQUE INDEX XPKordine ON order (id_order, id_cust);

_______________

But this script it's not sufficient because i can insert two orders for the same customer in the order table.

Thanks.