emp-dept
Tables (3)
Untitled
dept (부서정보)
- deptno (부서정보) — number(2) — Primary key — NOT NULL
- dname (부서명) — varchar2(14)
- loc (위치) — varchar2(13)
emp (사원정보)
- 사원번호 (empno) — number(4) — Primary key — NOT NULL
- 이름 (ename) — varchar2 (10)
- 직책 (job) — varchar2(9)
- mgr (상사번호) — number(4)
- 입사일 — date
- sal (급여) — number(7,2)
- comm (상여금) — number(7,2)
- deptno (부서정보) — number(2) — Foreign key → dept.deptno — NOT NULL
- deptno (부서정보2) — number(2) — Foreign key → dept.deptno — NOT NULL