SCOTT

테이블 (4)

Untitled (EMP)

  • Key (EMP) — NUMBER(4,0) — 기본 키 — NOT NULL
  • Field (ENAME) — VARCHAR2(10)
  • Field (JOB) — VARCHAR2(9)
  • Field (MGR) — NUMBER(4,0)
  • Field (HIREDATE) — DATE
  • Field (SAL) — NUMBER(7,2)
  • Field (COMM) — NUMBER(7,2)
  • 부서번호 (DEPTNO) — NUMBER(2,0) — 외래 키 → 부서.부서번호 — NOT NULL

Untitled (SALGRADE)

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

보너스 (BOUNS)

  • Field (ENAME) — VARCHAR2(10)
  • Field (JOB) — VARCHAR2(9)
  • (SAL) — NUMBER
  • Field (COMM) — NUMBER

부서 (DEPT)

  • 부서번호 (DEPTNO) — NUMBER(2,0) — 기본 키 — NOT NULL
  • 부서명 (DNAME) — VARCHAR2(14)
  • (LOC) — VARCHAT2(13)