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