User Tools

Site Tools


configuration:foreignconstraint

foreignConstraint.xml

Defines foreign key constraints in the database. Useful for databases that do not have the constraints set in the database.

Parameters

  • schema: The schema with the table containing the primary key.
  • fSchema: The schema with the table containing the foreign key.
  • table: The table with the primary key.
  • fTable: The table with the foreign key.
  • column: The primary key(s).
  • fColumn: The foreign key(s).

Example

<foreignConstraints>
    <foreignConstraint>
        <schema>financial</schema>
        <fSchema>financial</fSchema>
        <table>LOAN</table>
        <fTable>ACCOUNT</fTable>
        <column>account_id</column>
        <fColumn>account_id</fColumn>
    </foreignConstraint>
    <foreignConstraint>
        <schema>financial_1</schema>
        <fSchema>financial_2</fSchema>
        <table>table2</table>
        <fTable>fTable2</fTable>
        <column>col1_1</column>
        <column>col1_2</column>
        <fColumn>col2_1</fColumn>
        <fColumn>col2_2</fColumn>
    </foreignConstraint>
</foreignConstraints>

Page Tools