SELECT CONSTRAINT_NAME, CONSTRAINT_TYPE ,
       R_CONSTRAINT_NAME ,SEARCH_CONDITION
FROM USER_CONSTRAINTS
WHERE TABLE_NAME='INTERVENTIONS';