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