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