Maybe this example is not that intresting, anyway the main problem underling the sample is:
how can I reference a unique key in the referenced table instead of the primary key of the referenced table? On Fri, Feb 13, 2009 at 4:54 PM, Guido Ziliotti <[email protected]> wrote: > I would like to ask how to map the sql script attacched to this mail. > Thwe script is for MSSQL. This is the piicture -a bit strange, but not too > much. > > Entity: > > Prioject - Table prj, represnts a software pproject. > Action - A step to develop the porject. So the project is it's parent object > > But there are two kind of actions > > Coding - Table act_coding (action_id+project_id) > Testing - Table act_testing (action_id+project_id > > Now the ternary relation. Coding actions and testing actions may be related. > The relation is many to many but it has to happen inside the scope of a Common > Parent Project. > > So this is defined by the "triple" table which is composed by > > poject, coding, testing > > and project +coding must find a match in Coding Table, project + testing must > find a match in testing Table. This is a way to express the fact there is > indeed acommon project for the two actions. > By the way this is why project_id is not in The common base table Act. I had > to > move it down to enable the foreign key form triple. > > > I would like to build suche tables with Fluent Nhibernate, or at least to map > them. > > Thanks. > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Fluent NHibernate" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/fluent-nhibernate?hl=en -~----------~----~----~----~------~----~------~--~---
