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