2022-05-02 WS

Tables (3)

DEPT (Untitled3)

  • DEPTNO (부서코드) — CHAR(2) — Primary key — NOT NULL
  • DEPTNAME (부서명) — VARCHARAR(20)
  • DEPTLOC (부서위치) — VARCHAR(20)
  • Field
  • EMPNO (아이디) — CHAR(4) — Foreign key → EMP.EMPNO — NOT NULL

EMP (Untitled)

  • EMPNO (아이디) — CHAR(4) — Primary key — NOT NULL
  • TITLENO (직급) — CHAR(2)
  • DEPTNO (부서) — CHAR(2)
  • EMPNAME (이름) — VARCHAR(10)
  • MANAGER (관리자) — CHAR(4)
  • SALARY (연봉) — INT(5)
  • HDATE (입사일) — DATE
  • Field

TITLE (Untitled2)

  • TITLENO (코드) — VARCHAR(2) — Primary key — NOT NULL
  • TITLENAME (직급명) — VARCHAR(20)
  • Field
  • EMPNO (아이디) — CHAR(4) — Foreign key → EMP.EMPNO — NOT NULL