scott

Tables (4)

bobus

  • Field (ename) — varchar(10)
  • Field (job) — vachar(10)
  • Field (sal) — number
  • Field (comm) — number

dept

  • deptno — number(2) — Primary key — NOT NULL
  • dname — varchar2(10)
  • loc — varchar2(10)

emp

  • Key (empno) — number(2) — Primary key — NOT NULL
  • Field (ename) — varchar2(10)
  • Field (job) — varchar2(10)
  • Field (hiredate) — date
  • Field (mgr) — number(2)
  • deptno — number(2) — Foreign key → dept.deptno — NOT NULL
  • Field (sal) — number
  • Field (com) — number
  • deptno (deptno2) — number(2) — Foreign key → dept.deptno — NOT NULL

salgrade

  • Field