SCOTT

Tables (5)

SCOTT (EMP)

  • Key (EMPNO) — NUMBER(4) — Primary key — NOT NULL
  • Field (ENAME) — VARCHAR2(10 BYTE)
  • Field (JOB) — VARCHAR2(9 BYTE)
  • Field (MGR) — NUMBER(4)
  • Field (HIREDATE) — DATE
  • Field (SAL) — NUMBER(7, 2)
  • Field (COMM) — NUMBER(7, 2)
  • Field (DEPTNO) — NUMBER(2)
  • Key (DEPTNO2) — NUMBER(2) — Foreign key → SCOTT.Key — NOT NULL

SCOTT (DEPT)

  • Key (DEPTNO) — NUMBER(2) — Primary key — NOT NULL
  • Field (DNAME) — VARCHAR2(14 BYTE)
  • Field (LOC) — VARCHAR2(13 BYTE)

SCOTT (SALGRADE)

  • Field (GRADE) — NUMBER
  • Field (LOSAL) — NUMBER
  • Field (HISAL) — NUMBER

SCOTT (EMP_CONST)

  • (EMPNO) — NUMBER(4) — Primary key — NOT NULL
  • Key (ENAME) — VARCHAR2(10 BYTE) — Primary key — NOT NULL
  • Field (JOB) — VARCHAR2(9 BYTE)
  • Field2 (TEL) — VARCHAR2(20 BYTE)
  • Field (HIREDATE) — DATE
  • Field (SAL) — NUMBER(7, 2)
  • Field (COMM) — NUMBER(7, 2)
  • Field (DEPTNO) — NUMBER(2)
  • Key (DEPTNO2) — NUMBER(2) — Foreign key → SCOTT.Key — NOT NULL

SCOTT (DEPT_CONST)

  • Key (DEPTNO) — NUMBER(2) — Primary key — NOT NULL
  • Field (DNAME) — VARCHAR2(14 BYTE)
  • Field (LOC) — VARCHAR2(13 BYTE)