<package name="general">
                        <object name="applications" table="applications"
decorator="models.applications" sequence="seq_applications">
                                <id name="application_id" type="numeric" />
                                <property name="formal_title" type="string" 
column="formal_title"
nullable="true" />
                                <property name="short_title" type="string" 
column="short_title"
nullable="true" />
                                <property name="research_type" type="string"
column="research_type" nullable="true" />
                                <property name="committee" type="string" 
column="committee"
nullable="true" />
                                <property name="summary" type="string" 
column="summary"
nullable="true" />
                                <property name="status" type="string" 
column="status"
nullable="true" />
                                <property name="submitted_on" type="date" 
column="submitted_on"
nullable="true" />
                                <property name="updated_by" type="numeric" 
column="updated_by"
nullable="true" />
                                <property name="updated_on" type="date" 
column="updated_on"
nullable="true" />
                                <manytomany name="applications_users" 
table="applications_users"
lazy="true">
                                        <link to="general.applications" 
column="application_id"/>
                                        <link to="general.users" 
column="user_id"/>
                                        <collection type="array">
                                                <order property="updated_on" 
order="desc"/>
                                        </collection>
                                </manytomany>
                                <onetomany name="fcrec_researchers">
                                        <link to="fcrec.fcrec_researchers" 
column="application_id"/>
                                        <collection type="array">
                                                <order 
property="fcrec_researcher_id" order="asc"/>
                                        </collection>
                                </onetomany>
                        </object>
                </package>

                <package name="fcrec">
                        <object name="fcrec_researchers" table="users"
decorator="models.fcrec.fcrec_researchers"
sequence="seq_fcrec_researchers">
                                <id name="fcrec_researcher_id" type="numeric" />
                                <property name="email" type="string" 
column="email"
nullable="true" />
                                <property name="password" type="string" 
column="password"
nullable="true" />
                                <property name="name_title" type="string" 
column="name_title"
nullable="true" />
                                <property name="firstname" type="string" 
column="firstname"
nullable="true" />
                                <property name="lastname" type="string" 
column="lastname"
nullable="true" />
                                <property name="employer" type="string" 
column="employer"
nullable="true" />
                                <property name="employment_status" type="string"
column="employment_status" nullable="true" />
                                <property name="department_address" 
type="string"
column="department_address" nullable="true" />
                                <property name="phone" type="string" 
column="phone"
nullable="true" />
                                <property name="qualifications" type="string"
column="qualifications" nullable="true" />
                                <property name="chief_researcher" type="numeric"
column="chief_researcher" nullable="true" />
                        </object>
                </package>
--~--~---------~--~----~------------~-------~--~----~
Before posting questions to the group please read:
http://groups.google.com/group/transfer-dev/web/how-to-ask-support-questions-on-transfer

You received this message because you are subscribed to the Google Groups 
"transfer-dev" 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/transfer-dev?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to