SCOTT

Tables (3)

Untitled (EMP)

  • Key (EMPNO) — NUMBER(4, 0) — Primary key — NOT NULL
  • Field (ENAME) — VARCHAR2(10)
  • Field2 (JOB) — VARCHAR2(9)
  • Field (MGR) — NUMBER(4,0)
  • Field (HIREDATE) — DATE
  • SAL — NUMBER(7, 2)
  • 추가수당 (COMM) — NUMBER(7, 2)
  • 부서번호 (DEPTNO) — NUMBER(2,0) — Foreign key → Untitled.부서번호 — NOT NULL

Untitled (DEPT)

  • 부서번호 (DEPTNO) — NUMBER(2,0) — Primary key — NOT NULL
  • 부서이름 (DNAME) — VARCHAR2(14)
  • 지역 (LOC) — VARCHAR2(13)

Untitled (SALGRADE)

  • 등급 (GRADE) — NUMBER
  • 최소급여 (LOSAL) — NUMBER
  • 최대급여 (HISAL) — NUMBER