Hi,
there's absolutely no need to make a foreign key part of a primary key per
definition. All you are going to need are foreign key columns on USER and
USER_INFO that point to the related objects. In other words, your table layout
could be similar to
[USER]
USR_ID (PRIMARY KEY)
USR_NAME
USR_INFO_ID (FOREIGN KEY)
[USER_INFO]
USR_INFO_ID (PRIMARY KEY)
USR_ID (FOREIGN KEY)
FIRST_NAME
I hope this helps.
Regards
Werner
________________________________
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Sent: Donnerstag, 23. März 2006 17:18
To: castor
Subject: [castor-user] How to do relation 1:1 bidirection
I've table USER and USER_INFO, their relation is 1:1. I want to make
it to bidirection, how can I do it?
[USER]
USR_ID
USR_NAME
[USER_INFO]
USR_ID (USER.FK) --if foreign key as the primary key is not support in
castor can add another primary key USER_INFO_ID.
FIRST_NAME
________________________________
无限容量雅虎相册，原图等大下载，超快速度，赶快抢注！
<https://reg.cn.yahoo.com/cnreg/cnreg_first?id=78999&.prop=photo>
