InsaERD

Tables (4)

dept

  • 부서번호 (dept_id) — number(4) — Primary key — NOT NULL
  • dept_name — varchar2(20)
  • mgr_id — number(6)

emp

  • emp_id — number(6)
  • emp_name — varchar2(15)
  • email — varchar2(15)
  • gender — varchar2(1)
  • birthdate — date
  • phone — varchar2(15)
  • hiredate — date
  • position — varchar2(10)
  • salary — number(4)
  • comm — number(2,2)
  • mgr_id — number(6)
  • 부서번호 (dept_id) — number(4) — Foreign key → dept.부서번호 — NOT NULL
  • 부서번호 (dept_id2) — number(4) — Foreign key → dept.부서번호 — NOT NULL

loc

  • loc_id — number(2)
  • address — varchar2(50)
  • city — varchar2(20)
  • zip_code — varchar2(8)

pay_grade

  • pay_level — char(3)
  • low_pay — number(4)
  • high_pay — number(4)