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)