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)