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 -~----------~----~----~----~------~----~------~--~---
prj_coding_testing.sql
Description: Binary data
