| 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 |