CONSTRAINT_NAME CONSTRAINT_TYPE SEARCH_CONDITION R_OWNER R_TABLE_NAME R_CONSTRAINT_NAME DELETE_RULE STATUS DEFERRABLE VALIDATED GENERATED BAD RELY LAST_CHANGE INDEX_OWNER INDEX_NAME INVALID VIEW_RELATED
1 DEPT_ID_PK Primary_Key null null null null null ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 20-MAR-12 12.00.00 null DEPT_ID_PK null null
2 DEPT_LOC_FK Foreign_Key null LOW_PRIVS LOCATIONS LOC_ID_PK NO ACTION ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 20-MAR-12 12.00.00 null null null null
3 DEPT_MGR_FK Foreign_Key null LOW_PRIVS EMPLOYEES EMP_EMP_ID_PK NO ACTION ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 20-MAR-12 12.00.00 null null null null
4 DEPT_NAME_NN Check "DEPARTMENT_NAME" IS NOT NULL null null null null ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 20-MAR-12 12.00.00 null null null null