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 EMP_DEPT_FK Foreign_Key null LOW_PRIVS DEPARTMENTS DEPT_ID_PK NO ACTION ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 20-MAR-12 12.00.00 null null null null
2 EMP_EMAIL_NN Check "EMAIL" 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
3 EMP_EMAIL_UK Unique null null null null null ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 20-MAR-12 12.00.00 null EMP_EMAIL_UK null null
4 EMP_EMP_ID_PK Primary_Key null null null null null ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 20-MAR-12 12.00.00 null EMP_EMP_ID_PK null null
5 EMP_HIRE_DATE_NN Check "HIRE_DATE" 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
6 EMP_JOB_FK Foreign_Key null LOW_PRIVS JOBS JOB_ID_PK NO ACTION ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 20-MAR-12 12.00.00 null null null null
7 EMP_JOB_NN Check "JOB_ID" 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
8 EMP_LAST_NAME_NN Check "LAST_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
9 EMP_MANAGER_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
10 EMP_SALARY_MIN Check salary > 0 null null null null ENABLED NOT DEFERRABLE VALIDATED USER NAME null null 20-MAR-12 12.00.00 null null null null