Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- <table name="company">
- <column name="id" type="integer" required="true" primaryKey="true" autoIncrement="true"/>
- <column name="name" type="varchar" size="255" required="true"/>
- [...]
- </table>
- <table name="verticalcain_company" isCrossRef="true">
- <column name="company_id" type="integer" primaryKey="true"/>
- <column name="verticalchainsubelement_id" type="integer" primaryKey="true"/>
- <foreign-key foreignTable="company" phpName="CompanyElement">
- <reference local="company_id" foreign="id" />
- </foreign-key>
- <foreign-key foreignTable="verticalchainsubelement" phpName="SubVerticalChainElement">
- <reference local="verticalchainsubelement_id" foreign="id" />
- </foreign-key>
- </table>
- <table name="verticalchain">
- <column name="id" type="integer" required="true" primaryKey="true" autoIncrement="true"/>
- <column name="name" type="varchar" size="128"/>
- <column name="sequence" type="integer"/>
- </table>
- <table name="verticalchainsubelement">
- <column name="id" type="integer" required="true" primaryKey="true" autoIncrement="true"/>
- <column name="name" type="varchar" size="128"/>
- <column name="verticalChain_id" type="integer"/>
- <foreign-key foreignTable="verticalchain" phpName="PartoOf">
- <reference local="verticalChain_id" foreign="id"/>
- </foreign-key>
- </table>
- $vc_sub = VerticalchainsubelementQuery::create()->findByName("Holding");
- $vc = VerticalcainCompanyQuery::create()->filterBySubVerticalChainElement($vc_sub)->find();
- $comp = CompanyQuery::create()->filterByVerticalcainCompany($vc)->find();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement