SCOTT

테이블 (4)

EMP

  • Key (EMPNO) — NUMBER(4) — 기본 키 — NOT NULL
  • Key (ENAME) — VARCHAR2(20) — 외래 키 → 보너스.Key — NOT NULL
  • Field (JOB) — VARCHAR2(9)
  • Field (MGR) — NUMBER(4)
  • Field (HIREDATE) — DATE
  • Field (SAL) — NUMBER(7,2)
  • Field (COMM) — NUMBER(7,2)
  • Key (DEPTNO) — NUMBER(2,0) — 외래 키 → Untitled.Key — NOT NULL

Untitled (DEPT)

  • Key (DEPTNO) — NUMBER(2,0) — 기본 키 — NOT NULL
  • Field (DNAME) — VARCHAR2(14)
  • Field (LOC) — VARCHAR2(13)

Untitled (SALGRADE)

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

보너스 (BONUS)

  • Key (ENAME) — VARCHAR2(20) — 기본 키 — NOT NULL
  • (JOB) — VARCHAR2(20)
  • (SAL) — NUMBER(5)
  • Field (COMM) — NUMBER(5)