|
From: <len...@xs...> - 2003-07-14 14:01:54
|
Hello, I have three tables: RELATION, PERSON and COMPANY. RELATION has a normal primary key that is autogenerated by SQLObject. PERSON and COMPANY are dependent on RELATION, so there is a one-to-one relationship from RELATION to PERSON/COMPANY, and the primary key of PERSON/COMPANY is the same as the foreign key: RELATION_ID. I have not been able to model this into SQLObject. Is this possible at all? (I am using SQLObject 0.4). I think that what I am looking for is a 'do not create a primary key column but use _somecolumn_ as primary key for this table' option. Thanks for any suggestions! Lena |