ERDTest
Tables (5)
BONUS
- ENAME — VARCHAR2(10)
- JOB — VARCHAR2(9)
- SAL — NUMBER
- COMM — NUMBER
Copy Of EMP (CopyOfEMP)
- Key — Primary key — NOT NULL
- EMPNO — NUMBER(4)
- ENAME — VARCHAR2(10)
- JOB — VARCHAR2(9)
- MGR — NUMBER(4)
- HIREDATE — DATE
- SAL — NUMBER(7,2)
- COMM — NUMBER(7,2)
- DEPTNO — NUMBER(2)
DEPT
- Key — Foreign key → EMP.Key — NOT NULL
- DEPTNO — NUMBER(2)
- DNAME — VARCHAR2(14)
- LOC — VARCHAR2(13)
EMP
- Key — Primary key — NOT NULL
- EMPNO — NUMBER(4)
- ENAME — VARCHAR2(10)
- JOB — VARCHAR2(9)
- MGR — NUMBER(4)
- HIREDATE — DATE
- SAL — NUMBER(7,2)
- COMM — NUMBER(7,2)
- DEPTNO — NUMBER(2)
SALGRADE
- GRADE — NUMBER
- LOSAL — NUMBER
- HISAL — NUMBER