Missing Foreign Key Constraint in DB2 Script for UM_HYBRID_USER_ROLE Table

[BimsaraBodaragama]

Description

In the DB2 script for creating the UM_HYBRID_USER_ROLE table, the foreign key constraint:

FOREIGN KEY (UM_DOMAIN_ID, UM_TENANT_ID) REFERENCES UM_DOMAIN(UM_DOMAIN_ID, UM_TENANT_ID) ON DELETE CASCADE

is missing. This foreign key is present in other database scripts but not in the DB2 script, which causes inconsistency in database schema definitions across environments.

Steps to Reproduce

1. Compare the DB2 script for UM_HYBRID_USER_ROLE creation with scripts for other databases (e.g., MySQL, H2, Informix, MSSQL, MySQL Cluster, Oracle, Oracle RAC, PostgreSQL).
2. Observe that the foreign key constraint for UM_DOMAIN_ID and UM_TENANT_ID referencing the UM_DOMAIN table is absent in the DB2 script.

Version

7.0, 7.1 (Could be in previous versions as well)

Environment Details (with versions)

Database: DB2