Hi,
I have an assoc. table ( between two tables what a wounder... :) ) imagine the roles, users, user_roles relationship... I have a table with user_name, and user_pass (generator class=assigned, and has user_name is indentifier and uniqe stereotypes to column user_name). I have a table (roles )with role_name (generator class=assigned, and has user_name is indentifier and uniqe stereotypes). I have a table with a one-to-many relationship to both tables to the user_name and role_name property.... Every class has an Entity property... After the generation i have a table definition with (target postgres, but this is irrelevant): -- SKIP alter table USER_ROLES drop constraint USER_ROLES_user_nameC; -- SKIP alter table USER_ROLES drop constraint USER_ROLES_role_nameC; -- SKIP drop table ROLES; -- SKIP drop table USERS; -- SKIP drop table USER_ROLES; drop sequence hibernate_sequence; create table ROLES ( ROLE_NAME CHARACTER VARYING(30) not null, primary key (ROLE_NAME) ); create table USERS ( USER_NAME CHARACTER VARYING(30) not null, USER_PASS CHARACTER VARYING(30) not null, primary key (USER_NAME) ); create table USER_ROLES ( ID BIGINT not null, user_name CHARACTER VARYING(30) not null, role_name CHARACTER VARYING(30) not null, primary key (ID) ); alter table USER_ROLES add constraint USER_ROLES_user_nameC foreign key (user_name) references USERS; alter table USER_ROLES add constraint USER_ROLES_role_nameC foreign key (role_name) references ROLES; create sequence hibernate_sequence; I don't wanna have ID! As you see from the script the name of the colums was also modified, so it is good (for realm). Can I somehow eliminate the ID? (That is not created correctly to the roles and users tables...) Thanks -- Ganszky, Balázs _________________________________________________________ Reply to the post : http://galaxy.andromda.org/forum/viewtopic.php?p=3271#3271 Posting to http://forum.andromda.org/ is preferred over posting to the mailing list! ------------------------------------------------------- SF.Net email is Sponsored by the Better Software Conference & EXPO September 19-22, 2005 * San Francisco, CA * Development Lifecycle Practices Agile & Plan-Driven Development * Managing Projects & Teams * Testing & QA Security * Process Improvement & Measurement * http://www.sqe.com/bsce5sf _______________________________________________ Andromda-user mailing list Andromda-user@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/andromda-user
