emp-dept

Tables (3)

Untitled (사원정보)

  • Key (사원번호) — number(4) — Primary key — NOT NULL
  • Field (이름) — varchar2(10)
  • Key (부서번호) — number(2) — Foreign key → Untitled.Key — NOT NULL

Untitled (부서)

  • Key (부서번호) — number(2) — Primary key — NOT NULL
  • Field (부서명) — varchar2(20)

salgrade (급여등금)

  • Key (등급) — number(1) — Primary key — NOT NULL
  • Field (최소급여) — number(1000)