Insa ERD

Tables (4)

dept

  • 부서번호 (dept_id) — NUMBER(4) — Primary key — NOT NULL
  • dept_name — varchar2(20)
  • mgr_id — number(6)
  • 위치번호 (loc_id) — number(2) — Foreign key → loc.위치번호 — NOT NULL

emp

  • 사원번호 (emp_id) — NUMBER(6) — Primary key — NOT NULL
  • 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

loc

  • 위치번호 (loc_id) — number(2) — Primary key — NOT NULL
  • 주소 (address) — varchar2(50)
  • city — varchar2(20)
  • zip_code — varchar2(8)

pay_grade

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