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 |