User Tools

Site Tools

Sidebar

  1. Overview
  2. Applications
  3. Quick start
  4. Datasets
  5. Patterns
  6. Pattern development
  7. Algorithms
  8. Configuration
  9. Best practice
  10. FAQ
  11. Tricks
  12. Process
  13. Contact
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