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