Hi,
I have two tables 1.user ,2.authority table which are one-to-one mapped over shared Primarykey.

Now I want to have a one(user) to many(logdetail) between existing user table and a new table logdetail.

Basically this is what I want to achieve :

logdetail will have a foreign key column which is a primary key in already existing user table, of course the cascading functionality between these two tables.

How can I do this?

Any help is greatly appreciated.

Thanks